4: -- Name : txn_system_rec
5: -- Description : record to hold the values of systems.
6:
7: TYPE txn_system_rec IS RECORD(
8: TRANSACTION_SYSTEM_ID NUMBER := FND_API.G_MISS_NUM,
9: TRANSACTION_LINE_ID NUMBER := FND_API.G_MISS_NUM,
10: SYSTEM_NAME VARCHAR2(50) := FND_API.G_MISS_CHAR,
11: DESCRIPTION VARCHAR2(240) := FND_API.G_MISS_CHAR,
12: SYSTEM_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
5: -- Description : record to hold the values of systems.
6:
7: TYPE txn_system_rec IS RECORD(
8: TRANSACTION_SYSTEM_ID NUMBER := FND_API.G_MISS_NUM,
9: TRANSACTION_LINE_ID NUMBER := FND_API.G_MISS_NUM,
10: SYSTEM_NAME VARCHAR2(50) := FND_API.G_MISS_CHAR,
11: DESCRIPTION VARCHAR2(240) := FND_API.G_MISS_CHAR,
12: SYSTEM_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
13: SYSTEM_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
6:
7: TYPE txn_system_rec IS RECORD(
8: TRANSACTION_SYSTEM_ID NUMBER := FND_API.G_MISS_NUM,
9: TRANSACTION_LINE_ID NUMBER := FND_API.G_MISS_NUM,
10: SYSTEM_NAME VARCHAR2(50) := FND_API.G_MISS_CHAR,
11: DESCRIPTION VARCHAR2(240) := FND_API.G_MISS_CHAR,
12: SYSTEM_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
13: SYSTEM_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
14: CUSTOMER_ID NUMBER := FND_API.G_MISS_NUM,
7: TYPE txn_system_rec IS RECORD(
8: TRANSACTION_SYSTEM_ID NUMBER := FND_API.G_MISS_NUM,
9: TRANSACTION_LINE_ID NUMBER := FND_API.G_MISS_NUM,
10: SYSTEM_NAME VARCHAR2(50) := FND_API.G_MISS_CHAR,
11: DESCRIPTION VARCHAR2(240) := FND_API.G_MISS_CHAR,
12: SYSTEM_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
13: SYSTEM_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
14: CUSTOMER_ID NUMBER := FND_API.G_MISS_NUM,
15: BILL_TO_CONTACT_ID NUMBER := FND_API.G_MISS_NUM,
8: TRANSACTION_SYSTEM_ID NUMBER := FND_API.G_MISS_NUM,
9: TRANSACTION_LINE_ID NUMBER := FND_API.G_MISS_NUM,
10: SYSTEM_NAME VARCHAR2(50) := FND_API.G_MISS_CHAR,
11: DESCRIPTION VARCHAR2(240) := FND_API.G_MISS_CHAR,
12: SYSTEM_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
13: SYSTEM_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
14: CUSTOMER_ID NUMBER := FND_API.G_MISS_NUM,
15: BILL_TO_CONTACT_ID NUMBER := FND_API.G_MISS_NUM,
16: SHIP_TO_CONTACT_ID NUMBER := FND_API.G_MISS_NUM,
9: TRANSACTION_LINE_ID NUMBER := FND_API.G_MISS_NUM,
10: SYSTEM_NAME VARCHAR2(50) := FND_API.G_MISS_CHAR,
11: DESCRIPTION VARCHAR2(240) := FND_API.G_MISS_CHAR,
12: SYSTEM_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
13: SYSTEM_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
14: CUSTOMER_ID NUMBER := FND_API.G_MISS_NUM,
15: BILL_TO_CONTACT_ID NUMBER := FND_API.G_MISS_NUM,
16: SHIP_TO_CONTACT_ID NUMBER := FND_API.G_MISS_NUM,
17: TECHNICAL_CONTACT_ID NUMBER := FND_API.G_MISS_NUM,
10: SYSTEM_NAME VARCHAR2(50) := FND_API.G_MISS_CHAR,
11: DESCRIPTION VARCHAR2(240) := FND_API.G_MISS_CHAR,
12: SYSTEM_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
13: SYSTEM_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
14: CUSTOMER_ID NUMBER := FND_API.G_MISS_NUM,
15: BILL_TO_CONTACT_ID NUMBER := FND_API.G_MISS_NUM,
16: SHIP_TO_CONTACT_ID NUMBER := FND_API.G_MISS_NUM,
17: TECHNICAL_CONTACT_ID NUMBER := FND_API.G_MISS_NUM,
18: SERVICE_ADMIN_CONTACT_ID NUMBER := FND_API.G_MISS_NUM,
11: DESCRIPTION VARCHAR2(240) := FND_API.G_MISS_CHAR,
12: SYSTEM_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
13: SYSTEM_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
14: CUSTOMER_ID NUMBER := FND_API.G_MISS_NUM,
15: BILL_TO_CONTACT_ID NUMBER := FND_API.G_MISS_NUM,
16: SHIP_TO_CONTACT_ID NUMBER := FND_API.G_MISS_NUM,
17: TECHNICAL_CONTACT_ID NUMBER := FND_API.G_MISS_NUM,
18: SERVICE_ADMIN_CONTACT_ID NUMBER := FND_API.G_MISS_NUM,
19: SHIP_TO_SITE_USE_ID NUMBER := FND_API.G_MISS_NUM,
12: SYSTEM_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
13: SYSTEM_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
14: CUSTOMER_ID NUMBER := FND_API.G_MISS_NUM,
15: BILL_TO_CONTACT_ID NUMBER := FND_API.G_MISS_NUM,
16: SHIP_TO_CONTACT_ID NUMBER := FND_API.G_MISS_NUM,
17: TECHNICAL_CONTACT_ID NUMBER := FND_API.G_MISS_NUM,
18: SERVICE_ADMIN_CONTACT_ID NUMBER := FND_API.G_MISS_NUM,
19: SHIP_TO_SITE_USE_ID NUMBER := FND_API.G_MISS_NUM,
20: BILL_TO_SITE_USE_ID NUMBER := FND_API.G_MISS_NUM,
13: SYSTEM_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
14: CUSTOMER_ID NUMBER := FND_API.G_MISS_NUM,
15: BILL_TO_CONTACT_ID NUMBER := FND_API.G_MISS_NUM,
16: SHIP_TO_CONTACT_ID NUMBER := FND_API.G_MISS_NUM,
17: TECHNICAL_CONTACT_ID NUMBER := FND_API.G_MISS_NUM,
18: SERVICE_ADMIN_CONTACT_ID NUMBER := FND_API.G_MISS_NUM,
19: SHIP_TO_SITE_USE_ID NUMBER := FND_API.G_MISS_NUM,
20: BILL_TO_SITE_USE_ID NUMBER := FND_API.G_MISS_NUM,
21: INSTALL_SITE_USE_ID NUMBER := FND_API.G_MISS_NUM,
14: CUSTOMER_ID NUMBER := FND_API.G_MISS_NUM,
15: BILL_TO_CONTACT_ID NUMBER := FND_API.G_MISS_NUM,
16: SHIP_TO_CONTACT_ID NUMBER := FND_API.G_MISS_NUM,
17: TECHNICAL_CONTACT_ID NUMBER := FND_API.G_MISS_NUM,
18: SERVICE_ADMIN_CONTACT_ID NUMBER := FND_API.G_MISS_NUM,
19: SHIP_TO_SITE_USE_ID NUMBER := FND_API.G_MISS_NUM,
20: BILL_TO_SITE_USE_ID NUMBER := FND_API.G_MISS_NUM,
21: INSTALL_SITE_USE_ID NUMBER := FND_API.G_MISS_NUM,
22: COTERMINATE_DAY_MONTH VARCHAR2(6) := FND_API.G_MISS_CHAR,
15: BILL_TO_CONTACT_ID NUMBER := FND_API.G_MISS_NUM,
16: SHIP_TO_CONTACT_ID NUMBER := FND_API.G_MISS_NUM,
17: TECHNICAL_CONTACT_ID NUMBER := FND_API.G_MISS_NUM,
18: SERVICE_ADMIN_CONTACT_ID NUMBER := FND_API.G_MISS_NUM,
19: SHIP_TO_SITE_USE_ID NUMBER := FND_API.G_MISS_NUM,
20: BILL_TO_SITE_USE_ID NUMBER := FND_API.G_MISS_NUM,
21: INSTALL_SITE_USE_ID NUMBER := FND_API.G_MISS_NUM,
22: COTERMINATE_DAY_MONTH VARCHAR2(6) := FND_API.G_MISS_CHAR,
23: CONFIG_SYSTEM_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
16: SHIP_TO_CONTACT_ID NUMBER := FND_API.G_MISS_NUM,
17: TECHNICAL_CONTACT_ID NUMBER := FND_API.G_MISS_NUM,
18: SERVICE_ADMIN_CONTACT_ID NUMBER := FND_API.G_MISS_NUM,
19: SHIP_TO_SITE_USE_ID NUMBER := FND_API.G_MISS_NUM,
20: BILL_TO_SITE_USE_ID NUMBER := FND_API.G_MISS_NUM,
21: INSTALL_SITE_USE_ID NUMBER := FND_API.G_MISS_NUM,
22: COTERMINATE_DAY_MONTH VARCHAR2(6) := FND_API.G_MISS_CHAR,
23: CONFIG_SYSTEM_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
24: START_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
17: TECHNICAL_CONTACT_ID NUMBER := FND_API.G_MISS_NUM,
18: SERVICE_ADMIN_CONTACT_ID NUMBER := FND_API.G_MISS_NUM,
19: SHIP_TO_SITE_USE_ID NUMBER := FND_API.G_MISS_NUM,
20: BILL_TO_SITE_USE_ID NUMBER := FND_API.G_MISS_NUM,
21: INSTALL_SITE_USE_ID NUMBER := FND_API.G_MISS_NUM,
22: COTERMINATE_DAY_MONTH VARCHAR2(6) := FND_API.G_MISS_CHAR,
23: CONFIG_SYSTEM_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
24: START_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
25: END_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
18: SERVICE_ADMIN_CONTACT_ID NUMBER := FND_API.G_MISS_NUM,
19: SHIP_TO_SITE_USE_ID NUMBER := FND_API.G_MISS_NUM,
20: BILL_TO_SITE_USE_ID NUMBER := FND_API.G_MISS_NUM,
21: INSTALL_SITE_USE_ID NUMBER := FND_API.G_MISS_NUM,
22: COTERMINATE_DAY_MONTH VARCHAR2(6) := FND_API.G_MISS_CHAR,
23: CONFIG_SYSTEM_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
24: START_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
25: END_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
26: CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
19: SHIP_TO_SITE_USE_ID NUMBER := FND_API.G_MISS_NUM,
20: BILL_TO_SITE_USE_ID NUMBER := FND_API.G_MISS_NUM,
21: INSTALL_SITE_USE_ID NUMBER := FND_API.G_MISS_NUM,
22: COTERMINATE_DAY_MONTH VARCHAR2(6) := FND_API.G_MISS_CHAR,
23: CONFIG_SYSTEM_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
24: START_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
25: END_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
26: CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
27: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
20: BILL_TO_SITE_USE_ID NUMBER := FND_API.G_MISS_NUM,
21: INSTALL_SITE_USE_ID NUMBER := FND_API.G_MISS_NUM,
22: COTERMINATE_DAY_MONTH VARCHAR2(6) := FND_API.G_MISS_CHAR,
23: CONFIG_SYSTEM_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
24: START_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
25: END_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
26: CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
27: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
28: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
21: INSTALL_SITE_USE_ID NUMBER := FND_API.G_MISS_NUM,
22: COTERMINATE_DAY_MONTH VARCHAR2(6) := FND_API.G_MISS_CHAR,
23: CONFIG_SYSTEM_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
24: START_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
25: END_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
26: CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
27: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
28: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
29: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
22: COTERMINATE_DAY_MONTH VARCHAR2(6) := FND_API.G_MISS_CHAR,
23: CONFIG_SYSTEM_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
24: START_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
25: END_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
26: CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
27: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
28: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
29: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
30: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
23: CONFIG_SYSTEM_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
24: START_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
25: END_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
26: CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
27: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
28: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
29: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
30: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
31: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
24: START_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
25: END_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
26: CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
27: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
28: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
29: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
30: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
31: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
32: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
25: END_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
26: CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
27: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
28: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
29: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
30: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
31: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
32: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
33: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
26: CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
27: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
28: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
29: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
30: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
31: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
32: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
33: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
34: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
27: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
28: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
29: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
30: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
31: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
32: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
33: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
34: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
35: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
28: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
29: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
30: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
31: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
32: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
33: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
34: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
35: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
36: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
29: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
30: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
31: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
32: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
33: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
34: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
35: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
36: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
37: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
30: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
31: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
32: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
33: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
34: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
35: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
36: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
37: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
38: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
31: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
32: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
33: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
34: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
35: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
36: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
37: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
38: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
39: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
32: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
33: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
34: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
35: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
36: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
37: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
38: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
39: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
40: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
33: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
34: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
35: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
36: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
37: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
38: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
39: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
40: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
41: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
34: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
35: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
36: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
37: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
38: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
39: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
40: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
41: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
42: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM);
35: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
36: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
37: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
38: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
39: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
40: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
41: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
42: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM);
43:
36: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
37: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
38: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
39: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
40: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
41: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
42: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM);
43:
44: TYPE txn_systems_tbl IS TABLE OF txn_system_rec INDEX BY BINARY_INTEGER;
37: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
38: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
39: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
40: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
41: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
42: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM);
43:
44: TYPE txn_systems_tbl IS TABLE OF txn_system_rec INDEX BY BINARY_INTEGER;
45:
38: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
39: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
40: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
41: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
42: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM);
43:
44: TYPE txn_systems_tbl IS TABLE OF txn_system_rec INDEX BY BINARY_INTEGER;
45:
46: -- Name : txn_line_rec
49: -- Description : record to hold the attributes of the source
50: -- transaction identifiers.
51:
52: TYPE txn_line_rec is RECORD (
53: TRANSACTION_LINE_ID NUMBER := FND_API.G_MISS_NUM,
54: SOURCE_TRANSACTION_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
55: SOURCE_TRANSACTION_ID NUMBER := FND_API.G_MISS_NUM,
56: ---Added (Start) for m-to-m enhancements
57: SOURCE_TXN_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
50: -- transaction identifiers.
51:
52: TYPE txn_line_rec is RECORD (
53: TRANSACTION_LINE_ID NUMBER := FND_API.G_MISS_NUM,
54: SOURCE_TRANSACTION_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
55: SOURCE_TRANSACTION_ID NUMBER := FND_API.G_MISS_NUM,
56: ---Added (Start) for m-to-m enhancements
57: SOURCE_TXN_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
58: ---Added (End) for m-to-m enhancements
51:
52: TYPE txn_line_rec is RECORD (
53: TRANSACTION_LINE_ID NUMBER := FND_API.G_MISS_NUM,
54: SOURCE_TRANSACTION_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
55: SOURCE_TRANSACTION_ID NUMBER := FND_API.G_MISS_NUM,
56: ---Added (Start) for m-to-m enhancements
57: SOURCE_TXN_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
58: ---Added (End) for m-to-m enhancements
59: SOURCE_TRANSACTION_TABLE VARCHAR2(30) := FND_API.G_MISS_CHAR,
53: TRANSACTION_LINE_ID NUMBER := FND_API.G_MISS_NUM,
54: SOURCE_TRANSACTION_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
55: SOURCE_TRANSACTION_ID NUMBER := FND_API.G_MISS_NUM,
56: ---Added (Start) for m-to-m enhancements
57: SOURCE_TXN_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
58: ---Added (End) for m-to-m enhancements
59: SOURCE_TRANSACTION_TABLE VARCHAR2(30) := FND_API.G_MISS_CHAR,
60: -- Added for CZ Integration (Begin)
61: CONFIG_SESSION_HDR_ID NUMBER := FND_API.G_MISS_NUM,
55: SOURCE_TRANSACTION_ID NUMBER := FND_API.G_MISS_NUM,
56: ---Added (Start) for m-to-m enhancements
57: SOURCE_TXN_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
58: ---Added (End) for m-to-m enhancements
59: SOURCE_TRANSACTION_TABLE VARCHAR2(30) := FND_API.G_MISS_CHAR,
60: -- Added for CZ Integration (Begin)
61: CONFIG_SESSION_HDR_ID NUMBER := FND_API.G_MISS_NUM,
62: CONFIG_SESSION_REV_NUM NUMBER := FND_API.G_MISS_NUM,
63: CONFIG_SESSION_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
57: SOURCE_TXN_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
58: ---Added (End) for m-to-m enhancements
59: SOURCE_TRANSACTION_TABLE VARCHAR2(30) := FND_API.G_MISS_CHAR,
60: -- Added for CZ Integration (Begin)
61: CONFIG_SESSION_HDR_ID NUMBER := FND_API.G_MISS_NUM,
62: CONFIG_SESSION_REV_NUM NUMBER := FND_API.G_MISS_NUM,
63: CONFIG_SESSION_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
64: CONFIG_VALID_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
65: SOURCE_TRANSACTION_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
58: ---Added (End) for m-to-m enhancements
59: SOURCE_TRANSACTION_TABLE VARCHAR2(30) := FND_API.G_MISS_CHAR,
60: -- Added for CZ Integration (Begin)
61: CONFIG_SESSION_HDR_ID NUMBER := FND_API.G_MISS_NUM,
62: CONFIG_SESSION_REV_NUM NUMBER := FND_API.G_MISS_NUM,
63: CONFIG_SESSION_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
64: CONFIG_VALID_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
65: SOURCE_TRANSACTION_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
66: API_CALLER_IDENTITY VARCHAR2(15) := 'OTHER',
59: SOURCE_TRANSACTION_TABLE VARCHAR2(30) := FND_API.G_MISS_CHAR,
60: -- Added for CZ Integration (Begin)
61: CONFIG_SESSION_HDR_ID NUMBER := FND_API.G_MISS_NUM,
62: CONFIG_SESSION_REV_NUM NUMBER := FND_API.G_MISS_NUM,
63: CONFIG_SESSION_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
64: CONFIG_VALID_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
65: SOURCE_TRANSACTION_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
66: API_CALLER_IDENTITY VARCHAR2(15) := 'OTHER',
67: -- Added for CZ Integration (End)
60: -- Added for CZ Integration (Begin)
61: CONFIG_SESSION_HDR_ID NUMBER := FND_API.G_MISS_NUM,
62: CONFIG_SESSION_REV_NUM NUMBER := FND_API.G_MISS_NUM,
63: CONFIG_SESSION_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
64: CONFIG_VALID_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
65: SOURCE_TRANSACTION_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
66: API_CALLER_IDENTITY VARCHAR2(15) := 'OTHER',
67: -- Added for CZ Integration (End)
68: INV_MATERIAL_TXN_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
61: CONFIG_SESSION_HDR_ID NUMBER := FND_API.G_MISS_NUM,
62: CONFIG_SESSION_REV_NUM NUMBER := FND_API.G_MISS_NUM,
63: CONFIG_SESSION_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
64: CONFIG_VALID_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
65: SOURCE_TRANSACTION_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
66: API_CALLER_IDENTITY VARCHAR2(15) := 'OTHER',
67: -- Added for CZ Integration (End)
68: INV_MATERIAL_TXN_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
69: ERROR_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
64: CONFIG_VALID_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
65: SOURCE_TRANSACTION_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
66: API_CALLER_IDENTITY VARCHAR2(15) := 'OTHER',
67: -- Added for CZ Integration (End)
68: INV_MATERIAL_TXN_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
69: ERROR_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
70: ERROR_EXPLANATION VARCHAR2(240) := FND_API.G_MISS_CHAR,
71: PROCESSING_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
72: CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
65: SOURCE_TRANSACTION_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
66: API_CALLER_IDENTITY VARCHAR2(15) := 'OTHER',
67: -- Added for CZ Integration (End)
68: INV_MATERIAL_TXN_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
69: ERROR_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
70: ERROR_EXPLANATION VARCHAR2(240) := FND_API.G_MISS_CHAR,
71: PROCESSING_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
72: CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
66: API_CALLER_IDENTITY VARCHAR2(15) := 'OTHER',
67: -- Added for CZ Integration (End)
68: INV_MATERIAL_TXN_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
69: ERROR_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
70: ERROR_EXPLANATION VARCHAR2(240) := FND_API.G_MISS_CHAR,
71: PROCESSING_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
72: CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
67: -- Added for CZ Integration (End)
68: INV_MATERIAL_TXN_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
69: ERROR_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
70: ERROR_EXPLANATION VARCHAR2(240) := FND_API.G_MISS_CHAR,
71: PROCESSING_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
72: CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
68: INV_MATERIAL_TXN_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
69: ERROR_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
70: ERROR_EXPLANATION VARCHAR2(240) := FND_API.G_MISS_CHAR,
71: PROCESSING_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
72: CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
69: ERROR_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
70: ERROR_EXPLANATION VARCHAR2(240) := FND_API.G_MISS_CHAR,
71: PROCESSING_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
72: CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
70: ERROR_EXPLANATION VARCHAR2(240) := FND_API.G_MISS_CHAR,
71: PROCESSING_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
72: CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
78: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
71: PROCESSING_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
72: CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
78: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
79: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
72: CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
78: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
79: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
78: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
79: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
78: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
79: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
78: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
79: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
78: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
79: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
78: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
79: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
78: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
79: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
79: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM);
81: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM);
89:
82: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM);
89:
90: -- Name : txn_line_detail_rec
83: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM);
89:
90: -- Name : txn_line_detail_rec
91: -- Package name : csi_t_datastructures_grp
84: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM);
89:
90: -- Name : txn_line_detail_rec
91: -- Package name : csi_t_datastructures_grp
92: -- Type : type definition, group
92: -- Type : type definition, group
93: -- Description : record to hold the attributes of the txn line detail.
94:
95: TYPE txn_line_detail_rec is RECORD (
96: TXN_LINE_DETAIL_ID NUMBER := FND_API.G_MISS_NUM,
97: TRANSACTION_LINE_ID NUMBER := FND_API.G_MISS_NUM,
98: SUB_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
99: INSTANCE_EXISTS_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
100: SOURCE_TRANSACTION_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
93: -- Description : record to hold the attributes of the txn line detail.
94:
95: TYPE txn_line_detail_rec is RECORD (
96: TXN_LINE_DETAIL_ID NUMBER := FND_API.G_MISS_NUM,
97: TRANSACTION_LINE_ID NUMBER := FND_API.G_MISS_NUM,
98: SUB_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
99: INSTANCE_EXISTS_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
100: SOURCE_TRANSACTION_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
101: INSTANCE_ID NUMBER := FND_API.G_MISS_NUM,
94:
95: TYPE txn_line_detail_rec is RECORD (
96: TXN_LINE_DETAIL_ID NUMBER := FND_API.G_MISS_NUM,
97: TRANSACTION_LINE_ID NUMBER := FND_API.G_MISS_NUM,
98: SUB_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
99: INSTANCE_EXISTS_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
100: SOURCE_TRANSACTION_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
101: INSTANCE_ID NUMBER := FND_API.G_MISS_NUM,
102: CHANGED_INSTANCE_ID NUMBER := FND_API.G_MISS_NUM,
95: TYPE txn_line_detail_rec is RECORD (
96: TXN_LINE_DETAIL_ID NUMBER := FND_API.G_MISS_NUM,
97: TRANSACTION_LINE_ID NUMBER := FND_API.G_MISS_NUM,
98: SUB_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
99: INSTANCE_EXISTS_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
100: SOURCE_TRANSACTION_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
101: INSTANCE_ID NUMBER := FND_API.G_MISS_NUM,
102: CHANGED_INSTANCE_ID NUMBER := FND_API.G_MISS_NUM,
103: CSI_SYSTEM_ID NUMBER := FND_API.G_MISS_NUM,
96: TXN_LINE_DETAIL_ID NUMBER := FND_API.G_MISS_NUM,
97: TRANSACTION_LINE_ID NUMBER := FND_API.G_MISS_NUM,
98: SUB_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
99: INSTANCE_EXISTS_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
100: SOURCE_TRANSACTION_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
101: INSTANCE_ID NUMBER := FND_API.G_MISS_NUM,
102: CHANGED_INSTANCE_ID NUMBER := FND_API.G_MISS_NUM,
103: CSI_SYSTEM_ID NUMBER := FND_API.G_MISS_NUM,
104: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
97: TRANSACTION_LINE_ID NUMBER := FND_API.G_MISS_NUM,
98: SUB_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
99: INSTANCE_EXISTS_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
100: SOURCE_TRANSACTION_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
101: INSTANCE_ID NUMBER := FND_API.G_MISS_NUM,
102: CHANGED_INSTANCE_ID NUMBER := FND_API.G_MISS_NUM,
103: CSI_SYSTEM_ID NUMBER := FND_API.G_MISS_NUM,
104: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
105: INVENTORY_REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,
98: SUB_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
99: INSTANCE_EXISTS_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
100: SOURCE_TRANSACTION_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
101: INSTANCE_ID NUMBER := FND_API.G_MISS_NUM,
102: CHANGED_INSTANCE_ID NUMBER := FND_API.G_MISS_NUM,
103: CSI_SYSTEM_ID NUMBER := FND_API.G_MISS_NUM,
104: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
105: INVENTORY_REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,
106: INV_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
99: INSTANCE_EXISTS_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
100: SOURCE_TRANSACTION_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
101: INSTANCE_ID NUMBER := FND_API.G_MISS_NUM,
102: CHANGED_INSTANCE_ID NUMBER := FND_API.G_MISS_NUM,
103: CSI_SYSTEM_ID NUMBER := FND_API.G_MISS_NUM,
104: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
105: INVENTORY_REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,
106: INV_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
107: ITEM_CONDITION_ID NUMBER := FND_API.G_MISS_NUM,
100: SOURCE_TRANSACTION_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
101: INSTANCE_ID NUMBER := FND_API.G_MISS_NUM,
102: CHANGED_INSTANCE_ID NUMBER := FND_API.G_MISS_NUM,
103: CSI_SYSTEM_ID NUMBER := FND_API.G_MISS_NUM,
104: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
105: INVENTORY_REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,
106: INV_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
107: ITEM_CONDITION_ID NUMBER := FND_API.G_MISS_NUM,
108: INSTANCE_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
101: INSTANCE_ID NUMBER := FND_API.G_MISS_NUM,
102: CHANGED_INSTANCE_ID NUMBER := FND_API.G_MISS_NUM,
103: CSI_SYSTEM_ID NUMBER := FND_API.G_MISS_NUM,
104: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
105: INVENTORY_REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,
106: INV_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
107: ITEM_CONDITION_ID NUMBER := FND_API.G_MISS_NUM,
108: INSTANCE_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
109: QUANTITY NUMBER := FND_API.G_MISS_NUM,
102: CHANGED_INSTANCE_ID NUMBER := FND_API.G_MISS_NUM,
103: CSI_SYSTEM_ID NUMBER := FND_API.G_MISS_NUM,
104: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
105: INVENTORY_REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,
106: INV_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
107: ITEM_CONDITION_ID NUMBER := FND_API.G_MISS_NUM,
108: INSTANCE_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
109: QUANTITY NUMBER := FND_API.G_MISS_NUM,
110: UNIT_OF_MEASURE VARCHAR2(3) := FND_API.G_MISS_CHAR,
103: CSI_SYSTEM_ID NUMBER := FND_API.G_MISS_NUM,
104: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
105: INVENTORY_REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,
106: INV_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
107: ITEM_CONDITION_ID NUMBER := FND_API.G_MISS_NUM,
108: INSTANCE_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
109: QUANTITY NUMBER := FND_API.G_MISS_NUM,
110: UNIT_OF_MEASURE VARCHAR2(3) := FND_API.G_MISS_CHAR,
111: QTY_REMAINING NUMBER := FND_API.G_MISS_NUM,
104: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
105: INVENTORY_REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,
106: INV_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
107: ITEM_CONDITION_ID NUMBER := FND_API.G_MISS_NUM,
108: INSTANCE_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
109: QUANTITY NUMBER := FND_API.G_MISS_NUM,
110: UNIT_OF_MEASURE VARCHAR2(3) := FND_API.G_MISS_CHAR,
111: QTY_REMAINING NUMBER := FND_API.G_MISS_NUM,
112: SERIAL_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
105: INVENTORY_REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,
106: INV_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
107: ITEM_CONDITION_ID NUMBER := FND_API.G_MISS_NUM,
108: INSTANCE_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
109: QUANTITY NUMBER := FND_API.G_MISS_NUM,
110: UNIT_OF_MEASURE VARCHAR2(3) := FND_API.G_MISS_CHAR,
111: QTY_REMAINING NUMBER := FND_API.G_MISS_NUM,
112: SERIAL_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
113: MFG_SERIAL_NUMBER_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
106: INV_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
107: ITEM_CONDITION_ID NUMBER := FND_API.G_MISS_NUM,
108: INSTANCE_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
109: QUANTITY NUMBER := FND_API.G_MISS_NUM,
110: UNIT_OF_MEASURE VARCHAR2(3) := FND_API.G_MISS_CHAR,
111: QTY_REMAINING NUMBER := FND_API.G_MISS_NUM,
112: SERIAL_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
113: MFG_SERIAL_NUMBER_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
114: LOT_NUMBER VARCHAR2(80) := FND_API.G_MISS_CHAR,
107: ITEM_CONDITION_ID NUMBER := FND_API.G_MISS_NUM,
108: INSTANCE_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
109: QUANTITY NUMBER := FND_API.G_MISS_NUM,
110: UNIT_OF_MEASURE VARCHAR2(3) := FND_API.G_MISS_CHAR,
111: QTY_REMAINING NUMBER := FND_API.G_MISS_NUM,
112: SERIAL_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
113: MFG_SERIAL_NUMBER_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
114: LOT_NUMBER VARCHAR2(80) := FND_API.G_MISS_CHAR,
115: LOCATION_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
108: INSTANCE_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
109: QUANTITY NUMBER := FND_API.G_MISS_NUM,
110: UNIT_OF_MEASURE VARCHAR2(3) := FND_API.G_MISS_CHAR,
111: QTY_REMAINING NUMBER := FND_API.G_MISS_NUM,
112: SERIAL_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
113: MFG_SERIAL_NUMBER_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
114: LOT_NUMBER VARCHAR2(80) := FND_API.G_MISS_CHAR,
115: LOCATION_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
116: LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
109: QUANTITY NUMBER := FND_API.G_MISS_NUM,
110: UNIT_OF_MEASURE VARCHAR2(3) := FND_API.G_MISS_CHAR,
111: QTY_REMAINING NUMBER := FND_API.G_MISS_NUM,
112: SERIAL_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
113: MFG_SERIAL_NUMBER_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
114: LOT_NUMBER VARCHAR2(80) := FND_API.G_MISS_CHAR,
115: LOCATION_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
116: LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
117: INSTALLATION_DATE DATE := FND_API.G_MISS_DATE,
110: UNIT_OF_MEASURE VARCHAR2(3) := FND_API.G_MISS_CHAR,
111: QTY_REMAINING NUMBER := FND_API.G_MISS_NUM,
112: SERIAL_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
113: MFG_SERIAL_NUMBER_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
114: LOT_NUMBER VARCHAR2(80) := FND_API.G_MISS_CHAR,
115: LOCATION_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
116: LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
117: INSTALLATION_DATE DATE := FND_API.G_MISS_DATE,
118: IN_SERVICE_DATE DATE := FND_API.G_MISS_DATE,
111: QTY_REMAINING NUMBER := FND_API.G_MISS_NUM,
112: SERIAL_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
113: MFG_SERIAL_NUMBER_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
114: LOT_NUMBER VARCHAR2(80) := FND_API.G_MISS_CHAR,
115: LOCATION_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
116: LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
117: INSTALLATION_DATE DATE := FND_API.G_MISS_DATE,
118: IN_SERVICE_DATE DATE := FND_API.G_MISS_DATE,
119: EXTERNAL_REFERENCE VARCHAR2(30) := FND_API.G_MISS_CHAR,
112: SERIAL_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
113: MFG_SERIAL_NUMBER_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
114: LOT_NUMBER VARCHAR2(80) := FND_API.G_MISS_CHAR,
115: LOCATION_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
116: LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
117: INSTALLATION_DATE DATE := FND_API.G_MISS_DATE,
118: IN_SERVICE_DATE DATE := FND_API.G_MISS_DATE,
119: EXTERNAL_REFERENCE VARCHAR2(30) := FND_API.G_MISS_CHAR,
120: TRANSACTION_SYSTEM_ID NUMBER := FND_API.G_MISS_NUM,
113: MFG_SERIAL_NUMBER_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
114: LOT_NUMBER VARCHAR2(80) := FND_API.G_MISS_CHAR,
115: LOCATION_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
116: LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
117: INSTALLATION_DATE DATE := FND_API.G_MISS_DATE,
118: IN_SERVICE_DATE DATE := FND_API.G_MISS_DATE,
119: EXTERNAL_REFERENCE VARCHAR2(30) := FND_API.G_MISS_CHAR,
120: TRANSACTION_SYSTEM_ID NUMBER := FND_API.G_MISS_NUM,
121: SELLABLE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
114: LOT_NUMBER VARCHAR2(80) := FND_API.G_MISS_CHAR,
115: LOCATION_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
116: LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
117: INSTALLATION_DATE DATE := FND_API.G_MISS_DATE,
118: IN_SERVICE_DATE DATE := FND_API.G_MISS_DATE,
119: EXTERNAL_REFERENCE VARCHAR2(30) := FND_API.G_MISS_CHAR,
120: TRANSACTION_SYSTEM_ID NUMBER := FND_API.G_MISS_NUM,
121: SELLABLE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
122: VERSION_LABEL VARCHAR2(240) := FND_API.G_MISS_CHAR,
115: LOCATION_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
116: LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
117: INSTALLATION_DATE DATE := FND_API.G_MISS_DATE,
118: IN_SERVICE_DATE DATE := FND_API.G_MISS_DATE,
119: EXTERNAL_REFERENCE VARCHAR2(30) := FND_API.G_MISS_CHAR,
120: TRANSACTION_SYSTEM_ID NUMBER := FND_API.G_MISS_NUM,
121: SELLABLE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
122: VERSION_LABEL VARCHAR2(240) := FND_API.G_MISS_CHAR,
123: RETURN_BY_DATE DATE := FND_API.G_MISS_DATE,
116: LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
117: INSTALLATION_DATE DATE := FND_API.G_MISS_DATE,
118: IN_SERVICE_DATE DATE := FND_API.G_MISS_DATE,
119: EXTERNAL_REFERENCE VARCHAR2(30) := FND_API.G_MISS_CHAR,
120: TRANSACTION_SYSTEM_ID NUMBER := FND_API.G_MISS_NUM,
121: SELLABLE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
122: VERSION_LABEL VARCHAR2(240) := FND_API.G_MISS_CHAR,
123: RETURN_BY_DATE DATE := FND_API.G_MISS_DATE,
124: ACTIVE_START_DATE DATE := FND_API.G_MISS_DATE,
117: INSTALLATION_DATE DATE := FND_API.G_MISS_DATE,
118: IN_SERVICE_DATE DATE := FND_API.G_MISS_DATE,
119: EXTERNAL_REFERENCE VARCHAR2(30) := FND_API.G_MISS_CHAR,
120: TRANSACTION_SYSTEM_ID NUMBER := FND_API.G_MISS_NUM,
121: SELLABLE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
122: VERSION_LABEL VARCHAR2(240) := FND_API.G_MISS_CHAR,
123: RETURN_BY_DATE DATE := FND_API.G_MISS_DATE,
124: ACTIVE_START_DATE DATE := FND_API.G_MISS_DATE,
125: ACTIVE_END_DATE DATE := FND_API.G_MISS_DATE,
118: IN_SERVICE_DATE DATE := FND_API.G_MISS_DATE,
119: EXTERNAL_REFERENCE VARCHAR2(30) := FND_API.G_MISS_CHAR,
120: TRANSACTION_SYSTEM_ID NUMBER := FND_API.G_MISS_NUM,
121: SELLABLE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
122: VERSION_LABEL VARCHAR2(240) := FND_API.G_MISS_CHAR,
123: RETURN_BY_DATE DATE := FND_API.G_MISS_DATE,
124: ACTIVE_START_DATE DATE := FND_API.G_MISS_DATE,
125: ACTIVE_END_DATE DATE := FND_API.G_MISS_DATE,
126: PRESERVE_DETAIL_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
119: EXTERNAL_REFERENCE VARCHAR2(30) := FND_API.G_MISS_CHAR,
120: TRANSACTION_SYSTEM_ID NUMBER := FND_API.G_MISS_NUM,
121: SELLABLE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
122: VERSION_LABEL VARCHAR2(240) := FND_API.G_MISS_CHAR,
123: RETURN_BY_DATE DATE := FND_API.G_MISS_DATE,
124: ACTIVE_START_DATE DATE := FND_API.G_MISS_DATE,
125: ACTIVE_END_DATE DATE := FND_API.G_MISS_DATE,
126: PRESERVE_DETAIL_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
127: REFERENCE_SOURCE_ID NUMBER := FND_API.G_MISS_NUM,
120: TRANSACTION_SYSTEM_ID NUMBER := FND_API.G_MISS_NUM,
121: SELLABLE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
122: VERSION_LABEL VARCHAR2(240) := FND_API.G_MISS_CHAR,
123: RETURN_BY_DATE DATE := FND_API.G_MISS_DATE,
124: ACTIVE_START_DATE DATE := FND_API.G_MISS_DATE,
125: ACTIVE_END_DATE DATE := FND_API.G_MISS_DATE,
126: PRESERVE_DETAIL_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
127: REFERENCE_SOURCE_ID NUMBER := FND_API.G_MISS_NUM,
128: REFERENCE_SOURCE_LINE_ID NUMBER := FND_API.G_MISS_NUM,-- RMA fulfillment 11.5.9 ER
121: SELLABLE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
122: VERSION_LABEL VARCHAR2(240) := FND_API.G_MISS_CHAR,
123: RETURN_BY_DATE DATE := FND_API.G_MISS_DATE,
124: ACTIVE_START_DATE DATE := FND_API.G_MISS_DATE,
125: ACTIVE_END_DATE DATE := FND_API.G_MISS_DATE,
126: PRESERVE_DETAIL_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
127: REFERENCE_SOURCE_ID NUMBER := FND_API.G_MISS_NUM,
128: REFERENCE_SOURCE_LINE_ID NUMBER := FND_API.G_MISS_NUM,-- RMA fulfillment 11.5.9 ER
129: REFERENCE_SOURCE_DATE DATE := FND_API.G_MISS_DATE,
122: VERSION_LABEL VARCHAR2(240) := FND_API.G_MISS_CHAR,
123: RETURN_BY_DATE DATE := FND_API.G_MISS_DATE,
124: ACTIVE_START_DATE DATE := FND_API.G_MISS_DATE,
125: ACTIVE_END_DATE DATE := FND_API.G_MISS_DATE,
126: PRESERVE_DETAIL_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
127: REFERENCE_SOURCE_ID NUMBER := FND_API.G_MISS_NUM,
128: REFERENCE_SOURCE_LINE_ID NUMBER := FND_API.G_MISS_NUM,-- RMA fulfillment 11.5.9 ER
129: REFERENCE_SOURCE_DATE DATE := FND_API.G_MISS_DATE,
130: CSI_TRANSACTION_ID NUMBER := FND_API.G_MISS_NUM,
123: RETURN_BY_DATE DATE := FND_API.G_MISS_DATE,
124: ACTIVE_START_DATE DATE := FND_API.G_MISS_DATE,
125: ACTIVE_END_DATE DATE := FND_API.G_MISS_DATE,
126: PRESERVE_DETAIL_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
127: REFERENCE_SOURCE_ID NUMBER := FND_API.G_MISS_NUM,
128: REFERENCE_SOURCE_LINE_ID NUMBER := FND_API.G_MISS_NUM,-- RMA fulfillment 11.5.9 ER
129: REFERENCE_SOURCE_DATE DATE := FND_API.G_MISS_DATE,
130: CSI_TRANSACTION_ID NUMBER := FND_API.G_MISS_NUM,
131: SOURCE_TXN_LINE_DETAIL_ID NUMBER := FND_API.G_MISS_NUM,
124: ACTIVE_START_DATE DATE := FND_API.G_MISS_DATE,
125: ACTIVE_END_DATE DATE := FND_API.G_MISS_DATE,
126: PRESERVE_DETAIL_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
127: REFERENCE_SOURCE_ID NUMBER := FND_API.G_MISS_NUM,
128: REFERENCE_SOURCE_LINE_ID NUMBER := FND_API.G_MISS_NUM,-- RMA fulfillment 11.5.9 ER
129: REFERENCE_SOURCE_DATE DATE := FND_API.G_MISS_DATE,
130: CSI_TRANSACTION_ID NUMBER := FND_API.G_MISS_NUM,
131: SOURCE_TXN_LINE_DETAIL_ID NUMBER := FND_API.G_MISS_NUM,
132: INV_MTL_TRANSACTION_ID NUMBER := FND_API.G_MISS_NUM,
125: ACTIVE_END_DATE DATE := FND_API.G_MISS_DATE,
126: PRESERVE_DETAIL_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
127: REFERENCE_SOURCE_ID NUMBER := FND_API.G_MISS_NUM,
128: REFERENCE_SOURCE_LINE_ID NUMBER := FND_API.G_MISS_NUM,-- RMA fulfillment 11.5.9 ER
129: REFERENCE_SOURCE_DATE DATE := FND_API.G_MISS_DATE,
130: CSI_TRANSACTION_ID NUMBER := FND_API.G_MISS_NUM,
131: SOURCE_TXN_LINE_DETAIL_ID NUMBER := FND_API.G_MISS_NUM,
132: INV_MTL_TRANSACTION_ID NUMBER := FND_API.G_MISS_NUM,
133: PROCESSING_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
126: PRESERVE_DETAIL_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
127: REFERENCE_SOURCE_ID NUMBER := FND_API.G_MISS_NUM,
128: REFERENCE_SOURCE_LINE_ID NUMBER := FND_API.G_MISS_NUM,-- RMA fulfillment 11.5.9 ER
129: REFERENCE_SOURCE_DATE DATE := FND_API.G_MISS_DATE,
130: CSI_TRANSACTION_ID NUMBER := FND_API.G_MISS_NUM,
131: SOURCE_TXN_LINE_DETAIL_ID NUMBER := FND_API.G_MISS_NUM,
132: INV_MTL_TRANSACTION_ID NUMBER := FND_API.G_MISS_NUM,
133: PROCESSING_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
134: ERROR_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
127: REFERENCE_SOURCE_ID NUMBER := FND_API.G_MISS_NUM,
128: REFERENCE_SOURCE_LINE_ID NUMBER := FND_API.G_MISS_NUM,-- RMA fulfillment 11.5.9 ER
129: REFERENCE_SOURCE_DATE DATE := FND_API.G_MISS_DATE,
130: CSI_TRANSACTION_ID NUMBER := FND_API.G_MISS_NUM,
131: SOURCE_TXN_LINE_DETAIL_ID NUMBER := FND_API.G_MISS_NUM,
132: INV_MTL_TRANSACTION_ID NUMBER := FND_API.G_MISS_NUM,
133: PROCESSING_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
134: ERROR_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
135: ERROR_EXPLANATION VARCHAR2(240) := FND_API.G_MISS_CHAR,
128: REFERENCE_SOURCE_LINE_ID NUMBER := FND_API.G_MISS_NUM,-- RMA fulfillment 11.5.9 ER
129: REFERENCE_SOURCE_DATE DATE := FND_API.G_MISS_DATE,
130: CSI_TRANSACTION_ID NUMBER := FND_API.G_MISS_NUM,
131: SOURCE_TXN_LINE_DETAIL_ID NUMBER := FND_API.G_MISS_NUM,
132: INV_MTL_TRANSACTION_ID NUMBER := FND_API.G_MISS_NUM,
133: PROCESSING_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
134: ERROR_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
135: ERROR_EXPLANATION VARCHAR2(240) := FND_API.G_MISS_CHAR,
136: TXN_SYSTEMS_INDEX NUMBER := FND_API.G_MISS_NUM,
129: REFERENCE_SOURCE_DATE DATE := FND_API.G_MISS_DATE,
130: CSI_TRANSACTION_ID NUMBER := FND_API.G_MISS_NUM,
131: SOURCE_TXN_LINE_DETAIL_ID NUMBER := FND_API.G_MISS_NUM,
132: INV_MTL_TRANSACTION_ID NUMBER := FND_API.G_MISS_NUM,
133: PROCESSING_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
134: ERROR_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
135: ERROR_EXPLANATION VARCHAR2(240) := FND_API.G_MISS_CHAR,
136: TXN_SYSTEMS_INDEX NUMBER := FND_API.G_MISS_NUM,
137: -- Added for CZ Integration (Begin)
130: CSI_TRANSACTION_ID NUMBER := FND_API.G_MISS_NUM,
131: SOURCE_TXN_LINE_DETAIL_ID NUMBER := FND_API.G_MISS_NUM,
132: INV_MTL_TRANSACTION_ID NUMBER := FND_API.G_MISS_NUM,
133: PROCESSING_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
134: ERROR_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
135: ERROR_EXPLANATION VARCHAR2(240) := FND_API.G_MISS_CHAR,
136: TXN_SYSTEMS_INDEX NUMBER := FND_API.G_MISS_NUM,
137: -- Added for CZ Integration (Begin)
138: CONFIG_INST_HDR_ID NUMBER := FND_API.G_MISS_NUM,
131: SOURCE_TXN_LINE_DETAIL_ID NUMBER := FND_API.G_MISS_NUM,
132: INV_MTL_TRANSACTION_ID NUMBER := FND_API.G_MISS_NUM,
133: PROCESSING_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
134: ERROR_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
135: ERROR_EXPLANATION VARCHAR2(240) := FND_API.G_MISS_CHAR,
136: TXN_SYSTEMS_INDEX NUMBER := FND_API.G_MISS_NUM,
137: -- Added for CZ Integration (Begin)
138: CONFIG_INST_HDR_ID NUMBER := FND_API.G_MISS_NUM,
139: CONFIG_INST_REV_NUM NUMBER := FND_API.G_MISS_NUM,
132: INV_MTL_TRANSACTION_ID NUMBER := FND_API.G_MISS_NUM,
133: PROCESSING_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
134: ERROR_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
135: ERROR_EXPLANATION VARCHAR2(240) := FND_API.G_MISS_CHAR,
136: TXN_SYSTEMS_INDEX NUMBER := FND_API.G_MISS_NUM,
137: -- Added for CZ Integration (Begin)
138: CONFIG_INST_HDR_ID NUMBER := FND_API.G_MISS_NUM,
139: CONFIG_INST_REV_NUM NUMBER := FND_API.G_MISS_NUM,
140: CONFIG_INST_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
134: ERROR_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
135: ERROR_EXPLANATION VARCHAR2(240) := FND_API.G_MISS_CHAR,
136: TXN_SYSTEMS_INDEX NUMBER := FND_API.G_MISS_NUM,
137: -- Added for CZ Integration (Begin)
138: CONFIG_INST_HDR_ID NUMBER := FND_API.G_MISS_NUM,
139: CONFIG_INST_REV_NUM NUMBER := FND_API.G_MISS_NUM,
140: CONFIG_INST_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
141: CONFIG_INST_BASELINE_REV_NUM NUMBER := FND_API.G_MISS_NUM,
142: TARGET_COMMITMENT_DATE DATE := FND_API.G_MISS_DATE,
135: ERROR_EXPLANATION VARCHAR2(240) := FND_API.G_MISS_CHAR,
136: TXN_SYSTEMS_INDEX NUMBER := FND_API.G_MISS_NUM,
137: -- Added for CZ Integration (Begin)
138: CONFIG_INST_HDR_ID NUMBER := FND_API.G_MISS_NUM,
139: CONFIG_INST_REV_NUM NUMBER := FND_API.G_MISS_NUM,
140: CONFIG_INST_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
141: CONFIG_INST_BASELINE_REV_NUM NUMBER := FND_API.G_MISS_NUM,
142: TARGET_COMMITMENT_DATE DATE := FND_API.G_MISS_DATE,
143: INSTANCE_DESCRIPTION VARCHAR2(240) := FND_API.G_MISS_CHAR,
136: TXN_SYSTEMS_INDEX NUMBER := FND_API.G_MISS_NUM,
137: -- Added for CZ Integration (Begin)
138: CONFIG_INST_HDR_ID NUMBER := FND_API.G_MISS_NUM,
139: CONFIG_INST_REV_NUM NUMBER := FND_API.G_MISS_NUM,
140: CONFIG_INST_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
141: CONFIG_INST_BASELINE_REV_NUM NUMBER := FND_API.G_MISS_NUM,
142: TARGET_COMMITMENT_DATE DATE := FND_API.G_MISS_DATE,
143: INSTANCE_DESCRIPTION VARCHAR2(240) := FND_API.G_MISS_CHAR,
144: API_CALLER_IDENTITY VARCHAR2(15) := 'OTHER',
137: -- Added for CZ Integration (Begin)
138: CONFIG_INST_HDR_ID NUMBER := FND_API.G_MISS_NUM,
139: CONFIG_INST_REV_NUM NUMBER := FND_API.G_MISS_NUM,
140: CONFIG_INST_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
141: CONFIG_INST_BASELINE_REV_NUM NUMBER := FND_API.G_MISS_NUM,
142: TARGET_COMMITMENT_DATE DATE := FND_API.G_MISS_DATE,
143: INSTANCE_DESCRIPTION VARCHAR2(240) := FND_API.G_MISS_CHAR,
144: API_CALLER_IDENTITY VARCHAR2(15) := 'OTHER',
145: -- Added for CZ Integration (End)
138: CONFIG_INST_HDR_ID NUMBER := FND_API.G_MISS_NUM,
139: CONFIG_INST_REV_NUM NUMBER := FND_API.G_MISS_NUM,
140: CONFIG_INST_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
141: CONFIG_INST_BASELINE_REV_NUM NUMBER := FND_API.G_MISS_NUM,
142: TARGET_COMMITMENT_DATE DATE := FND_API.G_MISS_DATE,
143: INSTANCE_DESCRIPTION VARCHAR2(240) := FND_API.G_MISS_CHAR,
144: API_CALLER_IDENTITY VARCHAR2(15) := 'OTHER',
145: -- Added for CZ Integration (End)
146: -- Added for Partner Ordering (Begin)
139: CONFIG_INST_REV_NUM NUMBER := FND_API.G_MISS_NUM,
140: CONFIG_INST_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
141: CONFIG_INST_BASELINE_REV_NUM NUMBER := FND_API.G_MISS_NUM,
142: TARGET_COMMITMENT_DATE DATE := FND_API.G_MISS_DATE,
143: INSTANCE_DESCRIPTION VARCHAR2(240) := FND_API.G_MISS_CHAR,
144: API_CALLER_IDENTITY VARCHAR2(15) := 'OTHER',
145: -- Added for CZ Integration (End)
146: -- Added for Partner Ordering (Begin)
147: INSTALL_LOCATION_TYPE_CODE VARCHAR2(60) := FND_API.G_MISS_CHAR,
143: INSTANCE_DESCRIPTION VARCHAR2(240) := FND_API.G_MISS_CHAR,
144: API_CALLER_IDENTITY VARCHAR2(15) := 'OTHER',
145: -- Added for CZ Integration (End)
146: -- Added for Partner Ordering (Begin)
147: INSTALL_LOCATION_TYPE_CODE VARCHAR2(60) := FND_API.G_MISS_CHAR,
148: INSTALL_LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
149: -- Added for Partner Ordering (End)
150: CASCADE_OWNER_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR, -- bug 2972082
151: CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
144: API_CALLER_IDENTITY VARCHAR2(15) := 'OTHER',
145: -- Added for CZ Integration (End)
146: -- Added for Partner Ordering (Begin)
147: INSTALL_LOCATION_TYPE_CODE VARCHAR2(60) := FND_API.G_MISS_CHAR,
148: INSTALL_LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
149: -- Added for Partner Ordering (End)
150: CASCADE_OWNER_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR, -- bug 2972082
151: CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
152: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
146: -- Added for Partner Ordering (Begin)
147: INSTALL_LOCATION_TYPE_CODE VARCHAR2(60) := FND_API.G_MISS_CHAR,
148: INSTALL_LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
149: -- Added for Partner Ordering (End)
150: CASCADE_OWNER_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR, -- bug 2972082
151: CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
152: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
153: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
154: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
147: INSTALL_LOCATION_TYPE_CODE VARCHAR2(60) := FND_API.G_MISS_CHAR,
148: INSTALL_LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
149: -- Added for Partner Ordering (End)
150: CASCADE_OWNER_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR, -- bug 2972082
151: CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
152: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
153: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
154: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
155: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
148: INSTALL_LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
149: -- Added for Partner Ordering (End)
150: CASCADE_OWNER_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR, -- bug 2972082
151: CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
152: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
153: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
154: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
155: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
156: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
149: -- Added for Partner Ordering (End)
150: CASCADE_OWNER_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR, -- bug 2972082
151: CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
152: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
153: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
154: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
155: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
156: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
157: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
150: CASCADE_OWNER_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR, -- bug 2972082
151: CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
152: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
153: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
154: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
155: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
156: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
157: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
158: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
151: CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
152: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
153: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
154: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
155: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
156: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
157: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
158: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
159: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
152: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
153: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
154: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
155: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
156: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
157: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
158: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
159: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
160: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
153: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
154: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
155: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
156: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
157: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
158: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
159: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
160: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
161: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
154: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
155: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
156: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
157: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
158: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
159: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
160: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
161: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
162: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
155: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
156: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
157: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
158: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
159: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
160: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
161: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
162: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
163: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
156: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
157: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
158: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
159: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
160: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
161: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
162: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
163: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
164: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
157: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
158: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
159: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
160: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
161: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
162: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
163: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
164: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
165: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
158: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
159: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
160: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
161: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
162: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
163: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
164: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
165: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
166: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
159: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
160: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
161: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
162: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
163: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
164: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
165: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
166: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
167: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
160: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
161: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
162: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
163: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
164: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
165: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
166: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
167: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
168: PARENT_INSTANCE_ID NUMBER := FND_API.G_MISS_NUM, -- bug 3479880
161: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
162: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
163: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
164: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
165: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
166: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
167: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
168: PARENT_INSTANCE_ID NUMBER := FND_API.G_MISS_NUM, -- bug 3479880
169: ASSC_TXN_LINE_DETAIL_ID NUMBER := FND_API.G_MISS_NUM, -- bug 3600950
162: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
163: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
164: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
165: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
166: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
167: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
168: PARENT_INSTANCE_ID NUMBER := FND_API.G_MISS_NUM, -- bug 3479880
169: ASSC_TXN_LINE_DETAIL_ID NUMBER := FND_API.G_MISS_NUM, -- bug 3600950
170: OVERRIDING_CSI_TXN_ID NUMBER := FND_API.G_MISS_NUM, -- added for TSO with Equipment R12
163: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
164: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
165: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
166: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
167: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
168: PARENT_INSTANCE_ID NUMBER := FND_API.G_MISS_NUM, -- bug 3479880
169: ASSC_TXN_LINE_DETAIL_ID NUMBER := FND_API.G_MISS_NUM, -- bug 3600950
170: OVERRIDING_CSI_TXN_ID NUMBER := FND_API.G_MISS_NUM, -- added for TSO with Equipment R12
171: INSTANCE_STATUS_ID NUMBER := FND_API.G_MISS_NUM); -- added for Mass Update R12
164: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
165: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
166: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
167: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
168: PARENT_INSTANCE_ID NUMBER := FND_API.G_MISS_NUM, -- bug 3479880
169: ASSC_TXN_LINE_DETAIL_ID NUMBER := FND_API.G_MISS_NUM, -- bug 3600950
170: OVERRIDING_CSI_TXN_ID NUMBER := FND_API.G_MISS_NUM, -- added for TSO with Equipment R12
171: INSTANCE_STATUS_ID NUMBER := FND_API.G_MISS_NUM); -- added for Mass Update R12
172:
165: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
166: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
167: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
168: PARENT_INSTANCE_ID NUMBER := FND_API.G_MISS_NUM, -- bug 3479880
169: ASSC_TXN_LINE_DETAIL_ID NUMBER := FND_API.G_MISS_NUM, -- bug 3600950
170: OVERRIDING_CSI_TXN_ID NUMBER := FND_API.G_MISS_NUM, -- added for TSO with Equipment R12
171: INSTANCE_STATUS_ID NUMBER := FND_API.G_MISS_NUM); -- added for Mass Update R12
172:
173: TYPE txn_line_detail_tbl is TABLE OF txn_line_detail_rec
166: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
167: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
168: PARENT_INSTANCE_ID NUMBER := FND_API.G_MISS_NUM, -- bug 3479880
169: ASSC_TXN_LINE_DETAIL_ID NUMBER := FND_API.G_MISS_NUM, -- bug 3600950
170: OVERRIDING_CSI_TXN_ID NUMBER := FND_API.G_MISS_NUM, -- added for TSO with Equipment R12
171: INSTANCE_STATUS_ID NUMBER := FND_API.G_MISS_NUM); -- added for Mass Update R12
172:
173: TYPE txn_line_detail_tbl is TABLE OF txn_line_detail_rec
174: INDEX BY BINARY_INTEGER;
167: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
168: PARENT_INSTANCE_ID NUMBER := FND_API.G_MISS_NUM, -- bug 3479880
169: ASSC_TXN_LINE_DETAIL_ID NUMBER := FND_API.G_MISS_NUM, -- bug 3600950
170: OVERRIDING_CSI_TXN_ID NUMBER := FND_API.G_MISS_NUM, -- added for TSO with Equipment R12
171: INSTANCE_STATUS_ID NUMBER := FND_API.G_MISS_NUM); -- added for Mass Update R12
172:
173: TYPE txn_line_detail_tbl is TABLE OF txn_line_detail_rec
174: INDEX BY BINARY_INTEGER;
175:
180: -- Description : record to hold information about an transaction
181: -- detail-party relationship.
182:
183: TYPE txn_party_detail_rec IS RECORD (
184: TXN_PARTY_DETAIL_ID NUMBER := FND_API.G_MISS_NUM,
185: TXN_LINE_DETAIL_ID NUMBER := FND_API.G_MISS_NUM,
186: INSTANCE_PARTY_ID NUMBER := FND_API.G_MISS_NUM,
187: PARTY_SOURCE_TABLE VARCHAR2(30) := FND_API.G_MISS_CHAR,
188: PARTY_SOURCE_ID NUMBER := FND_API.G_MISS_NUM,
181: -- detail-party relationship.
182:
183: TYPE txn_party_detail_rec IS RECORD (
184: TXN_PARTY_DETAIL_ID NUMBER := FND_API.G_MISS_NUM,
185: TXN_LINE_DETAIL_ID NUMBER := FND_API.G_MISS_NUM,
186: INSTANCE_PARTY_ID NUMBER := FND_API.G_MISS_NUM,
187: PARTY_SOURCE_TABLE VARCHAR2(30) := FND_API.G_MISS_CHAR,
188: PARTY_SOURCE_ID NUMBER := FND_API.G_MISS_NUM,
189: RELATIONSHIP_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
182:
183: TYPE txn_party_detail_rec IS RECORD (
184: TXN_PARTY_DETAIL_ID NUMBER := FND_API.G_MISS_NUM,
185: TXN_LINE_DETAIL_ID NUMBER := FND_API.G_MISS_NUM,
186: INSTANCE_PARTY_ID NUMBER := FND_API.G_MISS_NUM,
187: PARTY_SOURCE_TABLE VARCHAR2(30) := FND_API.G_MISS_CHAR,
188: PARTY_SOURCE_ID NUMBER := FND_API.G_MISS_NUM,
189: RELATIONSHIP_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
190: CONTACT_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
183: TYPE txn_party_detail_rec IS RECORD (
184: TXN_PARTY_DETAIL_ID NUMBER := FND_API.G_MISS_NUM,
185: TXN_LINE_DETAIL_ID NUMBER := FND_API.G_MISS_NUM,
186: INSTANCE_PARTY_ID NUMBER := FND_API.G_MISS_NUM,
187: PARTY_SOURCE_TABLE VARCHAR2(30) := FND_API.G_MISS_CHAR,
188: PARTY_SOURCE_ID NUMBER := FND_API.G_MISS_NUM,
189: RELATIONSHIP_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
190: CONTACT_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
191: CONTACT_PARTY_ID NUMBER := FND_API.G_MISS_NUM,
184: TXN_PARTY_DETAIL_ID NUMBER := FND_API.G_MISS_NUM,
185: TXN_LINE_DETAIL_ID NUMBER := FND_API.G_MISS_NUM,
186: INSTANCE_PARTY_ID NUMBER := FND_API.G_MISS_NUM,
187: PARTY_SOURCE_TABLE VARCHAR2(30) := FND_API.G_MISS_CHAR,
188: PARTY_SOURCE_ID NUMBER := FND_API.G_MISS_NUM,
189: RELATIONSHIP_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
190: CONTACT_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
191: CONTACT_PARTY_ID NUMBER := FND_API.G_MISS_NUM,
192: ACTIVE_START_DATE DATE := FND_API.G_MISS_DATE,
185: TXN_LINE_DETAIL_ID NUMBER := FND_API.G_MISS_NUM,
186: INSTANCE_PARTY_ID NUMBER := FND_API.G_MISS_NUM,
187: PARTY_SOURCE_TABLE VARCHAR2(30) := FND_API.G_MISS_CHAR,
188: PARTY_SOURCE_ID NUMBER := FND_API.G_MISS_NUM,
189: RELATIONSHIP_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
190: CONTACT_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
191: CONTACT_PARTY_ID NUMBER := FND_API.G_MISS_NUM,
192: ACTIVE_START_DATE DATE := FND_API.G_MISS_DATE,
193: ACTIVE_END_DATE DATE := FND_API.G_MISS_DATE,
186: INSTANCE_PARTY_ID NUMBER := FND_API.G_MISS_NUM,
187: PARTY_SOURCE_TABLE VARCHAR2(30) := FND_API.G_MISS_CHAR,
188: PARTY_SOURCE_ID NUMBER := FND_API.G_MISS_NUM,
189: RELATIONSHIP_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
190: CONTACT_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
191: CONTACT_PARTY_ID NUMBER := FND_API.G_MISS_NUM,
192: ACTIVE_START_DATE DATE := FND_API.G_MISS_DATE,
193: ACTIVE_END_DATE DATE := FND_API.G_MISS_DATE,
194: PRESERVE_DETAIL_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
187: PARTY_SOURCE_TABLE VARCHAR2(30) := FND_API.G_MISS_CHAR,
188: PARTY_SOURCE_ID NUMBER := FND_API.G_MISS_NUM,
189: RELATIONSHIP_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
190: CONTACT_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
191: CONTACT_PARTY_ID NUMBER := FND_API.G_MISS_NUM,
192: ACTIVE_START_DATE DATE := FND_API.G_MISS_DATE,
193: ACTIVE_END_DATE DATE := FND_API.G_MISS_DATE,
194: PRESERVE_DETAIL_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
195: CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
188: PARTY_SOURCE_ID NUMBER := FND_API.G_MISS_NUM,
189: RELATIONSHIP_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
190: CONTACT_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
191: CONTACT_PARTY_ID NUMBER := FND_API.G_MISS_NUM,
192: ACTIVE_START_DATE DATE := FND_API.G_MISS_DATE,
193: ACTIVE_END_DATE DATE := FND_API.G_MISS_DATE,
194: PRESERVE_DETAIL_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
195: CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
196: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
189: RELATIONSHIP_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
190: CONTACT_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
191: CONTACT_PARTY_ID NUMBER := FND_API.G_MISS_NUM,
192: ACTIVE_START_DATE DATE := FND_API.G_MISS_DATE,
193: ACTIVE_END_DATE DATE := FND_API.G_MISS_DATE,
194: PRESERVE_DETAIL_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
195: CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
196: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
197: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
190: CONTACT_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
191: CONTACT_PARTY_ID NUMBER := FND_API.G_MISS_NUM,
192: ACTIVE_START_DATE DATE := FND_API.G_MISS_DATE,
193: ACTIVE_END_DATE DATE := FND_API.G_MISS_DATE,
194: PRESERVE_DETAIL_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
195: CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
196: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
197: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
198: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
191: CONTACT_PARTY_ID NUMBER := FND_API.G_MISS_NUM,
192: ACTIVE_START_DATE DATE := FND_API.G_MISS_DATE,
193: ACTIVE_END_DATE DATE := FND_API.G_MISS_DATE,
194: PRESERVE_DETAIL_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
195: CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
196: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
197: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
198: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
199: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
192: ACTIVE_START_DATE DATE := FND_API.G_MISS_DATE,
193: ACTIVE_END_DATE DATE := FND_API.G_MISS_DATE,
194: PRESERVE_DETAIL_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
195: CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
196: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
197: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
198: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
199: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
200: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
193: ACTIVE_END_DATE DATE := FND_API.G_MISS_DATE,
194: PRESERVE_DETAIL_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
195: CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
196: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
197: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
198: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
199: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
200: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
201: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
194: PRESERVE_DETAIL_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
195: CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
196: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
197: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
198: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
199: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
200: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
201: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
202: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
195: CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
196: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
197: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
198: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
199: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
200: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
201: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
202: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
203: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
196: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
197: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
198: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
199: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
200: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
201: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
202: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
203: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
204: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
197: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
198: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
199: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
200: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
201: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
202: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
203: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
204: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
205: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
198: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
199: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
200: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
201: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
202: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
203: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
204: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
205: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
206: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
199: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
200: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
201: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
202: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
203: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
204: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
205: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
206: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
207: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
200: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
201: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
202: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
203: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
204: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
205: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
206: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
207: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
208: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
201: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
202: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
203: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
204: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
205: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
206: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
207: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
208: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
209: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
202: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
203: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
204: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
205: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
206: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
207: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
208: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
209: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
210: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
203: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
204: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
205: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
206: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
207: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
208: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
209: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
210: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
211: TXN_LINE_DETAILS_INDEX NUMBER := FND_API.G_MISS_NUM,
204: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
205: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
206: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
207: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
208: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
209: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
210: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
211: TXN_LINE_DETAILS_INDEX NUMBER := FND_API.G_MISS_NUM,
212: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
205: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
206: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
207: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
208: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
209: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
210: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
211: TXN_LINE_DETAILS_INDEX NUMBER := FND_API.G_MISS_NUM,
212: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
213: PRIMARY_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
206: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
207: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
208: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
209: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
210: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
211: TXN_LINE_DETAILS_INDEX NUMBER := FND_API.G_MISS_NUM,
212: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
213: PRIMARY_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
214: PREFERRED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
207: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
208: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
209: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
210: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
211: TXN_LINE_DETAILS_INDEX NUMBER := FND_API.G_MISS_NUM,
212: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
213: PRIMARY_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
214: PREFERRED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
215: TXN_CONTACT_PARTY_INDEX NUMBER := FND_API.G_MISS_NUM);--added for R12 Mass update tech. requirement
208: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
209: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
210: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
211: TXN_LINE_DETAILS_INDEX NUMBER := FND_API.G_MISS_NUM,
212: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
213: PRIMARY_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
214: PREFERRED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
215: TXN_CONTACT_PARTY_INDEX NUMBER := FND_API.G_MISS_NUM);--added for R12 Mass update tech. requirement
216:
209: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
210: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
211: TXN_LINE_DETAILS_INDEX NUMBER := FND_API.G_MISS_NUM,
212: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
213: PRIMARY_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
214: PREFERRED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
215: TXN_CONTACT_PARTY_INDEX NUMBER := FND_API.G_MISS_NUM);--added for R12 Mass update tech. requirement
216:
217: TYPE txn_party_detail_tbl IS TABLE OF txn_party_detail_rec
210: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
211: TXN_LINE_DETAILS_INDEX NUMBER := FND_API.G_MISS_NUM,
212: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
213: PRIMARY_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
214: PREFERRED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
215: TXN_CONTACT_PARTY_INDEX NUMBER := FND_API.G_MISS_NUM);--added for R12 Mass update tech. requirement
216:
217: TYPE txn_party_detail_tbl IS TABLE OF txn_party_detail_rec
218: INDEX BY BINARY_INTEGER;
211: TXN_LINE_DETAILS_INDEX NUMBER := FND_API.G_MISS_NUM,
212: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
213: PRIMARY_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
214: PREFERRED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
215: TXN_CONTACT_PARTY_INDEX NUMBER := FND_API.G_MISS_NUM);--added for R12 Mass update tech. requirement
216:
217: TYPE txn_party_detail_tbl IS TABLE OF txn_party_detail_rec
218: INDEX BY BINARY_INTEGER;
219:
224: -- Description : record to hold information about an transaction
225: -- party detail-account relationship.
226:
227: TYPE txn_pty_acct_detail_rec IS RECORD (
228: TXN_ACCOUNT_DETAIL_ID NUMBER := FND_API.G_MISS_NUM,
229: TXN_PARTY_DETAIL_ID NUMBER := FND_API.G_MISS_NUM,
230: IP_ACCOUNT_ID NUMBER := FND_API.G_MISS_NUM,
231: ACCOUNT_ID NUMBER := FND_API.G_MISS_NUM,
232: RELATIONSHIP_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
225: -- party detail-account relationship.
226:
227: TYPE txn_pty_acct_detail_rec IS RECORD (
228: TXN_ACCOUNT_DETAIL_ID NUMBER := FND_API.G_MISS_NUM,
229: TXN_PARTY_DETAIL_ID NUMBER := FND_API.G_MISS_NUM,
230: IP_ACCOUNT_ID NUMBER := FND_API.G_MISS_NUM,
231: ACCOUNT_ID NUMBER := FND_API.G_MISS_NUM,
232: RELATIONSHIP_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
233: BILL_TO_ADDRESS_ID NUMBER := FND_API.G_MISS_NUM,
226:
227: TYPE txn_pty_acct_detail_rec IS RECORD (
228: TXN_ACCOUNT_DETAIL_ID NUMBER := FND_API.G_MISS_NUM,
229: TXN_PARTY_DETAIL_ID NUMBER := FND_API.G_MISS_NUM,
230: IP_ACCOUNT_ID NUMBER := FND_API.G_MISS_NUM,
231: ACCOUNT_ID NUMBER := FND_API.G_MISS_NUM,
232: RELATIONSHIP_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
233: BILL_TO_ADDRESS_ID NUMBER := FND_API.G_MISS_NUM,
234: SHIP_TO_ADDRESS_ID NUMBER := FND_API.G_MISS_NUM,
227: TYPE txn_pty_acct_detail_rec IS RECORD (
228: TXN_ACCOUNT_DETAIL_ID NUMBER := FND_API.G_MISS_NUM,
229: TXN_PARTY_DETAIL_ID NUMBER := FND_API.G_MISS_NUM,
230: IP_ACCOUNT_ID NUMBER := FND_API.G_MISS_NUM,
231: ACCOUNT_ID NUMBER := FND_API.G_MISS_NUM,
232: RELATIONSHIP_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
233: BILL_TO_ADDRESS_ID NUMBER := FND_API.G_MISS_NUM,
234: SHIP_TO_ADDRESS_ID NUMBER := FND_API.G_MISS_NUM,
235: ACTIVE_START_DATE DATE := FND_API.G_MISS_DATE,
228: TXN_ACCOUNT_DETAIL_ID NUMBER := FND_API.G_MISS_NUM,
229: TXN_PARTY_DETAIL_ID NUMBER := FND_API.G_MISS_NUM,
230: IP_ACCOUNT_ID NUMBER := FND_API.G_MISS_NUM,
231: ACCOUNT_ID NUMBER := FND_API.G_MISS_NUM,
232: RELATIONSHIP_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
233: BILL_TO_ADDRESS_ID NUMBER := FND_API.G_MISS_NUM,
234: SHIP_TO_ADDRESS_ID NUMBER := FND_API.G_MISS_NUM,
235: ACTIVE_START_DATE DATE := FND_API.G_MISS_DATE,
236: ACTIVE_END_DATE DATE := FND_API.G_MISS_DATE,
229: TXN_PARTY_DETAIL_ID NUMBER := FND_API.G_MISS_NUM,
230: IP_ACCOUNT_ID NUMBER := FND_API.G_MISS_NUM,
231: ACCOUNT_ID NUMBER := FND_API.G_MISS_NUM,
232: RELATIONSHIP_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
233: BILL_TO_ADDRESS_ID NUMBER := FND_API.G_MISS_NUM,
234: SHIP_TO_ADDRESS_ID NUMBER := FND_API.G_MISS_NUM,
235: ACTIVE_START_DATE DATE := FND_API.G_MISS_DATE,
236: ACTIVE_END_DATE DATE := FND_API.G_MISS_DATE,
237: PRESERVE_DETAIL_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
230: IP_ACCOUNT_ID NUMBER := FND_API.G_MISS_NUM,
231: ACCOUNT_ID NUMBER := FND_API.G_MISS_NUM,
232: RELATIONSHIP_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
233: BILL_TO_ADDRESS_ID NUMBER := FND_API.G_MISS_NUM,
234: SHIP_TO_ADDRESS_ID NUMBER := FND_API.G_MISS_NUM,
235: ACTIVE_START_DATE DATE := FND_API.G_MISS_DATE,
236: ACTIVE_END_DATE DATE := FND_API.G_MISS_DATE,
237: PRESERVE_DETAIL_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
238: CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
231: ACCOUNT_ID NUMBER := FND_API.G_MISS_NUM,
232: RELATIONSHIP_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
233: BILL_TO_ADDRESS_ID NUMBER := FND_API.G_MISS_NUM,
234: SHIP_TO_ADDRESS_ID NUMBER := FND_API.G_MISS_NUM,
235: ACTIVE_START_DATE DATE := FND_API.G_MISS_DATE,
236: ACTIVE_END_DATE DATE := FND_API.G_MISS_DATE,
237: PRESERVE_DETAIL_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
238: CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
239: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
232: RELATIONSHIP_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
233: BILL_TO_ADDRESS_ID NUMBER := FND_API.G_MISS_NUM,
234: SHIP_TO_ADDRESS_ID NUMBER := FND_API.G_MISS_NUM,
235: ACTIVE_START_DATE DATE := FND_API.G_MISS_DATE,
236: ACTIVE_END_DATE DATE := FND_API.G_MISS_DATE,
237: PRESERVE_DETAIL_FLAG VARCHAR2(1) := 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,
233: BILL_TO_ADDRESS_ID NUMBER := FND_API.G_MISS_NUM,
234: SHIP_TO_ADDRESS_ID NUMBER := FND_API.G_MISS_NUM,
235: ACTIVE_START_DATE DATE := FND_API.G_MISS_DATE,
236: ACTIVE_END_DATE DATE := FND_API.G_MISS_DATE,
237: PRESERVE_DETAIL_FLAG VARCHAR2(1) := 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,
234: SHIP_TO_ADDRESS_ID NUMBER := FND_API.G_MISS_NUM,
235: ACTIVE_START_DATE DATE := FND_API.G_MISS_DATE,
236: ACTIVE_END_DATE DATE := FND_API.G_MISS_DATE,
237: PRESERVE_DETAIL_FLAG VARCHAR2(1) := 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,
235: ACTIVE_START_DATE DATE := FND_API.G_MISS_DATE,
236: ACTIVE_END_DATE DATE := FND_API.G_MISS_DATE,
237: PRESERVE_DETAIL_FLAG VARCHAR2(1) := 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,
236: ACTIVE_END_DATE DATE := FND_API.G_MISS_DATE,
237: PRESERVE_DETAIL_FLAG VARCHAR2(1) := 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,
237: PRESERVE_DETAIL_FLAG VARCHAR2(1) := 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,
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: TXN_PARTY_DETAILS_INDEX 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: TXN_PARTY_DETAILS_INDEX NUMBER := FND_API.G_MISS_NUM,
255: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM);
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: TXN_PARTY_DETAILS_INDEX NUMBER := FND_API.G_MISS_NUM,
255: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM);
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: TXN_PARTY_DETAILS_INDEX NUMBER := FND_API.G_MISS_NUM,
255: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM);
256:
257: TYPE txn_pty_acct_detail_tbl IS TABLE OF txn_pty_acct_detail_rec
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: TXN_PARTY_DETAILS_INDEX NUMBER := FND_API.G_MISS_NUM,
255: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM);
256:
257: TYPE txn_pty_acct_detail_tbl IS TABLE OF txn_pty_acct_detail_rec
258: INDEX BY BINARY_INTEGER;
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: TXN_PARTY_DETAILS_INDEX NUMBER := FND_API.G_MISS_NUM,
255: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM);
256:
257: TYPE txn_pty_acct_detail_tbl IS TABLE OF txn_pty_acct_detail_rec
258: INDEX BY BINARY_INTEGER;
259:
264: -- Description : record to hold information about an transaction
265: -- detail-configuration details.
266:
267: TYPE txn_ii_rltns_rec IS RECORD (
268: TXN_RELATIONSHIP_ID NUMBER := FND_API.G_MISS_NUM,
269: TRANSACTION_LINE_ID NUMBER := FND_API.G_MISS_NUM,
270: CSI_INST_RELATIONSHIP_ID NUMBER := FND_API.G_MISS_NUM,
271: SUBJECT_ID NUMBER := FND_API.G_MISS_NUM,
272: ---Added (Start) for m-to-m enhancements
265: -- detail-configuration details.
266:
267: TYPE txn_ii_rltns_rec IS RECORD (
268: TXN_RELATIONSHIP_ID NUMBER := FND_API.G_MISS_NUM,
269: TRANSACTION_LINE_ID NUMBER := FND_API.G_MISS_NUM,
270: CSI_INST_RELATIONSHIP_ID NUMBER := FND_API.G_MISS_NUM,
271: SUBJECT_ID NUMBER := FND_API.G_MISS_NUM,
272: ---Added (Start) for m-to-m enhancements
273: SUBJECT_INDEX_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
266:
267: TYPE txn_ii_rltns_rec IS RECORD (
268: TXN_RELATIONSHIP_ID NUMBER := FND_API.G_MISS_NUM,
269: TRANSACTION_LINE_ID NUMBER := FND_API.G_MISS_NUM,
270: CSI_INST_RELATIONSHIP_ID NUMBER := FND_API.G_MISS_NUM,
271: SUBJECT_ID NUMBER := FND_API.G_MISS_NUM,
272: ---Added (Start) for m-to-m enhancements
273: SUBJECT_INDEX_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
274: SUBJECT_TYPE VARCHAR2(30) := 'T' ,
267: TYPE txn_ii_rltns_rec IS RECORD (
268: TXN_RELATIONSHIP_ID NUMBER := FND_API.G_MISS_NUM,
269: TRANSACTION_LINE_ID NUMBER := FND_API.G_MISS_NUM,
270: CSI_INST_RELATIONSHIP_ID NUMBER := FND_API.G_MISS_NUM,
271: SUBJECT_ID NUMBER := FND_API.G_MISS_NUM,
272: ---Added (Start) for m-to-m enhancements
273: SUBJECT_INDEX_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
274: SUBJECT_TYPE VARCHAR2(30) := 'T' ,
275: ---Added (End) for m-to-m enhancements
269: TRANSACTION_LINE_ID NUMBER := FND_API.G_MISS_NUM,
270: CSI_INST_RELATIONSHIP_ID NUMBER := FND_API.G_MISS_NUM,
271: SUBJECT_ID NUMBER := FND_API.G_MISS_NUM,
272: ---Added (Start) for m-to-m enhancements
273: SUBJECT_INDEX_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
274: SUBJECT_TYPE VARCHAR2(30) := 'T' ,
275: ---Added (End) for m-to-m enhancements
276: OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
277: ---Added (Start) for m-to-m enhancements
272: ---Added (Start) for m-to-m enhancements
273: SUBJECT_INDEX_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
274: SUBJECT_TYPE VARCHAR2(30) := 'T' ,
275: ---Added (End) for m-to-m enhancements
276: OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
277: ---Added (Start) for m-to-m enhancements
278: OBJECT_INDEX_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
279: OBJECT_TYPE VARCHAR2(30) := 'T' ,
280: ---Added (End) for m-to-m enhancements
274: SUBJECT_TYPE VARCHAR2(30) := 'T' ,
275: ---Added (End) for m-to-m enhancements
276: OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
277: ---Added (Start) for m-to-m enhancements
278: OBJECT_INDEX_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
279: OBJECT_TYPE VARCHAR2(30) := 'T' ,
280: ---Added (End) for m-to-m enhancements
281: -- Added for CZ Integration (Begin)
282: SUB_CONFIG_INST_HDR_ID NUMBER := FND_API.G_MISS_NUM,
278: OBJECT_INDEX_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
279: OBJECT_TYPE VARCHAR2(30) := 'T' ,
280: ---Added (End) for m-to-m enhancements
281: -- Added for CZ Integration (Begin)
282: SUB_CONFIG_INST_HDR_ID NUMBER := FND_API.G_MISS_NUM,
283: SUB_CONFIG_INST_REV_NUM NUMBER := FND_API.G_MISS_NUM,
284: SUB_CONFIG_INST_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
285: OBJ_CONFIG_INST_HDR_ID NUMBER := FND_API.G_MISS_NUM,
286: OBJ_CONFIG_INST_REV_NUM NUMBER := FND_API.G_MISS_NUM,
279: OBJECT_TYPE VARCHAR2(30) := 'T' ,
280: ---Added (End) for m-to-m enhancements
281: -- Added for CZ Integration (Begin)
282: SUB_CONFIG_INST_HDR_ID NUMBER := FND_API.G_MISS_NUM,
283: SUB_CONFIG_INST_REV_NUM NUMBER := FND_API.G_MISS_NUM,
284: SUB_CONFIG_INST_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
285: OBJ_CONFIG_INST_HDR_ID NUMBER := FND_API.G_MISS_NUM,
286: OBJ_CONFIG_INST_REV_NUM NUMBER := FND_API.G_MISS_NUM,
287: OBJ_CONFIG_INST_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
280: ---Added (End) for m-to-m enhancements
281: -- Added for CZ Integration (Begin)
282: SUB_CONFIG_INST_HDR_ID NUMBER := FND_API.G_MISS_NUM,
283: SUB_CONFIG_INST_REV_NUM NUMBER := FND_API.G_MISS_NUM,
284: SUB_CONFIG_INST_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
285: OBJ_CONFIG_INST_HDR_ID NUMBER := FND_API.G_MISS_NUM,
286: OBJ_CONFIG_INST_REV_NUM NUMBER := FND_API.G_MISS_NUM,
287: OBJ_CONFIG_INST_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
288: TARGET_COMMITMENT_DATE DATE := FND_API.G_MISS_DATE,
281: -- Added for CZ Integration (Begin)
282: SUB_CONFIG_INST_HDR_ID NUMBER := FND_API.G_MISS_NUM,
283: SUB_CONFIG_INST_REV_NUM NUMBER := FND_API.G_MISS_NUM,
284: SUB_CONFIG_INST_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
285: OBJ_CONFIG_INST_HDR_ID NUMBER := FND_API.G_MISS_NUM,
286: OBJ_CONFIG_INST_REV_NUM NUMBER := FND_API.G_MISS_NUM,
287: OBJ_CONFIG_INST_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
288: TARGET_COMMITMENT_DATE DATE := FND_API.G_MISS_DATE,
289: API_CALLER_IDENTITY VARCHAR2(15) := 'OTHER',
282: SUB_CONFIG_INST_HDR_ID NUMBER := FND_API.G_MISS_NUM,
283: SUB_CONFIG_INST_REV_NUM NUMBER := FND_API.G_MISS_NUM,
284: SUB_CONFIG_INST_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
285: OBJ_CONFIG_INST_HDR_ID NUMBER := FND_API.G_MISS_NUM,
286: OBJ_CONFIG_INST_REV_NUM NUMBER := FND_API.G_MISS_NUM,
287: OBJ_CONFIG_INST_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
288: TARGET_COMMITMENT_DATE DATE := FND_API.G_MISS_DATE,
289: API_CALLER_IDENTITY VARCHAR2(15) := 'OTHER',
290: -- Added for CZ Integration (End)
283: SUB_CONFIG_INST_REV_NUM NUMBER := FND_API.G_MISS_NUM,
284: SUB_CONFIG_INST_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
285: OBJ_CONFIG_INST_HDR_ID NUMBER := FND_API.G_MISS_NUM,
286: OBJ_CONFIG_INST_REV_NUM NUMBER := FND_API.G_MISS_NUM,
287: OBJ_CONFIG_INST_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
288: TARGET_COMMITMENT_DATE DATE := FND_API.G_MISS_DATE,
289: API_CALLER_IDENTITY VARCHAR2(15) := 'OTHER',
290: -- Added for CZ Integration (End)
291: RELATIONSHIP_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
284: SUB_CONFIG_INST_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
285: OBJ_CONFIG_INST_HDR_ID NUMBER := FND_API.G_MISS_NUM,
286: OBJ_CONFIG_INST_REV_NUM NUMBER := FND_API.G_MISS_NUM,
287: OBJ_CONFIG_INST_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
288: TARGET_COMMITMENT_DATE DATE := FND_API.G_MISS_DATE,
289: API_CALLER_IDENTITY VARCHAR2(15) := 'OTHER',
290: -- Added for CZ Integration (End)
291: RELATIONSHIP_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
292: DISPLAY_ORDER NUMBER := FND_API.G_MISS_NUM,
287: OBJ_CONFIG_INST_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
288: TARGET_COMMITMENT_DATE DATE := FND_API.G_MISS_DATE,
289: API_CALLER_IDENTITY VARCHAR2(15) := 'OTHER',
290: -- Added for CZ Integration (End)
291: RELATIONSHIP_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
292: DISPLAY_ORDER NUMBER := FND_API.G_MISS_NUM,
293: POSITION_REFERENCE VARCHAR2(30) := FND_API.G_MISS_CHAR,
294: MANDATORY_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
295: ACTIVE_START_DATE DATE := FND_API.G_MISS_DATE,
288: TARGET_COMMITMENT_DATE DATE := FND_API.G_MISS_DATE,
289: API_CALLER_IDENTITY VARCHAR2(15) := 'OTHER',
290: -- Added for CZ Integration (End)
291: RELATIONSHIP_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
292: DISPLAY_ORDER NUMBER := FND_API.G_MISS_NUM,
293: POSITION_REFERENCE VARCHAR2(30) := FND_API.G_MISS_CHAR,
294: MANDATORY_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
295: ACTIVE_START_DATE DATE := FND_API.G_MISS_DATE,
296: ACTIVE_END_DATE DATE := FND_API.G_MISS_DATE,
289: API_CALLER_IDENTITY VARCHAR2(15) := 'OTHER',
290: -- Added for CZ Integration (End)
291: RELATIONSHIP_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
292: DISPLAY_ORDER NUMBER := FND_API.G_MISS_NUM,
293: POSITION_REFERENCE VARCHAR2(30) := FND_API.G_MISS_CHAR,
294: MANDATORY_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
295: ACTIVE_START_DATE DATE := FND_API.G_MISS_DATE,
296: ACTIVE_END_DATE DATE := FND_API.G_MISS_DATE,
297: CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
290: -- Added for CZ Integration (End)
291: RELATIONSHIP_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
292: DISPLAY_ORDER NUMBER := FND_API.G_MISS_NUM,
293: POSITION_REFERENCE VARCHAR2(30) := FND_API.G_MISS_CHAR,
294: MANDATORY_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
295: ACTIVE_START_DATE DATE := FND_API.G_MISS_DATE,
296: ACTIVE_END_DATE DATE := FND_API.G_MISS_DATE,
297: CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
298: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
291: RELATIONSHIP_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
292: DISPLAY_ORDER NUMBER := FND_API.G_MISS_NUM,
293: POSITION_REFERENCE VARCHAR2(30) := FND_API.G_MISS_CHAR,
294: MANDATORY_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
295: ACTIVE_START_DATE DATE := FND_API.G_MISS_DATE,
296: ACTIVE_END_DATE DATE := FND_API.G_MISS_DATE,
297: CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
298: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
299: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
292: DISPLAY_ORDER NUMBER := FND_API.G_MISS_NUM,
293: POSITION_REFERENCE VARCHAR2(30) := FND_API.G_MISS_CHAR,
294: MANDATORY_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
295: ACTIVE_START_DATE DATE := FND_API.G_MISS_DATE,
296: ACTIVE_END_DATE DATE := FND_API.G_MISS_DATE,
297: CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
298: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
299: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
300: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
293: POSITION_REFERENCE VARCHAR2(30) := FND_API.G_MISS_CHAR,
294: MANDATORY_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
295: ACTIVE_START_DATE DATE := FND_API.G_MISS_DATE,
296: ACTIVE_END_DATE DATE := FND_API.G_MISS_DATE,
297: CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
298: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
299: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
300: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
301: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
294: MANDATORY_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
295: ACTIVE_START_DATE DATE := FND_API.G_MISS_DATE,
296: ACTIVE_END_DATE DATE := FND_API.G_MISS_DATE,
297: CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
298: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
299: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
300: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
301: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
302: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
295: ACTIVE_START_DATE DATE := FND_API.G_MISS_DATE,
296: ACTIVE_END_DATE DATE := FND_API.G_MISS_DATE,
297: CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
298: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
299: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
300: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
301: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
302: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
303: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
296: ACTIVE_END_DATE DATE := FND_API.G_MISS_DATE,
297: CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
298: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
299: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
300: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
301: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
302: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
303: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
304: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
297: CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
298: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
299: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
300: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
301: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
302: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
303: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
304: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
305: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
298: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
299: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
300: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
301: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
302: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
303: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
304: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
305: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
306: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
299: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
300: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
301: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
302: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
303: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
304: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
305: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
306: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
307: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
300: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
301: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
302: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
303: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
304: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
305: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
306: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
307: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
308: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
301: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
302: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
303: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
304: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
305: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
306: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
307: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
308: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
309: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
302: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
303: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
304: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
305: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
306: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
307: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
308: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
309: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
310: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
303: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
304: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
305: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
306: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
307: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
308: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
309: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
310: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
311: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
304: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
305: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
306: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
307: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
308: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
309: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
310: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
311: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
312: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
305: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
306: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
307: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
308: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
309: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
310: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
311: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
312: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
313: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
306: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
307: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
308: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
309: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
310: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
311: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
312: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
313: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
314: TRANSFER_COMPONENTS_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR);
307: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
308: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
309: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
310: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
311: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
312: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
313: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
314: TRANSFER_COMPONENTS_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR);
315:
308: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
309: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
310: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
311: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
312: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
313: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
314: TRANSFER_COMPONENTS_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR);
315:
316: TYPE txn_ii_rltns_tbl IS TABLE OF txn_ii_rltns_rec
309: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
310: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
311: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
312: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
313: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
314: TRANSFER_COMPONENTS_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR);
315:
316: TYPE txn_ii_rltns_tbl IS TABLE OF txn_ii_rltns_rec
317: INDEX BY BINARY_INTEGER;
310: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
311: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
312: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
313: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
314: TRANSFER_COMPONENTS_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR);
315:
316: TYPE txn_ii_rltns_tbl IS TABLE OF txn_ii_rltns_rec
317: INDEX BY BINARY_INTEGER;
318:
323: -- Description : record to hold information about an transaction
324: -- details-org association.
325:
326: TYPE txn_org_assgn_rec IS RECORD (
327: TXN_OPERATING_UNIT_ID NUMBER := FND_API.G_MISS_NUM,
328: TXN_LINE_DETAIL_ID NUMBER := FND_API.G_MISS_NUM,
329: INSTANCE_OU_ID NUMBER := FND_API.G_MISS_NUM,
330: OPERATING_UNIT_ID NUMBER := FND_API.G_MISS_NUM,
331: RELATIONSHIP_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
324: -- details-org association.
325:
326: TYPE txn_org_assgn_rec IS RECORD (
327: TXN_OPERATING_UNIT_ID NUMBER := FND_API.G_MISS_NUM,
328: TXN_LINE_DETAIL_ID NUMBER := FND_API.G_MISS_NUM,
329: INSTANCE_OU_ID NUMBER := FND_API.G_MISS_NUM,
330: OPERATING_UNIT_ID NUMBER := FND_API.G_MISS_NUM,
331: RELATIONSHIP_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
332: ACTIVE_START_DATE DATE := FND_API.G_MISS_DATE,
325:
326: TYPE txn_org_assgn_rec IS RECORD (
327: TXN_OPERATING_UNIT_ID NUMBER := FND_API.G_MISS_NUM,
328: TXN_LINE_DETAIL_ID NUMBER := FND_API.G_MISS_NUM,
329: INSTANCE_OU_ID NUMBER := FND_API.G_MISS_NUM,
330: OPERATING_UNIT_ID NUMBER := FND_API.G_MISS_NUM,
331: RELATIONSHIP_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
332: ACTIVE_START_DATE DATE := FND_API.G_MISS_DATE,
333: ACTIVE_END_DATE DATE := FND_API.G_MISS_DATE,
326: TYPE txn_org_assgn_rec IS RECORD (
327: TXN_OPERATING_UNIT_ID NUMBER := FND_API.G_MISS_NUM,
328: TXN_LINE_DETAIL_ID NUMBER := FND_API.G_MISS_NUM,
329: INSTANCE_OU_ID NUMBER := FND_API.G_MISS_NUM,
330: OPERATING_UNIT_ID NUMBER := FND_API.G_MISS_NUM,
331: RELATIONSHIP_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
332: ACTIVE_START_DATE DATE := FND_API.G_MISS_DATE,
333: ACTIVE_END_DATE DATE := FND_API.G_MISS_DATE,
334: PRESERVE_DETAIL_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
327: TXN_OPERATING_UNIT_ID NUMBER := FND_API.G_MISS_NUM,
328: TXN_LINE_DETAIL_ID NUMBER := FND_API.G_MISS_NUM,
329: INSTANCE_OU_ID NUMBER := FND_API.G_MISS_NUM,
330: OPERATING_UNIT_ID NUMBER := FND_API.G_MISS_NUM,
331: RELATIONSHIP_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
332: ACTIVE_START_DATE DATE := FND_API.G_MISS_DATE,
333: ACTIVE_END_DATE DATE := FND_API.G_MISS_DATE,
334: PRESERVE_DETAIL_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
335: CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
328: TXN_LINE_DETAIL_ID NUMBER := FND_API.G_MISS_NUM,
329: INSTANCE_OU_ID NUMBER := FND_API.G_MISS_NUM,
330: OPERATING_UNIT_ID NUMBER := FND_API.G_MISS_NUM,
331: RELATIONSHIP_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
332: ACTIVE_START_DATE DATE := FND_API.G_MISS_DATE,
333: ACTIVE_END_DATE DATE := FND_API.G_MISS_DATE,
334: PRESERVE_DETAIL_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
335: CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
336: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
329: INSTANCE_OU_ID NUMBER := FND_API.G_MISS_NUM,
330: OPERATING_UNIT_ID NUMBER := FND_API.G_MISS_NUM,
331: RELATIONSHIP_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
332: ACTIVE_START_DATE DATE := FND_API.G_MISS_DATE,
333: ACTIVE_END_DATE DATE := FND_API.G_MISS_DATE,
334: PRESERVE_DETAIL_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
335: CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
336: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
337: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
330: OPERATING_UNIT_ID NUMBER := FND_API.G_MISS_NUM,
331: RELATIONSHIP_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
332: ACTIVE_START_DATE DATE := FND_API.G_MISS_DATE,
333: ACTIVE_END_DATE DATE := FND_API.G_MISS_DATE,
334: PRESERVE_DETAIL_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
335: CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
336: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
337: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
338: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
331: RELATIONSHIP_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
332: ACTIVE_START_DATE DATE := FND_API.G_MISS_DATE,
333: ACTIVE_END_DATE DATE := FND_API.G_MISS_DATE,
334: PRESERVE_DETAIL_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
335: CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
336: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
337: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
338: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
339: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
332: ACTIVE_START_DATE DATE := FND_API.G_MISS_DATE,
333: ACTIVE_END_DATE DATE := FND_API.G_MISS_DATE,
334: PRESERVE_DETAIL_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
335: CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
336: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
337: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
338: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
339: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
340: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
333: ACTIVE_END_DATE DATE := FND_API.G_MISS_DATE,
334: PRESERVE_DETAIL_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
335: CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
336: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
337: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
338: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
339: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
340: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
341: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
334: PRESERVE_DETAIL_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
335: CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
336: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
337: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
338: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
339: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
340: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
341: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
342: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
335: CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
336: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
337: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
338: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
339: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
340: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
341: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
342: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
343: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
336: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
337: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
338: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
339: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
340: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
341: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
342: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
343: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
344: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
337: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
338: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
339: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
340: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
341: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
342: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
343: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
344: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
345: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
338: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
339: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
340: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
341: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
342: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
343: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
344: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
345: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
346: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
339: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
340: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
341: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
342: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
343: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
344: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
345: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
346: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
347: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
340: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
341: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
342: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
343: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
344: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
345: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
346: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
347: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
348: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
341: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
342: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
343: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
344: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
345: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
346: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
347: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
348: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
349: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
342: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
343: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
344: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
345: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
346: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
347: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
348: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
349: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
350: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
343: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
344: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
345: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
346: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
347: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
348: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
349: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
350: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
351: TXN_LINE_DETAILS_INDEX NUMBER := FND_API.G_MISS_NUM,
344: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
345: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
346: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
347: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
348: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
349: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
350: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
351: TXN_LINE_DETAILS_INDEX NUMBER := FND_API.G_MISS_NUM,
352: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM);
345: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
346: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
347: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
348: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
349: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
350: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
351: TXN_LINE_DETAILS_INDEX NUMBER := FND_API.G_MISS_NUM,
352: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM);
353:
346: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
347: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
348: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
349: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
350: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
351: TXN_LINE_DETAILS_INDEX NUMBER := FND_API.G_MISS_NUM,
352: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM);
353:
354: TYPE txn_org_assgn_tbl IS TABLE OF txn_org_assgn_rec
347: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
348: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
349: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
350: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
351: TXN_LINE_DETAILS_INDEX NUMBER := FND_API.G_MISS_NUM,
352: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM);
353:
354: TYPE txn_org_assgn_tbl IS TABLE OF txn_org_assgn_rec
355: INDEX BY BINARY_INTEGER;
348: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
349: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
350: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
351: TXN_LINE_DETAILS_INDEX NUMBER := FND_API.G_MISS_NUM,
352: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM);
353:
354: TYPE txn_org_assgn_tbl IS TABLE OF txn_org_assgn_rec
355: INDEX BY BINARY_INTEGER;
356:
361: -- Description : record to hold the values of a transaction detail's
362: -- extended attributes.
363:
364: TYPE txn_ext_attrib_vals_rec IS RECORD(
365: TXN_ATTRIB_DETAIL_ID NUMBER := FND_API.G_MISS_NUM,
366: TXN_LINE_DETAIL_ID NUMBER := FND_API.G_MISS_NUM,
367: ATTRIB_SOURCE_TABLE VARCHAR2(30) := FND_API.G_MISS_CHAR,
368: ATTRIBUTE_SOURCE_ID NUMBER := FND_API.G_MISS_NUM,
369: ATTRIBUTE_VALUE VARCHAR2(240) := FND_API.G_MISS_CHAR,
362: -- extended attributes.
363:
364: TYPE txn_ext_attrib_vals_rec IS RECORD(
365: TXN_ATTRIB_DETAIL_ID NUMBER := FND_API.G_MISS_NUM,
366: TXN_LINE_DETAIL_ID NUMBER := FND_API.G_MISS_NUM,
367: ATTRIB_SOURCE_TABLE VARCHAR2(30) := FND_API.G_MISS_CHAR,
368: ATTRIBUTE_SOURCE_ID NUMBER := FND_API.G_MISS_NUM,
369: ATTRIBUTE_VALUE VARCHAR2(240) := FND_API.G_MISS_CHAR,
370: -- Added for CZ Integration (Begin)
363:
364: TYPE txn_ext_attrib_vals_rec IS RECORD(
365: TXN_ATTRIB_DETAIL_ID NUMBER := FND_API.G_MISS_NUM,
366: TXN_LINE_DETAIL_ID NUMBER := FND_API.G_MISS_NUM,
367: ATTRIB_SOURCE_TABLE VARCHAR2(30) := FND_API.G_MISS_CHAR,
368: ATTRIBUTE_SOURCE_ID NUMBER := FND_API.G_MISS_NUM,
369: ATTRIBUTE_VALUE VARCHAR2(240) := FND_API.G_MISS_CHAR,
370: -- Added for CZ Integration (Begin)
371: ATTRIBUTE_CODE VARCHAR2(30) := FND_API.g_miss_char,
364: TYPE txn_ext_attrib_vals_rec IS RECORD(
365: TXN_ATTRIB_DETAIL_ID NUMBER := FND_API.G_MISS_NUM,
366: TXN_LINE_DETAIL_ID NUMBER := FND_API.G_MISS_NUM,
367: ATTRIB_SOURCE_TABLE VARCHAR2(30) := FND_API.G_MISS_CHAR,
368: ATTRIBUTE_SOURCE_ID NUMBER := FND_API.G_MISS_NUM,
369: ATTRIBUTE_VALUE VARCHAR2(240) := FND_API.G_MISS_CHAR,
370: -- Added for CZ Integration (Begin)
371: ATTRIBUTE_CODE VARCHAR2(30) := FND_API.g_miss_char,
372: ATTRIBUTE_LEVEL VARCHAR2(15) := FND_API.g_miss_char,
365: TXN_ATTRIB_DETAIL_ID NUMBER := FND_API.G_MISS_NUM,
366: TXN_LINE_DETAIL_ID NUMBER := FND_API.G_MISS_NUM,
367: ATTRIB_SOURCE_TABLE VARCHAR2(30) := FND_API.G_MISS_CHAR,
368: ATTRIBUTE_SOURCE_ID NUMBER := FND_API.G_MISS_NUM,
369: ATTRIBUTE_VALUE VARCHAR2(240) := FND_API.G_MISS_CHAR,
370: -- Added for CZ Integration (Begin)
371: ATTRIBUTE_CODE VARCHAR2(30) := FND_API.g_miss_char,
372: ATTRIBUTE_LEVEL VARCHAR2(15) := FND_API.g_miss_char,
373: API_CALLER_IDENTITY VARCHAR2(15) := 'OTHER',
367: ATTRIB_SOURCE_TABLE VARCHAR2(30) := FND_API.G_MISS_CHAR,
368: ATTRIBUTE_SOURCE_ID NUMBER := FND_API.G_MISS_NUM,
369: ATTRIBUTE_VALUE VARCHAR2(240) := FND_API.G_MISS_CHAR,
370: -- Added for CZ Integration (Begin)
371: ATTRIBUTE_CODE VARCHAR2(30) := FND_API.g_miss_char,
372: ATTRIBUTE_LEVEL VARCHAR2(15) := FND_API.g_miss_char,
373: API_CALLER_IDENTITY VARCHAR2(15) := 'OTHER',
374: -- Added for CZ Integration (End)
375: PROCESS_FLAG VARCHAR2(30) := FND_API.G_MISS_CHAR,
368: ATTRIBUTE_SOURCE_ID NUMBER := FND_API.G_MISS_NUM,
369: ATTRIBUTE_VALUE VARCHAR2(240) := FND_API.G_MISS_CHAR,
370: -- Added for CZ Integration (Begin)
371: ATTRIBUTE_CODE VARCHAR2(30) := FND_API.g_miss_char,
372: ATTRIBUTE_LEVEL VARCHAR2(15) := FND_API.g_miss_char,
373: API_CALLER_IDENTITY VARCHAR2(15) := 'OTHER',
374: -- Added for CZ Integration (End)
375: PROCESS_FLAG VARCHAR2(30) := FND_API.G_MISS_CHAR,
376: ACTIVE_START_DATE DATE := FND_API.G_MISS_DATE,
371: ATTRIBUTE_CODE VARCHAR2(30) := FND_API.g_miss_char,
372: ATTRIBUTE_LEVEL VARCHAR2(15) := FND_API.g_miss_char,
373: API_CALLER_IDENTITY VARCHAR2(15) := 'OTHER',
374: -- Added for CZ Integration (End)
375: PROCESS_FLAG VARCHAR2(30) := FND_API.G_MISS_CHAR,
376: ACTIVE_START_DATE DATE := FND_API.G_MISS_DATE,
377: ACTIVE_END_DATE DATE := FND_API.G_MISS_DATE,
378: PRESERVE_DETAIL_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
379: CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
372: ATTRIBUTE_LEVEL VARCHAR2(15) := FND_API.g_miss_char,
373: API_CALLER_IDENTITY VARCHAR2(15) := 'OTHER',
374: -- Added for CZ Integration (End)
375: PROCESS_FLAG VARCHAR2(30) := FND_API.G_MISS_CHAR,
376: ACTIVE_START_DATE DATE := FND_API.G_MISS_DATE,
377: ACTIVE_END_DATE DATE := FND_API.G_MISS_DATE,
378: PRESERVE_DETAIL_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
379: CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
380: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
373: API_CALLER_IDENTITY VARCHAR2(15) := 'OTHER',
374: -- Added for CZ Integration (End)
375: PROCESS_FLAG VARCHAR2(30) := FND_API.G_MISS_CHAR,
376: ACTIVE_START_DATE DATE := FND_API.G_MISS_DATE,
377: ACTIVE_END_DATE DATE := FND_API.G_MISS_DATE,
378: PRESERVE_DETAIL_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
379: CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
380: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
381: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
374: -- Added for CZ Integration (End)
375: PROCESS_FLAG VARCHAR2(30) := FND_API.G_MISS_CHAR,
376: ACTIVE_START_DATE DATE := FND_API.G_MISS_DATE,
377: ACTIVE_END_DATE DATE := FND_API.G_MISS_DATE,
378: PRESERVE_DETAIL_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
379: CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
380: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
381: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
382: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
375: PROCESS_FLAG VARCHAR2(30) := FND_API.G_MISS_CHAR,
376: ACTIVE_START_DATE DATE := FND_API.G_MISS_DATE,
377: ACTIVE_END_DATE DATE := FND_API.G_MISS_DATE,
378: PRESERVE_DETAIL_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
379: CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
380: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
381: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
382: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
383: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
376: ACTIVE_START_DATE DATE := FND_API.G_MISS_DATE,
377: ACTIVE_END_DATE DATE := FND_API.G_MISS_DATE,
378: PRESERVE_DETAIL_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
379: CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
380: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
381: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
382: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
383: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
384: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
377: ACTIVE_END_DATE DATE := FND_API.G_MISS_DATE,
378: PRESERVE_DETAIL_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
379: CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
380: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
381: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
382: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
383: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
384: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
385: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
378: PRESERVE_DETAIL_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
379: CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
380: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
381: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
382: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
383: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
384: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
385: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
386: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
379: CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
380: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
381: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
382: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
383: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
384: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
385: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
386: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
387: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
380: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
381: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
382: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
383: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
384: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
385: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
386: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
387: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
388: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
381: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
382: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
383: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
384: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
385: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
386: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
387: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
388: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
389: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
382: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
383: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
384: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
385: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
386: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
387: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
388: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
389: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
390: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
383: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
384: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
385: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
386: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
387: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
388: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
389: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
390: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
391: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
384: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
385: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
386: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
387: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
388: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
389: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
390: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
391: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
392: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
385: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
386: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
387: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
388: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
389: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
390: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
391: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
392: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
393: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
386: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
387: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
388: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
389: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
390: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
391: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
392: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
393: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
394: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
387: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
388: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
389: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
390: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
391: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
392: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
393: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
394: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
395: TXN_LINE_DETAILS_INDEX NUMBER := FND_API.G_MISS_NUM,
388: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
389: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
390: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
391: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
392: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
393: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
394: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
395: TXN_LINE_DETAILS_INDEX NUMBER := FND_API.G_MISS_NUM,
396: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM);
389: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
390: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
391: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
392: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
393: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
394: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
395: TXN_LINE_DETAILS_INDEX NUMBER := FND_API.G_MISS_NUM,
396: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM);
397:
390: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
391: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
392: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
393: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
394: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
395: TXN_LINE_DETAILS_INDEX NUMBER := FND_API.G_MISS_NUM,
396: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM);
397:
398:
391: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
392: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
393: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
394: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
395: TXN_LINE_DETAILS_INDEX NUMBER := FND_API.G_MISS_NUM,
396: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM);
397:
398:
399: TYPE txn_ext_attrib_vals_tbl IS table of txn_ext_attrib_vals_rec
392: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
393: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
394: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
395: TXN_LINE_DETAILS_INDEX NUMBER := FND_API.G_MISS_NUM,
396: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM);
397:
398:
399: TYPE txn_ext_attrib_vals_tbl IS table of txn_ext_attrib_vals_rec
400: INDEX BY BINARY_INTEGER;
405: -- Description : record to hold the item's extended attributes as defined
406: -- in the core installed base (csi_i_extend_attribs)
407:
408: TYPE csi_ext_attribs_rec IS RECORD(
409: ATTRIBUTE_ID NUMBER := FND_API.g_miss_num,
410: ATTRIBUTE_LEVEL VARCHAR2(15) := FND_API.g_miss_char,
411: MASTER_ORGANIZATION_ID NUMBER := FND_API.g_miss_num,
412: INVENTORY_ITEM_ID NUMBER := FND_API.g_miss_num,
413: ITEM_CATEGORY_ID NUMBER := FND_API.g_miss_num,
406: -- in the core installed base (csi_i_extend_attribs)
407:
408: TYPE csi_ext_attribs_rec IS RECORD(
409: ATTRIBUTE_ID NUMBER := FND_API.g_miss_num,
410: ATTRIBUTE_LEVEL VARCHAR2(15) := FND_API.g_miss_char,
411: MASTER_ORGANIZATION_ID NUMBER := FND_API.g_miss_num,
412: INVENTORY_ITEM_ID NUMBER := FND_API.g_miss_num,
413: ITEM_CATEGORY_ID NUMBER := FND_API.g_miss_num,
414: INSTANCE_ID NUMBER := FND_API.g_miss_num,
407:
408: TYPE csi_ext_attribs_rec IS RECORD(
409: ATTRIBUTE_ID NUMBER := FND_API.g_miss_num,
410: ATTRIBUTE_LEVEL VARCHAR2(15) := FND_API.g_miss_char,
411: MASTER_ORGANIZATION_ID NUMBER := FND_API.g_miss_num,
412: INVENTORY_ITEM_ID NUMBER := FND_API.g_miss_num,
413: ITEM_CATEGORY_ID NUMBER := FND_API.g_miss_num,
414: INSTANCE_ID NUMBER := FND_API.g_miss_num,
415: ATTRIBUTE_CODE VARCHAR2(30) := FND_API.g_miss_char,
408: TYPE csi_ext_attribs_rec IS RECORD(
409: ATTRIBUTE_ID NUMBER := FND_API.g_miss_num,
410: ATTRIBUTE_LEVEL VARCHAR2(15) := FND_API.g_miss_char,
411: MASTER_ORGANIZATION_ID NUMBER := FND_API.g_miss_num,
412: INVENTORY_ITEM_ID NUMBER := FND_API.g_miss_num,
413: ITEM_CATEGORY_ID NUMBER := FND_API.g_miss_num,
414: INSTANCE_ID NUMBER := FND_API.g_miss_num,
415: ATTRIBUTE_CODE VARCHAR2(30) := FND_API.g_miss_char,
416: ATTRIBUTE_NAME VARCHAR2(50) := FND_API.g_miss_char,
409: ATTRIBUTE_ID NUMBER := FND_API.g_miss_num,
410: ATTRIBUTE_LEVEL VARCHAR2(15) := FND_API.g_miss_char,
411: MASTER_ORGANIZATION_ID NUMBER := FND_API.g_miss_num,
412: INVENTORY_ITEM_ID NUMBER := FND_API.g_miss_num,
413: ITEM_CATEGORY_ID NUMBER := FND_API.g_miss_num,
414: INSTANCE_ID NUMBER := FND_API.g_miss_num,
415: ATTRIBUTE_CODE VARCHAR2(30) := FND_API.g_miss_char,
416: ATTRIBUTE_NAME VARCHAR2(50) := FND_API.g_miss_char,
417: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.g_miss_char,
410: ATTRIBUTE_LEVEL VARCHAR2(15) := FND_API.g_miss_char,
411: MASTER_ORGANIZATION_ID NUMBER := FND_API.g_miss_num,
412: INVENTORY_ITEM_ID NUMBER := FND_API.g_miss_num,
413: ITEM_CATEGORY_ID NUMBER := FND_API.g_miss_num,
414: INSTANCE_ID NUMBER := FND_API.g_miss_num,
415: ATTRIBUTE_CODE VARCHAR2(30) := FND_API.g_miss_char,
416: ATTRIBUTE_NAME VARCHAR2(50) := FND_API.g_miss_char,
417: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.g_miss_char,
418: DESCRIPTION VARCHAR2(240) := FND_API.g_miss_char,
411: MASTER_ORGANIZATION_ID NUMBER := FND_API.g_miss_num,
412: INVENTORY_ITEM_ID NUMBER := FND_API.g_miss_num,
413: ITEM_CATEGORY_ID NUMBER := FND_API.g_miss_num,
414: INSTANCE_ID NUMBER := FND_API.g_miss_num,
415: ATTRIBUTE_CODE VARCHAR2(30) := FND_API.g_miss_char,
416: ATTRIBUTE_NAME VARCHAR2(50) := FND_API.g_miss_char,
417: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.g_miss_char,
418: DESCRIPTION VARCHAR2(240) := FND_API.g_miss_char,
419: ACTIVE_START_DATE DATE := FND_API.g_miss_date,
412: INVENTORY_ITEM_ID NUMBER := FND_API.g_miss_num,
413: ITEM_CATEGORY_ID NUMBER := FND_API.g_miss_num,
414: INSTANCE_ID NUMBER := FND_API.g_miss_num,
415: ATTRIBUTE_CODE VARCHAR2(30) := FND_API.g_miss_char,
416: ATTRIBUTE_NAME VARCHAR2(50) := FND_API.g_miss_char,
417: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.g_miss_char,
418: DESCRIPTION VARCHAR2(240) := FND_API.g_miss_char,
419: ACTIVE_START_DATE DATE := FND_API.g_miss_date,
420: ACTIVE_END_DATE DATE := FND_API.g_miss_date,
413: ITEM_CATEGORY_ID NUMBER := FND_API.g_miss_num,
414: INSTANCE_ID NUMBER := FND_API.g_miss_num,
415: ATTRIBUTE_CODE VARCHAR2(30) := FND_API.g_miss_char,
416: ATTRIBUTE_NAME VARCHAR2(50) := FND_API.g_miss_char,
417: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.g_miss_char,
418: DESCRIPTION VARCHAR2(240) := FND_API.g_miss_char,
419: ACTIVE_START_DATE DATE := FND_API.g_miss_date,
420: ACTIVE_END_DATE DATE := FND_API.g_miss_date,
421: CONTEXT VARCHAR2(30) := FND_API.g_miss_char,
414: INSTANCE_ID NUMBER := FND_API.g_miss_num,
415: ATTRIBUTE_CODE VARCHAR2(30) := FND_API.g_miss_char,
416: ATTRIBUTE_NAME VARCHAR2(50) := FND_API.g_miss_char,
417: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.g_miss_char,
418: DESCRIPTION VARCHAR2(240) := FND_API.g_miss_char,
419: ACTIVE_START_DATE DATE := FND_API.g_miss_date,
420: ACTIVE_END_DATE DATE := FND_API.g_miss_date,
421: CONTEXT VARCHAR2(30) := FND_API.g_miss_char,
422: ATTRIBUTE1 VARCHAR2(150) := FND_API.g_miss_char,
415: ATTRIBUTE_CODE VARCHAR2(30) := FND_API.g_miss_char,
416: ATTRIBUTE_NAME VARCHAR2(50) := FND_API.g_miss_char,
417: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.g_miss_char,
418: DESCRIPTION VARCHAR2(240) := FND_API.g_miss_char,
419: ACTIVE_START_DATE DATE := FND_API.g_miss_date,
420: ACTIVE_END_DATE DATE := FND_API.g_miss_date,
421: CONTEXT VARCHAR2(30) := FND_API.g_miss_char,
422: ATTRIBUTE1 VARCHAR2(150) := FND_API.g_miss_char,
423: ATTRIBUTE2 VARCHAR2(150) := FND_API.g_miss_char,
416: ATTRIBUTE_NAME VARCHAR2(50) := FND_API.g_miss_char,
417: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.g_miss_char,
418: DESCRIPTION VARCHAR2(240) := FND_API.g_miss_char,
419: ACTIVE_START_DATE DATE := FND_API.g_miss_date,
420: ACTIVE_END_DATE DATE := FND_API.g_miss_date,
421: CONTEXT VARCHAR2(30) := FND_API.g_miss_char,
422: ATTRIBUTE1 VARCHAR2(150) := FND_API.g_miss_char,
423: ATTRIBUTE2 VARCHAR2(150) := FND_API.g_miss_char,
424: ATTRIBUTE3 VARCHAR2(150) := FND_API.g_miss_char,
417: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.g_miss_char,
418: DESCRIPTION VARCHAR2(240) := FND_API.g_miss_char,
419: ACTIVE_START_DATE DATE := FND_API.g_miss_date,
420: ACTIVE_END_DATE DATE := FND_API.g_miss_date,
421: CONTEXT VARCHAR2(30) := FND_API.g_miss_char,
422: ATTRIBUTE1 VARCHAR2(150) := FND_API.g_miss_char,
423: ATTRIBUTE2 VARCHAR2(150) := FND_API.g_miss_char,
424: ATTRIBUTE3 VARCHAR2(150) := FND_API.g_miss_char,
425: ATTRIBUTE4 VARCHAR2(150) := FND_API.g_miss_char,
418: DESCRIPTION VARCHAR2(240) := FND_API.g_miss_char,
419: ACTIVE_START_DATE DATE := FND_API.g_miss_date,
420: ACTIVE_END_DATE DATE := FND_API.g_miss_date,
421: CONTEXT VARCHAR2(30) := FND_API.g_miss_char,
422: ATTRIBUTE1 VARCHAR2(150) := FND_API.g_miss_char,
423: ATTRIBUTE2 VARCHAR2(150) := FND_API.g_miss_char,
424: ATTRIBUTE3 VARCHAR2(150) := FND_API.g_miss_char,
425: ATTRIBUTE4 VARCHAR2(150) := FND_API.g_miss_char,
426: ATTRIBUTE5 VARCHAR2(150) := FND_API.g_miss_char,
419: ACTIVE_START_DATE DATE := FND_API.g_miss_date,
420: ACTIVE_END_DATE DATE := FND_API.g_miss_date,
421: CONTEXT VARCHAR2(30) := FND_API.g_miss_char,
422: ATTRIBUTE1 VARCHAR2(150) := FND_API.g_miss_char,
423: ATTRIBUTE2 VARCHAR2(150) := FND_API.g_miss_char,
424: ATTRIBUTE3 VARCHAR2(150) := FND_API.g_miss_char,
425: ATTRIBUTE4 VARCHAR2(150) := FND_API.g_miss_char,
426: ATTRIBUTE5 VARCHAR2(150) := FND_API.g_miss_char,
427: ATTRIBUTE6 VARCHAR2(150) := FND_API.g_miss_char,
420: ACTIVE_END_DATE DATE := FND_API.g_miss_date,
421: CONTEXT VARCHAR2(30) := FND_API.g_miss_char,
422: ATTRIBUTE1 VARCHAR2(150) := FND_API.g_miss_char,
423: ATTRIBUTE2 VARCHAR2(150) := FND_API.g_miss_char,
424: ATTRIBUTE3 VARCHAR2(150) := FND_API.g_miss_char,
425: ATTRIBUTE4 VARCHAR2(150) := FND_API.g_miss_char,
426: ATTRIBUTE5 VARCHAR2(150) := FND_API.g_miss_char,
427: ATTRIBUTE6 VARCHAR2(150) := FND_API.g_miss_char,
428: ATTRIBUTE7 VARCHAR2(150) := FND_API.g_miss_char,
421: CONTEXT VARCHAR2(30) := FND_API.g_miss_char,
422: ATTRIBUTE1 VARCHAR2(150) := FND_API.g_miss_char,
423: ATTRIBUTE2 VARCHAR2(150) := FND_API.g_miss_char,
424: ATTRIBUTE3 VARCHAR2(150) := FND_API.g_miss_char,
425: ATTRIBUTE4 VARCHAR2(150) := FND_API.g_miss_char,
426: ATTRIBUTE5 VARCHAR2(150) := FND_API.g_miss_char,
427: ATTRIBUTE6 VARCHAR2(150) := FND_API.g_miss_char,
428: ATTRIBUTE7 VARCHAR2(150) := FND_API.g_miss_char,
429: ATTRIBUTE8 VARCHAR2(150) := FND_API.g_miss_char,
422: ATTRIBUTE1 VARCHAR2(150) := FND_API.g_miss_char,
423: ATTRIBUTE2 VARCHAR2(150) := FND_API.g_miss_char,
424: ATTRIBUTE3 VARCHAR2(150) := FND_API.g_miss_char,
425: ATTRIBUTE4 VARCHAR2(150) := FND_API.g_miss_char,
426: ATTRIBUTE5 VARCHAR2(150) := FND_API.g_miss_char,
427: ATTRIBUTE6 VARCHAR2(150) := FND_API.g_miss_char,
428: ATTRIBUTE7 VARCHAR2(150) := FND_API.g_miss_char,
429: ATTRIBUTE8 VARCHAR2(150) := FND_API.g_miss_char,
430: ATTRIBUTE9 VARCHAR2(150) := FND_API.g_miss_char,
423: ATTRIBUTE2 VARCHAR2(150) := FND_API.g_miss_char,
424: ATTRIBUTE3 VARCHAR2(150) := FND_API.g_miss_char,
425: ATTRIBUTE4 VARCHAR2(150) := FND_API.g_miss_char,
426: ATTRIBUTE5 VARCHAR2(150) := FND_API.g_miss_char,
427: ATTRIBUTE6 VARCHAR2(150) := FND_API.g_miss_char,
428: ATTRIBUTE7 VARCHAR2(150) := FND_API.g_miss_char,
429: ATTRIBUTE8 VARCHAR2(150) := FND_API.g_miss_char,
430: ATTRIBUTE9 VARCHAR2(150) := FND_API.g_miss_char,
431: ATTRIBUTE10 VARCHAR2(150) := FND_API.g_miss_char,
424: ATTRIBUTE3 VARCHAR2(150) := FND_API.g_miss_char,
425: ATTRIBUTE4 VARCHAR2(150) := FND_API.g_miss_char,
426: ATTRIBUTE5 VARCHAR2(150) := FND_API.g_miss_char,
427: ATTRIBUTE6 VARCHAR2(150) := FND_API.g_miss_char,
428: ATTRIBUTE7 VARCHAR2(150) := FND_API.g_miss_char,
429: ATTRIBUTE8 VARCHAR2(150) := FND_API.g_miss_char,
430: ATTRIBUTE9 VARCHAR2(150) := FND_API.g_miss_char,
431: ATTRIBUTE10 VARCHAR2(150) := FND_API.g_miss_char,
432: ATTRIBUTE11 VARCHAR2(150) := FND_API.g_miss_char,
425: ATTRIBUTE4 VARCHAR2(150) := FND_API.g_miss_char,
426: ATTRIBUTE5 VARCHAR2(150) := FND_API.g_miss_char,
427: ATTRIBUTE6 VARCHAR2(150) := FND_API.g_miss_char,
428: ATTRIBUTE7 VARCHAR2(150) := FND_API.g_miss_char,
429: ATTRIBUTE8 VARCHAR2(150) := FND_API.g_miss_char,
430: ATTRIBUTE9 VARCHAR2(150) := FND_API.g_miss_char,
431: ATTRIBUTE10 VARCHAR2(150) := FND_API.g_miss_char,
432: ATTRIBUTE11 VARCHAR2(150) := FND_API.g_miss_char,
433: ATTRIBUTE12 VARCHAR2(150) := FND_API.g_miss_char,
426: ATTRIBUTE5 VARCHAR2(150) := FND_API.g_miss_char,
427: ATTRIBUTE6 VARCHAR2(150) := FND_API.g_miss_char,
428: ATTRIBUTE7 VARCHAR2(150) := FND_API.g_miss_char,
429: ATTRIBUTE8 VARCHAR2(150) := FND_API.g_miss_char,
430: ATTRIBUTE9 VARCHAR2(150) := FND_API.g_miss_char,
431: ATTRIBUTE10 VARCHAR2(150) := FND_API.g_miss_char,
432: ATTRIBUTE11 VARCHAR2(150) := FND_API.g_miss_char,
433: ATTRIBUTE12 VARCHAR2(150) := FND_API.g_miss_char,
434: ATTRIBUTE13 VARCHAR2(150) := FND_API.g_miss_char,
427: ATTRIBUTE6 VARCHAR2(150) := FND_API.g_miss_char,
428: ATTRIBUTE7 VARCHAR2(150) := FND_API.g_miss_char,
429: ATTRIBUTE8 VARCHAR2(150) := FND_API.g_miss_char,
430: ATTRIBUTE9 VARCHAR2(150) := FND_API.g_miss_char,
431: ATTRIBUTE10 VARCHAR2(150) := FND_API.g_miss_char,
432: ATTRIBUTE11 VARCHAR2(150) := FND_API.g_miss_char,
433: ATTRIBUTE12 VARCHAR2(150) := FND_API.g_miss_char,
434: ATTRIBUTE13 VARCHAR2(150) := FND_API.g_miss_char,
435: ATTRIBUTE14 VARCHAR2(150) := FND_API.g_miss_char,
428: ATTRIBUTE7 VARCHAR2(150) := FND_API.g_miss_char,
429: ATTRIBUTE8 VARCHAR2(150) := FND_API.g_miss_char,
430: ATTRIBUTE9 VARCHAR2(150) := FND_API.g_miss_char,
431: ATTRIBUTE10 VARCHAR2(150) := FND_API.g_miss_char,
432: ATTRIBUTE11 VARCHAR2(150) := FND_API.g_miss_char,
433: ATTRIBUTE12 VARCHAR2(150) := FND_API.g_miss_char,
434: ATTRIBUTE13 VARCHAR2(150) := FND_API.g_miss_char,
435: ATTRIBUTE14 VARCHAR2(150) := FND_API.g_miss_char,
436: ATTRIBUTE15 VARCHAR2(150) := FND_API.g_miss_char,
429: ATTRIBUTE8 VARCHAR2(150) := FND_API.g_miss_char,
430: ATTRIBUTE9 VARCHAR2(150) := FND_API.g_miss_char,
431: ATTRIBUTE10 VARCHAR2(150) := FND_API.g_miss_char,
432: ATTRIBUTE11 VARCHAR2(150) := FND_API.g_miss_char,
433: ATTRIBUTE12 VARCHAR2(150) := FND_API.g_miss_char,
434: ATTRIBUTE13 VARCHAR2(150) := FND_API.g_miss_char,
435: ATTRIBUTE14 VARCHAR2(150) := FND_API.g_miss_char,
436: ATTRIBUTE15 VARCHAR2(150) := FND_API.g_miss_char,
437: OBJECT_VERSION_NUMBER NUMBER := FND_API.g_miss_num);
430: ATTRIBUTE9 VARCHAR2(150) := FND_API.g_miss_char,
431: ATTRIBUTE10 VARCHAR2(150) := FND_API.g_miss_char,
432: ATTRIBUTE11 VARCHAR2(150) := FND_API.g_miss_char,
433: ATTRIBUTE12 VARCHAR2(150) := FND_API.g_miss_char,
434: ATTRIBUTE13 VARCHAR2(150) := FND_API.g_miss_char,
435: ATTRIBUTE14 VARCHAR2(150) := FND_API.g_miss_char,
436: ATTRIBUTE15 VARCHAR2(150) := FND_API.g_miss_char,
437: OBJECT_VERSION_NUMBER NUMBER := FND_API.g_miss_num);
438:
431: ATTRIBUTE10 VARCHAR2(150) := FND_API.g_miss_char,
432: ATTRIBUTE11 VARCHAR2(150) := FND_API.g_miss_char,
433: ATTRIBUTE12 VARCHAR2(150) := FND_API.g_miss_char,
434: ATTRIBUTE13 VARCHAR2(150) := FND_API.g_miss_char,
435: ATTRIBUTE14 VARCHAR2(150) := FND_API.g_miss_char,
436: ATTRIBUTE15 VARCHAR2(150) := FND_API.g_miss_char,
437: OBJECT_VERSION_NUMBER NUMBER := FND_API.g_miss_num);
438:
439: TYPE csi_ext_attribs_tbl IS table of csi_ext_attribs_rec
432: ATTRIBUTE11 VARCHAR2(150) := FND_API.g_miss_char,
433: ATTRIBUTE12 VARCHAR2(150) := FND_API.g_miss_char,
434: ATTRIBUTE13 VARCHAR2(150) := FND_API.g_miss_char,
435: ATTRIBUTE14 VARCHAR2(150) := FND_API.g_miss_char,
436: ATTRIBUTE15 VARCHAR2(150) := FND_API.g_miss_char,
437: OBJECT_VERSION_NUMBER NUMBER := FND_API.g_miss_num);
438:
439: TYPE csi_ext_attribs_tbl IS table of csi_ext_attribs_rec
440: INDEX BY BINARY_INTEGER;
433: ATTRIBUTE12 VARCHAR2(150) := FND_API.g_miss_char,
434: ATTRIBUTE13 VARCHAR2(150) := FND_API.g_miss_char,
435: ATTRIBUTE14 VARCHAR2(150) := FND_API.g_miss_char,
436: ATTRIBUTE15 VARCHAR2(150) := FND_API.g_miss_char,
437: OBJECT_VERSION_NUMBER NUMBER := FND_API.g_miss_num);
438:
439: TYPE csi_ext_attribs_tbl IS table of csi_ext_attribs_rec
440: INDEX BY BINARY_INTEGER;
441:
444: -- Description : record to hold the values of an item instances
445: -- extended attribute values.
446:
447: TYPE csi_ext_attrib_vals_rec IS RECORD(
448: ATTRIBUTE_VALUE_ID NUMBER := FND_API.G_MISS_NUM,
449: INSTANCE_ID NUMBER := FND_API.G_MISS_NUM,
450: ATTRIBUTE_ID NUMBER := FND_API.G_MISS_NUM,
451: ATTRIBUTE_VALUE VARCHAR2(240) := FND_API.G_MISS_CHAR,
452: ACTIVE_START_DATE DATE := FND_API.G_MISS_DATE,
445: -- extended attribute values.
446:
447: TYPE csi_ext_attrib_vals_rec IS RECORD(
448: ATTRIBUTE_VALUE_ID NUMBER := FND_API.G_MISS_NUM,
449: INSTANCE_ID NUMBER := FND_API.G_MISS_NUM,
450: ATTRIBUTE_ID NUMBER := FND_API.G_MISS_NUM,
451: ATTRIBUTE_VALUE VARCHAR2(240) := FND_API.G_MISS_CHAR,
452: ACTIVE_START_DATE DATE := FND_API.G_MISS_DATE,
453: ACTIVE_END_DATE DATE := FND_API.G_MISS_DATE,
446:
447: TYPE csi_ext_attrib_vals_rec IS RECORD(
448: ATTRIBUTE_VALUE_ID NUMBER := FND_API.G_MISS_NUM,
449: INSTANCE_ID NUMBER := FND_API.G_MISS_NUM,
450: ATTRIBUTE_ID NUMBER := FND_API.G_MISS_NUM,
451: ATTRIBUTE_VALUE VARCHAR2(240) := FND_API.G_MISS_CHAR,
452: ACTIVE_START_DATE DATE := FND_API.G_MISS_DATE,
453: ACTIVE_END_DATE DATE := FND_API.G_MISS_DATE,
454: CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
447: TYPE csi_ext_attrib_vals_rec IS RECORD(
448: ATTRIBUTE_VALUE_ID NUMBER := FND_API.G_MISS_NUM,
449: INSTANCE_ID NUMBER := FND_API.G_MISS_NUM,
450: ATTRIBUTE_ID NUMBER := FND_API.G_MISS_NUM,
451: ATTRIBUTE_VALUE VARCHAR2(240) := FND_API.G_MISS_CHAR,
452: ACTIVE_START_DATE DATE := FND_API.G_MISS_DATE,
453: ACTIVE_END_DATE DATE := FND_API.G_MISS_DATE,
454: CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
455: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
448: ATTRIBUTE_VALUE_ID NUMBER := FND_API.G_MISS_NUM,
449: INSTANCE_ID NUMBER := FND_API.G_MISS_NUM,
450: ATTRIBUTE_ID NUMBER := FND_API.G_MISS_NUM,
451: ATTRIBUTE_VALUE VARCHAR2(240) := FND_API.G_MISS_CHAR,
452: ACTIVE_START_DATE DATE := FND_API.G_MISS_DATE,
453: ACTIVE_END_DATE DATE := FND_API.G_MISS_DATE,
454: CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
455: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
456: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
449: INSTANCE_ID NUMBER := FND_API.G_MISS_NUM,
450: ATTRIBUTE_ID NUMBER := FND_API.G_MISS_NUM,
451: ATTRIBUTE_VALUE VARCHAR2(240) := FND_API.G_MISS_CHAR,
452: ACTIVE_START_DATE DATE := FND_API.G_MISS_DATE,
453: ACTIVE_END_DATE DATE := FND_API.G_MISS_DATE,
454: CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
455: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
456: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
457: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
450: ATTRIBUTE_ID NUMBER := FND_API.G_MISS_NUM,
451: ATTRIBUTE_VALUE VARCHAR2(240) := FND_API.G_MISS_CHAR,
452: ACTIVE_START_DATE DATE := FND_API.G_MISS_DATE,
453: ACTIVE_END_DATE DATE := FND_API.G_MISS_DATE,
454: CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
455: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
456: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
457: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
458: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
451: ATTRIBUTE_VALUE VARCHAR2(240) := FND_API.G_MISS_CHAR,
452: ACTIVE_START_DATE DATE := FND_API.G_MISS_DATE,
453: ACTIVE_END_DATE DATE := FND_API.G_MISS_DATE,
454: CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
455: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
456: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
457: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
458: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
459: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
452: ACTIVE_START_DATE DATE := FND_API.G_MISS_DATE,
453: ACTIVE_END_DATE DATE := FND_API.G_MISS_DATE,
454: CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
455: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
456: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
457: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
458: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
459: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
460: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
453: ACTIVE_END_DATE DATE := FND_API.G_MISS_DATE,
454: CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
455: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
456: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
457: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
458: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
459: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
460: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
461: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
454: CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
455: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
456: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
457: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
458: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
459: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
460: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
461: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
462: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
455: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
456: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
457: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
458: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
459: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
460: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
461: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
462: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
463: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
456: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
457: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
458: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
459: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
460: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
461: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
462: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
463: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
464: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
457: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
458: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
459: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
460: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
461: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
462: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
463: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
464: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
465: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
458: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
459: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
460: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
461: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
462: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
463: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
464: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
465: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
466: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
459: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
460: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
461: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
462: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
463: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
464: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
465: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
466: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
467: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
460: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
461: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
462: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
463: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
464: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
465: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
466: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
467: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
468: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
461: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
462: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
463: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
464: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
465: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
466: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
467: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
468: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
469: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
462: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
463: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
464: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
465: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
466: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
467: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
468: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
469: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
470: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM);
463: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
464: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
465: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
466: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
467: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
468: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
469: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
470: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM);
471:
464: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
465: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
466: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
467: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
468: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
469: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
470: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM);
471:
472: TYPE csi_ext_attrib_vals_tbl IS TABLE OF csi_ext_attrib_vals_rec
465: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
466: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
467: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
468: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
469: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
470: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM);
471:
472: TYPE csi_ext_attrib_vals_tbl IS TABLE OF csi_ext_attrib_vals_rec
473: INDEX BY BINARY_INTEGER;
466: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
467: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
468: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
469: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
470: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM);
471:
472: TYPE csi_ext_attrib_vals_tbl IS TABLE OF csi_ext_attrib_vals_rec
473: INDEX BY BINARY_INTEGER;
474:
479: -- Description : record to hold internal id values of the txn line details
480:
481: TYPE txn_line_detail_ids_rec IS RECORD
482: (
483: TRANSACTION_LINE_ID NUMBER := FND_API.G_MISS_NUM,
484: TXN_LINE_DETAIL_ID NUMBER := FND_API.G_MISS_NUM
485: );
486:
487: TYPE txn_line_detail_ids_tbl IS TABLE OF txn_line_detail_ids_rec
480:
481: TYPE txn_line_detail_ids_rec IS RECORD
482: (
483: TRANSACTION_LINE_ID NUMBER := FND_API.G_MISS_NUM,
484: TXN_LINE_DETAIL_ID NUMBER := FND_API.G_MISS_NUM
485: );
486:
487: TYPE txn_line_detail_ids_tbl IS TABLE OF txn_line_detail_ids_rec
488: INDEX BY BINARY_INTEGER;
494: -- party relationship
495:
496: TYPE txn_party_ids_rec IS RECORD
497: (
498: TXN_PARTY_DETAIL_ID NUMBER := FND_API.G_MISS_NUM,
499: TXN_LINE_DETAIL_ID NUMBER := FND_API.G_MISS_NUM
500: );
501:
502: TYPE txn_party_ids_tbl IS TABLE OF txn_party_ids_rec
495:
496: TYPE txn_party_ids_rec IS RECORD
497: (
498: TXN_PARTY_DETAIL_ID NUMBER := FND_API.G_MISS_NUM,
499: TXN_LINE_DETAIL_ID NUMBER := FND_API.G_MISS_NUM
500: );
501:
502: TYPE txn_party_ids_tbl IS TABLE OF txn_party_ids_rec
503: INDEX BY BINARY_INTEGER;
510: -- accounts
511:
512: TYPE txn_pty_acct_ids_rec IS RECORD
513: (
514: TXN_ACCOUNT_DETAIL_ID NUMBER := FND_API.G_MISS_NUM,
515: TXN_PARTY_DETAIL_ID NUMBER := FND_API.G_MISS_NUM,
516: TXN_LINE_DETAIL_ID NUMBER := FND_API.G_MISS_NUM
517: );
518:
511:
512: TYPE txn_pty_acct_ids_rec IS RECORD
513: (
514: TXN_ACCOUNT_DETAIL_ID NUMBER := FND_API.G_MISS_NUM,
515: TXN_PARTY_DETAIL_ID NUMBER := FND_API.G_MISS_NUM,
516: TXN_LINE_DETAIL_ID NUMBER := FND_API.G_MISS_NUM
517: );
518:
519: TYPE txn_pty_acct_ids_tbl IS TABLE OF txn_pty_acct_ids_rec
512: TYPE txn_pty_acct_ids_rec IS RECORD
513: (
514: TXN_ACCOUNT_DETAIL_ID NUMBER := FND_API.G_MISS_NUM,
515: TXN_PARTY_DETAIL_ID NUMBER := FND_API.G_MISS_NUM,
516: TXN_LINE_DETAIL_ID NUMBER := FND_API.G_MISS_NUM
517: );
518:
519: TYPE txn_pty_acct_ids_tbl IS TABLE OF txn_pty_acct_ids_rec
520: INDEX BY BINARY_INTEGER;
527: -- instance-instance relationships
528:
529: TYPE txn_ii_rltns_ids_rec IS RECORD
530: (
531: TXN_RELATIONSHIP_ID NUMBER := FND_API.G_MISS_NUM,
532: TRANSACTION_LINE_ID NUMBER := FND_API.G_MISS_NUM
533: );
534:
535: TYPE txn_ii_rltns_ids_tbl IS TABLE OF txn_ii_rltns_ids_rec
528:
529: TYPE txn_ii_rltns_ids_rec IS RECORD
530: (
531: TXN_RELATIONSHIP_ID NUMBER := FND_API.G_MISS_NUM,
532: TRANSACTION_LINE_ID NUMBER := FND_API.G_MISS_NUM
533: );
534:
535: TYPE txn_ii_rltns_ids_tbl IS TABLE OF txn_ii_rltns_ids_rec
536: INDEX BY BINARY_INTEGER;
543: -- org assignments
544:
545: TYPE txn_org_assgn_ids_rec IS RECORD
546: (
547: TXN_OPERATING_UNIT_ID NUMBER := FND_API.G_MISS_NUM,
548: TXN_LINE_DETAIL_ID NUMBER := FND_API.G_MISS_NUM
549: );
550:
551: TYPE txn_org_assgn_ids_tbl IS TABLE OF txn_org_assgn_ids_rec
544:
545: TYPE txn_org_assgn_ids_rec IS RECORD
546: (
547: TXN_OPERATING_UNIT_ID NUMBER := FND_API.G_MISS_NUM,
548: TXN_LINE_DETAIL_ID NUMBER := FND_API.G_MISS_NUM
549: );
550:
551: TYPE txn_org_assgn_ids_tbl IS TABLE OF txn_org_assgn_ids_rec
552: INDEX BY BINARY_INTEGER;
559: -- attributes
560:
561: TYPE txn_ext_attrib_ids_rec IS RECORD
562: (
563: TXN_ATTRIB_DETAIL_ID NUMBER := FND_API.G_MISS_NUM,
564: TXN_LINE_DETAIL_ID NUMBER := FND_API.G_MISS_NUM
565: );
566:
567: TYPE txn_ext_attrib_ids_tbl IS TABLE OF txn_ext_attrib_ids_rec
560:
561: TYPE txn_ext_attrib_ids_rec IS RECORD
562: (
563: TXN_ATTRIB_DETAIL_ID NUMBER := FND_API.G_MISS_NUM,
564: TXN_LINE_DETAIL_ID NUMBER := FND_API.G_MISS_NUM
565: );
566:
567: TYPE txn_ext_attrib_ids_tbl IS TABLE OF txn_ext_attrib_ids_rec
568: INDEX BY BINARY_INTEGER;
571: -- Description : This record structure holds the possible query criteria
572: -- for transaction line
573:
574: TYPE txn_line_query_rec is RECORD(
575: TRANSACTION_LINE_ID NUMBER := FND_API.G_MISS_NUM,
576: ---Added (Start) for m-to-m enhancements
577: SOURCE_TRANSACTION_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
578: SOURCE_TXN_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
579: ---Added (End) for m-to-m enhancements
573:
574: TYPE txn_line_query_rec is RECORD(
575: TRANSACTION_LINE_ID NUMBER := FND_API.G_MISS_NUM,
576: ---Added (Start) for m-to-m enhancements
577: SOURCE_TRANSACTION_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
578: SOURCE_TXN_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
579: ---Added (End) for m-to-m enhancements
580: SOURCE_TRANSACTION_ID NUMBER := FND_API.G_MISS_NUM,
581: SOURCE_TRANSACTION_TABLE VARCHAR2(30) := FND_API.G_MISS_CHAR,
574: TYPE txn_line_query_rec is RECORD(
575: TRANSACTION_LINE_ID NUMBER := FND_API.G_MISS_NUM,
576: ---Added (Start) for m-to-m enhancements
577: SOURCE_TRANSACTION_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
578: SOURCE_TXN_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
579: ---Added (End) for m-to-m enhancements
580: SOURCE_TRANSACTION_ID NUMBER := FND_API.G_MISS_NUM,
581: SOURCE_TRANSACTION_TABLE VARCHAR2(30) := FND_API.G_MISS_CHAR,
582: -- Added for CZ Integration (Begin)
576: ---Added (Start) for m-to-m enhancements
577: SOURCE_TRANSACTION_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
578: SOURCE_TXN_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
579: ---Added (End) for m-to-m enhancements
580: SOURCE_TRANSACTION_ID NUMBER := FND_API.G_MISS_NUM,
581: SOURCE_TRANSACTION_TABLE VARCHAR2(30) := FND_API.G_MISS_CHAR,
582: -- Added for CZ Integration (Begin)
583: CONFIG_SESSION_HDR_ID NUMBER := FND_API.G_MISS_NUM,
584: CONFIG_SESSION_REV_NUM NUMBER := FND_API.G_MISS_NUM,
577: SOURCE_TRANSACTION_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
578: SOURCE_TXN_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
579: ---Added (End) for m-to-m enhancements
580: SOURCE_TRANSACTION_ID NUMBER := FND_API.G_MISS_NUM,
581: SOURCE_TRANSACTION_TABLE VARCHAR2(30) := FND_API.G_MISS_CHAR,
582: -- Added for CZ Integration (Begin)
583: CONFIG_SESSION_HDR_ID NUMBER := FND_API.G_MISS_NUM,
584: CONFIG_SESSION_REV_NUM NUMBER := FND_API.G_MISS_NUM,
585: CONFIG_SESSION_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
579: ---Added (End) for m-to-m enhancements
580: SOURCE_TRANSACTION_ID NUMBER := FND_API.G_MISS_NUM,
581: SOURCE_TRANSACTION_TABLE VARCHAR2(30) := FND_API.G_MISS_CHAR,
582: -- Added for CZ Integration (Begin)
583: CONFIG_SESSION_HDR_ID NUMBER := FND_API.G_MISS_NUM,
584: CONFIG_SESSION_REV_NUM NUMBER := FND_API.G_MISS_NUM,
585: CONFIG_SESSION_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
586: API_CALLER_IDENTITY VARCHAR2(15) := 'OTHER',
587: -- Added for CZ Integration (End)
580: SOURCE_TRANSACTION_ID NUMBER := FND_API.G_MISS_NUM,
581: SOURCE_TRANSACTION_TABLE VARCHAR2(30) := FND_API.G_MISS_CHAR,
582: -- Added for CZ Integration (Begin)
583: CONFIG_SESSION_HDR_ID NUMBER := FND_API.G_MISS_NUM,
584: CONFIG_SESSION_REV_NUM NUMBER := FND_API.G_MISS_NUM,
585: CONFIG_SESSION_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
586: API_CALLER_IDENTITY VARCHAR2(15) := 'OTHER',
587: -- Added for CZ Integration (End)
588: PROCESSING_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
581: SOURCE_TRANSACTION_TABLE VARCHAR2(30) := FND_API.G_MISS_CHAR,
582: -- Added for CZ Integration (Begin)
583: CONFIG_SESSION_HDR_ID NUMBER := FND_API.G_MISS_NUM,
584: CONFIG_SESSION_REV_NUM NUMBER := FND_API.G_MISS_NUM,
585: CONFIG_SESSION_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
586: API_CALLER_IDENTITY VARCHAR2(15) := 'OTHER',
587: -- Added for CZ Integration (End)
588: PROCESSING_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
589: ERROR_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
584: CONFIG_SESSION_REV_NUM NUMBER := FND_API.G_MISS_NUM,
585: CONFIG_SESSION_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
586: API_CALLER_IDENTITY VARCHAR2(15) := 'OTHER',
587: -- Added for CZ Integration (End)
588: PROCESSING_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
589: ERROR_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
590: ERROR_EXPLANATION VARCHAR2(240) := FND_API.G_MISS_CHAR);
591:
592:
585: CONFIG_SESSION_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
586: API_CALLER_IDENTITY VARCHAR2(15) := 'OTHER',
587: -- Added for CZ Integration (End)
588: PROCESSING_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
589: ERROR_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
590: ERROR_EXPLANATION VARCHAR2(240) := FND_API.G_MISS_CHAR);
591:
592:
593: -- Name : txn_line_detail_query_rec
586: API_CALLER_IDENTITY VARCHAR2(15) := 'OTHER',
587: -- Added for CZ Integration (End)
588: PROCESSING_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
589: ERROR_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
590: ERROR_EXPLANATION VARCHAR2(240) := FND_API.G_MISS_CHAR);
591:
592:
593: -- Name : txn_line_detail_query_rec
594: -- Description : This record structure holds the possible query criteria
594: -- Description : This record structure holds the possible query criteria
595: -- for transaction line detail
596:
597: TYPE txn_line_detail_query_rec is RECORD(
598: TRANSACTION_LINE_ID NUMBER := FND_API.G_MISS_NUM,
599: TXN_LINE_DETAIL_ID NUMBER := FND_API.G_MISS_NUM,
600: SUB_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
601: CSI_TRANSACTION_ID NUMBER := FND_API.G_MISS_NUM,
602: SOURCE_TRANSACTION_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
595: -- for transaction line detail
596:
597: TYPE txn_line_detail_query_rec is RECORD(
598: TRANSACTION_LINE_ID NUMBER := FND_API.G_MISS_NUM,
599: TXN_LINE_DETAIL_ID NUMBER := FND_API.G_MISS_NUM,
600: SUB_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
601: CSI_TRANSACTION_ID NUMBER := FND_API.G_MISS_NUM,
602: SOURCE_TRANSACTION_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
603: INSTANCE_ID NUMBER := FND_API.G_MISS_NUM,
596:
597: TYPE txn_line_detail_query_rec is RECORD(
598: TRANSACTION_LINE_ID NUMBER := FND_API.G_MISS_NUM,
599: TXN_LINE_DETAIL_ID NUMBER := FND_API.G_MISS_NUM,
600: SUB_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
601: CSI_TRANSACTION_ID NUMBER := FND_API.G_MISS_NUM,
602: SOURCE_TRANSACTION_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
603: INSTANCE_ID NUMBER := FND_API.G_MISS_NUM,
604: INSTANCE_EXISTS_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
597: TYPE txn_line_detail_query_rec is RECORD(
598: TRANSACTION_LINE_ID NUMBER := FND_API.G_MISS_NUM,
599: TXN_LINE_DETAIL_ID NUMBER := FND_API.G_MISS_NUM,
600: SUB_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
601: CSI_TRANSACTION_ID NUMBER := FND_API.G_MISS_NUM,
602: SOURCE_TRANSACTION_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
603: INSTANCE_ID NUMBER := FND_API.G_MISS_NUM,
604: INSTANCE_EXISTS_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
605: CSI_SYSTEM_ID NUMBER := FND_API.G_MISS_NUM,
598: TRANSACTION_LINE_ID NUMBER := FND_API.G_MISS_NUM,
599: TXN_LINE_DETAIL_ID NUMBER := FND_API.G_MISS_NUM,
600: SUB_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
601: CSI_TRANSACTION_ID NUMBER := FND_API.G_MISS_NUM,
602: SOURCE_TRANSACTION_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
603: INSTANCE_ID NUMBER := FND_API.G_MISS_NUM,
604: INSTANCE_EXISTS_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
605: CSI_SYSTEM_ID NUMBER := FND_API.G_MISS_NUM,
606: TRANSACTION_SYSTEM_ID NUMBER := FND_API.G_MISS_NUM,
599: TXN_LINE_DETAIL_ID NUMBER := FND_API.G_MISS_NUM,
600: SUB_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
601: CSI_TRANSACTION_ID NUMBER := FND_API.G_MISS_NUM,
602: SOURCE_TRANSACTION_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
603: INSTANCE_ID NUMBER := FND_API.G_MISS_NUM,
604: INSTANCE_EXISTS_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
605: CSI_SYSTEM_ID NUMBER := FND_API.G_MISS_NUM,
606: TRANSACTION_SYSTEM_ID NUMBER := FND_API.G_MISS_NUM,
607: INV_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
600: SUB_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
601: CSI_TRANSACTION_ID NUMBER := FND_API.G_MISS_NUM,
602: SOURCE_TRANSACTION_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
603: INSTANCE_ID NUMBER := FND_API.G_MISS_NUM,
604: INSTANCE_EXISTS_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
605: CSI_SYSTEM_ID NUMBER := FND_API.G_MISS_NUM,
606: TRANSACTION_SYSTEM_ID NUMBER := FND_API.G_MISS_NUM,
607: INV_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
608: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
601: CSI_TRANSACTION_ID NUMBER := FND_API.G_MISS_NUM,
602: SOURCE_TRANSACTION_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
603: INSTANCE_ID NUMBER := FND_API.G_MISS_NUM,
604: INSTANCE_EXISTS_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
605: CSI_SYSTEM_ID NUMBER := FND_API.G_MISS_NUM,
606: TRANSACTION_SYSTEM_ID NUMBER := FND_API.G_MISS_NUM,
607: INV_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
608: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
609: INVENTORY_REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,
602: SOURCE_TRANSACTION_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
603: INSTANCE_ID NUMBER := FND_API.G_MISS_NUM,
604: INSTANCE_EXISTS_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
605: CSI_SYSTEM_ID NUMBER := FND_API.G_MISS_NUM,
606: TRANSACTION_SYSTEM_ID NUMBER := FND_API.G_MISS_NUM,
607: INV_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
608: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
609: INVENTORY_REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,
610: SERIAL_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
603: INSTANCE_ID NUMBER := FND_API.G_MISS_NUM,
604: INSTANCE_EXISTS_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
605: CSI_SYSTEM_ID NUMBER := FND_API.G_MISS_NUM,
606: TRANSACTION_SYSTEM_ID NUMBER := FND_API.G_MISS_NUM,
607: INV_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
608: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
609: INVENTORY_REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,
610: SERIAL_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
611: MFG_SERIAL_NUMBER_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
604: INSTANCE_EXISTS_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
605: CSI_SYSTEM_ID NUMBER := FND_API.G_MISS_NUM,
606: TRANSACTION_SYSTEM_ID NUMBER := FND_API.G_MISS_NUM,
607: INV_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
608: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
609: INVENTORY_REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,
610: SERIAL_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
611: MFG_SERIAL_NUMBER_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
612: LOT_NUMBER VARCHAR2(80) := FND_API.G_MISS_CHAR,
605: CSI_SYSTEM_ID NUMBER := FND_API.G_MISS_NUM,
606: TRANSACTION_SYSTEM_ID NUMBER := FND_API.G_MISS_NUM,
607: INV_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
608: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
609: INVENTORY_REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,
610: SERIAL_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
611: MFG_SERIAL_NUMBER_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
612: LOT_NUMBER VARCHAR2(80) := FND_API.G_MISS_CHAR,
613: LOCATION_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
606: TRANSACTION_SYSTEM_ID NUMBER := FND_API.G_MISS_NUM,
607: INV_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
608: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
609: INVENTORY_REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,
610: SERIAL_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
611: MFG_SERIAL_NUMBER_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
612: LOT_NUMBER VARCHAR2(80) := FND_API.G_MISS_CHAR,
613: LOCATION_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
614: EXTERNAL_REFERENCE VARCHAR2(30) := FND_API.G_MISS_CHAR,
607: INV_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
608: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
609: INVENTORY_REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,
610: SERIAL_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
611: MFG_SERIAL_NUMBER_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
612: LOT_NUMBER VARCHAR2(80) := FND_API.G_MISS_CHAR,
613: LOCATION_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
614: EXTERNAL_REFERENCE VARCHAR2(30) := FND_API.G_MISS_CHAR,
615: RETURN_BY_DATE DATE := FND_API.G_MISS_DATE,
608: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
609: INVENTORY_REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,
610: SERIAL_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
611: MFG_SERIAL_NUMBER_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
612: LOT_NUMBER VARCHAR2(80) := FND_API.G_MISS_CHAR,
613: LOCATION_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
614: EXTERNAL_REFERENCE VARCHAR2(30) := FND_API.G_MISS_CHAR,
615: RETURN_BY_DATE DATE := FND_API.G_MISS_DATE,
616: REFERENCE_SOURCE_ID NUMBER := FND_API.G_MISS_NUM,
609: INVENTORY_REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,
610: SERIAL_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
611: MFG_SERIAL_NUMBER_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
612: LOT_NUMBER VARCHAR2(80) := FND_API.G_MISS_CHAR,
613: LOCATION_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
614: EXTERNAL_REFERENCE VARCHAR2(30) := FND_API.G_MISS_CHAR,
615: RETURN_BY_DATE DATE := FND_API.G_MISS_DATE,
616: REFERENCE_SOURCE_ID NUMBER := FND_API.G_MISS_NUM,
617: PROCESSING_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
610: SERIAL_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
611: MFG_SERIAL_NUMBER_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
612: LOT_NUMBER VARCHAR2(80) := FND_API.G_MISS_CHAR,
613: LOCATION_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
614: EXTERNAL_REFERENCE VARCHAR2(30) := FND_API.G_MISS_CHAR,
615: RETURN_BY_DATE DATE := FND_API.G_MISS_DATE,
616: REFERENCE_SOURCE_ID NUMBER := FND_API.G_MISS_NUM,
617: PROCESSING_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
618: ERROR_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
611: MFG_SERIAL_NUMBER_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
612: LOT_NUMBER VARCHAR2(80) := FND_API.G_MISS_CHAR,
613: LOCATION_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
614: EXTERNAL_REFERENCE VARCHAR2(30) := FND_API.G_MISS_CHAR,
615: RETURN_BY_DATE DATE := FND_API.G_MISS_DATE,
616: REFERENCE_SOURCE_ID NUMBER := FND_API.G_MISS_NUM,
617: PROCESSING_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
618: ERROR_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
619: ERROR_EXPLANATION VARCHAR2(240) := FND_API.G_MISS_CHAR);
612: LOT_NUMBER VARCHAR2(80) := FND_API.G_MISS_CHAR,
613: LOCATION_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
614: EXTERNAL_REFERENCE VARCHAR2(30) := FND_API.G_MISS_CHAR,
615: RETURN_BY_DATE DATE := FND_API.G_MISS_DATE,
616: REFERENCE_SOURCE_ID NUMBER := FND_API.G_MISS_NUM,
617: PROCESSING_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
618: ERROR_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
619: ERROR_EXPLANATION VARCHAR2(240) := FND_API.G_MISS_CHAR);
620:
613: LOCATION_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
614: EXTERNAL_REFERENCE VARCHAR2(30) := FND_API.G_MISS_CHAR,
615: RETURN_BY_DATE DATE := FND_API.G_MISS_DATE,
616: REFERENCE_SOURCE_ID NUMBER := FND_API.G_MISS_NUM,
617: PROCESSING_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
618: ERROR_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
619: ERROR_EXPLANATION VARCHAR2(240) := FND_API.G_MISS_CHAR);
620:
621: END csi_t_datastructures_grp;
614: EXTERNAL_REFERENCE VARCHAR2(30) := FND_API.G_MISS_CHAR,
615: RETURN_BY_DATE DATE := FND_API.G_MISS_DATE,
616: REFERENCE_SOURCE_ID NUMBER := FND_API.G_MISS_NUM,
617: PROCESSING_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
618: ERROR_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
619: ERROR_EXPLANATION VARCHAR2(240) := FND_API.G_MISS_CHAR);
620:
621: END csi_t_datastructures_grp;
615: RETURN_BY_DATE DATE := FND_API.G_MISS_DATE,
616: REFERENCE_SOURCE_ID NUMBER := FND_API.G_MISS_NUM,
617: PROCESSING_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
618: ERROR_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
619: ERROR_EXPLANATION VARCHAR2(240) := FND_API.G_MISS_CHAR);
620:
621: END csi_t_datastructures_grp;