[Home] [Help]
PACKAGE: APPS.CSI_T_DATASTRUCTURES_GRP
Source
1 PACKAGE csi_t_datastructures_grp AS
2 /* $Header: csigtdss.pls 120.4 2006/01/04 17:47:34 shegde noship $ */
3
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,
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,
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,
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,
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
47 -- Package name : csi_t_datastructures_grp
48 -- Type : type definition, group
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,
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',
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,
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,
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
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,
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,
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,
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
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)
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)
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,
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,
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
174 INDEX BY BINARY_INTEGER;
175
176
177 -- Name : txn_party_detail_rec
178 -- Package name : csi_t_datastructures_grp
179 -- Type : type definition, group
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,
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,
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,
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
216
217 TYPE txn_party_detail_tbl IS TABLE OF txn_party_detail_rec
218 INDEX BY BINARY_INTEGER;
219
220
221 -- Name : txn_pty_acct_detail_rec
222 -- Package name : csi_t_datastructures_grp
223 -- Type : type definition, group
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,
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,
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,
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
260
261 -- Name : txn_ii_rltns_rec
262 -- Package name : csi_t_datastructures_grp
266
263 -- Type : type definition, group
264 -- Description : record to hold information about an transaction
265 -- detail-configuration details.
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
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,
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,
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,
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,
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
319
320 -- Name : txn_org_assgn_rec
321 -- Package name : csi_t_datastructures_grp
322 -- Type : type definition, group
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,
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,
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,
350 ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
354 TYPE txn_org_assgn_tbl IS TABLE OF txn_org_assgn_rec
351 TXN_LINE_DETAILS_INDEX NUMBER := FND_API.G_MISS_NUM,
352 OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM);
353
355 INDEX BY BINARY_INTEGER;
356
357
358 -- Name : txn_ext_attrib_vals_rec
359 -- Package name : csi_t_datastructures_grp
360 -- Type : type definition, group
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,
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,
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,
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,
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;
401
402 -- Name : csi_ext_attribs_rec
403 -- Package name : csi_t_datastructures_grp
404 -- Type : type definition, group
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,
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,
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,
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;
441
442
443 -- Name : csi_ext_attrib_vals_rec
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(
451 ATTRIBUTE_VALUE VARCHAR2(240) := 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,
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,
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,
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
475
476 -- Name : txn_line_detail_ids_rec
477 -- Package name : csi_t_datastructures_grp
478 -- Type : type definition, group
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
488 INDEX BY BINARY_INTEGER;
489
490 -- Name : txn_party_ids_rec
491 -- Package name : csi_t_datastructures_grp
492 -- Type : type definition, group
493 -- Description : record to hold internal id values of the instance
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
503 INDEX BY BINARY_INTEGER;
504
505
506 -- Name : txn_pty_acct_ids_rec
507 -- Package name : csi_t_datastructures_grp
508 -- Type : type definition, group
509 -- Description : record to hold internal id values of the instance
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
519 TYPE txn_pty_acct_ids_tbl IS TABLE OF txn_pty_acct_ids_rec
520 INDEX BY BINARY_INTEGER;
521
522
523 -- Name : txn_ii_rltns_ids_rec
524 -- Package name : csi_t_datastructures_grp
525 -- Type : type definition, group
526 -- Description : record to hold internal id values of the
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
536 INDEX BY BINARY_INTEGER;
537
538
539 -- Name : txn_org_assgn_ids_rec
540 -- Package name : csi_t_datastructures_grp
541 -- Type : type definition, group
542 -- Description : record to hold internal id values of the instance
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
552 INDEX BY BINARY_INTEGER;
553
554
555 -- Name : txn_ext_attrib_ids_rec
556 -- Package name : csi_t_datastructures_grp
557 -- Type : type definition, group
558 -- Description : record to hold internal id values of the extended
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
568 INDEX BY BINARY_INTEGER;
569
570 -- Name : txn_line_query_rec
571 -- Description : This record structure holds the possible query criteria
572 -- for transaction line
573
574 TYPE txn_line_query_rec is RECORD(
578 SOURCE_TXN_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
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,
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)
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
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,
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,
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;