ebs二次開發5
CREATE OR REPLACE PACKAGE APPS.cux_mtl_tran_inte_pkg AS
PROCEDURE ins_lot_iface(p_transaction_interface_id IN NUMBER,
p_source_code IN VARCHAR2 DEFAULT NULL,
p_source_line_id IN NUMBER DEFAULT NULL,
p_last_update_date IN DATE,
p_last_updated_by IN NUMBER,
p_creation_date IN DATE,
p_created_by IN NUMBER,
p_last_update_login IN NUMBER DEFAULT NULL,
p_request_id IN NUMBER DEFAULT NULL,
p_program_application_id IN NUMBER DEFAULT NULL,
p_program_id IN NUMBER DEFAULT NULL,
p_program_update_date IN DATE DEFAULT NULL,
p_lot_number IN VARCHAR2,
p_lot_expiration_date IN DATE DEFAULT NULL,
p_transaction_quantity IN NUMBER,
p_primary_quantity IN NUMBER DEFAULT NULL,
p_serial_transaction_temp_id IN NUMBER DEFAULT NULL,
p_error_code IN VARCHAR2 DEFAULT NULL,
p_process_flag IN VARCHAR2 DEFAULT NULL,
p_description IN VARCHAR2 DEFAULT NULL,
p_vendor_name IN VARCHAR2 DEFAULT NULL,
p_supplier_lot_number IN VARCHAR2 DEFAULT NULL,
p_origination_date IN DATE DEFAULT NULL,
p_date_code IN VARCHAR2 DEFAULT NULL,
p_grade_code IN VARCHAR2 DEFAULT NULL,
p_change_date IN DATE DEFAULT NULL,
p_maturity_date IN DATE DEFAULT NULL,
p_status_id IN NUMBER DEFAULT NULL,
p_retest_date IN DATE DEFAULT NULL,
p_age IN NUMBER DEFAULT NULL,
p_item_size IN NUMBER DEFAULT NULL,
p_color IN VARCHAR2 DEFAULT NULL,
p_volume IN NUMBER DEFAULT NULL,
p_volume_uom IN VARCHAR2 DEFAULT NULL,
p_place_of_origin IN VARCHAR2 DEFAULT NULL,
p_best_by_date IN DATE DEFAULT NULL,
p_length IN NUMBER DEFAULT NULL,
p_length_uom IN VARCHAR2 DEFAULT NULL,
p_recycled_content IN NUMBER DEFAULT NULL,
p_thickness IN NUMBER DEFAULT NULL,
p_thickness_uom IN VARCHAR2 DEFAULT NULL,
p_width IN NUMBER DEFAULT NULL,
p_width_uom IN VARCHAR2 DEFAULT NULL,
p_curl_wrinkle_fold IN VARCHAR2 DEFAULT NULL,
p_lot_attribute_category IN VARCHAR2 DEFAULT NULL,
p_c_attribute1 IN VARCHAR2 DEFAULT NULL,
p_c_attribute2 IN VARCHAR2 DEFAULT NULL,
p_c_attribute3 IN VARCHAR2 DEFAULT NULL,
p_c_attribute4 IN VARCHAR2 DEFAULT NULL,
p_c_attribute5 IN VARCHAR2 DEFAULT NULL,
p_c_attribute6 IN VARCHAR2 DEFAULT NULL,
p_c_attribute7 IN VARCHAR2 DEFAULT NULL,
p_c_attribute8 IN VARCHAR2 DEFAULT NULL,
p_c_attribute9 IN VARCHAR2 DEFAULT NULL,
p_c_attribute10 IN VARCHAR2 DEFAULT NULL,
p_c_attribute11 IN VARCHAR2 DEFAULT NULL,
p_c_attribute12 IN VARCHAR2 DEFAULT NULL,
p_c_attribute13 IN VARCHAR2 DEFAULT NULL,
p_c_attribute14 IN VARCHAR2 DEFAULT NULL,
p_c_attribute15 IN VARCHAR2 DEFAULT NULL,
p_c_attribute16 IN VARCHAR2 DEFAULT NULL,
p_c_attribute17 IN VARCHAR2 DEFAULT NULL,
p_c_attribute18 IN VARCHAR2 DEFAULT NULL,
p_c_attribute19 IN VARCHAR2 DEFAULT NULL,
p_c_attribute20 IN VARCHAR2 DEFAULT NULL,
p_d_attribute1 IN DATE DEFAULT NULL,
p_d_attribute2 IN DATE DEFAULT NULL,
p_d_attribute3 IN DATE DEFAULT NULL,
p_d_attribute4 IN DATE DEFAULT NULL,
p_d_attribute5 IN DATE DEFAULT NULL,
p_d_attribute6 IN DATE DEFAULT NULL,
p_d_attribute7 IN DATE DEFAULT NULL,
p_d_attribute8 IN DATE DEFAULT NULL,
p_d_attribute9 IN DATE DEFAULT NULL,
p_d_attribute10 IN DATE DEFAULT NULL,
p_n_attribute1 IN NUMBER DEFAULT NULL,
p_n_attribute2 IN NUMBER DEFAULT NULL,
p_n_attribute3 IN NUMBER DEFAULT NULL,
p_n_attribute4 IN NUMBER DEFAULT NULL,
p_n_attribute5 IN NUMBER DEFAULT NULL,
p_n_attribute6 IN NUMBER DEFAULT NULL,
p_n_attribute7 IN NUMBER DEFAULT NULL,
p_n_attribute8 IN NUMBER DEFAULT NULL,
p_n_attribute9 IN NUMBER DEFAULT NULL,
p_n_attribute10 IN NUMBER DEFAULT NULL,
p_vendor_id IN NUMBER DEFAULT NULL,
p_territory_code IN VARCHAR2 DEFAULT NULL,
p_product_code IN VARCHAR2 DEFAULT NULL,
p_product_transaction_id IN NUMBER DEFAULT NULL,
p_secondary_tran_qty IN NUMBER DEFAULT NULL,
p_sublot_num IN VARCHAR2 DEFAULT NULL,
p_reason_code IN VARCHAR2 DEFAULT NULL,
p_attribute_category IN VARCHAR2 DEFAULT NULL,
p_attribute1 IN VARCHAR2 DEFAULT NULL,
p_attribute2 IN VARCHAR2 DEFAULT NULL,
p_attribute3 IN VARCHAR2 DEFAULT NULL,
p_attribute4 IN VARCHAR2 DEFAULT NULL,
p_attribute5 IN VARCHAR2 DEFAULT NULL,
p_attribute6 IN VARCHAR2 DEFAULT NULL,
p_attribute7 IN VARCHAR2 DEFAULT NULL,
p_attribute8 IN VARCHAR2 DEFAULT NULL,
p_attribute9 IN VARCHAR2 DEFAULT NULL,
p_attribute10 IN VARCHAR2 DEFAULT NULL,
p_attribute11 IN VARCHAR2 DEFAULT NULL,
p_attribute12 IN VARCHAR2 DEFAULT NULL,
p_attribute13 IN VARCHAR2 DEFAULT NULL,
p_attribute14 IN VARCHAR2 DEFAULT NULL,
p_attribute15 IN VARCHAR2 DEFAULT NULL);
PROCEDURE ins_mtl_trans_inte(p_transaction_interface_id NUMBER DEFAULT NULL,
p_transaction_header_id NUMBER DEFAULT NULL,
p_source_code VARCHAR2,
p_source_line_id NUMBER,
p_source_header_id NUMBER,
p_process_flag NUMBER,
p_validation_required NUMBER DEFAULT NULL,
p_transaction_mode NUMBER,
p_lock_flag NUMBER DEFAULT NULL,
p_last_updated_by NUMBER,
p_created_by NUMBER,
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_inventory_item_id NUMBER DEFAULT NULL,
p_item_segment1 VARCHAR2 DEFAULT NULL,
p_item_segment2 VARCHAR2 DEFAULT NULL,
p_item_segment3 VARCHAR2 DEFAULT NULL,
p_item_segment4 VARCHAR2 DEFAULT NULL,
p_item_segment5 VARCHAR2 DEFAULT NULL,
p_item_segment6 VARCHAR2 DEFAULT NULL,
p_item_segment7 VARCHAR2 DEFAULT NULL,
p_item_segment8 VARCHAR2 DEFAULT NULL,
p_item_segment9 VARCHAR2 DEFAULT NULL,
p_item_segment10 VARCHAR2 DEFAULT NULL,
p_item_segment11 VARCHAR2 DEFAULT NULL,
p_item_segment12 VARCHAR2 DEFAULT NULL,
p_item_segment13 VARCHAR2 DEFAULT NULL,
p_item_segment14 VARCHAR2 DEFAULT NULL,
p_item_segment15 VARCHAR2 DEFAULT NULL,
p_item_segment16 VARCHAR2 DEFAULT NULL,
p_item_segment17 VARCHAR2 DEFAULT NULL,
p_item_segment18 VARCHAR2 DEFAULT NULL,
p_item_segment19 VARCHAR2 DEFAULT NULL,
p_item_segment20 VARCHAR2 DEFAULT NULL,
p_revision VARCHAR2 DEFAULT NULL,
p_organization_id NUMBER,
p_transaction_quantity NUMBER,
p_primary_quantity NUMBER DEFAULT NULL,
p_transaction_uom VARCHAR2,
p_transaction_date DATE,
p_acct_period_id NUMBER DEFAULT NULL,
p_subinventory_code VARCHAR2 DEFAULT NULL,
p_locator_id NUMBER DEFAULT NULL,
p_loc_segment1 VARCHAR2 DEFAULT NULL,
p_loc_segment2 VARCHAR2 DEFAULT NULL,
p_loc_segment3 VARCHAR2 DEFAULT NULL,
p_loc_segment4 VARCHAR2 DEFAULT NULL,
p_loc_segment5 VARCHAR2 DEFAULT NULL,
p_loc_segment6 VARCHAR2 DEFAULT NULL,
p_loc_segment7 VARCHAR2 DEFAULT NULL,
p_loc_segment8 VARCHAR2 DEFAULT NULL,
p_loc_segment9 VARCHAR2 DEFAULT NULL,
p_loc_segment10 VARCHAR2 DEFAULT NULL,
p_loc_segment11 VARCHAR2 DEFAULT NULL,
p_loc_segment12 VARCHAR2 DEFAULT NULL,
p_loc_segment13 VARCHAR2 DEFAULT NULL,
p_loc_segment14 VARCHAR2 DEFAULT NULL,
p_loc_segment15 VARCHAR2 DEFAULT NULL,
p_loc_segment16 VARCHAR2 DEFAULT NULL,
p_loc_segment17 VARCHAR2 DEFAULT NULL,
p_loc_segment18 VARCHAR2 DEFAULT NULL,
p_loc_segment19 VARCHAR2 DEFAULT NULL,
p_loc_segment20 VARCHAR2 DEFAULT NULL,
p_transaction_source_id NUMBER DEFAULT NULL,
p_dsp_segment1 VARCHAR2 DEFAULT NULL,
p_dsp_segment2 VARCHAR2 DEFAULT NULL,
p_dsp_segment3 VARCHAR2 DEFAULT NULL,
p_dsp_segment4 VARCHAR2 DEFAULT NULL,
p_dsp_segment5 VARCHAR2 DEFAULT NULL,
p_dsp_segment6 VARCHAR2 DEFAULT NULL,
p_dsp_segment7 VARCHAR2 DEFAULT NULL,
p_dsp_segment8 VARCHAR2 DEFAULT NULL,
p_dsp_segment9 VARCHAR2 DEFAULT NULL,
p_dsp_segment10 VARCHAR2 DEFAULT NULL,
p_dsp_segment11 VARCHAR2 DEFAULT NULL,
p_dsp_segment12 VARCHAR2 DEFAULT NULL,
p_dsp_segment13 VARCHAR2 DEFAULT NULL,
p_dsp_segment14 VARCHAR2 DEFAULT NULL,
p_dsp_segment15 VARCHAR2 DEFAULT NULL,
p_dsp_segment16 VARCHAR2 DEFAULT NULL,
p_dsp_segment17 VARCHAR2 DEFAULT NULL,
p_dsp_segment18 VARCHAR2 DEFAULT NULL,
p_dsp_segment19 VARCHAR2 DEFAULT NULL,
p_dsp_segment20 VARCHAR2 DEFAULT NULL,
p_dsp_segment21 VARCHAR2 DEFAULT NULL,
p_dsp_segment22 VARCHAR2 DEFAULT NULL,
p_dsp_segment23 VARCHAR2 DEFAULT NULL,
p_dsp_segment24 VARCHAR2 DEFAULT NULL,
p_dsp_segment25 VARCHAR2 DEFAULT NULL,
p_dsp_segment26 VARCHAR2 DEFAULT NULL,
p_dsp_segment27 VARCHAR2 DEFAULT NULL,
p_dsp_segment28 VARCHAR2 DEFAULT NULL,
p_dsp_segment29 VARCHAR2 DEFAULT NULL,
p_dsp_segment30 VARCHAR2 DEFAULT NULL,
p_transaction_source_name VARCHAR2 DEFAULT NULL,
p_transaction_source_type_id NUMBER DEFAULT NULL,
p_transaction_action_id NUMBER DEFAULT NULL,
p_transaction_type_id NUMBER,
p_reason_id NUMBER DEFAULT NULL,
p_transaction_reference VARCHAR2 DEFAULT NULL,
p_transaction_cost NUMBER DEFAULT NULL,
p_distribution_account_id NUMBER DEFAULT NULL,
p_dst_segment1 VARCHAR2 DEFAULT NULL,
p_dst_segment2 VARCHAR2 DEFAULT NULL,
p_dst_segment3 VARCHAR2 DEFAULT NULL,
p_dst_segment4 VARCHAR2 DEFAULT NULL,
p_dst_segment5 VARCHAR2 DEFAULT NULL,
p_dst_segment6 VARCHAR2 DEFAULT NULL,
p_dst_segment7 VARCHAR2 DEFAULT NULL,
p_dst_segment8 VARCHAR2 DEFAULT NULL,
p_dst_segment9 VARCHAR2 DEFAULT NULL,
p_dst_segment10 VARCHAR2 DEFAULT NULL,
p_dst_segment11 VARCHAR2 DEFAULT NULL,
p_dst_segment12 VARCHAR2 DEFAULT NULL,
p_dst_segment13 VARCHAR2 DEFAULT NULL,
p_dst_segment14 VARCHAR2 DEFAULT NULL,
p_dst_segment15 VARCHAR2 DEFAULT NULL,
p_dst_segment16 VARCHAR2 DEFAULT NULL,
p_dst_segment17 VARCHAR2 DEFAULT NULL,
p_dst_segment18 VARCHAR2 DEFAULT NULL,
p_dst_segment19 VARCHAR2 DEFAULT NULL,
p_dst_segment20 VARCHAR2 DEFAULT NULL,
p_dst_segment21 VARCHAR2 DEFAULT NULL,
p_dst_segment22 VARCHAR2 DEFAULT NULL,
p_dst_segment23 VARCHAR2 DEFAULT NULL,
p_dst_segment24 VARCHAR2 DEFAULT NULL,
p_dst_segment25 VARCHAR2 DEFAULT NULL,
p_dst_segment26 VARCHAR2 DEFAULT NULL,
p_dst_segment27 VARCHAR2 DEFAULT NULL,
p_dst_segment28 VARCHAR2 DEFAULT NULL,
p_dst_segment29 VARCHAR2 DEFAULT NULL,
p_dst_segment30 VARCHAR2 DEFAULT NULL,
p_requisition_line_id 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_ussgl_transaction_code VARCHAR2 DEFAULT NULL,
p_wip_entity_type NUMBER DEFAULT NULL,
p_schedule_id NUMBER DEFAULT NULL,
p_employee_code VARCHAR2 DEFAULT NULL,
p_department_id NUMBER DEFAULT NULL,
p_schedule_update_code NUMBER DEFAULT NULL,
p_setup_teardown_code NUMBER DEFAULT NULL,
p_primary_switch NUMBER DEFAULT NULL,
p_mrp_code NUMBER DEFAULT NULL,
p_operation_seq_num NUMBER DEFAULT NULL,
p_repetitive_line_id NUMBER DEFAULT NULL,
p_picking_line_id NUMBER DEFAULT NULL,
p_trx_source_line_id NUMBER DEFAULT NULL,
p_trx_source_delivery_id NUMBER DEFAULT NULL,
p_demand_id NUMBER DEFAULT NULL,
p_customer_ship_id NUMBER DEFAULT NULL,
p_line_item_num NUMBER DEFAULT NULL,
p_receiving_document VARCHAR2 DEFAULT NULL,
p_rcv_transaction_id NUMBER DEFAULT NULL,
p_ship_to_location_id NUMBER DEFAULT NULL,
p_encumbrance_account NUMBER DEFAULT NULL,
p_encumbrance_amount NUMBER DEFAULT NULL,
p_vendor_lot_number VARCHAR2 DEFAULT NULL,
p_transfer_subinventory VARCHAR2 DEFAULT NULL,
p_transfer_organization NUMBER DEFAULT NULL,
p_transfer_locator NUMBER DEFAULT NULL,
p_xfer_loc_segment1 VARCHAR2 DEFAULT NULL,
p_xfer_loc_segment2 VARCHAR2 DEFAULT NULL,
p_xfer_loc_segment3 VARCHAR2 DEFAULT NULL,
p_xfer_loc_segment4 VARCHAR2 DEFAULT NULL,
p_xfer_loc_segment5 VARCHAR2 DEFAULT NULL,
p_xfer_loc_segment6 VARCHAR2 DEFAULT NULL,
p_xfer_loc_segment7 VARCHAR2 DEFAULT NULL,
p_xfer_loc_segment8 VARCHAR2 DEFAULT NULL,
p_xfer_loc_segment9 VARCHAR2 DEFAULT NULL,
p_xfer_loc_segment10 VARCHAR2 DEFAULT NULL,
p_xfer_loc_segment11 VARCHAR2 DEFAULT NULL,
p_xfer_loc_segment12 VARCHAR2 DEFAULT NULL,
p_xfer_loc_segment13 VARCHAR2 DEFAULT NULL,
p_xfer_loc_segment14 VARCHAR2 DEFAULT NULL,
p_xfer_loc_segment15 VARCHAR2 DEFAULT NULL,
p_xfer_loc_segment16 VARCHAR2 DEFAULT NULL,
p_xfer_loc_segment17 VARCHAR2 DEFAULT NULL,
p_xfer_loc_segment18 VARCHAR2 DEFAULT NULL,
p_xfer_loc_segment19 VARCHAR2 DEFAULT NULL,
p_xfer_loc_segment20 VARCHAR2 DEFAULT NULL,
p_shipment_number VARCHAR2 DEFAULT NULL,
p_transportation_cost NUMBER DEFAULT NULL,
p_transportation_account NUMBER DEFAULT NULL,
p_transfer_cost NUMBER DEFAULT NULL,
p_freight_code VARCHAR2 DEFAULT NULL,
p_containers NUMBER DEFAULT NULL,
p_waybill_airbill VARCHAR2 DEFAULT NULL,
p_expected_arrival_date DATE DEFAULT NULL,
p_new_average_cost NUMBER DEFAULT NULL,
p_value_change NUMBER DEFAULT NULL,
p_percentage_change NUMBER DEFAULT NULL,
p_demand_source_header_id NUMBER DEFAULT NULL,
p_demand_source_line VARCHAR2 DEFAULT NULL,
p_demand_source_delivery VARCHAR2 DEFAULT NULL,
p_negative_req_flag NUMBER DEFAULT NULL,
p_error_explanation VARCHAR2 DEFAULT NULL,
p_shippable_flag VARCHAR2 DEFAULT NULL,
p_error_code VARCHAR2 DEFAULT NULL,
p_required_flag VARCHAR2 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_requisition_distribution_id NUMBER DEFAULT NULL,
p_movement_id NUMBER DEFAULT NULL,
p_reservation_quantity NUMBER DEFAULT NULL,
p_shipped_quantity NUMBER DEFAULT NULL,
p_inventory_item VARCHAR2 DEFAULT NULL,
p_locator_name VARCHAR2 DEFAULT NULL,
p_task_id NUMBER DEFAULT NULL,
p_to_task_id NUMBER DEFAULT NULL,
p_source_task_id NUMBER DEFAULT NULL,
p_project_id NUMBER DEFAULT NULL,
p_to_project_id NUMBER DEFAULT NULL,
p_source_project_id NUMBER DEFAULT NULL,
p_pa_expenditure_org_id NUMBER DEFAULT NULL,
p_expenditure_type VARCHAR2 DEFAULT NULL,
p_final_completion_flag VARCHAR2 DEFAULT NULL,
p_transfer_percentage NUMBER DEFAULT NULL,
p_transaction_sequence_id NUMBER DEFAULT NULL,
p_material_account NUMBER DEFAULT NULL,
p_material_overhead_account NUMBER DEFAULT NULL,
p_resource_account NUMBER DEFAULT NULL,
p_outside_processing_account NUMBER DEFAULT NULL,
p_overhead_account NUMBER DEFAULT NULL,
p_bom_revision VARCHAR2 DEFAULT NULL,
p_routing_revision VARCHAR2 DEFAULT NULL,
p_bom_revision_date DATE DEFAULT NULL,
p_routing_revision_date DATE DEFAULT NULL,
p_alternate_bom_designator VARCHAR2 DEFAULT NULL,
p_alternate_routing_designator VARCHAR2 DEFAULT NULL,
p_accounting_class VARCHAR2 DEFAULT NULL,
p_demand_class VARCHAR2 DEFAULT NULL,
p_parent_id NUMBER DEFAULT NULL,
p_substitution_type_id NUMBER DEFAULT NULL,
p_substitution_item_id NUMBER DEFAULT NULL,
p_schedule_group NUMBER DEFAULT NULL,
p_build_sequence NUMBER DEFAULT NULL,
p_schedule_number VARCHAR2 DEFAULT NULL,
p_scheduled_flag NUMBER DEFAULT NULL,
p_flow_schedule VARCHAR2 DEFAULT NULL,
p_cost_group_id NUMBER DEFAULT NULL,
p_kanban_card_id NUMBER DEFAULT NULL,
p_qa_collection_id NUMBER DEFAULT NULL,
p_overcompletion_transaction_q NUMBER DEFAULT NULL,
p_overcompletion_primary_qty NUMBER DEFAULT NULL,
p_overcompletion_transaction_i NUMBER DEFAULT NULL,
p_end_item_unit_number VARCHAR2 DEFAULT NULL,
p_scheduled_payback_date DATE DEFAULT NULL,
p_org_cost_group_id NUMBER DEFAULT NULL,
p_cost_type_id NUMBER DEFAULT NULL,
p_source_lot_number VARCHAR2 DEFAULT NULL,
p_transfer_cost_group_id NUMBER DEFAULT NULL,
p_lpn_id NUMBER DEFAULT NULL,
p_transfer_lpn_id NUMBER DEFAULT NULL,
p_content_lpn_id NUMBER DEFAULT NULL,
p_xml_document_id VARCHAR2 DEFAULT NULL,
p_organization_type NUMBER DEFAULT NULL,
p_transfer_organization_type NUMBER DEFAULT NULL,
p_owning_organization_id NUMBER DEFAULT NULL,
p_owning_tp_type NUMBER DEFAULT NULL,
p_xfr_owning_organization_id NUMBER DEFAULT NULL,
p_transfer_owning_tp_type NUMBER DEFAULT NULL,
p_planning_organization_id NUMBER DEFAULT NULL,
p_planning_tp_type NUMBER DEFAULT NULL,
p_xfr_planning_organization_id NUMBER DEFAULT NULL,
p_transfer_planning_tp_type NUMBER DEFAULT NULL,
p_secondary_uom_code VARCHAR2 DEFAULT NULL,
p_secondary_transaction_quanti NUMBER DEFAULT NULL,
p_transaction_group_id NUMBER DEFAULT NULL,
p_transaction_group_seq NUMBER DEFAULT NULL,
p_representative_lot_number VARCHAR2 DEFAULT NULL,
p_transaction_batch_id NUMBER DEFAULT NULL,
p_transaction_batch_seq NUMBER DEFAULT NULL,
p_rebuild_item_id NUMBER DEFAULT NULL,
p_rebuild_serial_number VARCHAR2 DEFAULT NULL,
p_rebuild_activity_id NUMBER DEFAULT NULL,
p_rebuild_job_name VARCHAR2 DEFAULT NULL,
p_move_transaction_id NUMBER DEFAULT NULL,
p_completion_transaction_id NUMBER DEFAULT NULL,
p_wip_supply_type NUMBER DEFAULT NULL);
END;
/
CREATE OR REPLACE PACKAGE BODY APPS.cux_mtl_tran_inte_pkg AS
PROCEDURE ins_lot_iface(p_transaction_interface_id IN NUMBER,
p_source_code IN VARCHAR2 DEFAULT NULL,
p_source_line_id IN NUMBER DEFAULT NULL,
p_last_update_date IN DATE,
p_last_updated_by IN NUMBER,
p_creation_date IN DATE,
p_created_by IN NUMBER,
p_last_update_login IN NUMBER DEFAULT NULL,
p_request_id IN NUMBER DEFAULT NULL,
p_program_application_id IN NUMBER DEFAULT NULL,
p_program_id IN NUMBER DEFAULT NULL,
p_program_update_date IN DATE DEFAULT NULL,
p_lot_number IN VARCHAR2,
p_lot_expiration_date IN DATE DEFAULT NULL,
p_transaction_quantity IN NUMBER,
p_primary_quantity IN NUMBER DEFAULT NULL,
p_serial_transaction_temp_id IN NUMBER DEFAULT NULL,
p_error_code IN VARCHAR2 DEFAULT NULL,
p_process_flag IN VARCHAR2 DEFAULT NULL,
p_description IN VARCHAR2 DEFAULT NULL,
p_vendor_name IN VARCHAR2 DEFAULT NULL,
p_supplier_lot_number IN VARCHAR2 DEFAULT NULL,
p_origination_date IN DATE DEFAULT NULL,
p_date_code IN VARCHAR2 DEFAULT NULL,
p_grade_code IN VARCHAR2 DEFAULT NULL,
p_change_date IN DATE DEFAULT NULL,
p_maturity_date IN DATE DEFAULT NULL,
p_status_id IN NUMBER DEFAULT NULL,
p_retest_date IN DATE DEFAULT NULL,
p_age IN NUMBER DEFAULT NULL,
p_item_size IN NUMBER DEFAULT NULL,
p_color IN VARCHAR2 DEFAULT NULL,
p_volume IN NUMBER DEFAULT NULL,
p_volume_uom IN VARCHAR2 DEFAULT NULL,
p_place_of_origin IN VARCHAR2 DEFAULT NULL,
p_best_by_date IN DATE DEFAULT NULL,
p_length IN NUMBER DEFAULT NULL,
p_length_uom IN VARCHAR2 DEFAULT NULL,
p_recycled_content IN NUMBER DEFAULT NULL,
p_thickness IN NUMBER DEFAULT NULL,
p_thickness_uom IN VARCHAR2 DEFAULT NULL,
p_width IN NUMBER DEFAULT NULL,
p_width_uom IN VARCHAR2 DEFAULT NULL,
p_curl_wrinkle_fold IN VARCHAR2 DEFAULT NULL,
p_lot_attribute_category IN VARCHAR2 DEFAULT NULL,
p_c_attribute1 IN VARCHAR2 DEFAULT NULL,
p_c_attribute2 IN VARCHAR2 DEFAULT NULL,
p_c_attribute3 IN VARCHAR2 DEFAULT NULL,
p_c_attribute4 IN VARCHAR2 DEFAULT NULL,
p_c_attribute5 IN VARCHAR2 DEFAULT NULL,
p_c_attribute6 IN VARCHAR2 DEFAULT NULL,
p_c_attribute7 IN VARCHAR2 DEFAULT NULL,
p_c_attribute8 IN VARCHAR2 DEFAULT NULL,
p_c_attribute9 IN VARCHAR2 DEFAULT NULL,
p_c_attribute10 IN VARCHAR2 DEFAULT NULL,
p_c_attribute11 IN VARCHAR2 DEFAULT NULL,
p_c_attribute12 IN VARCHAR2 DEFAULT NULL,
p_c_attribute13 IN VARCHAR2 DEFAULT NULL,
p_c_attribute14 IN VARCHAR2 DEFAULT NULL,
p_c_attribute15 IN VARCHAR2 DEFAULT NULL,
p_c_attribute16 IN VARCHAR2 DEFAULT NULL,
p_c_attribute17 IN VARCHAR2 DEFAULT NULL,
p_c_attribute18 IN VARCHAR2 DEFAULT NULL,
p_c_attribute19 IN VARCHAR2 DEFAULT NULL,
p_c_attribute20 IN VARCHAR2 DEFAULT NULL,
p_d_attribute1 IN DATE DEFAULT NULL,
p_d_attribute2 IN DATE DEFAULT NULL,
p_d_attribute3 IN DATE DEFAULT NULL,
p_d_attribute4 IN DATE DEFAULT NULL,
p_d_attribute5 IN DATE DEFAULT NULL,
p_d_attribute6 IN DATE DEFAULT NULL,
p_d_attribute7 IN DATE DEFAULT NULL,
p_d_attribute8 IN DATE DEFAULT NULL,
p_d_attribute9 IN DATE DEFAULT NULL,
p_d_attribute10 IN DATE DEFAULT NULL,
p_n_attribute1 IN NUMBER DEFAULT NULL,
p_n_attribute2 IN NUMBER DEFAULT NULL,
p_n_attribute3 IN NUMBER DEFAULT NULL,
p_n_attribute4 IN NUMBER DEFAULT NULL,
p_n_attribute5 IN NUMBER DEFAULT NULL,
p_n_attribute6 IN NUMBER DEFAULT NULL,
p_n_attribute7 IN NUMBER DEFAULT NULL,
p_n_attribute8 IN NUMBER DEFAULT NULL,
p_n_attribute9 IN NUMBER DEFAULT NULL,
p_n_attribute10 IN NUMBER DEFAULT NULL,
p_vendor_id IN NUMBER DEFAULT NULL,
p_territory_code IN VARCHAR2 DEFAULT NULL,
p_product_code IN VARCHAR2 DEFAULT NULL,
p_product_transaction_id IN NUMBER DEFAULT NULL,
p_secondary_tran_qty IN NUMBER DEFAULT NULL,
p_sublot_num IN VARCHAR2 DEFAULT NULL,
p_reason_code IN VARCHAR2 DEFAULT NULL,
p_attribute_category IN VARCHAR2 DEFAULT NULL,
p_attribute1 IN VARCHAR2 DEFAULT NULL,
p_attribute2 IN VARCHAR2 DEFAULT NULL,
p_attribute3 IN VARCHAR2 DEFAULT NULL,
p_attribute4 IN VARCHAR2 DEFAULT NULL,
p_attribute5 IN VARCHAR2 DEFAULT NULL,
p_attribute6 IN VARCHAR2 DEFAULT NULL,
p_attribute7 IN VARCHAR2 DEFAULT NULL,
p_attribute8 IN VARCHAR2 DEFAULT NULL,
p_attribute9 IN VARCHAR2 DEFAULT NULL,
p_attribute10 IN VARCHAR2 DEFAULT NULL,
p_attribute11 IN VARCHAR2 DEFAULT NULL,
p_attribute12 IN VARCHAR2 DEFAULT NULL,
p_attribute13 IN VARCHAR2 DEFAULT NULL,
p_attribute14 IN VARCHAR2 DEFAULT NULL,
p_attribute15 IN VARCHAR2 DEFAULT NULL)
IS
BEGIN
INSERT INTO mtl_transaction_lots_interface
(transaction_interface_id,
source_code,
source_line_id,
last_update_date,
last_updated_by,
creation_date,
created_by,
last_update_login,
request_id,
program_application_id,
program_id,
program_update_date,
lot_number,
lot_expiration_date,
transaction_quantity,
primary_quantity,
serial_transaction_temp_id,
ERROR_CODE,
process_flag,
description,
vendor_name,
supplier_lot_number,
origination_date,
date_code,
grade_code,
change_date,
maturity_date,
status_id,
retest_date,
age,
item_size,
color,
volume,
volume_uom,
place_of_origin,
best_by_date,
length,
length_uom,
recycled_content,
thickness,
thickness_uom,
width,
width_uom,
curl_wrinkle_fold,
lot_attribute_category,
c_attribute1,
c_attribute2,
c_attribute3,
c_attribute4,
c_attribute5,
c_attribute6,
c_attribute7,
c_attribute8,
c_attribute9,
c_attribute10,
c_attribute11,
c_attribute12,
c_attribute13,
c_attribute14,
c_attribute15,
c_attribute16,
c_attribute17,
c_attribute18,
c_attribute19,
c_attribute20,
d_attribute1,
d_attribute2,
d_attribute3,
d_attribute4,
d_attribute5,
d_attribute6,
d_attribute7,
d_attribute8,
d_attribute9,
d_attribute10,
n_attribute1,
n_attribute2,
n_attribute3,
n_attribute4,
n_attribute5,
n_attribute6,
n_attribute7,
n_attribute8,
n_attribute9,
n_attribute10,
vendor_id,
territory_code,
product_code,
product_transaction_id,
secondary_transaction_quantity,
sublot_num,
reason_code,
attribute_category,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15)
VALUES
(p_transaction_interface_id,
p_source_code,
p_source_line_id,
p_last_update_date,
p_last_updated_by,
p_creation_date,
p_created_by,
p_last_update_login,
p_request_id,
p_program_application_id,
p_program_id,
p_program_update_date,
p_lot_number,
p_lot_expiration_date,
p_transaction_quantity,
p_primary_quantity,
p_serial_transaction_temp_id,
p_error_code,
p_process_flag,
p_description,
p_vendor_name,
p_supplier_lot_number,
p_origination_date,
p_date_code,
p_grade_code,
p_change_date,
p_maturity_date,
p_status_id,
p_retest_date,
p_age,
p_item_size,
p_color,
p_volume,
p_volume_uom,
p_place_of_origin,
p_best_by_date,
p_length,
p_length_uom,
p_recycled_content,
p_thickness,
p_thickness_uom,
p_width,
p_width_uom,
p_curl_wrinkle_fold,
p_lot_attribute_category,
p_c_attribute1,
p_c_attribute2,
p_c_attribute3,
p_c_attribute4,
p_c_attribute5,
p_c_attribute6,
p_c_attribute7,
p_c_attribute8,
p_c_attribute9,
p_c_attribute10,
p_c_attribute11,
p_c_attribute12,
p_c_attribute13,
p_c_attribute14,
p_c_attribute15,
p_c_attribute16,
p_c_attribute17,
p_c_attribute18,
p_c_attribute19,
p_c_attribute20,
p_d_attribute1,
p_d_attribute2,
p_d_attribute3,
p_d_attribute4,
p_d_attribute5,
p_d_attribute6,
p_d_attribute7,
p_d_attribute8,
p_d_attribute9,
p_d_attribute10,
p_n_attribute1,
p_n_attribute2,
p_n_attribute3,
p_n_attribute4,
p_n_attribute5,
p_n_attribute6,
p_n_attribute7,
p_n_attribute8,
p_n_attribute9,
p_n_attribute10,
p_vendor_id,
p_territory_code,
p_product_code,
p_product_transaction_id,
p_secondary_tran_qty,
p_sublot_num,
p_reason_code,
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);
END ins_lot_iface;
PROCEDURE ins_mtl_trans_inte(p_transaction_interface_id NUMBER DEFAULT NULL,
p_transaction_header_id NUMBER DEFAULT NULL,
p_source_code VARCHAR2,
p_source_line_id NUMBER,
p_source_header_id NUMBER,
p_process_flag NUMBER,
p_validation_required NUMBER DEFAULT NULL,
p_transaction_mode NUMBER,
p_lock_flag NUMBER DEFAULT NULL,
p_last_updated_by NUMBER,
p_created_by NUMBER,
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_inventory_item_id NUMBER DEFAULT NULL,
p_item_segment1 VARCHAR2 DEFAULT NULL,
p_item_segment2 VARCHAR2 DEFAULT NULL,
p_item_segment3 VARCHAR2 DEFAULT NULL,
p_item_segment4 VARCHAR2 DEFAULT NULL,
p_item_segment5 VARCHAR2 DEFAULT NULL,
p_item_segment6 VARCHAR2 DEFAULT NULL,
p_item_segment7 VARCHAR2 DEFAULT NULL,
p_item_segment8 VARCHAR2 DEFAULT NULL,
p_item_segment9 VARCHAR2 DEFAULT NULL,
p_item_segment10 VARCHAR2 DEFAULT NULL,
p_item_segment11 VARCHAR2 DEFAULT NULL,
p_item_segment12 VARCHAR2 DEFAULT NULL,
p_item_segment13 VARCHAR2 DEFAULT NULL,
p_item_segment14 VARCHAR2 DEFAULT NULL,
p_item_segment15 VARCHAR2 DEFAULT NULL,
p_item_segment16 VARCHAR2 DEFAULT NULL,
p_item_segment17 VARCHAR2 DEFAULT NULL,
p_item_segment18 VARCHAR2 DEFAULT NULL,
p_item_segment19 VARCHAR2 DEFAULT NULL,
p_item_segment20 VARCHAR2 DEFAULT NULL,
p_revision VARCHAR2 DEFAULT NULL,
p_organization_id NUMBER,
p_transaction_quantity NUMBER,
p_primary_quantity NUMBER DEFAULT NULL,
p_transaction_uom VARCHAR2,
p_transaction_date DATE,
p_acct_period_id NUMBER DEFAULT NULL,
p_subinventory_code VARCHAR2 DEFAULT NULL,
p_locator_id NUMBER DEFAULT NULL,
p_loc_segment1 VARCHAR2 DEFAULT NULL,
p_loc_segment2 VARCHAR2 DEFAULT NULL,
p_loc_segment3 VARCHAR2 DEFAULT NULL,
p_loc_segment4 VARCHAR2 DEFAULT NULL,
p_loc_segment5 VARCHAR2 DEFAULT NULL,
p_loc_segment6 VARCHAR2 DEFAULT NULL,
p_loc_segment7 VARCHAR2 DEFAULT NULL,
p_loc_segment8 VARCHAR2 DEFAULT NULL,
p_loc_segment9 VARCHAR2 DEFAULT NULL,
p_loc_segment10 VARCHAR2 DEFAULT NULL,
p_loc_segment11 VARCHAR2 DEFAULT NULL,
p_loc_segment12 VARCHAR2 DEFAULT NULL,
p_loc_segment13 VARCHAR2 DEFAULT NULL,
p_loc_segment14 VARCHAR2 DEFAULT NULL,
p_loc_segment15 VARCHAR2 DEFAULT NULL,
p_loc_segment16 VARCHAR2 DEFAULT NULL,
p_loc_segment17 VARCHAR2 DEFAULT NULL,
p_loc_segment18 VARCHAR2 DEFAULT NULL,
p_loc_segment19 VARCHAR2 DEFAULT NULL,
p_loc_segment20 VARCHAR2 DEFAULT NULL,
p_transaction_source_id NUMBER DEFAULT NULL,
p_dsp_segment1 VARCHAR2 DEFAULT NULL,
p_dsp_segment2 VARCHAR2 DEFAULT NULL,
p_dsp_segment3 VARCHAR2 DEFAULT NULL,
p_dsp_segment4 VARCHAR2 DEFAULT NULL,
p_dsp_segment5 VARCHAR2 DEFAULT NULL,
p_dsp_segment6 VARCHAR2 DEFAULT NULL,
p_dsp_segment7 VARCHAR2 DEFAULT NULL,
p_dsp_segment8 VARCHAR2 DEFAULT NULL,
p_dsp_segment9 VARCHAR2 DEFAULT NULL,
p_dsp_segment10 VARCHAR2 DEFAULT NULL,
p_dsp_segment11 VARCHAR2 DEFAULT NULL,
p_dsp_segment12 VARCHAR2 DEFAULT NULL,
p_dsp_segment13 VARCHAR2 DEFAULT NULL,
p_dsp_segment14 VARCHAR2 DEFAULT NULL,
p_dsp_segment15 VARCHAR2 DEFAULT NULL,
p_dsp_segment16 VARCHAR2 DEFAULT NULL,
p_dsp_segment17 VARCHAR2 DEFAULT NULL,
p_dsp_segment18 VARCHAR2 DEFAULT NULL,
p_dsp_segment19 VARCHAR2 DEFAULT NULL,
p_dsp_segment20 VARCHAR2 DEFAULT NULL,
p_dsp_segment21 VARCHAR2 DEFAULT NULL,
p_dsp_segment22 VARCHAR2 DEFAULT NULL,
p_dsp_segment23 VARCHAR2 DEFAULT NULL,
p_dsp_segment24 VARCHAR2 DEFAULT NULL,
p_dsp_segment25 VARCHAR2 DEFAULT NULL,
p_dsp_segment26 VARCHAR2 DEFAULT NULL,
p_dsp_segment27 VARCHAR2 DEFAULT NULL,
p_dsp_segment28 VARCHAR2 DEFAULT NULL,
p_dsp_segment29 VARCHAR2 DEFAULT NULL,
p_dsp_segment30 VARCHAR2 DEFAULT NULL,
p_transaction_source_name VARCHAR2 DEFAULT NULL,
p_transaction_source_type_id NUMBER DEFAULT NULL,
p_transaction_action_id NUMBER DEFAULT NULL,
p_transaction_type_id NUMBER,
p_reason_id NUMBER DEFAULT NULL,
p_transaction_reference VARCHAR2 DEFAULT NULL,
p_transaction_cost NUMBER DEFAULT NULL,
p_distribution_account_id NUMBER DEFAULT NULL,
p_dst_segment1 VARCHAR2 DEFAULT NULL,
p_dst_segment2 VARCHAR2 DEFAULT NULL,
p_dst_segment3 VARCHAR2 DEFAULT NULL,
p_dst_segment4 VARCHAR2 DEFAULT NULL,
p_dst_segment5 VARCHAR2 DEFAULT NULL,
p_dst_segment6 VARCHAR2 DEFAULT NULL,
p_dst_segment7 VARCHAR2 DEFAULT NULL,
p_dst_segment8 VARCHAR2 DEFAULT NULL,
p_dst_segment9 VARCHAR2 DEFAULT NULL,
p_dst_segment10 VARCHAR2 DEFAULT NULL,
p_dst_segment11 VARCHAR2 DEFAULT NULL,
p_dst_segment12 VARCHAR2 DEFAULT NULL,
p_dst_segment13 VARCHAR2 DEFAULT NULL,
p_dst_segment14 VARCHAR2 DEFAULT NULL,
p_dst_segment15 VARCHAR2 DEFAULT NULL,
p_dst_segment16 VARCHAR2 DEFAULT NULL,
p_dst_segment17 VARCHAR2 DEFAULT NULL,
p_dst_segment18 VARCHAR2 DEFAULT NULL,
p_dst_segment19 VARCHAR2 DEFAULT NULL,
p_dst_segment20 VARCHAR2 DEFAULT NULL,
p_dst_segment21 VARCHAR2 DEFAULT NULL,
p_dst_segment22 VARCHAR2 DEFAULT NULL,
p_dst_segment23 VARCHAR2 DEFAULT NULL,
p_dst_segment24 VARCHAR2 DEFAULT NULL,
p_dst_segment25 VARCHAR2 DEFAULT NULL,
p_dst_segment26 VARCHAR2 DEFAULT NULL,
p_dst_segment27 VARCHAR2 DEFAULT NULL,
p_dst_segment28 VARCHAR2 DEFAULT NULL,
p_dst_segment29 VARCHAR2 DEFAULT NULL,
p_dst_segment30 VARCHAR2 DEFAULT NULL,
p_requisition_line_id 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_ussgl_transaction_code VARCHAR2 DEFAULT NULL,
p_wip_entity_type NUMBER DEFAULT NULL,
p_schedule_id NUMBER DEFAULT NULL,
p_employee_code VARCHAR2 DEFAULT NULL,
p_department_id NUMBER DEFAULT NULL,
p_schedule_update_code NUMBER DEFAULT NULL,
p_setup_teardown_code NUMBER DEFAULT NULL,
p_primary_switch NUMBER DEFAULT NULL,
p_mrp_code NUMBER DEFAULT NULL,
p_operation_seq_num NUMBER DEFAULT NULL,
p_repetitive_line_id NUMBER DEFAULT NULL,
p_picking_line_id NUMBER DEFAULT NULL,
p_trx_source_line_id NUMBER DEFAULT NULL,
p_trx_source_delivery_id NUMBER DEFAULT NULL,
p_demand_id NUMBER DEFAULT NULL,
p_customer_ship_id NUMBER DEFAULT NULL,
p_line_item_num NUMBER DEFAULT NULL,
p_receiving_document VARCHAR2 DEFAULT NULL,
p_rcv_transaction_id NUMBER DEFAULT NULL,
p_ship_to_location_id NUMBER DEFAULT NULL,
p_encumbrance_account NUMBER DEFAULT NULL,
p_encumbrance_amount NUMBER DEFAULT NULL,
p_vendor_lot_number VARCHAR2 DEFAULT NULL,
p_transfer_subinventory VARCHAR2 DEFAULT NULL,
p_transfer_organization NUMBER DEFAULT NULL,
p_transfer_locator NUMBER DEFAULT NULL,
p_xfer_loc_segment1 VARCHAR2 DEFAULT NULL,
p_xfer_loc_segment2 VARCHAR2 DEFAULT NULL,
p_xfer_loc_segment3 VARCHAR2 DEFAULT NULL,
p_xfer_loc_segment4 VARCHAR2 DEFAULT NULL,
p_xfer_loc_segment5 VARCHAR2 DEFAULT NULL,
p_xfer_loc_segment6 VARCHAR2 DEFAULT NULL,
p_xfer_loc_segment7 VARCHAR2 DEFAULT NULL,
p_xfer_loc_segment8 VARCHAR2 DEFAULT NULL,
p_xfer_loc_segment9 VARCHAR2 DEFAULT NULL,
p_xfer_loc_segment10 VARCHAR2 DEFAULT NULL,
p_xfer_loc_segment11 VARCHAR2 DEFAULT NULL,
p_xfer_loc_segment12 VARCHAR2 DEFAULT NULL,
p_xfer_loc_segment13 VARCHAR2 DEFAULT NULL,
p_xfer_loc_segment14 VARCHAR2 DEFAULT NULL,
p_xfer_loc_segment15 VARCHAR2 DEFAULT NULL,
p_xfer_loc_segment16 VARCHAR2 DEFAULT NULL,
p_xfer_loc_segment17 VARCHAR2 DEFAULT NULL,
p_xfer_loc_segment18 VARCHAR2 DEFAULT NULL,
p_xfer_loc_segment19 VARCHAR2 DEFAULT NULL,
p_xfer_loc_segment20 VARCHAR2 DEFAULT NULL,
p_shipment_number VARCHAR2 DEFAULT NULL,
p_transportation_cost NUMBER DEFAULT NULL,
p_transportation_account NUMBER DEFAULT NULL,
p_transfer_cost NUMBER DEFAULT NULL,
p_freight_code VARCHAR2 DEFAULT NULL,
p_containers NUMBER DEFAULT NULL,
p_waybill_airbill VARCHAR2 DEFAULT NULL,
p_expected_arrival_date DATE DEFAULT NULL,
p_new_average_cost NUMBER DEFAULT NULL,
p_value_change NUMBER DEFAULT NULL,
p_percentage_change NUMBER DEFAULT NULL,
p_demand_source_header_id NUMBER DEFAULT NULL,
p_demand_source_line VARCHAR2 DEFAULT NULL,
p_demand_source_delivery VARCHAR2 DEFAULT NULL,
p_negative_req_flag NUMBER DEFAULT NULL,
p_error_explanation VARCHAR2 DEFAULT NULL,
p_shippable_flag VARCHAR2 DEFAULT NULL,
p_error_code VARCHAR2 DEFAULT NULL,
p_required_flag VARCHAR2 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_requisition_distribution_id NUMBER DEFAULT NULL,
p_movement_id NUMBER DEFAULT NULL,
p_reservation_quantity NUMBER DEFAULT NULL,
p_shipped_quantity NUMBER DEFAULT NULL,
p_inventory_item VARCHAR2 DEFAULT NULL,
p_locator_name VARCHAR2 DEFAULT NULL,
p_task_id NUMBER DEFAULT NULL,
p_to_task_id NUMBER DEFAULT NULL,
p_source_task_id NUMBER DEFAULT NULL,
p_project_id NUMBER DEFAULT NULL,
p_to_project_id NUMBER DEFAULT NULL,
p_source_project_id NUMBER DEFAULT NULL,
p_pa_expenditure_org_id NUMBER DEFAULT NULL,
p_expenditure_type VARCHAR2 DEFAULT NULL,
p_final_completion_flag VARCHAR2 DEFAULT NULL,
p_transfer_percentage NUMBER DEFAULT NULL,
p_transaction_sequence_id NUMBER DEFAULT NULL,
p_material_account NUMBER DEFAULT NULL,
p_material_overhead_account NUMBER DEFAULT NULL,
p_resource_account NUMBER DEFAULT NULL,
p_outside_processing_account NUMBER DEFAULT NULL,
p_overhead_account NUMBER DEFAULT NULL,
p_bom_revision VARCHAR2 DEFAULT NULL,
p_routing_revision VARCHAR2 DEFAULT NULL,
p_bom_revision_date DATE DEFAULT NULL,
p_routing_revision_date DATE DEFAULT NULL,
p_alternate_bom_designator VARCHAR2 DEFAULT NULL,
p_alternate_routing_designator VARCHAR2 DEFAULT NULL,
p_accounting_class VARCHAR2 DEFAULT NULL,
p_demand_class VARCHAR2 DEFAULT NULL,
p_parent_id NUMBER DEFAULT NULL,
p_substitution_type_id NUMBER DEFAULT NULL,
p_substitution_item_id NUMBER DEFAULT NULL,
p_schedule_group NUMBER DEFAULT NULL,
p_build_sequence NUMBER DEFAULT NULL,
p_schedule_number VARCHAR2 DEFAULT NULL,
p_scheduled_flag NUMBER DEFAULT NULL,
p_flow_schedule VARCHAR2 DEFAULT NULL,
p_cost_group_id NUMBER DEFAULT NULL,
p_kanban_card_id NUMBER DEFAULT NULL,
p_qa_collection_id NUMBER DEFAULT NULL,
p_overcompletion_transaction_q NUMBER DEFAULT NULL,
p_overcompletion_primary_qty NUMBER DEFAULT NULL,
p_overcompletion_transaction_i NUMBER DEFAULT NULL,
p_end_item_unit_number VARCHAR2 DEFAULT NULL,
p_scheduled_payback_date DATE DEFAULT NULL,
p_org_cost_group_id NUMBER DEFAULT NULL,
p_cost_type_id NUMBER DEFAULT NULL,
p_source_lot_number VARCHAR2 DEFAULT NULL,
p_transfer_cost_group_id NUMBER DEFAULT NULL,
p_lpn_id NUMBER DEFAULT NULL,
p_transfer_lpn_id NUMBER DEFAULT NULL,
p_content_lpn_id NUMBER DEFAULT NULL,
p_xml_document_id VARCHAR2 DEFAULT NULL,
p_organization_type NUMBER DEFAULT NULL,
p_transfer_organization_type NUMBER DEFAULT NULL,
p_owning_organization_id NUMBER DEFAULT NULL,
p_owning_tp_type NUMBER DEFAULT NULL,
p_xfr_owning_organization_id NUMBER DEFAULT NULL,
p_transfer_owning_tp_type NUMBER DEFAULT NULL,
p_planning_organization_id NUMBER DEFAULT NULL,
p_planning_tp_type NUMBER DEFAULT NULL,
p_xfr_planning_organization_id NUMBER DEFAULT NULL,
p_transfer_planning_tp_type NUMBER DEFAULT NULL,
p_secondary_uom_code VARCHAR2 DEFAULT NULL,
p_secondary_transaction_quanti NUMBER DEFAULT NULL,
p_transaction_group_id NUMBER DEFAULT NULL,
p_transaction_group_seq NUMBER DEFAULT NULL,
p_representative_lot_number VARCHAR2 DEFAULT NULL,
p_transaction_batch_id NUMBER DEFAULT NULL,
p_transaction_batch_seq NUMBER DEFAULT NULL,
p_rebuild_item_id NUMBER DEFAULT NULL,
p_rebuild_serial_number VARCHAR2 DEFAULT NULL,
p_rebuild_activity_id NUMBER DEFAULT NULL,
p_rebuild_job_name VARCHAR2 DEFAULT NULL,
p_move_transaction_id NUMBER DEFAULT NULL,
p_completion_transaction_id NUMBER DEFAULT NULL,
p_wip_supply_type NUMBER DEFAULT NULL) IS
BEGIN
INSERT INTO mtl_transactions_interface
(transaction_interface_id,
transaction_header_id,
source_code,
source_line_id,
source_header_id,
process_flag,
validation_required,
transaction_mode,
lock_flag,
last_update_date,
last_updated_by,
creation_date,
created_by,
last_update_login,
request_id,
program_application_id,
program_id,
program_update_date,
inventory_item_id,
item_segment1,
item_segment2,
item_segment3,
item_segment4,
item_segment5,
item_segment6,
item_segment7,
item_segment8,
item_segment9,
item_segment10,
item_segment11,
item_segment12,
item_segment13,
item_segment14,
item_segment15,
item_segment16,
item_segment17,
item_segment18,
item_segment19,
item_segment20,
revision,
organization_id,
transaction_quantity,
primary_quantity,
transaction_uom,
transaction_date,
acct_period_id,
subinventory_code,
locator_id,
loc_segment1,
loc_segment2,
loc_segment3,
loc_segment4,
loc_segment5,
loc_segment6,
loc_segment7,
loc_segment8,
loc_segment9,
loc_segment10,
loc_segment11,
loc_segment12,
loc_segment13,
loc_segment14,
loc_segment15,
loc_segment16,
loc_segment17,
loc_segment18,
loc_segment19,
loc_segment20,
transaction_source_id,
dsp_segment1,
dsp_segment2,
dsp_segment3,
dsp_segment4,
dsp_segment5,
dsp_segment6,
dsp_segment7,
dsp_segment8,
dsp_segment9,
dsp_segment10,
dsp_segment11,
dsp_segment12,
dsp_segment13,
dsp_segment14,
dsp_segment15,
dsp_segment16,
dsp_segment17,
dsp_segment18,
dsp_segment19,
dsp_segment20,
dsp_segment21,
dsp_segment22,
dsp_segment23,
dsp_segment24,
dsp_segment25,
dsp_segment26,
dsp_segment27,
dsp_segment28,
dsp_segment29,
dsp_segment30,
transaction_source_name,
transaction_source_type_id,
transaction_action_id,
transaction_type_id,
reason_id,
transaction_reference,
transaction_cost,
distribution_account_id,
dst_segment1,
dst_segment2,
dst_segment3,
dst_segment4,
dst_segment5,
dst_segment6,
dst_segment7,
dst_segment8,
dst_segment9,
dst_segment10,
dst_segment11,
dst_segment12,
dst_segment13,
dst_segment14,
dst_segment15,
dst_segment16,
dst_segment17,
dst_segment18,
dst_segment19,
dst_segment20,
dst_segment21,
dst_segment22,
dst_segment23,
dst_segment24,
dst_segment25,
dst_segment26,
dst_segment27,
dst_segment28,
dst_segment29,
dst_segment30,
requisition_line_id,
currency_code,
currency_conversion_date,
currency_conversion_type,
currency_conversion_rate,
ussgl_transaction_code,
wip_entity_type,
schedule_id,
employee_code,
department_id,
schedule_update_code,
setup_teardown_code,
primary_switch,
mrp_code,
operation_seq_num,
repetitive_line_id,
picking_line_id,
trx_source_line_id,
trx_source_delivery_id,
demand_id,
customer_ship_id,
line_item_num,
receiving_document,
rcv_transaction_id,
ship_to_location_id,
encumbrance_account,
encumbrance_amount,
vendor_lot_number,
transfer_subinventory,
transfer_organization,
transfer_locator,
xfer_loc_segment1,
xfer_loc_segment2,
xfer_loc_segment3,
xfer_loc_segment4,
xfer_loc_segment5,
xfer_loc_segment6,
xfer_loc_segment7,
xfer_loc_segment8,
xfer_loc_segment9,
xfer_loc_segment10,
xfer_loc_segment11,
xfer_loc_segment12,
xfer_loc_segment13,
xfer_loc_segment14,
xfer_loc_segment15,
xfer_loc_segment16,
xfer_loc_segment17,
xfer_loc_segment18,
xfer_loc_segment19,
xfer_loc_segment20,
shipment_number,
transportation_cost,
transportation_account,
transfer_cost,
freight_code,
containers,
waybill_airbill,
expected_arrival_date,
new_average_cost,
value_change,
percentage_change,
demand_source_header_id,
demand_source_line,
demand_source_delivery,
negative_req_flag,
error_explanation,
shippable_flag,
ERROR_CODE,
required_flag,
attribute_category,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15,
requisition_distribution_id,
movement_id,
reservation_quantity,
shipped_quantity,
inventory_item,
locator_name,
task_id,
to_task_id,
source_task_id,
project_id,
to_project_id,
source_project_id,
pa_expenditure_org_id,
expenditure_type,
final_completion_flag,
transfer_percentage,
transaction_sequence_id,
material_account,
material_overhead_account,
resource_account,
outside_processing_account,
overhead_account,
bom_revision,
routing_revision,
bom_revision_date,
routing_revision_date,
alternate_bom_designator,
alternate_routing_designator,
accounting_class,
demand_class,
parent_id,
substitution_type_id,
substitution_item_id,
schedule_group,
build_sequence,
schedule_number,
scheduled_flag,
flow_schedule,
cost_group_id,
kanban_card_id,
qa_collection_id,
overcompletion_transaction_qty,
overcompletion_primary_qty,
overcompletion_transaction_id,
end_item_unit_number,
scheduled_payback_date,
org_cost_group_id,
cost_type_id,
source_lot_number,
transfer_cost_group_id,
lpn_id,
transfer_lpn_id,
content_lpn_id,
xml_document_id,
organization_type,
transfer_organization_type,
owning_organization_id,
owning_tp_type,
xfr_owning_organization_id,
transfer_owning_tp_type,
planning_organization_id,
planning_tp_type,
xfr_planning_organization_id,
transfer_planning_tp_type,
secondary_uom_code,
secondary_transaction_quantity,
transaction_group_id,
transaction_group_seq,
representative_lot_number,
transaction_batch_id,
transaction_batch_seq,
rebuild_item_id,
rebuild_serial_number,
rebuild_activity_id,
rebuild_job_name,
move_transaction_id,
completion_transaction_id,
wip_supply_type)
VALUES
(p_transaction_interface_id,
p_transaction_header_id,
p_source_code,
p_source_line_id,
p_source_header_id,
p_process_flag,
p_validation_required,
p_transaction_mode,
p_lock_flag,
SYSDATE,
p_last_updated_by,
SYSDATE,
p_created_by,
p_last_update_login,
p_request_id,
p_program_application_id,
p_program_id,
p_program_update_date,
p_inventory_item_id,
p_item_segment1,
p_item_segment2,
p_item_segment3,
p_item_segment4,
p_item_segment5,
p_item_segment6,
p_item_segment7,
p_item_segment8,
p_item_segment9,
p_item_segment10,
p_item_segment11,
p_item_segment12,
p_item_segment13,
p_item_segment14,
p_item_segment15,
p_item_segment16,
p_item_segment17,
p_item_segment18,
p_item_segment19,
p_item_segment20,
p_revision,
p_organization_id,
p_transaction_quantity,
p_primary_quantity,
p_transaction_uom,
p_transaction_date,
p_acct_period_id,
p_subinventory_code,
p_locator_id,
p_loc_segment1,
p_loc_segment2,
p_loc_segment3,
p_loc_segment4,
p_loc_segment5,
p_loc_segment6,
p_loc_segment7,
p_loc_segment8,
p_loc_segment9,
p_loc_segment10,
p_loc_segment11,
p_loc_segment12,
p_loc_segment13,
p_loc_segment14,
p_loc_segment15,
p_loc_segment16,
p_loc_segment17,
p_loc_segment18,
p_loc_segment19,
p_loc_segment20,
p_transaction_source_id,
p_dsp_segment1,
p_dsp_segment2,
p_dsp_segment3,
p_dsp_segment4,
p_dsp_segment5,
p_dsp_segment6,
p_dsp_segment7,
p_dsp_segment8,
p_dsp_segment9,
p_dsp_segment10,
p_dsp_segment11,
p_dsp_segment12,
p_dsp_segment13,
p_dsp_segment14,
p_dsp_segment15,
p_dsp_segment16,
p_dsp_segment17,
p_dsp_segment18,
p_dsp_segment19,
p_dsp_segment20,
p_dsp_segment21,
p_dsp_segment22,
p_dsp_segment23,
p_dsp_segment24,
p_dsp_segment25,
p_dsp_segment26,
p_dsp_segment27,
p_dsp_segment28,
p_dsp_segment29,
p_dsp_segment30,
p_transaction_source_name,
p_transaction_source_type_id,
p_transaction_action_id,
p_transaction_type_id,
p_reason_id,
p_transaction_reference,
p_transaction_cost,
p_distribution_account_id,
p_dst_segment1,
p_dst_segment2,
p_dst_segment3,
p_dst_segment4,
p_dst_segment5,
p_dst_segment6,
p_dst_segment7,
p_dst_segment8,
p_dst_segment9,
p_dst_segment10,
p_dst_segment11,
p_dst_segment12,
p_dst_segment13,
p_dst_segment14,
p_dst_segment15,
p_dst_segment16,
p_dst_segment17,
p_dst_segment18,
p_dst_segment19,
p_dst_segment20,
p_dst_segment21,
p_dst_segment22,
p_dst_segment23,
p_dst_segment24,
p_dst_segment25,
p_dst_segment26,
p_dst_segment27,
p_dst_segment28,
p_dst_segment29,
p_dst_segment30,
p_requisition_line_id,
p_currency_code,
p_currency_conversion_date,
p_currency_conversion_type,
p_currency_conversion_rate,
p_ussgl_transaction_code,
p_wip_entity_type,
p_schedule_id,
p_employee_code,
p_department_id,
p_schedule_update_code,
p_setup_teardown_code,
p_primary_switch,
p_mrp_code,
p_operation_seq_num,
p_repetitive_line_id,
p_picking_line_id,
p_trx_source_line_id,
p_trx_source_delivery_id,
p_demand_id,
p_customer_ship_id,
p_line_item_num,
p_receiving_document,
p_rcv_transaction_id,
p_ship_to_location_id,
p_encumbrance_account,
p_encumbrance_amount,
p_vendor_lot_number,
p_transfer_subinventory,
p_transfer_organization,
p_transfer_locator,
p_xfer_loc_segment1,
p_xfer_loc_segment2,
p_xfer_loc_segment3,
p_xfer_loc_segment4,
p_xfer_loc_segment5,
p_xfer_loc_segment6,
p_xfer_loc_segment7,
p_xfer_loc_segment8,
p_xfer_loc_segment9,
p_xfer_loc_segment10,
p_xfer_loc_segment11,
p_xfer_loc_segment12,
p_xfer_loc_segment13,
p_xfer_loc_segment14,
p_xfer_loc_segment15,
p_xfer_loc_segment16,
p_xfer_loc_segment17,
p_xfer_loc_segment18,
p_xfer_loc_segment19,
p_xfer_loc_segment20,
p_shipment_number,
p_transportation_cost,
p_transportation_account,
p_transfer_cost,
p_freight_code,
p_containers,
p_waybill_airbill,
p_expected_arrival_date,
p_new_average_cost,
p_value_change,
p_percentage_change,
p_demand_source_header_id,
p_demand_source_line,
p_demand_source_delivery,
p_negative_req_flag,
p_error_explanation,
p_shippable_flag,
p_error_code,
p_required_flag,
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_requisition_distribution_id,
p_movement_id,
p_reservation_quantity,
p_shipped_quantity,
p_inventory_item,
p_locator_name,
p_task_id,
p_to_task_id,
p_source_task_id,
p_project_id,
p_to_project_id,
p_source_project_id,
p_pa_expenditure_org_id,
p_expenditure_type,
p_final_completion_flag,
p_transfer_percentage,
p_transaction_sequence_id,
p_material_account,
p_material_overhead_account,
p_resource_account,
p_outside_processing_account,
p_overhead_account,
p_bom_revision,
p_routing_revision,
p_bom_revision_date,
p_routing_revision_date,
p_alternate_bom_designator,
p_alternate_routing_designator,
p_accounting_class,
p_demand_class,
p_parent_id,
p_substitution_type_id,
p_substitution_item_id,
p_schedule_group,
p_build_sequence,
p_schedule_number,
p_scheduled_flag,
p_flow_schedule,
p_cost_group_id,
p_kanban_card_id,
p_qa_collection_id,
p_overcompletion_transaction_q,
p_overcompletion_primary_qty,
p_overcompletion_transaction_i,
p_end_item_unit_number,
p_scheduled_payback_date,
p_org_cost_group_id,
p_cost_type_id,
p_source_lot_number,
p_transfer_cost_group_id,
p_lpn_id,
p_transfer_lpn_id,
p_content_lpn_id,
p_xml_document_id,
p_organization_type,
p_transfer_organization_type,
p_owning_organization_id,
p_owning_tp_type,
p_xfr_owning_organization_id,
p_transfer_owning_tp_type,
p_planning_organization_id,
p_planning_tp_type,
p_xfr_planning_organization_id,
p_transfer_planning_tp_type,
p_secondary_uom_code,
p_secondary_transaction_quanti,
p_transaction_group_id,
p_transaction_group_seq,
p_representative_lot_number,
p_transaction_batch_id,
p_transaction_batch_seq,
p_rebuild_item_id,
p_rebuild_serial_number,
p_rebuild_activity_id,
p_rebuild_job_name,
p_move_transaction_id,
p_completion_transaction_id,
p_wip_supply_type);
END;
END;
/
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/11536986/viewspace-620203/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- ebs二次開發1
- ebs二次開發2
- ebs二次開發3
- ebs二次開發4
- ebs二次開發6
- ebs二次開發7
- EBS開發筆記-1筆記
- EBS開發環境搭建開發環境
- EBS開發筆記-2筆記
- EBS FORM PLL 開發入門ORM
- Application(EBS)開發整理(轉)APP
- Dresdon二次開發
- ThinkS二次開發
- SOLIDWORKS二次開發Solid
- NX二次開發-使用NXOPEN C++嚮導模板做二次開發C++
- Oracle EBS 基於Host併發程式的開發Oracle
- UG二次開發筆記筆記
- SOLIDWORKS二次開發形式Solid
- 小說APP原始碼開發，支援二次開發功能APP原始碼
- openfire 3.8.2 原始碼部署 /開發配置 / 二次開發原始碼
- 一個開源的OJ二次開發
- TP5框架開發的小程式商城 獨立後臺 開源無加密原始碼 方便二次開發框架加密原始碼
- Scratch3 二次開發系列
- Voyager 的使用及二次開發
- SOLIDWORKS二次開發介紹Solid
- 基於ecshop的二次開發
- 團隊專案：二次開發
- ECshop 二次開發模板教程1
- ECshop 二次開發模板教程2
- ECshop 二次開發模板教程3
- ECshop 二次開發模板教程4
- ecshop 二次開發,原始碼分析原始碼
- C++大作業二次開發C++
- BIMFACE二次開發SDK 開源C#版C#
- 我的ECshop二次開發從零開始
- EBS之JTF_Grid 開發總結
- Web快速開發平臺，基於二次開發平臺Web
- 教育APP系統原始碼二次開發，原生開發功能APP原始碼