ebs二次開發7
CREATE OR REPLACE PACKAGE APPS.cux_wip_inte_pkg
AS
PROCEDURE ins_wcti (
p_transaction_id NUMBER DEFAULT NULL,
p_last_updated_by NUMBER DEFAULT NULL,
p_last_updated_by_name VARCHAR2 DEFAULT NULL,
p_created_by NUMBER DEFAULT NULL,
p_created_by_name VARCHAR2 DEFAULT NULL,
p_last_update_login NUMBER DEFAULT NULL,
p_request_id NUMBER DEFAULT NULL,
p_program_application_id NUMBER DEFAULT NULL,
p_program_id NUMBER DEFAULT NULL,
p_program_update_date DATE DEFAULT NULL,
p_group_id NUMBER DEFAULT NULL,
p_source_code VARCHAR2 DEFAULT NULL,
p_source_line_id NUMBER DEFAULT NULL,
p_process_phase NUMBER,
p_process_status NUMBER,
p_transaction_type NUMBER DEFAULT NULL,
p_organization_id NUMBER DEFAULT NULL,
p_organization_code VARCHAR2 DEFAULT NULL,
p_wip_entity_id NUMBER DEFAULT NULL,
p_wip_entity_name VARCHAR2 DEFAULT NULL,
p_entity_type NUMBER DEFAULT NULL,
p_line_id NUMBER DEFAULT NULL,
p_line_code VARCHAR2 DEFAULT NULL,
p_primary_item_id NUMBER DEFAULT NULL,
p_repetitive_schedule_id NUMBER DEFAULT NULL,
p_transaction_date DATE,
p_acct_period_id NUMBER DEFAULT NULL,
p_operation_seq_num NUMBER DEFAULT NULL,
p_resource_seq_num NUMBER DEFAULT NULL,
p_department_id NUMBER DEFAULT NULL,
p_department_code VARCHAR2 DEFAULT NULL,
p_employee_id NUMBER DEFAULT NULL,
p_employee_num VARCHAR2 DEFAULT NULL,
p_resource_id NUMBER DEFAULT NULL,
p_resource_code VARCHAR2 DEFAULT NULL,
p_resource_type NUMBER DEFAULT NULL,
p_usage_rate_or_amount NUMBER DEFAULT NULL,
p_basis_type NUMBER DEFAULT NULL,
p_autocharge_type NUMBER DEFAULT NULL,
p_standard_rate_flag NUMBER DEFAULT NULL,
p_transaction_quantity NUMBER DEFAULT NULL,
p_transaction_uom VARCHAR2 DEFAULT NULL,
p_primary_quantity NUMBER DEFAULT NULL,
p_primary_uom VARCHAR2 DEFAULT NULL,
p_primary_uom_class VARCHAR2 DEFAULT NULL,
p_actual_resource_rate NUMBER DEFAULT NULL,
p_currency_code VARCHAR2 DEFAULT NULL,
p_currency_conversion_date DATE DEFAULT NULL,
p_currency_conversion_type VARCHAR2 DEFAULT NULL,
p_currency_conversion_rate NUMBER DEFAULT NULL,
p_currency_actual_resource_rat NUMBER DEFAULT NULL,
p_activity_id NUMBER DEFAULT NULL,
p_activity_name VARCHAR2 DEFAULT NULL,
p_reason_id NUMBER DEFAULT NULL,
p_reason_name VARCHAR2 DEFAULT NULL,
p_reference VARCHAR2 DEFAULT NULL,
p_move_transaction_id NUMBER DEFAULT NULL,
p_completion_transaction_id NUMBER DEFAULT NULL,
p_rcv_transaction_id NUMBER DEFAULT NULL,
p_po_header_id NUMBER DEFAULT NULL,
p_po_line_id NUMBER DEFAULT NULL,
p_receiving_account_id NUMBER DEFAULT NULL,
p_project_id NUMBER DEFAULT NULL,
p_task_id NUMBER DEFAULT NULL,
p_attribute_category VARCHAR2 DEFAULT NULL,
p_attribute1 VARCHAR2 DEFAULT NULL,
p_attribute2 VARCHAR2 DEFAULT NULL,
p_attribute3 VARCHAR2 DEFAULT NULL,
p_attribute4 VARCHAR2 DEFAULT NULL,
p_attribute5 VARCHAR2 DEFAULT NULL,
p_attribute6 VARCHAR2 DEFAULT NULL,
p_attribute7 VARCHAR2 DEFAULT NULL,
p_attribute8 VARCHAR2 DEFAULT NULL,
p_attribute9 VARCHAR2 DEFAULT NULL,
p_attribute10 VARCHAR2 DEFAULT NULL,
p_attribute11 VARCHAR2 DEFAULT NULL,
p_attribute12 VARCHAR2 DEFAULT NULL,
p_attribute13 VARCHAR2 DEFAULT NULL,
p_attribute14 VARCHAR2 DEFAULT NULL,
p_attribute15 VARCHAR2 DEFAULT NULL,
p_phantom_flag NUMBER DEFAULT NULL,
p_xml_document_id VARCHAR2 DEFAULT NULL,
p_charge_department_id NUMBER DEFAULT NULL,
p_instance_id NUMBER DEFAULT NULL
);
END;
/
CREATE OR REPLACE PACKAGE BODY APPS.cux_wip_inte_pkg
AS
PROCEDURE ins_wcti (
p_transaction_id NUMBER DEFAULT NULL,
p_last_updated_by NUMBER DEFAULT NULL,
p_last_updated_by_name VARCHAR2 DEFAULT NULL,
p_created_by NUMBER DEFAULT NULL,
p_created_by_name VARCHAR2 DEFAULT NULL,
p_last_update_login NUMBER DEFAULT NULL,
p_request_id NUMBER DEFAULT NULL,
p_program_application_id NUMBER DEFAULT NULL,
p_program_id NUMBER DEFAULT NULL,
p_program_update_date DATE DEFAULT NULL,
p_group_id NUMBER DEFAULT NULL,
p_source_code VARCHAR2 DEFAULT NULL,
p_source_line_id NUMBER DEFAULT NULL,
p_process_phase NUMBER,
p_process_status NUMBER,
p_transaction_type NUMBER DEFAULT NULL,
p_organization_id NUMBER DEFAULT NULL,
p_organization_code VARCHAR2 DEFAULT NULL,
p_wip_entity_id NUMBER DEFAULT NULL,
p_wip_entity_name VARCHAR2 DEFAULT NULL,
p_entity_type NUMBER DEFAULT NULL,
p_line_id NUMBER DEFAULT NULL,
p_line_code VARCHAR2 DEFAULT NULL,
p_primary_item_id NUMBER DEFAULT NULL,
p_repetitive_schedule_id NUMBER DEFAULT NULL,
p_transaction_date DATE,
p_acct_period_id NUMBER DEFAULT NULL,
p_operation_seq_num NUMBER DEFAULT NULL,
p_resource_seq_num NUMBER DEFAULT NULL,
p_department_id NUMBER DEFAULT NULL,
p_department_code VARCHAR2 DEFAULT NULL,
p_employee_id NUMBER DEFAULT NULL,
p_employee_num VARCHAR2 DEFAULT NULL,
p_resource_id NUMBER DEFAULT NULL,
p_resource_code VARCHAR2 DEFAULT NULL,
p_resource_type NUMBER DEFAULT NULL,
p_usage_rate_or_amount NUMBER DEFAULT NULL,
p_basis_type NUMBER DEFAULT NULL,
p_autocharge_type NUMBER DEFAULT NULL,
p_standard_rate_flag NUMBER DEFAULT NULL,
p_transaction_quantity NUMBER DEFAULT NULL,
p_transaction_uom VARCHAR2 DEFAULT NULL,
p_primary_quantity NUMBER DEFAULT NULL,
p_primary_uom VARCHAR2 DEFAULT NULL,
p_primary_uom_class VARCHAR2 DEFAULT NULL,
p_actual_resource_rate NUMBER DEFAULT NULL,
p_currency_code VARCHAR2 DEFAULT NULL,
p_currency_conversion_date DATE DEFAULT NULL,
p_currency_conversion_type VARCHAR2 DEFAULT NULL,
p_currency_conversion_rate NUMBER DEFAULT NULL,
p_currency_actual_resource_rat NUMBER DEFAULT NULL,
p_activity_id NUMBER DEFAULT NULL,
p_activity_name VARCHAR2 DEFAULT NULL,
p_reason_id NUMBER DEFAULT NULL,
p_reason_name VARCHAR2 DEFAULT NULL,
p_reference VARCHAR2 DEFAULT NULL,
p_move_transaction_id NUMBER DEFAULT NULL,
p_completion_transaction_id NUMBER DEFAULT NULL,
p_rcv_transaction_id NUMBER DEFAULT NULL,
p_po_header_id NUMBER DEFAULT NULL,
p_po_line_id NUMBER DEFAULT NULL,
p_receiving_account_id NUMBER DEFAULT NULL,
p_project_id NUMBER DEFAULT NULL,
p_task_id NUMBER DEFAULT NULL,
p_attribute_category VARCHAR2 DEFAULT NULL,
p_attribute1 VARCHAR2 DEFAULT NULL,
p_attribute2 VARCHAR2 DEFAULT NULL,
p_attribute3 VARCHAR2 DEFAULT NULL,
p_attribute4 VARCHAR2 DEFAULT NULL,
p_attribute5 VARCHAR2 DEFAULT NULL,
p_attribute6 VARCHAR2 DEFAULT NULL,
p_attribute7 VARCHAR2 DEFAULT NULL,
p_attribute8 VARCHAR2 DEFAULT NULL,
p_attribute9 VARCHAR2 DEFAULT NULL,
p_attribute10 VARCHAR2 DEFAULT NULL,
p_attribute11 VARCHAR2 DEFAULT NULL,
p_attribute12 VARCHAR2 DEFAULT NULL,
p_attribute13 VARCHAR2 DEFAULT NULL,
p_attribute14 VARCHAR2 DEFAULT NULL,
p_attribute15 VARCHAR2 DEFAULT NULL,
p_phantom_flag NUMBER DEFAULT NULL,
p_xml_document_id VARCHAR2 DEFAULT NULL,
p_charge_department_id NUMBER DEFAULT NULL,
p_instance_id NUMBER DEFAULT NULL
)
IS
BEGIN
INSERT INTO wip_cost_txn_interface
(transaction_id, last_update_date, last_updated_by,
last_updated_by_name, creation_date, created_by,
created_by_name, last_update_login, request_id,
program_application_id, program_id,
program_update_date, GROUP_ID, source_code,
source_line_id, process_phase, process_status,
transaction_type, organization_id,
organization_code, wip_entity_id, wip_entity_name,
entity_type, line_id, line_code, primary_item_id,
repetitive_schedule_id, transaction_date,
acct_period_id, operation_seq_num,
resource_seq_num, department_id, department_code,
employee_id, employee_num, resource_id,
resource_code, resource_type, usage_rate_or_amount,
basis_type, autocharge_type, standard_rate_flag,
transaction_quantity, transaction_uom,
primary_quantity, primary_uom, primary_uom_class,
actual_resource_rate, currency_code,
currency_conversion_date, currency_conversion_type,
currency_conversion_rate,
currency_actual_resource_rate, activity_id,
activity_name, reason_id, reason_name, REFERENCE,
move_transaction_id, completion_transaction_id,
rcv_transaction_id, po_header_id, po_line_id,
receiving_account_id, project_id, task_id,
attribute_category, attribute1, attribute2,
attribute3, attribute4, attribute5, attribute6,
attribute7, attribute8, attribute9, attribute10,
attribute11, attribute12, attribute13,
attribute14, attribute15, phantom_flag,
xml_document_id, charge_department_id, instance_id
)
VALUES (p_transaction_id, SYSDATE, p_last_updated_by,
p_last_updated_by_name, SYSDATE, p_created_by,
p_created_by_name, p_last_update_login, p_request_id,
p_program_application_id, p_program_id,
p_program_update_date, p_group_id, p_source_code,
p_source_line_id, p_process_phase, p_process_status,
p_transaction_type, p_organization_id,
p_organization_code, p_wip_entity_id, p_wip_entity_name,
p_entity_type, p_line_id, p_line_code, p_primary_item_id,
p_repetitive_schedule_id, p_transaction_date,
p_acct_period_id, p_operation_seq_num,
p_resource_seq_num, p_department_id, p_department_code,
p_employee_id, p_employee_num, p_resource_id,
p_resource_code, p_resource_type, p_usage_rate_or_amount,
p_basis_type, p_autocharge_type, p_standard_rate_flag,
p_transaction_quantity, p_transaction_uom,
p_primary_quantity, p_primary_uom, p_primary_uom_class,
p_actual_resource_rate, p_currency_code,
p_currency_conversion_date, p_currency_conversion_type,
p_currency_conversion_rate,
p_currency_actual_resource_rat, p_activity_id,
p_activity_name, p_reason_id, p_reason_name, p_reference,
p_move_transaction_id, p_completion_transaction_id,
p_rcv_transaction_id, p_po_header_id, p_po_line_id,
p_receiving_account_id, p_project_id, p_task_id,
p_attribute_category, p_attribute1, p_attribute2,
p_attribute3, p_attribute4, p_attribute5, p_attribute6,
p_attribute7, p_attribute8, p_attribute9, p_attribute10,
p_attribute11, p_attribute12, p_attribute13,
p_attribute14, p_attribute15, p_phantom_flag,
p_xml_document_id, p_charge_department_id, p_instance_id
);
END;
END;
/
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/11536986/viewspace-620208/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- ebs二次開發1
- ebs二次開發2
- ebs二次開發3
- ebs二次開發4
- ebs二次開發5
- ebs二次開發6
- EBS開發筆記-1筆記
- EBS開發環境搭建開發環境
- EBS開發筆記-2筆記
- 【EBS】主機併發程式開發
- EBS FORM PLL 開發入門ORM
- Application(EBS)開發整理(轉)APP
- 網站修改二次開發，網站二次開發流程網站
- Dresdon二次開發
- ThinkS二次開發
- SOLIDWORKS二次開發Solid
- NX二次開發-使用NXOPEN C++嚮導模板做二次開發C++
- Oracle EBS 基於Host併發程式的開發Oracle
- UG二次開發筆記筆記
- SOLIDWORKS二次開發形式Solid
- kubernetes 二次開發
- 基於 solox 二次開發
- 小說APP原始碼開發，支援二次開發功能APP原始碼
- openfire 3.8.2 原始碼部署 /開發配置 / 二次開發原始碼
- 一個開源的OJ二次開發
- Scratch3 二次開發系列
- Voyager 的使用及二次開發
- SOLIDWORKS二次開發介紹Solid
- 基於ecshop的二次開發
- 團隊專案：二次開發
- ECshop 二次開發模板教程1
- ECshop 二次開發模板教程2
- ECshop 二次開發模板教程3
- ECshop 二次開發模板教程4
- ecshop 二次開發,原始碼分析原始碼
- C++大作業二次開發C++
- EBS之JTF_Grid 開發總結
- BIMFACE二次開發SDK 開源C#版C#