The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT employee_id
FROM fnd_user
WHERE user_id = FND_GLOBAL.USER_ID;
SELECT rcv_interface_groups_s.nextval
FROM DUAL;
SELECT mkc.kanban_card_id,
mkc.supply_status,
mkc.card_status,
mkc.source_type,
mkc.inventory_item_id,
mkc.organization_id
FROM mtl_kanban_cards mkc
WHERE mkc.kanban_card_id = p_kanban_card_id;
SELECT msi.lot_control_code,
msi.serial_number_control_code
FROM mtl_system_items msi
WHERE msi.inventory_item_id = p_item_id
AND msi.organization_id = p_organization_id;
SELECT poh.po_header_id,
poh.approved_flag,
poll.qty_rcv_tolerance,
pod.quantity_ordered,
pod.quantity_delivered
FROM po_headers_all poh,
po_line_locations_all poll,
po_distributions_all pod,
mtl_kanban_cards mkc,
mtl_kanban_card_activity mkca
WHERE poh.po_header_id = pod.po_header_id
AND poll.line_location_id = pod.line_location_id
AND pod.po_distribution_id = mkca.document_detail_id
AND mkca.kanban_card_id = mkc.kanban_card_id
AND mkca.replenishment_cycle_id = mkc.current_replnsh_cycle_id
AND mkc.kanban_card_id = p_kanban_card_id;
SELECT COUNT(rsl.shipment_line_id) num_of_ship_lines,
SUM(rsl.quantity_shipped) quantity_shipped,
SUM(rsl.quantity_received) quantity_received
FROM rcv_shipment_lines rsl,
mtl_kanban_cards mkc,
mtl_kanban_card_activity mkca
WHERE rsl.requisition_line_id = mkca.document_detail_id
AND mkca.kanban_card_id = mkc.kanban_card_id
AND mkca.replenishment_cycle_id = mkc.current_replnsh_cycle_id
AND mkc.kanban_card_id = p_kanban_card_id;
l_delete_rows BOOLEAN := FALSE;
l_delete_rows := TRUE;
l_delete_rows := TRUE;
l_delete_rows := TRUE;
IF (l_delete_rows) THEN
DELETE FROM rcv_transactions_interface
WHERE group_id = p_group_id;
SELECT pol.category_id item_category_id,
pol.item_id item_id,
DECODE(msi.allow_item_desc_update_flag, 'Y',
pol.item_description,
NVL(msi.description, pol.item_description)
) item_description,
pol.item_revision item_revision,
muom.uom_code uom_code,
poll.ship_to_location_id ship_to_location_id,
msi.primary_unit_of_measure primary_uom,
poh.vendor_id vendor_id,
poh.vendor_site_id vendor_site_id,
poll.ship_to_organization_id to_organization_id,
poll.receiving_routing_id routing_id,
poh.po_header_id po_header_id,
poll.po_release_id po_release_id,
pol.po_line_id po_line_id,
poll.line_location_id po_line_location_id,
NVL(poll.price_override, pol.unit_price) unit_price,
poh.currency_code currency_code,
poh.rate_type currency_conversion_type,
poh.rate currency_conversion_rate,
poh.rate_date currency_conversion_date,
pod.po_distribution_id po_distribution_id,
pod.deliver_to_location_id deliver_to_location_id,
mkc.subinventory_name subinventory_name,
mkc.locator_id locator_id,
NVL(poll.promised_date, poll.need_by_date) expected_receipt_date,
pol.vendor_product_num vendor_item_number,
poll.attribute_category attribute_category,
poll.attribute1 attribute1,
poll.attribute2 attribute2,
poll.attribute3 attribute3,
poll.attribute4 attribute4,
poll.attribute5 attribute5,
poll.attribute6 attribute6,
poll.attribute7 attribute7,
poll.attribute8 attribute8,
poll.attribute9 attribute9,
poll.attribute10 attribute10,
poll.attribute11 attribute11,
poll.attribute12 attribute12,
poll.attribute13 attribute13,
poll.attribute14 attribute14,
poll.attribute15 attribute15,
poll.government_context government_context,
msi.lot_control_code lot_control_code,
msi.serial_number_control_code serial_number_control_code,
poll.country_of_origin_code country_of_origin_code,
poll.secondary_quantity secondary_quantity,
poll.secondary_unit_of_measure secondary_uom,
poll.org_id org_id
FROM po_headers_all poh,
po_lines_all pol,
po_line_locations_all poll,
po_distributions_all pod,
mtl_system_items_vl msi,
mtl_units_of_measure muom,
mtl_kanban_cards mkc,
mtl_kanban_card_activity mkca
WHERE poh.po_header_id = pol.po_header_id
AND pol.po_line_id = poll.po_line_id
AND poll.line_location_id = pod.line_location_id
AND pod.po_distribution_id = mkca.document_detail_id
AND msi.inventory_item_id = mkc.inventory_item_id
AND msi.organization_id = mkc.organization_id
AND muom.unit_of_measure = msi.primary_unit_of_measure
AND mkca.kanban_card_id = mkc.kanban_card_id
AND mkca.replenishment_cycle_id = mkc.current_replnsh_cycle_id
AND mkc.kanban_card_id = p_kanban_card_id;
'Before rcv_shipment_headers_pkg.insert_row');
rcv_shipment_headers_pkg.insert_row
( X_Rowid => l_rowid,
X_Shipment_Header_Id => l_shipment_header_id,
X_Last_Update_Date => SYSDATE,
X_Last_Updated_By => FND_GLOBAL.USER_ID,
X_Creation_Date => SYSDATE,
X_Created_By => FND_GLOBAL.USER_ID,
X_Last_Update_Login => FND_GLOBAL.LOGIN_ID,
X_Receipt_Source_Code => 'VENDOR',
X_Vendor_Id => l_rcv_details_rec.vendor_id,
X_Vendor_Site_Id => l_rcv_details_rec.vendor_site_id,
X_Organization_Id => NULL,
X_ship_to_org_id => l_rcv_details_rec.to_organization_id,
X_Shipment_Num => NULL,
X_Receipt_Num => x_receipt_num,
X_Ship_To_Location_Id => l_rcv_details_rec.ship_to_location_id,
X_Bill_Of_Lading => NULL,
X_Packing_Slip => NULL,
X_Shipped_Date => NULL,
X_Freight_Carrier_Code => NULL,
X_Expected_Receipt_Date => l_rcv_details_rec.expected_receipt_date,
X_Employee_Id => l_employee_id,
X_Num_Of_Containers => NULL,
X_Waybill_Airbill_Num => NULL,
X_Comments => NULL,
X_Attribute_Category => l_rcv_details_rec.attribute_category,
X_Attribute1 => l_rcv_details_rec.attribute1,
X_Attribute2 => l_rcv_details_rec.attribute2,
X_Attribute3 => l_rcv_details_rec.attribute3,
X_Attribute4 => l_rcv_details_rec.attribute4,
X_Attribute5 => l_rcv_details_rec.attribute5,
X_Attribute6 => l_rcv_details_rec.attribute6,
X_Attribute7 => l_rcv_details_rec.attribute7,
X_Attribute8 => l_rcv_details_rec.attribute8,
X_Attribute9 => l_rcv_details_rec.attribute9,
X_Attribute10 => l_rcv_details_rec.attribute10,
X_Attribute11 => l_rcv_details_rec.attribute11,
X_Attribute12 => l_rcv_details_rec.attribute12,
X_Attribute13 => l_rcv_details_rec.attribute13,
X_Attribute14 => l_rcv_details_rec.attribute14,
X_Attribute15 => l_rcv_details_rec.attribute15,
X_Ussgl_Transaction_Code => NULL,
X_Government_Context => l_rcv_details_rec.government_context,
X_Request_Id => NULL,
X_Program_Application_Id => NULL,
X_Program_Id => NULL,
X_Program_Update_Date => NULL,
X_customer_id => NULL,
X_customer_site_id => NULL
);
'After rcv_shipment_headers_pkg.insert_row: ' ||
'l_shipment_header_id = ' || l_shipment_header_id || ', ' ||
'x_receipt_num = ' || x_receipt_num);
'Before rcv_trx_interface_insert_pkg.insert_row');
rcv_trx_interface_insert_pkg.insert_row
( X_Rowid => l_rowid,
X_Interface_Transaction_Id => l_interface_transaction_id,
X_Group_Id => l_group_id,
X_Last_Update_Date => SYSDATE,
X_Last_Updated_By => FND_GLOBAL.USER_ID,
X_Creation_Date => SYSDATE,
X_Created_By => FND_GLOBAL.USER_ID,
X_Last_Update_Login => FND_GLOBAL.LOGIN_ID,
X_Transaction_Type => 'RECEIVE',
X_Transaction_Date => SYSDATE,
X_Processing_Status_Code => 'PENDING',
X_Processing_Mode_Code => 'ONLINE',
X_Processing_Request_Id => NULL,
X_Transaction_Status_Code => 'PENDING',
X_Category_Id => l_rcv_details_rec.item_category_id,
X_Quantity => p_receipt_quantity,
X_Unit_Of_Measure => l_rcv_details_rec.primary_uom,
X_Interface_Source_Code => 'FLM',
X_Interface_Source_Line_Id => NULL,
X_Inv_Transaction_Id => NULL,
X_Item_Id => l_rcv_details_rec.item_id,
X_Item_Description => l_rcv_details_rec.item_description,
X_Item_Revision => l_rcv_details_rec.item_revision,
X_Uom_Code => l_rcv_details_rec.uom_code,
X_Employee_Id => l_employee_id,
X_Auto_Transact_Code => 'DELIVER',
X_Shipment_Header_Id => l_shipment_header_id,
X_Shipment_Line_Id => NULL,
X_Ship_To_Location_Id => l_rcv_details_rec.ship_to_location_id,
X_Primary_Quantity => p_receipt_quantity,
X_Primary_Unit_Of_Measure => l_rcv_details_rec.primary_uom,
X_Receipt_Source_Code => 'VENDOR',
X_Vendor_Id => l_rcv_details_rec.vendor_id,
X_Vendor_Site_Id => l_rcv_details_rec.vendor_site_id,
X_From_Organization_Id => NULL,
X_To_Organization_Id => l_rcv_details_rec.to_organization_id,
X_Routing_Header_Id => l_rcv_details_rec.routing_id,
X_Routing_Step_Id => 1,
X_Source_Document_Code => 'PO',
X_Parent_Transaction_Id => NULL,
X_Po_Header_Id => l_rcv_details_rec.po_header_id,
X_Po_Revision_Num => NULL,
X_Po_Release_Id => l_rcv_details_rec.po_release_id,
X_Po_Line_Id => l_rcv_details_rec.po_line_id,
X_Po_Line_Location_Id => l_rcv_details_rec.po_line_location_id,
X_Po_Unit_Price => l_rcv_details_rec.unit_price,
X_Currency_Code => l_rcv_details_rec.currency_code,
X_Currency_Conversion_Type => l_rcv_details_rec.currency_conversion_type,
X_Currency_Conversion_Rate => l_rcv_details_rec.currency_conversion_rate,
X_Currency_Conversion_Date => l_rcv_details_rec.currency_conversion_date,
X_Po_Distribution_Id => l_rcv_details_rec.po_distribution_id,
X_Requisition_Line_Id => NULL,
X_Req_Distribution_Id => NULL,
X_Charge_Account_Id => NULL,
X_Substitute_Unordered_Code => NULL,
X_Receipt_Exception_Flag => NULL,
X_Accrual_Status_Code => NULL,
X_Inspection_Status_Code => 'NOT INSPECTED',
X_Inspection_Quality_Code => NULL,
X_Destination_Type_Code => 'INVENTORY',
X_Deliver_To_Person_Id => l_employee_id,
X_Location_Id => l_rcv_details_rec.deliver_to_location_id,
X_Deliver_To_Location_Id => l_rcv_details_rec.deliver_to_location_id,
X_Subinventory => l_rcv_details_rec.subinventory_name,
X_Locator_Id => l_rcv_details_rec.locator_id,
X_Wip_Entity_Id => NULL,
X_Wip_Line_Id => NULL,
X_Department_Code => NULL,
X_Wip_Repetitive_Schedule_Id => NULL,
X_Wip_Operation_Seq_Num => NULL,
X_Wip_Resource_Seq_Num => NULL,
X_Bom_Resource_Id => NULL,
X_Shipment_Num => NULL,
X_Freight_Carrier_Code => NULL,
X_Bill_Of_Lading => NULL,
X_Packing_Slip => NULL,
X_Shipped_Date => NULL,
X_Expected_Receipt_Date => l_rcv_details_rec.expected_receipt_date,
X_Actual_Cost => NULL,
X_Transfer_Cost => NULL,
X_Transportation_Cost => NULL,
X_Transportation_Account_Id => NULL,
X_Num_Of_Containers => NULL,
X_Waybill_Airbill_Num => NULL,
X_Vendor_Item_Num => l_rcv_details_rec.vendor_item_number,
X_Vendor_Lot_Num => NULL,
X_Rma_Reference => NULL,
X_Comments => NULL,
X_Attribute_Category => l_rcv_details_rec.attribute_category,
X_Attribute1 => l_rcv_details_rec.attribute1,
X_Attribute2 => l_rcv_details_rec.attribute2,
X_Attribute3 => l_rcv_details_rec.attribute3,
X_Attribute4 => l_rcv_details_rec.attribute4,
X_Attribute5 => l_rcv_details_rec.attribute5,
X_Attribute6 => l_rcv_details_rec.attribute6,
X_Attribute7 => l_rcv_details_rec.attribute7,
X_Attribute8 => l_rcv_details_rec.attribute8,
X_Attribute9 => l_rcv_details_rec.attribute9,
X_Attribute10 => l_rcv_details_rec.attribute10,
X_Attribute11 => l_rcv_details_rec.attribute11,
X_Attribute12 => l_rcv_details_rec.attribute12,
X_Attribute13 => l_rcv_details_rec.attribute13,
X_Attribute14 => l_rcv_details_rec.attribute14,
X_Attribute15 => l_rcv_details_rec.attribute15,
X_Ship_Head_Attribute_Category => NULL,
X_Ship_Head_Attribute1 => NULL,
X_Ship_Head_Attribute2 => NULL,
X_Ship_Head_Attribute3 => NULL,
X_Ship_Head_Attribute4 => NULL,
X_Ship_Head_Attribute5 => NULL,
X_Ship_Head_Attribute6 => NULL,
X_Ship_Head_Attribute7 => NULL,
X_Ship_Head_Attribute8 => NULL,
X_Ship_Head_Attribute9 => NULL,
X_Ship_Head_Attribute10 => NULL,
X_Ship_Head_Attribute11 => NULL,
X_Ship_Head_Attribute12 => NULL,
X_Ship_Head_Attribute13 => NULL,
X_Ship_Head_Attribute14 => NULL,
X_Ship_Head_Attribute15 => NULL,
X_Ship_Line_Attribute_Category => NULL,
X_Ship_Line_Attribute1 => NULL,
X_Ship_Line_Attribute2 => NULL,
X_Ship_Line_Attribute3 => NULL,
X_Ship_Line_Attribute4 => NULL,
X_Ship_Line_Attribute5 => NULL,
X_Ship_Line_Attribute6 => NULL,
X_Ship_Line_Attribute7 => NULL,
X_Ship_Line_Attribute8 => NULL,
X_Ship_Line_Attribute9 => NULL,
X_Ship_Line_Attribute10 => NULL,
X_Ship_Line_Attribute11 => NULL,
X_Ship_Line_Attribute12 => NULL,
X_Ship_Line_Attribute13 => NULL,
X_Ship_Line_Attribute14 => NULL,
X_Ship_Line_Attribute15 => NULL,
X_Ussgl_Transaction_Code => NULL,
X_Government_Context => l_rcv_details_rec.government_context,
X_Reason_Id => NULL,
X_Destination_Context => NULL,
X_Source_Doc_Quantity => p_receipt_quantity,
X_Source_Doc_Unit_Of_Measure => l_rcv_details_rec.primary_uom,
X_Lot_Number_CC => l_rcv_details_rec.lot_control_code,
X_Serial_Number_CC => l_rcv_details_rec.serial_number_control_code,
X_QA_Collection_Id => NULL,
X_Country_of_Origin_Code => l_rcv_details_rec.country_of_origin_code,
X_oe_order_header_id => NULL,
X_oe_order_line_id => NULL,
X_customer_item_num => NULL,
X_customer_id => NULL,
X_customer_site_id => NULL,
X_put_away_rule_id => NULL,
X_put_away_strategy_id => NULL,
X_lpn_id => NULL,
X_transfer_lpn_id => NULL,
X_secondary_quantity => l_rcv_details_rec.secondary_quantity,
X_secondary_unit_of_measure => l_rcv_details_rec.secondary_uom,
p_org_id => l_rcv_details_rec.org_id
);
'After rcv_trx_interface_insert_pkg.insert_row: ' ||
'l_interface_transaction_id = ' || l_interface_transaction_id);
SELECT rsl.category_id,
rsl.quantity_shipped - rsl.quantity_received quantity,
rsl.item_id,
rsl.item_description,
rsl.item_revision,
muom.uom_code,
rsl.shipment_header_id,
rsl.shipment_line_id,
rsl.ship_to_location_id,
rsl.primary_unit_of_measure,
rsl.from_organization_id,
rsl.to_organization_id,
rsl.routing_header_id,
rsl.source_document_code,
rsl.requisition_line_id,
rsl.req_distribution_id,
rsl.charge_account_id,
rsl.destination_type_code,
rsl.deliver_to_person_id,
rsl.deliver_to_location_id,
rsl.to_subinventory,
rsl.locator_id,
rsl.packing_slip,
rsl.transfer_cost,
rsl.transportation_cost,
rsl.transportation_account_id,
rsl.comments,
rsl.attribute_category,
rsl.attribute1,
rsl.attribute2,
rsl.attribute3,
rsl.attribute4,
rsl.attribute5,
rsl.attribute6,
rsl.attribute7,
rsl.attribute8,
rsl.attribute9,
rsl.attribute10,
rsl.attribute11,
rsl.attribute12,
rsl.attribute13,
rsl.attribute14,
rsl.attribute15,
rsl.ussgl_transaction_code,
rsl.government_context,
rsl.reason_id,
rsl.destination_context,
msi.lot_control_code,
msi.serial_number_control_code,
rsl.country_of_origin_code,
rsl.cost_group_id,
porl.org_id
FROM rcv_shipment_lines rsl,
po_requisition_lines_all porl,
mtl_system_items msi,
mtl_units_of_measure muom,
mtl_kanban_cards mkc,
mtl_kanban_card_activity mkca
WHERE rsl.requisition_line_id = porl.requisition_line_id
AND rsl.requisition_line_id = mkca.document_detail_id
AND msi.inventory_item_id = mkc.inventory_item_id
AND msi.organization_id = mkc.organization_id
AND muom.unit_of_measure = msi.primary_unit_of_measure
AND mkca.kanban_card_id = mkc.kanban_card_id
AND mkca.replenishment_cycle_id = mkc.current_replnsh_cycle_id
AND mkc.kanban_card_id = p_kanban_card_id
AND rsl.shipment_line_status_code IN ('EXPECTED', 'PARTIALLY RECEIVED')
ORDER BY rsl.shipment_header_id, rsl.line_num;
SELECT rowid,
shipment_header_id,
receipt_source_code,
vendor_id,
vendor_site_Id,
organization_Id,
ship_to_org_id,
shipment_num,
receipt_num,
ship_to_location_id,
bill_of_lading,
packing_slip,
shipped_date,
freight_carrier_code,
expected_receipt_date,
num_of_containers,
waybill_airbill_num,
comments,
attribute_category,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15,
ussgl_transaction_code,
government_context,
request_id,
program_application_id,
program_id,
customer_id,
customer_site_id
FROM rcv_shipment_headers
WHERE shipment_header_id = p_shipment_header_id;
SELECT TO_CHAR(next_receipt_num + 1)
INTO l_temp_receipt_num
FROM rcv_parameters
WHERE organization_id = l_ship_header_rec.ship_to_org_id
FOR UPDATE OF next_receipt_num;
SELECT COUNT(*)
INTO l_receipt_exists
FROM rcv_shipment_headers rsh
WHERE receipt_num = l_temp_receipt_num
AND ship_to_org_id = l_ship_header_rec.ship_to_org_id;
UPDATE rcv_parameters
SET next_receipt_num = l_temp_receipt_num
WHERE organization_id = l_ship_header_rec.ship_to_org_id;
'Calling rcv_shipment_headers_pkg.update_row');
rcv_shipment_headers_pkg.update_row
( X_Rowid => l_ship_header_rec.rowid,
X_Shipment_Header_Id => l_ship_header_rec.shipment_header_id,
X_Last_Update_Date => SYSDATE,
X_Last_Updated_By => FND_GLOBAL.USER_ID,
X_Last_Update_Login => FND_GLOBAL.LOGIN_ID,
X_Receipt_Source_Code => l_ship_header_rec.receipt_source_code,
X_Vendor_Id => l_ship_header_rec.vendor_id,
X_Vendor_Site_Id => l_ship_header_rec.vendor_site_id,
X_Organization_Id => l_ship_header_rec.organization_Id,
X_ship_to_org_id => l_ship_header_rec.ship_to_org_id,
X_Shipment_Num => l_ship_header_rec.shipment_num,
X_Receipt_Num => x_receipt_num,
X_Ship_To_Location_Id => l_ship_header_rec.ship_to_location_id,
X_Bill_Of_Lading => l_ship_header_rec.bill_of_lading,
X_Packing_Slip => l_ship_header_rec.packing_slip,
X_Shipped_Date => l_ship_header_rec.shipped_date,
X_Freight_Carrier_Code => l_ship_header_rec.freight_carrier_code,
X_Expected_Receipt_Date => l_ship_header_rec.expected_receipt_date,
X_Employee_Id => l_employee_id,
X_Num_Of_Containers => l_ship_header_rec.num_of_containers,
X_Waybill_Airbill_Num => l_ship_header_rec.waybill_airbill_num,
X_Comments => l_ship_header_rec.comments,
X_Attribute_Category => l_ship_header_rec.attribute_category,
X_Attribute1 => l_ship_header_rec.attribute1,
X_Attribute2 => l_ship_header_rec.attribute2,
X_Attribute3 => l_ship_header_rec.attribute3,
X_Attribute4 => l_ship_header_rec.attribute4,
X_Attribute5 => l_ship_header_rec.attribute5,
X_Attribute6 => l_ship_header_rec.attribute6,
X_Attribute7 => l_ship_header_rec.attribute7,
X_Attribute8 => l_ship_header_rec.attribute8,
X_Attribute9 => l_ship_header_rec.attribute9,
X_Attribute10 => l_ship_header_rec.attribute10,
X_Attribute11 => l_ship_header_rec.attribute11,
X_Attribute12 => l_ship_header_rec.attribute12,
X_Attribute13 => l_ship_header_rec.attribute13,
X_Attribute14 => l_ship_header_rec.attribute14,
X_Attribute15 => l_ship_header_rec.attribute15,
X_Ussgl_Transaction_Code => l_ship_header_rec.ussgl_transaction_code,
X_Government_Context => l_ship_header_rec.government_context,
X_Request_Id => l_ship_header_rec.request_id,
X_Program_Application_Id => l_ship_header_rec.program_application_id,
X_Program_Id => l_ship_header_rec.program_id,
X_Program_Update_Date => SYSDATE,
X_customer_id => l_ship_header_rec.customer_id,
X_customer_site_id => l_ship_header_rec.customer_site_id
);
'Before rcv_trx_interface_insert_pkg.insert_row');
rcv_trx_interface_insert_pkg.insert_row
( X_Rowid => l_rowid,
X_Interface_Transaction_Id => l_interface_transaction_id,
X_Group_Id => l_group_id,
X_Last_Update_Date => SYSDATE,
X_Last_Updated_By => FND_GLOBAL.USER_ID,
X_Creation_Date => SYSDATE,
X_Created_By => FND_GLOBAL.USER_ID,
X_Last_Update_Login => FND_GLOBAL.LOGIN_ID,
X_Transaction_Type => 'RECEIVE',
X_Transaction_Date => SYSDATE,
X_Processing_Status_Code => 'PENDING',
X_Processing_Mode_Code => 'ONLINE',
X_Processing_Request_Id => NULL,
X_Transaction_Status_Code => 'PENDING',
X_Category_Id => l_ship_line_rec.category_id,
X_Quantity => l_quantity,
X_Unit_Of_Measure => l_ship_line_rec.primary_unit_of_measure,
X_Interface_Source_Code => 'FLM',
X_Interface_Source_Line_Id => NULL,
X_Inv_Transaction_Id => NULL,
X_Item_Id => l_ship_line_rec.item_id,
X_Item_Description => l_ship_line_rec.item_description,
X_Item_Revision => l_ship_line_rec.item_revision,
X_Uom_Code => l_ship_line_rec.uom_code,
X_Employee_Id => l_employee_id,
X_Auto_Transact_Code => 'DELIVER',
X_Shipment_Header_Id => l_ship_line_rec.shipment_header_id,
X_Shipment_Line_Id => l_ship_line_rec.shipment_line_id,
X_Ship_To_Location_Id => l_ship_line_rec.ship_to_location_id,
X_Primary_Quantity => l_quantity,
X_Primary_Unit_Of_Measure => l_ship_line_rec.primary_unit_of_measure,
X_Receipt_Source_Code => l_ship_header_rec.receipt_source_code,
X_Vendor_Id => NULL,
X_Vendor_Site_Id => NULL,
X_From_Organization_Id => l_ship_line_rec.from_organization_id,
X_To_Organization_Id => l_ship_line_rec.to_organization_id,
X_Routing_Header_Id => l_ship_line_rec.routing_header_id,
X_Routing_Step_Id => 1,
X_Source_Document_Code => l_ship_line_rec.source_document_code,
X_Parent_Transaction_Id => NULL,
X_Po_Header_Id => NULL,
X_Po_Revision_Num => NULL,
X_Po_Release_Id => NULL,
X_Po_Line_Id => NULL,
X_Po_Line_Location_Id => NULL,
X_Po_Unit_Price => NULL,
X_Currency_Code => NULL,
X_Currency_Conversion_Type => NULL,
X_Currency_Conversion_Rate => NULL,
X_Currency_Conversion_Date => NULL,
X_Po_Distribution_Id => NULL,
X_Requisition_Line_Id => l_ship_line_rec.requisition_line_id,
X_Req_Distribution_Id => l_ship_line_rec.req_distribution_id,
X_Charge_Account_Id => l_ship_line_rec.charge_account_id,
X_Substitute_Unordered_Code => NULL,
X_Receipt_Exception_Flag => NULL,
X_Accrual_Status_Code => NULL,
X_Inspection_Status_Code => 'NOT INSPECTED',
X_Inspection_Quality_Code => NULL,
X_Destination_Type_Code => l_ship_line_rec.destination_type_code,
X_Deliver_To_Person_Id => l_ship_line_rec.deliver_to_person_id,
X_Location_Id => l_ship_line_rec.deliver_to_location_id,
X_Deliver_To_Location_Id => l_ship_line_rec.deliver_to_location_id,
X_Subinventory => l_ship_line_rec.to_subinventory,
X_Locator_Id => l_ship_line_rec.locator_id,
X_Wip_Entity_Id => NULL,
X_Wip_Line_Id => NULL,
X_Department_Code => NULL,
X_Wip_Repetitive_Schedule_Id => NULL,
X_Wip_Operation_Seq_Num => NULL,
X_Wip_Resource_Seq_Num => NULL,
X_Bom_Resource_Id => NULL,
X_Shipment_Num => l_ship_header_rec.shipment_num,
X_Freight_Carrier_Code => l_ship_header_rec.freight_carrier_code,
X_Bill_Of_Lading => l_ship_header_rec.bill_of_lading,
X_Packing_Slip => l_ship_line_rec.packing_slip,
X_Shipped_Date => l_ship_header_rec.shipped_date,
X_Expected_Receipt_Date => l_ship_header_rec.expected_receipt_date,
X_Actual_Cost => NULL,
X_Transfer_Cost => l_ship_line_rec.transfer_cost,
X_Transportation_Cost => l_ship_line_rec.transportation_cost,
X_Transportation_Account_Id => l_ship_line_rec.transportation_account_id,
X_Num_Of_Containers => l_ship_header_rec.num_of_containers,
X_Waybill_Airbill_Num => l_ship_header_rec.waybill_airbill_num,
X_Vendor_Item_Num => NULL,
X_Vendor_Lot_Num => NULL,
X_Rma_Reference => NULL,
X_Comments => l_ship_line_rec.comments,
X_Attribute_Category => l_ship_line_rec.attribute_category,
X_Attribute1 => l_ship_line_rec.attribute1,
X_Attribute2 => l_ship_line_rec.attribute2,
X_Attribute3 => l_ship_line_rec.attribute3,
X_Attribute4 => l_ship_line_rec.attribute4,
X_Attribute5 => l_ship_line_rec.attribute5,
X_Attribute6 => l_ship_line_rec.attribute6,
X_Attribute7 => l_ship_line_rec.attribute7,
X_Attribute8 => l_ship_line_rec.attribute8,
X_Attribute9 => l_ship_line_rec.attribute9,
X_Attribute10 => l_ship_line_rec.attribute10,
X_Attribute11 => l_ship_line_rec.attribute11,
X_Attribute12 => l_ship_line_rec.attribute12,
X_Attribute13 => l_ship_line_rec.attribute13,
X_Attribute14 => l_ship_line_rec.attribute14,
X_Attribute15 => l_ship_line_rec.attribute15,
X_Ship_Head_Attribute_Category => NULL,
X_Ship_Head_Attribute1 => NULL,
X_Ship_Head_Attribute2 => NULL,
X_Ship_Head_Attribute3 => NULL,
X_Ship_Head_Attribute4 => NULL,
X_Ship_Head_Attribute5 => NULL,
X_Ship_Head_Attribute6 => NULL,
X_Ship_Head_Attribute7 => NULL,
X_Ship_Head_Attribute8 => NULL,
X_Ship_Head_Attribute9 => NULL,
X_Ship_Head_Attribute10 => NULL,
X_Ship_Head_Attribute11 => NULL,
X_Ship_Head_Attribute12 => NULL,
X_Ship_Head_Attribute13 => NULL,
X_Ship_Head_Attribute14 => NULL,
X_Ship_Head_Attribute15 => NULL,
X_Ship_Line_Attribute_Category => NULL,
X_Ship_Line_Attribute1 => NULL,
X_Ship_Line_Attribute2 => NULL,
X_Ship_Line_Attribute3 => NULL,
X_Ship_Line_Attribute4 => NULL,
X_Ship_Line_Attribute5 => NULL,
X_Ship_Line_Attribute6 => NULL,
X_Ship_Line_Attribute7 => NULL,
X_Ship_Line_Attribute8 => NULL,
X_Ship_Line_Attribute9 => NULL,
X_Ship_Line_Attribute10 => NULL,
X_Ship_Line_Attribute11 => NULL,
X_Ship_Line_Attribute12 => NULL,
X_Ship_Line_Attribute13 => NULL,
X_Ship_Line_Attribute14 => NULL,
X_Ship_Line_Attribute15 => NULL,
X_Ussgl_Transaction_Code => l_ship_line_rec.ussgl_transaction_code,
X_Government_Context => l_ship_line_rec.government_context,
X_Reason_Id => l_ship_line_rec.reason_id,
X_Destination_Context => l_ship_line_rec.destination_context,
X_Source_Doc_Quantity => l_quantity,
X_Source_Doc_Unit_Of_Measure => l_ship_line_rec.primary_unit_of_measure,
X_Lot_Number_CC => l_ship_line_rec.lot_control_code,
X_Serial_Number_CC => l_ship_line_rec.serial_number_control_code,
X_QA_Collection_Id => NULL,
X_Country_of_Origin_Code => l_ship_line_rec.country_of_origin_code,
X_oe_order_header_id => NULL,
X_oe_order_line_id => NULL,
X_customer_item_num => NULL,
X_customer_id => NULL,
X_customer_site_id => NULL,
X_put_away_rule_id => NULL,
X_put_away_strategy_id => NULL,
X_lpn_id => NULL,
X_transfer_lpn_id => NULL,
X_cost_group_id => l_ship_line_rec.cost_group_id,
p_org_id => l_ship_line_rec.org_id
);
'After rcv_trx_interface_insert_pkg.insert_row: ' ||
'l_interface_transaction_id = ' || l_interface_transaction_id);
SELECT source_type
FROM mtl_kanban_cards
WHERE kanban_card_id = p_kanban_card_id;