13: -- non-source and parent instance details based on the
14: -- definition of ib_txn_sub_type_id.
15:
16: TYPE txn_instance_rec is RECORD (
17: IB_TXN_SEGMENT_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,-- S-Source,N-NonSource,P-Parent
18: INSTANCE_ID NUMBER := FND_API.G_MISS_NUM, -- Pass if caller has one
19: NEW_INSTANCE_ID NUMBER := FND_API.G_MISS_NUM, -- Will contain ID if IB creates new
20: INSTANCE_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
21: EXTERNAL_REFERENCE VARCHAR2(30) := FND_API.G_MISS_CHAR,
14: -- definition of ib_txn_sub_type_id.
15:
16: TYPE txn_instance_rec is RECORD (
17: IB_TXN_SEGMENT_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,-- S-Source,N-NonSource,P-Parent
18: INSTANCE_ID NUMBER := FND_API.G_MISS_NUM, -- Pass if caller has one
19: NEW_INSTANCE_ID NUMBER := FND_API.G_MISS_NUM, -- Will contain ID if IB creates new
20: INSTANCE_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
21: EXTERNAL_REFERENCE VARCHAR2(30) := FND_API.G_MISS_CHAR,
22: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
15:
16: TYPE txn_instance_rec is RECORD (
17: IB_TXN_SEGMENT_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,-- S-Source,N-NonSource,P-Parent
18: INSTANCE_ID NUMBER := FND_API.G_MISS_NUM, -- Pass if caller has one
19: NEW_INSTANCE_ID NUMBER := FND_API.G_MISS_NUM, -- Will contain ID if IB creates new
20: INSTANCE_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
21: EXTERNAL_REFERENCE VARCHAR2(30) := FND_API.G_MISS_CHAR,
22: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
23: VLD_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
16: TYPE txn_instance_rec is RECORD (
17: IB_TXN_SEGMENT_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,-- S-Source,N-NonSource,P-Parent
18: INSTANCE_ID NUMBER := FND_API.G_MISS_NUM, -- Pass if caller has one
19: NEW_INSTANCE_ID NUMBER := FND_API.G_MISS_NUM, -- Will contain ID if IB creates new
20: INSTANCE_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
21: EXTERNAL_REFERENCE VARCHAR2(30) := FND_API.G_MISS_CHAR,
22: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
23: VLD_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
24: INVENTORY_REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,
17: IB_TXN_SEGMENT_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,-- S-Source,N-NonSource,P-Parent
18: INSTANCE_ID NUMBER := FND_API.G_MISS_NUM, -- Pass if caller has one
19: NEW_INSTANCE_ID NUMBER := FND_API.G_MISS_NUM, -- Will contain ID if IB creates new
20: INSTANCE_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
21: EXTERNAL_REFERENCE VARCHAR2(30) := FND_API.G_MISS_CHAR,
22: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
23: VLD_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
24: INVENTORY_REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,
25: INV_MASTER_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
18: INSTANCE_ID NUMBER := FND_API.G_MISS_NUM, -- Pass if caller has one
19: NEW_INSTANCE_ID NUMBER := FND_API.G_MISS_NUM, -- Will contain ID if IB creates new
20: INSTANCE_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
21: EXTERNAL_REFERENCE VARCHAR2(30) := FND_API.G_MISS_CHAR,
22: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
23: VLD_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
24: INVENTORY_REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,
25: INV_MASTER_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
26: SERIAL_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
19: NEW_INSTANCE_ID NUMBER := FND_API.G_MISS_NUM, -- Will contain ID if IB creates new
20: INSTANCE_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
21: EXTERNAL_REFERENCE VARCHAR2(30) := FND_API.G_MISS_CHAR,
22: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
23: VLD_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
24: INVENTORY_REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,
25: INV_MASTER_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
26: SERIAL_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
27: MFG_SERIAL_NUMBER_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
20: INSTANCE_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
21: EXTERNAL_REFERENCE VARCHAR2(30) := FND_API.G_MISS_CHAR,
22: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
23: VLD_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
24: INVENTORY_REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,
25: INV_MASTER_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
26: SERIAL_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
27: MFG_SERIAL_NUMBER_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
28: LOT_NUMBER VARCHAR2(80) := FND_API.G_MISS_CHAR,
21: EXTERNAL_REFERENCE VARCHAR2(30) := FND_API.G_MISS_CHAR,
22: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
23: VLD_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
24: INVENTORY_REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,
25: INV_MASTER_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
26: SERIAL_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
27: MFG_SERIAL_NUMBER_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
28: LOT_NUMBER VARCHAR2(80) := FND_API.G_MISS_CHAR,
29: QUANTITY NUMBER := FND_API.G_MISS_NUM,
22: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
23: VLD_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
24: INVENTORY_REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,
25: INV_MASTER_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
26: SERIAL_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
27: MFG_SERIAL_NUMBER_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
28: LOT_NUMBER VARCHAR2(80) := FND_API.G_MISS_CHAR,
29: QUANTITY NUMBER := FND_API.G_MISS_NUM,
30: UNIT_OF_MEASURE VARCHAR2(3) := FND_API.G_MISS_CHAR,
23: VLD_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
24: INVENTORY_REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,
25: INV_MASTER_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
26: SERIAL_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
27: MFG_SERIAL_NUMBER_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
28: LOT_NUMBER VARCHAR2(80) := FND_API.G_MISS_CHAR,
29: QUANTITY NUMBER := FND_API.G_MISS_NUM,
30: UNIT_OF_MEASURE VARCHAR2(3) := FND_API.G_MISS_CHAR,
31: ACCOUNTING_CLASS_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
24: INVENTORY_REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,
25: INV_MASTER_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
26: SERIAL_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
27: MFG_SERIAL_NUMBER_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
28: LOT_NUMBER VARCHAR2(80) := FND_API.G_MISS_CHAR,
29: QUANTITY NUMBER := FND_API.G_MISS_NUM,
30: UNIT_OF_MEASURE VARCHAR2(3) := FND_API.G_MISS_CHAR,
31: ACCOUNTING_CLASS_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
32: INSTANCE_CONDITION_ID NUMBER := FND_API.G_MISS_NUM,
25: INV_MASTER_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
26: SERIAL_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
27: MFG_SERIAL_NUMBER_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
28: LOT_NUMBER VARCHAR2(80) := FND_API.G_MISS_CHAR,
29: QUANTITY NUMBER := FND_API.G_MISS_NUM,
30: UNIT_OF_MEASURE VARCHAR2(3) := FND_API.G_MISS_CHAR,
31: ACCOUNTING_CLASS_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
32: INSTANCE_CONDITION_ID NUMBER := FND_API.G_MISS_NUM,
33: INSTANCE_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
26: SERIAL_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
27: MFG_SERIAL_NUMBER_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
28: LOT_NUMBER VARCHAR2(80) := FND_API.G_MISS_CHAR,
29: QUANTITY NUMBER := FND_API.G_MISS_NUM,
30: UNIT_OF_MEASURE VARCHAR2(3) := FND_API.G_MISS_CHAR,
31: ACCOUNTING_CLASS_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
32: INSTANCE_CONDITION_ID NUMBER := FND_API.G_MISS_NUM,
33: INSTANCE_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
34: CUSTOMER_VIEW_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
27: MFG_SERIAL_NUMBER_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
28: LOT_NUMBER VARCHAR2(80) := FND_API.G_MISS_CHAR,
29: QUANTITY NUMBER := FND_API.G_MISS_NUM,
30: UNIT_OF_MEASURE VARCHAR2(3) := FND_API.G_MISS_CHAR,
31: ACCOUNTING_CLASS_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
32: INSTANCE_CONDITION_ID NUMBER := FND_API.G_MISS_NUM,
33: INSTANCE_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
34: CUSTOMER_VIEW_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
35: MERCHANT_VIEW_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
28: LOT_NUMBER VARCHAR2(80) := FND_API.G_MISS_CHAR,
29: QUANTITY NUMBER := FND_API.G_MISS_NUM,
30: UNIT_OF_MEASURE VARCHAR2(3) := FND_API.G_MISS_CHAR,
31: ACCOUNTING_CLASS_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
32: INSTANCE_CONDITION_ID NUMBER := FND_API.G_MISS_NUM,
33: INSTANCE_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
34: CUSTOMER_VIEW_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
35: MERCHANT_VIEW_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
36: SELLABLE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
29: QUANTITY NUMBER := FND_API.G_MISS_NUM,
30: UNIT_OF_MEASURE VARCHAR2(3) := FND_API.G_MISS_CHAR,
31: ACCOUNTING_CLASS_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
32: INSTANCE_CONDITION_ID NUMBER := FND_API.G_MISS_NUM,
33: INSTANCE_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
34: CUSTOMER_VIEW_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
35: MERCHANT_VIEW_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
36: SELLABLE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
37: SYSTEM_ID NUMBER := FND_API.G_MISS_NUM,
30: UNIT_OF_MEASURE VARCHAR2(3) := FND_API.G_MISS_CHAR,
31: ACCOUNTING_CLASS_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
32: INSTANCE_CONDITION_ID NUMBER := FND_API.G_MISS_NUM,
33: INSTANCE_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
34: CUSTOMER_VIEW_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
35: MERCHANT_VIEW_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
36: SELLABLE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
37: SYSTEM_ID NUMBER := FND_API.G_MISS_NUM,
38: INSTANCE_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
31: ACCOUNTING_CLASS_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
32: INSTANCE_CONDITION_ID NUMBER := FND_API.G_MISS_NUM,
33: INSTANCE_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
34: CUSTOMER_VIEW_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
35: MERCHANT_VIEW_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
36: SELLABLE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
37: SYSTEM_ID NUMBER := FND_API.G_MISS_NUM,
38: INSTANCE_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
39: ACTIVE_START_DATE DATE := FND_API.G_MISS_DATE,
32: INSTANCE_CONDITION_ID NUMBER := FND_API.G_MISS_NUM,
33: INSTANCE_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
34: CUSTOMER_VIEW_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
35: MERCHANT_VIEW_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
36: SELLABLE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
37: SYSTEM_ID NUMBER := FND_API.G_MISS_NUM,
38: INSTANCE_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
39: ACTIVE_START_DATE DATE := FND_API.G_MISS_DATE,
40: ACTIVE_END_DATE DATE := FND_API.G_MISS_DATE,
33: INSTANCE_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
34: CUSTOMER_VIEW_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
35: MERCHANT_VIEW_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
36: SELLABLE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
37: SYSTEM_ID NUMBER := FND_API.G_MISS_NUM,
38: INSTANCE_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
39: ACTIVE_START_DATE DATE := FND_API.G_MISS_DATE,
40: ACTIVE_END_DATE DATE := FND_API.G_MISS_DATE,
41: LOCATION_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
34: CUSTOMER_VIEW_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
35: MERCHANT_VIEW_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
36: SELLABLE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
37: SYSTEM_ID NUMBER := FND_API.G_MISS_NUM,
38: INSTANCE_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
39: ACTIVE_START_DATE DATE := FND_API.G_MISS_DATE,
40: ACTIVE_END_DATE DATE := FND_API.G_MISS_DATE,
41: LOCATION_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
42: LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
35: MERCHANT_VIEW_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
36: SELLABLE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
37: SYSTEM_ID NUMBER := FND_API.G_MISS_NUM,
38: INSTANCE_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
39: ACTIVE_START_DATE DATE := FND_API.G_MISS_DATE,
40: ACTIVE_END_DATE DATE := FND_API.G_MISS_DATE,
41: LOCATION_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
42: LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
43: INV_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
36: SELLABLE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
37: SYSTEM_ID NUMBER := FND_API.G_MISS_NUM,
38: INSTANCE_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
39: ACTIVE_START_DATE DATE := FND_API.G_MISS_DATE,
40: ACTIVE_END_DATE DATE := FND_API.G_MISS_DATE,
41: LOCATION_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
42: LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
43: INV_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
44: INV_SUBINVENTORY_NAME VARCHAR2(10) := FND_API.G_MISS_CHAR,
37: SYSTEM_ID NUMBER := FND_API.G_MISS_NUM,
38: INSTANCE_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
39: ACTIVE_START_DATE DATE := FND_API.G_MISS_DATE,
40: ACTIVE_END_DATE DATE := FND_API.G_MISS_DATE,
41: LOCATION_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
42: LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
43: INV_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
44: INV_SUBINVENTORY_NAME VARCHAR2(10) := FND_API.G_MISS_CHAR,
45: INV_LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
38: INSTANCE_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
39: ACTIVE_START_DATE DATE := FND_API.G_MISS_DATE,
40: ACTIVE_END_DATE DATE := FND_API.G_MISS_DATE,
41: LOCATION_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
42: LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
43: INV_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
44: INV_SUBINVENTORY_NAME VARCHAR2(10) := FND_API.G_MISS_CHAR,
45: INV_LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
46: PA_PROJECT_ID NUMBER := FND_API.G_MISS_NUM,
39: ACTIVE_START_DATE DATE := FND_API.G_MISS_DATE,
40: ACTIVE_END_DATE DATE := FND_API.G_MISS_DATE,
41: LOCATION_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
42: LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
43: INV_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
44: INV_SUBINVENTORY_NAME VARCHAR2(10) := FND_API.G_MISS_CHAR,
45: INV_LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
46: PA_PROJECT_ID NUMBER := FND_API.G_MISS_NUM,
47: PA_PROJECT_TASK_ID NUMBER := FND_API.G_MISS_NUM,
40: ACTIVE_END_DATE DATE := FND_API.G_MISS_DATE,
41: LOCATION_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
42: LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
43: INV_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
44: INV_SUBINVENTORY_NAME VARCHAR2(10) := FND_API.G_MISS_CHAR,
45: INV_LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
46: PA_PROJECT_ID NUMBER := FND_API.G_MISS_NUM,
47: PA_PROJECT_TASK_ID NUMBER := FND_API.G_MISS_NUM,
48: IN_TRANSIT_ORDER_LINE_ID NUMBER := FND_API.G_MISS_NUM,
41: LOCATION_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
42: LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
43: INV_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
44: INV_SUBINVENTORY_NAME VARCHAR2(10) := FND_API.G_MISS_CHAR,
45: INV_LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
46: PA_PROJECT_ID NUMBER := FND_API.G_MISS_NUM,
47: PA_PROJECT_TASK_ID NUMBER := FND_API.G_MISS_NUM,
48: IN_TRANSIT_ORDER_LINE_ID NUMBER := FND_API.G_MISS_NUM,
49: WIP_JOB_ID NUMBER := FND_API.G_MISS_NUM,
42: LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
43: INV_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
44: INV_SUBINVENTORY_NAME VARCHAR2(10) := FND_API.G_MISS_CHAR,
45: INV_LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
46: PA_PROJECT_ID NUMBER := FND_API.G_MISS_NUM,
47: PA_PROJECT_TASK_ID NUMBER := FND_API.G_MISS_NUM,
48: IN_TRANSIT_ORDER_LINE_ID NUMBER := FND_API.G_MISS_NUM,
49: WIP_JOB_ID NUMBER := FND_API.G_MISS_NUM,
50: PO_ORDER_LINE_ID NUMBER := FND_API.G_MISS_NUM,
43: INV_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
44: INV_SUBINVENTORY_NAME VARCHAR2(10) := FND_API.G_MISS_CHAR,
45: INV_LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
46: PA_PROJECT_ID NUMBER := FND_API.G_MISS_NUM,
47: PA_PROJECT_TASK_ID NUMBER := FND_API.G_MISS_NUM,
48: IN_TRANSIT_ORDER_LINE_ID NUMBER := FND_API.G_MISS_NUM,
49: WIP_JOB_ID NUMBER := FND_API.G_MISS_NUM,
50: PO_ORDER_LINE_ID NUMBER := FND_API.G_MISS_NUM,
51: LAST_OE_ORDER_LINE_ID NUMBER := FND_API.G_MISS_NUM,
44: INV_SUBINVENTORY_NAME VARCHAR2(10) := FND_API.G_MISS_CHAR,
45: INV_LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
46: PA_PROJECT_ID NUMBER := FND_API.G_MISS_NUM,
47: PA_PROJECT_TASK_ID NUMBER := FND_API.G_MISS_NUM,
48: IN_TRANSIT_ORDER_LINE_ID NUMBER := FND_API.G_MISS_NUM,
49: WIP_JOB_ID NUMBER := FND_API.G_MISS_NUM,
50: PO_ORDER_LINE_ID NUMBER := FND_API.G_MISS_NUM,
51: LAST_OE_ORDER_LINE_ID NUMBER := FND_API.G_MISS_NUM,
52: LAST_OE_RMA_LINE_ID NUMBER := FND_API.G_MISS_NUM,
45: INV_LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
46: PA_PROJECT_ID NUMBER := FND_API.G_MISS_NUM,
47: PA_PROJECT_TASK_ID NUMBER := FND_API.G_MISS_NUM,
48: IN_TRANSIT_ORDER_LINE_ID NUMBER := FND_API.G_MISS_NUM,
49: WIP_JOB_ID NUMBER := FND_API.G_MISS_NUM,
50: PO_ORDER_LINE_ID NUMBER := FND_API.G_MISS_NUM,
51: LAST_OE_ORDER_LINE_ID NUMBER := FND_API.G_MISS_NUM,
52: LAST_OE_RMA_LINE_ID NUMBER := FND_API.G_MISS_NUM,
53: LAST_PO_PO_LINE_ID NUMBER := FND_API.G_MISS_NUM,
46: PA_PROJECT_ID NUMBER := FND_API.G_MISS_NUM,
47: PA_PROJECT_TASK_ID NUMBER := FND_API.G_MISS_NUM,
48: IN_TRANSIT_ORDER_LINE_ID NUMBER := FND_API.G_MISS_NUM,
49: WIP_JOB_ID NUMBER := FND_API.G_MISS_NUM,
50: PO_ORDER_LINE_ID NUMBER := FND_API.G_MISS_NUM,
51: LAST_OE_ORDER_LINE_ID NUMBER := FND_API.G_MISS_NUM,
52: LAST_OE_RMA_LINE_ID NUMBER := FND_API.G_MISS_NUM,
53: LAST_PO_PO_LINE_ID NUMBER := FND_API.G_MISS_NUM,
54: LAST_OE_PO_NUMBER VARCHAR2(50) := FND_API.G_MISS_CHAR,
47: PA_PROJECT_TASK_ID NUMBER := FND_API.G_MISS_NUM,
48: IN_TRANSIT_ORDER_LINE_ID NUMBER := FND_API.G_MISS_NUM,
49: WIP_JOB_ID NUMBER := FND_API.G_MISS_NUM,
50: PO_ORDER_LINE_ID NUMBER := FND_API.G_MISS_NUM,
51: LAST_OE_ORDER_LINE_ID NUMBER := FND_API.G_MISS_NUM,
52: LAST_OE_RMA_LINE_ID NUMBER := FND_API.G_MISS_NUM,
53: LAST_PO_PO_LINE_ID NUMBER := FND_API.G_MISS_NUM,
54: LAST_OE_PO_NUMBER VARCHAR2(50) := FND_API.G_MISS_CHAR,
55: LAST_WIP_JOB_ID NUMBER := FND_API.G_MISS_NUM,
48: IN_TRANSIT_ORDER_LINE_ID NUMBER := FND_API.G_MISS_NUM,
49: WIP_JOB_ID NUMBER := FND_API.G_MISS_NUM,
50: PO_ORDER_LINE_ID NUMBER := FND_API.G_MISS_NUM,
51: LAST_OE_ORDER_LINE_ID NUMBER := FND_API.G_MISS_NUM,
52: LAST_OE_RMA_LINE_ID NUMBER := FND_API.G_MISS_NUM,
53: LAST_PO_PO_LINE_ID NUMBER := FND_API.G_MISS_NUM,
54: LAST_OE_PO_NUMBER VARCHAR2(50) := FND_API.G_MISS_CHAR,
55: LAST_WIP_JOB_ID NUMBER := FND_API.G_MISS_NUM,
56: LAST_PA_PROJECT_ID NUMBER := FND_API.G_MISS_NUM,
49: WIP_JOB_ID NUMBER := FND_API.G_MISS_NUM,
50: PO_ORDER_LINE_ID NUMBER := FND_API.G_MISS_NUM,
51: LAST_OE_ORDER_LINE_ID NUMBER := FND_API.G_MISS_NUM,
52: LAST_OE_RMA_LINE_ID NUMBER := FND_API.G_MISS_NUM,
53: LAST_PO_PO_LINE_ID NUMBER := FND_API.G_MISS_NUM,
54: LAST_OE_PO_NUMBER VARCHAR2(50) := FND_API.G_MISS_CHAR,
55: LAST_WIP_JOB_ID NUMBER := FND_API.G_MISS_NUM,
56: LAST_PA_PROJECT_ID NUMBER := FND_API.G_MISS_NUM,
57: LAST_PA_TASK_ID NUMBER := FND_API.G_MISS_NUM,
50: PO_ORDER_LINE_ID NUMBER := FND_API.G_MISS_NUM,
51: LAST_OE_ORDER_LINE_ID NUMBER := FND_API.G_MISS_NUM,
52: LAST_OE_RMA_LINE_ID NUMBER := FND_API.G_MISS_NUM,
53: LAST_PO_PO_LINE_ID NUMBER := FND_API.G_MISS_NUM,
54: LAST_OE_PO_NUMBER VARCHAR2(50) := FND_API.G_MISS_CHAR,
55: LAST_WIP_JOB_ID NUMBER := FND_API.G_MISS_NUM,
56: LAST_PA_PROJECT_ID NUMBER := FND_API.G_MISS_NUM,
57: LAST_PA_TASK_ID NUMBER := FND_API.G_MISS_NUM,
58: LAST_OE_AGREEMENT_ID NUMBER := FND_API.G_MISS_NUM,
51: LAST_OE_ORDER_LINE_ID NUMBER := FND_API.G_MISS_NUM,
52: LAST_OE_RMA_LINE_ID NUMBER := FND_API.G_MISS_NUM,
53: LAST_PO_PO_LINE_ID NUMBER := FND_API.G_MISS_NUM,
54: LAST_OE_PO_NUMBER VARCHAR2(50) := FND_API.G_MISS_CHAR,
55: LAST_WIP_JOB_ID NUMBER := FND_API.G_MISS_NUM,
56: LAST_PA_PROJECT_ID NUMBER := FND_API.G_MISS_NUM,
57: LAST_PA_TASK_ID NUMBER := FND_API.G_MISS_NUM,
58: LAST_OE_AGREEMENT_ID NUMBER := FND_API.G_MISS_NUM,
59: INSTALL_DATE DATE := FND_API.G_MISS_DATE,
52: LAST_OE_RMA_LINE_ID NUMBER := FND_API.G_MISS_NUM,
53: LAST_PO_PO_LINE_ID NUMBER := FND_API.G_MISS_NUM,
54: LAST_OE_PO_NUMBER VARCHAR2(50) := FND_API.G_MISS_CHAR,
55: LAST_WIP_JOB_ID NUMBER := FND_API.G_MISS_NUM,
56: LAST_PA_PROJECT_ID NUMBER := FND_API.G_MISS_NUM,
57: LAST_PA_TASK_ID NUMBER := FND_API.G_MISS_NUM,
58: LAST_OE_AGREEMENT_ID NUMBER := FND_API.G_MISS_NUM,
59: INSTALL_DATE DATE := FND_API.G_MISS_DATE,
60: MANUALLY_CREATED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
53: LAST_PO_PO_LINE_ID NUMBER := FND_API.G_MISS_NUM,
54: LAST_OE_PO_NUMBER VARCHAR2(50) := FND_API.G_MISS_CHAR,
55: LAST_WIP_JOB_ID NUMBER := FND_API.G_MISS_NUM,
56: LAST_PA_PROJECT_ID NUMBER := FND_API.G_MISS_NUM,
57: LAST_PA_TASK_ID NUMBER := FND_API.G_MISS_NUM,
58: LAST_OE_AGREEMENT_ID NUMBER := FND_API.G_MISS_NUM,
59: INSTALL_DATE DATE := FND_API.G_MISS_DATE,
60: MANUALLY_CREATED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
61: RETURN_BY_DATE DATE := FND_API.G_MISS_DATE,
54: LAST_OE_PO_NUMBER VARCHAR2(50) := FND_API.G_MISS_CHAR,
55: LAST_WIP_JOB_ID NUMBER := FND_API.G_MISS_NUM,
56: LAST_PA_PROJECT_ID NUMBER := FND_API.G_MISS_NUM,
57: LAST_PA_TASK_ID NUMBER := FND_API.G_MISS_NUM,
58: LAST_OE_AGREEMENT_ID NUMBER := FND_API.G_MISS_NUM,
59: INSTALL_DATE DATE := FND_API.G_MISS_DATE,
60: MANUALLY_CREATED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
61: RETURN_BY_DATE DATE := FND_API.G_MISS_DATE,
62: ACTUAL_RETURN_DATE DATE := FND_API.G_MISS_DATE,
55: LAST_WIP_JOB_ID NUMBER := FND_API.G_MISS_NUM,
56: LAST_PA_PROJECT_ID NUMBER := FND_API.G_MISS_NUM,
57: LAST_PA_TASK_ID NUMBER := FND_API.G_MISS_NUM,
58: LAST_OE_AGREEMENT_ID NUMBER := FND_API.G_MISS_NUM,
59: INSTALL_DATE DATE := FND_API.G_MISS_DATE,
60: MANUALLY_CREATED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
61: RETURN_BY_DATE DATE := FND_API.G_MISS_DATE,
62: ACTUAL_RETURN_DATE DATE := FND_API.G_MISS_DATE,
63: CREATION_COMPLETE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
56: LAST_PA_PROJECT_ID NUMBER := FND_API.G_MISS_NUM,
57: LAST_PA_TASK_ID NUMBER := FND_API.G_MISS_NUM,
58: LAST_OE_AGREEMENT_ID NUMBER := FND_API.G_MISS_NUM,
59: INSTALL_DATE DATE := FND_API.G_MISS_DATE,
60: MANUALLY_CREATED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
61: RETURN_BY_DATE DATE := FND_API.G_MISS_DATE,
62: ACTUAL_RETURN_DATE DATE := FND_API.G_MISS_DATE,
63: CREATION_COMPLETE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
64: COMPLETENESS_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
57: LAST_PA_TASK_ID NUMBER := FND_API.G_MISS_NUM,
58: LAST_OE_AGREEMENT_ID NUMBER := FND_API.G_MISS_NUM,
59: INSTALL_DATE DATE := FND_API.G_MISS_DATE,
60: MANUALLY_CREATED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
61: RETURN_BY_DATE DATE := FND_API.G_MISS_DATE,
62: ACTUAL_RETURN_DATE DATE := FND_API.G_MISS_DATE,
63: CREATION_COMPLETE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
64: COMPLETENESS_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
65: VERSION_LABEL VARCHAR2(240) := FND_API.G_MISS_CHAR,
58: LAST_OE_AGREEMENT_ID NUMBER := FND_API.G_MISS_NUM,
59: INSTALL_DATE DATE := FND_API.G_MISS_DATE,
60: MANUALLY_CREATED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
61: RETURN_BY_DATE DATE := FND_API.G_MISS_DATE,
62: ACTUAL_RETURN_DATE DATE := FND_API.G_MISS_DATE,
63: CREATION_COMPLETE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
64: COMPLETENESS_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
65: VERSION_LABEL VARCHAR2(240) := FND_API.G_MISS_CHAR,
66: VERSION_LABEL_DESCRIPTION VARCHAR2(240) := FND_API.G_MISS_CHAR,
59: INSTALL_DATE DATE := FND_API.G_MISS_DATE,
60: MANUALLY_CREATED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
61: RETURN_BY_DATE DATE := FND_API.G_MISS_DATE,
62: ACTUAL_RETURN_DATE DATE := FND_API.G_MISS_DATE,
63: CREATION_COMPLETE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
64: COMPLETENESS_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
65: VERSION_LABEL VARCHAR2(240) := FND_API.G_MISS_CHAR,
66: VERSION_LABEL_DESCRIPTION VARCHAR2(240) := FND_API.G_MISS_CHAR,
67: CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
60: MANUALLY_CREATED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
61: RETURN_BY_DATE DATE := FND_API.G_MISS_DATE,
62: ACTUAL_RETURN_DATE DATE := FND_API.G_MISS_DATE,
63: CREATION_COMPLETE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
64: COMPLETENESS_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
65: VERSION_LABEL VARCHAR2(240) := FND_API.G_MISS_CHAR,
66: VERSION_LABEL_DESCRIPTION VARCHAR2(240) := FND_API.G_MISS_CHAR,
67: CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
68: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
61: RETURN_BY_DATE DATE := FND_API.G_MISS_DATE,
62: ACTUAL_RETURN_DATE DATE := FND_API.G_MISS_DATE,
63: CREATION_COMPLETE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
64: COMPLETENESS_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
65: VERSION_LABEL VARCHAR2(240) := FND_API.G_MISS_CHAR,
66: VERSION_LABEL_DESCRIPTION VARCHAR2(240) := FND_API.G_MISS_CHAR,
67: CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
68: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
69: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
62: ACTUAL_RETURN_DATE DATE := FND_API.G_MISS_DATE,
63: CREATION_COMPLETE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
64: COMPLETENESS_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
65: VERSION_LABEL VARCHAR2(240) := FND_API.G_MISS_CHAR,
66: VERSION_LABEL_DESCRIPTION VARCHAR2(240) := FND_API.G_MISS_CHAR,
67: CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
68: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
69: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
70: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
63: CREATION_COMPLETE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
64: COMPLETENESS_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
65: VERSION_LABEL VARCHAR2(240) := FND_API.G_MISS_CHAR,
66: VERSION_LABEL_DESCRIPTION VARCHAR2(240) := FND_API.G_MISS_CHAR,
67: CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
68: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
69: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
70: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
71: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
64: COMPLETENESS_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
65: VERSION_LABEL VARCHAR2(240) := FND_API.G_MISS_CHAR,
66: VERSION_LABEL_DESCRIPTION VARCHAR2(240) := FND_API.G_MISS_CHAR,
67: CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
68: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
69: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
70: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
71: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
72: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
65: VERSION_LABEL VARCHAR2(240) := FND_API.G_MISS_CHAR,
66: VERSION_LABEL_DESCRIPTION VARCHAR2(240) := FND_API.G_MISS_CHAR,
67: CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
68: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
69: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
70: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
71: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
72: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
66: VERSION_LABEL_DESCRIPTION VARCHAR2(240) := FND_API.G_MISS_CHAR,
67: CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
68: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
69: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
70: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
71: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
72: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
67: CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
68: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
69: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
70: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
71: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
72: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
68: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
69: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
70: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
71: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
72: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
69: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
70: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
71: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
72: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
70: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
71: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
72: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
78: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
71: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
72: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
78: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
79: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
72: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
78: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
79: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
78: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
79: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
78: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
79: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
78: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
79: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
76: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
78: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
79: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
84: LAST_TXN_LINE_DETAIL_ID NUMBER := FND_API.G_MISS_NUM,
77: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
78: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
79: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
84: LAST_TXN_LINE_DETAIL_ID NUMBER := FND_API.G_MISS_NUM,
85: INSTALL_LOCATION_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
78: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
79: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
84: LAST_TXN_LINE_DETAIL_ID NUMBER := FND_API.G_MISS_NUM,
85: INSTALL_LOCATION_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
86: INSTALL_LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
79: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
84: LAST_TXN_LINE_DETAIL_ID NUMBER := FND_API.G_MISS_NUM,
85: INSTALL_LOCATION_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
86: INSTALL_LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
87: INSTANCE_USAGE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
84: LAST_TXN_LINE_DETAIL_ID NUMBER := FND_API.G_MISS_NUM,
85: INSTALL_LOCATION_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
86: INSTALL_LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
87: INSTANCE_USAGE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
88: MTL_TXN_CREATION_DATE DATE := FND_API.G_MISS_DATE, --bug 3804960
81: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
84: LAST_TXN_LINE_DETAIL_ID NUMBER := FND_API.G_MISS_NUM,
85: INSTALL_LOCATION_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
86: INSTALL_LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
87: INSTANCE_USAGE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
88: MTL_TXN_CREATION_DATE DATE := FND_API.G_MISS_DATE, --bug 3804960
89: CONFIG_INST_HDR_ID NUMBER := FND_API.G_MISS_NUM,
82: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
84: LAST_TXN_LINE_DETAIL_ID NUMBER := FND_API.G_MISS_NUM,
85: INSTALL_LOCATION_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
86: INSTALL_LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
87: INSTANCE_USAGE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
88: MTL_TXN_CREATION_DATE DATE := FND_API.G_MISS_DATE, --bug 3804960
89: CONFIG_INST_HDR_ID NUMBER := FND_API.G_MISS_NUM,
90: CONFIG_INST_REV_NUM NUMBER := FND_API.G_MISS_NUM,
83: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
84: LAST_TXN_LINE_DETAIL_ID NUMBER := FND_API.G_MISS_NUM,
85: INSTALL_LOCATION_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
86: INSTALL_LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
87: INSTANCE_USAGE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
88: MTL_TXN_CREATION_DATE DATE := FND_API.G_MISS_DATE, --bug 3804960
89: CONFIG_INST_HDR_ID NUMBER := FND_API.G_MISS_NUM,
90: CONFIG_INST_REV_NUM NUMBER := FND_API.G_MISS_NUM,
91: CONFIG_INST_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
84: LAST_TXN_LINE_DETAIL_ID NUMBER := FND_API.G_MISS_NUM,
85: INSTALL_LOCATION_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
86: INSTALL_LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
87: INSTANCE_USAGE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
88: MTL_TXN_CREATION_DATE DATE := FND_API.G_MISS_DATE, --bug 3804960
89: CONFIG_INST_HDR_ID NUMBER := FND_API.G_MISS_NUM,
90: CONFIG_INST_REV_NUM NUMBER := FND_API.G_MISS_NUM,
91: CONFIG_INST_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
92: OPERATIONAL_STATUS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR);
85: INSTALL_LOCATION_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
86: INSTALL_LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
87: INSTANCE_USAGE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
88: MTL_TXN_CREATION_DATE DATE := FND_API.G_MISS_DATE, --bug 3804960
89: CONFIG_INST_HDR_ID NUMBER := FND_API.G_MISS_NUM,
90: CONFIG_INST_REV_NUM NUMBER := FND_API.G_MISS_NUM,
91: CONFIG_INST_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
92: OPERATIONAL_STATUS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR);
93:
86: INSTALL_LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
87: INSTANCE_USAGE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
88: MTL_TXN_CREATION_DATE DATE := FND_API.G_MISS_DATE, --bug 3804960
89: CONFIG_INST_HDR_ID NUMBER := FND_API.G_MISS_NUM,
90: CONFIG_INST_REV_NUM NUMBER := FND_API.G_MISS_NUM,
91: CONFIG_INST_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
92: OPERATIONAL_STATUS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR);
93:
94: TYPE dest_location_rec IS RECORD (
87: INSTANCE_USAGE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
88: MTL_TXN_CREATION_DATE DATE := FND_API.G_MISS_DATE, --bug 3804960
89: CONFIG_INST_HDR_ID NUMBER := FND_API.G_MISS_NUM,
90: CONFIG_INST_REV_NUM NUMBER := FND_API.G_MISS_NUM,
91: CONFIG_INST_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
92: OPERATIONAL_STATUS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR);
93:
94: TYPE dest_location_rec IS RECORD (
95: parent_tbl_index NUMBER := fnd_api.g_miss_num,
88: MTL_TXN_CREATION_DATE DATE := FND_API.G_MISS_DATE, --bug 3804960
89: CONFIG_INST_HDR_ID NUMBER := FND_API.G_MISS_NUM,
90: CONFIG_INST_REV_NUM NUMBER := FND_API.G_MISS_NUM,
91: CONFIG_INST_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
92: OPERATIONAL_STATUS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR);
93:
94: TYPE dest_location_rec IS RECORD (
95: parent_tbl_index NUMBER := fnd_api.g_miss_num,
96: location_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
91: CONFIG_INST_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
92: OPERATIONAL_STATUS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR);
93:
94: TYPE dest_location_rec IS RECORD (
95: parent_tbl_index NUMBER := fnd_api.g_miss_num,
96: location_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
97: location_id NUMBER := FND_API.G_MISS_NUM,
98: install_location_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
99: install_location_id NUMBER := FND_API.G_MISS_NUM,
92: OPERATIONAL_STATUS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR);
93:
94: TYPE dest_location_rec IS RECORD (
95: parent_tbl_index NUMBER := fnd_api.g_miss_num,
96: location_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
97: location_id NUMBER := FND_API.G_MISS_NUM,
98: install_location_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
99: install_location_id NUMBER := FND_API.G_MISS_NUM,
100: instance_usage_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
93:
94: TYPE dest_location_rec IS RECORD (
95: parent_tbl_index NUMBER := fnd_api.g_miss_num,
96: location_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
97: location_id NUMBER := FND_API.G_MISS_NUM,
98: install_location_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
99: install_location_id NUMBER := FND_API.G_MISS_NUM,
100: instance_usage_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
101: inv_organization_id NUMBER := FND_API.G_MISS_NUM,
94: TYPE dest_location_rec IS RECORD (
95: parent_tbl_index NUMBER := fnd_api.g_miss_num,
96: location_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
97: location_id NUMBER := FND_API.G_MISS_NUM,
98: install_location_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
99: install_location_id NUMBER := FND_API.G_MISS_NUM,
100: instance_usage_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
101: inv_organization_id NUMBER := FND_API.G_MISS_NUM,
102: inv_subinventory_name VARCHAR2(10) := FND_API.G_MISS_CHAR,
95: parent_tbl_index NUMBER := fnd_api.g_miss_num,
96: location_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
97: location_id NUMBER := FND_API.G_MISS_NUM,
98: install_location_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
99: install_location_id NUMBER := FND_API.G_MISS_NUM,
100: instance_usage_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
101: inv_organization_id NUMBER := FND_API.G_MISS_NUM,
102: inv_subinventory_name VARCHAR2(10) := FND_API.G_MISS_CHAR,
103: inv_locator_id NUMBER := FND_API.G_MISS_NUM,
96: location_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
97: location_id NUMBER := FND_API.G_MISS_NUM,
98: install_location_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
99: install_location_id NUMBER := FND_API.G_MISS_NUM,
100: instance_usage_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
101: inv_organization_id NUMBER := FND_API.G_MISS_NUM,
102: inv_subinventory_name VARCHAR2(10) := FND_API.G_MISS_CHAR,
103: inv_locator_id NUMBER := FND_API.G_MISS_NUM,
104: pa_project_id NUMBER := FND_API.G_MISS_NUM,
97: location_id NUMBER := FND_API.G_MISS_NUM,
98: install_location_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
99: install_location_id NUMBER := FND_API.G_MISS_NUM,
100: instance_usage_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
101: inv_organization_id NUMBER := FND_API.G_MISS_NUM,
102: inv_subinventory_name VARCHAR2(10) := FND_API.G_MISS_CHAR,
103: inv_locator_id NUMBER := FND_API.G_MISS_NUM,
104: pa_project_id NUMBER := FND_API.G_MISS_NUM,
105: pa_project_task_id NUMBER := FND_API.G_MISS_NUM,
98: install_location_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
99: install_location_id NUMBER := FND_API.G_MISS_NUM,
100: instance_usage_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
101: inv_organization_id NUMBER := FND_API.G_MISS_NUM,
102: inv_subinventory_name VARCHAR2(10) := FND_API.G_MISS_CHAR,
103: inv_locator_id NUMBER := FND_API.G_MISS_NUM,
104: pa_project_id NUMBER := FND_API.G_MISS_NUM,
105: pa_project_task_id NUMBER := FND_API.G_MISS_NUM,
106: in_transit_order_line_id NUMBER := fnd_api.g_miss_num,
99: install_location_id NUMBER := FND_API.G_MISS_NUM,
100: instance_usage_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
101: inv_organization_id NUMBER := FND_API.G_MISS_NUM,
102: inv_subinventory_name VARCHAR2(10) := FND_API.G_MISS_CHAR,
103: inv_locator_id NUMBER := FND_API.G_MISS_NUM,
104: pa_project_id NUMBER := FND_API.G_MISS_NUM,
105: pa_project_task_id NUMBER := FND_API.G_MISS_NUM,
106: in_transit_order_line_id NUMBER := fnd_api.g_miss_num,
107: wip_job_id NUMBER := fnd_api.g_miss_num,
100: instance_usage_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
101: inv_organization_id NUMBER := FND_API.G_MISS_NUM,
102: inv_subinventory_name VARCHAR2(10) := FND_API.G_MISS_CHAR,
103: inv_locator_id NUMBER := FND_API.G_MISS_NUM,
104: pa_project_id NUMBER := FND_API.G_MISS_NUM,
105: pa_project_task_id NUMBER := FND_API.G_MISS_NUM,
106: in_transit_order_line_id NUMBER := fnd_api.g_miss_num,
107: wip_job_id NUMBER := fnd_api.g_miss_num,
108: last_wip_job_id number := fnd_api.g_miss_num, --bug 5376024
101: inv_organization_id NUMBER := FND_API.G_MISS_NUM,
102: inv_subinventory_name VARCHAR2(10) := FND_API.G_MISS_CHAR,
103: inv_locator_id NUMBER := FND_API.G_MISS_NUM,
104: pa_project_id NUMBER := FND_API.G_MISS_NUM,
105: pa_project_task_id NUMBER := FND_API.G_MISS_NUM,
106: in_transit_order_line_id NUMBER := fnd_api.g_miss_num,
107: wip_job_id NUMBER := fnd_api.g_miss_num,
108: last_wip_job_id number := fnd_api.g_miss_num, --bug 5376024
109: po_order_line_id NUMBER := fnd_api.g_miss_num,
102: inv_subinventory_name VARCHAR2(10) := FND_API.G_MISS_CHAR,
103: inv_locator_id NUMBER := FND_API.G_MISS_NUM,
104: pa_project_id NUMBER := FND_API.G_MISS_NUM,
105: pa_project_task_id NUMBER := FND_API.G_MISS_NUM,
106: in_transit_order_line_id NUMBER := fnd_api.g_miss_num,
107: wip_job_id NUMBER := fnd_api.g_miss_num,
108: last_wip_job_id number := fnd_api.g_miss_num, --bug 5376024
109: po_order_line_id NUMBER := fnd_api.g_miss_num,
110: last_pa_project_id NUMBER := fnd_api.g_miss_num,
103: inv_locator_id NUMBER := FND_API.G_MISS_NUM,
104: pa_project_id NUMBER := FND_API.G_MISS_NUM,
105: pa_project_task_id NUMBER := FND_API.G_MISS_NUM,
106: in_transit_order_line_id NUMBER := fnd_api.g_miss_num,
107: wip_job_id NUMBER := fnd_api.g_miss_num,
108: last_wip_job_id number := fnd_api.g_miss_num, --bug 5376024
109: po_order_line_id NUMBER := fnd_api.g_miss_num,
110: last_pa_project_id NUMBER := fnd_api.g_miss_num,
111: last_pa_project_task_id NUMBER := fnd_api.g_miss_num,
104: pa_project_id NUMBER := FND_API.G_MISS_NUM,
105: pa_project_task_id NUMBER := FND_API.G_MISS_NUM,
106: in_transit_order_line_id NUMBER := fnd_api.g_miss_num,
107: wip_job_id NUMBER := fnd_api.g_miss_num,
108: last_wip_job_id number := fnd_api.g_miss_num, --bug 5376024
109: po_order_line_id NUMBER := fnd_api.g_miss_num,
110: last_pa_project_id NUMBER := fnd_api.g_miss_num,
111: last_pa_project_task_id NUMBER := fnd_api.g_miss_num,
112: external_reference VARCHAR2(30) := fnd_api.g_miss_char,
105: pa_project_task_id NUMBER := FND_API.G_MISS_NUM,
106: in_transit_order_line_id NUMBER := fnd_api.g_miss_num,
107: wip_job_id NUMBER := fnd_api.g_miss_num,
108: last_wip_job_id number := fnd_api.g_miss_num, --bug 5376024
109: po_order_line_id NUMBER := fnd_api.g_miss_num,
110: last_pa_project_id NUMBER := fnd_api.g_miss_num,
111: last_pa_project_task_id NUMBER := fnd_api.g_miss_num,
112: external_reference VARCHAR2(30) := fnd_api.g_miss_char,
113: operational_status_code VARCHAR2(30) := fnd_api.g_miss_char);
106: in_transit_order_line_id NUMBER := fnd_api.g_miss_num,
107: wip_job_id NUMBER := fnd_api.g_miss_num,
108: last_wip_job_id number := fnd_api.g_miss_num, --bug 5376024
109: po_order_line_id NUMBER := fnd_api.g_miss_num,
110: last_pa_project_id NUMBER := fnd_api.g_miss_num,
111: last_pa_project_task_id NUMBER := fnd_api.g_miss_num,
112: external_reference VARCHAR2(30) := fnd_api.g_miss_char,
113: operational_status_code VARCHAR2(30) := fnd_api.g_miss_char);
114:
107: wip_job_id NUMBER := fnd_api.g_miss_num,
108: last_wip_job_id number := fnd_api.g_miss_num, --bug 5376024
109: po_order_line_id NUMBER := fnd_api.g_miss_num,
110: last_pa_project_id NUMBER := fnd_api.g_miss_num,
111: last_pa_project_task_id NUMBER := fnd_api.g_miss_num,
112: external_reference VARCHAR2(30) := fnd_api.g_miss_char,
113: operational_status_code VARCHAR2(30) := fnd_api.g_miss_char);
114:
115:
108: last_wip_job_id number := fnd_api.g_miss_num, --bug 5376024
109: po_order_line_id NUMBER := fnd_api.g_miss_num,
110: last_pa_project_id NUMBER := fnd_api.g_miss_num,
111: last_pa_project_task_id NUMBER := fnd_api.g_miss_num,
112: external_reference VARCHAR2(30) := fnd_api.g_miss_char,
113: operational_status_code VARCHAR2(30) := fnd_api.g_miss_char);
114:
115:
116: TYPE txn_instances_tbl is TABLE OF txn_instance_rec INDEX BY BINARY_INTEGER;
109: po_order_line_id NUMBER := fnd_api.g_miss_num,
110: last_pa_project_id NUMBER := fnd_api.g_miss_num,
111: last_pa_project_task_id NUMBER := fnd_api.g_miss_num,
112: external_reference VARCHAR2(30) := fnd_api.g_miss_char,
113: operational_status_code VARCHAR2(30) := fnd_api.g_miss_char);
114:
115:
116: TYPE txn_instances_tbl is TABLE OF txn_instance_rec INDEX BY BINARY_INTEGER;
117:
118: -- Name : txn_i_party_rec
119: -- Description : record to hold information about an instance-party relationship.
120:
121: TYPE txn_i_party_rec IS RECORD (
122: instance_party_id NUMBER := FND_API.G_MISS_NUM,
123: parent_tbl_index NUMBER := FND_API.G_MISS_NUM,
124: instance_id NUMBER := FND_API.G_MISS_NUM,
125: party_source_table VARCHAR2(30) := FND_API.G_MISS_CHAR,
126: party_id NUMBER := FND_API.G_MISS_NUM,
119: -- Description : record to hold information about an instance-party relationship.
120:
121: TYPE txn_i_party_rec IS RECORD (
122: instance_party_id NUMBER := FND_API.G_MISS_NUM,
123: parent_tbl_index NUMBER := FND_API.G_MISS_NUM,
124: instance_id NUMBER := FND_API.G_MISS_NUM,
125: party_source_table VARCHAR2(30) := FND_API.G_MISS_CHAR,
126: party_id NUMBER := FND_API.G_MISS_NUM,
127: relationship_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
120:
121: TYPE txn_i_party_rec IS RECORD (
122: instance_party_id NUMBER := FND_API.G_MISS_NUM,
123: parent_tbl_index NUMBER := FND_API.G_MISS_NUM,
124: instance_id NUMBER := FND_API.G_MISS_NUM,
125: party_source_table VARCHAR2(30) := FND_API.G_MISS_CHAR,
126: party_id NUMBER := FND_API.G_MISS_NUM,
127: relationship_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
128: contact_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
121: TYPE txn_i_party_rec IS RECORD (
122: instance_party_id NUMBER := FND_API.G_MISS_NUM,
123: parent_tbl_index NUMBER := FND_API.G_MISS_NUM,
124: instance_id NUMBER := FND_API.G_MISS_NUM,
125: party_source_table VARCHAR2(30) := FND_API.G_MISS_CHAR,
126: party_id NUMBER := FND_API.G_MISS_NUM,
127: relationship_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
128: contact_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
129: contact_ip_id NUMBER := FND_API.G_MISS_NUM,
122: instance_party_id NUMBER := FND_API.G_MISS_NUM,
123: parent_tbl_index NUMBER := FND_API.G_MISS_NUM,
124: instance_id NUMBER := FND_API.G_MISS_NUM,
125: party_source_table VARCHAR2(30) := FND_API.G_MISS_CHAR,
126: party_id NUMBER := FND_API.G_MISS_NUM,
127: relationship_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
128: contact_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
129: contact_ip_id NUMBER := FND_API.G_MISS_NUM,
130: active_start_date DATE := FND_API.G_MISS_DATE,
123: parent_tbl_index NUMBER := FND_API.G_MISS_NUM,
124: instance_id NUMBER := FND_API.G_MISS_NUM,
125: party_source_table VARCHAR2(30) := FND_API.G_MISS_CHAR,
126: party_id NUMBER := FND_API.G_MISS_NUM,
127: relationship_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
128: contact_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
129: contact_ip_id NUMBER := FND_API.G_MISS_NUM,
130: active_start_date DATE := FND_API.G_MISS_DATE,
131: active_end_date DATE := FND_API.G_MISS_DATE,
124: instance_id NUMBER := FND_API.G_MISS_NUM,
125: party_source_table VARCHAR2(30) := FND_API.G_MISS_CHAR,
126: party_id NUMBER := FND_API.G_MISS_NUM,
127: relationship_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
128: contact_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
129: contact_ip_id NUMBER := FND_API.G_MISS_NUM,
130: active_start_date DATE := FND_API.G_MISS_DATE,
131: active_end_date DATE := FND_API.G_MISS_DATE,
132: context VARCHAR2(30) := FND_API.G_MISS_CHAR,
125: party_source_table VARCHAR2(30) := FND_API.G_MISS_CHAR,
126: party_id NUMBER := FND_API.G_MISS_NUM,
127: relationship_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
128: contact_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
129: contact_ip_id NUMBER := FND_API.G_MISS_NUM,
130: active_start_date DATE := FND_API.G_MISS_DATE,
131: active_end_date DATE := FND_API.G_MISS_DATE,
132: context VARCHAR2(30) := FND_API.G_MISS_CHAR,
133: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
126: party_id NUMBER := FND_API.G_MISS_NUM,
127: relationship_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
128: contact_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
129: contact_ip_id NUMBER := FND_API.G_MISS_NUM,
130: active_start_date DATE := FND_API.G_MISS_DATE,
131: active_end_date DATE := FND_API.G_MISS_DATE,
132: context VARCHAR2(30) := FND_API.G_MISS_CHAR,
133: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
134: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
127: relationship_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
128: contact_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
129: contact_ip_id NUMBER := FND_API.G_MISS_NUM,
130: active_start_date DATE := FND_API.G_MISS_DATE,
131: active_end_date DATE := FND_API.G_MISS_DATE,
132: context VARCHAR2(30) := FND_API.G_MISS_CHAR,
133: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
134: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
135: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
128: contact_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
129: contact_ip_id NUMBER := FND_API.G_MISS_NUM,
130: active_start_date DATE := FND_API.G_MISS_DATE,
131: active_end_date DATE := FND_API.G_MISS_DATE,
132: context VARCHAR2(30) := FND_API.G_MISS_CHAR,
133: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
134: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
135: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
136: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
129: contact_ip_id NUMBER := FND_API.G_MISS_NUM,
130: active_start_date DATE := FND_API.G_MISS_DATE,
131: active_end_date DATE := FND_API.G_MISS_DATE,
132: context VARCHAR2(30) := FND_API.G_MISS_CHAR,
133: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
134: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
135: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
136: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
137: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
130: active_start_date DATE := FND_API.G_MISS_DATE,
131: active_end_date DATE := FND_API.G_MISS_DATE,
132: context VARCHAR2(30) := FND_API.G_MISS_CHAR,
133: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
134: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
135: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
136: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
137: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
138: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
131: active_end_date DATE := FND_API.G_MISS_DATE,
132: context VARCHAR2(30) := FND_API.G_MISS_CHAR,
133: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
134: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
135: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
136: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
137: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
138: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
139: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
132: context VARCHAR2(30) := FND_API.G_MISS_CHAR,
133: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
134: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
135: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
136: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
137: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
138: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
139: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
140: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
133: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
134: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
135: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
136: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
137: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
138: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
139: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
140: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
141: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
134: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
135: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
136: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
137: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
138: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
139: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
140: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
141: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
142: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
135: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
136: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
137: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
138: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
139: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
140: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
141: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
142: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
143: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
136: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
137: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
138: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
139: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
140: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
141: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
142: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
143: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
144: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
137: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
138: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
139: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
140: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
141: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
142: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
143: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
144: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
145: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
138: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
139: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
140: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
141: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
142: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
143: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
144: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
145: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
146: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
139: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
140: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
141: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
142: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
143: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
144: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
145: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
146: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
147: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
140: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
141: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
142: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
143: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
144: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
145: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
146: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
147: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
148: object_version_number NUMBER := FND_API.G_MISS_NUM
141: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
142: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
143: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
144: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
145: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
146: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
147: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
148: object_version_number NUMBER := FND_API.G_MISS_NUM
149: );
142: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
143: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
144: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
145: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
146: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
147: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
148: object_version_number NUMBER := FND_API.G_MISS_NUM
149: );
150:
143: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
144: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
145: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
146: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
147: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
148: object_version_number NUMBER := FND_API.G_MISS_NUM
149: );
150:
151: TYPE txn_i_parties_tbl IS TABLE OF txn_i_party_rec INDEX BY BINARY_INTEGER;
144: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
145: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
146: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
147: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
148: object_version_number NUMBER := FND_API.G_MISS_NUM
149: );
150:
151: TYPE txn_i_parties_tbl IS TABLE OF txn_i_party_rec INDEX BY BINARY_INTEGER;
152:
153: -- Name : txn_ip_account_rec
154: -- Description : record to hold information about a party-account relationship.
155:
156: TYPE txn_ip_account_rec IS RECORD (
157: ip_account_id NUMBER := FND_API.G_MISS_NUM,
158: parent_tbl_index NUMBER := FND_API.G_MISS_NUM,
159: instance_party_id NUMBER := FND_API.G_MISS_NUM,
160: party_account_id NUMBER := FND_API.G_MISS_NUM,
161: relationship_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
154: -- Description : record to hold information about a party-account relationship.
155:
156: TYPE txn_ip_account_rec IS RECORD (
157: ip_account_id NUMBER := FND_API.G_MISS_NUM,
158: parent_tbl_index NUMBER := FND_API.G_MISS_NUM,
159: instance_party_id NUMBER := FND_API.G_MISS_NUM,
160: party_account_id NUMBER := FND_API.G_MISS_NUM,
161: relationship_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
162: bill_to_address NUMBER := FND_API.G_MISS_NUM,
155:
156: TYPE txn_ip_account_rec IS RECORD (
157: ip_account_id NUMBER := FND_API.G_MISS_NUM,
158: parent_tbl_index NUMBER := FND_API.G_MISS_NUM,
159: instance_party_id NUMBER := FND_API.G_MISS_NUM,
160: party_account_id NUMBER := FND_API.G_MISS_NUM,
161: relationship_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
162: bill_to_address NUMBER := FND_API.G_MISS_NUM,
163: ship_to_address NUMBER := FND_API.G_MISS_NUM,
156: TYPE txn_ip_account_rec IS RECORD (
157: ip_account_id NUMBER := FND_API.G_MISS_NUM,
158: parent_tbl_index NUMBER := FND_API.G_MISS_NUM,
159: instance_party_id NUMBER := FND_API.G_MISS_NUM,
160: party_account_id NUMBER := FND_API.G_MISS_NUM,
161: relationship_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
162: bill_to_address NUMBER := FND_API.G_MISS_NUM,
163: ship_to_address NUMBER := FND_API.G_MISS_NUM,
164: active_start_date DATE := FND_API.G_MISS_DATE,
157: ip_account_id NUMBER := FND_API.G_MISS_NUM,
158: parent_tbl_index NUMBER := FND_API.G_MISS_NUM,
159: instance_party_id NUMBER := FND_API.G_MISS_NUM,
160: party_account_id NUMBER := FND_API.G_MISS_NUM,
161: relationship_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
162: bill_to_address NUMBER := FND_API.G_MISS_NUM,
163: ship_to_address NUMBER := FND_API.G_MISS_NUM,
164: active_start_date DATE := FND_API.G_MISS_DATE,
165: active_end_date DATE := FND_API.G_MISS_DATE,
158: parent_tbl_index NUMBER := FND_API.G_MISS_NUM,
159: instance_party_id NUMBER := FND_API.G_MISS_NUM,
160: party_account_id NUMBER := FND_API.G_MISS_NUM,
161: relationship_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
162: bill_to_address NUMBER := FND_API.G_MISS_NUM,
163: ship_to_address NUMBER := FND_API.G_MISS_NUM,
164: active_start_date DATE := FND_API.G_MISS_DATE,
165: active_end_date DATE := FND_API.G_MISS_DATE,
166: context VARCHAR2(30) := FND_API.G_MISS_CHAR,
159: instance_party_id NUMBER := FND_API.G_MISS_NUM,
160: party_account_id NUMBER := FND_API.G_MISS_NUM,
161: relationship_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
162: bill_to_address NUMBER := FND_API.G_MISS_NUM,
163: ship_to_address NUMBER := FND_API.G_MISS_NUM,
164: active_start_date DATE := FND_API.G_MISS_DATE,
165: active_end_date DATE := FND_API.G_MISS_DATE,
166: context VARCHAR2(30) := FND_API.G_MISS_CHAR,
167: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
160: party_account_id NUMBER := FND_API.G_MISS_NUM,
161: relationship_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
162: bill_to_address NUMBER := FND_API.G_MISS_NUM,
163: ship_to_address NUMBER := FND_API.G_MISS_NUM,
164: active_start_date DATE := FND_API.G_MISS_DATE,
165: active_end_date DATE := FND_API.G_MISS_DATE,
166: context VARCHAR2(30) := FND_API.G_MISS_CHAR,
167: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
168: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
161: relationship_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
162: bill_to_address NUMBER := FND_API.G_MISS_NUM,
163: ship_to_address NUMBER := FND_API.G_MISS_NUM,
164: active_start_date DATE := FND_API.G_MISS_DATE,
165: active_end_date DATE := FND_API.G_MISS_DATE,
166: context VARCHAR2(30) := FND_API.G_MISS_CHAR,
167: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
168: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
169: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
162: bill_to_address NUMBER := FND_API.G_MISS_NUM,
163: ship_to_address NUMBER := FND_API.G_MISS_NUM,
164: active_start_date DATE := FND_API.G_MISS_DATE,
165: active_end_date DATE := FND_API.G_MISS_DATE,
166: context VARCHAR2(30) := FND_API.G_MISS_CHAR,
167: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
168: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
169: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
170: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
163: ship_to_address NUMBER := FND_API.G_MISS_NUM,
164: active_start_date DATE := FND_API.G_MISS_DATE,
165: active_end_date DATE := FND_API.G_MISS_DATE,
166: context VARCHAR2(30) := FND_API.G_MISS_CHAR,
167: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
168: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
169: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
170: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
171: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
164: active_start_date DATE := FND_API.G_MISS_DATE,
165: active_end_date DATE := FND_API.G_MISS_DATE,
166: context VARCHAR2(30) := FND_API.G_MISS_CHAR,
167: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
168: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
169: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
170: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
171: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
172: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
165: active_end_date DATE := FND_API.G_MISS_DATE,
166: context VARCHAR2(30) := FND_API.G_MISS_CHAR,
167: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
168: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
169: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
170: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
171: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
172: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
173: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
166: context VARCHAR2(30) := FND_API.G_MISS_CHAR,
167: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
168: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
169: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
170: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
171: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
172: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
173: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
174: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
167: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
168: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
169: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
170: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
171: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
172: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
173: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
174: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
175: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
168: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
169: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
170: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
171: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
172: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
173: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
174: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
175: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
176: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
169: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
170: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
171: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
172: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
173: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
174: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
175: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
176: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
177: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
170: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
171: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
172: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
173: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
174: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
175: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
176: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
177: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
178: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
171: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
172: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
173: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
174: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
175: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
176: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
177: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
178: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
179: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
172: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
173: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
174: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
175: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
176: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
177: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
178: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
179: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
180: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
173: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
174: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
175: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
176: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
177: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
178: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
179: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
180: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
181: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
174: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
175: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
176: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
177: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
178: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
179: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
180: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
181: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
182: object_version_number NUMBER := FND_API.G_MISS_NUM
175: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
176: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
177: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
178: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
179: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
180: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
181: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
182: object_version_number NUMBER := FND_API.G_MISS_NUM
183: );
176: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
177: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
178: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
179: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
180: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
181: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
182: object_version_number NUMBER := FND_API.G_MISS_NUM
183: );
184:
177: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
178: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
179: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
180: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
181: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
182: object_version_number NUMBER := FND_API.G_MISS_NUM
183: );
184:
185: TYPE txn_ip_accounts_tbl IS TABLE OF txn_ip_account_rec INDEX BY BINARY_INTEGER;
178: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
179: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
180: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
181: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
182: object_version_number NUMBER := FND_API.G_MISS_NUM
183: );
184:
185: TYPE txn_ip_accounts_tbl IS TABLE OF txn_ip_account_rec INDEX BY BINARY_INTEGER;
186:
187: -- Name : txn_ii_relationship_rec
188: -- Description : record to hold the attributes of an item instance relationship.
189:
190: TYPE txn_ii_relationship_rec IS RECORD (
191: RELATIONSHIP_ID NUMBER := FND_API.G_MISS_NUM,
192: RELATIONSHIP_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
193: OBJECT_INDEX NUMBER := FND_API.G_MISS_NUM,
194: OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
195: SUBJECT_INDEX NUMBER := FND_API.G_MISS_NUM,
188: -- Description : record to hold the attributes of an item instance relationship.
189:
190: TYPE txn_ii_relationship_rec IS RECORD (
191: RELATIONSHIP_ID NUMBER := FND_API.G_MISS_NUM,
192: RELATIONSHIP_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
193: OBJECT_INDEX NUMBER := FND_API.G_MISS_NUM,
194: OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
195: SUBJECT_INDEX NUMBER := FND_API.G_MISS_NUM,
196: SUBJECT_ID NUMBER := FND_API.G_MISS_NUM,
189:
190: TYPE txn_ii_relationship_rec IS RECORD (
191: RELATIONSHIP_ID NUMBER := FND_API.G_MISS_NUM,
192: RELATIONSHIP_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
193: OBJECT_INDEX NUMBER := FND_API.G_MISS_NUM,
194: OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
195: SUBJECT_INDEX NUMBER := FND_API.G_MISS_NUM,
196: SUBJECT_ID NUMBER := FND_API.G_MISS_NUM,
197: SUBJECT_HAS_CHILD VARCHAR2(1) := FND_API.G_MISS_CHAR,
190: TYPE txn_ii_relationship_rec IS RECORD (
191: RELATIONSHIP_ID NUMBER := FND_API.G_MISS_NUM,
192: RELATIONSHIP_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
193: OBJECT_INDEX NUMBER := FND_API.G_MISS_NUM,
194: OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
195: SUBJECT_INDEX NUMBER := FND_API.G_MISS_NUM,
196: SUBJECT_ID NUMBER := FND_API.G_MISS_NUM,
197: SUBJECT_HAS_CHILD VARCHAR2(1) := FND_API.G_MISS_CHAR,
198: POSITION_REFERENCE VARCHAR2(30) := FND_API.G_MISS_CHAR,
191: RELATIONSHIP_ID NUMBER := FND_API.G_MISS_NUM,
192: RELATIONSHIP_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
193: OBJECT_INDEX NUMBER := FND_API.G_MISS_NUM,
194: OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
195: SUBJECT_INDEX NUMBER := FND_API.G_MISS_NUM,
196: SUBJECT_ID NUMBER := FND_API.G_MISS_NUM,
197: SUBJECT_HAS_CHILD VARCHAR2(1) := FND_API.G_MISS_CHAR,
198: POSITION_REFERENCE VARCHAR2(30) := FND_API.G_MISS_CHAR,
199: ACTIVE_START_DATE DATE := FND_API.G_MISS_DATE,
192: RELATIONSHIP_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
193: OBJECT_INDEX NUMBER := FND_API.G_MISS_NUM,
194: OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
195: SUBJECT_INDEX NUMBER := FND_API.G_MISS_NUM,
196: SUBJECT_ID NUMBER := FND_API.G_MISS_NUM,
197: SUBJECT_HAS_CHILD VARCHAR2(1) := FND_API.G_MISS_CHAR,
198: POSITION_REFERENCE VARCHAR2(30) := FND_API.G_MISS_CHAR,
199: ACTIVE_START_DATE DATE := FND_API.G_MISS_DATE,
200: ACTIVE_END_DATE DATE := FND_API.G_MISS_DATE,
193: OBJECT_INDEX NUMBER := FND_API.G_MISS_NUM,
194: OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
195: SUBJECT_INDEX NUMBER := FND_API.G_MISS_NUM,
196: SUBJECT_ID NUMBER := FND_API.G_MISS_NUM,
197: SUBJECT_HAS_CHILD VARCHAR2(1) := FND_API.G_MISS_CHAR,
198: POSITION_REFERENCE VARCHAR2(30) := FND_API.G_MISS_CHAR,
199: ACTIVE_START_DATE DATE := FND_API.G_MISS_DATE,
200: ACTIVE_END_DATE DATE := FND_API.G_MISS_DATE,
201: DISPLAY_ORDER NUMBER := FND_API.G_MISS_NUM,
194: OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
195: SUBJECT_INDEX NUMBER := FND_API.G_MISS_NUM,
196: SUBJECT_ID NUMBER := FND_API.G_MISS_NUM,
197: SUBJECT_HAS_CHILD VARCHAR2(1) := FND_API.G_MISS_CHAR,
198: POSITION_REFERENCE VARCHAR2(30) := FND_API.G_MISS_CHAR,
199: ACTIVE_START_DATE DATE := FND_API.G_MISS_DATE,
200: ACTIVE_END_DATE DATE := FND_API.G_MISS_DATE,
201: DISPLAY_ORDER NUMBER := FND_API.G_MISS_NUM,
202: MANDATORY_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
195: SUBJECT_INDEX NUMBER := FND_API.G_MISS_NUM,
196: SUBJECT_ID NUMBER := FND_API.G_MISS_NUM,
197: SUBJECT_HAS_CHILD VARCHAR2(1) := FND_API.G_MISS_CHAR,
198: POSITION_REFERENCE VARCHAR2(30) := FND_API.G_MISS_CHAR,
199: ACTIVE_START_DATE DATE := FND_API.G_MISS_DATE,
200: ACTIVE_END_DATE DATE := FND_API.G_MISS_DATE,
201: DISPLAY_ORDER NUMBER := FND_API.G_MISS_NUM,
202: MANDATORY_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
203: CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
196: SUBJECT_ID NUMBER := FND_API.G_MISS_NUM,
197: SUBJECT_HAS_CHILD VARCHAR2(1) := FND_API.G_MISS_CHAR,
198: POSITION_REFERENCE VARCHAR2(30) := FND_API.G_MISS_CHAR,
199: ACTIVE_START_DATE DATE := FND_API.G_MISS_DATE,
200: ACTIVE_END_DATE DATE := FND_API.G_MISS_DATE,
201: DISPLAY_ORDER NUMBER := FND_API.G_MISS_NUM,
202: MANDATORY_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
203: CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
204: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
197: SUBJECT_HAS_CHILD VARCHAR2(1) := FND_API.G_MISS_CHAR,
198: POSITION_REFERENCE VARCHAR2(30) := FND_API.G_MISS_CHAR,
199: ACTIVE_START_DATE DATE := FND_API.G_MISS_DATE,
200: ACTIVE_END_DATE DATE := FND_API.G_MISS_DATE,
201: DISPLAY_ORDER NUMBER := FND_API.G_MISS_NUM,
202: MANDATORY_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
203: CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
204: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
205: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
198: POSITION_REFERENCE VARCHAR2(30) := FND_API.G_MISS_CHAR,
199: ACTIVE_START_DATE DATE := FND_API.G_MISS_DATE,
200: ACTIVE_END_DATE DATE := FND_API.G_MISS_DATE,
201: DISPLAY_ORDER NUMBER := FND_API.G_MISS_NUM,
202: MANDATORY_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
203: CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
204: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
205: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
206: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
199: ACTIVE_START_DATE DATE := FND_API.G_MISS_DATE,
200: ACTIVE_END_DATE DATE := FND_API.G_MISS_DATE,
201: DISPLAY_ORDER NUMBER := FND_API.G_MISS_NUM,
202: MANDATORY_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
203: CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
204: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
205: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
206: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
207: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
200: ACTIVE_END_DATE DATE := FND_API.G_MISS_DATE,
201: DISPLAY_ORDER NUMBER := FND_API.G_MISS_NUM,
202: MANDATORY_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
203: CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
204: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
205: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
206: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
207: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
208: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
201: DISPLAY_ORDER NUMBER := FND_API.G_MISS_NUM,
202: MANDATORY_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
203: CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
204: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
205: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
206: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
207: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
208: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
209: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
202: MANDATORY_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
203: CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
204: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
205: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
206: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
207: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
208: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
209: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
210: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
203: CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
204: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
205: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
206: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
207: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
208: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
209: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
210: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
211: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
204: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
205: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
206: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
207: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
208: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
209: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
210: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
211: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
212: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
205: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
206: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
207: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
208: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
209: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
210: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
211: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
212: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
213: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
206: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
207: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
208: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
209: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
210: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
211: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
212: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
213: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
214: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
207: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
208: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
209: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
210: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
211: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
212: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
213: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
214: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
215: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
208: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
209: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
210: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
211: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
212: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
213: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
214: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
215: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
216: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
209: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
210: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
211: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
212: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
213: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
214: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
215: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
216: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
217: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
210: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
211: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
212: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
213: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
214: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
215: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
216: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
217: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
218: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
211: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
212: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
213: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
214: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
215: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
216: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
217: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
218: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
219: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
212: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
213: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
214: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
215: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
216: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
217: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
218: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
219: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
220: );
213: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
214: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
215: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
216: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
217: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
218: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
219: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
220: );
221:
214: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
215: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
216: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
217: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
218: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
219: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
220: );
221:
222: TYPE txn_ii_relationships_tbl IS TABLE OF txn_ii_relationship_rec INDEX BY BINARY_INTEGER;
215: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
216: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
217: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
218: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
219: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
220: );
221:
222: TYPE txn_ii_relationships_tbl IS TABLE OF txn_ii_relationship_rec INDEX BY BINARY_INTEGER;
223:
224: -- Name : txn_ext_attrib_value_rec
225: -- Description : record to hold the values of an item instances extended attributes.
226:
227: TYPE txn_ext_attrib_value_rec IS RECORD (
228: attribute_value_id NUMBER := FND_API.G_MISS_NUM,
229: parent_tbl_index NUMBER := FND_API.G_MISS_NUM,
230: instance_id NUMBER := FND_API.G_MISS_NUM,
231: attribute_id NUMBER := FND_API.G_MISS_NUM,
232: attribute_code VARCHAR2(30) := fnd_api.g_miss_char ,
225: -- Description : record to hold the values of an item instances extended attributes.
226:
227: TYPE txn_ext_attrib_value_rec IS RECORD (
228: attribute_value_id NUMBER := FND_API.G_MISS_NUM,
229: parent_tbl_index NUMBER := FND_API.G_MISS_NUM,
230: instance_id NUMBER := FND_API.G_MISS_NUM,
231: attribute_id NUMBER := FND_API.G_MISS_NUM,
232: attribute_code VARCHAR2(30) := fnd_api.g_miss_char ,
233: attribute_value VARCHAR2(240) := FND_API.G_MISS_CHAR,
226:
227: TYPE txn_ext_attrib_value_rec IS RECORD (
228: attribute_value_id NUMBER := FND_API.G_MISS_NUM,
229: parent_tbl_index NUMBER := FND_API.G_MISS_NUM,
230: instance_id NUMBER := FND_API.G_MISS_NUM,
231: attribute_id NUMBER := FND_API.G_MISS_NUM,
232: attribute_code VARCHAR2(30) := fnd_api.g_miss_char ,
233: attribute_value VARCHAR2(240) := FND_API.G_MISS_CHAR,
234: active_start_date DATE := FND_API.G_MISS_DATE,
227: TYPE txn_ext_attrib_value_rec IS RECORD (
228: attribute_value_id NUMBER := FND_API.G_MISS_NUM,
229: parent_tbl_index NUMBER := FND_API.G_MISS_NUM,
230: instance_id NUMBER := FND_API.G_MISS_NUM,
231: attribute_id NUMBER := FND_API.G_MISS_NUM,
232: attribute_code VARCHAR2(30) := fnd_api.g_miss_char ,
233: attribute_value VARCHAR2(240) := FND_API.G_MISS_CHAR,
234: active_start_date DATE := FND_API.G_MISS_DATE,
235: active_end_date DATE := FND_API.G_MISS_DATE,
228: attribute_value_id NUMBER := FND_API.G_MISS_NUM,
229: parent_tbl_index NUMBER := FND_API.G_MISS_NUM,
230: instance_id NUMBER := FND_API.G_MISS_NUM,
231: attribute_id NUMBER := FND_API.G_MISS_NUM,
232: attribute_code VARCHAR2(30) := fnd_api.g_miss_char ,
233: attribute_value VARCHAR2(240) := FND_API.G_MISS_CHAR,
234: active_start_date DATE := FND_API.G_MISS_DATE,
235: active_end_date DATE := FND_API.G_MISS_DATE,
236: context VARCHAR2(30) := FND_API.G_MISS_CHAR,
229: parent_tbl_index NUMBER := FND_API.G_MISS_NUM,
230: instance_id NUMBER := FND_API.G_MISS_NUM,
231: attribute_id NUMBER := FND_API.G_MISS_NUM,
232: attribute_code VARCHAR2(30) := fnd_api.g_miss_char ,
233: attribute_value VARCHAR2(240) := FND_API.G_MISS_CHAR,
234: active_start_date DATE := FND_API.G_MISS_DATE,
235: active_end_date DATE := FND_API.G_MISS_DATE,
236: context VARCHAR2(30) := FND_API.G_MISS_CHAR,
237: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
230: instance_id NUMBER := FND_API.G_MISS_NUM,
231: attribute_id NUMBER := FND_API.G_MISS_NUM,
232: attribute_code VARCHAR2(30) := fnd_api.g_miss_char ,
233: attribute_value VARCHAR2(240) := FND_API.G_MISS_CHAR,
234: active_start_date DATE := FND_API.G_MISS_DATE,
235: active_end_date DATE := FND_API.G_MISS_DATE,
236: context VARCHAR2(30) := FND_API.G_MISS_CHAR,
237: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
238: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
231: attribute_id NUMBER := FND_API.G_MISS_NUM,
232: attribute_code VARCHAR2(30) := fnd_api.g_miss_char ,
233: attribute_value VARCHAR2(240) := FND_API.G_MISS_CHAR,
234: active_start_date DATE := FND_API.G_MISS_DATE,
235: active_end_date DATE := FND_API.G_MISS_DATE,
236: context VARCHAR2(30) := FND_API.G_MISS_CHAR,
237: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
238: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
239: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
232: attribute_code VARCHAR2(30) := fnd_api.g_miss_char ,
233: attribute_value VARCHAR2(240) := FND_API.G_MISS_CHAR,
234: active_start_date DATE := FND_API.G_MISS_DATE,
235: active_end_date DATE := FND_API.G_MISS_DATE,
236: context VARCHAR2(30) := FND_API.G_MISS_CHAR,
237: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
238: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
239: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
240: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
233: attribute_value VARCHAR2(240) := FND_API.G_MISS_CHAR,
234: active_start_date DATE := FND_API.G_MISS_DATE,
235: active_end_date DATE := FND_API.G_MISS_DATE,
236: context VARCHAR2(30) := FND_API.G_MISS_CHAR,
237: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
238: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
239: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
240: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
241: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
234: active_start_date DATE := FND_API.G_MISS_DATE,
235: active_end_date DATE := FND_API.G_MISS_DATE,
236: context VARCHAR2(30) := FND_API.G_MISS_CHAR,
237: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
238: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
239: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
240: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
241: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
242: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
235: active_end_date DATE := FND_API.G_MISS_DATE,
236: context VARCHAR2(30) := FND_API.G_MISS_CHAR,
237: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
238: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
239: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
240: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
241: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
242: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
243: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
236: context VARCHAR2(30) := FND_API.G_MISS_CHAR,
237: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
238: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
239: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
240: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
241: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
242: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
243: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
244: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
237: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
238: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
239: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
240: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
241: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
242: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
243: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
244: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
245: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
238: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
239: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
240: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
241: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
242: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
243: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
244: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
245: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
246: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
239: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
240: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
241: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
242: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
243: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
244: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
245: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
246: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
247: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
240: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
241: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
242: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
243: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
244: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
245: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
246: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
247: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
248: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
241: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
242: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
243: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
244: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
245: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
246: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
247: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
248: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
249: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
242: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
243: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
244: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
245: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
246: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
247: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
248: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
249: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
250: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
243: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
244: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
245: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
246: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
247: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
248: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
249: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
250: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
251: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
244: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
245: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
246: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
247: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
248: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
249: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
250: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
251: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
252: object_version_number NUMBER := FND_API.G_MISS_NUM
245: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
246: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
247: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
248: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
249: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
250: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
251: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
252: object_version_number NUMBER := FND_API.G_MISS_NUM
253: );
246: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
247: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
248: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
249: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
250: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
251: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
252: object_version_number NUMBER := FND_API.G_MISS_NUM
253: );
254:
247: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
248: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
249: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
250: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
251: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
252: object_version_number NUMBER := FND_API.G_MISS_NUM
253: );
254:
255:
248: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
249: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
250: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
251: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
252: object_version_number NUMBER := FND_API.G_MISS_NUM
253: );
254:
255:
256: TYPE txn_ext_attrib_values_tbl IS table of txn_ext_attrib_value_rec INDEX BY BINARY_INTEGER;
259: -- Description : record to hold the pricing attributes of an item instance.
260:
261:
262: TYPE txn_pricing_attrib_rec IS RECORD (
263: pricing_attribute_id NUMBER := FND_API.G_MISS_NUM,
264: parent_tbl_index NUMBER := FND_API.G_MISS_NUM,
265: instance_id NUMBER := FND_API.G_MISS_NUM,
266: active_start_date DATE := FND_API.G_MISS_DATE,
267: active_end_date DATE := FND_API.G_MISS_DATE,
260:
261:
262: TYPE txn_pricing_attrib_rec IS RECORD (
263: pricing_attribute_id NUMBER := FND_API.G_MISS_NUM,
264: parent_tbl_index NUMBER := FND_API.G_MISS_NUM,
265: instance_id NUMBER := FND_API.G_MISS_NUM,
266: active_start_date DATE := FND_API.G_MISS_DATE,
267: active_end_date DATE := FND_API.G_MISS_DATE,
268: pricing_context VARCHAR2(30) := FND_API.G_MISS_CHAR,
261:
262: TYPE txn_pricing_attrib_rec IS RECORD (
263: pricing_attribute_id NUMBER := FND_API.G_MISS_NUM,
264: parent_tbl_index NUMBER := FND_API.G_MISS_NUM,
265: instance_id NUMBER := FND_API.G_MISS_NUM,
266: active_start_date DATE := FND_API.G_MISS_DATE,
267: active_end_date DATE := FND_API.G_MISS_DATE,
268: pricing_context VARCHAR2(30) := FND_API.G_MISS_CHAR,
269: pricing_attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
262: TYPE txn_pricing_attrib_rec IS RECORD (
263: pricing_attribute_id NUMBER := FND_API.G_MISS_NUM,
264: parent_tbl_index NUMBER := FND_API.G_MISS_NUM,
265: instance_id NUMBER := FND_API.G_MISS_NUM,
266: active_start_date DATE := FND_API.G_MISS_DATE,
267: active_end_date DATE := FND_API.G_MISS_DATE,
268: pricing_context VARCHAR2(30) := FND_API.G_MISS_CHAR,
269: pricing_attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
270: pricing_attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
263: pricing_attribute_id NUMBER := FND_API.G_MISS_NUM,
264: parent_tbl_index NUMBER := FND_API.G_MISS_NUM,
265: instance_id NUMBER := FND_API.G_MISS_NUM,
266: active_start_date DATE := FND_API.G_MISS_DATE,
267: active_end_date DATE := FND_API.G_MISS_DATE,
268: pricing_context VARCHAR2(30) := FND_API.G_MISS_CHAR,
269: pricing_attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
270: pricing_attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
271: pricing_attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
264: parent_tbl_index NUMBER := FND_API.G_MISS_NUM,
265: instance_id NUMBER := FND_API.G_MISS_NUM,
266: active_start_date DATE := FND_API.G_MISS_DATE,
267: active_end_date DATE := FND_API.G_MISS_DATE,
268: pricing_context VARCHAR2(30) := FND_API.G_MISS_CHAR,
269: pricing_attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
270: pricing_attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
271: pricing_attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
272: pricing_attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
265: instance_id NUMBER := FND_API.G_MISS_NUM,
266: active_start_date DATE := FND_API.G_MISS_DATE,
267: active_end_date DATE := FND_API.G_MISS_DATE,
268: pricing_context VARCHAR2(30) := FND_API.G_MISS_CHAR,
269: pricing_attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
270: pricing_attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
271: pricing_attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
272: pricing_attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
273: pricing_attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
266: active_start_date DATE := FND_API.G_MISS_DATE,
267: active_end_date DATE := FND_API.G_MISS_DATE,
268: pricing_context VARCHAR2(30) := FND_API.G_MISS_CHAR,
269: pricing_attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
270: pricing_attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
271: pricing_attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
272: pricing_attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
273: pricing_attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
274: pricing_attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
267: active_end_date DATE := FND_API.G_MISS_DATE,
268: pricing_context VARCHAR2(30) := FND_API.G_MISS_CHAR,
269: pricing_attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
270: pricing_attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
271: pricing_attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
272: pricing_attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
273: pricing_attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
274: pricing_attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
275: pricing_attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
268: pricing_context VARCHAR2(30) := FND_API.G_MISS_CHAR,
269: pricing_attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
270: pricing_attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
271: pricing_attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
272: pricing_attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
273: pricing_attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
274: pricing_attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
275: pricing_attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
276: pricing_attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
269: pricing_attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
270: pricing_attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
271: pricing_attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
272: pricing_attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
273: pricing_attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
274: pricing_attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
275: pricing_attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
276: pricing_attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
277: pricing_attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
270: pricing_attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
271: pricing_attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
272: pricing_attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
273: pricing_attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
274: pricing_attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
275: pricing_attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
276: pricing_attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
277: pricing_attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
278: pricing_attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
271: pricing_attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
272: pricing_attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
273: pricing_attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
274: pricing_attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
275: pricing_attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
276: pricing_attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
277: pricing_attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
278: pricing_attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
279: pricing_attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
272: pricing_attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
273: pricing_attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
274: pricing_attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
275: pricing_attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
276: pricing_attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
277: pricing_attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
278: pricing_attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
279: pricing_attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
280: pricing_attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
273: pricing_attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
274: pricing_attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
275: pricing_attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
276: pricing_attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
277: pricing_attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
278: pricing_attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
279: pricing_attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
280: pricing_attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
281: pricing_attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
274: pricing_attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
275: pricing_attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
276: pricing_attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
277: pricing_attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
278: pricing_attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
279: pricing_attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
280: pricing_attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
281: pricing_attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
282: pricing_attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
275: pricing_attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
276: pricing_attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
277: pricing_attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
278: pricing_attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
279: pricing_attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
280: pricing_attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
281: pricing_attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
282: pricing_attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
283: pricing_attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
276: pricing_attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
277: pricing_attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
278: pricing_attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
279: pricing_attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
280: pricing_attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
281: pricing_attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
282: pricing_attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
283: pricing_attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
284: pricing_attribute16 VARCHAR2(150) := FND_API.G_MISS_CHAR,
277: pricing_attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
278: pricing_attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
279: pricing_attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
280: pricing_attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
281: pricing_attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
282: pricing_attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
283: pricing_attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
284: pricing_attribute16 VARCHAR2(150) := FND_API.G_MISS_CHAR,
285: pricing_attribute17 VARCHAR2(150) := FND_API.G_MISS_CHAR,
278: pricing_attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
279: pricing_attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
280: pricing_attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
281: pricing_attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
282: pricing_attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
283: pricing_attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
284: pricing_attribute16 VARCHAR2(150) := FND_API.G_MISS_CHAR,
285: pricing_attribute17 VARCHAR2(150) := FND_API.G_MISS_CHAR,
286: pricing_attribute18 VARCHAR2(150) := FND_API.G_MISS_CHAR,
279: pricing_attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
280: pricing_attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
281: pricing_attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
282: pricing_attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
283: pricing_attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
284: pricing_attribute16 VARCHAR2(150) := FND_API.G_MISS_CHAR,
285: pricing_attribute17 VARCHAR2(150) := FND_API.G_MISS_CHAR,
286: pricing_attribute18 VARCHAR2(150) := FND_API.G_MISS_CHAR,
287: pricing_attribute19 VARCHAR2(150) := FND_API.G_MISS_CHAR,
280: pricing_attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
281: pricing_attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
282: pricing_attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
283: pricing_attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
284: pricing_attribute16 VARCHAR2(150) := FND_API.G_MISS_CHAR,
285: pricing_attribute17 VARCHAR2(150) := FND_API.G_MISS_CHAR,
286: pricing_attribute18 VARCHAR2(150) := FND_API.G_MISS_CHAR,
287: pricing_attribute19 VARCHAR2(150) := FND_API.G_MISS_CHAR,
288: pricing_attribute20 VARCHAR2(150) := FND_API.G_MISS_CHAR,
281: pricing_attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
282: pricing_attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
283: pricing_attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
284: pricing_attribute16 VARCHAR2(150) := FND_API.G_MISS_CHAR,
285: pricing_attribute17 VARCHAR2(150) := FND_API.G_MISS_CHAR,
286: pricing_attribute18 VARCHAR2(150) := FND_API.G_MISS_CHAR,
287: pricing_attribute19 VARCHAR2(150) := FND_API.G_MISS_CHAR,
288: pricing_attribute20 VARCHAR2(150) := FND_API.G_MISS_CHAR,
289: pricing_attribute21 VARCHAR2(150) := FND_API.G_MISS_CHAR,
282: pricing_attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
283: pricing_attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
284: pricing_attribute16 VARCHAR2(150) := FND_API.G_MISS_CHAR,
285: pricing_attribute17 VARCHAR2(150) := FND_API.G_MISS_CHAR,
286: pricing_attribute18 VARCHAR2(150) := FND_API.G_MISS_CHAR,
287: pricing_attribute19 VARCHAR2(150) := FND_API.G_MISS_CHAR,
288: pricing_attribute20 VARCHAR2(150) := FND_API.G_MISS_CHAR,
289: pricing_attribute21 VARCHAR2(150) := FND_API.G_MISS_CHAR,
290: pricing_attribute22 VARCHAR2(150) := FND_API.G_MISS_CHAR,
283: pricing_attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
284: pricing_attribute16 VARCHAR2(150) := FND_API.G_MISS_CHAR,
285: pricing_attribute17 VARCHAR2(150) := FND_API.G_MISS_CHAR,
286: pricing_attribute18 VARCHAR2(150) := FND_API.G_MISS_CHAR,
287: pricing_attribute19 VARCHAR2(150) := FND_API.G_MISS_CHAR,
288: pricing_attribute20 VARCHAR2(150) := FND_API.G_MISS_CHAR,
289: pricing_attribute21 VARCHAR2(150) := FND_API.G_MISS_CHAR,
290: pricing_attribute22 VARCHAR2(150) := FND_API.G_MISS_CHAR,
291: pricing_attribute23 VARCHAR2(150) := FND_API.G_MISS_CHAR,
284: pricing_attribute16 VARCHAR2(150) := FND_API.G_MISS_CHAR,
285: pricing_attribute17 VARCHAR2(150) := FND_API.G_MISS_CHAR,
286: pricing_attribute18 VARCHAR2(150) := FND_API.G_MISS_CHAR,
287: pricing_attribute19 VARCHAR2(150) := FND_API.G_MISS_CHAR,
288: pricing_attribute20 VARCHAR2(150) := FND_API.G_MISS_CHAR,
289: pricing_attribute21 VARCHAR2(150) := FND_API.G_MISS_CHAR,
290: pricing_attribute22 VARCHAR2(150) := FND_API.G_MISS_CHAR,
291: pricing_attribute23 VARCHAR2(150) := FND_API.G_MISS_CHAR,
292: pricing_attribute24 VARCHAR2(150) := FND_API.G_MISS_CHAR,
285: pricing_attribute17 VARCHAR2(150) := FND_API.G_MISS_CHAR,
286: pricing_attribute18 VARCHAR2(150) := FND_API.G_MISS_CHAR,
287: pricing_attribute19 VARCHAR2(150) := FND_API.G_MISS_CHAR,
288: pricing_attribute20 VARCHAR2(150) := FND_API.G_MISS_CHAR,
289: pricing_attribute21 VARCHAR2(150) := FND_API.G_MISS_CHAR,
290: pricing_attribute22 VARCHAR2(150) := FND_API.G_MISS_CHAR,
291: pricing_attribute23 VARCHAR2(150) := FND_API.G_MISS_CHAR,
292: pricing_attribute24 VARCHAR2(150) := FND_API.G_MISS_CHAR,
293: pricing_attribute25 VARCHAR2(150) := FND_API.G_MISS_CHAR,
286: pricing_attribute18 VARCHAR2(150) := FND_API.G_MISS_CHAR,
287: pricing_attribute19 VARCHAR2(150) := FND_API.G_MISS_CHAR,
288: pricing_attribute20 VARCHAR2(150) := FND_API.G_MISS_CHAR,
289: pricing_attribute21 VARCHAR2(150) := FND_API.G_MISS_CHAR,
290: pricing_attribute22 VARCHAR2(150) := FND_API.G_MISS_CHAR,
291: pricing_attribute23 VARCHAR2(150) := FND_API.G_MISS_CHAR,
292: pricing_attribute24 VARCHAR2(150) := FND_API.G_MISS_CHAR,
293: pricing_attribute25 VARCHAR2(150) := FND_API.G_MISS_CHAR,
294: pricing_attribute26 VARCHAR2(150) := FND_API.G_MISS_CHAR,
287: pricing_attribute19 VARCHAR2(150) := FND_API.G_MISS_CHAR,
288: pricing_attribute20 VARCHAR2(150) := FND_API.G_MISS_CHAR,
289: pricing_attribute21 VARCHAR2(150) := FND_API.G_MISS_CHAR,
290: pricing_attribute22 VARCHAR2(150) := FND_API.G_MISS_CHAR,
291: pricing_attribute23 VARCHAR2(150) := FND_API.G_MISS_CHAR,
292: pricing_attribute24 VARCHAR2(150) := FND_API.G_MISS_CHAR,
293: pricing_attribute25 VARCHAR2(150) := FND_API.G_MISS_CHAR,
294: pricing_attribute26 VARCHAR2(150) := FND_API.G_MISS_CHAR,
295: pricing_attribute27 VARCHAR2(150) := FND_API.G_MISS_CHAR,
288: pricing_attribute20 VARCHAR2(150) := FND_API.G_MISS_CHAR,
289: pricing_attribute21 VARCHAR2(150) := FND_API.G_MISS_CHAR,
290: pricing_attribute22 VARCHAR2(150) := FND_API.G_MISS_CHAR,
291: pricing_attribute23 VARCHAR2(150) := FND_API.G_MISS_CHAR,
292: pricing_attribute24 VARCHAR2(150) := FND_API.G_MISS_CHAR,
293: pricing_attribute25 VARCHAR2(150) := FND_API.G_MISS_CHAR,
294: pricing_attribute26 VARCHAR2(150) := FND_API.G_MISS_CHAR,
295: pricing_attribute27 VARCHAR2(150) := FND_API.G_MISS_CHAR,
296: pricing_attribute28 VARCHAR2(150) := FND_API.G_MISS_CHAR,
289: pricing_attribute21 VARCHAR2(150) := FND_API.G_MISS_CHAR,
290: pricing_attribute22 VARCHAR2(150) := FND_API.G_MISS_CHAR,
291: pricing_attribute23 VARCHAR2(150) := FND_API.G_MISS_CHAR,
292: pricing_attribute24 VARCHAR2(150) := FND_API.G_MISS_CHAR,
293: pricing_attribute25 VARCHAR2(150) := FND_API.G_MISS_CHAR,
294: pricing_attribute26 VARCHAR2(150) := FND_API.G_MISS_CHAR,
295: pricing_attribute27 VARCHAR2(150) := FND_API.G_MISS_CHAR,
296: pricing_attribute28 VARCHAR2(150) := FND_API.G_MISS_CHAR,
297: pricing_attribute29 VARCHAR2(150) := FND_API.G_MISS_CHAR,
290: pricing_attribute22 VARCHAR2(150) := FND_API.G_MISS_CHAR,
291: pricing_attribute23 VARCHAR2(150) := FND_API.G_MISS_CHAR,
292: pricing_attribute24 VARCHAR2(150) := FND_API.G_MISS_CHAR,
293: pricing_attribute25 VARCHAR2(150) := FND_API.G_MISS_CHAR,
294: pricing_attribute26 VARCHAR2(150) := FND_API.G_MISS_CHAR,
295: pricing_attribute27 VARCHAR2(150) := FND_API.G_MISS_CHAR,
296: pricing_attribute28 VARCHAR2(150) := FND_API.G_MISS_CHAR,
297: pricing_attribute29 VARCHAR2(150) := FND_API.G_MISS_CHAR,
298: pricing_attribute30 VARCHAR2(150) := FND_API.G_MISS_CHAR,
291: pricing_attribute23 VARCHAR2(150) := FND_API.G_MISS_CHAR,
292: pricing_attribute24 VARCHAR2(150) := FND_API.G_MISS_CHAR,
293: pricing_attribute25 VARCHAR2(150) := FND_API.G_MISS_CHAR,
294: pricing_attribute26 VARCHAR2(150) := FND_API.G_MISS_CHAR,
295: pricing_attribute27 VARCHAR2(150) := FND_API.G_MISS_CHAR,
296: pricing_attribute28 VARCHAR2(150) := FND_API.G_MISS_CHAR,
297: pricing_attribute29 VARCHAR2(150) := FND_API.G_MISS_CHAR,
298: pricing_attribute30 VARCHAR2(150) := FND_API.G_MISS_CHAR,
299: pricing_attribute31 VARCHAR2(150) := FND_API.G_MISS_CHAR,
292: pricing_attribute24 VARCHAR2(150) := FND_API.G_MISS_CHAR,
293: pricing_attribute25 VARCHAR2(150) := FND_API.G_MISS_CHAR,
294: pricing_attribute26 VARCHAR2(150) := FND_API.G_MISS_CHAR,
295: pricing_attribute27 VARCHAR2(150) := FND_API.G_MISS_CHAR,
296: pricing_attribute28 VARCHAR2(150) := FND_API.G_MISS_CHAR,
297: pricing_attribute29 VARCHAR2(150) := FND_API.G_MISS_CHAR,
298: pricing_attribute30 VARCHAR2(150) := FND_API.G_MISS_CHAR,
299: pricing_attribute31 VARCHAR2(150) := FND_API.G_MISS_CHAR,
300: pricing_attribute32 VARCHAR2(150) := FND_API.G_MISS_CHAR,
293: pricing_attribute25 VARCHAR2(150) := FND_API.G_MISS_CHAR,
294: pricing_attribute26 VARCHAR2(150) := FND_API.G_MISS_CHAR,
295: pricing_attribute27 VARCHAR2(150) := FND_API.G_MISS_CHAR,
296: pricing_attribute28 VARCHAR2(150) := FND_API.G_MISS_CHAR,
297: pricing_attribute29 VARCHAR2(150) := FND_API.G_MISS_CHAR,
298: pricing_attribute30 VARCHAR2(150) := FND_API.G_MISS_CHAR,
299: pricing_attribute31 VARCHAR2(150) := FND_API.G_MISS_CHAR,
300: pricing_attribute32 VARCHAR2(150) := FND_API.G_MISS_CHAR,
301: pricing_attribute33 VARCHAR2(150) := FND_API.G_MISS_CHAR,
294: pricing_attribute26 VARCHAR2(150) := FND_API.G_MISS_CHAR,
295: pricing_attribute27 VARCHAR2(150) := FND_API.G_MISS_CHAR,
296: pricing_attribute28 VARCHAR2(150) := FND_API.G_MISS_CHAR,
297: pricing_attribute29 VARCHAR2(150) := FND_API.G_MISS_CHAR,
298: pricing_attribute30 VARCHAR2(150) := FND_API.G_MISS_CHAR,
299: pricing_attribute31 VARCHAR2(150) := FND_API.G_MISS_CHAR,
300: pricing_attribute32 VARCHAR2(150) := FND_API.G_MISS_CHAR,
301: pricing_attribute33 VARCHAR2(150) := FND_API.G_MISS_CHAR,
302: pricing_attribute34 VARCHAR2(150) := FND_API.G_MISS_CHAR,
295: pricing_attribute27 VARCHAR2(150) := FND_API.G_MISS_CHAR,
296: pricing_attribute28 VARCHAR2(150) := FND_API.G_MISS_CHAR,
297: pricing_attribute29 VARCHAR2(150) := FND_API.G_MISS_CHAR,
298: pricing_attribute30 VARCHAR2(150) := FND_API.G_MISS_CHAR,
299: pricing_attribute31 VARCHAR2(150) := FND_API.G_MISS_CHAR,
300: pricing_attribute32 VARCHAR2(150) := FND_API.G_MISS_CHAR,
301: pricing_attribute33 VARCHAR2(150) := FND_API.G_MISS_CHAR,
302: pricing_attribute34 VARCHAR2(150) := FND_API.G_MISS_CHAR,
303: pricing_attribute35 VARCHAR2(150) := FND_API.G_MISS_CHAR,
296: pricing_attribute28 VARCHAR2(150) := FND_API.G_MISS_CHAR,
297: pricing_attribute29 VARCHAR2(150) := FND_API.G_MISS_CHAR,
298: pricing_attribute30 VARCHAR2(150) := FND_API.G_MISS_CHAR,
299: pricing_attribute31 VARCHAR2(150) := FND_API.G_MISS_CHAR,
300: pricing_attribute32 VARCHAR2(150) := FND_API.G_MISS_CHAR,
301: pricing_attribute33 VARCHAR2(150) := FND_API.G_MISS_CHAR,
302: pricing_attribute34 VARCHAR2(150) := FND_API.G_MISS_CHAR,
303: pricing_attribute35 VARCHAR2(150) := FND_API.G_MISS_CHAR,
304: pricing_attribute36 VARCHAR2(150) := FND_API.G_MISS_CHAR,
297: pricing_attribute29 VARCHAR2(150) := FND_API.G_MISS_CHAR,
298: pricing_attribute30 VARCHAR2(150) := FND_API.G_MISS_CHAR,
299: pricing_attribute31 VARCHAR2(150) := FND_API.G_MISS_CHAR,
300: pricing_attribute32 VARCHAR2(150) := FND_API.G_MISS_CHAR,
301: pricing_attribute33 VARCHAR2(150) := FND_API.G_MISS_CHAR,
302: pricing_attribute34 VARCHAR2(150) := FND_API.G_MISS_CHAR,
303: pricing_attribute35 VARCHAR2(150) := FND_API.G_MISS_CHAR,
304: pricing_attribute36 VARCHAR2(150) := FND_API.G_MISS_CHAR,
305: pricing_attribute37 VARCHAR2(150) := FND_API.G_MISS_CHAR,
298: pricing_attribute30 VARCHAR2(150) := FND_API.G_MISS_CHAR,
299: pricing_attribute31 VARCHAR2(150) := FND_API.G_MISS_CHAR,
300: pricing_attribute32 VARCHAR2(150) := FND_API.G_MISS_CHAR,
301: pricing_attribute33 VARCHAR2(150) := FND_API.G_MISS_CHAR,
302: pricing_attribute34 VARCHAR2(150) := FND_API.G_MISS_CHAR,
303: pricing_attribute35 VARCHAR2(150) := FND_API.G_MISS_CHAR,
304: pricing_attribute36 VARCHAR2(150) := FND_API.G_MISS_CHAR,
305: pricing_attribute37 VARCHAR2(150) := FND_API.G_MISS_CHAR,
306: pricing_attribute38 VARCHAR2(150) := FND_API.G_MISS_CHAR,
299: pricing_attribute31 VARCHAR2(150) := FND_API.G_MISS_CHAR,
300: pricing_attribute32 VARCHAR2(150) := FND_API.G_MISS_CHAR,
301: pricing_attribute33 VARCHAR2(150) := FND_API.G_MISS_CHAR,
302: pricing_attribute34 VARCHAR2(150) := FND_API.G_MISS_CHAR,
303: pricing_attribute35 VARCHAR2(150) := FND_API.G_MISS_CHAR,
304: pricing_attribute36 VARCHAR2(150) := FND_API.G_MISS_CHAR,
305: pricing_attribute37 VARCHAR2(150) := FND_API.G_MISS_CHAR,
306: pricing_attribute38 VARCHAR2(150) := FND_API.G_MISS_CHAR,
307: pricing_attribute39 VARCHAR2(150) := FND_API.G_MISS_CHAR,
300: pricing_attribute32 VARCHAR2(150) := FND_API.G_MISS_CHAR,
301: pricing_attribute33 VARCHAR2(150) := FND_API.G_MISS_CHAR,
302: pricing_attribute34 VARCHAR2(150) := FND_API.G_MISS_CHAR,
303: pricing_attribute35 VARCHAR2(150) := FND_API.G_MISS_CHAR,
304: pricing_attribute36 VARCHAR2(150) := FND_API.G_MISS_CHAR,
305: pricing_attribute37 VARCHAR2(150) := FND_API.G_MISS_CHAR,
306: pricing_attribute38 VARCHAR2(150) := FND_API.G_MISS_CHAR,
307: pricing_attribute39 VARCHAR2(150) := FND_API.G_MISS_CHAR,
308: pricing_attribute40 VARCHAR2(150) := FND_API.G_MISS_CHAR,
301: pricing_attribute33 VARCHAR2(150) := FND_API.G_MISS_CHAR,
302: pricing_attribute34 VARCHAR2(150) := FND_API.G_MISS_CHAR,
303: pricing_attribute35 VARCHAR2(150) := FND_API.G_MISS_CHAR,
304: pricing_attribute36 VARCHAR2(150) := FND_API.G_MISS_CHAR,
305: pricing_attribute37 VARCHAR2(150) := FND_API.G_MISS_CHAR,
306: pricing_attribute38 VARCHAR2(150) := FND_API.G_MISS_CHAR,
307: pricing_attribute39 VARCHAR2(150) := FND_API.G_MISS_CHAR,
308: pricing_attribute40 VARCHAR2(150) := FND_API.G_MISS_CHAR,
309: pricing_attribute41 VARCHAR2(150) := FND_API.G_MISS_CHAR,
302: pricing_attribute34 VARCHAR2(150) := FND_API.G_MISS_CHAR,
303: pricing_attribute35 VARCHAR2(150) := FND_API.G_MISS_CHAR,
304: pricing_attribute36 VARCHAR2(150) := FND_API.G_MISS_CHAR,
305: pricing_attribute37 VARCHAR2(150) := FND_API.G_MISS_CHAR,
306: pricing_attribute38 VARCHAR2(150) := FND_API.G_MISS_CHAR,
307: pricing_attribute39 VARCHAR2(150) := FND_API.G_MISS_CHAR,
308: pricing_attribute40 VARCHAR2(150) := FND_API.G_MISS_CHAR,
309: pricing_attribute41 VARCHAR2(150) := FND_API.G_MISS_CHAR,
310: pricing_attribute42 VARCHAR2(150) := FND_API.G_MISS_CHAR,
303: pricing_attribute35 VARCHAR2(150) := FND_API.G_MISS_CHAR,
304: pricing_attribute36 VARCHAR2(150) := FND_API.G_MISS_CHAR,
305: pricing_attribute37 VARCHAR2(150) := FND_API.G_MISS_CHAR,
306: pricing_attribute38 VARCHAR2(150) := FND_API.G_MISS_CHAR,
307: pricing_attribute39 VARCHAR2(150) := FND_API.G_MISS_CHAR,
308: pricing_attribute40 VARCHAR2(150) := FND_API.G_MISS_CHAR,
309: pricing_attribute41 VARCHAR2(150) := FND_API.G_MISS_CHAR,
310: pricing_attribute42 VARCHAR2(150) := FND_API.G_MISS_CHAR,
311: pricing_attribute43 VARCHAR2(150) := FND_API.G_MISS_CHAR,
304: pricing_attribute36 VARCHAR2(150) := FND_API.G_MISS_CHAR,
305: pricing_attribute37 VARCHAR2(150) := FND_API.G_MISS_CHAR,
306: pricing_attribute38 VARCHAR2(150) := FND_API.G_MISS_CHAR,
307: pricing_attribute39 VARCHAR2(150) := FND_API.G_MISS_CHAR,
308: pricing_attribute40 VARCHAR2(150) := FND_API.G_MISS_CHAR,
309: pricing_attribute41 VARCHAR2(150) := FND_API.G_MISS_CHAR,
310: pricing_attribute42 VARCHAR2(150) := FND_API.G_MISS_CHAR,
311: pricing_attribute43 VARCHAR2(150) := FND_API.G_MISS_CHAR,
312: pricing_attribute44 VARCHAR2(150) := FND_API.G_MISS_CHAR,
305: pricing_attribute37 VARCHAR2(150) := FND_API.G_MISS_CHAR,
306: pricing_attribute38 VARCHAR2(150) := FND_API.G_MISS_CHAR,
307: pricing_attribute39 VARCHAR2(150) := FND_API.G_MISS_CHAR,
308: pricing_attribute40 VARCHAR2(150) := FND_API.G_MISS_CHAR,
309: pricing_attribute41 VARCHAR2(150) := FND_API.G_MISS_CHAR,
310: pricing_attribute42 VARCHAR2(150) := FND_API.G_MISS_CHAR,
311: pricing_attribute43 VARCHAR2(150) := FND_API.G_MISS_CHAR,
312: pricing_attribute44 VARCHAR2(150) := FND_API.G_MISS_CHAR,
313: pricing_attribute45 VARCHAR2(150) := FND_API.G_MISS_CHAR,
306: pricing_attribute38 VARCHAR2(150) := FND_API.G_MISS_CHAR,
307: pricing_attribute39 VARCHAR2(150) := FND_API.G_MISS_CHAR,
308: pricing_attribute40 VARCHAR2(150) := FND_API.G_MISS_CHAR,
309: pricing_attribute41 VARCHAR2(150) := FND_API.G_MISS_CHAR,
310: pricing_attribute42 VARCHAR2(150) := FND_API.G_MISS_CHAR,
311: pricing_attribute43 VARCHAR2(150) := FND_API.G_MISS_CHAR,
312: pricing_attribute44 VARCHAR2(150) := FND_API.G_MISS_CHAR,
313: pricing_attribute45 VARCHAR2(150) := FND_API.G_MISS_CHAR,
314: pricing_attribute46 VARCHAR2(150) := FND_API.G_MISS_CHAR,
307: pricing_attribute39 VARCHAR2(150) := FND_API.G_MISS_CHAR,
308: pricing_attribute40 VARCHAR2(150) := FND_API.G_MISS_CHAR,
309: pricing_attribute41 VARCHAR2(150) := FND_API.G_MISS_CHAR,
310: pricing_attribute42 VARCHAR2(150) := FND_API.G_MISS_CHAR,
311: pricing_attribute43 VARCHAR2(150) := FND_API.G_MISS_CHAR,
312: pricing_attribute44 VARCHAR2(150) := FND_API.G_MISS_CHAR,
313: pricing_attribute45 VARCHAR2(150) := FND_API.G_MISS_CHAR,
314: pricing_attribute46 VARCHAR2(150) := FND_API.G_MISS_CHAR,
315: pricing_attribute47 VARCHAR2(150) := FND_API.G_MISS_CHAR,
308: pricing_attribute40 VARCHAR2(150) := FND_API.G_MISS_CHAR,
309: pricing_attribute41 VARCHAR2(150) := FND_API.G_MISS_CHAR,
310: pricing_attribute42 VARCHAR2(150) := FND_API.G_MISS_CHAR,
311: pricing_attribute43 VARCHAR2(150) := FND_API.G_MISS_CHAR,
312: pricing_attribute44 VARCHAR2(150) := FND_API.G_MISS_CHAR,
313: pricing_attribute45 VARCHAR2(150) := FND_API.G_MISS_CHAR,
314: pricing_attribute46 VARCHAR2(150) := FND_API.G_MISS_CHAR,
315: pricing_attribute47 VARCHAR2(150) := FND_API.G_MISS_CHAR,
316: pricing_attribute48 VARCHAR2(150) := FND_API.G_MISS_CHAR,
309: pricing_attribute41 VARCHAR2(150) := FND_API.G_MISS_CHAR,
310: pricing_attribute42 VARCHAR2(150) := FND_API.G_MISS_CHAR,
311: pricing_attribute43 VARCHAR2(150) := FND_API.G_MISS_CHAR,
312: pricing_attribute44 VARCHAR2(150) := FND_API.G_MISS_CHAR,
313: pricing_attribute45 VARCHAR2(150) := FND_API.G_MISS_CHAR,
314: pricing_attribute46 VARCHAR2(150) := FND_API.G_MISS_CHAR,
315: pricing_attribute47 VARCHAR2(150) := FND_API.G_MISS_CHAR,
316: pricing_attribute48 VARCHAR2(150) := FND_API.G_MISS_CHAR,
317: pricing_attribute49 VARCHAR2(150) := FND_API.G_MISS_CHAR,
310: pricing_attribute42 VARCHAR2(150) := FND_API.G_MISS_CHAR,
311: pricing_attribute43 VARCHAR2(150) := FND_API.G_MISS_CHAR,
312: pricing_attribute44 VARCHAR2(150) := FND_API.G_MISS_CHAR,
313: pricing_attribute45 VARCHAR2(150) := FND_API.G_MISS_CHAR,
314: pricing_attribute46 VARCHAR2(150) := FND_API.G_MISS_CHAR,
315: pricing_attribute47 VARCHAR2(150) := FND_API.G_MISS_CHAR,
316: pricing_attribute48 VARCHAR2(150) := FND_API.G_MISS_CHAR,
317: pricing_attribute49 VARCHAR2(150) := FND_API.G_MISS_CHAR,
318: pricing_attribute50 VARCHAR2(150) := FND_API.G_MISS_CHAR,
311: pricing_attribute43 VARCHAR2(150) := FND_API.G_MISS_CHAR,
312: pricing_attribute44 VARCHAR2(150) := FND_API.G_MISS_CHAR,
313: pricing_attribute45 VARCHAR2(150) := FND_API.G_MISS_CHAR,
314: pricing_attribute46 VARCHAR2(150) := FND_API.G_MISS_CHAR,
315: pricing_attribute47 VARCHAR2(150) := FND_API.G_MISS_CHAR,
316: pricing_attribute48 VARCHAR2(150) := FND_API.G_MISS_CHAR,
317: pricing_attribute49 VARCHAR2(150) := FND_API.G_MISS_CHAR,
318: pricing_attribute50 VARCHAR2(150) := FND_API.G_MISS_CHAR,
319: pricing_attribute51 VARCHAR2(150) := FND_API.G_MISS_CHAR,
312: pricing_attribute44 VARCHAR2(150) := FND_API.G_MISS_CHAR,
313: pricing_attribute45 VARCHAR2(150) := FND_API.G_MISS_CHAR,
314: pricing_attribute46 VARCHAR2(150) := FND_API.G_MISS_CHAR,
315: pricing_attribute47 VARCHAR2(150) := FND_API.G_MISS_CHAR,
316: pricing_attribute48 VARCHAR2(150) := FND_API.G_MISS_CHAR,
317: pricing_attribute49 VARCHAR2(150) := FND_API.G_MISS_CHAR,
318: pricing_attribute50 VARCHAR2(150) := FND_API.G_MISS_CHAR,
319: pricing_attribute51 VARCHAR2(150) := FND_API.G_MISS_CHAR,
320: pricing_attribute52 VARCHAR2(150) := FND_API.G_MISS_CHAR,
313: pricing_attribute45 VARCHAR2(150) := FND_API.G_MISS_CHAR,
314: pricing_attribute46 VARCHAR2(150) := FND_API.G_MISS_CHAR,
315: pricing_attribute47 VARCHAR2(150) := FND_API.G_MISS_CHAR,
316: pricing_attribute48 VARCHAR2(150) := FND_API.G_MISS_CHAR,
317: pricing_attribute49 VARCHAR2(150) := FND_API.G_MISS_CHAR,
318: pricing_attribute50 VARCHAR2(150) := FND_API.G_MISS_CHAR,
319: pricing_attribute51 VARCHAR2(150) := FND_API.G_MISS_CHAR,
320: pricing_attribute52 VARCHAR2(150) := FND_API.G_MISS_CHAR,
321: pricing_attribute53 VARCHAR2(150) := FND_API.G_MISS_CHAR,
314: pricing_attribute46 VARCHAR2(150) := FND_API.G_MISS_CHAR,
315: pricing_attribute47 VARCHAR2(150) := FND_API.G_MISS_CHAR,
316: pricing_attribute48 VARCHAR2(150) := FND_API.G_MISS_CHAR,
317: pricing_attribute49 VARCHAR2(150) := FND_API.G_MISS_CHAR,
318: pricing_attribute50 VARCHAR2(150) := FND_API.G_MISS_CHAR,
319: pricing_attribute51 VARCHAR2(150) := FND_API.G_MISS_CHAR,
320: pricing_attribute52 VARCHAR2(150) := FND_API.G_MISS_CHAR,
321: pricing_attribute53 VARCHAR2(150) := FND_API.G_MISS_CHAR,
322: pricing_attribute54 VARCHAR2(150) := FND_API.G_MISS_CHAR,
315: pricing_attribute47 VARCHAR2(150) := FND_API.G_MISS_CHAR,
316: pricing_attribute48 VARCHAR2(150) := FND_API.G_MISS_CHAR,
317: pricing_attribute49 VARCHAR2(150) := FND_API.G_MISS_CHAR,
318: pricing_attribute50 VARCHAR2(150) := FND_API.G_MISS_CHAR,
319: pricing_attribute51 VARCHAR2(150) := FND_API.G_MISS_CHAR,
320: pricing_attribute52 VARCHAR2(150) := FND_API.G_MISS_CHAR,
321: pricing_attribute53 VARCHAR2(150) := FND_API.G_MISS_CHAR,
322: pricing_attribute54 VARCHAR2(150) := FND_API.G_MISS_CHAR,
323: pricing_attribute55 VARCHAR2(150) := FND_API.G_MISS_CHAR,
316: pricing_attribute48 VARCHAR2(150) := FND_API.G_MISS_CHAR,
317: pricing_attribute49 VARCHAR2(150) := FND_API.G_MISS_CHAR,
318: pricing_attribute50 VARCHAR2(150) := FND_API.G_MISS_CHAR,
319: pricing_attribute51 VARCHAR2(150) := FND_API.G_MISS_CHAR,
320: pricing_attribute52 VARCHAR2(150) := FND_API.G_MISS_CHAR,
321: pricing_attribute53 VARCHAR2(150) := FND_API.G_MISS_CHAR,
322: pricing_attribute54 VARCHAR2(150) := FND_API.G_MISS_CHAR,
323: pricing_attribute55 VARCHAR2(150) := FND_API.G_MISS_CHAR,
324: pricing_attribute56 VARCHAR2(150) := FND_API.G_MISS_CHAR,
317: pricing_attribute49 VARCHAR2(150) := FND_API.G_MISS_CHAR,
318: pricing_attribute50 VARCHAR2(150) := FND_API.G_MISS_CHAR,
319: pricing_attribute51 VARCHAR2(150) := FND_API.G_MISS_CHAR,
320: pricing_attribute52 VARCHAR2(150) := FND_API.G_MISS_CHAR,
321: pricing_attribute53 VARCHAR2(150) := FND_API.G_MISS_CHAR,
322: pricing_attribute54 VARCHAR2(150) := FND_API.G_MISS_CHAR,
323: pricing_attribute55 VARCHAR2(150) := FND_API.G_MISS_CHAR,
324: pricing_attribute56 VARCHAR2(150) := FND_API.G_MISS_CHAR,
325: pricing_attribute57 VARCHAR2(150) := FND_API.G_MISS_CHAR,
318: pricing_attribute50 VARCHAR2(150) := FND_API.G_MISS_CHAR,
319: pricing_attribute51 VARCHAR2(150) := FND_API.G_MISS_CHAR,
320: pricing_attribute52 VARCHAR2(150) := FND_API.G_MISS_CHAR,
321: pricing_attribute53 VARCHAR2(150) := FND_API.G_MISS_CHAR,
322: pricing_attribute54 VARCHAR2(150) := FND_API.G_MISS_CHAR,
323: pricing_attribute55 VARCHAR2(150) := FND_API.G_MISS_CHAR,
324: pricing_attribute56 VARCHAR2(150) := FND_API.G_MISS_CHAR,
325: pricing_attribute57 VARCHAR2(150) := FND_API.G_MISS_CHAR,
326: pricing_attribute58 VARCHAR2(150) := FND_API.G_MISS_CHAR,
319: pricing_attribute51 VARCHAR2(150) := FND_API.G_MISS_CHAR,
320: pricing_attribute52 VARCHAR2(150) := FND_API.G_MISS_CHAR,
321: pricing_attribute53 VARCHAR2(150) := FND_API.G_MISS_CHAR,
322: pricing_attribute54 VARCHAR2(150) := FND_API.G_MISS_CHAR,
323: pricing_attribute55 VARCHAR2(150) := FND_API.G_MISS_CHAR,
324: pricing_attribute56 VARCHAR2(150) := FND_API.G_MISS_CHAR,
325: pricing_attribute57 VARCHAR2(150) := FND_API.G_MISS_CHAR,
326: pricing_attribute58 VARCHAR2(150) := FND_API.G_MISS_CHAR,
327: pricing_attribute59 VARCHAR2(150) := FND_API.G_MISS_CHAR,
320: pricing_attribute52 VARCHAR2(150) := FND_API.G_MISS_CHAR,
321: pricing_attribute53 VARCHAR2(150) := FND_API.G_MISS_CHAR,
322: pricing_attribute54 VARCHAR2(150) := FND_API.G_MISS_CHAR,
323: pricing_attribute55 VARCHAR2(150) := FND_API.G_MISS_CHAR,
324: pricing_attribute56 VARCHAR2(150) := FND_API.G_MISS_CHAR,
325: pricing_attribute57 VARCHAR2(150) := FND_API.G_MISS_CHAR,
326: pricing_attribute58 VARCHAR2(150) := FND_API.G_MISS_CHAR,
327: pricing_attribute59 VARCHAR2(150) := FND_API.G_MISS_CHAR,
328: pricing_attribute60 VARCHAR2(150) := FND_API.G_MISS_CHAR,
321: pricing_attribute53 VARCHAR2(150) := FND_API.G_MISS_CHAR,
322: pricing_attribute54 VARCHAR2(150) := FND_API.G_MISS_CHAR,
323: pricing_attribute55 VARCHAR2(150) := FND_API.G_MISS_CHAR,
324: pricing_attribute56 VARCHAR2(150) := FND_API.G_MISS_CHAR,
325: pricing_attribute57 VARCHAR2(150) := FND_API.G_MISS_CHAR,
326: pricing_attribute58 VARCHAR2(150) := FND_API.G_MISS_CHAR,
327: pricing_attribute59 VARCHAR2(150) := FND_API.G_MISS_CHAR,
328: pricing_attribute60 VARCHAR2(150) := FND_API.G_MISS_CHAR,
329: pricing_attribute61 VARCHAR2(150) := FND_API.G_MISS_CHAR,
322: pricing_attribute54 VARCHAR2(150) := FND_API.G_MISS_CHAR,
323: pricing_attribute55 VARCHAR2(150) := FND_API.G_MISS_CHAR,
324: pricing_attribute56 VARCHAR2(150) := FND_API.G_MISS_CHAR,
325: pricing_attribute57 VARCHAR2(150) := FND_API.G_MISS_CHAR,
326: pricing_attribute58 VARCHAR2(150) := FND_API.G_MISS_CHAR,
327: pricing_attribute59 VARCHAR2(150) := FND_API.G_MISS_CHAR,
328: pricing_attribute60 VARCHAR2(150) := FND_API.G_MISS_CHAR,
329: pricing_attribute61 VARCHAR2(150) := FND_API.G_MISS_CHAR,
330: pricing_attribute62 VARCHAR2(150) := FND_API.G_MISS_CHAR,
323: pricing_attribute55 VARCHAR2(150) := FND_API.G_MISS_CHAR,
324: pricing_attribute56 VARCHAR2(150) := FND_API.G_MISS_CHAR,
325: pricing_attribute57 VARCHAR2(150) := FND_API.G_MISS_CHAR,
326: pricing_attribute58 VARCHAR2(150) := FND_API.G_MISS_CHAR,
327: pricing_attribute59 VARCHAR2(150) := FND_API.G_MISS_CHAR,
328: pricing_attribute60 VARCHAR2(150) := FND_API.G_MISS_CHAR,
329: pricing_attribute61 VARCHAR2(150) := FND_API.G_MISS_CHAR,
330: pricing_attribute62 VARCHAR2(150) := FND_API.G_MISS_CHAR,
331: pricing_attribute63 VARCHAR2(150) := FND_API.G_MISS_CHAR,
324: pricing_attribute56 VARCHAR2(150) := FND_API.G_MISS_CHAR,
325: pricing_attribute57 VARCHAR2(150) := FND_API.G_MISS_CHAR,
326: pricing_attribute58 VARCHAR2(150) := FND_API.G_MISS_CHAR,
327: pricing_attribute59 VARCHAR2(150) := FND_API.G_MISS_CHAR,
328: pricing_attribute60 VARCHAR2(150) := FND_API.G_MISS_CHAR,
329: pricing_attribute61 VARCHAR2(150) := FND_API.G_MISS_CHAR,
330: pricing_attribute62 VARCHAR2(150) := FND_API.G_MISS_CHAR,
331: pricing_attribute63 VARCHAR2(150) := FND_API.G_MISS_CHAR,
332: pricing_attribute64 VARCHAR2(150) := FND_API.G_MISS_CHAR,
325: pricing_attribute57 VARCHAR2(150) := FND_API.G_MISS_CHAR,
326: pricing_attribute58 VARCHAR2(150) := FND_API.G_MISS_CHAR,
327: pricing_attribute59 VARCHAR2(150) := FND_API.G_MISS_CHAR,
328: pricing_attribute60 VARCHAR2(150) := FND_API.G_MISS_CHAR,
329: pricing_attribute61 VARCHAR2(150) := FND_API.G_MISS_CHAR,
330: pricing_attribute62 VARCHAR2(150) := FND_API.G_MISS_CHAR,
331: pricing_attribute63 VARCHAR2(150) := FND_API.G_MISS_CHAR,
332: pricing_attribute64 VARCHAR2(150) := FND_API.G_MISS_CHAR,
333: pricing_attribute65 VARCHAR2(150) := FND_API.G_MISS_CHAR,
326: pricing_attribute58 VARCHAR2(150) := FND_API.G_MISS_CHAR,
327: pricing_attribute59 VARCHAR2(150) := FND_API.G_MISS_CHAR,
328: pricing_attribute60 VARCHAR2(150) := FND_API.G_MISS_CHAR,
329: pricing_attribute61 VARCHAR2(150) := FND_API.G_MISS_CHAR,
330: pricing_attribute62 VARCHAR2(150) := FND_API.G_MISS_CHAR,
331: pricing_attribute63 VARCHAR2(150) := FND_API.G_MISS_CHAR,
332: pricing_attribute64 VARCHAR2(150) := FND_API.G_MISS_CHAR,
333: pricing_attribute65 VARCHAR2(150) := FND_API.G_MISS_CHAR,
334: pricing_attribute66 VARCHAR2(150) := FND_API.G_MISS_CHAR,
327: pricing_attribute59 VARCHAR2(150) := FND_API.G_MISS_CHAR,
328: pricing_attribute60 VARCHAR2(150) := FND_API.G_MISS_CHAR,
329: pricing_attribute61 VARCHAR2(150) := FND_API.G_MISS_CHAR,
330: pricing_attribute62 VARCHAR2(150) := FND_API.G_MISS_CHAR,
331: pricing_attribute63 VARCHAR2(150) := FND_API.G_MISS_CHAR,
332: pricing_attribute64 VARCHAR2(150) := FND_API.G_MISS_CHAR,
333: pricing_attribute65 VARCHAR2(150) := FND_API.G_MISS_CHAR,
334: pricing_attribute66 VARCHAR2(150) := FND_API.G_MISS_CHAR,
335: pricing_attribute67 VARCHAR2(150) := FND_API.G_MISS_CHAR,
328: pricing_attribute60 VARCHAR2(150) := FND_API.G_MISS_CHAR,
329: pricing_attribute61 VARCHAR2(150) := FND_API.G_MISS_CHAR,
330: pricing_attribute62 VARCHAR2(150) := FND_API.G_MISS_CHAR,
331: pricing_attribute63 VARCHAR2(150) := FND_API.G_MISS_CHAR,
332: pricing_attribute64 VARCHAR2(150) := FND_API.G_MISS_CHAR,
333: pricing_attribute65 VARCHAR2(150) := FND_API.G_MISS_CHAR,
334: pricing_attribute66 VARCHAR2(150) := FND_API.G_MISS_CHAR,
335: pricing_attribute67 VARCHAR2(150) := FND_API.G_MISS_CHAR,
336: pricing_attribute68 VARCHAR2(150) := FND_API.G_MISS_CHAR,
329: pricing_attribute61 VARCHAR2(150) := FND_API.G_MISS_CHAR,
330: pricing_attribute62 VARCHAR2(150) := FND_API.G_MISS_CHAR,
331: pricing_attribute63 VARCHAR2(150) := FND_API.G_MISS_CHAR,
332: pricing_attribute64 VARCHAR2(150) := FND_API.G_MISS_CHAR,
333: pricing_attribute65 VARCHAR2(150) := FND_API.G_MISS_CHAR,
334: pricing_attribute66 VARCHAR2(150) := FND_API.G_MISS_CHAR,
335: pricing_attribute67 VARCHAR2(150) := FND_API.G_MISS_CHAR,
336: pricing_attribute68 VARCHAR2(150) := FND_API.G_MISS_CHAR,
337: pricing_attribute69 VARCHAR2(150) := FND_API.G_MISS_CHAR,
330: pricing_attribute62 VARCHAR2(150) := FND_API.G_MISS_CHAR,
331: pricing_attribute63 VARCHAR2(150) := FND_API.G_MISS_CHAR,
332: pricing_attribute64 VARCHAR2(150) := FND_API.G_MISS_CHAR,
333: pricing_attribute65 VARCHAR2(150) := FND_API.G_MISS_CHAR,
334: pricing_attribute66 VARCHAR2(150) := FND_API.G_MISS_CHAR,
335: pricing_attribute67 VARCHAR2(150) := FND_API.G_MISS_CHAR,
336: pricing_attribute68 VARCHAR2(150) := FND_API.G_MISS_CHAR,
337: pricing_attribute69 VARCHAR2(150) := FND_API.G_MISS_CHAR,
338: pricing_attribute70 VARCHAR2(150) := FND_API.G_MISS_CHAR,
331: pricing_attribute63 VARCHAR2(150) := FND_API.G_MISS_CHAR,
332: pricing_attribute64 VARCHAR2(150) := FND_API.G_MISS_CHAR,
333: pricing_attribute65 VARCHAR2(150) := FND_API.G_MISS_CHAR,
334: pricing_attribute66 VARCHAR2(150) := FND_API.G_MISS_CHAR,
335: pricing_attribute67 VARCHAR2(150) := FND_API.G_MISS_CHAR,
336: pricing_attribute68 VARCHAR2(150) := FND_API.G_MISS_CHAR,
337: pricing_attribute69 VARCHAR2(150) := FND_API.G_MISS_CHAR,
338: pricing_attribute70 VARCHAR2(150) := FND_API.G_MISS_CHAR,
339: pricing_attribute71 VARCHAR2(150) := FND_API.G_MISS_CHAR,
332: pricing_attribute64 VARCHAR2(150) := FND_API.G_MISS_CHAR,
333: pricing_attribute65 VARCHAR2(150) := FND_API.G_MISS_CHAR,
334: pricing_attribute66 VARCHAR2(150) := FND_API.G_MISS_CHAR,
335: pricing_attribute67 VARCHAR2(150) := FND_API.G_MISS_CHAR,
336: pricing_attribute68 VARCHAR2(150) := FND_API.G_MISS_CHAR,
337: pricing_attribute69 VARCHAR2(150) := FND_API.G_MISS_CHAR,
338: pricing_attribute70 VARCHAR2(150) := FND_API.G_MISS_CHAR,
339: pricing_attribute71 VARCHAR2(150) := FND_API.G_MISS_CHAR,
340: pricing_attribute72 VARCHAR2(150) := FND_API.G_MISS_CHAR,
333: pricing_attribute65 VARCHAR2(150) := FND_API.G_MISS_CHAR,
334: pricing_attribute66 VARCHAR2(150) := FND_API.G_MISS_CHAR,
335: pricing_attribute67 VARCHAR2(150) := FND_API.G_MISS_CHAR,
336: pricing_attribute68 VARCHAR2(150) := FND_API.G_MISS_CHAR,
337: pricing_attribute69 VARCHAR2(150) := FND_API.G_MISS_CHAR,
338: pricing_attribute70 VARCHAR2(150) := FND_API.G_MISS_CHAR,
339: pricing_attribute71 VARCHAR2(150) := FND_API.G_MISS_CHAR,
340: pricing_attribute72 VARCHAR2(150) := FND_API.G_MISS_CHAR,
341: pricing_attribute73 VARCHAR2(150) := FND_API.G_MISS_CHAR,
334: pricing_attribute66 VARCHAR2(150) := FND_API.G_MISS_CHAR,
335: pricing_attribute67 VARCHAR2(150) := FND_API.G_MISS_CHAR,
336: pricing_attribute68 VARCHAR2(150) := FND_API.G_MISS_CHAR,
337: pricing_attribute69 VARCHAR2(150) := FND_API.G_MISS_CHAR,
338: pricing_attribute70 VARCHAR2(150) := FND_API.G_MISS_CHAR,
339: pricing_attribute71 VARCHAR2(150) := FND_API.G_MISS_CHAR,
340: pricing_attribute72 VARCHAR2(150) := FND_API.G_MISS_CHAR,
341: pricing_attribute73 VARCHAR2(150) := FND_API.G_MISS_CHAR,
342: pricing_attribute74 VARCHAR2(150) := FND_API.G_MISS_CHAR,
335: pricing_attribute67 VARCHAR2(150) := FND_API.G_MISS_CHAR,
336: pricing_attribute68 VARCHAR2(150) := FND_API.G_MISS_CHAR,
337: pricing_attribute69 VARCHAR2(150) := FND_API.G_MISS_CHAR,
338: pricing_attribute70 VARCHAR2(150) := FND_API.G_MISS_CHAR,
339: pricing_attribute71 VARCHAR2(150) := FND_API.G_MISS_CHAR,
340: pricing_attribute72 VARCHAR2(150) := FND_API.G_MISS_CHAR,
341: pricing_attribute73 VARCHAR2(150) := FND_API.G_MISS_CHAR,
342: pricing_attribute74 VARCHAR2(150) := FND_API.G_MISS_CHAR,
343: pricing_attribute75 VARCHAR2(150) := FND_API.G_MISS_CHAR,
336: pricing_attribute68 VARCHAR2(150) := FND_API.G_MISS_CHAR,
337: pricing_attribute69 VARCHAR2(150) := FND_API.G_MISS_CHAR,
338: pricing_attribute70 VARCHAR2(150) := FND_API.G_MISS_CHAR,
339: pricing_attribute71 VARCHAR2(150) := FND_API.G_MISS_CHAR,
340: pricing_attribute72 VARCHAR2(150) := FND_API.G_MISS_CHAR,
341: pricing_attribute73 VARCHAR2(150) := FND_API.G_MISS_CHAR,
342: pricing_attribute74 VARCHAR2(150) := FND_API.G_MISS_CHAR,
343: pricing_attribute75 VARCHAR2(150) := FND_API.G_MISS_CHAR,
344: pricing_attribute76 VARCHAR2(150) := FND_API.G_MISS_CHAR,
337: pricing_attribute69 VARCHAR2(150) := FND_API.G_MISS_CHAR,
338: pricing_attribute70 VARCHAR2(150) := FND_API.G_MISS_CHAR,
339: pricing_attribute71 VARCHAR2(150) := FND_API.G_MISS_CHAR,
340: pricing_attribute72 VARCHAR2(150) := FND_API.G_MISS_CHAR,
341: pricing_attribute73 VARCHAR2(150) := FND_API.G_MISS_CHAR,
342: pricing_attribute74 VARCHAR2(150) := FND_API.G_MISS_CHAR,
343: pricing_attribute75 VARCHAR2(150) := FND_API.G_MISS_CHAR,
344: pricing_attribute76 VARCHAR2(150) := FND_API.G_MISS_CHAR,
345: pricing_attribute77 VARCHAR2(150) := FND_API.G_MISS_CHAR,
338: pricing_attribute70 VARCHAR2(150) := FND_API.G_MISS_CHAR,
339: pricing_attribute71 VARCHAR2(150) := FND_API.G_MISS_CHAR,
340: pricing_attribute72 VARCHAR2(150) := FND_API.G_MISS_CHAR,
341: pricing_attribute73 VARCHAR2(150) := FND_API.G_MISS_CHAR,
342: pricing_attribute74 VARCHAR2(150) := FND_API.G_MISS_CHAR,
343: pricing_attribute75 VARCHAR2(150) := FND_API.G_MISS_CHAR,
344: pricing_attribute76 VARCHAR2(150) := FND_API.G_MISS_CHAR,
345: pricing_attribute77 VARCHAR2(150) := FND_API.G_MISS_CHAR,
346: pricing_attribute78 VARCHAR2(150) := FND_API.G_MISS_CHAR,
339: pricing_attribute71 VARCHAR2(150) := FND_API.G_MISS_CHAR,
340: pricing_attribute72 VARCHAR2(150) := FND_API.G_MISS_CHAR,
341: pricing_attribute73 VARCHAR2(150) := FND_API.G_MISS_CHAR,
342: pricing_attribute74 VARCHAR2(150) := FND_API.G_MISS_CHAR,
343: pricing_attribute75 VARCHAR2(150) := FND_API.G_MISS_CHAR,
344: pricing_attribute76 VARCHAR2(150) := FND_API.G_MISS_CHAR,
345: pricing_attribute77 VARCHAR2(150) := FND_API.G_MISS_CHAR,
346: pricing_attribute78 VARCHAR2(150) := FND_API.G_MISS_CHAR,
347: pricing_attribute79 VARCHAR2(150) := FND_API.G_MISS_CHAR,
340: pricing_attribute72 VARCHAR2(150) := FND_API.G_MISS_CHAR,
341: pricing_attribute73 VARCHAR2(150) := FND_API.G_MISS_CHAR,
342: pricing_attribute74 VARCHAR2(150) := FND_API.G_MISS_CHAR,
343: pricing_attribute75 VARCHAR2(150) := FND_API.G_MISS_CHAR,
344: pricing_attribute76 VARCHAR2(150) := FND_API.G_MISS_CHAR,
345: pricing_attribute77 VARCHAR2(150) := FND_API.G_MISS_CHAR,
346: pricing_attribute78 VARCHAR2(150) := FND_API.G_MISS_CHAR,
347: pricing_attribute79 VARCHAR2(150) := FND_API.G_MISS_CHAR,
348: pricing_attribute80 VARCHAR2(150) := FND_API.G_MISS_CHAR,
341: pricing_attribute73 VARCHAR2(150) := FND_API.G_MISS_CHAR,
342: pricing_attribute74 VARCHAR2(150) := FND_API.G_MISS_CHAR,
343: pricing_attribute75 VARCHAR2(150) := FND_API.G_MISS_CHAR,
344: pricing_attribute76 VARCHAR2(150) := FND_API.G_MISS_CHAR,
345: pricing_attribute77 VARCHAR2(150) := FND_API.G_MISS_CHAR,
346: pricing_attribute78 VARCHAR2(150) := FND_API.G_MISS_CHAR,
347: pricing_attribute79 VARCHAR2(150) := FND_API.G_MISS_CHAR,
348: pricing_attribute80 VARCHAR2(150) := FND_API.G_MISS_CHAR,
349: pricing_attribute81 VARCHAR2(150) := FND_API.G_MISS_CHAR,
342: pricing_attribute74 VARCHAR2(150) := FND_API.G_MISS_CHAR,
343: pricing_attribute75 VARCHAR2(150) := FND_API.G_MISS_CHAR,
344: pricing_attribute76 VARCHAR2(150) := FND_API.G_MISS_CHAR,
345: pricing_attribute77 VARCHAR2(150) := FND_API.G_MISS_CHAR,
346: pricing_attribute78 VARCHAR2(150) := FND_API.G_MISS_CHAR,
347: pricing_attribute79 VARCHAR2(150) := FND_API.G_MISS_CHAR,
348: pricing_attribute80 VARCHAR2(150) := FND_API.G_MISS_CHAR,
349: pricing_attribute81 VARCHAR2(150) := FND_API.G_MISS_CHAR,
350: pricing_attribute82 VARCHAR2(150) := FND_API.G_MISS_CHAR,
343: pricing_attribute75 VARCHAR2(150) := FND_API.G_MISS_CHAR,
344: pricing_attribute76 VARCHAR2(150) := FND_API.G_MISS_CHAR,
345: pricing_attribute77 VARCHAR2(150) := FND_API.G_MISS_CHAR,
346: pricing_attribute78 VARCHAR2(150) := FND_API.G_MISS_CHAR,
347: pricing_attribute79 VARCHAR2(150) := FND_API.G_MISS_CHAR,
348: pricing_attribute80 VARCHAR2(150) := FND_API.G_MISS_CHAR,
349: pricing_attribute81 VARCHAR2(150) := FND_API.G_MISS_CHAR,
350: pricing_attribute82 VARCHAR2(150) := FND_API.G_MISS_CHAR,
351: pricing_attribute83 VARCHAR2(150) := FND_API.G_MISS_CHAR,
344: pricing_attribute76 VARCHAR2(150) := FND_API.G_MISS_CHAR,
345: pricing_attribute77 VARCHAR2(150) := FND_API.G_MISS_CHAR,
346: pricing_attribute78 VARCHAR2(150) := FND_API.G_MISS_CHAR,
347: pricing_attribute79 VARCHAR2(150) := FND_API.G_MISS_CHAR,
348: pricing_attribute80 VARCHAR2(150) := FND_API.G_MISS_CHAR,
349: pricing_attribute81 VARCHAR2(150) := FND_API.G_MISS_CHAR,
350: pricing_attribute82 VARCHAR2(150) := FND_API.G_MISS_CHAR,
351: pricing_attribute83 VARCHAR2(150) := FND_API.G_MISS_CHAR,
352: pricing_attribute84 VARCHAR2(150) := FND_API.G_MISS_CHAR,
345: pricing_attribute77 VARCHAR2(150) := FND_API.G_MISS_CHAR,
346: pricing_attribute78 VARCHAR2(150) := FND_API.G_MISS_CHAR,
347: pricing_attribute79 VARCHAR2(150) := FND_API.G_MISS_CHAR,
348: pricing_attribute80 VARCHAR2(150) := FND_API.G_MISS_CHAR,
349: pricing_attribute81 VARCHAR2(150) := FND_API.G_MISS_CHAR,
350: pricing_attribute82 VARCHAR2(150) := FND_API.G_MISS_CHAR,
351: pricing_attribute83 VARCHAR2(150) := FND_API.G_MISS_CHAR,
352: pricing_attribute84 VARCHAR2(150) := FND_API.G_MISS_CHAR,
353: pricing_attribute85 VARCHAR2(150) := FND_API.G_MISS_CHAR,
346: pricing_attribute78 VARCHAR2(150) := FND_API.G_MISS_CHAR,
347: pricing_attribute79 VARCHAR2(150) := FND_API.G_MISS_CHAR,
348: pricing_attribute80 VARCHAR2(150) := FND_API.G_MISS_CHAR,
349: pricing_attribute81 VARCHAR2(150) := FND_API.G_MISS_CHAR,
350: pricing_attribute82 VARCHAR2(150) := FND_API.G_MISS_CHAR,
351: pricing_attribute83 VARCHAR2(150) := FND_API.G_MISS_CHAR,
352: pricing_attribute84 VARCHAR2(150) := FND_API.G_MISS_CHAR,
353: pricing_attribute85 VARCHAR2(150) := FND_API.G_MISS_CHAR,
354: pricing_attribute86 VARCHAR2(150) := FND_API.G_MISS_CHAR,
347: pricing_attribute79 VARCHAR2(150) := FND_API.G_MISS_CHAR,
348: pricing_attribute80 VARCHAR2(150) := FND_API.G_MISS_CHAR,
349: pricing_attribute81 VARCHAR2(150) := FND_API.G_MISS_CHAR,
350: pricing_attribute82 VARCHAR2(150) := FND_API.G_MISS_CHAR,
351: pricing_attribute83 VARCHAR2(150) := FND_API.G_MISS_CHAR,
352: pricing_attribute84 VARCHAR2(150) := FND_API.G_MISS_CHAR,
353: pricing_attribute85 VARCHAR2(150) := FND_API.G_MISS_CHAR,
354: pricing_attribute86 VARCHAR2(150) := FND_API.G_MISS_CHAR,
355: pricing_attribute87 VARCHAR2(150) := FND_API.G_MISS_CHAR,
348: pricing_attribute80 VARCHAR2(150) := FND_API.G_MISS_CHAR,
349: pricing_attribute81 VARCHAR2(150) := FND_API.G_MISS_CHAR,
350: pricing_attribute82 VARCHAR2(150) := FND_API.G_MISS_CHAR,
351: pricing_attribute83 VARCHAR2(150) := FND_API.G_MISS_CHAR,
352: pricing_attribute84 VARCHAR2(150) := FND_API.G_MISS_CHAR,
353: pricing_attribute85 VARCHAR2(150) := FND_API.G_MISS_CHAR,
354: pricing_attribute86 VARCHAR2(150) := FND_API.G_MISS_CHAR,
355: pricing_attribute87 VARCHAR2(150) := FND_API.G_MISS_CHAR,
356: pricing_attribute88 VARCHAR2(150) := FND_API.G_MISS_CHAR,
349: pricing_attribute81 VARCHAR2(150) := FND_API.G_MISS_CHAR,
350: pricing_attribute82 VARCHAR2(150) := FND_API.G_MISS_CHAR,
351: pricing_attribute83 VARCHAR2(150) := FND_API.G_MISS_CHAR,
352: pricing_attribute84 VARCHAR2(150) := FND_API.G_MISS_CHAR,
353: pricing_attribute85 VARCHAR2(150) := FND_API.G_MISS_CHAR,
354: pricing_attribute86 VARCHAR2(150) := FND_API.G_MISS_CHAR,
355: pricing_attribute87 VARCHAR2(150) := FND_API.G_MISS_CHAR,
356: pricing_attribute88 VARCHAR2(150) := FND_API.G_MISS_CHAR,
357: pricing_attribute89 VARCHAR2(150) := FND_API.G_MISS_CHAR,
350: pricing_attribute82 VARCHAR2(150) := FND_API.G_MISS_CHAR,
351: pricing_attribute83 VARCHAR2(150) := FND_API.G_MISS_CHAR,
352: pricing_attribute84 VARCHAR2(150) := FND_API.G_MISS_CHAR,
353: pricing_attribute85 VARCHAR2(150) := FND_API.G_MISS_CHAR,
354: pricing_attribute86 VARCHAR2(150) := FND_API.G_MISS_CHAR,
355: pricing_attribute87 VARCHAR2(150) := FND_API.G_MISS_CHAR,
356: pricing_attribute88 VARCHAR2(150) := FND_API.G_MISS_CHAR,
357: pricing_attribute89 VARCHAR2(150) := FND_API.G_MISS_CHAR,
358: pricing_attribute90 VARCHAR2(150) := FND_API.G_MISS_CHAR,
351: pricing_attribute83 VARCHAR2(150) := FND_API.G_MISS_CHAR,
352: pricing_attribute84 VARCHAR2(150) := FND_API.G_MISS_CHAR,
353: pricing_attribute85 VARCHAR2(150) := FND_API.G_MISS_CHAR,
354: pricing_attribute86 VARCHAR2(150) := FND_API.G_MISS_CHAR,
355: pricing_attribute87 VARCHAR2(150) := FND_API.G_MISS_CHAR,
356: pricing_attribute88 VARCHAR2(150) := FND_API.G_MISS_CHAR,
357: pricing_attribute89 VARCHAR2(150) := FND_API.G_MISS_CHAR,
358: pricing_attribute90 VARCHAR2(150) := FND_API.G_MISS_CHAR,
359: pricing_attribute91 VARCHAR2(150) := FND_API.G_MISS_CHAR,
352: pricing_attribute84 VARCHAR2(150) := FND_API.G_MISS_CHAR,
353: pricing_attribute85 VARCHAR2(150) := FND_API.G_MISS_CHAR,
354: pricing_attribute86 VARCHAR2(150) := FND_API.G_MISS_CHAR,
355: pricing_attribute87 VARCHAR2(150) := FND_API.G_MISS_CHAR,
356: pricing_attribute88 VARCHAR2(150) := FND_API.G_MISS_CHAR,
357: pricing_attribute89 VARCHAR2(150) := FND_API.G_MISS_CHAR,
358: pricing_attribute90 VARCHAR2(150) := FND_API.G_MISS_CHAR,
359: pricing_attribute91 VARCHAR2(150) := FND_API.G_MISS_CHAR,
360: pricing_attribute92 VARCHAR2(150) := FND_API.G_MISS_CHAR,
353: pricing_attribute85 VARCHAR2(150) := FND_API.G_MISS_CHAR,
354: pricing_attribute86 VARCHAR2(150) := FND_API.G_MISS_CHAR,
355: pricing_attribute87 VARCHAR2(150) := FND_API.G_MISS_CHAR,
356: pricing_attribute88 VARCHAR2(150) := FND_API.G_MISS_CHAR,
357: pricing_attribute89 VARCHAR2(150) := FND_API.G_MISS_CHAR,
358: pricing_attribute90 VARCHAR2(150) := FND_API.G_MISS_CHAR,
359: pricing_attribute91 VARCHAR2(150) := FND_API.G_MISS_CHAR,
360: pricing_attribute92 VARCHAR2(150) := FND_API.G_MISS_CHAR,
361: pricing_attribute93 VARCHAR2(150) := FND_API.G_MISS_CHAR,
354: pricing_attribute86 VARCHAR2(150) := FND_API.G_MISS_CHAR,
355: pricing_attribute87 VARCHAR2(150) := FND_API.G_MISS_CHAR,
356: pricing_attribute88 VARCHAR2(150) := FND_API.G_MISS_CHAR,
357: pricing_attribute89 VARCHAR2(150) := FND_API.G_MISS_CHAR,
358: pricing_attribute90 VARCHAR2(150) := FND_API.G_MISS_CHAR,
359: pricing_attribute91 VARCHAR2(150) := FND_API.G_MISS_CHAR,
360: pricing_attribute92 VARCHAR2(150) := FND_API.G_MISS_CHAR,
361: pricing_attribute93 VARCHAR2(150) := FND_API.G_MISS_CHAR,
362: pricing_attribute94 VARCHAR2(150) := FND_API.G_MISS_CHAR,
355: pricing_attribute87 VARCHAR2(150) := FND_API.G_MISS_CHAR,
356: pricing_attribute88 VARCHAR2(150) := FND_API.G_MISS_CHAR,
357: pricing_attribute89 VARCHAR2(150) := FND_API.G_MISS_CHAR,
358: pricing_attribute90 VARCHAR2(150) := FND_API.G_MISS_CHAR,
359: pricing_attribute91 VARCHAR2(150) := FND_API.G_MISS_CHAR,
360: pricing_attribute92 VARCHAR2(150) := FND_API.G_MISS_CHAR,
361: pricing_attribute93 VARCHAR2(150) := FND_API.G_MISS_CHAR,
362: pricing_attribute94 VARCHAR2(150) := FND_API.G_MISS_CHAR,
363: pricing_attribute95 VARCHAR2(150) := FND_API.G_MISS_CHAR,
356: pricing_attribute88 VARCHAR2(150) := FND_API.G_MISS_CHAR,
357: pricing_attribute89 VARCHAR2(150) := FND_API.G_MISS_CHAR,
358: pricing_attribute90 VARCHAR2(150) := FND_API.G_MISS_CHAR,
359: pricing_attribute91 VARCHAR2(150) := FND_API.G_MISS_CHAR,
360: pricing_attribute92 VARCHAR2(150) := FND_API.G_MISS_CHAR,
361: pricing_attribute93 VARCHAR2(150) := FND_API.G_MISS_CHAR,
362: pricing_attribute94 VARCHAR2(150) := FND_API.G_MISS_CHAR,
363: pricing_attribute95 VARCHAR2(150) := FND_API.G_MISS_CHAR,
364: pricing_attribute96 VARCHAR2(150) := FND_API.G_MISS_CHAR,
357: pricing_attribute89 VARCHAR2(150) := FND_API.G_MISS_CHAR,
358: pricing_attribute90 VARCHAR2(150) := FND_API.G_MISS_CHAR,
359: pricing_attribute91 VARCHAR2(150) := FND_API.G_MISS_CHAR,
360: pricing_attribute92 VARCHAR2(150) := FND_API.G_MISS_CHAR,
361: pricing_attribute93 VARCHAR2(150) := FND_API.G_MISS_CHAR,
362: pricing_attribute94 VARCHAR2(150) := FND_API.G_MISS_CHAR,
363: pricing_attribute95 VARCHAR2(150) := FND_API.G_MISS_CHAR,
364: pricing_attribute96 VARCHAR2(150) := FND_API.G_MISS_CHAR,
365: pricing_attribute97 VARCHAR2(150) := FND_API.G_MISS_CHAR,
358: pricing_attribute90 VARCHAR2(150) := FND_API.G_MISS_CHAR,
359: pricing_attribute91 VARCHAR2(150) := FND_API.G_MISS_CHAR,
360: pricing_attribute92 VARCHAR2(150) := FND_API.G_MISS_CHAR,
361: pricing_attribute93 VARCHAR2(150) := FND_API.G_MISS_CHAR,
362: pricing_attribute94 VARCHAR2(150) := FND_API.G_MISS_CHAR,
363: pricing_attribute95 VARCHAR2(150) := FND_API.G_MISS_CHAR,
364: pricing_attribute96 VARCHAR2(150) := FND_API.G_MISS_CHAR,
365: pricing_attribute97 VARCHAR2(150) := FND_API.G_MISS_CHAR,
366: pricing_attribute98 VARCHAR2(150) := FND_API.G_MISS_CHAR,
359: pricing_attribute91 VARCHAR2(150) := FND_API.G_MISS_CHAR,
360: pricing_attribute92 VARCHAR2(150) := FND_API.G_MISS_CHAR,
361: pricing_attribute93 VARCHAR2(150) := FND_API.G_MISS_CHAR,
362: pricing_attribute94 VARCHAR2(150) := FND_API.G_MISS_CHAR,
363: pricing_attribute95 VARCHAR2(150) := FND_API.G_MISS_CHAR,
364: pricing_attribute96 VARCHAR2(150) := FND_API.G_MISS_CHAR,
365: pricing_attribute97 VARCHAR2(150) := FND_API.G_MISS_CHAR,
366: pricing_attribute98 VARCHAR2(150) := FND_API.G_MISS_CHAR,
367: pricing_attribute99 VARCHAR2(150) := FND_API.G_MISS_CHAR,
360: pricing_attribute92 VARCHAR2(150) := FND_API.G_MISS_CHAR,
361: pricing_attribute93 VARCHAR2(150) := FND_API.G_MISS_CHAR,
362: pricing_attribute94 VARCHAR2(150) := FND_API.G_MISS_CHAR,
363: pricing_attribute95 VARCHAR2(150) := FND_API.G_MISS_CHAR,
364: pricing_attribute96 VARCHAR2(150) := FND_API.G_MISS_CHAR,
365: pricing_attribute97 VARCHAR2(150) := FND_API.G_MISS_CHAR,
366: pricing_attribute98 VARCHAR2(150) := FND_API.G_MISS_CHAR,
367: pricing_attribute99 VARCHAR2(150) := FND_API.G_MISS_CHAR,
368: pricing_attribute100 VARCHAR2(150) := FND_API.G_MISS_CHAR,
361: pricing_attribute93 VARCHAR2(150) := FND_API.G_MISS_CHAR,
362: pricing_attribute94 VARCHAR2(150) := FND_API.G_MISS_CHAR,
363: pricing_attribute95 VARCHAR2(150) := FND_API.G_MISS_CHAR,
364: pricing_attribute96 VARCHAR2(150) := FND_API.G_MISS_CHAR,
365: pricing_attribute97 VARCHAR2(150) := FND_API.G_MISS_CHAR,
366: pricing_attribute98 VARCHAR2(150) := FND_API.G_MISS_CHAR,
367: pricing_attribute99 VARCHAR2(150) := FND_API.G_MISS_CHAR,
368: pricing_attribute100 VARCHAR2(150) := FND_API.G_MISS_CHAR,
369: context VARCHAR2(30) := FND_API.G_MISS_CHAR,
362: pricing_attribute94 VARCHAR2(150) := FND_API.G_MISS_CHAR,
363: pricing_attribute95 VARCHAR2(150) := FND_API.G_MISS_CHAR,
364: pricing_attribute96 VARCHAR2(150) := FND_API.G_MISS_CHAR,
365: pricing_attribute97 VARCHAR2(150) := FND_API.G_MISS_CHAR,
366: pricing_attribute98 VARCHAR2(150) := FND_API.G_MISS_CHAR,
367: pricing_attribute99 VARCHAR2(150) := FND_API.G_MISS_CHAR,
368: pricing_attribute100 VARCHAR2(150) := FND_API.G_MISS_CHAR,
369: context VARCHAR2(30) := FND_API.G_MISS_CHAR,
370: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
363: pricing_attribute95 VARCHAR2(150) := FND_API.G_MISS_CHAR,
364: pricing_attribute96 VARCHAR2(150) := FND_API.G_MISS_CHAR,
365: pricing_attribute97 VARCHAR2(150) := FND_API.G_MISS_CHAR,
366: pricing_attribute98 VARCHAR2(150) := FND_API.G_MISS_CHAR,
367: pricing_attribute99 VARCHAR2(150) := FND_API.G_MISS_CHAR,
368: pricing_attribute100 VARCHAR2(150) := FND_API.G_MISS_CHAR,
369: context VARCHAR2(30) := FND_API.G_MISS_CHAR,
370: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
371: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
364: pricing_attribute96 VARCHAR2(150) := FND_API.G_MISS_CHAR,
365: pricing_attribute97 VARCHAR2(150) := FND_API.G_MISS_CHAR,
366: pricing_attribute98 VARCHAR2(150) := FND_API.G_MISS_CHAR,
367: pricing_attribute99 VARCHAR2(150) := FND_API.G_MISS_CHAR,
368: pricing_attribute100 VARCHAR2(150) := FND_API.G_MISS_CHAR,
369: context VARCHAR2(30) := FND_API.G_MISS_CHAR,
370: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
371: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
372: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
365: pricing_attribute97 VARCHAR2(150) := FND_API.G_MISS_CHAR,
366: pricing_attribute98 VARCHAR2(150) := FND_API.G_MISS_CHAR,
367: pricing_attribute99 VARCHAR2(150) := FND_API.G_MISS_CHAR,
368: pricing_attribute100 VARCHAR2(150) := FND_API.G_MISS_CHAR,
369: context VARCHAR2(30) := FND_API.G_MISS_CHAR,
370: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
371: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
372: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
373: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
366: pricing_attribute98 VARCHAR2(150) := FND_API.G_MISS_CHAR,
367: pricing_attribute99 VARCHAR2(150) := FND_API.G_MISS_CHAR,
368: pricing_attribute100 VARCHAR2(150) := FND_API.G_MISS_CHAR,
369: context VARCHAR2(30) := FND_API.G_MISS_CHAR,
370: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
371: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
372: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
373: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
374: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
367: pricing_attribute99 VARCHAR2(150) := FND_API.G_MISS_CHAR,
368: pricing_attribute100 VARCHAR2(150) := FND_API.G_MISS_CHAR,
369: context VARCHAR2(30) := FND_API.G_MISS_CHAR,
370: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
371: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
372: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
373: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
374: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
375: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
368: pricing_attribute100 VARCHAR2(150) := FND_API.G_MISS_CHAR,
369: context VARCHAR2(30) := FND_API.G_MISS_CHAR,
370: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
371: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
372: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
373: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
374: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
375: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
376: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
369: context VARCHAR2(30) := FND_API.G_MISS_CHAR,
370: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
371: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
372: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
373: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
374: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
375: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
376: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
377: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
370: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
371: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
372: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
373: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
374: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
375: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
376: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
377: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
378: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
371: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
372: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
373: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
374: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
375: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
376: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
377: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
378: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
379: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
372: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
373: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
374: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
375: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
376: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
377: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
378: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
379: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
380: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
373: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
374: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
375: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
376: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
377: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
378: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
379: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
380: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
381: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
374: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
375: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
376: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
377: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
378: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
379: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
380: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
381: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
382: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
375: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
376: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
377: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
378: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
379: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
380: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
381: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
382: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
383: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
376: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
377: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
378: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
379: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
380: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
381: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
382: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
383: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
384: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
377: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
378: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
379: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
380: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
381: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
382: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
383: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
384: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
385: object_version_number NUMBER := FND_API.G_MISS_NUM
378: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
379: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
380: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
381: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
382: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
383: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
384: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
385: object_version_number NUMBER := FND_API.G_MISS_NUM
386: );
379: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
380: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
381: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
382: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
383: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
384: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
385: object_version_number NUMBER := FND_API.G_MISS_NUM
386: );
387:
380: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
381: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
382: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
383: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
384: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
385: object_version_number NUMBER := FND_API.G_MISS_NUM
386: );
387:
388: TYPE txn_pricing_attribs_tbl IS TABLE OF txn_pricing_attrib_rec INDEX BY BINARY_INTEGER;
381: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
382: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
383: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
384: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
385: object_version_number NUMBER := FND_API.G_MISS_NUM
386: );
387:
388: TYPE txn_pricing_attribs_tbl IS TABLE OF txn_pricing_attrib_rec INDEX BY BINARY_INTEGER;
389:
391: -- Description : record to hold information about an instance-org association.
392:
393:
394: TYPE txn_org_unit_rec IS RECORD (
395: instance_ou_id NUMBER := FND_API.G_MISS_NUM,
396: parent_tbl_index NUMBER := FND_API.G_MISS_NUM,
397: instance_id NUMBER := FND_API.G_MISS_NUM,
398: operating_unit_id NUMBER := FND_API.G_MISS_NUM,
399: relationship_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
392:
393:
394: TYPE txn_org_unit_rec IS RECORD (
395: instance_ou_id NUMBER := FND_API.G_MISS_NUM,
396: parent_tbl_index NUMBER := FND_API.G_MISS_NUM,
397: instance_id NUMBER := FND_API.G_MISS_NUM,
398: operating_unit_id NUMBER := FND_API.G_MISS_NUM,
399: relationship_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
400: active_start_date DATE := FND_API.G_MISS_DATE,
393:
394: TYPE txn_org_unit_rec IS RECORD (
395: instance_ou_id NUMBER := FND_API.G_MISS_NUM,
396: parent_tbl_index NUMBER := FND_API.G_MISS_NUM,
397: instance_id NUMBER := FND_API.G_MISS_NUM,
398: operating_unit_id NUMBER := FND_API.G_MISS_NUM,
399: relationship_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
400: active_start_date DATE := FND_API.G_MISS_DATE,
401: active_end_date DATE := FND_API.G_MISS_DATE,
394: TYPE txn_org_unit_rec IS RECORD (
395: instance_ou_id NUMBER := FND_API.G_MISS_NUM,
396: parent_tbl_index NUMBER := FND_API.G_MISS_NUM,
397: instance_id NUMBER := FND_API.G_MISS_NUM,
398: operating_unit_id NUMBER := FND_API.G_MISS_NUM,
399: relationship_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
400: active_start_date DATE := FND_API.G_MISS_DATE,
401: active_end_date DATE := FND_API.G_MISS_DATE,
402: context VARCHAR2(30) := FND_API.G_MISS_CHAR,
395: instance_ou_id NUMBER := FND_API.G_MISS_NUM,
396: parent_tbl_index NUMBER := FND_API.G_MISS_NUM,
397: instance_id NUMBER := FND_API.G_MISS_NUM,
398: operating_unit_id NUMBER := FND_API.G_MISS_NUM,
399: relationship_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
400: active_start_date DATE := FND_API.G_MISS_DATE,
401: active_end_date DATE := FND_API.G_MISS_DATE,
402: context VARCHAR2(30) := FND_API.G_MISS_CHAR,
403: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
396: parent_tbl_index NUMBER := FND_API.G_MISS_NUM,
397: instance_id NUMBER := FND_API.G_MISS_NUM,
398: operating_unit_id NUMBER := FND_API.G_MISS_NUM,
399: relationship_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
400: active_start_date DATE := FND_API.G_MISS_DATE,
401: active_end_date DATE := FND_API.G_MISS_DATE,
402: context VARCHAR2(30) := FND_API.G_MISS_CHAR,
403: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
404: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
397: instance_id NUMBER := FND_API.G_MISS_NUM,
398: operating_unit_id NUMBER := FND_API.G_MISS_NUM,
399: relationship_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
400: active_start_date DATE := FND_API.G_MISS_DATE,
401: active_end_date DATE := FND_API.G_MISS_DATE,
402: context VARCHAR2(30) := FND_API.G_MISS_CHAR,
403: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
404: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
405: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
398: operating_unit_id NUMBER := FND_API.G_MISS_NUM,
399: relationship_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
400: active_start_date DATE := FND_API.G_MISS_DATE,
401: active_end_date DATE := FND_API.G_MISS_DATE,
402: context VARCHAR2(30) := FND_API.G_MISS_CHAR,
403: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
404: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
405: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
406: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
399: relationship_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
400: active_start_date DATE := FND_API.G_MISS_DATE,
401: active_end_date DATE := FND_API.G_MISS_DATE,
402: context VARCHAR2(30) := FND_API.G_MISS_CHAR,
403: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
404: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
405: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
406: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
407: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
400: active_start_date DATE := FND_API.G_MISS_DATE,
401: active_end_date DATE := FND_API.G_MISS_DATE,
402: context VARCHAR2(30) := FND_API.G_MISS_CHAR,
403: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
404: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
405: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
406: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
407: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
408: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
401: active_end_date DATE := FND_API.G_MISS_DATE,
402: context VARCHAR2(30) := FND_API.G_MISS_CHAR,
403: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
404: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
405: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
406: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
407: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
408: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
409: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
402: context VARCHAR2(30) := FND_API.G_MISS_CHAR,
403: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
404: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
405: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
406: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
407: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
408: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
409: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
410: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
403: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
404: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
405: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
406: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
407: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
408: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
409: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
410: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
411: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
404: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
405: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
406: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
407: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
408: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
409: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
410: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
411: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
412: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
405: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
406: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
407: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
408: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
409: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
410: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
411: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
412: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
413: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
406: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
407: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
408: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
409: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
410: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
411: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
412: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
413: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
414: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
407: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
408: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
409: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
410: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
411: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
412: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
413: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
414: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
415: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
408: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
409: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
410: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
411: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
412: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
413: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
414: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
415: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
416: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
409: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
410: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
411: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
412: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
413: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
414: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
415: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
416: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
417: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
410: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
411: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
412: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
413: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
414: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
415: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
416: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
417: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
418: object_version_number NUMBER := FND_API.G_MISS_NUM
411: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
412: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
413: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
414: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
415: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
416: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
417: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
418: object_version_number NUMBER := FND_API.G_MISS_NUM
419: );
412: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
413: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
414: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
415: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
416: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
417: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
418: object_version_number NUMBER := FND_API.G_MISS_NUM
419: );
420:
413: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
414: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
415: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
416: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
417: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
418: object_version_number NUMBER := FND_API.G_MISS_NUM
419: );
420:
421: TYPE txn_org_units_tbl IS TABLE OF txn_org_unit_rec INDEX BY BINARY_INTEGER;
414: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
415: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
416: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
417: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
418: object_version_number NUMBER := FND_API.G_MISS_NUM
419: );
420:
421: TYPE txn_org_units_tbl IS TABLE OF txn_org_unit_rec INDEX BY BINARY_INTEGER;
422:
423: -- Name : txn_instance_asset_rec
424: -- Description : record to hold information about instance-asset association.
425:
426: TYPE txn_instance_asset_rec IS RECORD (
427: instance_asset_id NUMBER := FND_API.G_MISS_NUM,
428: parent_tbl_index NUMBER := FND_API.G_MISS_NUM,
429: instance_id NUMBER := FND_API.G_MISS_NUM,
430: fa_asset_id NUMBER := FND_API.G_MISS_NUM,
431: fa_book_type_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
424: -- Description : record to hold information about instance-asset association.
425:
426: TYPE txn_instance_asset_rec IS RECORD (
427: instance_asset_id NUMBER := FND_API.G_MISS_NUM,
428: parent_tbl_index NUMBER := FND_API.G_MISS_NUM,
429: instance_id NUMBER := FND_API.G_MISS_NUM,
430: fa_asset_id NUMBER := FND_API.G_MISS_NUM,
431: fa_book_type_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
432: fa_location_id NUMBER := FND_API.G_MISS_NUM,
425:
426: TYPE txn_instance_asset_rec IS RECORD (
427: instance_asset_id NUMBER := FND_API.G_MISS_NUM,
428: parent_tbl_index NUMBER := FND_API.G_MISS_NUM,
429: instance_id NUMBER := FND_API.G_MISS_NUM,
430: fa_asset_id NUMBER := FND_API.G_MISS_NUM,
431: fa_book_type_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
432: fa_location_id NUMBER := FND_API.G_MISS_NUM,
433: asset_quantity NUMBER := FND_API.G_MISS_NUM,
426: TYPE txn_instance_asset_rec IS RECORD (
427: instance_asset_id NUMBER := FND_API.G_MISS_NUM,
428: parent_tbl_index NUMBER := FND_API.G_MISS_NUM,
429: instance_id NUMBER := FND_API.G_MISS_NUM,
430: fa_asset_id NUMBER := FND_API.G_MISS_NUM,
431: fa_book_type_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
432: fa_location_id NUMBER := FND_API.G_MISS_NUM,
433: asset_quantity NUMBER := FND_API.G_MISS_NUM,
434: update_status VARCHAR2(30) := FND_API.G_MISS_CHAR,
427: instance_asset_id NUMBER := FND_API.G_MISS_NUM,
428: parent_tbl_index NUMBER := FND_API.G_MISS_NUM,
429: instance_id NUMBER := FND_API.G_MISS_NUM,
430: fa_asset_id NUMBER := FND_API.G_MISS_NUM,
431: fa_book_type_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
432: fa_location_id NUMBER := FND_API.G_MISS_NUM,
433: asset_quantity NUMBER := FND_API.G_MISS_NUM,
434: update_status VARCHAR2(30) := FND_API.G_MISS_CHAR,
435: active_start_date DATE := FND_API.G_MISS_DATE,
428: parent_tbl_index NUMBER := FND_API.G_MISS_NUM,
429: instance_id NUMBER := FND_API.G_MISS_NUM,
430: fa_asset_id NUMBER := FND_API.G_MISS_NUM,
431: fa_book_type_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
432: fa_location_id NUMBER := FND_API.G_MISS_NUM,
433: asset_quantity NUMBER := FND_API.G_MISS_NUM,
434: update_status VARCHAR2(30) := FND_API.G_MISS_CHAR,
435: active_start_date DATE := FND_API.G_MISS_DATE,
436: active_end_date DATE := FND_API.G_MISS_DATE,
429: instance_id NUMBER := FND_API.G_MISS_NUM,
430: fa_asset_id NUMBER := FND_API.G_MISS_NUM,
431: fa_book_type_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
432: fa_location_id NUMBER := FND_API.G_MISS_NUM,
433: asset_quantity NUMBER := FND_API.G_MISS_NUM,
434: update_status VARCHAR2(30) := FND_API.G_MISS_CHAR,
435: active_start_date DATE := FND_API.G_MISS_DATE,
436: active_end_date DATE := FND_API.G_MISS_DATE,
437: object_version_number NUMBER := FND_API.G_MISS_NUM);
430: fa_asset_id NUMBER := FND_API.G_MISS_NUM,
431: fa_book_type_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
432: fa_location_id NUMBER := FND_API.G_MISS_NUM,
433: asset_quantity NUMBER := FND_API.G_MISS_NUM,
434: update_status VARCHAR2(30) := FND_API.G_MISS_CHAR,
435: active_start_date DATE := FND_API.G_MISS_DATE,
436: active_end_date DATE := FND_API.G_MISS_DATE,
437: object_version_number NUMBER := FND_API.G_MISS_NUM);
438:
431: fa_book_type_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
432: fa_location_id NUMBER := FND_API.G_MISS_NUM,
433: asset_quantity NUMBER := FND_API.G_MISS_NUM,
434: update_status VARCHAR2(30) := FND_API.G_MISS_CHAR,
435: active_start_date DATE := FND_API.G_MISS_DATE,
436: active_end_date DATE := FND_API.G_MISS_DATE,
437: object_version_number NUMBER := FND_API.G_MISS_NUM);
438:
439: TYPE txn_instance_asset_tbl IS TABLE OF txn_instance_asset_rec INDEX BY BINARY_INTEGER;
432: fa_location_id NUMBER := FND_API.G_MISS_NUM,
433: asset_quantity NUMBER := FND_API.G_MISS_NUM,
434: update_status VARCHAR2(30) := FND_API.G_MISS_CHAR,
435: active_start_date DATE := FND_API.G_MISS_DATE,
436: active_end_date DATE := FND_API.G_MISS_DATE,
437: object_version_number NUMBER := FND_API.G_MISS_NUM);
438:
439: TYPE txn_instance_asset_tbl IS TABLE OF txn_instance_asset_rec INDEX BY BINARY_INTEGER;
440:
433: asset_quantity NUMBER := FND_API.G_MISS_NUM,
434: update_status VARCHAR2(30) := FND_API.G_MISS_CHAR,
435: active_start_date DATE := FND_API.G_MISS_DATE,
436: active_end_date DATE := FND_API.G_MISS_DATE,
437: object_version_number NUMBER := FND_API.G_MISS_NUM);
438:
439: TYPE txn_instance_asset_tbl IS TABLE OF txn_instance_asset_rec INDEX BY BINARY_INTEGER;
440:
441:
448: /*-------------------------------------------------------------------*/
449:
450: PROCEDURE process_transaction (
451: p_api_version IN NUMBER,
452: p_commit IN VARCHAR2 := fnd_api.g_false,
453: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
454: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
455: p_validate_only_flag IN VARCHAR2 := fnd_api.g_false,
456: p_in_out_flag IN VARCHAR2, -- valid values are 'IN', 'OUT'
449:
450: PROCEDURE process_transaction (
451: p_api_version IN NUMBER,
452: p_commit IN VARCHAR2 := fnd_api.g_false,
453: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
454: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
455: p_validate_only_flag IN VARCHAR2 := fnd_api.g_false,
456: p_in_out_flag IN VARCHAR2, -- valid values are 'IN', 'OUT'
457: p_dest_location_rec IN OUT NOCOPY dest_location_rec,
450: PROCEDURE process_transaction (
451: p_api_version IN NUMBER,
452: p_commit IN VARCHAR2 := fnd_api.g_false,
453: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
454: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
455: p_validate_only_flag IN VARCHAR2 := fnd_api.g_false,
456: p_in_out_flag IN VARCHAR2, -- valid values are 'IN', 'OUT'
457: p_dest_location_rec IN OUT NOCOPY dest_location_rec,
458: p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
451: p_api_version IN NUMBER,
452: p_commit IN VARCHAR2 := fnd_api.g_false,
453: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
454: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
455: p_validate_only_flag IN VARCHAR2 := fnd_api.g_false,
456: p_in_out_flag IN VARCHAR2, -- valid values are 'IN', 'OUT'
457: p_dest_location_rec IN OUT NOCOPY dest_location_rec,
458: p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
459: p_instances_tbl IN OUT NOCOPY txn_instances_tbl,
471:
472: /* overloading to supress the visibility of the signature change to field service */
473: PROCEDURE process_transaction (
474: p_api_version IN NUMBER,
475: p_commit IN VARCHAR2 := fnd_api.g_false,
476: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
477: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
478: p_validate_only_flag IN VARCHAR2 := fnd_api.g_false,
479: p_in_out_flag IN VARCHAR2, -- valid values are 'IN', 'OUT'
472: /* overloading to supress the visibility of the signature change to field service */
473: PROCEDURE process_transaction (
474: p_api_version IN NUMBER,
475: p_commit IN VARCHAR2 := fnd_api.g_false,
476: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
477: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
478: p_validate_only_flag IN VARCHAR2 := fnd_api.g_false,
479: p_in_out_flag IN VARCHAR2, -- valid values are 'IN', 'OUT'
480: p_dest_location_rec IN OUT NOCOPY dest_location_rec,
473: PROCEDURE process_transaction (
474: p_api_version IN NUMBER,
475: p_commit IN VARCHAR2 := fnd_api.g_false,
476: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
477: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
478: p_validate_only_flag IN VARCHAR2 := fnd_api.g_false,
479: p_in_out_flag IN VARCHAR2, -- valid values are 'IN', 'OUT'
480: p_dest_location_rec IN OUT NOCOPY dest_location_rec,
481: p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
474: p_api_version IN NUMBER,
475: p_commit IN VARCHAR2 := fnd_api.g_false,
476: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
477: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
478: p_validate_only_flag IN VARCHAR2 := fnd_api.g_false,
479: p_in_out_flag IN VARCHAR2, -- valid values are 'IN', 'OUT'
480: p_dest_location_rec IN OUT NOCOPY dest_location_rec,
481: p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
482: p_instances_tbl IN OUT NOCOPY txn_instances_tbl,