14: G_TXN_ERROR CONSTANT VARCHAR2(1) := 'E';
15: G_IN_WIP CONSTANT VARCHAR2(30) := 'IN_WIP';
16:
17: TYPE MTL_ITEM_REC_TYPE IS RECORD
18: ( INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
19: ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
20: SUBINVENTORY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
21: REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,
22: TRANSACTION_QUANTITY NUMBER := FND_API.G_MISS_NUM,
15: G_IN_WIP CONSTANT VARCHAR2(30) := 'IN_WIP';
16:
17: TYPE MTL_ITEM_REC_TYPE IS RECORD
18: ( INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
19: ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
20: SUBINVENTORY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
21: REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,
22: TRANSACTION_QUANTITY NUMBER := FND_API.G_MISS_NUM,
23: PRIMARY_QUANTITY NUMBER := FND_API.G_MISS_NUM,
16:
17: TYPE MTL_ITEM_REC_TYPE IS RECORD
18: ( INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
19: ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
20: SUBINVENTORY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
21: REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,
22: TRANSACTION_QUANTITY NUMBER := FND_API.G_MISS_NUM,
23: PRIMARY_QUANTITY NUMBER := FND_API.G_MISS_NUM,
24: TRANSACTION_UOM VARCHAR2(3) := FND_API.G_MISS_CHAR,
17: TYPE MTL_ITEM_REC_TYPE IS RECORD
18: ( INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
19: ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
20: SUBINVENTORY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
21: REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,
22: TRANSACTION_QUANTITY NUMBER := FND_API.G_MISS_NUM,
23: PRIMARY_QUANTITY NUMBER := FND_API.G_MISS_NUM,
24: TRANSACTION_UOM VARCHAR2(3) := FND_API.G_MISS_CHAR,
25: PRIMARY_UOM_CODE VARCHAR2(3) := FND_API.G_MISS_CHAR,
18: ( INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
19: ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
20: SUBINVENTORY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
21: REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,
22: TRANSACTION_QUANTITY NUMBER := FND_API.G_MISS_NUM,
23: PRIMARY_QUANTITY NUMBER := FND_API.G_MISS_NUM,
24: TRANSACTION_UOM VARCHAR2(3) := FND_API.G_MISS_CHAR,
25: PRIMARY_UOM_CODE VARCHAR2(3) := FND_API.G_MISS_CHAR,
26: TRANSACTION_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
19: ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
20: SUBINVENTORY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
21: REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,
22: TRANSACTION_QUANTITY NUMBER := FND_API.G_MISS_NUM,
23: PRIMARY_QUANTITY NUMBER := FND_API.G_MISS_NUM,
24: TRANSACTION_UOM VARCHAR2(3) := FND_API.G_MISS_CHAR,
25: PRIMARY_UOM_CODE VARCHAR2(3) := FND_API.G_MISS_CHAR,
26: TRANSACTION_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
27: TRANSACTION_ACTION_ID NUMBER := FND_API.G_MISS_NUM,
20: SUBINVENTORY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
21: REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,
22: TRANSACTION_QUANTITY NUMBER := FND_API.G_MISS_NUM,
23: PRIMARY_QUANTITY NUMBER := FND_API.G_MISS_NUM,
24: TRANSACTION_UOM VARCHAR2(3) := FND_API.G_MISS_CHAR,
25: PRIMARY_UOM_CODE VARCHAR2(3) := FND_API.G_MISS_CHAR,
26: TRANSACTION_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
27: TRANSACTION_ACTION_ID NUMBER := FND_API.G_MISS_NUM,
28: TRANSACTION_SOURCE_ID NUMBER := FND_API.G_MISS_NUM,
21: REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,
22: TRANSACTION_QUANTITY NUMBER := FND_API.G_MISS_NUM,
23: PRIMARY_QUANTITY NUMBER := FND_API.G_MISS_NUM,
24: TRANSACTION_UOM VARCHAR2(3) := FND_API.G_MISS_CHAR,
25: PRIMARY_UOM_CODE VARCHAR2(3) := FND_API.G_MISS_CHAR,
26: TRANSACTION_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
27: TRANSACTION_ACTION_ID NUMBER := FND_API.G_MISS_NUM,
28: TRANSACTION_SOURCE_ID NUMBER := FND_API.G_MISS_NUM,
29: TRANSACTION_SOURCE_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
22: TRANSACTION_QUANTITY NUMBER := FND_API.G_MISS_NUM,
23: PRIMARY_QUANTITY NUMBER := FND_API.G_MISS_NUM,
24: TRANSACTION_UOM VARCHAR2(3) := FND_API.G_MISS_CHAR,
25: PRIMARY_UOM_CODE VARCHAR2(3) := FND_API.G_MISS_CHAR,
26: TRANSACTION_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
27: TRANSACTION_ACTION_ID NUMBER := FND_API.G_MISS_NUM,
28: TRANSACTION_SOURCE_ID NUMBER := FND_API.G_MISS_NUM,
29: TRANSACTION_SOURCE_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
30: TRANSFER_LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
23: PRIMARY_QUANTITY NUMBER := FND_API.G_MISS_NUM,
24: TRANSACTION_UOM VARCHAR2(3) := FND_API.G_MISS_CHAR,
25: PRIMARY_UOM_CODE VARCHAR2(3) := FND_API.G_MISS_CHAR,
26: TRANSACTION_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
27: TRANSACTION_ACTION_ID NUMBER := FND_API.G_MISS_NUM,
28: TRANSACTION_SOURCE_ID NUMBER := FND_API.G_MISS_NUM,
29: TRANSACTION_SOURCE_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
30: TRANSFER_LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
31: TRANSFER_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
24: TRANSACTION_UOM VARCHAR2(3) := FND_API.G_MISS_CHAR,
25: PRIMARY_UOM_CODE VARCHAR2(3) := FND_API.G_MISS_CHAR,
26: TRANSACTION_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
27: TRANSACTION_ACTION_ID NUMBER := FND_API.G_MISS_NUM,
28: TRANSACTION_SOURCE_ID NUMBER := FND_API.G_MISS_NUM,
29: TRANSACTION_SOURCE_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
30: TRANSFER_LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
31: TRANSFER_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
32: TRANSFER_SUBINVENTORY VARCHAR2(10) := FND_API.G_MISS_CHAR,
25: PRIMARY_UOM_CODE VARCHAR2(3) := FND_API.G_MISS_CHAR,
26: TRANSACTION_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
27: TRANSACTION_ACTION_ID NUMBER := FND_API.G_MISS_NUM,
28: TRANSACTION_SOURCE_ID NUMBER := FND_API.G_MISS_NUM,
29: TRANSACTION_SOURCE_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
30: TRANSFER_LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
31: TRANSFER_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
32: TRANSFER_SUBINVENTORY VARCHAR2(10) := FND_API.G_MISS_CHAR,
33: LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
26: TRANSACTION_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
27: TRANSACTION_ACTION_ID NUMBER := FND_API.G_MISS_NUM,
28: TRANSACTION_SOURCE_ID NUMBER := FND_API.G_MISS_NUM,
29: TRANSACTION_SOURCE_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
30: TRANSFER_LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
31: TRANSFER_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
32: TRANSFER_SUBINVENTORY VARCHAR2(10) := FND_API.G_MISS_CHAR,
33: LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
34: SOURCE_PROJECT_ID NUMBER := FND_API.G_MISS_NUM,
27: TRANSACTION_ACTION_ID NUMBER := FND_API.G_MISS_NUM,
28: TRANSACTION_SOURCE_ID NUMBER := FND_API.G_MISS_NUM,
29: TRANSACTION_SOURCE_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
30: TRANSFER_LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
31: TRANSFER_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
32: TRANSFER_SUBINVENTORY VARCHAR2(10) := FND_API.G_MISS_CHAR,
33: LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
34: SOURCE_PROJECT_ID NUMBER := FND_API.G_MISS_NUM,
35: SOURCE_TASK_ID NUMBER := FND_API.G_MISS_NUM,
28: TRANSACTION_SOURCE_ID NUMBER := FND_API.G_MISS_NUM,
29: TRANSACTION_SOURCE_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
30: TRANSFER_LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
31: TRANSFER_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
32: TRANSFER_SUBINVENTORY VARCHAR2(10) := FND_API.G_MISS_CHAR,
33: LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
34: SOURCE_PROJECT_ID NUMBER := FND_API.G_MISS_NUM,
35: SOURCE_TASK_ID NUMBER := FND_API.G_MISS_NUM,
36: FROM_PROJECT_ID NUMBER := FND_API.G_MISS_NUM,
29: TRANSACTION_SOURCE_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
30: TRANSFER_LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
31: TRANSFER_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
32: TRANSFER_SUBINVENTORY VARCHAR2(10) := FND_API.G_MISS_CHAR,
33: LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
34: SOURCE_PROJECT_ID NUMBER := FND_API.G_MISS_NUM,
35: SOURCE_TASK_ID NUMBER := FND_API.G_MISS_NUM,
36: FROM_PROJECT_ID NUMBER := FND_API.G_MISS_NUM,
37: FROM_TASK_ID NUMBER := FND_API.G_MISS_NUM,
30: TRANSFER_LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
31: TRANSFER_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
32: TRANSFER_SUBINVENTORY VARCHAR2(10) := FND_API.G_MISS_CHAR,
33: LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
34: SOURCE_PROJECT_ID NUMBER := FND_API.G_MISS_NUM,
35: SOURCE_TASK_ID NUMBER := FND_API.G_MISS_NUM,
36: FROM_PROJECT_ID NUMBER := FND_API.G_MISS_NUM,
37: FROM_TASK_ID NUMBER := FND_API.G_MISS_NUM,
38: TO_PROJECT_ID NUMBER := FND_API.G_MISS_NUM,
31: TRANSFER_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
32: TRANSFER_SUBINVENTORY VARCHAR2(10) := FND_API.G_MISS_CHAR,
33: LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
34: SOURCE_PROJECT_ID NUMBER := FND_API.G_MISS_NUM,
35: SOURCE_TASK_ID NUMBER := FND_API.G_MISS_NUM,
36: FROM_PROJECT_ID NUMBER := FND_API.G_MISS_NUM,
37: FROM_TASK_ID NUMBER := FND_API.G_MISS_NUM,
38: TO_PROJECT_ID NUMBER := FND_API.G_MISS_NUM,
39: TO_TASK_ID NUMBER := FND_API.G_MISS_NUM,
32: TRANSFER_SUBINVENTORY VARCHAR2(10) := FND_API.G_MISS_CHAR,
33: LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
34: SOURCE_PROJECT_ID NUMBER := FND_API.G_MISS_NUM,
35: SOURCE_TASK_ID NUMBER := FND_API.G_MISS_NUM,
36: FROM_PROJECT_ID NUMBER := FND_API.G_MISS_NUM,
37: FROM_TASK_ID NUMBER := FND_API.G_MISS_NUM,
38: TO_PROJECT_ID NUMBER := FND_API.G_MISS_NUM,
39: TO_TASK_ID NUMBER := FND_API.G_MISS_NUM,
40: TRANSACTION_DATE DATE := FND_API.G_MISS_DATE,
33: LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
34: SOURCE_PROJECT_ID NUMBER := FND_API.G_MISS_NUM,
35: SOURCE_TASK_ID NUMBER := FND_API.G_MISS_NUM,
36: FROM_PROJECT_ID NUMBER := FND_API.G_MISS_NUM,
37: FROM_TASK_ID NUMBER := FND_API.G_MISS_NUM,
38: TO_PROJECT_ID NUMBER := FND_API.G_MISS_NUM,
39: TO_TASK_ID NUMBER := FND_API.G_MISS_NUM,
40: TRANSACTION_DATE DATE := FND_API.G_MISS_DATE,
41: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
34: SOURCE_PROJECT_ID NUMBER := FND_API.G_MISS_NUM,
35: SOURCE_TASK_ID NUMBER := FND_API.G_MISS_NUM,
36: FROM_PROJECT_ID NUMBER := FND_API.G_MISS_NUM,
37: FROM_TASK_ID NUMBER := FND_API.G_MISS_NUM,
38: TO_PROJECT_ID NUMBER := FND_API.G_MISS_NUM,
39: TO_TASK_ID NUMBER := FND_API.G_MISS_NUM,
40: TRANSACTION_DATE DATE := FND_API.G_MISS_DATE,
41: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
42: SERIAL_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
35: SOURCE_TASK_ID NUMBER := FND_API.G_MISS_NUM,
36: FROM_PROJECT_ID NUMBER := FND_API.G_MISS_NUM,
37: FROM_TASK_ID NUMBER := FND_API.G_MISS_NUM,
38: TO_PROJECT_ID NUMBER := FND_API.G_MISS_NUM,
39: TO_TASK_ID NUMBER := FND_API.G_MISS_NUM,
40: TRANSACTION_DATE DATE := FND_API.G_MISS_DATE,
41: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
42: SERIAL_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
43: LOT_NUMBER VARCHAR2(80) := FND_API.G_MISS_CHAR, --bnarayan
36: FROM_PROJECT_ID NUMBER := FND_API.G_MISS_NUM,
37: FROM_TASK_ID NUMBER := FND_API.G_MISS_NUM,
38: TO_PROJECT_ID NUMBER := FND_API.G_MISS_NUM,
39: TO_TASK_ID NUMBER := FND_API.G_MISS_NUM,
40: TRANSACTION_DATE DATE := FND_API.G_MISS_DATE,
41: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
42: SERIAL_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
43: LOT_NUMBER VARCHAR2(80) := FND_API.G_MISS_CHAR, --bnarayan
44: HR_LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
37: FROM_TASK_ID NUMBER := FND_API.G_MISS_NUM,
38: TO_PROJECT_ID NUMBER := FND_API.G_MISS_NUM,
39: TO_TASK_ID NUMBER := FND_API.G_MISS_NUM,
40: TRANSACTION_DATE DATE := FND_API.G_MISS_DATE,
41: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
42: SERIAL_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
43: LOT_NUMBER VARCHAR2(80) := FND_API.G_MISS_CHAR, --bnarayan
44: HR_LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
45: PO_DISTRIBUTION_ID NUMBER := FND_API.G_MISS_NUM,
38: TO_PROJECT_ID NUMBER := FND_API.G_MISS_NUM,
39: TO_TASK_ID NUMBER := FND_API.G_MISS_NUM,
40: TRANSACTION_DATE DATE := FND_API.G_MISS_DATE,
41: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
42: SERIAL_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
43: LOT_NUMBER VARCHAR2(80) := FND_API.G_MISS_CHAR, --bnarayan
44: HR_LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
45: PO_DISTRIBUTION_ID NUMBER := FND_API.G_MISS_NUM,
46: SUBINV_LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
39: TO_TASK_ID NUMBER := FND_API.G_MISS_NUM,
40: TRANSACTION_DATE DATE := FND_API.G_MISS_DATE,
41: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
42: SERIAL_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
43: LOT_NUMBER VARCHAR2(80) := FND_API.G_MISS_CHAR, --bnarayan
44: HR_LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
45: PO_DISTRIBUTION_ID NUMBER := FND_API.G_MISS_NUM,
46: SUBINV_LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
47: SHIPMENT_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
40: TRANSACTION_DATE DATE := FND_API.G_MISS_DATE,
41: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
42: SERIAL_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
43: LOT_NUMBER VARCHAR2(80) := FND_API.G_MISS_CHAR, --bnarayan
44: HR_LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
45: PO_DISTRIBUTION_ID NUMBER := FND_API.G_MISS_NUM,
46: SUBINV_LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
47: SHIPMENT_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
48: TRX_SOURCE_LINE_ID NUMBER := FND_API.G_MISS_NUM,
41: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
42: SERIAL_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
43: LOT_NUMBER VARCHAR2(80) := FND_API.G_MISS_CHAR, --bnarayan
44: HR_LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
45: PO_DISTRIBUTION_ID NUMBER := FND_API.G_MISS_NUM,
46: SUBINV_LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
47: SHIPMENT_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
48: TRX_SOURCE_LINE_ID NUMBER := FND_API.G_MISS_NUM,
49: MOVE_ORDER_LINE_ID NUMBER := FND_API.G_MISS_NUM,
42: SERIAL_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
43: LOT_NUMBER VARCHAR2(80) := FND_API.G_MISS_CHAR, --bnarayan
44: HR_LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
45: PO_DISTRIBUTION_ID NUMBER := FND_API.G_MISS_NUM,
46: SUBINV_LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
47: SHIPMENT_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
48: TRX_SOURCE_LINE_ID NUMBER := FND_API.G_MISS_NUM,
49: MOVE_ORDER_LINE_ID NUMBER := FND_API.G_MISS_NUM,
50: SERIAL_NUMBER_CONTROL_CODE NUMBER := FND_API.G_MISS_NUM,
43: LOT_NUMBER VARCHAR2(80) := FND_API.G_MISS_CHAR, --bnarayan
44: HR_LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
45: PO_DISTRIBUTION_ID NUMBER := FND_API.G_MISS_NUM,
46: SUBINV_LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
47: SHIPMENT_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
48: TRX_SOURCE_LINE_ID NUMBER := FND_API.G_MISS_NUM,
49: MOVE_ORDER_LINE_ID NUMBER := FND_API.G_MISS_NUM,
50: SERIAL_NUMBER_CONTROL_CODE NUMBER := FND_API.G_MISS_NUM,
51: SHIP_TO_LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
44: HR_LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
45: PO_DISTRIBUTION_ID NUMBER := FND_API.G_MISS_NUM,
46: SUBINV_LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
47: SHIPMENT_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
48: TRX_SOURCE_LINE_ID NUMBER := FND_API.G_MISS_NUM,
49: MOVE_ORDER_LINE_ID NUMBER := FND_API.G_MISS_NUM,
50: SERIAL_NUMBER_CONTROL_CODE NUMBER := FND_API.G_MISS_NUM,
51: SHIP_TO_LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
52: LOT_CONTROL_CODE NUMBER := FND_API.G_MISS_NUM,
45: PO_DISTRIBUTION_ID NUMBER := FND_API.G_MISS_NUM,
46: SUBINV_LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
47: SHIPMENT_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
48: TRX_SOURCE_LINE_ID NUMBER := FND_API.G_MISS_NUM,
49: MOVE_ORDER_LINE_ID NUMBER := FND_API.G_MISS_NUM,
50: SERIAL_NUMBER_CONTROL_CODE NUMBER := FND_API.G_MISS_NUM,
51: SHIP_TO_LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
52: LOT_CONTROL_CODE NUMBER := FND_API.G_MISS_NUM,
53: REVISION_QTY_CONTROL_CODE NUMBER := FND_API.G_MISS_NUM,
46: SUBINV_LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
47: SHIPMENT_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
48: TRX_SOURCE_LINE_ID NUMBER := FND_API.G_MISS_NUM,
49: MOVE_ORDER_LINE_ID NUMBER := FND_API.G_MISS_NUM,
50: SERIAL_NUMBER_CONTROL_CODE NUMBER := FND_API.G_MISS_NUM,
51: SHIP_TO_LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
52: LOT_CONTROL_CODE NUMBER := FND_API.G_MISS_NUM,
53: REVISION_QTY_CONTROL_CODE NUMBER := FND_API.G_MISS_NUM,
54: COMMS_NL_TRACKABLE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
47: SHIPMENT_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
48: TRX_SOURCE_LINE_ID NUMBER := FND_API.G_MISS_NUM,
49: MOVE_ORDER_LINE_ID NUMBER := FND_API.G_MISS_NUM,
50: SERIAL_NUMBER_CONTROL_CODE NUMBER := FND_API.G_MISS_NUM,
51: SHIP_TO_LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
52: LOT_CONTROL_CODE NUMBER := FND_API.G_MISS_NUM,
53: REVISION_QTY_CONTROL_CODE NUMBER := FND_API.G_MISS_NUM,
54: COMMS_NL_TRACKABLE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
55: LOCATION_CONTROL_CODE NUMBER := FND_API.G_MISS_NUM,
48: TRX_SOURCE_LINE_ID NUMBER := FND_API.G_MISS_NUM,
49: MOVE_ORDER_LINE_ID NUMBER := FND_API.G_MISS_NUM,
50: SERIAL_NUMBER_CONTROL_CODE NUMBER := FND_API.G_MISS_NUM,
51: SHIP_TO_LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
52: LOT_CONTROL_CODE NUMBER := FND_API.G_MISS_NUM,
53: REVISION_QTY_CONTROL_CODE NUMBER := FND_API.G_MISS_NUM,
54: COMMS_NL_TRACKABLE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
55: LOCATION_CONTROL_CODE NUMBER := FND_API.G_MISS_NUM,
56: PHYSICAL_ADJUSTMENT_ID NUMBER := FND_API.G_MISS_NUM,
49: MOVE_ORDER_LINE_ID NUMBER := FND_API.G_MISS_NUM,
50: SERIAL_NUMBER_CONTROL_CODE NUMBER := FND_API.G_MISS_NUM,
51: SHIP_TO_LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
52: LOT_CONTROL_CODE NUMBER := FND_API.G_MISS_NUM,
53: REVISION_QTY_CONTROL_CODE NUMBER := FND_API.G_MISS_NUM,
54: COMMS_NL_TRACKABLE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
55: LOCATION_CONTROL_CODE NUMBER := FND_API.G_MISS_NUM,
56: PHYSICAL_ADJUSTMENT_ID NUMBER := FND_API.G_MISS_NUM,
57: CYCLE_COUNT_ID NUMBER := FND_API.G_MISS_NUM,
50: SERIAL_NUMBER_CONTROL_CODE NUMBER := FND_API.G_MISS_NUM,
51: SHIP_TO_LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
52: LOT_CONTROL_CODE NUMBER := FND_API.G_MISS_NUM,
53: REVISION_QTY_CONTROL_CODE NUMBER := FND_API.G_MISS_NUM,
54: COMMS_NL_TRACKABLE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
55: LOCATION_CONTROL_CODE NUMBER := FND_API.G_MISS_NUM,
56: PHYSICAL_ADJUSTMENT_ID NUMBER := FND_API.G_MISS_NUM,
57: CYCLE_COUNT_ID NUMBER := FND_API.G_MISS_NUM,
58: --R12 changes,Included to track rebuildables and asset numbers
51: SHIP_TO_LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
52: LOT_CONTROL_CODE NUMBER := FND_API.G_MISS_NUM,
53: REVISION_QTY_CONTROL_CODE NUMBER := FND_API.G_MISS_NUM,
54: COMMS_NL_TRACKABLE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
55: LOCATION_CONTROL_CODE NUMBER := FND_API.G_MISS_NUM,
56: PHYSICAL_ADJUSTMENT_ID NUMBER := FND_API.G_MISS_NUM,
57: CYCLE_COUNT_ID NUMBER := FND_API.G_MISS_NUM,
58: --R12 changes,Included to track rebuildables and asset numbers
59: EAM_ITEM_TYPE NUMBER := FND_API.G_MISS_NUM,
52: LOT_CONTROL_CODE NUMBER := FND_API.G_MISS_NUM,
53: REVISION_QTY_CONTROL_CODE NUMBER := FND_API.G_MISS_NUM,
54: COMMS_NL_TRACKABLE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
55: LOCATION_CONTROL_CODE NUMBER := FND_API.G_MISS_NUM,
56: PHYSICAL_ADJUSTMENT_ID NUMBER := FND_API.G_MISS_NUM,
57: CYCLE_COUNT_ID NUMBER := FND_API.G_MISS_NUM,
58: --R12 changes,Included to track rebuildables and asset numbers
59: EAM_ITEM_TYPE NUMBER := FND_API.G_MISS_NUM,
60: RCV_TRANSACTION_ID NUMBER := FND_API.G_MISS_NUM,
53: REVISION_QTY_CONTROL_CODE NUMBER := FND_API.G_MISS_NUM,
54: COMMS_NL_TRACKABLE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
55: LOCATION_CONTROL_CODE NUMBER := FND_API.G_MISS_NUM,
56: PHYSICAL_ADJUSTMENT_ID NUMBER := FND_API.G_MISS_NUM,
57: CYCLE_COUNT_ID NUMBER := FND_API.G_MISS_NUM,
58: --R12 changes,Included to track rebuildables and asset numbers
59: EAM_ITEM_TYPE NUMBER := FND_API.G_MISS_NUM,
60: RCV_TRANSACTION_ID NUMBER := FND_API.G_MISS_NUM,
61: TRANSFER_TRANSACTION_ID NUMBER := FND_API.G_MISS_NUM);
55: LOCATION_CONTROL_CODE NUMBER := FND_API.G_MISS_NUM,
56: PHYSICAL_ADJUSTMENT_ID NUMBER := FND_API.G_MISS_NUM,
57: CYCLE_COUNT_ID NUMBER := FND_API.G_MISS_NUM,
58: --R12 changes,Included to track rebuildables and asset numbers
59: EAM_ITEM_TYPE NUMBER := FND_API.G_MISS_NUM,
60: RCV_TRANSACTION_ID NUMBER := FND_API.G_MISS_NUM,
61: TRANSFER_TRANSACTION_ID NUMBER := FND_API.G_MISS_NUM);
62:
63: TYPE MTL_ITEM_TBL_TYPE is TABLE OF MTL_ITEM_REC_TYPE INDEX BY BINARY_INTEGER;
56: PHYSICAL_ADJUSTMENT_ID NUMBER := FND_API.G_MISS_NUM,
57: CYCLE_COUNT_ID NUMBER := FND_API.G_MISS_NUM,
58: --R12 changes,Included to track rebuildables and asset numbers
59: EAM_ITEM_TYPE NUMBER := FND_API.G_MISS_NUM,
60: RCV_TRANSACTION_ID NUMBER := FND_API.G_MISS_NUM,
61: TRANSFER_TRANSACTION_ID NUMBER := FND_API.G_MISS_NUM);
62:
63: TYPE MTL_ITEM_TBL_TYPE is TABLE OF MTL_ITEM_REC_TYPE INDEX BY BINARY_INTEGER;
64:
57: CYCLE_COUNT_ID NUMBER := FND_API.G_MISS_NUM,
58: --R12 changes,Included to track rebuildables and asset numbers
59: EAM_ITEM_TYPE NUMBER := FND_API.G_MISS_NUM,
60: RCV_TRANSACTION_ID NUMBER := FND_API.G_MISS_NUM,
61: TRANSFER_TRANSACTION_ID NUMBER := FND_API.G_MISS_NUM);
62:
63: TYPE MTL_ITEM_TBL_TYPE is TABLE OF MTL_ITEM_REC_TYPE INDEX BY BINARY_INTEGER;
64:
65: TYPE MTL_TRX_TYPE is RECORD