22: */
23:
24: TYPE TRANS_REC_TYPE IS RECORD
25: (
26: TRANSACTION_ID mtl_material_transactions.transaction_id%TYPE
27: , TRANSACTION_SOURCE_TYPE_ID mtl_material_transactions.transaction_source_type_id%TYPE
28: , TRANSACTION_ACTION_ID mtl_material_transactions.transaction_action_id%TYPE
29: , TRANSACTION_TYPE_ID mtl_material_transactions.transaction_type_id%TYPE
30: , INVENTORY_ITEM_ID mtl_material_transactions.inventory_item_id%TYPE
23:
24: TYPE TRANS_REC_TYPE IS RECORD
25: (
26: TRANSACTION_ID mtl_material_transactions.transaction_id%TYPE
27: , TRANSACTION_SOURCE_TYPE_ID mtl_material_transactions.transaction_source_type_id%TYPE
28: , TRANSACTION_ACTION_ID mtl_material_transactions.transaction_action_id%TYPE
29: , TRANSACTION_TYPE_ID mtl_material_transactions.transaction_type_id%TYPE
30: , INVENTORY_ITEM_ID mtl_material_transactions.inventory_item_id%TYPE
31: , ORGANIZATION_ID mtl_material_transactions.organization_id%TYPE
24: TYPE TRANS_REC_TYPE IS RECORD
25: (
26: TRANSACTION_ID mtl_material_transactions.transaction_id%TYPE
27: , TRANSACTION_SOURCE_TYPE_ID mtl_material_transactions.transaction_source_type_id%TYPE
28: , TRANSACTION_ACTION_ID mtl_material_transactions.transaction_action_id%TYPE
29: , TRANSACTION_TYPE_ID mtl_material_transactions.transaction_type_id%TYPE
30: , INVENTORY_ITEM_ID mtl_material_transactions.inventory_item_id%TYPE
31: , ORGANIZATION_ID mtl_material_transactions.organization_id%TYPE
32: , LOT_NUMBER mtl_transaction_lot_numbers.lot_number%TYPE
25: (
26: TRANSACTION_ID mtl_material_transactions.transaction_id%TYPE
27: , TRANSACTION_SOURCE_TYPE_ID mtl_material_transactions.transaction_source_type_id%TYPE
28: , TRANSACTION_ACTION_ID mtl_material_transactions.transaction_action_id%TYPE
29: , TRANSACTION_TYPE_ID mtl_material_transactions.transaction_type_id%TYPE
30: , INVENTORY_ITEM_ID mtl_material_transactions.inventory_item_id%TYPE
31: , ORGANIZATION_ID mtl_material_transactions.organization_id%TYPE
32: , LOT_NUMBER mtl_transaction_lot_numbers.lot_number%TYPE
33: , TRANSACTION_DATE mtl_material_transactions.transaction_date%TYPE
26: TRANSACTION_ID mtl_material_transactions.transaction_id%TYPE
27: , TRANSACTION_SOURCE_TYPE_ID mtl_material_transactions.transaction_source_type_id%TYPE
28: , TRANSACTION_ACTION_ID mtl_material_transactions.transaction_action_id%TYPE
29: , TRANSACTION_TYPE_ID mtl_material_transactions.transaction_type_id%TYPE
30: , INVENTORY_ITEM_ID mtl_material_transactions.inventory_item_id%TYPE
31: , ORGANIZATION_ID mtl_material_transactions.organization_id%TYPE
32: , LOT_NUMBER mtl_transaction_lot_numbers.lot_number%TYPE
33: , TRANSACTION_DATE mtl_material_transactions.transaction_date%TYPE
34: , PRIMARY_QUANTITY mtl_material_transactions.primary_quantity%TYPE
27: , TRANSACTION_SOURCE_TYPE_ID mtl_material_transactions.transaction_source_type_id%TYPE
28: , TRANSACTION_ACTION_ID mtl_material_transactions.transaction_action_id%TYPE
29: , TRANSACTION_TYPE_ID mtl_material_transactions.transaction_type_id%TYPE
30: , INVENTORY_ITEM_ID mtl_material_transactions.inventory_item_id%TYPE
31: , ORGANIZATION_ID mtl_material_transactions.organization_id%TYPE
32: , LOT_NUMBER mtl_transaction_lot_numbers.lot_number%TYPE
33: , TRANSACTION_DATE mtl_material_transactions.transaction_date%TYPE
34: , PRIMARY_QUANTITY mtl_material_transactions.primary_quantity%TYPE
35: , PRIMARY_UOM mtl_system_items_b.primary_uom_code%TYPE
29: , TRANSACTION_TYPE_ID mtl_material_transactions.transaction_type_id%TYPE
30: , INVENTORY_ITEM_ID mtl_material_transactions.inventory_item_id%TYPE
31: , ORGANIZATION_ID mtl_material_transactions.organization_id%TYPE
32: , LOT_NUMBER mtl_transaction_lot_numbers.lot_number%TYPE
33: , TRANSACTION_DATE mtl_material_transactions.transaction_date%TYPE
34: , PRIMARY_QUANTITY mtl_material_transactions.primary_quantity%TYPE
35: , PRIMARY_UOM mtl_system_items_b.primary_uom_code%TYPE
36: , DOC_QTY NUMBER
37: , DOC_UOM gme_material_details.dtl_um%TYPE
30: , INVENTORY_ITEM_ID mtl_material_transactions.inventory_item_id%TYPE
31: , ORGANIZATION_ID mtl_material_transactions.organization_id%TYPE
32: , LOT_NUMBER mtl_transaction_lot_numbers.lot_number%TYPE
33: , TRANSACTION_DATE mtl_material_transactions.transaction_date%TYPE
34: , PRIMARY_QUANTITY mtl_material_transactions.primary_quantity%TYPE
35: , PRIMARY_UOM mtl_system_items_b.primary_uom_code%TYPE
36: , DOC_QTY NUMBER
37: , DOC_UOM gme_material_details.dtl_um%TYPE
38: , TRANSACTION_SOURCE_ID mtl_material_transactions.transaction_source_id%TYPE
34: , PRIMARY_QUANTITY mtl_material_transactions.primary_quantity%TYPE
35: , PRIMARY_UOM mtl_system_items_b.primary_uom_code%TYPE
36: , DOC_QTY NUMBER
37: , DOC_UOM gme_material_details.dtl_um%TYPE
38: , TRANSACTION_SOURCE_ID mtl_material_transactions.transaction_source_id%TYPE
39: , TRX_SOURCE_LINE_ID mtl_material_transactions.trx_source_line_id%TYPE
40: , REVERSE_ID mtl_material_transactions.source_line_id%TYPE
41: , LINE_TYPE gme_material_details.line_type%TYPE
42: , LAST_UPDATED_BY mtl_material_transactions.last_updated_by%TYPE
35: , PRIMARY_UOM mtl_system_items_b.primary_uom_code%TYPE
36: , DOC_QTY NUMBER
37: , DOC_UOM gme_material_details.dtl_um%TYPE
38: , TRANSACTION_SOURCE_ID mtl_material_transactions.transaction_source_id%TYPE
39: , TRX_SOURCE_LINE_ID mtl_material_transactions.trx_source_line_id%TYPE
40: , REVERSE_ID mtl_material_transactions.source_line_id%TYPE
41: , LINE_TYPE gme_material_details.line_type%TYPE
42: , LAST_UPDATED_BY mtl_material_transactions.last_updated_by%TYPE
43: , CREATED_BY mtl_material_transactions.created_by%TYPE
36: , DOC_QTY NUMBER
37: , DOC_UOM gme_material_details.dtl_um%TYPE
38: , TRANSACTION_SOURCE_ID mtl_material_transactions.transaction_source_id%TYPE
39: , TRX_SOURCE_LINE_ID mtl_material_transactions.trx_source_line_id%TYPE
40: , REVERSE_ID mtl_material_transactions.source_line_id%TYPE
41: , LINE_TYPE gme_material_details.line_type%TYPE
42: , LAST_UPDATED_BY mtl_material_transactions.last_updated_by%TYPE
43: , CREATED_BY mtl_material_transactions.created_by%TYPE
44: , LAST_UPDATE_LOGIN mtl_material_transactions.last_update_login%TYPE
38: , TRANSACTION_SOURCE_ID mtl_material_transactions.transaction_source_id%TYPE
39: , TRX_SOURCE_LINE_ID mtl_material_transactions.trx_source_line_id%TYPE
40: , REVERSE_ID mtl_material_transactions.source_line_id%TYPE
41: , LINE_TYPE gme_material_details.line_type%TYPE
42: , LAST_UPDATED_BY mtl_material_transactions.last_updated_by%TYPE
43: , CREATED_BY mtl_material_transactions.created_by%TYPE
44: , LAST_UPDATE_LOGIN mtl_material_transactions.last_update_login%TYPE
45: );
46:
39: , TRX_SOURCE_LINE_ID mtl_material_transactions.trx_source_line_id%TYPE
40: , REVERSE_ID mtl_material_transactions.source_line_id%TYPE
41: , LINE_TYPE gme_material_details.line_type%TYPE
42: , LAST_UPDATED_BY mtl_material_transactions.last_updated_by%TYPE
43: , CREATED_BY mtl_material_transactions.created_by%TYPE
44: , LAST_UPDATE_LOGIN mtl_material_transactions.last_update_login%TYPE
45: );
46:
47: PROCEDURE Create_Incoming_Layers
40: , REVERSE_ID mtl_material_transactions.source_line_id%TYPE
41: , LINE_TYPE gme_material_details.line_type%TYPE
42: , LAST_UPDATED_BY mtl_material_transactions.last_updated_by%TYPE
43: , CREATED_BY mtl_material_transactions.created_by%TYPE
44: , LAST_UPDATE_LOGIN mtl_material_transactions.last_update_login%TYPE
45: );
46:
47: PROCEDURE Create_Incoming_Layers
48: ( p_api_version IN NUMBER,