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: CALL_CONTRACTS VARCHAR2(1) := FND_API.G_TRUE, -- Bug 12390649
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: CALL_CONTRACTS VARCHAR2(1) := FND_API.G_TRUE, -- Bug 12390649
93: OPERATIONAL_STATUS_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: CALL_CONTRACTS VARCHAR2(1) := FND_API.G_TRUE, -- Bug 12390649
93: OPERATIONAL_STATUS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR);
94:
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: CALL_CONTRACTS VARCHAR2(1) := FND_API.G_TRUE, -- Bug 12390649
93: OPERATIONAL_STATUS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR);
94:
95: TYPE dest_location_rec IS RECORD (
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: CALL_CONTRACTS VARCHAR2(1) := FND_API.G_TRUE, -- Bug 12390649
93: OPERATIONAL_STATUS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR);
94:
95: TYPE dest_location_rec IS RECORD (
96: parent_tbl_index NUMBER := fnd_api.g_miss_num,
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: CALL_CONTRACTS VARCHAR2(1) := FND_API.G_TRUE, -- Bug 12390649
93: OPERATIONAL_STATUS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR);
94:
95: TYPE dest_location_rec IS RECORD (
96: parent_tbl_index NUMBER := fnd_api.g_miss_num,
97: location_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
92: CALL_CONTRACTS VARCHAR2(1) := FND_API.G_TRUE, -- Bug 12390649
93: OPERATIONAL_STATUS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR);
94:
95: TYPE dest_location_rec IS RECORD (
96: parent_tbl_index NUMBER := fnd_api.g_miss_num,
97: location_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
98: location_id NUMBER := FND_API.G_MISS_NUM,
99: install_location_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
100: install_location_id NUMBER := FND_API.G_MISS_NUM,
93: OPERATIONAL_STATUS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR);
94:
95: TYPE dest_location_rec IS RECORD (
96: parent_tbl_index NUMBER := fnd_api.g_miss_num,
97: location_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
98: location_id NUMBER := FND_API.G_MISS_NUM,
99: install_location_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
100: install_location_id NUMBER := FND_API.G_MISS_NUM,
101: instance_usage_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
94:
95: TYPE dest_location_rec IS RECORD (
96: parent_tbl_index NUMBER := fnd_api.g_miss_num,
97: location_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
98: location_id NUMBER := FND_API.G_MISS_NUM,
99: install_location_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
100: install_location_id NUMBER := FND_API.G_MISS_NUM,
101: instance_usage_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
102: inv_organization_id NUMBER := FND_API.G_MISS_NUM,
95: TYPE dest_location_rec IS RECORD (
96: parent_tbl_index NUMBER := fnd_api.g_miss_num,
97: location_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
98: location_id NUMBER := FND_API.G_MISS_NUM,
99: install_location_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
100: install_location_id NUMBER := FND_API.G_MISS_NUM,
101: instance_usage_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
102: inv_organization_id NUMBER := FND_API.G_MISS_NUM,
103: inv_subinventory_name VARCHAR2(10) := FND_API.G_MISS_CHAR,
96: parent_tbl_index NUMBER := fnd_api.g_miss_num,
97: location_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
98: location_id NUMBER := FND_API.G_MISS_NUM,
99: install_location_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
100: install_location_id NUMBER := FND_API.G_MISS_NUM,
101: instance_usage_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
102: inv_organization_id NUMBER := FND_API.G_MISS_NUM,
103: inv_subinventory_name VARCHAR2(10) := FND_API.G_MISS_CHAR,
104: inv_locator_id NUMBER := FND_API.G_MISS_NUM,
97: location_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
98: location_id NUMBER := FND_API.G_MISS_NUM,
99: install_location_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
100: install_location_id NUMBER := FND_API.G_MISS_NUM,
101: instance_usage_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
102: inv_organization_id NUMBER := FND_API.G_MISS_NUM,
103: inv_subinventory_name VARCHAR2(10) := FND_API.G_MISS_CHAR,
104: inv_locator_id NUMBER := FND_API.G_MISS_NUM,
105: pa_project_id NUMBER := FND_API.G_MISS_NUM,
98: location_id NUMBER := FND_API.G_MISS_NUM,
99: install_location_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
100: install_location_id NUMBER := FND_API.G_MISS_NUM,
101: instance_usage_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
102: inv_organization_id NUMBER := FND_API.G_MISS_NUM,
103: inv_subinventory_name VARCHAR2(10) := FND_API.G_MISS_CHAR,
104: inv_locator_id NUMBER := FND_API.G_MISS_NUM,
105: pa_project_id NUMBER := FND_API.G_MISS_NUM,
106: pa_project_task_id NUMBER := FND_API.G_MISS_NUM,
99: install_location_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
100: install_location_id NUMBER := FND_API.G_MISS_NUM,
101: instance_usage_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
102: inv_organization_id NUMBER := FND_API.G_MISS_NUM,
103: inv_subinventory_name VARCHAR2(10) := FND_API.G_MISS_CHAR,
104: inv_locator_id NUMBER := FND_API.G_MISS_NUM,
105: pa_project_id NUMBER := FND_API.G_MISS_NUM,
106: pa_project_task_id NUMBER := FND_API.G_MISS_NUM,
107: in_transit_order_line_id NUMBER := fnd_api.g_miss_num,
100: install_location_id NUMBER := FND_API.G_MISS_NUM,
101: instance_usage_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
102: inv_organization_id NUMBER := FND_API.G_MISS_NUM,
103: inv_subinventory_name VARCHAR2(10) := FND_API.G_MISS_CHAR,
104: inv_locator_id NUMBER := FND_API.G_MISS_NUM,
105: pa_project_id NUMBER := FND_API.G_MISS_NUM,
106: pa_project_task_id NUMBER := FND_API.G_MISS_NUM,
107: in_transit_order_line_id NUMBER := fnd_api.g_miss_num,
108: wip_job_id NUMBER := fnd_api.g_miss_num,
101: instance_usage_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
102: inv_organization_id NUMBER := FND_API.G_MISS_NUM,
103: inv_subinventory_name VARCHAR2(10) := FND_API.G_MISS_CHAR,
104: inv_locator_id NUMBER := FND_API.G_MISS_NUM,
105: pa_project_id NUMBER := FND_API.G_MISS_NUM,
106: pa_project_task_id NUMBER := FND_API.G_MISS_NUM,
107: in_transit_order_line_id NUMBER := fnd_api.g_miss_num,
108: wip_job_id NUMBER := fnd_api.g_miss_num,
109: last_wip_job_id number := fnd_api.g_miss_num, --bug 5376024
102: inv_organization_id NUMBER := FND_API.G_MISS_NUM,
103: inv_subinventory_name VARCHAR2(10) := FND_API.G_MISS_CHAR,
104: inv_locator_id NUMBER := FND_API.G_MISS_NUM,
105: pa_project_id NUMBER := FND_API.G_MISS_NUM,
106: pa_project_task_id NUMBER := FND_API.G_MISS_NUM,
107: in_transit_order_line_id NUMBER := fnd_api.g_miss_num,
108: wip_job_id NUMBER := fnd_api.g_miss_num,
109: last_wip_job_id number := fnd_api.g_miss_num, --bug 5376024
110: po_order_line_id NUMBER := fnd_api.g_miss_num,
103: inv_subinventory_name VARCHAR2(10) := FND_API.G_MISS_CHAR,
104: inv_locator_id NUMBER := FND_API.G_MISS_NUM,
105: pa_project_id NUMBER := FND_API.G_MISS_NUM,
106: pa_project_task_id NUMBER := FND_API.G_MISS_NUM,
107: in_transit_order_line_id NUMBER := fnd_api.g_miss_num,
108: wip_job_id NUMBER := fnd_api.g_miss_num,
109: last_wip_job_id number := fnd_api.g_miss_num, --bug 5376024
110: po_order_line_id NUMBER := fnd_api.g_miss_num,
111: last_pa_project_id NUMBER := fnd_api.g_miss_num,
104: inv_locator_id NUMBER := FND_API.G_MISS_NUM,
105: pa_project_id NUMBER := FND_API.G_MISS_NUM,
106: pa_project_task_id NUMBER := FND_API.G_MISS_NUM,
107: in_transit_order_line_id NUMBER := fnd_api.g_miss_num,
108: wip_job_id NUMBER := fnd_api.g_miss_num,
109: last_wip_job_id number := fnd_api.g_miss_num, --bug 5376024
110: po_order_line_id NUMBER := fnd_api.g_miss_num,
111: last_pa_project_id NUMBER := fnd_api.g_miss_num,
112: last_pa_project_task_id NUMBER := fnd_api.g_miss_num,
105: pa_project_id NUMBER := FND_API.G_MISS_NUM,
106: pa_project_task_id NUMBER := FND_API.G_MISS_NUM,
107: in_transit_order_line_id NUMBER := fnd_api.g_miss_num,
108: wip_job_id NUMBER := fnd_api.g_miss_num,
109: last_wip_job_id number := fnd_api.g_miss_num, --bug 5376024
110: po_order_line_id NUMBER := fnd_api.g_miss_num,
111: last_pa_project_id NUMBER := fnd_api.g_miss_num,
112: last_pa_project_task_id NUMBER := fnd_api.g_miss_num,
113: external_reference VARCHAR2(30) := fnd_api.g_miss_char,
106: pa_project_task_id NUMBER := FND_API.G_MISS_NUM,
107: in_transit_order_line_id NUMBER := fnd_api.g_miss_num,
108: wip_job_id NUMBER := fnd_api.g_miss_num,
109: last_wip_job_id number := fnd_api.g_miss_num, --bug 5376024
110: po_order_line_id NUMBER := fnd_api.g_miss_num,
111: last_pa_project_id NUMBER := fnd_api.g_miss_num,
112: last_pa_project_task_id NUMBER := fnd_api.g_miss_num,
113: external_reference VARCHAR2(30) := fnd_api.g_miss_char,
114: operational_status_code VARCHAR2(30) := fnd_api.g_miss_char);
107: in_transit_order_line_id NUMBER := fnd_api.g_miss_num,
108: wip_job_id NUMBER := fnd_api.g_miss_num,
109: last_wip_job_id number := fnd_api.g_miss_num, --bug 5376024
110: po_order_line_id NUMBER := fnd_api.g_miss_num,
111: last_pa_project_id NUMBER := fnd_api.g_miss_num,
112: last_pa_project_task_id NUMBER := fnd_api.g_miss_num,
113: external_reference VARCHAR2(30) := fnd_api.g_miss_char,
114: operational_status_code VARCHAR2(30) := fnd_api.g_miss_char);
115:
108: wip_job_id NUMBER := fnd_api.g_miss_num,
109: last_wip_job_id number := fnd_api.g_miss_num, --bug 5376024
110: po_order_line_id NUMBER := fnd_api.g_miss_num,
111: last_pa_project_id NUMBER := fnd_api.g_miss_num,
112: last_pa_project_task_id NUMBER := fnd_api.g_miss_num,
113: external_reference VARCHAR2(30) := fnd_api.g_miss_char,
114: operational_status_code VARCHAR2(30) := fnd_api.g_miss_char);
115:
116:
109: last_wip_job_id number := fnd_api.g_miss_num, --bug 5376024
110: po_order_line_id NUMBER := fnd_api.g_miss_num,
111: last_pa_project_id NUMBER := fnd_api.g_miss_num,
112: last_pa_project_task_id NUMBER := fnd_api.g_miss_num,
113: external_reference VARCHAR2(30) := fnd_api.g_miss_char,
114: operational_status_code VARCHAR2(30) := fnd_api.g_miss_char);
115:
116:
117: TYPE txn_instances_tbl is TABLE OF txn_instance_rec INDEX BY BINARY_INTEGER;
110: po_order_line_id NUMBER := fnd_api.g_miss_num,
111: last_pa_project_id NUMBER := fnd_api.g_miss_num,
112: last_pa_project_task_id NUMBER := fnd_api.g_miss_num,
113: external_reference VARCHAR2(30) := fnd_api.g_miss_char,
114: operational_status_code VARCHAR2(30) := fnd_api.g_miss_char);
115:
116:
117: TYPE txn_instances_tbl is TABLE OF txn_instance_rec INDEX BY BINARY_INTEGER;
118:
119: -- Name : txn_i_party_rec
120: -- Description : record to hold information about an instance-party relationship.
121:
122: TYPE txn_i_party_rec IS RECORD (
123: instance_party_id NUMBER := FND_API.G_MISS_NUM,
124: parent_tbl_index NUMBER := FND_API.G_MISS_NUM,
125: instance_id NUMBER := FND_API.G_MISS_NUM,
126: party_source_table VARCHAR2(30) := FND_API.G_MISS_CHAR,
127: party_id NUMBER := FND_API.G_MISS_NUM,
120: -- Description : record to hold information about an instance-party relationship.
121:
122: TYPE txn_i_party_rec IS RECORD (
123: instance_party_id NUMBER := FND_API.G_MISS_NUM,
124: parent_tbl_index NUMBER := FND_API.G_MISS_NUM,
125: instance_id NUMBER := FND_API.G_MISS_NUM,
126: party_source_table VARCHAR2(30) := FND_API.G_MISS_CHAR,
127: party_id NUMBER := FND_API.G_MISS_NUM,
128: relationship_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
121:
122: TYPE txn_i_party_rec IS RECORD (
123: instance_party_id NUMBER := FND_API.G_MISS_NUM,
124: parent_tbl_index NUMBER := FND_API.G_MISS_NUM,
125: instance_id NUMBER := FND_API.G_MISS_NUM,
126: party_source_table VARCHAR2(30) := FND_API.G_MISS_CHAR,
127: party_id NUMBER := FND_API.G_MISS_NUM,
128: relationship_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
129: contact_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
122: TYPE txn_i_party_rec IS RECORD (
123: instance_party_id NUMBER := FND_API.G_MISS_NUM,
124: parent_tbl_index NUMBER := FND_API.G_MISS_NUM,
125: instance_id NUMBER := FND_API.G_MISS_NUM,
126: party_source_table VARCHAR2(30) := FND_API.G_MISS_CHAR,
127: party_id NUMBER := FND_API.G_MISS_NUM,
128: relationship_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
129: contact_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
130: contact_ip_id NUMBER := FND_API.G_MISS_NUM,
123: instance_party_id NUMBER := FND_API.G_MISS_NUM,
124: parent_tbl_index NUMBER := FND_API.G_MISS_NUM,
125: instance_id NUMBER := FND_API.G_MISS_NUM,
126: party_source_table VARCHAR2(30) := FND_API.G_MISS_CHAR,
127: party_id NUMBER := FND_API.G_MISS_NUM,
128: relationship_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
129: contact_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
130: contact_ip_id NUMBER := FND_API.G_MISS_NUM,
131: active_start_date DATE := FND_API.G_MISS_DATE,
124: parent_tbl_index NUMBER := FND_API.G_MISS_NUM,
125: instance_id NUMBER := FND_API.G_MISS_NUM,
126: party_source_table VARCHAR2(30) := FND_API.G_MISS_CHAR,
127: party_id NUMBER := FND_API.G_MISS_NUM,
128: relationship_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
129: contact_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
130: contact_ip_id NUMBER := FND_API.G_MISS_NUM,
131: active_start_date DATE := FND_API.G_MISS_DATE,
132: active_end_date DATE := FND_API.G_MISS_DATE,
125: instance_id NUMBER := FND_API.G_MISS_NUM,
126: party_source_table VARCHAR2(30) := FND_API.G_MISS_CHAR,
127: party_id NUMBER := FND_API.G_MISS_NUM,
128: relationship_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
129: contact_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
130: contact_ip_id NUMBER := FND_API.G_MISS_NUM,
131: active_start_date DATE := FND_API.G_MISS_DATE,
132: active_end_date DATE := FND_API.G_MISS_DATE,
133: context VARCHAR2(30) := FND_API.G_MISS_CHAR,
126: party_source_table VARCHAR2(30) := FND_API.G_MISS_CHAR,
127: party_id NUMBER := FND_API.G_MISS_NUM,
128: relationship_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
129: contact_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
130: contact_ip_id NUMBER := FND_API.G_MISS_NUM,
131: active_start_date DATE := FND_API.G_MISS_DATE,
132: active_end_date DATE := FND_API.G_MISS_DATE,
133: context VARCHAR2(30) := FND_API.G_MISS_CHAR,
134: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
127: party_id NUMBER := FND_API.G_MISS_NUM,
128: relationship_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
129: contact_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
130: contact_ip_id NUMBER := FND_API.G_MISS_NUM,
131: active_start_date DATE := FND_API.G_MISS_DATE,
132: active_end_date DATE := FND_API.G_MISS_DATE,
133: context VARCHAR2(30) := FND_API.G_MISS_CHAR,
134: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
135: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
128: relationship_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
129: contact_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
130: contact_ip_id NUMBER := FND_API.G_MISS_NUM,
131: active_start_date DATE := FND_API.G_MISS_DATE,
132: active_end_date DATE := FND_API.G_MISS_DATE,
133: context VARCHAR2(30) := FND_API.G_MISS_CHAR,
134: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
135: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
136: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
129: contact_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
130: contact_ip_id NUMBER := FND_API.G_MISS_NUM,
131: active_start_date DATE := FND_API.G_MISS_DATE,
132: active_end_date DATE := FND_API.G_MISS_DATE,
133: context VARCHAR2(30) := FND_API.G_MISS_CHAR,
134: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
135: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
136: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
137: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
130: contact_ip_id NUMBER := FND_API.G_MISS_NUM,
131: active_start_date DATE := FND_API.G_MISS_DATE,
132: active_end_date DATE := FND_API.G_MISS_DATE,
133: context VARCHAR2(30) := FND_API.G_MISS_CHAR,
134: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
135: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
136: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
137: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
138: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
131: active_start_date DATE := FND_API.G_MISS_DATE,
132: active_end_date DATE := FND_API.G_MISS_DATE,
133: context VARCHAR2(30) := FND_API.G_MISS_CHAR,
134: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
135: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
136: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
137: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
138: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
139: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
132: active_end_date DATE := FND_API.G_MISS_DATE,
133: context VARCHAR2(30) := FND_API.G_MISS_CHAR,
134: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
135: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
136: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
137: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
138: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
139: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
140: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
133: context VARCHAR2(30) := FND_API.G_MISS_CHAR,
134: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
135: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
136: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
137: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
138: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
139: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
140: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
141: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
134: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
135: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
136: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
137: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
138: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
139: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
140: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
141: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
142: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
135: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
136: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
137: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
138: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
139: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
140: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
141: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
142: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
143: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
136: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
137: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
138: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
139: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
140: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
141: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
142: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
143: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
144: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
137: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
138: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
139: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
140: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
141: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
142: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
143: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
144: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
145: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
138: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
139: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
140: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
141: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
142: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
143: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
144: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
145: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
146: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
139: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
140: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
141: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
142: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
143: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
144: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
145: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
146: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
147: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
140: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
141: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
142: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
143: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
144: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
145: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
146: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
147: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
148: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
141: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
142: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
143: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
144: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
145: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
146: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
147: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
148: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
149: object_version_number NUMBER := FND_API.G_MISS_NUM
142: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
143: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
144: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
145: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
146: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
147: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
148: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
149: object_version_number NUMBER := FND_API.G_MISS_NUM
150: );
143: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
144: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
145: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
146: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
147: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
148: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
149: object_version_number NUMBER := FND_API.G_MISS_NUM
150: );
151:
144: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
145: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
146: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
147: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
148: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
149: object_version_number NUMBER := FND_API.G_MISS_NUM
150: );
151:
152: TYPE txn_i_parties_tbl IS TABLE OF txn_i_party_rec INDEX BY BINARY_INTEGER;
145: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
146: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
147: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
148: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
149: object_version_number NUMBER := FND_API.G_MISS_NUM
150: );
151:
152: TYPE txn_i_parties_tbl IS TABLE OF txn_i_party_rec INDEX BY BINARY_INTEGER;
153:
154: -- Name : txn_ip_account_rec
155: -- Description : record to hold information about a party-account relationship.
156:
157: TYPE txn_ip_account_rec IS RECORD (
158: ip_account_id NUMBER := FND_API.G_MISS_NUM,
159: parent_tbl_index NUMBER := FND_API.G_MISS_NUM,
160: instance_party_id NUMBER := FND_API.G_MISS_NUM,
161: party_account_id NUMBER := FND_API.G_MISS_NUM,
162: relationship_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
155: -- Description : record to hold information about a party-account relationship.
156:
157: TYPE txn_ip_account_rec IS RECORD (
158: ip_account_id NUMBER := FND_API.G_MISS_NUM,
159: parent_tbl_index NUMBER := FND_API.G_MISS_NUM,
160: instance_party_id NUMBER := FND_API.G_MISS_NUM,
161: party_account_id NUMBER := FND_API.G_MISS_NUM,
162: relationship_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
163: bill_to_address NUMBER := FND_API.G_MISS_NUM,
156:
157: TYPE txn_ip_account_rec IS RECORD (
158: ip_account_id NUMBER := FND_API.G_MISS_NUM,
159: parent_tbl_index NUMBER := FND_API.G_MISS_NUM,
160: instance_party_id NUMBER := FND_API.G_MISS_NUM,
161: party_account_id NUMBER := FND_API.G_MISS_NUM,
162: relationship_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
163: bill_to_address NUMBER := FND_API.G_MISS_NUM,
164: ship_to_address NUMBER := FND_API.G_MISS_NUM,
157: TYPE txn_ip_account_rec IS RECORD (
158: ip_account_id NUMBER := FND_API.G_MISS_NUM,
159: parent_tbl_index NUMBER := FND_API.G_MISS_NUM,
160: instance_party_id NUMBER := FND_API.G_MISS_NUM,
161: party_account_id NUMBER := FND_API.G_MISS_NUM,
162: relationship_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
163: bill_to_address NUMBER := FND_API.G_MISS_NUM,
164: ship_to_address NUMBER := FND_API.G_MISS_NUM,
165: active_start_date DATE := FND_API.G_MISS_DATE,
158: ip_account_id NUMBER := FND_API.G_MISS_NUM,
159: parent_tbl_index NUMBER := FND_API.G_MISS_NUM,
160: instance_party_id NUMBER := FND_API.G_MISS_NUM,
161: party_account_id NUMBER := FND_API.G_MISS_NUM,
162: relationship_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
163: bill_to_address NUMBER := FND_API.G_MISS_NUM,
164: ship_to_address NUMBER := FND_API.G_MISS_NUM,
165: active_start_date DATE := FND_API.G_MISS_DATE,
166: active_end_date DATE := FND_API.G_MISS_DATE,
159: parent_tbl_index NUMBER := FND_API.G_MISS_NUM,
160: instance_party_id NUMBER := FND_API.G_MISS_NUM,
161: party_account_id NUMBER := FND_API.G_MISS_NUM,
162: relationship_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
163: bill_to_address NUMBER := FND_API.G_MISS_NUM,
164: ship_to_address NUMBER := FND_API.G_MISS_NUM,
165: active_start_date DATE := FND_API.G_MISS_DATE,
166: active_end_date DATE := FND_API.G_MISS_DATE,
167: context VARCHAR2(30) := FND_API.G_MISS_CHAR,
160: instance_party_id NUMBER := FND_API.G_MISS_NUM,
161: party_account_id NUMBER := FND_API.G_MISS_NUM,
162: relationship_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
163: bill_to_address NUMBER := FND_API.G_MISS_NUM,
164: ship_to_address NUMBER := FND_API.G_MISS_NUM,
165: active_start_date DATE := FND_API.G_MISS_DATE,
166: active_end_date DATE := FND_API.G_MISS_DATE,
167: context VARCHAR2(30) := FND_API.G_MISS_CHAR,
168: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
161: party_account_id NUMBER := FND_API.G_MISS_NUM,
162: relationship_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
163: bill_to_address NUMBER := FND_API.G_MISS_NUM,
164: ship_to_address NUMBER := FND_API.G_MISS_NUM,
165: active_start_date DATE := FND_API.G_MISS_DATE,
166: active_end_date DATE := FND_API.G_MISS_DATE,
167: context VARCHAR2(30) := FND_API.G_MISS_CHAR,
168: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
169: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
162: relationship_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
163: bill_to_address NUMBER := FND_API.G_MISS_NUM,
164: ship_to_address NUMBER := FND_API.G_MISS_NUM,
165: active_start_date DATE := FND_API.G_MISS_DATE,
166: active_end_date DATE := FND_API.G_MISS_DATE,
167: context VARCHAR2(30) := FND_API.G_MISS_CHAR,
168: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
169: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
170: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
163: bill_to_address NUMBER := FND_API.G_MISS_NUM,
164: ship_to_address NUMBER := FND_API.G_MISS_NUM,
165: active_start_date DATE := FND_API.G_MISS_DATE,
166: active_end_date DATE := FND_API.G_MISS_DATE,
167: context VARCHAR2(30) := FND_API.G_MISS_CHAR,
168: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
169: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
170: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
171: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
164: ship_to_address NUMBER := FND_API.G_MISS_NUM,
165: active_start_date DATE := FND_API.G_MISS_DATE,
166: active_end_date DATE := FND_API.G_MISS_DATE,
167: context VARCHAR2(30) := FND_API.G_MISS_CHAR,
168: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
169: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
170: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
171: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
172: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
165: active_start_date DATE := FND_API.G_MISS_DATE,
166: active_end_date DATE := FND_API.G_MISS_DATE,
167: context VARCHAR2(30) := FND_API.G_MISS_CHAR,
168: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
169: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
170: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
171: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
172: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
173: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
166: active_end_date DATE := FND_API.G_MISS_DATE,
167: context VARCHAR2(30) := FND_API.G_MISS_CHAR,
168: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
169: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
170: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
171: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
172: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
173: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
174: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
167: context VARCHAR2(30) := FND_API.G_MISS_CHAR,
168: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
169: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
170: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
171: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
172: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
173: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
174: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
175: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
168: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
169: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
170: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
171: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
172: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
173: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
174: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
175: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
176: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
169: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
170: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
171: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
172: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
173: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
174: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
175: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
176: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
177: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
170: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
171: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
172: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
173: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
174: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
175: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
176: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
177: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
178: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
171: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
172: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
173: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
174: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
175: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
176: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
177: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
178: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
179: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
172: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
173: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
174: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
175: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
176: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
177: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
178: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
179: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
180: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
173: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
174: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
175: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
176: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
177: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
178: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
179: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
180: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
181: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
174: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
175: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
176: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
177: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
178: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
179: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
180: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
181: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
182: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
175: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
176: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
177: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
178: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
179: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
180: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
181: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
182: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
183: call_contracts VARCHAR2(1) := FND_API.G_TRUE, -- Bug 12390649
176: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
177: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
178: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
179: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
180: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
181: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
182: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
183: call_contracts VARCHAR2(1) := FND_API.G_TRUE, -- Bug 12390649
184: object_version_number NUMBER := FND_API.G_MISS_NUM
177: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
178: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
179: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
180: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
181: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
182: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
183: call_contracts VARCHAR2(1) := FND_API.G_TRUE, -- Bug 12390649
184: object_version_number NUMBER := FND_API.G_MISS_NUM
185: );
178: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
179: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
180: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
181: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
182: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
183: call_contracts VARCHAR2(1) := FND_API.G_TRUE, -- Bug 12390649
184: object_version_number NUMBER := FND_API.G_MISS_NUM
185: );
186:
179: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
180: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
181: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
182: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
183: call_contracts VARCHAR2(1) := FND_API.G_TRUE, -- Bug 12390649
184: object_version_number NUMBER := FND_API.G_MISS_NUM
185: );
186:
187: TYPE txn_ip_accounts_tbl IS TABLE OF txn_ip_account_rec INDEX BY BINARY_INTEGER;
180: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
181: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
182: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
183: call_contracts VARCHAR2(1) := FND_API.G_TRUE, -- Bug 12390649
184: object_version_number NUMBER := FND_API.G_MISS_NUM
185: );
186:
187: TYPE txn_ip_accounts_tbl IS TABLE OF txn_ip_account_rec INDEX BY BINARY_INTEGER;
188:
189: -- Name : txn_ii_relationship_rec
190: -- Description : record to hold the attributes of an item instance relationship.
191:
192: TYPE txn_ii_relationship_rec IS RECORD (
193: RELATIONSHIP_ID NUMBER := FND_API.G_MISS_NUM,
194: RELATIONSHIP_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
195: OBJECT_INDEX NUMBER := FND_API.G_MISS_NUM,
196: OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
197: SUBJECT_INDEX NUMBER := FND_API.G_MISS_NUM,
190: -- Description : record to hold the attributes of an item instance relationship.
191:
192: TYPE txn_ii_relationship_rec IS RECORD (
193: RELATIONSHIP_ID NUMBER := FND_API.G_MISS_NUM,
194: RELATIONSHIP_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
195: OBJECT_INDEX NUMBER := FND_API.G_MISS_NUM,
196: OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
197: SUBJECT_INDEX NUMBER := FND_API.G_MISS_NUM,
198: SUBJECT_ID NUMBER := FND_API.G_MISS_NUM,
191:
192: TYPE txn_ii_relationship_rec IS RECORD (
193: RELATIONSHIP_ID NUMBER := FND_API.G_MISS_NUM,
194: RELATIONSHIP_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
195: OBJECT_INDEX NUMBER := FND_API.G_MISS_NUM,
196: OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
197: SUBJECT_INDEX NUMBER := FND_API.G_MISS_NUM,
198: SUBJECT_ID NUMBER := FND_API.G_MISS_NUM,
199: SUBJECT_HAS_CHILD VARCHAR2(1) := FND_API.G_MISS_CHAR,
192: TYPE txn_ii_relationship_rec IS RECORD (
193: RELATIONSHIP_ID NUMBER := FND_API.G_MISS_NUM,
194: RELATIONSHIP_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
195: OBJECT_INDEX NUMBER := FND_API.G_MISS_NUM,
196: OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
197: SUBJECT_INDEX NUMBER := FND_API.G_MISS_NUM,
198: SUBJECT_ID NUMBER := FND_API.G_MISS_NUM,
199: SUBJECT_HAS_CHILD VARCHAR2(1) := FND_API.G_MISS_CHAR,
200: POSITION_REFERENCE VARCHAR2(30) := FND_API.G_MISS_CHAR,
193: RELATIONSHIP_ID NUMBER := FND_API.G_MISS_NUM,
194: RELATIONSHIP_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
195: OBJECT_INDEX NUMBER := FND_API.G_MISS_NUM,
196: OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
197: SUBJECT_INDEX NUMBER := FND_API.G_MISS_NUM,
198: SUBJECT_ID NUMBER := FND_API.G_MISS_NUM,
199: SUBJECT_HAS_CHILD VARCHAR2(1) := FND_API.G_MISS_CHAR,
200: POSITION_REFERENCE VARCHAR2(30) := FND_API.G_MISS_CHAR,
201: ACTIVE_START_DATE DATE := FND_API.G_MISS_DATE,
194: RELATIONSHIP_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
195: OBJECT_INDEX NUMBER := FND_API.G_MISS_NUM,
196: OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
197: SUBJECT_INDEX NUMBER := FND_API.G_MISS_NUM,
198: SUBJECT_ID NUMBER := FND_API.G_MISS_NUM,
199: SUBJECT_HAS_CHILD VARCHAR2(1) := FND_API.G_MISS_CHAR,
200: POSITION_REFERENCE VARCHAR2(30) := FND_API.G_MISS_CHAR,
201: ACTIVE_START_DATE DATE := FND_API.G_MISS_DATE,
202: ACTIVE_END_DATE DATE := FND_API.G_MISS_DATE,
195: OBJECT_INDEX NUMBER := FND_API.G_MISS_NUM,
196: OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
197: SUBJECT_INDEX NUMBER := FND_API.G_MISS_NUM,
198: SUBJECT_ID NUMBER := FND_API.G_MISS_NUM,
199: SUBJECT_HAS_CHILD VARCHAR2(1) := FND_API.G_MISS_CHAR,
200: POSITION_REFERENCE VARCHAR2(30) := FND_API.G_MISS_CHAR,
201: ACTIVE_START_DATE DATE := FND_API.G_MISS_DATE,
202: ACTIVE_END_DATE DATE := FND_API.G_MISS_DATE,
203: DISPLAY_ORDER NUMBER := FND_API.G_MISS_NUM,
196: OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
197: SUBJECT_INDEX NUMBER := FND_API.G_MISS_NUM,
198: SUBJECT_ID NUMBER := FND_API.G_MISS_NUM,
199: SUBJECT_HAS_CHILD VARCHAR2(1) := FND_API.G_MISS_CHAR,
200: POSITION_REFERENCE VARCHAR2(30) := FND_API.G_MISS_CHAR,
201: ACTIVE_START_DATE DATE := FND_API.G_MISS_DATE,
202: ACTIVE_END_DATE DATE := FND_API.G_MISS_DATE,
203: DISPLAY_ORDER NUMBER := FND_API.G_MISS_NUM,
204: MANDATORY_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
197: SUBJECT_INDEX NUMBER := FND_API.G_MISS_NUM,
198: SUBJECT_ID NUMBER := FND_API.G_MISS_NUM,
199: SUBJECT_HAS_CHILD VARCHAR2(1) := FND_API.G_MISS_CHAR,
200: POSITION_REFERENCE VARCHAR2(30) := FND_API.G_MISS_CHAR,
201: ACTIVE_START_DATE DATE := FND_API.G_MISS_DATE,
202: ACTIVE_END_DATE DATE := FND_API.G_MISS_DATE,
203: DISPLAY_ORDER NUMBER := FND_API.G_MISS_NUM,
204: MANDATORY_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
205: CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
198: SUBJECT_ID NUMBER := FND_API.G_MISS_NUM,
199: SUBJECT_HAS_CHILD VARCHAR2(1) := FND_API.G_MISS_CHAR,
200: POSITION_REFERENCE VARCHAR2(30) := FND_API.G_MISS_CHAR,
201: ACTIVE_START_DATE DATE := FND_API.G_MISS_DATE,
202: ACTIVE_END_DATE DATE := FND_API.G_MISS_DATE,
203: DISPLAY_ORDER NUMBER := FND_API.G_MISS_NUM,
204: MANDATORY_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
205: CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
206: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
199: SUBJECT_HAS_CHILD VARCHAR2(1) := FND_API.G_MISS_CHAR,
200: POSITION_REFERENCE VARCHAR2(30) := FND_API.G_MISS_CHAR,
201: ACTIVE_START_DATE DATE := FND_API.G_MISS_DATE,
202: ACTIVE_END_DATE DATE := FND_API.G_MISS_DATE,
203: DISPLAY_ORDER NUMBER := FND_API.G_MISS_NUM,
204: MANDATORY_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
205: CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
206: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
207: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
200: POSITION_REFERENCE VARCHAR2(30) := FND_API.G_MISS_CHAR,
201: ACTIVE_START_DATE DATE := FND_API.G_MISS_DATE,
202: ACTIVE_END_DATE DATE := FND_API.G_MISS_DATE,
203: DISPLAY_ORDER NUMBER := FND_API.G_MISS_NUM,
204: MANDATORY_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
205: CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
206: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
207: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
208: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
201: ACTIVE_START_DATE DATE := FND_API.G_MISS_DATE,
202: ACTIVE_END_DATE DATE := FND_API.G_MISS_DATE,
203: DISPLAY_ORDER NUMBER := FND_API.G_MISS_NUM,
204: MANDATORY_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
205: CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
206: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
207: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
208: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
209: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
202: ACTIVE_END_DATE DATE := FND_API.G_MISS_DATE,
203: DISPLAY_ORDER NUMBER := FND_API.G_MISS_NUM,
204: MANDATORY_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
205: CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
206: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
207: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
208: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
209: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
210: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
203: DISPLAY_ORDER NUMBER := FND_API.G_MISS_NUM,
204: MANDATORY_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
205: CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
206: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
207: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
208: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
209: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
210: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
211: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
204: MANDATORY_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
205: CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
206: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
207: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
208: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
209: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
210: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
211: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
212: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
205: CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
206: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
207: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
208: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
209: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
210: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
211: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
212: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
213: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
206: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
207: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
208: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
209: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
210: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
211: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
212: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
213: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
214: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
207: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
208: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
209: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
210: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
211: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
212: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
213: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
214: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
215: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
208: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
209: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
210: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
211: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
212: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
213: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
214: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
215: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
216: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
209: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
210: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
211: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
212: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
213: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
214: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
215: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
216: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
217: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
210: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
211: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
212: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
213: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
214: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
215: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
216: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
217: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
218: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
211: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
212: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
213: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
214: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
215: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
216: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
217: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
218: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
219: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
212: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
213: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
214: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
215: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
216: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
217: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
218: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
219: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
220: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
213: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
214: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
215: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
216: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
217: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
218: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
219: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
220: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
221: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
214: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
215: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
216: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
217: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
218: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
219: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
220: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
221: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
222: );
215: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
216: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
217: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
218: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
219: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
220: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
221: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
222: );
223:
216: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
217: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
218: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
219: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
220: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
221: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
222: );
223:
224: TYPE txn_ii_relationships_tbl IS TABLE OF txn_ii_relationship_rec INDEX BY BINARY_INTEGER;
217: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
218: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
219: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
220: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
221: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
222: );
223:
224: TYPE txn_ii_relationships_tbl IS TABLE OF txn_ii_relationship_rec INDEX BY BINARY_INTEGER;
225:
226: -- Name : txn_ext_attrib_value_rec
227: -- Description : record to hold the values of an item instances extended attributes.
228:
229: TYPE txn_ext_attrib_value_rec IS RECORD (
230: attribute_value_id NUMBER := FND_API.G_MISS_NUM,
231: parent_tbl_index NUMBER := FND_API.G_MISS_NUM,
232: instance_id NUMBER := FND_API.G_MISS_NUM,
233: attribute_id NUMBER := FND_API.G_MISS_NUM,
234: attribute_code VARCHAR2(30) := fnd_api.g_miss_char ,
227: -- Description : record to hold the values of an item instances extended attributes.
228:
229: TYPE txn_ext_attrib_value_rec IS RECORD (
230: attribute_value_id NUMBER := FND_API.G_MISS_NUM,
231: parent_tbl_index NUMBER := FND_API.G_MISS_NUM,
232: instance_id NUMBER := FND_API.G_MISS_NUM,
233: attribute_id NUMBER := FND_API.G_MISS_NUM,
234: attribute_code VARCHAR2(30) := fnd_api.g_miss_char ,
235: attribute_value VARCHAR2(240) := FND_API.G_MISS_CHAR,
228:
229: TYPE txn_ext_attrib_value_rec IS RECORD (
230: attribute_value_id NUMBER := FND_API.G_MISS_NUM,
231: parent_tbl_index NUMBER := FND_API.G_MISS_NUM,
232: instance_id NUMBER := FND_API.G_MISS_NUM,
233: attribute_id NUMBER := FND_API.G_MISS_NUM,
234: attribute_code VARCHAR2(30) := fnd_api.g_miss_char ,
235: attribute_value VARCHAR2(240) := FND_API.G_MISS_CHAR,
236: active_start_date DATE := FND_API.G_MISS_DATE,
229: TYPE txn_ext_attrib_value_rec IS RECORD (
230: attribute_value_id NUMBER := FND_API.G_MISS_NUM,
231: parent_tbl_index NUMBER := FND_API.G_MISS_NUM,
232: instance_id NUMBER := FND_API.G_MISS_NUM,
233: attribute_id NUMBER := FND_API.G_MISS_NUM,
234: attribute_code VARCHAR2(30) := fnd_api.g_miss_char ,
235: attribute_value VARCHAR2(240) := FND_API.G_MISS_CHAR,
236: active_start_date DATE := FND_API.G_MISS_DATE,
237: active_end_date DATE := FND_API.G_MISS_DATE,
230: attribute_value_id NUMBER := FND_API.G_MISS_NUM,
231: parent_tbl_index NUMBER := FND_API.G_MISS_NUM,
232: instance_id NUMBER := FND_API.G_MISS_NUM,
233: attribute_id NUMBER := FND_API.G_MISS_NUM,
234: attribute_code VARCHAR2(30) := fnd_api.g_miss_char ,
235: attribute_value VARCHAR2(240) := FND_API.G_MISS_CHAR,
236: active_start_date DATE := FND_API.G_MISS_DATE,
237: active_end_date DATE := FND_API.G_MISS_DATE,
238: context VARCHAR2(30) := FND_API.G_MISS_CHAR,
231: parent_tbl_index NUMBER := FND_API.G_MISS_NUM,
232: instance_id NUMBER := FND_API.G_MISS_NUM,
233: attribute_id NUMBER := FND_API.G_MISS_NUM,
234: attribute_code VARCHAR2(30) := fnd_api.g_miss_char ,
235: attribute_value VARCHAR2(240) := FND_API.G_MISS_CHAR,
236: active_start_date DATE := FND_API.G_MISS_DATE,
237: active_end_date DATE := FND_API.G_MISS_DATE,
238: context VARCHAR2(30) := FND_API.G_MISS_CHAR,
239: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
232: instance_id NUMBER := FND_API.G_MISS_NUM,
233: attribute_id NUMBER := FND_API.G_MISS_NUM,
234: attribute_code VARCHAR2(30) := fnd_api.g_miss_char ,
235: attribute_value VARCHAR2(240) := FND_API.G_MISS_CHAR,
236: active_start_date DATE := FND_API.G_MISS_DATE,
237: active_end_date DATE := FND_API.G_MISS_DATE,
238: context VARCHAR2(30) := FND_API.G_MISS_CHAR,
239: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
240: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
233: attribute_id NUMBER := FND_API.G_MISS_NUM,
234: attribute_code VARCHAR2(30) := fnd_api.g_miss_char ,
235: attribute_value VARCHAR2(240) := FND_API.G_MISS_CHAR,
236: active_start_date DATE := FND_API.G_MISS_DATE,
237: active_end_date DATE := FND_API.G_MISS_DATE,
238: context VARCHAR2(30) := FND_API.G_MISS_CHAR,
239: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
240: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
241: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
234: attribute_code VARCHAR2(30) := fnd_api.g_miss_char ,
235: attribute_value VARCHAR2(240) := FND_API.G_MISS_CHAR,
236: active_start_date DATE := FND_API.G_MISS_DATE,
237: active_end_date DATE := FND_API.G_MISS_DATE,
238: context VARCHAR2(30) := FND_API.G_MISS_CHAR,
239: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
240: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
241: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
242: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
235: attribute_value VARCHAR2(240) := FND_API.G_MISS_CHAR,
236: active_start_date DATE := FND_API.G_MISS_DATE,
237: active_end_date DATE := FND_API.G_MISS_DATE,
238: context VARCHAR2(30) := FND_API.G_MISS_CHAR,
239: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
240: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
241: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
242: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
243: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
236: active_start_date DATE := FND_API.G_MISS_DATE,
237: active_end_date DATE := FND_API.G_MISS_DATE,
238: context VARCHAR2(30) := FND_API.G_MISS_CHAR,
239: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
240: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
241: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
242: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
243: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
244: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
237: active_end_date DATE := FND_API.G_MISS_DATE,
238: context VARCHAR2(30) := FND_API.G_MISS_CHAR,
239: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
240: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
241: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
242: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
243: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
244: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
245: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
238: context VARCHAR2(30) := FND_API.G_MISS_CHAR,
239: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
240: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
241: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
242: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
243: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
244: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
245: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
246: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
239: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
240: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
241: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
242: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
243: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
244: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
245: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
246: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
247: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
240: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
241: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
242: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
243: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
244: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
245: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
246: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
247: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
248: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
241: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
242: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
243: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
244: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
245: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
246: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
247: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
248: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
249: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
242: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
243: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
244: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
245: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
246: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
247: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
248: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
249: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
250: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
243: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
244: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
245: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
246: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
247: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
248: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
249: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
250: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
251: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
244: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
245: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
246: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
247: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
248: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
249: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
250: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
251: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
252: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
245: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
246: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
247: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
248: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
249: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
250: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
251: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
252: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
253: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
246: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
247: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
248: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
249: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
250: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
251: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
252: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
253: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
254: object_version_number NUMBER := FND_API.G_MISS_NUM
247: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
248: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
249: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
250: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
251: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
252: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
253: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
254: object_version_number NUMBER := FND_API.G_MISS_NUM
255: );
248: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
249: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
250: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
251: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
252: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
253: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
254: object_version_number NUMBER := FND_API.G_MISS_NUM
255: );
256:
249: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
250: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
251: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
252: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
253: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
254: object_version_number NUMBER := FND_API.G_MISS_NUM
255: );
256:
257:
250: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
251: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
252: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
253: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
254: object_version_number NUMBER := FND_API.G_MISS_NUM
255: );
256:
257:
258: TYPE txn_ext_attrib_values_tbl IS table of txn_ext_attrib_value_rec INDEX BY BINARY_INTEGER;
261: -- Description : record to hold the pricing attributes of an item instance.
262:
263:
264: TYPE txn_pricing_attrib_rec IS RECORD (
265: pricing_attribute_id NUMBER := FND_API.G_MISS_NUM,
266: parent_tbl_index NUMBER := FND_API.G_MISS_NUM,
267: instance_id NUMBER := FND_API.G_MISS_NUM,
268: active_start_date DATE := FND_API.G_MISS_DATE,
269: active_end_date DATE := FND_API.G_MISS_DATE,
262:
263:
264: TYPE txn_pricing_attrib_rec IS RECORD (
265: pricing_attribute_id NUMBER := FND_API.G_MISS_NUM,
266: parent_tbl_index NUMBER := FND_API.G_MISS_NUM,
267: instance_id NUMBER := FND_API.G_MISS_NUM,
268: active_start_date DATE := FND_API.G_MISS_DATE,
269: active_end_date DATE := FND_API.G_MISS_DATE,
270: pricing_context VARCHAR2(30) := FND_API.G_MISS_CHAR,
263:
264: TYPE txn_pricing_attrib_rec IS RECORD (
265: pricing_attribute_id NUMBER := FND_API.G_MISS_NUM,
266: parent_tbl_index NUMBER := FND_API.G_MISS_NUM,
267: instance_id NUMBER := FND_API.G_MISS_NUM,
268: active_start_date DATE := FND_API.G_MISS_DATE,
269: active_end_date DATE := FND_API.G_MISS_DATE,
270: pricing_context VARCHAR2(30) := FND_API.G_MISS_CHAR,
271: pricing_attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
264: TYPE txn_pricing_attrib_rec IS RECORD (
265: pricing_attribute_id NUMBER := FND_API.G_MISS_NUM,
266: parent_tbl_index NUMBER := FND_API.G_MISS_NUM,
267: instance_id NUMBER := FND_API.G_MISS_NUM,
268: active_start_date DATE := FND_API.G_MISS_DATE,
269: active_end_date DATE := FND_API.G_MISS_DATE,
270: pricing_context VARCHAR2(30) := FND_API.G_MISS_CHAR,
271: pricing_attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
272: pricing_attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
265: pricing_attribute_id NUMBER := FND_API.G_MISS_NUM,
266: parent_tbl_index NUMBER := FND_API.G_MISS_NUM,
267: instance_id NUMBER := FND_API.G_MISS_NUM,
268: active_start_date DATE := FND_API.G_MISS_DATE,
269: active_end_date DATE := FND_API.G_MISS_DATE,
270: pricing_context VARCHAR2(30) := FND_API.G_MISS_CHAR,
271: pricing_attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
272: pricing_attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
273: pricing_attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
266: parent_tbl_index NUMBER := FND_API.G_MISS_NUM,
267: instance_id NUMBER := FND_API.G_MISS_NUM,
268: active_start_date DATE := FND_API.G_MISS_DATE,
269: active_end_date DATE := FND_API.G_MISS_DATE,
270: pricing_context VARCHAR2(30) := FND_API.G_MISS_CHAR,
271: pricing_attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
272: pricing_attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
273: pricing_attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
274: pricing_attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
267: instance_id NUMBER := FND_API.G_MISS_NUM,
268: active_start_date DATE := FND_API.G_MISS_DATE,
269: active_end_date DATE := FND_API.G_MISS_DATE,
270: pricing_context VARCHAR2(30) := FND_API.G_MISS_CHAR,
271: pricing_attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
272: pricing_attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
273: pricing_attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
274: pricing_attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
275: pricing_attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
268: active_start_date DATE := FND_API.G_MISS_DATE,
269: active_end_date DATE := FND_API.G_MISS_DATE,
270: pricing_context VARCHAR2(30) := FND_API.G_MISS_CHAR,
271: pricing_attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
272: pricing_attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
273: pricing_attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
274: pricing_attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
275: pricing_attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
276: pricing_attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
269: active_end_date DATE := FND_API.G_MISS_DATE,
270: pricing_context VARCHAR2(30) := FND_API.G_MISS_CHAR,
271: pricing_attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
272: pricing_attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
273: pricing_attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
274: pricing_attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
275: pricing_attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
276: pricing_attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
277: pricing_attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
270: pricing_context VARCHAR2(30) := FND_API.G_MISS_CHAR,
271: pricing_attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
272: pricing_attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
273: pricing_attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
274: pricing_attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
275: pricing_attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
276: pricing_attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
277: pricing_attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
278: pricing_attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
271: pricing_attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
272: pricing_attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
273: pricing_attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
274: pricing_attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
275: pricing_attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
276: pricing_attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
277: pricing_attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
278: pricing_attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
279: pricing_attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
272: pricing_attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
273: pricing_attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
274: pricing_attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
275: pricing_attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
276: pricing_attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
277: pricing_attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
278: pricing_attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
279: pricing_attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
280: pricing_attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
273: pricing_attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
274: pricing_attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
275: pricing_attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
276: pricing_attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
277: pricing_attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
278: pricing_attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
279: pricing_attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
280: pricing_attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
281: pricing_attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
274: pricing_attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
275: pricing_attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
276: pricing_attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
277: pricing_attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
278: pricing_attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
279: pricing_attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
280: pricing_attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
281: pricing_attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
282: pricing_attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
275: pricing_attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
276: pricing_attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
277: pricing_attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
278: pricing_attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
279: pricing_attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
280: pricing_attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
281: pricing_attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
282: pricing_attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
283: pricing_attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
276: pricing_attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
277: pricing_attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
278: pricing_attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
279: pricing_attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
280: pricing_attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
281: pricing_attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
282: pricing_attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
283: pricing_attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
284: pricing_attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
277: pricing_attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
278: pricing_attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
279: pricing_attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
280: pricing_attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
281: pricing_attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
282: pricing_attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
283: pricing_attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
284: pricing_attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
285: pricing_attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
278: pricing_attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
279: pricing_attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
280: pricing_attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
281: pricing_attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
282: pricing_attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
283: pricing_attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
284: pricing_attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
285: pricing_attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
286: pricing_attribute16 VARCHAR2(150) := FND_API.G_MISS_CHAR,
279: pricing_attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
280: pricing_attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
281: pricing_attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
282: pricing_attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
283: pricing_attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
284: pricing_attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
285: pricing_attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
286: pricing_attribute16 VARCHAR2(150) := FND_API.G_MISS_CHAR,
287: pricing_attribute17 VARCHAR2(150) := FND_API.G_MISS_CHAR,
280: pricing_attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
281: pricing_attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
282: pricing_attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
283: pricing_attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
284: pricing_attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
285: pricing_attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
286: pricing_attribute16 VARCHAR2(150) := FND_API.G_MISS_CHAR,
287: pricing_attribute17 VARCHAR2(150) := FND_API.G_MISS_CHAR,
288: pricing_attribute18 VARCHAR2(150) := FND_API.G_MISS_CHAR,
281: pricing_attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
282: pricing_attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
283: pricing_attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
284: pricing_attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
285: pricing_attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
286: pricing_attribute16 VARCHAR2(150) := FND_API.G_MISS_CHAR,
287: pricing_attribute17 VARCHAR2(150) := FND_API.G_MISS_CHAR,
288: pricing_attribute18 VARCHAR2(150) := FND_API.G_MISS_CHAR,
289: pricing_attribute19 VARCHAR2(150) := FND_API.G_MISS_CHAR,
282: pricing_attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
283: pricing_attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
284: pricing_attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
285: pricing_attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
286: pricing_attribute16 VARCHAR2(150) := FND_API.G_MISS_CHAR,
287: pricing_attribute17 VARCHAR2(150) := FND_API.G_MISS_CHAR,
288: pricing_attribute18 VARCHAR2(150) := FND_API.G_MISS_CHAR,
289: pricing_attribute19 VARCHAR2(150) := FND_API.G_MISS_CHAR,
290: pricing_attribute20 VARCHAR2(150) := FND_API.G_MISS_CHAR,
283: pricing_attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
284: pricing_attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
285: pricing_attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
286: pricing_attribute16 VARCHAR2(150) := FND_API.G_MISS_CHAR,
287: pricing_attribute17 VARCHAR2(150) := FND_API.G_MISS_CHAR,
288: pricing_attribute18 VARCHAR2(150) := FND_API.G_MISS_CHAR,
289: pricing_attribute19 VARCHAR2(150) := FND_API.G_MISS_CHAR,
290: pricing_attribute20 VARCHAR2(150) := FND_API.G_MISS_CHAR,
291: pricing_attribute21 VARCHAR2(150) := FND_API.G_MISS_CHAR,
284: pricing_attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
285: pricing_attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
286: pricing_attribute16 VARCHAR2(150) := FND_API.G_MISS_CHAR,
287: pricing_attribute17 VARCHAR2(150) := FND_API.G_MISS_CHAR,
288: pricing_attribute18 VARCHAR2(150) := FND_API.G_MISS_CHAR,
289: pricing_attribute19 VARCHAR2(150) := FND_API.G_MISS_CHAR,
290: pricing_attribute20 VARCHAR2(150) := FND_API.G_MISS_CHAR,
291: pricing_attribute21 VARCHAR2(150) := FND_API.G_MISS_CHAR,
292: pricing_attribute22 VARCHAR2(150) := FND_API.G_MISS_CHAR,
285: pricing_attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
286: pricing_attribute16 VARCHAR2(150) := FND_API.G_MISS_CHAR,
287: pricing_attribute17 VARCHAR2(150) := FND_API.G_MISS_CHAR,
288: pricing_attribute18 VARCHAR2(150) := FND_API.G_MISS_CHAR,
289: pricing_attribute19 VARCHAR2(150) := FND_API.G_MISS_CHAR,
290: pricing_attribute20 VARCHAR2(150) := FND_API.G_MISS_CHAR,
291: pricing_attribute21 VARCHAR2(150) := FND_API.G_MISS_CHAR,
292: pricing_attribute22 VARCHAR2(150) := FND_API.G_MISS_CHAR,
293: pricing_attribute23 VARCHAR2(150) := FND_API.G_MISS_CHAR,
286: pricing_attribute16 VARCHAR2(150) := FND_API.G_MISS_CHAR,
287: pricing_attribute17 VARCHAR2(150) := FND_API.G_MISS_CHAR,
288: pricing_attribute18 VARCHAR2(150) := FND_API.G_MISS_CHAR,
289: pricing_attribute19 VARCHAR2(150) := FND_API.G_MISS_CHAR,
290: pricing_attribute20 VARCHAR2(150) := FND_API.G_MISS_CHAR,
291: pricing_attribute21 VARCHAR2(150) := FND_API.G_MISS_CHAR,
292: pricing_attribute22 VARCHAR2(150) := FND_API.G_MISS_CHAR,
293: pricing_attribute23 VARCHAR2(150) := FND_API.G_MISS_CHAR,
294: pricing_attribute24 VARCHAR2(150) := FND_API.G_MISS_CHAR,
287: pricing_attribute17 VARCHAR2(150) := FND_API.G_MISS_CHAR,
288: pricing_attribute18 VARCHAR2(150) := FND_API.G_MISS_CHAR,
289: pricing_attribute19 VARCHAR2(150) := FND_API.G_MISS_CHAR,
290: pricing_attribute20 VARCHAR2(150) := FND_API.G_MISS_CHAR,
291: pricing_attribute21 VARCHAR2(150) := FND_API.G_MISS_CHAR,
292: pricing_attribute22 VARCHAR2(150) := FND_API.G_MISS_CHAR,
293: pricing_attribute23 VARCHAR2(150) := FND_API.G_MISS_CHAR,
294: pricing_attribute24 VARCHAR2(150) := FND_API.G_MISS_CHAR,
295: pricing_attribute25 VARCHAR2(150) := FND_API.G_MISS_CHAR,
288: pricing_attribute18 VARCHAR2(150) := FND_API.G_MISS_CHAR,
289: pricing_attribute19 VARCHAR2(150) := FND_API.G_MISS_CHAR,
290: pricing_attribute20 VARCHAR2(150) := FND_API.G_MISS_CHAR,
291: pricing_attribute21 VARCHAR2(150) := FND_API.G_MISS_CHAR,
292: pricing_attribute22 VARCHAR2(150) := FND_API.G_MISS_CHAR,
293: pricing_attribute23 VARCHAR2(150) := FND_API.G_MISS_CHAR,
294: pricing_attribute24 VARCHAR2(150) := FND_API.G_MISS_CHAR,
295: pricing_attribute25 VARCHAR2(150) := FND_API.G_MISS_CHAR,
296: pricing_attribute26 VARCHAR2(150) := FND_API.G_MISS_CHAR,
289: pricing_attribute19 VARCHAR2(150) := FND_API.G_MISS_CHAR,
290: pricing_attribute20 VARCHAR2(150) := FND_API.G_MISS_CHAR,
291: pricing_attribute21 VARCHAR2(150) := FND_API.G_MISS_CHAR,
292: pricing_attribute22 VARCHAR2(150) := FND_API.G_MISS_CHAR,
293: pricing_attribute23 VARCHAR2(150) := FND_API.G_MISS_CHAR,
294: pricing_attribute24 VARCHAR2(150) := FND_API.G_MISS_CHAR,
295: pricing_attribute25 VARCHAR2(150) := FND_API.G_MISS_CHAR,
296: pricing_attribute26 VARCHAR2(150) := FND_API.G_MISS_CHAR,
297: pricing_attribute27 VARCHAR2(150) := FND_API.G_MISS_CHAR,
290: pricing_attribute20 VARCHAR2(150) := FND_API.G_MISS_CHAR,
291: pricing_attribute21 VARCHAR2(150) := FND_API.G_MISS_CHAR,
292: pricing_attribute22 VARCHAR2(150) := FND_API.G_MISS_CHAR,
293: pricing_attribute23 VARCHAR2(150) := FND_API.G_MISS_CHAR,
294: pricing_attribute24 VARCHAR2(150) := FND_API.G_MISS_CHAR,
295: pricing_attribute25 VARCHAR2(150) := FND_API.G_MISS_CHAR,
296: pricing_attribute26 VARCHAR2(150) := FND_API.G_MISS_CHAR,
297: pricing_attribute27 VARCHAR2(150) := FND_API.G_MISS_CHAR,
298: pricing_attribute28 VARCHAR2(150) := FND_API.G_MISS_CHAR,
291: pricing_attribute21 VARCHAR2(150) := FND_API.G_MISS_CHAR,
292: pricing_attribute22 VARCHAR2(150) := FND_API.G_MISS_CHAR,
293: pricing_attribute23 VARCHAR2(150) := FND_API.G_MISS_CHAR,
294: pricing_attribute24 VARCHAR2(150) := FND_API.G_MISS_CHAR,
295: pricing_attribute25 VARCHAR2(150) := FND_API.G_MISS_CHAR,
296: pricing_attribute26 VARCHAR2(150) := FND_API.G_MISS_CHAR,
297: pricing_attribute27 VARCHAR2(150) := FND_API.G_MISS_CHAR,
298: pricing_attribute28 VARCHAR2(150) := FND_API.G_MISS_CHAR,
299: pricing_attribute29 VARCHAR2(150) := FND_API.G_MISS_CHAR,
292: pricing_attribute22 VARCHAR2(150) := FND_API.G_MISS_CHAR,
293: pricing_attribute23 VARCHAR2(150) := FND_API.G_MISS_CHAR,
294: pricing_attribute24 VARCHAR2(150) := FND_API.G_MISS_CHAR,
295: pricing_attribute25 VARCHAR2(150) := FND_API.G_MISS_CHAR,
296: pricing_attribute26 VARCHAR2(150) := FND_API.G_MISS_CHAR,
297: pricing_attribute27 VARCHAR2(150) := FND_API.G_MISS_CHAR,
298: pricing_attribute28 VARCHAR2(150) := FND_API.G_MISS_CHAR,
299: pricing_attribute29 VARCHAR2(150) := FND_API.G_MISS_CHAR,
300: pricing_attribute30 VARCHAR2(150) := FND_API.G_MISS_CHAR,
293: pricing_attribute23 VARCHAR2(150) := FND_API.G_MISS_CHAR,
294: pricing_attribute24 VARCHAR2(150) := FND_API.G_MISS_CHAR,
295: pricing_attribute25 VARCHAR2(150) := FND_API.G_MISS_CHAR,
296: pricing_attribute26 VARCHAR2(150) := FND_API.G_MISS_CHAR,
297: pricing_attribute27 VARCHAR2(150) := FND_API.G_MISS_CHAR,
298: pricing_attribute28 VARCHAR2(150) := FND_API.G_MISS_CHAR,
299: pricing_attribute29 VARCHAR2(150) := FND_API.G_MISS_CHAR,
300: pricing_attribute30 VARCHAR2(150) := FND_API.G_MISS_CHAR,
301: pricing_attribute31 VARCHAR2(150) := FND_API.G_MISS_CHAR,
294: pricing_attribute24 VARCHAR2(150) := FND_API.G_MISS_CHAR,
295: pricing_attribute25 VARCHAR2(150) := FND_API.G_MISS_CHAR,
296: pricing_attribute26 VARCHAR2(150) := FND_API.G_MISS_CHAR,
297: pricing_attribute27 VARCHAR2(150) := FND_API.G_MISS_CHAR,
298: pricing_attribute28 VARCHAR2(150) := FND_API.G_MISS_CHAR,
299: pricing_attribute29 VARCHAR2(150) := FND_API.G_MISS_CHAR,
300: pricing_attribute30 VARCHAR2(150) := FND_API.G_MISS_CHAR,
301: pricing_attribute31 VARCHAR2(150) := FND_API.G_MISS_CHAR,
302: pricing_attribute32 VARCHAR2(150) := FND_API.G_MISS_CHAR,
295: pricing_attribute25 VARCHAR2(150) := FND_API.G_MISS_CHAR,
296: pricing_attribute26 VARCHAR2(150) := FND_API.G_MISS_CHAR,
297: pricing_attribute27 VARCHAR2(150) := FND_API.G_MISS_CHAR,
298: pricing_attribute28 VARCHAR2(150) := FND_API.G_MISS_CHAR,
299: pricing_attribute29 VARCHAR2(150) := FND_API.G_MISS_CHAR,
300: pricing_attribute30 VARCHAR2(150) := FND_API.G_MISS_CHAR,
301: pricing_attribute31 VARCHAR2(150) := FND_API.G_MISS_CHAR,
302: pricing_attribute32 VARCHAR2(150) := FND_API.G_MISS_CHAR,
303: pricing_attribute33 VARCHAR2(150) := FND_API.G_MISS_CHAR,
296: pricing_attribute26 VARCHAR2(150) := FND_API.G_MISS_CHAR,
297: pricing_attribute27 VARCHAR2(150) := FND_API.G_MISS_CHAR,
298: pricing_attribute28 VARCHAR2(150) := FND_API.G_MISS_CHAR,
299: pricing_attribute29 VARCHAR2(150) := FND_API.G_MISS_CHAR,
300: pricing_attribute30 VARCHAR2(150) := FND_API.G_MISS_CHAR,
301: pricing_attribute31 VARCHAR2(150) := FND_API.G_MISS_CHAR,
302: pricing_attribute32 VARCHAR2(150) := FND_API.G_MISS_CHAR,
303: pricing_attribute33 VARCHAR2(150) := FND_API.G_MISS_CHAR,
304: pricing_attribute34 VARCHAR2(150) := FND_API.G_MISS_CHAR,
297: pricing_attribute27 VARCHAR2(150) := FND_API.G_MISS_CHAR,
298: pricing_attribute28 VARCHAR2(150) := FND_API.G_MISS_CHAR,
299: pricing_attribute29 VARCHAR2(150) := FND_API.G_MISS_CHAR,
300: pricing_attribute30 VARCHAR2(150) := FND_API.G_MISS_CHAR,
301: pricing_attribute31 VARCHAR2(150) := FND_API.G_MISS_CHAR,
302: pricing_attribute32 VARCHAR2(150) := FND_API.G_MISS_CHAR,
303: pricing_attribute33 VARCHAR2(150) := FND_API.G_MISS_CHAR,
304: pricing_attribute34 VARCHAR2(150) := FND_API.G_MISS_CHAR,
305: pricing_attribute35 VARCHAR2(150) := FND_API.G_MISS_CHAR,
298: pricing_attribute28 VARCHAR2(150) := FND_API.G_MISS_CHAR,
299: pricing_attribute29 VARCHAR2(150) := FND_API.G_MISS_CHAR,
300: pricing_attribute30 VARCHAR2(150) := FND_API.G_MISS_CHAR,
301: pricing_attribute31 VARCHAR2(150) := FND_API.G_MISS_CHAR,
302: pricing_attribute32 VARCHAR2(150) := FND_API.G_MISS_CHAR,
303: pricing_attribute33 VARCHAR2(150) := FND_API.G_MISS_CHAR,
304: pricing_attribute34 VARCHAR2(150) := FND_API.G_MISS_CHAR,
305: pricing_attribute35 VARCHAR2(150) := FND_API.G_MISS_CHAR,
306: pricing_attribute36 VARCHAR2(150) := FND_API.G_MISS_CHAR,
299: pricing_attribute29 VARCHAR2(150) := FND_API.G_MISS_CHAR,
300: pricing_attribute30 VARCHAR2(150) := FND_API.G_MISS_CHAR,
301: pricing_attribute31 VARCHAR2(150) := FND_API.G_MISS_CHAR,
302: pricing_attribute32 VARCHAR2(150) := FND_API.G_MISS_CHAR,
303: pricing_attribute33 VARCHAR2(150) := FND_API.G_MISS_CHAR,
304: pricing_attribute34 VARCHAR2(150) := FND_API.G_MISS_CHAR,
305: pricing_attribute35 VARCHAR2(150) := FND_API.G_MISS_CHAR,
306: pricing_attribute36 VARCHAR2(150) := FND_API.G_MISS_CHAR,
307: pricing_attribute37 VARCHAR2(150) := FND_API.G_MISS_CHAR,
300: pricing_attribute30 VARCHAR2(150) := FND_API.G_MISS_CHAR,
301: pricing_attribute31 VARCHAR2(150) := FND_API.G_MISS_CHAR,
302: pricing_attribute32 VARCHAR2(150) := FND_API.G_MISS_CHAR,
303: pricing_attribute33 VARCHAR2(150) := FND_API.G_MISS_CHAR,
304: pricing_attribute34 VARCHAR2(150) := FND_API.G_MISS_CHAR,
305: pricing_attribute35 VARCHAR2(150) := FND_API.G_MISS_CHAR,
306: pricing_attribute36 VARCHAR2(150) := FND_API.G_MISS_CHAR,
307: pricing_attribute37 VARCHAR2(150) := FND_API.G_MISS_CHAR,
308: pricing_attribute38 VARCHAR2(150) := FND_API.G_MISS_CHAR,
301: pricing_attribute31 VARCHAR2(150) := FND_API.G_MISS_CHAR,
302: pricing_attribute32 VARCHAR2(150) := FND_API.G_MISS_CHAR,
303: pricing_attribute33 VARCHAR2(150) := FND_API.G_MISS_CHAR,
304: pricing_attribute34 VARCHAR2(150) := FND_API.G_MISS_CHAR,
305: pricing_attribute35 VARCHAR2(150) := FND_API.G_MISS_CHAR,
306: pricing_attribute36 VARCHAR2(150) := FND_API.G_MISS_CHAR,
307: pricing_attribute37 VARCHAR2(150) := FND_API.G_MISS_CHAR,
308: pricing_attribute38 VARCHAR2(150) := FND_API.G_MISS_CHAR,
309: pricing_attribute39 VARCHAR2(150) := FND_API.G_MISS_CHAR,
302: pricing_attribute32 VARCHAR2(150) := FND_API.G_MISS_CHAR,
303: pricing_attribute33 VARCHAR2(150) := FND_API.G_MISS_CHAR,
304: pricing_attribute34 VARCHAR2(150) := FND_API.G_MISS_CHAR,
305: pricing_attribute35 VARCHAR2(150) := FND_API.G_MISS_CHAR,
306: pricing_attribute36 VARCHAR2(150) := FND_API.G_MISS_CHAR,
307: pricing_attribute37 VARCHAR2(150) := FND_API.G_MISS_CHAR,
308: pricing_attribute38 VARCHAR2(150) := FND_API.G_MISS_CHAR,
309: pricing_attribute39 VARCHAR2(150) := FND_API.G_MISS_CHAR,
310: pricing_attribute40 VARCHAR2(150) := FND_API.G_MISS_CHAR,
303: pricing_attribute33 VARCHAR2(150) := FND_API.G_MISS_CHAR,
304: pricing_attribute34 VARCHAR2(150) := FND_API.G_MISS_CHAR,
305: pricing_attribute35 VARCHAR2(150) := FND_API.G_MISS_CHAR,
306: pricing_attribute36 VARCHAR2(150) := FND_API.G_MISS_CHAR,
307: pricing_attribute37 VARCHAR2(150) := FND_API.G_MISS_CHAR,
308: pricing_attribute38 VARCHAR2(150) := FND_API.G_MISS_CHAR,
309: pricing_attribute39 VARCHAR2(150) := FND_API.G_MISS_CHAR,
310: pricing_attribute40 VARCHAR2(150) := FND_API.G_MISS_CHAR,
311: pricing_attribute41 VARCHAR2(150) := FND_API.G_MISS_CHAR,
304: pricing_attribute34 VARCHAR2(150) := FND_API.G_MISS_CHAR,
305: pricing_attribute35 VARCHAR2(150) := FND_API.G_MISS_CHAR,
306: pricing_attribute36 VARCHAR2(150) := FND_API.G_MISS_CHAR,
307: pricing_attribute37 VARCHAR2(150) := FND_API.G_MISS_CHAR,
308: pricing_attribute38 VARCHAR2(150) := FND_API.G_MISS_CHAR,
309: pricing_attribute39 VARCHAR2(150) := FND_API.G_MISS_CHAR,
310: pricing_attribute40 VARCHAR2(150) := FND_API.G_MISS_CHAR,
311: pricing_attribute41 VARCHAR2(150) := FND_API.G_MISS_CHAR,
312: pricing_attribute42 VARCHAR2(150) := FND_API.G_MISS_CHAR,
305: pricing_attribute35 VARCHAR2(150) := FND_API.G_MISS_CHAR,
306: pricing_attribute36 VARCHAR2(150) := FND_API.G_MISS_CHAR,
307: pricing_attribute37 VARCHAR2(150) := FND_API.G_MISS_CHAR,
308: pricing_attribute38 VARCHAR2(150) := FND_API.G_MISS_CHAR,
309: pricing_attribute39 VARCHAR2(150) := FND_API.G_MISS_CHAR,
310: pricing_attribute40 VARCHAR2(150) := FND_API.G_MISS_CHAR,
311: pricing_attribute41 VARCHAR2(150) := FND_API.G_MISS_CHAR,
312: pricing_attribute42 VARCHAR2(150) := FND_API.G_MISS_CHAR,
313: pricing_attribute43 VARCHAR2(150) := FND_API.G_MISS_CHAR,
306: pricing_attribute36 VARCHAR2(150) := FND_API.G_MISS_CHAR,
307: pricing_attribute37 VARCHAR2(150) := FND_API.G_MISS_CHAR,
308: pricing_attribute38 VARCHAR2(150) := FND_API.G_MISS_CHAR,
309: pricing_attribute39 VARCHAR2(150) := FND_API.G_MISS_CHAR,
310: pricing_attribute40 VARCHAR2(150) := FND_API.G_MISS_CHAR,
311: pricing_attribute41 VARCHAR2(150) := FND_API.G_MISS_CHAR,
312: pricing_attribute42 VARCHAR2(150) := FND_API.G_MISS_CHAR,
313: pricing_attribute43 VARCHAR2(150) := FND_API.G_MISS_CHAR,
314: pricing_attribute44 VARCHAR2(150) := FND_API.G_MISS_CHAR,
307: pricing_attribute37 VARCHAR2(150) := FND_API.G_MISS_CHAR,
308: pricing_attribute38 VARCHAR2(150) := FND_API.G_MISS_CHAR,
309: pricing_attribute39 VARCHAR2(150) := FND_API.G_MISS_CHAR,
310: pricing_attribute40 VARCHAR2(150) := FND_API.G_MISS_CHAR,
311: pricing_attribute41 VARCHAR2(150) := FND_API.G_MISS_CHAR,
312: pricing_attribute42 VARCHAR2(150) := FND_API.G_MISS_CHAR,
313: pricing_attribute43 VARCHAR2(150) := FND_API.G_MISS_CHAR,
314: pricing_attribute44 VARCHAR2(150) := FND_API.G_MISS_CHAR,
315: pricing_attribute45 VARCHAR2(150) := FND_API.G_MISS_CHAR,
308: pricing_attribute38 VARCHAR2(150) := FND_API.G_MISS_CHAR,
309: pricing_attribute39 VARCHAR2(150) := FND_API.G_MISS_CHAR,
310: pricing_attribute40 VARCHAR2(150) := FND_API.G_MISS_CHAR,
311: pricing_attribute41 VARCHAR2(150) := FND_API.G_MISS_CHAR,
312: pricing_attribute42 VARCHAR2(150) := FND_API.G_MISS_CHAR,
313: pricing_attribute43 VARCHAR2(150) := FND_API.G_MISS_CHAR,
314: pricing_attribute44 VARCHAR2(150) := FND_API.G_MISS_CHAR,
315: pricing_attribute45 VARCHAR2(150) := FND_API.G_MISS_CHAR,
316: pricing_attribute46 VARCHAR2(150) := FND_API.G_MISS_CHAR,
309: pricing_attribute39 VARCHAR2(150) := FND_API.G_MISS_CHAR,
310: pricing_attribute40 VARCHAR2(150) := FND_API.G_MISS_CHAR,
311: pricing_attribute41 VARCHAR2(150) := FND_API.G_MISS_CHAR,
312: pricing_attribute42 VARCHAR2(150) := FND_API.G_MISS_CHAR,
313: pricing_attribute43 VARCHAR2(150) := FND_API.G_MISS_CHAR,
314: pricing_attribute44 VARCHAR2(150) := FND_API.G_MISS_CHAR,
315: pricing_attribute45 VARCHAR2(150) := FND_API.G_MISS_CHAR,
316: pricing_attribute46 VARCHAR2(150) := FND_API.G_MISS_CHAR,
317: pricing_attribute47 VARCHAR2(150) := FND_API.G_MISS_CHAR,
310: pricing_attribute40 VARCHAR2(150) := FND_API.G_MISS_CHAR,
311: pricing_attribute41 VARCHAR2(150) := FND_API.G_MISS_CHAR,
312: pricing_attribute42 VARCHAR2(150) := FND_API.G_MISS_CHAR,
313: pricing_attribute43 VARCHAR2(150) := FND_API.G_MISS_CHAR,
314: pricing_attribute44 VARCHAR2(150) := FND_API.G_MISS_CHAR,
315: pricing_attribute45 VARCHAR2(150) := FND_API.G_MISS_CHAR,
316: pricing_attribute46 VARCHAR2(150) := FND_API.G_MISS_CHAR,
317: pricing_attribute47 VARCHAR2(150) := FND_API.G_MISS_CHAR,
318: pricing_attribute48 VARCHAR2(150) := FND_API.G_MISS_CHAR,
311: pricing_attribute41 VARCHAR2(150) := FND_API.G_MISS_CHAR,
312: pricing_attribute42 VARCHAR2(150) := FND_API.G_MISS_CHAR,
313: pricing_attribute43 VARCHAR2(150) := FND_API.G_MISS_CHAR,
314: pricing_attribute44 VARCHAR2(150) := FND_API.G_MISS_CHAR,
315: pricing_attribute45 VARCHAR2(150) := FND_API.G_MISS_CHAR,
316: pricing_attribute46 VARCHAR2(150) := FND_API.G_MISS_CHAR,
317: pricing_attribute47 VARCHAR2(150) := FND_API.G_MISS_CHAR,
318: pricing_attribute48 VARCHAR2(150) := FND_API.G_MISS_CHAR,
319: pricing_attribute49 VARCHAR2(150) := FND_API.G_MISS_CHAR,
312: pricing_attribute42 VARCHAR2(150) := FND_API.G_MISS_CHAR,
313: pricing_attribute43 VARCHAR2(150) := FND_API.G_MISS_CHAR,
314: pricing_attribute44 VARCHAR2(150) := FND_API.G_MISS_CHAR,
315: pricing_attribute45 VARCHAR2(150) := FND_API.G_MISS_CHAR,
316: pricing_attribute46 VARCHAR2(150) := FND_API.G_MISS_CHAR,
317: pricing_attribute47 VARCHAR2(150) := FND_API.G_MISS_CHAR,
318: pricing_attribute48 VARCHAR2(150) := FND_API.G_MISS_CHAR,
319: pricing_attribute49 VARCHAR2(150) := FND_API.G_MISS_CHAR,
320: pricing_attribute50 VARCHAR2(150) := FND_API.G_MISS_CHAR,
313: pricing_attribute43 VARCHAR2(150) := FND_API.G_MISS_CHAR,
314: pricing_attribute44 VARCHAR2(150) := FND_API.G_MISS_CHAR,
315: pricing_attribute45 VARCHAR2(150) := FND_API.G_MISS_CHAR,
316: pricing_attribute46 VARCHAR2(150) := FND_API.G_MISS_CHAR,
317: pricing_attribute47 VARCHAR2(150) := FND_API.G_MISS_CHAR,
318: pricing_attribute48 VARCHAR2(150) := FND_API.G_MISS_CHAR,
319: pricing_attribute49 VARCHAR2(150) := FND_API.G_MISS_CHAR,
320: pricing_attribute50 VARCHAR2(150) := FND_API.G_MISS_CHAR,
321: pricing_attribute51 VARCHAR2(150) := FND_API.G_MISS_CHAR,
314: pricing_attribute44 VARCHAR2(150) := FND_API.G_MISS_CHAR,
315: pricing_attribute45 VARCHAR2(150) := FND_API.G_MISS_CHAR,
316: pricing_attribute46 VARCHAR2(150) := FND_API.G_MISS_CHAR,
317: pricing_attribute47 VARCHAR2(150) := FND_API.G_MISS_CHAR,
318: pricing_attribute48 VARCHAR2(150) := FND_API.G_MISS_CHAR,
319: pricing_attribute49 VARCHAR2(150) := FND_API.G_MISS_CHAR,
320: pricing_attribute50 VARCHAR2(150) := FND_API.G_MISS_CHAR,
321: pricing_attribute51 VARCHAR2(150) := FND_API.G_MISS_CHAR,
322: pricing_attribute52 VARCHAR2(150) := FND_API.G_MISS_CHAR,
315: pricing_attribute45 VARCHAR2(150) := FND_API.G_MISS_CHAR,
316: pricing_attribute46 VARCHAR2(150) := FND_API.G_MISS_CHAR,
317: pricing_attribute47 VARCHAR2(150) := FND_API.G_MISS_CHAR,
318: pricing_attribute48 VARCHAR2(150) := FND_API.G_MISS_CHAR,
319: pricing_attribute49 VARCHAR2(150) := FND_API.G_MISS_CHAR,
320: pricing_attribute50 VARCHAR2(150) := FND_API.G_MISS_CHAR,
321: pricing_attribute51 VARCHAR2(150) := FND_API.G_MISS_CHAR,
322: pricing_attribute52 VARCHAR2(150) := FND_API.G_MISS_CHAR,
323: pricing_attribute53 VARCHAR2(150) := FND_API.G_MISS_CHAR,
316: pricing_attribute46 VARCHAR2(150) := FND_API.G_MISS_CHAR,
317: pricing_attribute47 VARCHAR2(150) := FND_API.G_MISS_CHAR,
318: pricing_attribute48 VARCHAR2(150) := FND_API.G_MISS_CHAR,
319: pricing_attribute49 VARCHAR2(150) := FND_API.G_MISS_CHAR,
320: pricing_attribute50 VARCHAR2(150) := FND_API.G_MISS_CHAR,
321: pricing_attribute51 VARCHAR2(150) := FND_API.G_MISS_CHAR,
322: pricing_attribute52 VARCHAR2(150) := FND_API.G_MISS_CHAR,
323: pricing_attribute53 VARCHAR2(150) := FND_API.G_MISS_CHAR,
324: pricing_attribute54 VARCHAR2(150) := FND_API.G_MISS_CHAR,
317: pricing_attribute47 VARCHAR2(150) := FND_API.G_MISS_CHAR,
318: pricing_attribute48 VARCHAR2(150) := FND_API.G_MISS_CHAR,
319: pricing_attribute49 VARCHAR2(150) := FND_API.G_MISS_CHAR,
320: pricing_attribute50 VARCHAR2(150) := FND_API.G_MISS_CHAR,
321: pricing_attribute51 VARCHAR2(150) := FND_API.G_MISS_CHAR,
322: pricing_attribute52 VARCHAR2(150) := FND_API.G_MISS_CHAR,
323: pricing_attribute53 VARCHAR2(150) := FND_API.G_MISS_CHAR,
324: pricing_attribute54 VARCHAR2(150) := FND_API.G_MISS_CHAR,
325: pricing_attribute55 VARCHAR2(150) := FND_API.G_MISS_CHAR,
318: pricing_attribute48 VARCHAR2(150) := FND_API.G_MISS_CHAR,
319: pricing_attribute49 VARCHAR2(150) := FND_API.G_MISS_CHAR,
320: pricing_attribute50 VARCHAR2(150) := FND_API.G_MISS_CHAR,
321: pricing_attribute51 VARCHAR2(150) := FND_API.G_MISS_CHAR,
322: pricing_attribute52 VARCHAR2(150) := FND_API.G_MISS_CHAR,
323: pricing_attribute53 VARCHAR2(150) := FND_API.G_MISS_CHAR,
324: pricing_attribute54 VARCHAR2(150) := FND_API.G_MISS_CHAR,
325: pricing_attribute55 VARCHAR2(150) := FND_API.G_MISS_CHAR,
326: pricing_attribute56 VARCHAR2(150) := FND_API.G_MISS_CHAR,
319: pricing_attribute49 VARCHAR2(150) := FND_API.G_MISS_CHAR,
320: pricing_attribute50 VARCHAR2(150) := FND_API.G_MISS_CHAR,
321: pricing_attribute51 VARCHAR2(150) := FND_API.G_MISS_CHAR,
322: pricing_attribute52 VARCHAR2(150) := FND_API.G_MISS_CHAR,
323: pricing_attribute53 VARCHAR2(150) := FND_API.G_MISS_CHAR,
324: pricing_attribute54 VARCHAR2(150) := FND_API.G_MISS_CHAR,
325: pricing_attribute55 VARCHAR2(150) := FND_API.G_MISS_CHAR,
326: pricing_attribute56 VARCHAR2(150) := FND_API.G_MISS_CHAR,
327: pricing_attribute57 VARCHAR2(150) := FND_API.G_MISS_CHAR,
320: pricing_attribute50 VARCHAR2(150) := FND_API.G_MISS_CHAR,
321: pricing_attribute51 VARCHAR2(150) := FND_API.G_MISS_CHAR,
322: pricing_attribute52 VARCHAR2(150) := FND_API.G_MISS_CHAR,
323: pricing_attribute53 VARCHAR2(150) := FND_API.G_MISS_CHAR,
324: pricing_attribute54 VARCHAR2(150) := FND_API.G_MISS_CHAR,
325: pricing_attribute55 VARCHAR2(150) := FND_API.G_MISS_CHAR,
326: pricing_attribute56 VARCHAR2(150) := FND_API.G_MISS_CHAR,
327: pricing_attribute57 VARCHAR2(150) := FND_API.G_MISS_CHAR,
328: pricing_attribute58 VARCHAR2(150) := FND_API.G_MISS_CHAR,
321: pricing_attribute51 VARCHAR2(150) := FND_API.G_MISS_CHAR,
322: pricing_attribute52 VARCHAR2(150) := FND_API.G_MISS_CHAR,
323: pricing_attribute53 VARCHAR2(150) := FND_API.G_MISS_CHAR,
324: pricing_attribute54 VARCHAR2(150) := FND_API.G_MISS_CHAR,
325: pricing_attribute55 VARCHAR2(150) := FND_API.G_MISS_CHAR,
326: pricing_attribute56 VARCHAR2(150) := FND_API.G_MISS_CHAR,
327: pricing_attribute57 VARCHAR2(150) := FND_API.G_MISS_CHAR,
328: pricing_attribute58 VARCHAR2(150) := FND_API.G_MISS_CHAR,
329: pricing_attribute59 VARCHAR2(150) := FND_API.G_MISS_CHAR,
322: pricing_attribute52 VARCHAR2(150) := FND_API.G_MISS_CHAR,
323: pricing_attribute53 VARCHAR2(150) := FND_API.G_MISS_CHAR,
324: pricing_attribute54 VARCHAR2(150) := FND_API.G_MISS_CHAR,
325: pricing_attribute55 VARCHAR2(150) := FND_API.G_MISS_CHAR,
326: pricing_attribute56 VARCHAR2(150) := FND_API.G_MISS_CHAR,
327: pricing_attribute57 VARCHAR2(150) := FND_API.G_MISS_CHAR,
328: pricing_attribute58 VARCHAR2(150) := FND_API.G_MISS_CHAR,
329: pricing_attribute59 VARCHAR2(150) := FND_API.G_MISS_CHAR,
330: pricing_attribute60 VARCHAR2(150) := FND_API.G_MISS_CHAR,
323: pricing_attribute53 VARCHAR2(150) := FND_API.G_MISS_CHAR,
324: pricing_attribute54 VARCHAR2(150) := FND_API.G_MISS_CHAR,
325: pricing_attribute55 VARCHAR2(150) := FND_API.G_MISS_CHAR,
326: pricing_attribute56 VARCHAR2(150) := FND_API.G_MISS_CHAR,
327: pricing_attribute57 VARCHAR2(150) := FND_API.G_MISS_CHAR,
328: pricing_attribute58 VARCHAR2(150) := FND_API.G_MISS_CHAR,
329: pricing_attribute59 VARCHAR2(150) := FND_API.G_MISS_CHAR,
330: pricing_attribute60 VARCHAR2(150) := FND_API.G_MISS_CHAR,
331: pricing_attribute61 VARCHAR2(150) := FND_API.G_MISS_CHAR,
324: pricing_attribute54 VARCHAR2(150) := FND_API.G_MISS_CHAR,
325: pricing_attribute55 VARCHAR2(150) := FND_API.G_MISS_CHAR,
326: pricing_attribute56 VARCHAR2(150) := FND_API.G_MISS_CHAR,
327: pricing_attribute57 VARCHAR2(150) := FND_API.G_MISS_CHAR,
328: pricing_attribute58 VARCHAR2(150) := FND_API.G_MISS_CHAR,
329: pricing_attribute59 VARCHAR2(150) := FND_API.G_MISS_CHAR,
330: pricing_attribute60 VARCHAR2(150) := FND_API.G_MISS_CHAR,
331: pricing_attribute61 VARCHAR2(150) := FND_API.G_MISS_CHAR,
332: pricing_attribute62 VARCHAR2(150) := FND_API.G_MISS_CHAR,
325: pricing_attribute55 VARCHAR2(150) := FND_API.G_MISS_CHAR,
326: pricing_attribute56 VARCHAR2(150) := FND_API.G_MISS_CHAR,
327: pricing_attribute57 VARCHAR2(150) := FND_API.G_MISS_CHAR,
328: pricing_attribute58 VARCHAR2(150) := FND_API.G_MISS_CHAR,
329: pricing_attribute59 VARCHAR2(150) := FND_API.G_MISS_CHAR,
330: pricing_attribute60 VARCHAR2(150) := FND_API.G_MISS_CHAR,
331: pricing_attribute61 VARCHAR2(150) := FND_API.G_MISS_CHAR,
332: pricing_attribute62 VARCHAR2(150) := FND_API.G_MISS_CHAR,
333: pricing_attribute63 VARCHAR2(150) := FND_API.G_MISS_CHAR,
326: pricing_attribute56 VARCHAR2(150) := FND_API.G_MISS_CHAR,
327: pricing_attribute57 VARCHAR2(150) := FND_API.G_MISS_CHAR,
328: pricing_attribute58 VARCHAR2(150) := FND_API.G_MISS_CHAR,
329: pricing_attribute59 VARCHAR2(150) := FND_API.G_MISS_CHAR,
330: pricing_attribute60 VARCHAR2(150) := FND_API.G_MISS_CHAR,
331: pricing_attribute61 VARCHAR2(150) := FND_API.G_MISS_CHAR,
332: pricing_attribute62 VARCHAR2(150) := FND_API.G_MISS_CHAR,
333: pricing_attribute63 VARCHAR2(150) := FND_API.G_MISS_CHAR,
334: pricing_attribute64 VARCHAR2(150) := FND_API.G_MISS_CHAR,
327: pricing_attribute57 VARCHAR2(150) := FND_API.G_MISS_CHAR,
328: pricing_attribute58 VARCHAR2(150) := FND_API.G_MISS_CHAR,
329: pricing_attribute59 VARCHAR2(150) := FND_API.G_MISS_CHAR,
330: pricing_attribute60 VARCHAR2(150) := FND_API.G_MISS_CHAR,
331: pricing_attribute61 VARCHAR2(150) := FND_API.G_MISS_CHAR,
332: pricing_attribute62 VARCHAR2(150) := FND_API.G_MISS_CHAR,
333: pricing_attribute63 VARCHAR2(150) := FND_API.G_MISS_CHAR,
334: pricing_attribute64 VARCHAR2(150) := FND_API.G_MISS_CHAR,
335: pricing_attribute65 VARCHAR2(150) := FND_API.G_MISS_CHAR,
328: pricing_attribute58 VARCHAR2(150) := FND_API.G_MISS_CHAR,
329: pricing_attribute59 VARCHAR2(150) := FND_API.G_MISS_CHAR,
330: pricing_attribute60 VARCHAR2(150) := FND_API.G_MISS_CHAR,
331: pricing_attribute61 VARCHAR2(150) := FND_API.G_MISS_CHAR,
332: pricing_attribute62 VARCHAR2(150) := FND_API.G_MISS_CHAR,
333: pricing_attribute63 VARCHAR2(150) := FND_API.G_MISS_CHAR,
334: pricing_attribute64 VARCHAR2(150) := FND_API.G_MISS_CHAR,
335: pricing_attribute65 VARCHAR2(150) := FND_API.G_MISS_CHAR,
336: pricing_attribute66 VARCHAR2(150) := FND_API.G_MISS_CHAR,
329: pricing_attribute59 VARCHAR2(150) := FND_API.G_MISS_CHAR,
330: pricing_attribute60 VARCHAR2(150) := FND_API.G_MISS_CHAR,
331: pricing_attribute61 VARCHAR2(150) := FND_API.G_MISS_CHAR,
332: pricing_attribute62 VARCHAR2(150) := FND_API.G_MISS_CHAR,
333: pricing_attribute63 VARCHAR2(150) := FND_API.G_MISS_CHAR,
334: pricing_attribute64 VARCHAR2(150) := FND_API.G_MISS_CHAR,
335: pricing_attribute65 VARCHAR2(150) := FND_API.G_MISS_CHAR,
336: pricing_attribute66 VARCHAR2(150) := FND_API.G_MISS_CHAR,
337: pricing_attribute67 VARCHAR2(150) := FND_API.G_MISS_CHAR,
330: pricing_attribute60 VARCHAR2(150) := FND_API.G_MISS_CHAR,
331: pricing_attribute61 VARCHAR2(150) := FND_API.G_MISS_CHAR,
332: pricing_attribute62 VARCHAR2(150) := FND_API.G_MISS_CHAR,
333: pricing_attribute63 VARCHAR2(150) := FND_API.G_MISS_CHAR,
334: pricing_attribute64 VARCHAR2(150) := FND_API.G_MISS_CHAR,
335: pricing_attribute65 VARCHAR2(150) := FND_API.G_MISS_CHAR,
336: pricing_attribute66 VARCHAR2(150) := FND_API.G_MISS_CHAR,
337: pricing_attribute67 VARCHAR2(150) := FND_API.G_MISS_CHAR,
338: pricing_attribute68 VARCHAR2(150) := FND_API.G_MISS_CHAR,
331: pricing_attribute61 VARCHAR2(150) := FND_API.G_MISS_CHAR,
332: pricing_attribute62 VARCHAR2(150) := FND_API.G_MISS_CHAR,
333: pricing_attribute63 VARCHAR2(150) := FND_API.G_MISS_CHAR,
334: pricing_attribute64 VARCHAR2(150) := FND_API.G_MISS_CHAR,
335: pricing_attribute65 VARCHAR2(150) := FND_API.G_MISS_CHAR,
336: pricing_attribute66 VARCHAR2(150) := FND_API.G_MISS_CHAR,
337: pricing_attribute67 VARCHAR2(150) := FND_API.G_MISS_CHAR,
338: pricing_attribute68 VARCHAR2(150) := FND_API.G_MISS_CHAR,
339: pricing_attribute69 VARCHAR2(150) := FND_API.G_MISS_CHAR,
332: pricing_attribute62 VARCHAR2(150) := FND_API.G_MISS_CHAR,
333: pricing_attribute63 VARCHAR2(150) := FND_API.G_MISS_CHAR,
334: pricing_attribute64 VARCHAR2(150) := FND_API.G_MISS_CHAR,
335: pricing_attribute65 VARCHAR2(150) := FND_API.G_MISS_CHAR,
336: pricing_attribute66 VARCHAR2(150) := FND_API.G_MISS_CHAR,
337: pricing_attribute67 VARCHAR2(150) := FND_API.G_MISS_CHAR,
338: pricing_attribute68 VARCHAR2(150) := FND_API.G_MISS_CHAR,
339: pricing_attribute69 VARCHAR2(150) := FND_API.G_MISS_CHAR,
340: pricing_attribute70 VARCHAR2(150) := FND_API.G_MISS_CHAR,
333: pricing_attribute63 VARCHAR2(150) := FND_API.G_MISS_CHAR,
334: pricing_attribute64 VARCHAR2(150) := FND_API.G_MISS_CHAR,
335: pricing_attribute65 VARCHAR2(150) := FND_API.G_MISS_CHAR,
336: pricing_attribute66 VARCHAR2(150) := FND_API.G_MISS_CHAR,
337: pricing_attribute67 VARCHAR2(150) := FND_API.G_MISS_CHAR,
338: pricing_attribute68 VARCHAR2(150) := FND_API.G_MISS_CHAR,
339: pricing_attribute69 VARCHAR2(150) := FND_API.G_MISS_CHAR,
340: pricing_attribute70 VARCHAR2(150) := FND_API.G_MISS_CHAR,
341: pricing_attribute71 VARCHAR2(150) := FND_API.G_MISS_CHAR,
334: pricing_attribute64 VARCHAR2(150) := FND_API.G_MISS_CHAR,
335: pricing_attribute65 VARCHAR2(150) := FND_API.G_MISS_CHAR,
336: pricing_attribute66 VARCHAR2(150) := FND_API.G_MISS_CHAR,
337: pricing_attribute67 VARCHAR2(150) := FND_API.G_MISS_CHAR,
338: pricing_attribute68 VARCHAR2(150) := FND_API.G_MISS_CHAR,
339: pricing_attribute69 VARCHAR2(150) := FND_API.G_MISS_CHAR,
340: pricing_attribute70 VARCHAR2(150) := FND_API.G_MISS_CHAR,
341: pricing_attribute71 VARCHAR2(150) := FND_API.G_MISS_CHAR,
342: pricing_attribute72 VARCHAR2(150) := FND_API.G_MISS_CHAR,
335: pricing_attribute65 VARCHAR2(150) := FND_API.G_MISS_CHAR,
336: pricing_attribute66 VARCHAR2(150) := FND_API.G_MISS_CHAR,
337: pricing_attribute67 VARCHAR2(150) := FND_API.G_MISS_CHAR,
338: pricing_attribute68 VARCHAR2(150) := FND_API.G_MISS_CHAR,
339: pricing_attribute69 VARCHAR2(150) := FND_API.G_MISS_CHAR,
340: pricing_attribute70 VARCHAR2(150) := FND_API.G_MISS_CHAR,
341: pricing_attribute71 VARCHAR2(150) := FND_API.G_MISS_CHAR,
342: pricing_attribute72 VARCHAR2(150) := FND_API.G_MISS_CHAR,
343: pricing_attribute73 VARCHAR2(150) := FND_API.G_MISS_CHAR,
336: pricing_attribute66 VARCHAR2(150) := FND_API.G_MISS_CHAR,
337: pricing_attribute67 VARCHAR2(150) := FND_API.G_MISS_CHAR,
338: pricing_attribute68 VARCHAR2(150) := FND_API.G_MISS_CHAR,
339: pricing_attribute69 VARCHAR2(150) := FND_API.G_MISS_CHAR,
340: pricing_attribute70 VARCHAR2(150) := FND_API.G_MISS_CHAR,
341: pricing_attribute71 VARCHAR2(150) := FND_API.G_MISS_CHAR,
342: pricing_attribute72 VARCHAR2(150) := FND_API.G_MISS_CHAR,
343: pricing_attribute73 VARCHAR2(150) := FND_API.G_MISS_CHAR,
344: pricing_attribute74 VARCHAR2(150) := FND_API.G_MISS_CHAR,
337: pricing_attribute67 VARCHAR2(150) := FND_API.G_MISS_CHAR,
338: pricing_attribute68 VARCHAR2(150) := FND_API.G_MISS_CHAR,
339: pricing_attribute69 VARCHAR2(150) := FND_API.G_MISS_CHAR,
340: pricing_attribute70 VARCHAR2(150) := FND_API.G_MISS_CHAR,
341: pricing_attribute71 VARCHAR2(150) := FND_API.G_MISS_CHAR,
342: pricing_attribute72 VARCHAR2(150) := FND_API.G_MISS_CHAR,
343: pricing_attribute73 VARCHAR2(150) := FND_API.G_MISS_CHAR,
344: pricing_attribute74 VARCHAR2(150) := FND_API.G_MISS_CHAR,
345: pricing_attribute75 VARCHAR2(150) := FND_API.G_MISS_CHAR,
338: pricing_attribute68 VARCHAR2(150) := FND_API.G_MISS_CHAR,
339: pricing_attribute69 VARCHAR2(150) := FND_API.G_MISS_CHAR,
340: pricing_attribute70 VARCHAR2(150) := FND_API.G_MISS_CHAR,
341: pricing_attribute71 VARCHAR2(150) := FND_API.G_MISS_CHAR,
342: pricing_attribute72 VARCHAR2(150) := FND_API.G_MISS_CHAR,
343: pricing_attribute73 VARCHAR2(150) := FND_API.G_MISS_CHAR,
344: pricing_attribute74 VARCHAR2(150) := FND_API.G_MISS_CHAR,
345: pricing_attribute75 VARCHAR2(150) := FND_API.G_MISS_CHAR,
346: pricing_attribute76 VARCHAR2(150) := FND_API.G_MISS_CHAR,
339: pricing_attribute69 VARCHAR2(150) := FND_API.G_MISS_CHAR,
340: pricing_attribute70 VARCHAR2(150) := FND_API.G_MISS_CHAR,
341: pricing_attribute71 VARCHAR2(150) := FND_API.G_MISS_CHAR,
342: pricing_attribute72 VARCHAR2(150) := FND_API.G_MISS_CHAR,
343: pricing_attribute73 VARCHAR2(150) := FND_API.G_MISS_CHAR,
344: pricing_attribute74 VARCHAR2(150) := FND_API.G_MISS_CHAR,
345: pricing_attribute75 VARCHAR2(150) := FND_API.G_MISS_CHAR,
346: pricing_attribute76 VARCHAR2(150) := FND_API.G_MISS_CHAR,
347: pricing_attribute77 VARCHAR2(150) := FND_API.G_MISS_CHAR,
340: pricing_attribute70 VARCHAR2(150) := FND_API.G_MISS_CHAR,
341: pricing_attribute71 VARCHAR2(150) := FND_API.G_MISS_CHAR,
342: pricing_attribute72 VARCHAR2(150) := FND_API.G_MISS_CHAR,
343: pricing_attribute73 VARCHAR2(150) := FND_API.G_MISS_CHAR,
344: pricing_attribute74 VARCHAR2(150) := FND_API.G_MISS_CHAR,
345: pricing_attribute75 VARCHAR2(150) := FND_API.G_MISS_CHAR,
346: pricing_attribute76 VARCHAR2(150) := FND_API.G_MISS_CHAR,
347: pricing_attribute77 VARCHAR2(150) := FND_API.G_MISS_CHAR,
348: pricing_attribute78 VARCHAR2(150) := FND_API.G_MISS_CHAR,
341: pricing_attribute71 VARCHAR2(150) := FND_API.G_MISS_CHAR,
342: pricing_attribute72 VARCHAR2(150) := FND_API.G_MISS_CHAR,
343: pricing_attribute73 VARCHAR2(150) := FND_API.G_MISS_CHAR,
344: pricing_attribute74 VARCHAR2(150) := FND_API.G_MISS_CHAR,
345: pricing_attribute75 VARCHAR2(150) := FND_API.G_MISS_CHAR,
346: pricing_attribute76 VARCHAR2(150) := FND_API.G_MISS_CHAR,
347: pricing_attribute77 VARCHAR2(150) := FND_API.G_MISS_CHAR,
348: pricing_attribute78 VARCHAR2(150) := FND_API.G_MISS_CHAR,
349: pricing_attribute79 VARCHAR2(150) := FND_API.G_MISS_CHAR,
342: pricing_attribute72 VARCHAR2(150) := FND_API.G_MISS_CHAR,
343: pricing_attribute73 VARCHAR2(150) := FND_API.G_MISS_CHAR,
344: pricing_attribute74 VARCHAR2(150) := FND_API.G_MISS_CHAR,
345: pricing_attribute75 VARCHAR2(150) := FND_API.G_MISS_CHAR,
346: pricing_attribute76 VARCHAR2(150) := FND_API.G_MISS_CHAR,
347: pricing_attribute77 VARCHAR2(150) := FND_API.G_MISS_CHAR,
348: pricing_attribute78 VARCHAR2(150) := FND_API.G_MISS_CHAR,
349: pricing_attribute79 VARCHAR2(150) := FND_API.G_MISS_CHAR,
350: pricing_attribute80 VARCHAR2(150) := FND_API.G_MISS_CHAR,
343: pricing_attribute73 VARCHAR2(150) := FND_API.G_MISS_CHAR,
344: pricing_attribute74 VARCHAR2(150) := FND_API.G_MISS_CHAR,
345: pricing_attribute75 VARCHAR2(150) := FND_API.G_MISS_CHAR,
346: pricing_attribute76 VARCHAR2(150) := FND_API.G_MISS_CHAR,
347: pricing_attribute77 VARCHAR2(150) := FND_API.G_MISS_CHAR,
348: pricing_attribute78 VARCHAR2(150) := FND_API.G_MISS_CHAR,
349: pricing_attribute79 VARCHAR2(150) := FND_API.G_MISS_CHAR,
350: pricing_attribute80 VARCHAR2(150) := FND_API.G_MISS_CHAR,
351: pricing_attribute81 VARCHAR2(150) := FND_API.G_MISS_CHAR,
344: pricing_attribute74 VARCHAR2(150) := FND_API.G_MISS_CHAR,
345: pricing_attribute75 VARCHAR2(150) := FND_API.G_MISS_CHAR,
346: pricing_attribute76 VARCHAR2(150) := FND_API.G_MISS_CHAR,
347: pricing_attribute77 VARCHAR2(150) := FND_API.G_MISS_CHAR,
348: pricing_attribute78 VARCHAR2(150) := FND_API.G_MISS_CHAR,
349: pricing_attribute79 VARCHAR2(150) := FND_API.G_MISS_CHAR,
350: pricing_attribute80 VARCHAR2(150) := FND_API.G_MISS_CHAR,
351: pricing_attribute81 VARCHAR2(150) := FND_API.G_MISS_CHAR,
352: pricing_attribute82 VARCHAR2(150) := FND_API.G_MISS_CHAR,
345: pricing_attribute75 VARCHAR2(150) := FND_API.G_MISS_CHAR,
346: pricing_attribute76 VARCHAR2(150) := FND_API.G_MISS_CHAR,
347: pricing_attribute77 VARCHAR2(150) := FND_API.G_MISS_CHAR,
348: pricing_attribute78 VARCHAR2(150) := FND_API.G_MISS_CHAR,
349: pricing_attribute79 VARCHAR2(150) := FND_API.G_MISS_CHAR,
350: pricing_attribute80 VARCHAR2(150) := FND_API.G_MISS_CHAR,
351: pricing_attribute81 VARCHAR2(150) := FND_API.G_MISS_CHAR,
352: pricing_attribute82 VARCHAR2(150) := FND_API.G_MISS_CHAR,
353: pricing_attribute83 VARCHAR2(150) := FND_API.G_MISS_CHAR,
346: pricing_attribute76 VARCHAR2(150) := FND_API.G_MISS_CHAR,
347: pricing_attribute77 VARCHAR2(150) := FND_API.G_MISS_CHAR,
348: pricing_attribute78 VARCHAR2(150) := FND_API.G_MISS_CHAR,
349: pricing_attribute79 VARCHAR2(150) := FND_API.G_MISS_CHAR,
350: pricing_attribute80 VARCHAR2(150) := FND_API.G_MISS_CHAR,
351: pricing_attribute81 VARCHAR2(150) := FND_API.G_MISS_CHAR,
352: pricing_attribute82 VARCHAR2(150) := FND_API.G_MISS_CHAR,
353: pricing_attribute83 VARCHAR2(150) := FND_API.G_MISS_CHAR,
354: pricing_attribute84 VARCHAR2(150) := FND_API.G_MISS_CHAR,
347: pricing_attribute77 VARCHAR2(150) := FND_API.G_MISS_CHAR,
348: pricing_attribute78 VARCHAR2(150) := FND_API.G_MISS_CHAR,
349: pricing_attribute79 VARCHAR2(150) := FND_API.G_MISS_CHAR,
350: pricing_attribute80 VARCHAR2(150) := FND_API.G_MISS_CHAR,
351: pricing_attribute81 VARCHAR2(150) := FND_API.G_MISS_CHAR,
352: pricing_attribute82 VARCHAR2(150) := FND_API.G_MISS_CHAR,
353: pricing_attribute83 VARCHAR2(150) := FND_API.G_MISS_CHAR,
354: pricing_attribute84 VARCHAR2(150) := FND_API.G_MISS_CHAR,
355: pricing_attribute85 VARCHAR2(150) := FND_API.G_MISS_CHAR,
348: pricing_attribute78 VARCHAR2(150) := FND_API.G_MISS_CHAR,
349: pricing_attribute79 VARCHAR2(150) := FND_API.G_MISS_CHAR,
350: pricing_attribute80 VARCHAR2(150) := FND_API.G_MISS_CHAR,
351: pricing_attribute81 VARCHAR2(150) := FND_API.G_MISS_CHAR,
352: pricing_attribute82 VARCHAR2(150) := FND_API.G_MISS_CHAR,
353: pricing_attribute83 VARCHAR2(150) := FND_API.G_MISS_CHAR,
354: pricing_attribute84 VARCHAR2(150) := FND_API.G_MISS_CHAR,
355: pricing_attribute85 VARCHAR2(150) := FND_API.G_MISS_CHAR,
356: pricing_attribute86 VARCHAR2(150) := FND_API.G_MISS_CHAR,
349: pricing_attribute79 VARCHAR2(150) := FND_API.G_MISS_CHAR,
350: pricing_attribute80 VARCHAR2(150) := FND_API.G_MISS_CHAR,
351: pricing_attribute81 VARCHAR2(150) := FND_API.G_MISS_CHAR,
352: pricing_attribute82 VARCHAR2(150) := FND_API.G_MISS_CHAR,
353: pricing_attribute83 VARCHAR2(150) := FND_API.G_MISS_CHAR,
354: pricing_attribute84 VARCHAR2(150) := FND_API.G_MISS_CHAR,
355: pricing_attribute85 VARCHAR2(150) := FND_API.G_MISS_CHAR,
356: pricing_attribute86 VARCHAR2(150) := FND_API.G_MISS_CHAR,
357: pricing_attribute87 VARCHAR2(150) := FND_API.G_MISS_CHAR,
350: pricing_attribute80 VARCHAR2(150) := FND_API.G_MISS_CHAR,
351: pricing_attribute81 VARCHAR2(150) := FND_API.G_MISS_CHAR,
352: pricing_attribute82 VARCHAR2(150) := FND_API.G_MISS_CHAR,
353: pricing_attribute83 VARCHAR2(150) := FND_API.G_MISS_CHAR,
354: pricing_attribute84 VARCHAR2(150) := FND_API.G_MISS_CHAR,
355: pricing_attribute85 VARCHAR2(150) := FND_API.G_MISS_CHAR,
356: pricing_attribute86 VARCHAR2(150) := FND_API.G_MISS_CHAR,
357: pricing_attribute87 VARCHAR2(150) := FND_API.G_MISS_CHAR,
358: pricing_attribute88 VARCHAR2(150) := FND_API.G_MISS_CHAR,
351: pricing_attribute81 VARCHAR2(150) := FND_API.G_MISS_CHAR,
352: pricing_attribute82 VARCHAR2(150) := FND_API.G_MISS_CHAR,
353: pricing_attribute83 VARCHAR2(150) := FND_API.G_MISS_CHAR,
354: pricing_attribute84 VARCHAR2(150) := FND_API.G_MISS_CHAR,
355: pricing_attribute85 VARCHAR2(150) := FND_API.G_MISS_CHAR,
356: pricing_attribute86 VARCHAR2(150) := FND_API.G_MISS_CHAR,
357: pricing_attribute87 VARCHAR2(150) := FND_API.G_MISS_CHAR,
358: pricing_attribute88 VARCHAR2(150) := FND_API.G_MISS_CHAR,
359: pricing_attribute89 VARCHAR2(150) := FND_API.G_MISS_CHAR,
352: pricing_attribute82 VARCHAR2(150) := FND_API.G_MISS_CHAR,
353: pricing_attribute83 VARCHAR2(150) := FND_API.G_MISS_CHAR,
354: pricing_attribute84 VARCHAR2(150) := FND_API.G_MISS_CHAR,
355: pricing_attribute85 VARCHAR2(150) := FND_API.G_MISS_CHAR,
356: pricing_attribute86 VARCHAR2(150) := FND_API.G_MISS_CHAR,
357: pricing_attribute87 VARCHAR2(150) := FND_API.G_MISS_CHAR,
358: pricing_attribute88 VARCHAR2(150) := FND_API.G_MISS_CHAR,
359: pricing_attribute89 VARCHAR2(150) := FND_API.G_MISS_CHAR,
360: pricing_attribute90 VARCHAR2(150) := FND_API.G_MISS_CHAR,
353: pricing_attribute83 VARCHAR2(150) := FND_API.G_MISS_CHAR,
354: pricing_attribute84 VARCHAR2(150) := FND_API.G_MISS_CHAR,
355: pricing_attribute85 VARCHAR2(150) := FND_API.G_MISS_CHAR,
356: pricing_attribute86 VARCHAR2(150) := FND_API.G_MISS_CHAR,
357: pricing_attribute87 VARCHAR2(150) := FND_API.G_MISS_CHAR,
358: pricing_attribute88 VARCHAR2(150) := FND_API.G_MISS_CHAR,
359: pricing_attribute89 VARCHAR2(150) := FND_API.G_MISS_CHAR,
360: pricing_attribute90 VARCHAR2(150) := FND_API.G_MISS_CHAR,
361: pricing_attribute91 VARCHAR2(150) := FND_API.G_MISS_CHAR,
354: pricing_attribute84 VARCHAR2(150) := FND_API.G_MISS_CHAR,
355: pricing_attribute85 VARCHAR2(150) := FND_API.G_MISS_CHAR,
356: pricing_attribute86 VARCHAR2(150) := FND_API.G_MISS_CHAR,
357: pricing_attribute87 VARCHAR2(150) := FND_API.G_MISS_CHAR,
358: pricing_attribute88 VARCHAR2(150) := FND_API.G_MISS_CHAR,
359: pricing_attribute89 VARCHAR2(150) := FND_API.G_MISS_CHAR,
360: pricing_attribute90 VARCHAR2(150) := FND_API.G_MISS_CHAR,
361: pricing_attribute91 VARCHAR2(150) := FND_API.G_MISS_CHAR,
362: pricing_attribute92 VARCHAR2(150) := FND_API.G_MISS_CHAR,
355: pricing_attribute85 VARCHAR2(150) := FND_API.G_MISS_CHAR,
356: pricing_attribute86 VARCHAR2(150) := FND_API.G_MISS_CHAR,
357: pricing_attribute87 VARCHAR2(150) := FND_API.G_MISS_CHAR,
358: pricing_attribute88 VARCHAR2(150) := FND_API.G_MISS_CHAR,
359: pricing_attribute89 VARCHAR2(150) := FND_API.G_MISS_CHAR,
360: pricing_attribute90 VARCHAR2(150) := FND_API.G_MISS_CHAR,
361: pricing_attribute91 VARCHAR2(150) := FND_API.G_MISS_CHAR,
362: pricing_attribute92 VARCHAR2(150) := FND_API.G_MISS_CHAR,
363: pricing_attribute93 VARCHAR2(150) := FND_API.G_MISS_CHAR,
356: pricing_attribute86 VARCHAR2(150) := FND_API.G_MISS_CHAR,
357: pricing_attribute87 VARCHAR2(150) := FND_API.G_MISS_CHAR,
358: pricing_attribute88 VARCHAR2(150) := FND_API.G_MISS_CHAR,
359: pricing_attribute89 VARCHAR2(150) := FND_API.G_MISS_CHAR,
360: pricing_attribute90 VARCHAR2(150) := FND_API.G_MISS_CHAR,
361: pricing_attribute91 VARCHAR2(150) := FND_API.G_MISS_CHAR,
362: pricing_attribute92 VARCHAR2(150) := FND_API.G_MISS_CHAR,
363: pricing_attribute93 VARCHAR2(150) := FND_API.G_MISS_CHAR,
364: pricing_attribute94 VARCHAR2(150) := FND_API.G_MISS_CHAR,
357: pricing_attribute87 VARCHAR2(150) := FND_API.G_MISS_CHAR,
358: pricing_attribute88 VARCHAR2(150) := FND_API.G_MISS_CHAR,
359: pricing_attribute89 VARCHAR2(150) := FND_API.G_MISS_CHAR,
360: pricing_attribute90 VARCHAR2(150) := FND_API.G_MISS_CHAR,
361: pricing_attribute91 VARCHAR2(150) := FND_API.G_MISS_CHAR,
362: pricing_attribute92 VARCHAR2(150) := FND_API.G_MISS_CHAR,
363: pricing_attribute93 VARCHAR2(150) := FND_API.G_MISS_CHAR,
364: pricing_attribute94 VARCHAR2(150) := FND_API.G_MISS_CHAR,
365: pricing_attribute95 VARCHAR2(150) := FND_API.G_MISS_CHAR,
358: pricing_attribute88 VARCHAR2(150) := FND_API.G_MISS_CHAR,
359: pricing_attribute89 VARCHAR2(150) := FND_API.G_MISS_CHAR,
360: pricing_attribute90 VARCHAR2(150) := FND_API.G_MISS_CHAR,
361: pricing_attribute91 VARCHAR2(150) := FND_API.G_MISS_CHAR,
362: pricing_attribute92 VARCHAR2(150) := FND_API.G_MISS_CHAR,
363: pricing_attribute93 VARCHAR2(150) := FND_API.G_MISS_CHAR,
364: pricing_attribute94 VARCHAR2(150) := FND_API.G_MISS_CHAR,
365: pricing_attribute95 VARCHAR2(150) := FND_API.G_MISS_CHAR,
366: pricing_attribute96 VARCHAR2(150) := FND_API.G_MISS_CHAR,
359: pricing_attribute89 VARCHAR2(150) := FND_API.G_MISS_CHAR,
360: pricing_attribute90 VARCHAR2(150) := FND_API.G_MISS_CHAR,
361: pricing_attribute91 VARCHAR2(150) := FND_API.G_MISS_CHAR,
362: pricing_attribute92 VARCHAR2(150) := FND_API.G_MISS_CHAR,
363: pricing_attribute93 VARCHAR2(150) := FND_API.G_MISS_CHAR,
364: pricing_attribute94 VARCHAR2(150) := FND_API.G_MISS_CHAR,
365: pricing_attribute95 VARCHAR2(150) := FND_API.G_MISS_CHAR,
366: pricing_attribute96 VARCHAR2(150) := FND_API.G_MISS_CHAR,
367: pricing_attribute97 VARCHAR2(150) := FND_API.G_MISS_CHAR,
360: pricing_attribute90 VARCHAR2(150) := FND_API.G_MISS_CHAR,
361: pricing_attribute91 VARCHAR2(150) := FND_API.G_MISS_CHAR,
362: pricing_attribute92 VARCHAR2(150) := FND_API.G_MISS_CHAR,
363: pricing_attribute93 VARCHAR2(150) := FND_API.G_MISS_CHAR,
364: pricing_attribute94 VARCHAR2(150) := FND_API.G_MISS_CHAR,
365: pricing_attribute95 VARCHAR2(150) := FND_API.G_MISS_CHAR,
366: pricing_attribute96 VARCHAR2(150) := FND_API.G_MISS_CHAR,
367: pricing_attribute97 VARCHAR2(150) := FND_API.G_MISS_CHAR,
368: pricing_attribute98 VARCHAR2(150) := FND_API.G_MISS_CHAR,
361: pricing_attribute91 VARCHAR2(150) := FND_API.G_MISS_CHAR,
362: pricing_attribute92 VARCHAR2(150) := FND_API.G_MISS_CHAR,
363: pricing_attribute93 VARCHAR2(150) := FND_API.G_MISS_CHAR,
364: pricing_attribute94 VARCHAR2(150) := FND_API.G_MISS_CHAR,
365: pricing_attribute95 VARCHAR2(150) := FND_API.G_MISS_CHAR,
366: pricing_attribute96 VARCHAR2(150) := FND_API.G_MISS_CHAR,
367: pricing_attribute97 VARCHAR2(150) := FND_API.G_MISS_CHAR,
368: pricing_attribute98 VARCHAR2(150) := FND_API.G_MISS_CHAR,
369: pricing_attribute99 VARCHAR2(150) := FND_API.G_MISS_CHAR,
362: pricing_attribute92 VARCHAR2(150) := FND_API.G_MISS_CHAR,
363: pricing_attribute93 VARCHAR2(150) := FND_API.G_MISS_CHAR,
364: pricing_attribute94 VARCHAR2(150) := FND_API.G_MISS_CHAR,
365: pricing_attribute95 VARCHAR2(150) := FND_API.G_MISS_CHAR,
366: pricing_attribute96 VARCHAR2(150) := FND_API.G_MISS_CHAR,
367: pricing_attribute97 VARCHAR2(150) := FND_API.G_MISS_CHAR,
368: pricing_attribute98 VARCHAR2(150) := FND_API.G_MISS_CHAR,
369: pricing_attribute99 VARCHAR2(150) := FND_API.G_MISS_CHAR,
370: pricing_attribute100 VARCHAR2(150) := FND_API.G_MISS_CHAR,
363: pricing_attribute93 VARCHAR2(150) := FND_API.G_MISS_CHAR,
364: pricing_attribute94 VARCHAR2(150) := FND_API.G_MISS_CHAR,
365: pricing_attribute95 VARCHAR2(150) := FND_API.G_MISS_CHAR,
366: pricing_attribute96 VARCHAR2(150) := FND_API.G_MISS_CHAR,
367: pricing_attribute97 VARCHAR2(150) := FND_API.G_MISS_CHAR,
368: pricing_attribute98 VARCHAR2(150) := FND_API.G_MISS_CHAR,
369: pricing_attribute99 VARCHAR2(150) := FND_API.G_MISS_CHAR,
370: pricing_attribute100 VARCHAR2(150) := FND_API.G_MISS_CHAR,
371: context VARCHAR2(30) := FND_API.G_MISS_CHAR,
364: pricing_attribute94 VARCHAR2(150) := FND_API.G_MISS_CHAR,
365: pricing_attribute95 VARCHAR2(150) := FND_API.G_MISS_CHAR,
366: pricing_attribute96 VARCHAR2(150) := FND_API.G_MISS_CHAR,
367: pricing_attribute97 VARCHAR2(150) := FND_API.G_MISS_CHAR,
368: pricing_attribute98 VARCHAR2(150) := FND_API.G_MISS_CHAR,
369: pricing_attribute99 VARCHAR2(150) := FND_API.G_MISS_CHAR,
370: pricing_attribute100 VARCHAR2(150) := FND_API.G_MISS_CHAR,
371: context VARCHAR2(30) := FND_API.G_MISS_CHAR,
372: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
365: pricing_attribute95 VARCHAR2(150) := FND_API.G_MISS_CHAR,
366: pricing_attribute96 VARCHAR2(150) := FND_API.G_MISS_CHAR,
367: pricing_attribute97 VARCHAR2(150) := FND_API.G_MISS_CHAR,
368: pricing_attribute98 VARCHAR2(150) := FND_API.G_MISS_CHAR,
369: pricing_attribute99 VARCHAR2(150) := FND_API.G_MISS_CHAR,
370: pricing_attribute100 VARCHAR2(150) := FND_API.G_MISS_CHAR,
371: context VARCHAR2(30) := FND_API.G_MISS_CHAR,
372: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
373: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
366: pricing_attribute96 VARCHAR2(150) := FND_API.G_MISS_CHAR,
367: pricing_attribute97 VARCHAR2(150) := FND_API.G_MISS_CHAR,
368: pricing_attribute98 VARCHAR2(150) := FND_API.G_MISS_CHAR,
369: pricing_attribute99 VARCHAR2(150) := FND_API.G_MISS_CHAR,
370: pricing_attribute100 VARCHAR2(150) := FND_API.G_MISS_CHAR,
371: context VARCHAR2(30) := FND_API.G_MISS_CHAR,
372: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
373: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
374: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
367: pricing_attribute97 VARCHAR2(150) := FND_API.G_MISS_CHAR,
368: pricing_attribute98 VARCHAR2(150) := FND_API.G_MISS_CHAR,
369: pricing_attribute99 VARCHAR2(150) := FND_API.G_MISS_CHAR,
370: pricing_attribute100 VARCHAR2(150) := FND_API.G_MISS_CHAR,
371: context VARCHAR2(30) := FND_API.G_MISS_CHAR,
372: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
373: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
374: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
375: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
368: pricing_attribute98 VARCHAR2(150) := FND_API.G_MISS_CHAR,
369: pricing_attribute99 VARCHAR2(150) := FND_API.G_MISS_CHAR,
370: pricing_attribute100 VARCHAR2(150) := FND_API.G_MISS_CHAR,
371: context VARCHAR2(30) := FND_API.G_MISS_CHAR,
372: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
373: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
374: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
375: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
376: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
369: pricing_attribute99 VARCHAR2(150) := FND_API.G_MISS_CHAR,
370: pricing_attribute100 VARCHAR2(150) := FND_API.G_MISS_CHAR,
371: context VARCHAR2(30) := FND_API.G_MISS_CHAR,
372: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
373: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
374: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
375: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
376: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
377: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
370: pricing_attribute100 VARCHAR2(150) := FND_API.G_MISS_CHAR,
371: context VARCHAR2(30) := FND_API.G_MISS_CHAR,
372: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
373: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
374: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
375: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
376: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
377: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
378: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
371: context VARCHAR2(30) := FND_API.G_MISS_CHAR,
372: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
373: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
374: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
375: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
376: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
377: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
378: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
379: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
372: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
373: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
374: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
375: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
376: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
377: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
378: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
379: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
380: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
373: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
374: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
375: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
376: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
377: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
378: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
379: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
380: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
381: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
374: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
375: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
376: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
377: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
378: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
379: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
380: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
381: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
382: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
375: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
376: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
377: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
378: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
379: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
380: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
381: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
382: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
383: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
376: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
377: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
378: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
379: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
380: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
381: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
382: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
383: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
384: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
377: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
378: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
379: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
380: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
381: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
382: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
383: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
384: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
385: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
378: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
379: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
380: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
381: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
382: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
383: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
384: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
385: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
386: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
379: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
380: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
381: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
382: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
383: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
384: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
385: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
386: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
387: object_version_number NUMBER := FND_API.G_MISS_NUM
380: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
381: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
382: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
383: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
384: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
385: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
386: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
387: object_version_number NUMBER := FND_API.G_MISS_NUM
388: );
381: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
382: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
383: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
384: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
385: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
386: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
387: object_version_number NUMBER := FND_API.G_MISS_NUM
388: );
389:
382: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
383: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
384: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
385: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
386: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
387: object_version_number NUMBER := FND_API.G_MISS_NUM
388: );
389:
390: TYPE txn_pricing_attribs_tbl IS TABLE OF txn_pricing_attrib_rec INDEX BY BINARY_INTEGER;
383: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
384: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
385: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
386: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
387: object_version_number NUMBER := FND_API.G_MISS_NUM
388: );
389:
390: TYPE txn_pricing_attribs_tbl IS TABLE OF txn_pricing_attrib_rec INDEX BY BINARY_INTEGER;
391:
393: -- Description : record to hold information about an instance-org association.
394:
395:
396: TYPE txn_org_unit_rec IS RECORD (
397: instance_ou_id NUMBER := FND_API.G_MISS_NUM,
398: parent_tbl_index NUMBER := FND_API.G_MISS_NUM,
399: instance_id NUMBER := FND_API.G_MISS_NUM,
400: operating_unit_id NUMBER := FND_API.G_MISS_NUM,
401: relationship_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
394:
395:
396: TYPE txn_org_unit_rec IS RECORD (
397: instance_ou_id NUMBER := FND_API.G_MISS_NUM,
398: parent_tbl_index NUMBER := FND_API.G_MISS_NUM,
399: instance_id NUMBER := FND_API.G_MISS_NUM,
400: operating_unit_id NUMBER := FND_API.G_MISS_NUM,
401: relationship_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
402: active_start_date DATE := FND_API.G_MISS_DATE,
395:
396: TYPE txn_org_unit_rec IS RECORD (
397: instance_ou_id NUMBER := FND_API.G_MISS_NUM,
398: parent_tbl_index NUMBER := FND_API.G_MISS_NUM,
399: instance_id NUMBER := FND_API.G_MISS_NUM,
400: operating_unit_id NUMBER := FND_API.G_MISS_NUM,
401: relationship_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
402: active_start_date DATE := FND_API.G_MISS_DATE,
403: active_end_date DATE := FND_API.G_MISS_DATE,
396: TYPE txn_org_unit_rec IS RECORD (
397: instance_ou_id NUMBER := FND_API.G_MISS_NUM,
398: parent_tbl_index NUMBER := FND_API.G_MISS_NUM,
399: instance_id NUMBER := FND_API.G_MISS_NUM,
400: operating_unit_id NUMBER := FND_API.G_MISS_NUM,
401: relationship_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
402: active_start_date DATE := FND_API.G_MISS_DATE,
403: active_end_date DATE := FND_API.G_MISS_DATE,
404: context VARCHAR2(30) := FND_API.G_MISS_CHAR,
397: instance_ou_id NUMBER := FND_API.G_MISS_NUM,
398: parent_tbl_index NUMBER := FND_API.G_MISS_NUM,
399: instance_id NUMBER := FND_API.G_MISS_NUM,
400: operating_unit_id NUMBER := FND_API.G_MISS_NUM,
401: relationship_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
402: active_start_date DATE := FND_API.G_MISS_DATE,
403: active_end_date DATE := FND_API.G_MISS_DATE,
404: context VARCHAR2(30) := FND_API.G_MISS_CHAR,
405: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
398: parent_tbl_index NUMBER := FND_API.G_MISS_NUM,
399: instance_id NUMBER := FND_API.G_MISS_NUM,
400: operating_unit_id NUMBER := FND_API.G_MISS_NUM,
401: relationship_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
402: active_start_date DATE := FND_API.G_MISS_DATE,
403: active_end_date DATE := FND_API.G_MISS_DATE,
404: context VARCHAR2(30) := FND_API.G_MISS_CHAR,
405: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
406: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
399: instance_id NUMBER := FND_API.G_MISS_NUM,
400: operating_unit_id NUMBER := FND_API.G_MISS_NUM,
401: relationship_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
402: active_start_date DATE := FND_API.G_MISS_DATE,
403: active_end_date DATE := FND_API.G_MISS_DATE,
404: context VARCHAR2(30) := FND_API.G_MISS_CHAR,
405: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
406: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
407: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
400: operating_unit_id NUMBER := FND_API.G_MISS_NUM,
401: relationship_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
402: active_start_date DATE := FND_API.G_MISS_DATE,
403: active_end_date DATE := FND_API.G_MISS_DATE,
404: context VARCHAR2(30) := FND_API.G_MISS_CHAR,
405: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
406: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
407: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
408: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
401: relationship_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
402: active_start_date DATE := FND_API.G_MISS_DATE,
403: active_end_date DATE := FND_API.G_MISS_DATE,
404: context VARCHAR2(30) := FND_API.G_MISS_CHAR,
405: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
406: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
407: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
408: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
409: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
402: active_start_date DATE := FND_API.G_MISS_DATE,
403: active_end_date DATE := FND_API.G_MISS_DATE,
404: context VARCHAR2(30) := FND_API.G_MISS_CHAR,
405: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
406: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
407: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
408: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
409: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
410: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
403: active_end_date DATE := FND_API.G_MISS_DATE,
404: context VARCHAR2(30) := FND_API.G_MISS_CHAR,
405: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
406: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
407: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
408: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
409: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
410: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
411: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
404: context VARCHAR2(30) := FND_API.G_MISS_CHAR,
405: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
406: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
407: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
408: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
409: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
410: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
411: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
412: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
405: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
406: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
407: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
408: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
409: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
410: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
411: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
412: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
413: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
406: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
407: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
408: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
409: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
410: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
411: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
412: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
413: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
414: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
407: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
408: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
409: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
410: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
411: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
412: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
413: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
414: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
415: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
408: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
409: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
410: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
411: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
412: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
413: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
414: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
415: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
416: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
409: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
410: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
411: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
412: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
413: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
414: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
415: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
416: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
417: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
410: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
411: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
412: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
413: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
414: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
415: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
416: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
417: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
418: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
411: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
412: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
413: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
414: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
415: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
416: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
417: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
418: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
419: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
412: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
413: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
414: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
415: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
416: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
417: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
418: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
419: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
420: object_version_number NUMBER := FND_API.G_MISS_NUM
413: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
414: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
415: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
416: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
417: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
418: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
419: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
420: object_version_number NUMBER := FND_API.G_MISS_NUM
421: );
414: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
415: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
416: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
417: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
418: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
419: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
420: object_version_number NUMBER := FND_API.G_MISS_NUM
421: );
422:
415: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
416: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
417: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
418: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
419: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
420: object_version_number NUMBER := FND_API.G_MISS_NUM
421: );
422:
423: TYPE txn_org_units_tbl IS TABLE OF txn_org_unit_rec INDEX BY BINARY_INTEGER;
416: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
417: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
418: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
419: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
420: object_version_number NUMBER := FND_API.G_MISS_NUM
421: );
422:
423: TYPE txn_org_units_tbl IS TABLE OF txn_org_unit_rec INDEX BY BINARY_INTEGER;
424:
425: -- Name : txn_instance_asset_rec
426: -- Description : record to hold information about instance-asset association.
427:
428: TYPE txn_instance_asset_rec IS RECORD (
429: instance_asset_id NUMBER := FND_API.G_MISS_NUM,
430: parent_tbl_index NUMBER := FND_API.G_MISS_NUM,
431: instance_id NUMBER := FND_API.G_MISS_NUM,
432: fa_asset_id NUMBER := FND_API.G_MISS_NUM,
433: fa_book_type_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
426: -- Description : record to hold information about instance-asset association.
427:
428: TYPE txn_instance_asset_rec IS RECORD (
429: instance_asset_id NUMBER := FND_API.G_MISS_NUM,
430: parent_tbl_index NUMBER := FND_API.G_MISS_NUM,
431: instance_id NUMBER := FND_API.G_MISS_NUM,
432: fa_asset_id NUMBER := FND_API.G_MISS_NUM,
433: fa_book_type_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
434: fa_location_id NUMBER := FND_API.G_MISS_NUM,
427:
428: TYPE txn_instance_asset_rec IS RECORD (
429: instance_asset_id NUMBER := FND_API.G_MISS_NUM,
430: parent_tbl_index NUMBER := FND_API.G_MISS_NUM,
431: instance_id NUMBER := FND_API.G_MISS_NUM,
432: fa_asset_id NUMBER := FND_API.G_MISS_NUM,
433: fa_book_type_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
434: fa_location_id NUMBER := FND_API.G_MISS_NUM,
435: asset_quantity NUMBER := FND_API.G_MISS_NUM,
428: TYPE txn_instance_asset_rec IS RECORD (
429: instance_asset_id NUMBER := FND_API.G_MISS_NUM,
430: parent_tbl_index NUMBER := FND_API.G_MISS_NUM,
431: instance_id NUMBER := FND_API.G_MISS_NUM,
432: fa_asset_id NUMBER := FND_API.G_MISS_NUM,
433: fa_book_type_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
434: fa_location_id NUMBER := FND_API.G_MISS_NUM,
435: asset_quantity NUMBER := FND_API.G_MISS_NUM,
436: update_status VARCHAR2(30) := FND_API.G_MISS_CHAR,
429: instance_asset_id NUMBER := FND_API.G_MISS_NUM,
430: parent_tbl_index NUMBER := FND_API.G_MISS_NUM,
431: instance_id NUMBER := FND_API.G_MISS_NUM,
432: fa_asset_id NUMBER := FND_API.G_MISS_NUM,
433: fa_book_type_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
434: fa_location_id NUMBER := FND_API.G_MISS_NUM,
435: asset_quantity NUMBER := FND_API.G_MISS_NUM,
436: update_status VARCHAR2(30) := FND_API.G_MISS_CHAR,
437: active_start_date DATE := FND_API.G_MISS_DATE,
430: parent_tbl_index NUMBER := FND_API.G_MISS_NUM,
431: instance_id NUMBER := FND_API.G_MISS_NUM,
432: fa_asset_id NUMBER := FND_API.G_MISS_NUM,
433: fa_book_type_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
434: fa_location_id NUMBER := FND_API.G_MISS_NUM,
435: asset_quantity NUMBER := FND_API.G_MISS_NUM,
436: update_status VARCHAR2(30) := FND_API.G_MISS_CHAR,
437: active_start_date DATE := FND_API.G_MISS_DATE,
438: active_end_date DATE := FND_API.G_MISS_DATE,
431: instance_id NUMBER := FND_API.G_MISS_NUM,
432: fa_asset_id NUMBER := FND_API.G_MISS_NUM,
433: fa_book_type_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
434: fa_location_id NUMBER := FND_API.G_MISS_NUM,
435: asset_quantity NUMBER := FND_API.G_MISS_NUM,
436: update_status VARCHAR2(30) := FND_API.G_MISS_CHAR,
437: active_start_date DATE := FND_API.G_MISS_DATE,
438: active_end_date DATE := FND_API.G_MISS_DATE,
439: object_version_number NUMBER := FND_API.G_MISS_NUM);
432: fa_asset_id NUMBER := FND_API.G_MISS_NUM,
433: fa_book_type_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
434: fa_location_id NUMBER := FND_API.G_MISS_NUM,
435: asset_quantity NUMBER := FND_API.G_MISS_NUM,
436: update_status VARCHAR2(30) := FND_API.G_MISS_CHAR,
437: active_start_date DATE := FND_API.G_MISS_DATE,
438: active_end_date DATE := FND_API.G_MISS_DATE,
439: object_version_number NUMBER := FND_API.G_MISS_NUM);
440:
433: fa_book_type_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
434: fa_location_id NUMBER := FND_API.G_MISS_NUM,
435: asset_quantity NUMBER := FND_API.G_MISS_NUM,
436: update_status VARCHAR2(30) := FND_API.G_MISS_CHAR,
437: active_start_date DATE := FND_API.G_MISS_DATE,
438: active_end_date DATE := FND_API.G_MISS_DATE,
439: object_version_number NUMBER := FND_API.G_MISS_NUM);
440:
441: TYPE txn_instance_asset_tbl IS TABLE OF txn_instance_asset_rec INDEX BY BINARY_INTEGER;
434: fa_location_id NUMBER := FND_API.G_MISS_NUM,
435: asset_quantity NUMBER := FND_API.G_MISS_NUM,
436: update_status VARCHAR2(30) := FND_API.G_MISS_CHAR,
437: active_start_date DATE := FND_API.G_MISS_DATE,
438: active_end_date DATE := FND_API.G_MISS_DATE,
439: object_version_number NUMBER := FND_API.G_MISS_NUM);
440:
441: TYPE txn_instance_asset_tbl IS TABLE OF txn_instance_asset_rec INDEX BY BINARY_INTEGER;
442:
435: asset_quantity NUMBER := FND_API.G_MISS_NUM,
436: update_status VARCHAR2(30) := FND_API.G_MISS_CHAR,
437: active_start_date DATE := FND_API.G_MISS_DATE,
438: active_end_date DATE := FND_API.G_MISS_DATE,
439: object_version_number NUMBER := FND_API.G_MISS_NUM);
440:
441: TYPE txn_instance_asset_tbl IS TABLE OF txn_instance_asset_rec INDEX BY BINARY_INTEGER;
442:
443:
450: /*-------------------------------------------------------------------*/
451:
452: PROCEDURE process_transaction (
453: p_api_version IN NUMBER,
454: p_commit IN VARCHAR2 := fnd_api.g_false,
455: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
456: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
457: p_validate_only_flag IN VARCHAR2 := fnd_api.g_false,
458: p_in_out_flag IN VARCHAR2, -- valid values are 'IN', 'OUT'
451:
452: PROCEDURE process_transaction (
453: p_api_version IN NUMBER,
454: p_commit IN VARCHAR2 := fnd_api.g_false,
455: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
456: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
457: p_validate_only_flag IN VARCHAR2 := fnd_api.g_false,
458: p_in_out_flag IN VARCHAR2, -- valid values are 'IN', 'OUT'
459: p_dest_location_rec IN OUT NOCOPY dest_location_rec,
452: PROCEDURE process_transaction (
453: p_api_version IN NUMBER,
454: p_commit IN VARCHAR2 := fnd_api.g_false,
455: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
456: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
457: p_validate_only_flag IN VARCHAR2 := fnd_api.g_false,
458: p_in_out_flag IN VARCHAR2, -- valid values are 'IN', 'OUT'
459: p_dest_location_rec IN OUT NOCOPY dest_location_rec,
460: p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
453: p_api_version IN NUMBER,
454: p_commit IN VARCHAR2 := fnd_api.g_false,
455: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
456: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
457: p_validate_only_flag IN VARCHAR2 := fnd_api.g_false,
458: p_in_out_flag IN VARCHAR2, -- valid values are 'IN', 'OUT'
459: p_dest_location_rec IN OUT NOCOPY dest_location_rec,
460: p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
461: p_instances_tbl IN OUT NOCOPY txn_instances_tbl,
474:
475: /* overloading to supress the visibility of the signature change to field service */
476: PROCEDURE process_transaction (
477: p_api_version IN NUMBER,
478: p_commit IN VARCHAR2 := fnd_api.g_false,
479: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
480: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
481: p_validate_only_flag IN VARCHAR2 := fnd_api.g_false,
482: p_in_out_flag IN VARCHAR2, -- valid values are 'IN', 'OUT'
475: /* overloading to supress the visibility of the signature change to field service */
476: PROCEDURE process_transaction (
477: p_api_version IN NUMBER,
478: p_commit IN VARCHAR2 := fnd_api.g_false,
479: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
480: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
481: p_validate_only_flag IN VARCHAR2 := fnd_api.g_false,
482: p_in_out_flag IN VARCHAR2, -- valid values are 'IN', 'OUT'
483: p_dest_location_rec IN OUT NOCOPY dest_location_rec,
476: PROCEDURE process_transaction (
477: p_api_version IN NUMBER,
478: p_commit IN VARCHAR2 := fnd_api.g_false,
479: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
480: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
481: p_validate_only_flag IN VARCHAR2 := fnd_api.g_false,
482: p_in_out_flag IN VARCHAR2, -- valid values are 'IN', 'OUT'
483: p_dest_location_rec IN OUT NOCOPY dest_location_rec,
484: p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
477: p_api_version IN NUMBER,
478: p_commit IN VARCHAR2 := fnd_api.g_false,
479: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
480: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
481: p_validate_only_flag IN VARCHAR2 := fnd_api.g_false,
482: p_in_out_flag IN VARCHAR2, -- valid values are 'IN', 'OUT'
483: p_dest_location_rec IN OUT NOCOPY dest_location_rec,
484: p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
485: p_instances_tbl IN OUT NOCOPY txn_instances_tbl,