[Home] [Help]
PACKAGE: APPS.CSI_DATASTRUCTURES_PUB
Source
1 PACKAGE csi_datastructures_pub AUTHID CURRENT_USER AS
2 /* $Header: csipdss.pls 120.24.12020000.2 2012/12/05 10:27:58 mvaradam ship $ */
3
4 -- Added by sguthiva for att enhancements
5 -- The following 2 tables will be used during the batch validation
6 TYPE parameter_name IS TABLE OF VARCHAR2(30)
7 INDEX BY BINARY_INTEGER;
8 TYPE parameter_value IS TABLE OF VARCHAR2(200)
9 INDEX BY BINARY_INTEGER;
10 -- End addition by sguthiva for att enhancements
11
12 -- Name : party_account_query_rec
13 -- Package name : csi_datastructures_pub
14 -- Type : type definition, public
15 -- Description : record to hold information to query a party-account relationship.
16
17 TYPE party_account_query_rec IS RECORD
18 (
19 ip_account_id NUMBER := FND_API.G_MISS_NUM,
20 instance_party_id NUMBER := FND_API.G_MISS_NUM,
21 party_account_id NUMBER := FND_API.G_MISS_NUM,
22 relationship_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
23 );
24
25 TYPE install_param_rec IS RECORD
26 ( INTERNAL_PARTY_ID NUMBER
27 ,PROJECT_LOCATION_ID NUMBER
28 ,WIP_LOCATION_ID NUMBER
29 ,IN_TRANSIT_LOCATION_ID NUMBER
30 ,PO_LOCATION_ID NUMBER
31 ,CATEGORY_SET_ID NUMBER
32 ,HISTORY_FULL_DUMP_FREQUENCY NUMBER
33 ,FREEZE_FLAG VARCHAR2(1)
34 ,FREEZE_DATE DATE
35 ,SHOW_ALL_PARTY_LOCATION VARCHAR2(1)
36 ,OWNERSHIP_OVERRIDE_AT_TXN VARCHAR2(1)
37 ,SFM_QUEUE_BYPASS_FLAG VARCHAR2(1)
38 ,AUTO_ALLOCATE_COMP_AT_WIP VARCHAR2(1)
39 ,TXN_SEQ_START_DATE DATE
40 ,OWNERSHIP_CASCADE_AT_TXN VARCHAR2(1)
41 ,FETCH_FLAG VARCHAR2(1)
42 ,FA_CREATION_GROUP_BY VARCHAR2(30)
43 );
44
45 G_INSTALL_PARAM_REC INSTALL_PARAM_REC;
46
47 -- Name : party_account_rec
48 -- Package name : csi_datastructures_pub
49 -- Type : type definition, public
50 -- Description : record to hold information about a party-account relationship.
51
52
53 TYPE party_account_rec IS RECORD
54 (
55 ip_account_id NUMBER := FND_API.G_MISS_NUM,
56 parent_tbl_index NUMBER := FND_API.G_MISS_NUM,
57 instance_party_id NUMBER := FND_API.G_MISS_NUM,
58 party_account_id NUMBER := FND_API.G_MISS_NUM,
59 relationship_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
60 bill_to_address NUMBER := FND_API.G_MISS_NUM,
61 ship_to_address NUMBER := FND_API.G_MISS_NUM,
62 active_start_date DATE := FND_API.G_MISS_DATE,
63 active_end_date DATE := FND_API.G_MISS_DATE,
64 context VARCHAR2(30) := FND_API.G_MISS_CHAR,
65 attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
66 attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
67 attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
68 attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
69 attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
70 attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
71 attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
72 attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
73 attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74 attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75 attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
76 attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77 attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
78 attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
79 attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80 object_version_number NUMBER := FND_API.G_MISS_NUM ,
81 call_contracts VARCHAR2(1) := FND_API.G_TRUE,
82 vld_organization_id NUMBER := FND_API.G_MISS_NUM,
83 expire_flag VARCHAR2(1) := FND_API.G_FALSE, --Added by sguthiva for bug 2307804
84 grp_call_contracts VARCHAR2(1) := FND_API.G_FALSE, -- Should be turned on only by GRP API. For internal use only.
85 REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
86 PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
87 PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
88 PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
89 SYSTEM_ID NUMBER := FND_API.G_MISS_NUM, -- OKS Enhancement only
90 CASCADE_OWNERSHIP_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR ---- Added for bug 2972082
91 );
92
93 TYPE party_account_tbl IS TABLE OF party_account_rec INDEX BY BINARY_INTEGER;
94
95
96 -- Name : party_query_rec
97 -- Package name : csi_datastructures_pub
98 -- Type : type definition, public
99 -- Description : record to hold information to query an instance-party relationship.
100
101
102 TYPE party_query_rec IS RECORD
103 (
104 instance_party_id NUMBER := FND_API.G_MISS_NUM,
105 instance_id NUMBER := FND_API.G_MISS_NUM,
106 party_id NUMBER := FND_API.G_MISS_NUM,
107 relationship_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
108 );
109
110
111
112 -- Name : party_rec
113 -- Package name : csi_datastructures_pub
114 -- Type : type definition, public
115 -- Description : record to hold information about an instance-party relationship.
116
117
118 TYPE party_rec IS RECORD
119 (
120 instance_party_id NUMBER := FND_API.G_MISS_NUM,
121 instance_id NUMBER := FND_API.G_MISS_NUM,
122 party_source_table VARCHAR2(30) := FND_API.G_MISS_CHAR,
123 party_id NUMBER := FND_API.G_MISS_NUM,
124 relationship_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
125 contact_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
126 contact_ip_id NUMBER := FND_API.G_MISS_NUM,
127 active_start_date DATE := FND_API.G_MISS_DATE,
128 active_end_date DATE := FND_API.G_MISS_DATE,
129 context VARCHAR2(30) := FND_API.G_MISS_CHAR,
130 attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
131 attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
132 attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
133 attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
134 attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
135 attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
136 attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
137 attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
138 attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
139 attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
140 attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
141 attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
142 attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
143 attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
144 attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
145 object_version_number NUMBER := FND_API.G_MISS_NUM,
146 primary_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
147 preferred_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
148 parent_tbl_index NUMBER := FND_API.G_MISS_NUM,
149 call_contracts VARCHAR2(1) := FND_API.G_TRUE,
150 interface_id NUMBER := FND_API.G_MISS_NUM,
151 contact_parent_tbl_index NUMBER := FND_API.G_MISS_NUM,
152 cascade_ownership_flag VARCHAR2(1) := FND_API.G_MISS_CHAR ---- Added for bug 2972082
153 );
154
155 -- cascade_ownership_flag is strictly for internal use only.
156 TYPE party_tbl IS TABLE OF party_rec INDEX BY BINARY_INTEGER;
157
158
159
160 -- Name : party_header_rec
161 -- Package name : csi_datastructures_pub
162 -- Type : type definition, public
163 -- Description : record to hold header information about an instance-party relationship.
164
165
166 TYPE party_header_rec IS RECORD
167 (
168 instance_party_id NUMBER := FND_API.G_MISS_NUM,
169 instance_id NUMBER := FND_API.G_MISS_NUM,
170 party_source_table VARCHAR2(30) := FND_API.G_MISS_CHAR,
171 party_id NUMBER := FND_API.G_MISS_NUM,
172 relationship_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
173 contact_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
174 contact_ip_id NUMBER := FND_API.G_MISS_NUM,
175 party_number VARCHAR2(30) := FND_API.G_MISS_CHAR,
176 party_name VARCHAR2(360) := FND_API.G_MISS_CHAR,
177 party_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
178 active_start_date DATE := FND_API.G_MISS_DATE,
179 active_end_date DATE := FND_API.G_MISS_DATE,
180 context VARCHAR2(30) := FND_API.G_MISS_CHAR,
181 attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
182 attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
183 attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
184 attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
185 attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
186 attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
187 attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
188 attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
189 attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
190 attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
191 attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
192 attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
193 attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
194 attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
195 attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
196 object_version_number NUMBER := FND_API.G_MISS_NUM,
197 address1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
198 address2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
199 address3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
200 address4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
201 city VARCHAR2(60) := FND_API.G_MISS_CHAR,
202 state VARCHAR2(60) := FND_API.G_MISS_CHAR,
203 postal_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
204 country VARCHAR2(60) := FND_API.G_MISS_CHAR,
205 work_phone_number VARCHAR2(85) := FND_API.G_MISS_CHAR,
206 email_address VARCHAR2(2000) := FND_API.G_MISS_CHAR,
207 primary_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
208 preferred_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
209 );
210
211 TYPE party_header_tbl IS TABLE OF party_header_rec INDEX BY BINARY_INTEGER;
212
213
214 -- Name : version_label_query_rec
215 -- Package name : csi_datastructures_pub
216 -- Type : type definition, public
217 -- Description : record to hold the information for querying the version label of an item instance.
218
219 TYPE version_label_query_rec IS RECORD
220 (
221 version_label_id NUMBER := FND_API.G_MISS_NUM,
222 instance_id NUMBER := FND_API.G_MISS_NUM,
223 version_label VARCHAR2(240) := FND_API.G_MISS_CHAR,
224 date_time_stamp DATE := FND_API.G_MISS_DATE
225 );
226
227
228 -- Name : version_label_rec
229 -- Package name : csi_datastructures_pub
230 -- Type : type definition, public
231 -- Description : record to hold the version label information for an item instance.
232
233 TYPE version_label_rec IS RECORD
234 (
235 version_label_id NUMBER := FND_API.G_MISS_NUM,
236 instance_id NUMBER := FND_API.G_MISS_NUM,
237 version_label VARCHAR2(240) := FND_API.G_MISS_CHAR,
238 description VARCHAR2(240) := FND_API.G_MISS_CHAR,
239 date_time_stamp DATE := FND_API.G_MISS_DATE,
240 active_start_date DATE := FND_API.G_MISS_DATE,
241 active_end_date DATE := FND_API.G_MISS_DATE,
242 context VARCHAR2(30) := FND_API.G_MISS_CHAR,
243 attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
244 attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
245 attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
246 attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
247 attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
248 attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
249 attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
250 attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
251 attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
252 attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
253 attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
254 attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
255 attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
256 attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
257 attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
258 object_version_number NUMBER := FND_API.G_MISS_NUM
259 );
260
261
262 TYPE version_label_tbl IS TABLE OF version_label_rec INDEX BY BINARY_INTEGER;
263
264
265 TYPE id_tbl IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
266
267
268 TYPE instance_asset_location_rec IS RECORD
269 (
270 ASSET_LOCATION_ID NUMBER := FND_API.G_MISS_NUM ,
271 FA_LOCATION_ID NUMBER := FND_API.G_MISS_NUM ,
275 ACTIVE_END_DATE DATE := FND_API.G_MISS_DATE,
272 LOCATION_TABLE VARCHAR2(100):= FND_API.G_MISS_CHAR,
273 LOCATION_ID NUMBER := FND_API.G_MISS_NUM ,
274 ACTIVE_START_DATE DATE := FND_API.G_MISS_DATE,
276 OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
277 );
278
279
280 TYPE instance_asset_location_tbl IS TABLE OF instance_asset_location_rec INDEX BY BINARY_INTEGER;
281
282
283 -- Name : instance_rec
284 -- Package name : csi_datastructures_pub
285 -- Type : type definition, public
286 -- Description : record to hold the attributes of an item instance.
287
288
289 TYPE instance_rec is RECORD
290 ( INSTANCE_ID NUMBER := FND_API.G_MISS_NUM,
291 INSTANCE_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
292 EXTERNAL_REFERENCE VARCHAR2(30) := FND_API.G_MISS_CHAR,
293 INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
294 VLD_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
295 INVENTORY_REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,
296 INV_MASTER_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
297 SERIAL_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
298 MFG_SERIAL_NUMBER_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
299 LOT_NUMBER VARCHAR2(80) := FND_API.G_MISS_CHAR,
300 QUANTITY NUMBER := FND_API.G_MISS_NUM,
301 UNIT_OF_MEASURE VARCHAR2(3) := FND_API.G_MISS_CHAR,
302 ACCOUNTING_CLASS_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
303 INSTANCE_CONDITION_ID NUMBER := FND_API.G_MISS_NUM,
304 INSTANCE_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
305 CUSTOMER_VIEW_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
306 MERCHANT_VIEW_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
307 SELLABLE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
308 SYSTEM_ID NUMBER := FND_API.G_MISS_NUM,
309 INSTANCE_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
310 ACTIVE_START_DATE DATE := FND_API.G_MISS_DATE,
311 ACTIVE_END_DATE DATE := FND_API.G_MISS_DATE,
312 LOCATION_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
313 LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
314 INV_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
315 INV_SUBINVENTORY_NAME VARCHAR2(10) := FND_API.G_MISS_CHAR,
316 INV_LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
317 PA_PROJECT_ID NUMBER := FND_API.G_MISS_NUM,
318 PA_PROJECT_TASK_ID NUMBER := FND_API.G_MISS_NUM,
319 IN_TRANSIT_ORDER_LINE_ID NUMBER := FND_API.G_MISS_NUM,
320 WIP_JOB_ID NUMBER := FND_API.G_MISS_NUM,
321 PO_ORDER_LINE_ID NUMBER := FND_API.G_MISS_NUM,
322 LAST_OE_ORDER_LINE_ID NUMBER := FND_API.G_MISS_NUM,
323 LAST_OE_RMA_LINE_ID NUMBER := FND_API.G_MISS_NUM,
324 LAST_PO_PO_LINE_ID NUMBER := FND_API.G_MISS_NUM,
325 LAST_OE_PO_NUMBER VARCHAR2(50) := FND_API.G_MISS_CHAR,
326 LAST_WIP_JOB_ID NUMBER := FND_API.G_MISS_NUM,
327 LAST_PA_PROJECT_ID NUMBER := FND_API.G_MISS_NUM,
328 LAST_PA_TASK_ID NUMBER := FND_API.G_MISS_NUM,
329 LAST_OE_AGREEMENT_ID NUMBER := FND_API.G_MISS_NUM,
330 INSTALL_DATE DATE := FND_API.G_MISS_DATE,
331 MANUALLY_CREATED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
332 RETURN_BY_DATE DATE := FND_API.G_MISS_DATE,
333 ACTUAL_RETURN_DATE DATE := FND_API.G_MISS_DATE,
334 CREATION_COMPLETE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
335 COMPLETENESS_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
336 VERSION_LABEL VARCHAR2(240) := FND_API.G_MISS_CHAR,
337 VERSION_LABEL_DESCRIPTION VARCHAR2(240) := FND_API.G_MISS_CHAR,
338 CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
339 ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
340 ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
341 ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
342 ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
343 ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
344 ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
345 ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
346 ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
347 ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
348 ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
349 ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
350 ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
351 ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
352 ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
353 ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
354 OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
355 LAST_TXN_LINE_DETAIL_ID NUMBER := FND_API.G_MISS_NUM,
359 CHECK_FOR_INSTANCE_EXPIRY VARCHAR2(1) := FND_API.G_TRUE,
356 INSTALL_LOCATION_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
357 INSTALL_LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
358 INSTANCE_USAGE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
360 PROCESSED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
361 CALL_CONTRACTS VARCHAR2(1) := FND_API.G_TRUE,
362 INTERFACE_ID NUMBER := FND_API.G_MISS_NUM,
363 GRP_CALL_CONTRACTS VARCHAR2(1) := FND_API.G_FALSE, -- Should be turned on only from Group API. For internal use only.
364 CONFIG_INST_HDR_ID NUMBER := FND_API.G_MISS_NUM,
365 CONFIG_INST_REV_NUM NUMBER := FND_API.G_MISS_NUM,
366 CONFIG_INST_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
367 CONFIG_VALID_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
368 INSTANCE_DESCRIPTION VARCHAR2(240) := FND_API.G_MISS_CHAR,
369 CALL_BATCH_VALIDATION VARCHAR2(1) := FND_API.G_TRUE,
370 REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
371 PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
372 PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
373 PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
374 CASCADE_OWNERSHIP_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR, ---- Added for bug 2972082
375 -- Start addition of columns for EAM integration
376 NETWORK_ASSET_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
377 MAINTAINABLE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
378 PN_LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
379 ASSET_CRITICALITY_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
380 CATEGORY_ID NUMBER := FND_API.G_MISS_NUM,
381 EQUIPMENT_GEN_OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
382 INSTANTIATION_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
383 LINEAR_LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
384 OPERATIONAL_LOG_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
385 CHECKIN_STATUS NUMBER := FND_API.G_MISS_NUM,
386 SUPPLIER_WARRANTY_EXP_DATE DATE := FND_API.G_MISS_DATE,
387 ATTRIBUTE16 VARCHAR2(240) := FND_API.G_MISS_CHAR,
388 ATTRIBUTE17 VARCHAR2(240) := FND_API.G_MISS_CHAR,
389 ATTRIBUTE18 VARCHAR2(240) := FND_API.G_MISS_CHAR,
390 ATTRIBUTE19 VARCHAR2(240) := FND_API.G_MISS_CHAR,
391 ATTRIBUTE20 VARCHAR2(240) := FND_API.G_MISS_CHAR,
392 ATTRIBUTE21 VARCHAR2(240) := FND_API.G_MISS_CHAR,
393 ATTRIBUTE22 VARCHAR2(240) := FND_API.G_MISS_CHAR,
394 ATTRIBUTE23 VARCHAR2(240) := FND_API.G_MISS_CHAR,
395 ATTRIBUTE24 VARCHAR2(240) := FND_API.G_MISS_CHAR,
396 ATTRIBUTE25 VARCHAR2(240) := FND_API.G_MISS_CHAR,
397 ATTRIBUTE26 VARCHAR2(240) := FND_API.G_MISS_CHAR,
398 ATTRIBUTE27 VARCHAR2(240) := FND_API.G_MISS_CHAR,
399 ATTRIBUTE28 VARCHAR2(240) := FND_API.G_MISS_CHAR,
400 ATTRIBUTE29 VARCHAR2(240) := FND_API.G_MISS_CHAR,
401 ATTRIBUTE30 VARCHAR2(240) := FND_API.G_MISS_CHAR,
402 -- End addition of columns for EAM integration
403 -- Addition of columns for FA Integration
404 PURCHASE_UNIT_PRICE NUMBER := FND_API.G_MISS_NUM,
405 PURCHASE_CURRENCY_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR,
406 PAYABLES_UNIT_PRICE NUMBER := FND_API.G_MISS_NUM,
407 PAYABLES_CURRENCY_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR,
408 SALES_UNIT_PRICE NUMBER := FND_API.G_MISS_NUM,
409 SALES_CURRENCY_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR,
410 OPERATIONAL_STATUS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
411 -- End addition of columns for FA Integration
412 -- Added the following columns for bug 4632441
413 DEPARTMENT_ID NUMBER := fnd_api.g_miss_num,
414 WIP_ACCOUNTING_CLASS VARCHAR2(10) := fnd_api.g_miss_char,
415 AREA_ID NUMBER := fnd_api.g_miss_num,
416 -- End addition of columns for bug 4632441
417 OWNER_PARTY_ID NUMBER := fnd_api.g_miss_num,
418 SOURCE_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR, -- Added Code for Siebel Genesis Project
419 REC_INDEX NUMBER := FND_API.G_MISS_NUM --Added for Bug 10414679
420 );
421
422 -- cascade_ownership_flag is strictly for internal use only.
423
424 TYPE instance_tbl is TABLE OF instance_rec INDEX BY BINARY_INTEGER;
425
426
427
428 -- Name : instance_query_rec
429 -- Package name : csi_datastructures_pub
430 -- Type : type definition, public
431 -- Description : record to hold the attributes to query an item instance.
432
433
434 TYPE instance_query_rec is RECORD
435 (
436 INSTANCE_ID NUMBER := FND_API.G_MISS_NUM,
437 INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
438 INVENTORY_REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,
439 INV_MASTER_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
440 SERIAL_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
441 LOT_NUMBER VARCHAR2(80) := FND_API.G_MISS_CHAR,
445 SYSTEM_ID NUMBER := FND_API.G_MISS_NUM,
442 UNIT_OF_MEASURE VARCHAR2(3) := FND_API.G_MISS_CHAR,
443 INSTANCE_CONDITION_ID NUMBER := FND_API.G_MISS_NUM,
444 INSTANCE_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
446 INSTANCE_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
447 LOCATION_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
448 LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
449 INV_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
450 INV_SUBINVENTORY_NAME VARCHAR2(10) := FND_API.G_MISS_CHAR,
451 INV_LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
452 PA_PROJECT_ID NUMBER := FND_API.G_MISS_NUM,
453 PA_PROJECT_TASK_ID NUMBER := FND_API.G_MISS_NUM,
454 IN_TRANSIT_ORDER_LINE_ID NUMBER := FND_API.G_MISS_NUM,
455 WIP_JOB_ID NUMBER := FND_API.G_MISS_NUM,
456 PO_ORDER_LINE_ID NUMBER := FND_API.G_MISS_NUM,
457 LAST_OE_ORDER_LINE_ID NUMBER := FND_API.G_MISS_NUM,
458 LAST_OE_RMA_LINE_ID NUMBER := FND_API.G_MISS_NUM,
459 LAST_PO_PO_LINE_ID NUMBER := FND_API.G_MISS_NUM,
460 LAST_OE_PO_NUMBER VARCHAR2(50) := FND_API.G_MISS_CHAR,
461 LAST_WIP_JOB_ID NUMBER := FND_API.G_MISS_NUM,
462 LAST_PA_PROJECT_ID NUMBER := FND_API.G_MISS_NUM,
463 LAST_PA_TASK_ID NUMBER := FND_API.G_MISS_NUM,
464 LAST_OE_AGREEMENT_ID NUMBER := FND_API.G_MISS_NUM,
465 INSTALL_DATE DATE := FND_API.G_MISS_DATE,
466 MANUALLY_CREATED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
467 RETURN_BY_DATE DATE := FND_API.G_MISS_DATE,
468 ACTUAL_RETURN_DATE DATE := FND_API.G_MISS_DATE,
469 INSTANCE_USAGE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
470 QUERY_UNITS_ONLY VARCHAR2(1) := FND_API.G_MISS_CHAR,
471 CONTRACT_NUMBER VARCHAR2(120) := FND_API.G_MISS_CHAR, -- Added
472 CONFIG_INST_HDR_ID NUMBER := FND_API.G_MISS_NUM,
473 CONFIG_INST_REV_NUM NUMBER := FND_API.G_MISS_NUM,
474 CONFIG_INST_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
475 INSTANCE_DESCRIPTION VARCHAR2(240) := FND_API.G_MISS_CHAR,
476 OPERATIONAL_STATUS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR
477 );
478
479
480
481 -- Name : instance_header_rec
482 -- Package name : csi_datastructures_pub
483 -- Type : type definition, public
484 -- Description : record to hold the header attributes of an item instance.
485
486 TYPE instance_header_rec is RECORD
487 (
488
489 INSTANCE_ID NUMBER := FND_API.G_MISS_NUM,
490 INSTANCE_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
491 EXTERNAL_REFERENCE VARCHAR2(30) := FND_API.G_MISS_CHAR,
492 INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
493 INVENTORY_REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,
494 INV_MASTER_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
495 SERIAL_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
496 MFG_SERIAL_NUMBER_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
497 LOT_NUMBER VARCHAR2(80) := FND_API.G_MISS_CHAR,
498 QUANTITY NUMBER := FND_API.G_MISS_NUM,
499 UNIT_OF_MEASURE_NAME VARCHAR2(30) := FND_API.G_MISS_CHAR,
500 UNIT_OF_MEASURE VARCHAR2(3) := FND_API.G_MISS_CHAR,
501 ACCOUNTING_CLASS VARCHAR2(30) := FND_API.G_MISS_CHAR,
502 ACCOUNTING_CLASS_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
503 INSTANCE_CONDITION VARCHAR2(80) := FND_API.G_MISS_CHAR,
504 INSTANCE_CONDITION_ID NUMBER := FND_API.G_MISS_NUM,
505 INSTANCE_STATUS VARCHAR2(50) := FND_API.G_MISS_CHAR,
506 INSTANCE_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
507 CUSTOMER_VIEW_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
508 MERCHANT_VIEW_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
509 SELLABLE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
510 SYSTEM_ID NUMBER := FND_API.G_MISS_NUM,
511 SYSTEM_NAME VARCHAR2(30) := FND_API.G_MISS_CHAR,
512 INSTANCE_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
513 INSTANCE_TYPE_NAME VARCHAR2(240) := FND_API.G_MISS_CHAR,
514 ACTIVE_START_DATE DATE := FND_API.G_MISS_DATE,
515 ACTIVE_END_DATE DATE := FND_API.G_MISS_DATE,
516 LOCATION_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
517 LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
518 INV_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
519 INV_ORGANIZATION_NAME VARCHAR2(60) := FND_API.G_MISS_CHAR,
520 INV_SUBINVENTORY_NAME VARCHAR2(10) := FND_API.G_MISS_CHAR,
521 INV_LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
522 PA_PROJECT_ID NUMBER := FND_API.G_MISS_NUM,
523 PA_PROJECT_TASK_ID NUMBER := FND_API.G_MISS_NUM,
524 PA_PROJECT_NAME VARCHAR2(30) := FND_API.G_MISS_CHAR,
525 PA_PROJECT_NUMBER VARCHAR2(25) := FND_API.G_MISS_CHAR,
526 PA_TASK_NAME VARCHAR2(20) := FND_API.G_MISS_CHAR,
530 IN_TRANSIT_ORDER_NUMBER NUMBER := FND_API.G_MISS_NUM,
527 PA_TASK_NUMBER VARCHAR2(25) := FND_API.G_MISS_CHAR,
528 IN_TRANSIT_ORDER_LINE_ID NUMBER := FND_API.G_MISS_NUM,
529 IN_TRANSIT_ORDER_LINE_NUMBER NUMBER := FND_API.G_MISS_NUM,
531 WIP_JOB_ID NUMBER := FND_API.G_MISS_NUM,
532 WIP_ENTITY_NAME VARCHAR2(240) := FND_API.G_MISS_CHAR,
533 PO_ORDER_LINE_ID NUMBER := FND_API.G_MISS_NUM,
534 LAST_OE_ORDER_LINE_ID NUMBER := FND_API.G_MISS_NUM,
535 LAST_OE_RMA_LINE_ID NUMBER := FND_API.G_MISS_NUM,
536 LAST_PO_PO_LINE_ID NUMBER := FND_API.G_MISS_NUM,
537 LAST_OE_PO_NUMBER VARCHAR2(50) := FND_API.G_MISS_CHAR,
538 LAST_WIP_JOB_ID NUMBER := FND_API.G_MISS_NUM,
539 LAST_PA_PROJECT_ID NUMBER := FND_API.G_MISS_NUM,
540 LAST_PA_TASK_ID NUMBER := FND_API.G_MISS_NUM,
541 LAST_OE_AGREEMENT_ID NUMBER := FND_API.G_MISS_NUM,
542 INSTALL_DATE DATE := FND_API.G_MISS_DATE,
543 MANUALLY_CREATED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
544 RETURN_BY_DATE DATE := FND_API.G_MISS_DATE,
545 ACTUAL_RETURN_DATE DATE := FND_API.G_MISS_DATE,
546 CREATION_COMPLETE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
547 COMPLETENESS_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
548 CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
549 ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
550 ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
551 ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
552 ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
553 ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
554 ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
555 ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
556 ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
557 ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
558 ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
559 ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
560 ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
561 ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
562 ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
563 ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
564 OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
565 LAST_TXN_LINE_DETAIL_ID NUMBER := FND_API.G_MISS_NUM,
566 INSTALL_LOCATION_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
567 INSTALL_LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
568 INSTANCE_USAGE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
569 CURRENT_LOC_ADDRESS1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
570 CURRENT_LOC_ADDRESS2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
571 CURRENT_LOC_ADDRESS3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
572 CURRENT_LOC_ADDRESS4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
573 CURRENT_LOC_CITY VARCHAR2(60) := FND_API.G_MISS_CHAR,
574 CURRENT_LOC_STATE VARCHAR2(150) := FND_API.G_MISS_CHAR,
575 CURRENT_LOC_POSTAL_CODE VARCHAR2(60) := FND_API.G_MISS_CHAR,
576 CURRENT_LOC_COUNTRY VARCHAR2(60) := FND_API.G_MISS_CHAR,
577 SALES_ORDER_NUMBER NUMBER := FND_API.G_MISS_NUM,
578 SALES_ORDER_LINE_NUMBER NUMBER := FND_API.G_MISS_NUM,
579 SALES_ORDER_DATE DATE := FND_API.G_MISS_DATE,
580 PURCHASE_ORDER_NUMBER VARCHAR2(50) := FND_API.G_MISS_CHAR,
581 INSTANCE_USAGE_NAME VARCHAR2(80) := FND_API.G_MISS_CHAR,
582 INSTALL_LOC_ADDRESS1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
583 INSTALL_LOC_ADDRESS2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
584 INSTALL_LOC_ADDRESS3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
585 INSTALL_LOC_ADDRESS4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
586 INSTALL_LOC_CITY VARCHAR2(60) := FND_API.G_MISS_CHAR,
587 INSTALL_LOC_STATE VARCHAR2(150) := FND_API.G_MISS_CHAR,
588 INSTALL_LOC_POSTAL_CODE VARCHAR2(60) := FND_API.G_MISS_CHAR,
589 INSTALL_LOC_COUNTRY VARCHAR2(60) := FND_API.G_MISS_CHAR,
590 VLD_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
591 CURRENT_LOC_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
592 INSTALL_LOC_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
593 CURRENT_PARTY_NAME VARCHAR2(360) := FND_API.G_MISS_CHAR,
594 CURRENT_PARTY_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
595 INSTALL_PARTY_NAME VARCHAR2(360) := FND_API.G_MISS_CHAR,
596 INSTALL_PARTY_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
597 CONFIG_INST_HDR_ID NUMBER := FND_API.G_MISS_NUM,
598 CONFIG_INST_REV_NUM NUMBER := FND_API.G_MISS_NUM,
599 CONFIG_INST_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
600 CONFIG_VALID_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
601 INSTANCE_DESCRIPTION VARCHAR2(240) := FND_API.G_MISS_CHAR,
602 START_LOC_ADDRESS1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
603 START_LOC_ADDRESS2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
604 START_LOC_ADDRESS3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
608 START_LOC_POSTAL_CODE VARCHAR2(60) := FND_API.G_MISS_CHAR,
605 START_LOC_ADDRESS4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
606 START_LOC_CITY VARCHAR2(60) := FND_API.G_MISS_CHAR,
607 START_LOC_STATE VARCHAR2(60) := FND_API.G_MISS_CHAR,
609 START_LOC_COUNTRY VARCHAR2(60) := FND_API.G_MISS_CHAR,
610 END_LOC_ADDRESS1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
611 END_LOC_ADDRESS2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
612 END_LOC_ADDRESS3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
613 END_LOC_ADDRESS4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
614 END_LOC_CITY VARCHAR2(60) := FND_API.G_MISS_CHAR,
615 END_LOC_STATE VARCHAR2(60) := FND_API.G_MISS_CHAR,
616 END_LOC_POSTAL_CODE VARCHAR2(60) := FND_API.G_MISS_CHAR,
617 END_LOC_COUNTRY VARCHAR2(60) := FND_API.G_MISS_CHAR,
618 VLD_ORGANIZATION_NAME VARCHAR2(60) := FND_API.G_MISS_CHAR,
619 LAST_OE_AGREEMENT_NAME VARCHAR2(240) := FND_API.G_MISS_CHAR,
620 INV_LOCATOR_NAME VARCHAR2(240) := FND_API.G_MISS_CHAR,
621 -- Start addition of columns for EAM integration
622 NETWORK_ASSET_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
623 MAINTAINABLE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
624 PN_LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
625 ASSET_CRITICALITY_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
626 CATEGORY_ID NUMBER := FND_API.G_MISS_NUM,
627 EQUIPMENT_GEN_OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
628 INSTANTIATION_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
629 LINEAR_LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
630 OPERATIONAL_LOG_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
631 CHECKIN_STATUS NUMBER := FND_API.G_MISS_NUM,
632 SUPPLIER_WARRANTY_EXP_DATE DATE := FND_API.G_MISS_DATE,
633 ATTRIBUTE16 VARCHAR2(240) := FND_API.G_MISS_CHAR,
634 ATTRIBUTE17 VARCHAR2(240) := FND_API.G_MISS_CHAR,
635 ATTRIBUTE18 VARCHAR2(240) := FND_API.G_MISS_CHAR,
636 ATTRIBUTE19 VARCHAR2(240) := FND_API.G_MISS_CHAR,
637 ATTRIBUTE20 VARCHAR2(240) := FND_API.G_MISS_CHAR,
638 ATTRIBUTE21 VARCHAR2(240) := FND_API.G_MISS_CHAR,
639 ATTRIBUTE22 VARCHAR2(240) := FND_API.G_MISS_CHAR,
640 ATTRIBUTE23 VARCHAR2(240) := FND_API.G_MISS_CHAR,
641 ATTRIBUTE24 VARCHAR2(240) := FND_API.G_MISS_CHAR,
642 ATTRIBUTE25 VARCHAR2(240) := FND_API.G_MISS_CHAR,
643 ATTRIBUTE26 VARCHAR2(240) := FND_API.G_MISS_CHAR,
644 ATTRIBUTE27 VARCHAR2(240) := FND_API.G_MISS_CHAR,
645 ATTRIBUTE28 VARCHAR2(240) := FND_API.G_MISS_CHAR,
646 ATTRIBUTE29 VARCHAR2(240) := FND_API.G_MISS_CHAR,
647 ATTRIBUTE30 VARCHAR2(240) := FND_API.G_MISS_CHAR,
648 -- End addition of columns for EAM integration
649 -- Addition of columns for FA Integration
650 PURCHASE_UNIT_PRICE NUMBER := FND_API.G_MISS_NUM,
651 PURCHASE_CURRENCY_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR,
652 PAYABLES_UNIT_PRICE NUMBER := FND_API.G_MISS_NUM,
653 PAYABLES_CURRENCY_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR,
654 SALES_UNIT_PRICE NUMBER := FND_API.G_MISS_NUM,
655 SALES_CURRENCY_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR,
656 OPERATIONAL_STATUS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
657 OPERATIONAL_STATUS_NAME VARCHAR2(80) := FND_API.G_MISS_CHAR,
658 -- End addition of columns for FA Integration
659 -- Addition of columns to resolve ids for eam
660 MAINTENANCE_ORGANIZATION VARCHAR2(3) := FND_API.G_MISS_CHAR,
661 DEPARTMENT VARCHAR2(10) := FND_API.G_MISS_CHAR,
662 AREA VARCHAR2(30) := FND_API.G_MISS_CHAR,
663 WIP_ACCOUNTING_CLASS VARCHAR2(10) := FND_API.G_MISS_CHAR,
664 PARENT_ASSET_GROUP VARCHAR2(40) := FND_API.G_MISS_CHAR,
665 CRITICALITY VARCHAR2(80) := FND_API.G_MISS_CHAR,
666 CATEGORY_NAME VARCHAR2(163) := FND_API.G_MISS_CHAR,
667 PARENT_ASSET_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
668 MAINTAINABLE VARCHAR2(5) := FND_API.G_MISS_CHAR, --for bug 5211068
669 -- End addition of columns to resolve ids for eam
670 VERSION_LABEL VARCHAR2(30) := FND_API.G_MISS_CHAR,
671 VERSION_LABEL_MEANING VARCHAR2(80) := FND_API.G_MISS_CHAR,
672 INVENTORY_ITEM_NAME VARCHAR2(240) := FND_API.G_MISS_CHAR --Bug 7292862
673 );
674
675
676
677 TYPE instance_header_tbl is TABLE OF instance_header_rec INDEX BY BINARY_INTEGER;
678
679 TYPE transaction_query_rec IS RECORD
680 (
681 TRANSACTION_ID NUMBER := FND_API.G_MISS_NUM,
682 TRANSACTION_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
683 TXN_SUB_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
684 SOURCE_GROUP_REF_ID NUMBER := FND_API.G_MISS_NUM,
685 SOURCE_GROUP_REF VARCHAR2(50) := FND_API.G_MISS_CHAR,
686 SOURCE_HEADER_REF_ID NUMBER := FND_API.G_MISS_NUM,
687 SOURCE_HEADER_REF VARCHAR2(240) := FND_API.G_MISS_CHAR,
688 SOURCE_LINE_REF_ID NUMBER := FND_API.G_MISS_NUM,
692 MESSAGE_ID NUMBER := FND_API.G_MISS_NUM,
689 SOURCE_LINE_REF VARCHAR2(150) := FND_API.G_MISS_CHAR, -- Changed for bug#15931790
690 SOURCE_TRANSACTION_DATE DATE := FND_API.G_MISS_DATE,
691 INV_MATERIAL_TRANSACTION_ID NUMBER := FND_API.G_MISS_NUM,
693 TRANSACTION_START_DATE DATE := FND_API.G_MISS_DATE,
694 TRANSACTION_END_DATE DATE := FND_API.G_MISS_DATE,
695 INSTANCE_ID NUMBER := FND_API.G_MISS_NUM,
696 TRANSACTION_STATUS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR
697
698 );
699
700 TYPE transactions_query_tbl IS TABLE OF transaction_query_rec
701 INDEX BY BINARY_INTEGER;
702
703
704 TYPE transaction_sort_rec IS RECORD
705 (
706 TRANSACTION_DATE VARCHAR2(1) := 'N',
707 TRANSACTION_TYPE_ID VARCHAR2(1) := 'N'
708 );
709
710
711 -- Name : transaction_rec_type
712 -- Package name : csi_datastructures_pub
713 -- Type : type definition, public
714 -- Description : record to hold the attributes of an Installed Base transaction.
715
716
717 TYPE transaction_rec IS RECORD
718 (
719 TRANSACTION_ID NUMBER := FND_API.G_MISS_NUM ,
720 TRANSACTION_DATE DATE := FND_API.G_MISS_DATE,
721 SOURCE_TRANSACTION_DATE DATE := FND_API.G_MISS_DATE,
722 TRANSACTION_TYPE_ID NUMBER := FND_API.G_MISS_NUM ,
723 TXN_SUB_TYPE_ID NUMBER := FND_API.G_MISS_NUM ,
724 SOURCE_GROUP_REF_ID NUMBER := FND_API.G_MISS_NUM ,
725 SOURCE_GROUP_REF VARCHAR2(50),
726 SOURCE_HEADER_REF_ID NUMBER := FND_API.G_MISS_NUM ,
727 SOURCE_HEADER_REF VARCHAR2(240),
728 SOURCE_LINE_REF_ID NUMBER := FND_API.G_MISS_NUM ,
729 SOURCE_LINE_REF VARCHAR2(150), -- Changed for bug#15931790
730 SOURCE_DIST_REF_ID1 NUMBER := FND_API.G_MISS_NUM ,
731 SOURCE_DIST_REF_ID2 NUMBER := FND_API.G_MISS_NUM ,
732 INV_MATERIAL_TRANSACTION_ID NUMBER := FND_API.G_MISS_NUM ,
733 TRANSACTION_QUANTITY NUMBER := FND_API.G_MISS_NUM ,
734 TRANSACTION_UOM_CODE VARCHAR2(3) := FND_API.G_MISS_CHAR,
735 TRANSACTED_BY NUMBER := FND_API.G_MISS_NUM ,
736 TRANSACTION_STATUS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
737 TRANSACTION_ACTION_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
738 MESSAGE_ID NUMBER := FND_API.G_MISS_NUM ,
739 CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
740 ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
741 ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
742 ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
743 ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
744 ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
745 ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
746 ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
747 ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
748 ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
749 ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
750 ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
751 ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
752 ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
753 ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
754 ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
755 OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM ,
756 SPLIT_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
757 SRC_TXN_CREATION_DATE DATE := FND_API.G_MISS_DATE, --Internal Use Only Bug #3804960
758 GL_INTERFACE_STATUS_CODE NUMBER := FND_API.G_MISS_NUM
759 );
760
761 TYPE transaction_tbl IS TABLE OF transaction_rec INDEX BY BINARY_INTEGER;
762
763
764 TYPE transaction_error_rec IS RECORD
765 (
766 TRANSACTION_ERROR_ID NUMBER := FND_API.G_MISS_NUM ,
767 TRANSACTION_ID NUMBER := FND_API.G_MISS_NUM ,
768 MESSAGE_ID NUMBER := FND_API.G_MISS_NUM ,
769 ERROR_TEXT VARCHAR2(2000) := FND_API.G_MISS_CHAR,
770 SOURCE_TYPE VARCHAR2(240) := FND_API.G_MISS_CHAR,
771 SOURCE_ID NUMBER := FND_API.G_MISS_NUM ,
772 PROCESSED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
773 CREATED_BY NUMBER := FND_API.G_MISS_NUM ,
774 CREATION_DATE DATE := FND_API.G_MISS_DATE,
775 LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM ,
776 LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
777 LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM ,
778 OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM ,
779 TRANSACTION_TYPE_ID NUMBER := FND_API.G_MISS_NUM ,
780 SOURCE_GROUP_REF VARCHAR2(50) := FND_API.G_MISS_CHAR,
781 SOURCE_GROUP_REF_ID NUMBER := FND_API.G_MISS_NUM ,
782 SOURCE_HEADER_REF VARCHAR2(240) := FND_API.G_MISS_CHAR,
783 SOURCE_HEADER_REF_ID NUMBER := FND_API.G_MISS_NUM ,
787 SOURCE_DIST_REF_ID2 NUMBER := FND_API.G_MISS_NUM ,
784 SOURCE_LINE_REF VARCHAR2(150) := FND_API.G_MISS_CHAR, -- Changed for bug#15931790
785 SOURCE_LINE_REF_ID NUMBER := FND_API.G_MISS_NUM ,
786 SOURCE_DIST_REF_ID1 NUMBER := FND_API.G_MISS_NUM ,
788 INV_MATERIAL_TRANSACTION_ID NUMBER := FND_API.G_MISS_NUM ,
789 ERROR_STAGE VARCHAR2(30) := FND_API.G_MISS_CHAR,
790 MESSAGE_STRING VARCHAR2(4000) := FND_API.G_MISS_CHAR,
791 INSTANCE_ID NUMBER := FND_API.G_MISS_NUM ,
792 INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM ,
793 SERIAL_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
794 LOT_NUMBER VARCHAR2(80) := FND_API.G_MISS_CHAR,
795 TRANSACTION_ERROR_DATE DATE := FND_API.G_MISS_DATE,
796 SRC_SERIAL_NUM_CTRL_CODE NUMBER := FND_API.G_MISS_NUM ,
797 SRC_LOCATION_CTRL_CODE NUMBER := FND_API.G_MISS_NUM ,
798 SRC_LOT_CTRL_CODE NUMBER := FND_API.G_MISS_NUM ,
799 SRC_REV_QTY_CTRL_CODE NUMBER := FND_API.G_MISS_NUM ,
800 DST_SERIAL_NUM_CTRL_CODE NUMBER := FND_API.G_MISS_NUM ,
801 DST_LOCATION_CTRL_CODE NUMBER := FND_API.G_MISS_NUM ,
802 DST_LOT_CTRL_CODE NUMBER := FND_API.G_MISS_NUM ,
803 DST_REV_QTY_CTRL_CODE NUMBER := FND_API.G_MISS_NUM ,
804 COMMS_NL_TRACKABLE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
805 );
806
807 TYPE transactions_error_tbl IS TABLE OF transaction_error_rec
808 INDEX BY BINARY_INTEGER;
809
810
811
812 -- Name : relationship_query_rec
813 -- Package name : csi_datastructures_pub
814 -- Type : type definition, public
815 -- Description : record to hold the attributes for querying an item instance relationship.
816
817
818 TYPE relationship_query_rec IS RECORD
819 (
820 relationship_id NUMBER := FND_API.G_MISS_NUM
821 ,relationship_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
822 ,object_id NUMBER := FND_API.G_MISS_NUM
823 ,subject_id NUMBER := FND_API.G_MISS_NUM
824 );
825
826
827 -- Name : ii_relationship_rec_type
828 -- Package name : csi_datastructures_pub
829 -- Type : type definition, public
830 -- Description : record to hold the attributes of an item instance relationship.
831
832 TYPE ii_relationship_rec IS RECORD
833 (
834 RELATIONSHIP_ID NUMBER := FND_API.G_MISS_NUM,
835 RELATIONSHIP_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
836 OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
837 SUBJECT_ID NUMBER := FND_API.G_MISS_NUM,
838 SUBJECT_HAS_CHILD VARCHAR2(1) := FND_API.G_MISS_CHAR,
839 POSITION_REFERENCE VARCHAR2(30) := FND_API.G_MISS_CHAR,
840 ACTIVE_START_DATE DATE := FND_API.G_MISS_DATE,
841 ACTIVE_END_DATE DATE := FND_API.G_MISS_DATE,
842 DISPLAY_ORDER NUMBER := FND_API.G_MISS_NUM,
843 MANDATORY_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
844 CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
845 ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
846 ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
847 ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
848 ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
849 ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
850 ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
851 ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
852 ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
853 ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
854 ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
855 ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
856 ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
857 ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
858 ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
859 ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
860 OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
861 PARENT_TBL_INDEX NUMBER := FND_API.G_MISS_NUM,
862 PROCESSED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
863 INTERFACE_ID NUMBER := FND_API.G_MISS_NUM,
864 CASCADE_OWNERSHIP_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR -- Added for bug 2972082
865 );
866
867 -- cascade_ownership_flag is strictly for internal use only.
868
869 TYPE ii_relationship_tbl IS TABLE OF ii_relationship_rec
870 INDEX BY BINARY_INTEGER;
871 /*-----------------------------------------------------*/
872 /* record to maintain the information we store in the */
873 /* relationship history table */
874 /*-----------------------------------------------------*/
875
876
877 TYPE relationship_history_rec IS RECORD
878 (
879 RELATIONSHIP_HISTORY_ID NUMBER :=FND_API.G_MISS_NUM,
880 RELATIONSHIP_ID NUMBER :=FND_API.G_MISS_NUM,
884 OLD_POSITION_REFERENCE VARCHAR2(30) :=FND_API.G_MISS_CHAR,
881 TRANSACTION_ID NUMBER :=FND_API.G_MISS_NUM,
882 OLD_SUBJECT_ID NUMBER :=FND_API.G_MISS_NUM,
883 NEW_SUBJECT_ID NUMBER :=FND_API.G_MISS_NUM,
885 NEW_POSITION_REFERENCE VARCHAR2(30) :=FND_API.G_MISS_CHAR,
886 OLD_ACTIVE_START_DATE DATE :=FND_API.G_MISS_DATE,
887 NEW_ACTIVE_START_DATE DATE :=FND_API.G_MISS_DATE,
888 OLD_ACTIVE_END_DATE DATE :=FND_API.G_MISS_DATE,
889 NEW_ACTIVE_END_DATE DATE :=FND_API.G_MISS_DATE,
890 OLD_MANDATORY_FLAG VARCHAR2(1) :=FND_API.G_MISS_CHAR,
891 NEW_MANDATORY_FLAG VARCHAR2(1) :=FND_API.G_MISS_CHAR,
892 OLD_CONTEXT VARCHAR2(30) :=FND_API.G_MISS_CHAR,
893 NEW_CONTEXT VARCHAR2(30) :=FND_API.G_MISS_CHAR,
894 OLD_ATTRIBUTE1 VARCHAR2(150) :=FND_API.G_MISS_CHAR,
895 NEW_ATTRIBUTE1 VARCHAR2(150) :=FND_API.G_MISS_CHAR,
896 OLD_ATTRIBUTE2 VARCHAR2(150) :=FND_API.G_MISS_CHAR,
897 NEW_ATTRIBUTE2 VARCHAR2(150) :=FND_API.G_MISS_CHAR,
898 OLD_ATTRIBUTE3 VARCHAR2(150) :=FND_API.G_MISS_CHAR,
899 NEW_ATTRIBUTE3 VARCHAR2(150) :=FND_API.G_MISS_CHAR,
900 OLD_ATTRIBUTE4 VARCHAR2(150) :=FND_API.G_MISS_CHAR,
901 NEW_ATTRIBUTE4 VARCHAR2(150) :=FND_API.G_MISS_CHAR,
902 OLD_ATTRIBUTE5 VARCHAR2(150) :=FND_API.G_MISS_CHAR,
903 NEW_ATTRIBUTE5 VARCHAR2(150) :=FND_API.G_MISS_CHAR,
904 OLD_ATTRIBUTE6 VARCHAR2(150) :=FND_API.G_MISS_CHAR,
905 NEW_ATTRIBUTE6 VARCHAR2(150) :=FND_API.G_MISS_CHAR,
906 OLD_ATTRIBUTE7 VARCHAR2(150) :=FND_API.G_MISS_CHAR,
907 NEW_ATTRIBUTE7 VARCHAR2(150) :=FND_API.G_MISS_CHAR,
908 OLD_ATTRIBUTE8 VARCHAR2(150) :=FND_API.G_MISS_CHAR,
909 NEW_ATTRIBUTE8 VARCHAR2(150) :=FND_API.G_MISS_CHAR,
910 OLD_ATTRIBUTE9 VARCHAR2(150) :=FND_API.G_MISS_CHAR,
911 NEW_ATTRIBUTE9 VARCHAR2(150) :=FND_API.G_MISS_CHAR,
912 OLD_ATTRIBUTE10 VARCHAR2(150) :=FND_API.G_MISS_CHAR,
913 NEW_ATTRIBUTE10 VARCHAR2(150) :=FND_API.G_MISS_CHAR,
914 OLD_ATTRIBUTE11 VARCHAR2(150) :=FND_API.G_MISS_CHAR,
915 NEW_ATTRIBUTE11 VARCHAR2(150) :=FND_API.G_MISS_CHAR,
916 OLD_ATTRIBUTE12 VARCHAR2(150) :=FND_API.G_MISS_CHAR,
917 NEW_ATTRIBUTE12 VARCHAR2(150) :=FND_API.G_MISS_CHAR,
918 OLD_ATTRIBUTE13 VARCHAR2(150) :=FND_API.G_MISS_CHAR,
919 NEW_ATTRIBUTE13 VARCHAR2(150) :=FND_API.G_MISS_CHAR,
920 OLD_ATTRIBUTE14 VARCHAR2(150) :=FND_API.G_MISS_CHAR,
921 NEW_ATTRIBUTE14 VARCHAR2(150) :=FND_API.G_MISS_CHAR,
922 OLD_ATTRIBUTE15 VARCHAR2(150) :=FND_API.G_MISS_CHAR,
923 NEW_ATTRIBUTE15 VARCHAR2(150) :=FND_API.G_MISS_CHAR,
924 FULL_DUMP_FLAG VARCHAR2(1) :=FND_API.G_MISS_CHAR,
925 OBJECT_VERSION_NUMBER NUMBER :=FND_API.G_MISS_NUM,
926 CREATION_DATE DATE :=FND_API.G_MISS_DATE,
927 INSTANCE_ID NUMBER :=FND_API.G_MISS_NUM,
928 OBJECT_ID NUMBER :=FND_API.G_MISS_NUM,
929 RELATIONSHIP_TYPE_CODE VARCHAR2(30) :=FND_API.G_MISS_CHAR,
930 RELATIONSHIP_TYPE VARCHAR2(80) :=FND_API.G_MISS_CHAR,
931 OLD_SUBJECT_NUMBER VARCHAR2(30) :=FND_API.G_MISS_CHAR,
932 NEW_SUBJECT_NUMBER VARCHAR2(30) :=FND_API.G_MISS_CHAR
933 );
934
935 TYPE relationship_history_tbl IS TABLE OF relationship_history_rec INDEX BY BINARY_INTEGER;
936
937
938 TYPE system_rec IS RECORD
939 (
940 SYSTEM_ID NUMBER := FND_API.G_MISS_NUM ,
941 CUSTOMER_ID NUMBER := FND_API.G_MISS_NUM ,
942 SYSTEM_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR ,
943 SYSTEM_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR ,
944 PARENT_SYSTEM_ID NUMBER := FND_API.G_MISS_NUM ,
945 SHIP_TO_CONTACT_ID NUMBER := FND_API.G_MISS_NUM ,
946 BILL_TO_CONTACT_ID NUMBER := FND_API.G_MISS_NUM ,
947 TECHNICAL_CONTACT_ID NUMBER := FND_API.G_MISS_NUM ,
948 SERVICE_ADMIN_CONTACT_ID NUMBER := FND_API.G_MISS_NUM ,
949 SHIP_TO_SITE_USE_ID NUMBER := FND_API.G_MISS_NUM ,
950 BILL_TO_SITE_USE_ID NUMBER := FND_API.G_MISS_NUM ,
951 INSTALL_SITE_USE_ID NUMBER := FND_API.G_MISS_NUM ,
952 COTERMINATE_DAY_MONTH VARCHAR2(6) := FND_API.G_MISS_CHAR ,
953 AUTOCREATED_FROM_SYSTEM_ID NUMBER := FND_API.G_MISS_NUM ,
954 CONFIG_SYSTEM_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR ,
955 START_DATE_ACTIVE DATE := FND_API.G_MISS_DATE ,
956 END_DATE_ACTIVE DATE := FND_API.G_MISS_DATE ,
957 CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR ,
958 ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR ,
959 ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR ,
960 ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR ,
961 ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR ,
962 ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR ,
963 ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR ,
964 ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR ,
965 ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR ,
969 ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR ,
966 ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR ,
967 ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR ,
968 ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR ,
970 ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR ,
971 ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR ,
972 ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR ,
973 OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM ,
974 NAME VARCHAR2(50) := FND_API.G_MISS_CHAR ,
975 DESCRIPTION VARCHAR2(240) := FND_API.G_MISS_CHAR ,
976 TECH_CONT_CHANGE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR ,
977 BILL_TO_CONT_CHANGE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR ,
978 SHIP_TO_CONT_CHANGE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR ,
979 SERV_ADMIN_CONT_CHANGE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR ,
980 BILL_TO_SITE_CHANGE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR ,
981 SHIP_TO_SITE_CHANGE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR ,
982 INSTALL_TO_SITE_CHANGE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR ,
983 CASCADE_CUST_TO_INS_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR ,
984 OPERATING_UNIT_ID NUMBER := FND_API.G_MISS_NUM ,
985 REQUEST_ID NUMBER := FND_API.G_MISS_NUM ,
986 PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM ,
987 PROGRAM_ID NUMBER := FND_API.G_MISS_NUM ,
988 PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE
989 );
990
991 TYPE systems_tbl IS TABLE OF system_rec
992 INDEX BY BINARY_INTEGER;
993
994
995 TYPE system_history_rec IS RECORD
996 (
997 SYSTEM_HISTORY_ID NUMBER :=FND_API.G_MISS_NUM ,
998 SYSTEM_ID NUMBER :=FND_API.G_MISS_NUM ,
999 TRANSACTION_ID NUMBER :=FND_API.G_MISS_NUM ,
1000 OLD_CUSTOMER_ID NUMBER :=FND_API.G_MISS_NUM ,
1001 NEW_CUSTOMER_ID NUMBER :=FND_API.G_MISS_NUM ,
1002 OLD_SYSTEM_TYPE_CODE VARCHAR2(30) :=FND_API.G_MISS_CHAR,
1003 NEW_SYSTEM_TYPE_CODE VARCHAR2(30) :=FND_API.G_MISS_CHAR,
1004 OLD_SYSTEM_NUMBER VARCHAR2(30) :=FND_API.G_MISS_CHAR,
1005 NEW_SYSTEM_NUMBER VARCHAR2(30) :=FND_API.G_MISS_CHAR,
1006 OLD_PARENT_SYSTEM_ID NUMBER :=FND_API.G_MISS_NUM ,
1007 NEW_PARENT_SYSTEM_ID NUMBER :=FND_API.G_MISS_NUM ,
1008 OLD_SHIP_TO_CONTACT_ID NUMBER :=FND_API.G_MISS_NUM ,
1009 NEW_SHIP_TO_CONTACT_ID NUMBER :=FND_API.G_MISS_NUM ,
1010 OLD_BILL_TO_CONTACT_ID NUMBER :=FND_API.G_MISS_NUM ,
1011 NEW_BILL_TO_CONTACT_ID NUMBER :=FND_API.G_MISS_NUM ,
1012 OLD_TECHNICAL_CONTACT_ID NUMBER :=FND_API.G_MISS_NUM ,
1013 NEW_TECHNICAL_CONTACT_ID NUMBER :=FND_API.G_MISS_NUM ,
1014 OLD_SERVICE_ADMIN_CONTACT_ID NUMBER :=FND_API.G_MISS_NUM ,
1015 NEW_SERVICE_ADMIN_CONTACT_ID NUMBER :=FND_API.G_MISS_NUM ,
1016 OLD_SHIP_TO_SITE_USE_ID NUMBER :=FND_API.G_MISS_NUM ,
1017 NEW_SHIP_TO_SITE_USE_ID NUMBER :=FND_API.G_MISS_NUM ,
1018 OLD_INSTALL_SITE_USE_ID NUMBER :=FND_API.G_MISS_NUM ,
1019 NEW_INSTALL_SITE_USE_ID NUMBER :=FND_API.G_MISS_NUM ,
1020 OLD_BILL_TO_SITE_USE_ID NUMBER :=FND_API.G_MISS_NUM ,
1021 NEW_BILL_TO_SITE_USE_ID NUMBER :=FND_API.G_MISS_NUM ,
1022 OLD_COTERMINATE_DAY_MONTH VARCHAR2(6) :=FND_API.G_MISS_CHAR,
1023 NEW_COTERMINATE_DAY_MONTH VARCHAR2(6) :=FND_API.G_MISS_CHAR,
1024 OLD_START_DATE_ACTIVE DATE :=FND_API.G_MISS_DATE,
1025 NEW_START_DATE_ACTIVE DATE :=FND_API.G_MISS_DATE,
1026 OLD_END_DATE_ACTIVE DATE :=FND_API.G_MISS_DATE,
1027 NEW_END_DATE_ACTIVE DATE :=FND_API.G_MISS_DATE,
1028 OLD_AUTOCREATED_FROM_SYSTEM NUMBER :=FND_API.G_MISS_NUM ,
1029 NEW_AUTOCREATED_FROM_SYSTEM NUMBER :=FND_API.G_MISS_NUM ,
1030 OLD_CONFIG_SYSTEM_TYPE VARCHAR2(30) :=FND_API.G_MISS_CHAR,
1031 NEW_CONFIG_SYSTEM_TYPE VARCHAR2(30) :=FND_API.G_MISS_CHAR,
1032 OLD_CONTEXT VARCHAR2(30) :=FND_API.G_MISS_CHAR,
1033 NEW_CONTEXT VARCHAR2(30) :=FND_API.G_MISS_CHAR,
1034 OLD_ATTRIBUTE1 VARCHAR2(240) :=FND_API.G_MISS_CHAR,
1035 NEW_ATTRIBUTE1 VARCHAR2(240) :=FND_API.G_MISS_CHAR,
1036 OLD_ATTRIBUTE2 VARCHAR2(240) :=FND_API.G_MISS_CHAR,
1037 NEW_ATTRIBUTE2 VARCHAR2(240) :=FND_API.G_MISS_CHAR,
1038 OLD_ATTRIBUTE3 VARCHAR2(240) :=FND_API.G_MISS_CHAR,
1039 NEW_ATTRIBUTE3 VARCHAR2(240) :=FND_API.G_MISS_CHAR,
1040 OLD_ATTRIBUTE4 VARCHAR2(240) :=FND_API.G_MISS_CHAR,
1041 NEW_ATTRIBUTE4 VARCHAR2(240) :=FND_API.G_MISS_CHAR,
1042 OLD_ATTRIBUTE5 VARCHAR2(240) :=FND_API.G_MISS_CHAR,
1043 NEW_ATTRIBUTE5 VARCHAR2(240) :=FND_API.G_MISS_CHAR,
1044 OLD_ATTRIBUTE6 VARCHAR2(240) :=FND_API.G_MISS_CHAR,
1045 NEW_ATTRIBUTE6 VARCHAR2(240) :=FND_API.G_MISS_CHAR,
1046 OLD_ATTRIBUTE7 VARCHAR2(240) :=FND_API.G_MISS_CHAR,
1050 OLD_ATTRIBUTE9 VARCHAR2(240) :=FND_API.G_MISS_CHAR,
1047 NEW_ATTRIBUTE7 VARCHAR2(240) :=FND_API.G_MISS_CHAR,
1048 OLD_ATTRIBUTE8 VARCHAR2(240) :=FND_API.G_MISS_CHAR,
1049 NEW_ATTRIBUTE8 VARCHAR2(240) :=FND_API.G_MISS_CHAR,
1051 NEW_ATTRIBUTE9 VARCHAR2(240) :=FND_API.G_MISS_CHAR,
1052 OLD_ATTRIBUTE10 VARCHAR2(240) :=FND_API.G_MISS_CHAR,
1053 NEW_ATTRIBUTE10 VARCHAR2(240) :=FND_API.G_MISS_CHAR,
1054 OLD_ATTRIBUTE11 VARCHAR2(240) :=FND_API.G_MISS_CHAR,
1055 NEW_ATTRIBUTE11 VARCHAR2(240) :=FND_API.G_MISS_CHAR,
1056 OLD_ATTRIBUTE12 VARCHAR2(240) :=FND_API.G_MISS_CHAR,
1057 NEW_ATTRIBUTE12 VARCHAR2(240) :=FND_API.G_MISS_CHAR,
1058 OLD_ATTRIBUTE13 VARCHAR2(240) :=FND_API.G_MISS_CHAR,
1059 NEW_ATTRIBUTE13 VARCHAR2(240) :=FND_API.G_MISS_CHAR,
1060 OLD_ATTRIBUTE14 VARCHAR2(240) :=FND_API.G_MISS_CHAR,
1061 NEW_ATTRIBUTE14 VARCHAR2(240) :=FND_API.G_MISS_CHAR,
1062 OLD_ATTRIBUTE15 VARCHAR2(240) :=FND_API.G_MISS_CHAR,
1063 NEW_ATTRIBUTE15 VARCHAR2(240) :=FND_API.G_MISS_CHAR,
1064 FULL_DUMP_FLAG VARCHAR2(240) :=FND_API.G_MISS_CHAR,
1065 OBJECT_VERSION_NUMBER NUMBER :=FND_API.G_MISS_NUM ,
1066 OLD_NAME VARCHAR2(50) :=FND_API.G_MISS_CHAR,
1067 NEW_NAME VARCHAR2(50) :=FND_API.G_MISS_CHAR,
1068 OLD_DESCRIPTION VARCHAR2(240) :=FND_API.G_MISS_CHAR,
1069 NEW_DESCRIPTION VARCHAR2(240) :=FND_API.G_MISS_CHAR,
1070 OLD_OPERATING_UNIT_ID NUMBER :=FND_API.G_MISS_NUM,
1071 NEW_OPERATING_UNIT_ID NUMBER :=FND_API.G_MISS_NUM,
1072 OLD_SYSTEM_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR , --check from csi_lookups
1073 NEW_SYSTEM_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR , --check from csi_lookups
1074 OLD_PARENT_NAME VARCHAR2(50) := FND_API.G_MISS_CHAR ,
1075 NEW_PARENT_NAME VARCHAR2(50) := FND_API.G_MISS_CHAR ,
1076 OLD_SHIP_TO_ADDRESS1 VARCHAR2(240) := FND_API.G_MISS_CHAR ,
1077 OLD_SHIP_TO_ADDRESS2 VARCHAR2(240) := FND_API.G_MISS_CHAR ,
1078 OLD_SHIP_TO_ADDRESS3 VARCHAR2(240) := FND_API.G_MISS_CHAR ,
1079 OLD_SHIP_TO_ADDRESS4 VARCHAR2(240) := FND_API.G_MISS_CHAR ,
1080 OLD_SHIP_TO_LOCATION VARCHAR2(40) := FND_API.G_MISS_CHAR ,
1081 OLD_SHIP_STATE VARCHAR2(60) := FND_API.G_MISS_CHAR ,
1082 OLD_SHIP_POSTAL_CODE VARCHAR2(60) := FND_API.G_MISS_CHAR ,
1083 OLD_SHIP_COUNTRY VARCHAR2(60) := FND_API.G_MISS_CHAR ,
1084 OLD_SHIP_TO_CUSTOMER VARCHAR2(360) := FND_API.G_MISS_CHAR ,
1085 OLD_SHIP_TO_CUSTOMER_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR ,
1086 NEW_SHIP_TO_ADDRESS1 VARCHAR2(240) := FND_API.G_MISS_CHAR ,
1087 NEW_SHIP_TO_ADDRESS2 VARCHAR2(240) := FND_API.G_MISS_CHAR ,
1088 NEW_SHIP_TO_ADDRESS3 VARCHAR2(240) := FND_API.G_MISS_CHAR ,
1089 NEW_SHIP_TO_ADDRESS4 VARCHAR2(240) := FND_API.G_MISS_CHAR ,
1090 NEW_SHIP_TO_LOCATION VARCHAR2(40) := FND_API.G_MISS_CHAR ,
1091 NEW_SHIP_STATE VARCHAR2(60) := FND_API.G_MISS_CHAR ,
1092 NEW_SHIP_POSTAL_CODE VARCHAR2(60) := FND_API.G_MISS_CHAR ,
1093 NEW_SHIP_COUNTRY VARCHAR2(60) := FND_API.G_MISS_CHAR ,
1094 NEW_SHIP_TO_CUSTOMER VARCHAR2(360) := FND_API.G_MISS_CHAR ,
1095 NEW_SHIP_TO_CUSTOMER_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR ,
1096 OLD_INSTALL_ADDRESS1 VARCHAR2(240) := FND_API.G_MISS_CHAR ,
1097 OLD_INSTALL_ADDRESS2 VARCHAR2(240) := FND_API.G_MISS_CHAR ,
1098 OLD_INSTALL_ADDRESS3 VARCHAR2(240) := FND_API.G_MISS_CHAR ,
1099 OLD_INSTALL_ADDRESS4 VARCHAR2(240) := FND_API.G_MISS_CHAR ,
1100 OLD_INSTALL_LOCATION VARCHAR2(40) := FND_API.G_MISS_CHAR ,
1101 OLD_INSTALL_STATE VARCHAR2(60) := FND_API.G_MISS_CHAR ,
1102 OLD_INSTALL_POSTAL_CODE VARCHAR2(60) := FND_API.G_MISS_CHAR ,
1103 OLD_INSTALL_COUNTRY VARCHAR2(60) := FND_API.G_MISS_CHAR ,
1104 OLD_INSTALL_CUSTOMER_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR ,
1105 OLD_INSTALL_CUSTOMER VARCHAR2(360) := FND_API.G_MISS_CHAR ,
1106 NEW_INSTALL_ADDRESS1 VARCHAR2(240) := FND_API.G_MISS_CHAR ,
1107 NEW_INSTALL_ADDRESS2 VARCHAR2(240) := FND_API.G_MISS_CHAR ,
1108 NEW_INSTALL_ADDRESS3 VARCHAR2(240) := FND_API.G_MISS_CHAR ,
1109 NEW_INSTALL_ADDRESS4 VARCHAR2(240) := FND_API.G_MISS_CHAR ,
1110 NEW_INSTALL_LOCATION VARCHAR2(40) := FND_API.G_MISS_CHAR ,
1111 NEW_INSTALL_STATE VARCHAR2(60) := FND_API.G_MISS_CHAR ,
1112 NEW_INSTALL_POSTAL_CODE VARCHAR2(60) := FND_API.G_MISS_CHAR ,
1113 NEW_INSTALL_COUNTRY VARCHAR2(60) := FND_API.G_MISS_CHAR ,
1114 NEW_INSTALL_CUSTOMER_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR ,
1115 NEW_INSTALL_CUSTOMER VARCHAR2(360) := FND_API.G_MISS_CHAR ,
1116 OLD_BILL_TO_ADDRESS1 VARCHAR2(240) := FND_API.G_MISS_CHAR ,
1117 OLD_BILL_TO_ADDRESS2 VARCHAR2(240) := FND_API.G_MISS_CHAR ,
1118 OLD_BILL_TO_ADDRESS3 VARCHAR2(240) := FND_API.G_MISS_CHAR ,
1119 OLD_BILL_TO_ADDRESS4 VARCHAR2(240) := FND_API.G_MISS_CHAR ,
1123 OLD_BILL_COUNTRY VARCHAR2(60) := FND_API.G_MISS_CHAR ,
1120 OLD_BILL_TO_LOCATION VARCHAR2(40) := FND_API.G_MISS_CHAR ,
1121 OLD_BILL_STATE VARCHAR2(60) := FND_API.G_MISS_CHAR ,
1122 OLD_BILL_POSTAL_CODE VARCHAR2(60) := FND_API.G_MISS_CHAR ,
1124 OLD_BILL_TO_CUSTOMER_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR ,
1125 OLD_BILL_TO_CUSTOMER VARCHAR2(360) := FND_API.G_MISS_CHAR ,
1126 NEW_BILL_TO_ADDRESS1 VARCHAR2(240) := FND_API.G_MISS_CHAR ,
1127 NEW_BILL_TO_ADDRESS2 VARCHAR2(240) := FND_API.G_MISS_CHAR ,
1128 NEW_BILL_TO_ADDRESS3 VARCHAR2(240) := FND_API.G_MISS_CHAR ,
1129 NEW_BILL_TO_ADDRESS4 VARCHAR2(240) := FND_API.G_MISS_CHAR ,
1130 NEW_BILL_TO_LOCATION VARCHAR2(40) := FND_API.G_MISS_CHAR ,
1131 NEW_BILL_STATE VARCHAR2(60) := FND_API.G_MISS_CHAR ,
1132 NEW_BILL_POSTAL_CODE VARCHAR2(60) := FND_API.G_MISS_CHAR ,
1133 NEW_BILL_COUNTRY VARCHAR2(60) := FND_API.G_MISS_CHAR ,
1134 NEW_BILL_TO_CUSTOMER_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR ,
1135 NEW_BILL_TO_CUSTOMER VARCHAR2(360) := FND_API.G_MISS_CHAR ,
1136 OLD_SHIP_TO_CONTACT_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR ,
1137 OLD_SHIP_TO_CONTACT VARCHAR2(360) := FND_API.G_MISS_CHAR ,
1138 NEW_SHIP_TO_CONTACT_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR ,
1139 NEW_SHIP_TO_CONTACT VARCHAR2(360) := FND_API.G_MISS_CHAR ,
1140 OLD_BILL_TO_CONTACT_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR ,
1141 OLD_BILL_TO_CONTACT VARCHAR2(360) := FND_API.G_MISS_CHAR ,
1142 NEW_BILL_TO_CONTACT_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR ,
1143 NEW_BILL_TO_CONTACT VARCHAR2(360) := FND_API.G_MISS_CHAR ,
1144 OLD_TECHNICAL_CONTACT_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR ,
1145 OLD_TECHNICAL_CONTACT VARCHAR2(360) := FND_API.G_MISS_CHAR ,
1146 NEW_TECHNICAL_CONTACT_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR ,
1147 NEW_TECHNICAL_CONTACT VARCHAR2(360) := FND_API.G_MISS_CHAR ,
1148 OLD_SERV_ADMIN_CONTACT_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR ,
1149 OLD_SERV_ADMIN_CONTACT VARCHAR2(360) := FND_API.G_MISS_CHAR ,
1150 NEW_SERV_ADMIN_CONTACT_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR ,
1151 NEW_SERV_ADMIN_CONTACT VARCHAR2(360) := FND_API.G_MISS_CHAR ,
1152 OLD_OPERATING_UNIT_NAME VARCHAR2(60) := FND_API.G_MISS_CHAR ,
1153 NEW_OPERATING_UNIT_NAME VARCHAR2(60) := FND_API.G_MISS_CHAR
1154 );
1155
1156
1157
1158 TYPE systems_history_tbl IS TABLE OF system_history_rec
1159 INDEX BY BINARY_INTEGER;
1160
1161 TYPE system_query_rec IS RECORD
1162 (
1163 system_id NUMBER := FND_API.G_MISS_NUM
1164 ,system_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
1165 ,system_number VARCHAR2(30) := FND_API.G_MISS_CHAR
1166 );
1167
1168 -- Name : ext_attrib_rec
1169 -- Description : ext_attrib_rec record to hold information about extended attributes
1170
1171 TYPE ext_attrib_rec IS RECORD
1172 (
1173 attribute_id NUMBER := fnd_api.g_miss_num ,
1174 attribute_level VARCHAR2(15) := fnd_api.g_miss_char ,
1175 master_organization_id NUMBER := fnd_api.g_miss_num ,
1176 inventory_item_id NUMBER := fnd_api.g_miss_num ,
1177 item_category_id NUMBER := fnd_api.g_miss_num ,
1178 instance_id NUMBER := fnd_api.g_miss_num ,
1179 attribute_code VARCHAR2(30) := fnd_api.g_miss_char ,
1180 attribute_name VARCHAR2(50) := fnd_api.g_miss_char ,
1181 attribute_category VARCHAR2(30) := fnd_api.g_miss_char ,
1182 description VARCHAR2(240) := fnd_api.g_miss_char ,
1183 active_start_date DATE := fnd_api.g_miss_date ,
1184 active_end_date DATE := fnd_api.g_miss_date ,
1185 context VARCHAR2(30) := fnd_api.g_miss_char ,
1186 attribute1 VARCHAR2(150) := fnd_api.g_miss_char ,
1187 attribute2 VARCHAR2(150) := fnd_api.g_miss_char ,
1188 attribute3 VARCHAR2(150) := fnd_api.g_miss_char ,
1189 attribute4 VARCHAR2(150) := fnd_api.g_miss_char ,
1190 attribute5 VARCHAR2(150) := fnd_api.g_miss_char ,
1191 attribute6 VARCHAR2(150) := fnd_api.g_miss_char ,
1192 attribute7 VARCHAR2(150) := fnd_api.g_miss_char ,
1193 attribute8 VARCHAR2(150) := fnd_api.g_miss_char ,
1194 attribute9 VARCHAR2(150) := fnd_api.g_miss_char ,
1195 attribute10 VARCHAR2(150) := fnd_api.g_miss_char ,
1196 attribute11 VARCHAR2(150) := fnd_api.g_miss_char ,
1197 attribute12 VARCHAR2(150) := fnd_api.g_miss_char ,
1198 attribute13 VARCHAR2(150) := fnd_api.g_miss_char ,
1199 attribute14 VARCHAR2(150) := fnd_api.g_miss_char ,
1200 attribute15 VARCHAR2(150) := fnd_api.g_miss_char ,
1201 object_version_number NUMBER := fnd_api.g_miss_num
1202 );
1203
1204 TYPE extend_attrib_tbl IS TABLE OF ext_attrib_rec
1205 INDEX BY BINARY_INTEGER;
1206
1207 -- Name : extend_attrib_values_rec
1208 -- Package name : csi_datastructures_pub
1212
1209 -- Type : type definition, public
1210 -- Description : record to hold the values of an item instances extended attributes.
1211
1213 TYPE extend_attrib_values_rec IS RECORD
1214 (
1215 attribute_value_id NUMBER := FND_API.G_MISS_NUM,
1216 instance_id NUMBER := FND_API.G_MISS_NUM,
1217 attribute_id NUMBER := FND_API.G_MISS_NUM,
1218 attribute_code VARCHAR2(30) := fnd_api.g_miss_char ,
1219 attribute_value VARCHAR2(240) := FND_API.G_MISS_CHAR,
1220 active_start_date DATE := FND_API.G_MISS_DATE,
1221 active_end_date DATE := FND_API.G_MISS_DATE,
1222 context VARCHAR2(30) := FND_API.G_MISS_CHAR,
1223 attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1224 attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1225 attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1226 attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1227 attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1228 attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1229 attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1230 attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1231 attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1232 attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1233 attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1234 attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1235 attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1236 attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1237 attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1238 object_version_number NUMBER := FND_API.G_MISS_NUM,
1239 parent_tbl_index NUMBER := FND_API.G_MISS_NUM
1240 );
1241
1242
1243 TYPE extend_attrib_values_tbl IS table of extend_attrib_values_rec INDEX BY
1244 BINARY_INTEGER;
1245
1246
1247
1248 -- Name : extend_attrib_query_rec
1249 -- Package name : csi_datastructures_pub
1250 -- Type : type definition, public
1251 -- Description : record to hold the information for querying the values of an item instances extended
1252 -- attributes.
1253
1254
1255 TYPE extend_attrib_query_rec IS RECORD
1256 (
1257 attribute_value_id NUMBER := FND_API.G_MISS_NUM,
1258 instance_id NUMBER := FND_API.G_MISS_NUM,
1259 attribute_id NUMBER := FND_API.G_MISS_NUM
1260 );
1261
1262
1263
1264 -- Name : pricing_attributes_rec
1265 -- Package name : csi_datastructures_pub
1266 -- Type : type definition, public
1267 -- Description : record to hold the pricing attributes of an item instance.
1268
1269
1270 TYPE pricing_attribs_rec IS RECORD
1271 (
1272 pricing_attribute_id NUMBER := FND_API.G_MISS_NUM,
1273 instance_id NUMBER := FND_API.G_MISS_NUM,
1274 active_start_date DATE := FND_API.G_MISS_DATE,
1275 active_end_date DATE := FND_API.G_MISS_DATE,
1276 pricing_context VARCHAR2(30) := FND_API.G_MISS_CHAR,
1277 pricing_attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1278 pricing_attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1279 pricing_attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1280 pricing_attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1281 pricing_attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1282 pricing_attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1283 pricing_attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1284 pricing_attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1285 pricing_attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1286 pricing_attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1287 pricing_attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1288 pricing_attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1289 pricing_attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1290 pricing_attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1291 pricing_attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1292 pricing_attribute16 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1293 pricing_attribute17 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1294 pricing_attribute18 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1295 pricing_attribute19 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1296 pricing_attribute20 VARCHAR2(240) := FND_API.G_MISS_CHAR, --modified for bug #5980271
1297 pricing_attribute21 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1298 pricing_attribute22 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1299 pricing_attribute23 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1300 pricing_attribute24 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1301 pricing_attribute25 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1302 pricing_attribute26 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1303 pricing_attribute27 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1304 pricing_attribute28 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1305 pricing_attribute29 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1306 pricing_attribute30 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1307 pricing_attribute31 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1308 pricing_attribute32 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1312 pricing_attribute36 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1309 pricing_attribute33 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1310 pricing_attribute34 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1311 pricing_attribute35 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1313 pricing_attribute37 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1314 pricing_attribute38 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1315 pricing_attribute39 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1316 pricing_attribute40 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1317 pricing_attribute41 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1318 pricing_attribute42 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1319 pricing_attribute43 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1320 pricing_attribute44 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1321 pricing_attribute45 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1322 pricing_attribute46 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1323 pricing_attribute47 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1324 pricing_attribute48 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1325 pricing_attribute49 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1326 pricing_attribute50 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1327 pricing_attribute51 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1328 pricing_attribute52 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1329 pricing_attribute53 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1330 pricing_attribute54 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1331 pricing_attribute55 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1332 pricing_attribute56 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1333 pricing_attribute57 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1334 pricing_attribute58 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1335 pricing_attribute59 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1336 pricing_attribute60 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1337 pricing_attribute61 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1338 pricing_attribute62 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1339 pricing_attribute63 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1340 pricing_attribute64 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1341 pricing_attribute65 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1342 pricing_attribute66 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1343 pricing_attribute67 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1344 pricing_attribute68 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1345 pricing_attribute69 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1346 pricing_attribute70 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1347 pricing_attribute71 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1348 pricing_attribute72 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1349 pricing_attribute73 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1350 pricing_attribute74 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1351 pricing_attribute75 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1352 pricing_attribute76 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1353 pricing_attribute77 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1354 pricing_attribute78 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1355 pricing_attribute79 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1356 pricing_attribute80 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1357 pricing_attribute81 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1358 pricing_attribute82 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1359 pricing_attribute83 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1360 pricing_attribute84 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1361 pricing_attribute85 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1362 pricing_attribute86 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1363 pricing_attribute87 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1364 pricing_attribute88 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1365 pricing_attribute89 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1366 pricing_attribute90 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1367 pricing_attribute91 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1368 pricing_attribute92 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1369 pricing_attribute93 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1370 pricing_attribute94 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1371 pricing_attribute95 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1372 pricing_attribute96 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1373 pricing_attribute97 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1374 pricing_attribute98 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1375 pricing_attribute99 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1376 pricing_attribute100 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1377 context VARCHAR2(30) := FND_API.G_MISS_CHAR,
1378 attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1379 attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1380 attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1381 attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1382 attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1383 attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1384 attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1385 attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1386 attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1390 attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1387 attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1388 attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1389 attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1391 attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1392 attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1393 object_version_number NUMBER := FND_API.G_MISS_NUM,
1394 parent_tbl_index NUMBER := FND_API.G_MISS_NUM
1395 );
1396
1397 TYPE pricing_attribs_tbl IS TABLE OF pricing_attribs_rec INDEX BY BINARY_INTEGER;
1398
1399
1400 -- Name : pricing_attributes_query_rec
1401 -- Package name : csi_datastructures_pub
1402 -- Type : type definition, public
1403 -- Description : record to hold the query columns for pricing attributes of an item instance.
1404
1405 TYPE pricing_attribs_query_rec IS RECORD
1406 (
1407 pricing_attribute_id NUMBER := FND_API.G_MISS_NUM,
1408 instance_id NUMBER := FND_API.G_MISS_NUM
1409 );
1410
1411
1412 -- Name : organization_unit_rec
1413 -- Package name : csi_datastructures_pub
1414 -- Type : type definition, public
1415 -- Description : record to hold information about an instance-org association.
1416
1417
1418 TYPE organization_units_rec IS RECORD
1419 (
1420 instance_ou_id NUMBER := FND_API.G_MISS_NUM,
1421 instance_id NUMBER := FND_API.G_MISS_NUM,
1422 operating_unit_id NUMBER := FND_API.G_MISS_NUM,
1423 relationship_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
1424 active_start_date DATE := FND_API.G_MISS_DATE,
1425 active_end_date DATE := FND_API.G_MISS_DATE,
1426 context VARCHAR2(30) := FND_API.G_MISS_CHAR,
1427 attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1428 attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1429 attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1430 attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1431 attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1432 attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1433 attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1434 attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1435 attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1436 attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1437 attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1438 attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1439 attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1440 attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1441 attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1442 object_version_number NUMBER := FND_API.G_MISS_NUM,
1443 parent_tbl_index NUMBER := FND_API.G_MISS_NUM
1444 );
1445
1446 TYPE organization_units_tbl IS TABLE OF organization_units_rec INDEX BY BINARY_INTEGER;
1447
1448
1449
1450
1451 -- Name : organization_unit_query_rec
1452 -- Package name : csi_datastructures_pub
1453 -- Type : type definition, public
1454 -- Description : record to hold information to query an instance-org association.
1455
1456
1457 TYPE organization_unit_query_rec IS RECORD
1458 (
1459 instance_ou_id NUMBER := FND_API.G_MISS_NUM,
1460 instance_id NUMBER := FND_API.G_MISS_NUM,
1461 operating_unit_id NUMBER := FND_API.G_MISS_NUM,
1462 relationship_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
1463 );
1464
1465
1466 -- Name : instance_asset_rec
1467 -- Package name : csi_datastructures_pub
1468 -- Type : type definition, public
1469 -- Description : record to hold information about instance-asset association.
1470
1471
1472 TYPE instance_asset_rec IS RECORD
1473 (
1474 instance_asset_id NUMBER := FND_API.G_MISS_NUM,
1475 instance_id NUMBER := FND_API.G_MISS_NUM,
1476 fa_asset_id NUMBER := FND_API.G_MISS_NUM,
1477 fa_book_type_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
1478 fa_location_id NUMBER := FND_API.G_MISS_NUM,
1479 asset_quantity NUMBER := FND_API.G_MISS_NUM,
1480 update_status VARCHAR2(30) := FND_API.G_MISS_CHAR,
1481 active_start_date DATE := FND_API.G_MISS_DATE,
1482 active_end_date DATE := FND_API.G_MISS_DATE,
1483 object_version_number NUMBER := FND_API.G_MISS_NUM,
1484 check_for_instance_expiry VARCHAR2(1) := FND_API.G_TRUE,
1485 parent_tbl_index NUMBER := FND_API.G_MISS_NUM,
1486 fa_sync_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
1487 fa_mass_addition_id NUMBER := FND_API.G_MISS_NUM,
1488 creation_complete_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
1489 fa_sync_validation_reqd VARCHAR2(1) := FND_API.G_FALSE
1490 );
1491
1492 TYPE instance_asset_tbl IS TABLE OF instance_asset_rec INDEX BY BINARY_INTEGER;
1493
1494
1495
1496 -- Name : instance_asset_query_rec
1497 -- Package name : csi_datastructures_pub
1501
1498 -- Type : type definition, public
1499 -- Description : record to hold query columns for an instance-asset association.
1500
1502 TYPE instance_asset_query_rec IS RECORD
1503 (
1504 instance_asset_id NUMBER := FND_API.G_MISS_NUM,
1505 instance_id NUMBER := FND_API.G_MISS_NUM,
1506 fa_asset_id NUMBER := FND_API.G_MISS_NUM,
1507 fa_book_type_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
1508 fa_location_id NUMBER := FND_API.G_MISS_NUM,
1509 update_status VARCHAR2(30) := FND_API.G_MISS_CHAR,
1510 fa_mass_addition_id NUMBER := FND_API.G_MISS_NUM
1511 );
1512
1513 -- Name : party_account_header_rec
1514 -- Package name : csi_datastructures_pub
1515 -- Type : type definition, public
1516 -- Description : record to hold information about a party-account relationship.
1517
1518 TYPE party_account_header_rec IS RECORD
1519 (
1520 ip_account_id NUMBER := FND_API.G_MISS_NUM,
1521 instance_party_id NUMBER := FND_API.G_MISS_NUM,
1522 party_account_id NUMBER := FND_API.G_MISS_NUM,
1523 party_account_number VARCHAR2(30) := FND_API.G_MISS_CHAR,
1524 party_account_name VARCHAR2(240) := FND_API.G_MISS_CHAR,
1525 relationship_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
1526 bill_to_address NUMBER := FND_API.G_MISS_NUM,
1527 bill_to_location VARCHAR2(40) := FND_API.G_MISS_CHAR,
1528 ship_to_address NUMBER := FND_API.G_MISS_NUM,
1529 ship_to_location VARCHAR2(40) := FND_API.G_MISS_CHAR,
1530 active_start_date DATE := FND_API.G_MISS_DATE,
1531 active_end_date DATE := FND_API.G_MISS_DATE,
1532 context VARCHAR2(30) := FND_API.G_MISS_CHAR,
1533 attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1534 attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1535 attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1536 attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1537 attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1538 attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1539 attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1540 attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1541 attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1542 attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1543 attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1544 attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1545 attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1546 attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1547 attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1548 object_version_number NUMBER := FND_API.G_MISS_NUM,
1549 bill_to_address1 VARCHAR2(240) := FND_API.G_MISS_CHAR, -- Added for bug 2670371
1550 bill_to_address2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
1551 bill_to_address3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
1552 bill_to_address4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
1553 bill_to_city VARCHAR2(60) := FND_API.G_MISS_CHAR,
1554 bill_to_state VARCHAR2(60) := FND_API.G_MISS_CHAR,
1555 bill_to_postal_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
1556 bill_to_country VARCHAR2(60) := FND_API.G_MISS_CHAR,
1557 ship_to_address1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
1558 ship_to_address2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
1559 ship_to_address3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
1560 ship_to_address4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
1561 ship_to_city VARCHAR2(60) := FND_API.G_MISS_CHAR,
1562 ship_to_state VARCHAR2(60) := FND_API.G_MISS_CHAR,
1563 ship_to_postal_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
1564 ship_to_country VARCHAR2(60) := FND_API.G_MISS_CHAR
1565 );
1566
1567 TYPE party_account_header_tbl IS TABLE OF party_account_header_rec INDEX BY
1568 BINARY_INTEGER;
1569
1570 -- Name : org_unit_header_rec
1571 -- Package name : csi_datastructures_pub
1572 -- Type : type definition, public
1573 -- Description : record to hold information about an instance-org association.
1574
1575
1576 TYPE org_units_header_rec IS RECORD
1577 (
1578 instance_ou_id NUMBER := FND_API.G_MISS_NUM,
1579 instance_id NUMBER := FND_API.G_MISS_NUM,
1580 operating_unit_id NUMBER := FND_API.G_MISS_NUM,
1581 operating_unit_name VARCHAR2(60) := FND_API.G_MISS_CHAR,
1582 relationship_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
1583 active_start_date DATE := FND_API.G_MISS_DATE,
1584 active_end_date DATE := FND_API.G_MISS_DATE,
1585 context VARCHAR2(30) := FND_API.G_MISS_CHAR,
1586 attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1587 attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1588 attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1589 attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1590 attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1594 attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1591 attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1592 attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1593 attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1595 attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1596 attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1597 attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1598 attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1599 attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1600 attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1601 object_version_number NUMBER := FND_API.G_MISS_NUM,
1602 relationship_type_name VARCHAR2(80) := FND_API.G_MISS_CHAR
1603 );
1604
1605 TYPE org_units_header_tbl IS TABLE OF org_units_header_rec INDEX BY BINARY_INTEGER;
1606
1607
1608 -- Name : instance_asset_header_rec
1609 -- Package name : csi_datastructures_pub
1610 -- Type : type definition, public
1611 -- Description : record to hold query columns for an instance-asset association.
1612
1613 TYPE instance_asset_header_rec IS RECORD
1614 (
1615 instance_asset_id NUMBER := FND_API.G_MISS_NUM,
1616 instance_id NUMBER := FND_API.G_MISS_NUM,
1617 fa_asset_id NUMBER := FND_API.G_MISS_NUM,
1618 fa_book_type_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
1619 fa_location_id NUMBER := FND_API.G_MISS_NUM,
1620 asset_quantity NUMBER := FND_API.G_MISS_NUM,
1621 update_status VARCHAR2(30) := FND_API.G_MISS_CHAR,
1622 active_start_date DATE := FND_API.G_MISS_DATE,
1623 active_end_date DATE := FND_API.G_MISS_DATE,
1624 object_version_number NUMBER := FND_API.G_MISS_NUM,
1625 asset_number VARCHAR2(15) := FND_API.G_MISS_CHAR,
1626 serial_number VARCHAR2(35) := FND_API.G_MISS_CHAR,
1627 tag_number VARCHAR2(15) := FND_API.G_MISS_CHAR,
1628 category VARCHAR2(60) := FND_API.G_MISS_CHAR,
1629 fa_location_segment1 VARCHAR2(30) := FND_API.G_MISS_CHAR,
1630 fa_location_segment2 VARCHAR2(30) := FND_API.G_MISS_CHAR,
1631 fa_location_segment3 VARCHAR2(30) := FND_API.G_MISS_CHAR,
1632 fa_location_segment4 VARCHAR2(30) := FND_API.G_MISS_CHAR,
1633 fa_location_segment5 VARCHAR2(30) := FND_API.G_MISS_CHAR,
1634 fa_location_segment6 VARCHAR2(30) := FND_API.G_MISS_CHAR,
1635 fa_location_segment7 VARCHAR2(30) := FND_API.G_MISS_CHAR,
1636 date_placed_in_service DATE := FND_API.G_MISS_DATE,
1637 description VARCHAR2(80) := FND_API.G_MISS_CHAR,
1638 employee_name VARCHAR2(240) := FND_API.G_MISS_CHAR,
1639 expense_account_number VARCHAR2(25) := FND_API.G_MISS_CHAR,
1640 fa_mass_addition_id NUMBER := FND_API.G_MISS_NUM,
1641 creation_complete_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
1642 );
1643
1644 TYPE instance_asset_header_tbl IS TABLE of instance_asset_header_rec INDEX BY BINARY_INTEGER;
1645
1646
1647 /*--------------------------------------------------*/
1648 /* Record instance_history_rec */
1649 /* is used in retreiving history for a */
1650 /* given transaction */
1651 /*--------------------------------------------------*/
1652
1653 TYPE instance_history_rec IS RECORD
1654 (
1655 instance_id NUMBER
1656 ,old_instance_number VARCHAR2(30)
1657 ,new_instance_number VARCHAR2(30)
1658 ,old_external_reference VARCHAR2(30)
1659 ,new_external_reference VARCHAR2(30)
1660 ,old_inventory_item_id NUMBER
1661 ,new_inventory_item_id NUMBER
1662 ,old_inventory_revision VARCHAR2(3)
1663 ,new_inventory_revision VARCHAR2(3)
1664 ,old_inv_master_org_id NUMBER
1665 ,new_inv_master_org_id NUMBER
1666 ,old_serial_number VARCHAR2(30)
1667 ,new_serial_number VARCHAR2(30)
1668 ,old_mfg_serial_number_flag VARCHAR2(1)
1669 ,new_mfg_serial_number_flag VARCHAR2(1)
1670 ,old_lot_number VARCHAR2(80)
1671 ,new_lot_number VARCHAR2(80)
1672 ,old_quantity NUMBER
1673 ,new_quantity NUMBER
1674 ,old_unit_of_measure_name VARCHAR2(30)
1675 ,new_unit_of_measure_name VARCHAR2(30)
1676 ,old_unit_of_measure VARCHAR2(3)
1677 ,new_unit_of_measure VARCHAR2(3)
1678 ,old_accounting_class VARCHAR2(30)
1679 ,new_accounting_class VARCHAR2(30)
1680 ,old_accounting_class_code VARCHAR2(10)
1681 ,new_accounting_class_code VARCHAR2(10)
1682 ,old_instance_condition VARCHAR2(80)
1683 ,new_instance_condition VARCHAR2(80)
1684 ,old_instance_condition_id NUMBER
1685 ,new_instance_condition_id NUMBER
1686 ,old_instance_status VARCHAR2(50)
1687 ,new_instance_status VARCHAR2(50)
1688 ,old_instance_status_id NUMBER
1689 ,new_instance_status_id NUMBER
1690 ,old_customer_view_flag VARCHAR2(1)
1691 ,new_customer_view_flag VARCHAR2(1)
1692 ,old_merchant_view_flag VARCHAR2(1)
1696 ,old_system_id NUMBER
1693 ,new_merchant_view_flag VARCHAR2(1)
1694 ,old_sellable_flag VARCHAR2(1)
1695 ,new_sellable_flag VARCHAR2(1)
1697 ,new_system_id NUMBER
1698 ,old_system_name VARCHAR2(30)
1699 ,new_system_name VARCHAR2(30)
1700 ,old_instance_type_code VARCHAR2(30)
1701 ,new_instance_type_code VARCHAR2(30)
1702 ,old_instance_type_name VARCHAR2(240)
1703 ,new_instance_type_name VARCHAR2(240)
1704 ,old_active_start_date DATE
1705 ,new_active_start_date DATE
1706 ,old_active_end_date DATE
1707 ,new_active_end_date DATE
1708 ,old_location_type_code VARCHAR2(30)
1709 ,new_location_type_code VARCHAR2(30)
1710 ,old_location_id NUMBER
1711 ,new_location_id NUMBER
1712 ,old_inv_organization_id NUMBER
1713 ,new_inv_organization_id NUMBER
1714 ,old_inv_organization_name VARCHAR2(60)
1715 ,new_inv_organization_name VARCHAR2(60)
1716 ,old_inv_subinventory_name VARCHAR2(10)
1717 ,new_inv_subinventory_name VARCHAR2(10)
1718 ,old_inv_locator_id NUMBER
1719 ,new_inv_locator_id NUMBER
1720 ,old_pa_project_id NUMBER
1721 ,new_pa_project_id NUMBER
1722 ,old_pa_project_task_id NUMBER
1723 ,new_pa_project_task_id NUMBER
1724 ,old_pa_project_name VARCHAR2(30)
1725 ,new_pa_project_name VARCHAR2(30)
1726 ,old_pa_project_number VARCHAR2(25)
1727 ,new_pa_project_number VARCHAR2(25)
1728 ,old_pa_task_name VARCHAR2(20)
1729 ,new_pa_task_name VARCHAR2(20)
1730 ,old_pa_task_number VARCHAR2(25)
1731 ,new_pa_task_number VARCHAR2(25)
1732 ,old_in_transit_order_line_id NUMBER
1733 ,new_in_transit_order_line_id NUMBER
1734 ,old_in_transit_order_line_num NUMBER
1735 ,new_in_transit_order_line_num NUMBER
1736 ,old_in_transit_order_number NUMBER
1737 ,new_in_transit_order_number NUMBER
1738 ,old_wip_job_id NUMBER
1739 ,new_wip_job_id NUMBER
1740 ,old_wip_entity_name VARCHAR2(240)
1741 ,new_wip_entity_name VARCHAR2(240)
1742 ,old_po_order_line_id NUMBER
1743 ,new_po_order_line_id NUMBER
1744 ,old_last_oe_order_line_id NUMBER
1745 ,new_last_oe_order_line_id NUMBER
1746 ,old_last_oe_rma_line_id NUMBER
1747 ,new_last_oe_rma_line_id NUMBER
1748 ,old_last_po_po_line_id NUMBER
1749 ,new_last_po_po_line_id NUMBER
1750 ,old_last_oe_po_number VARCHAR2(50)
1751 ,new_last_oe_po_number VARCHAR2(50)
1752 ,old_last_wip_job_id NUMBER
1753 ,new_last_wip_job_id NUMBER
1754 ,old_last_pa_project_id NUMBER
1755 ,new_last_pa_project_id NUMBER
1756 ,old_last_pa_task_id NUMBER
1757 ,new_last_pa_task_id NUMBER
1758 ,old_last_oe_agreement_id NUMBER
1759 ,new_last_oe_agreement_id NUMBER
1760 ,old_install_date DATE
1761 ,new_install_date DATE
1762 ,old_manually_created_flag VARCHAR2(1)
1763 ,new_manually_created_flag VARCHAR2(1)
1764 ,old_return_by_date DATE
1765 ,new_return_by_date DATE
1766 ,old_actual_return_date DATE
1767 ,new_actual_return_date DATE
1768 ,old_creation_complete_flag VARCHAR2(1)
1769 ,new_creation_complete_flag VARCHAR2(1)
1770 ,old_completeness_flag VARCHAR2(1)
1771 ,new_completeness_flag VARCHAR2(1)
1772 ,old_context VARCHAR2(30)
1773 ,new_context VARCHAR2(30)
1774 ,old_attribute1 VARCHAR2(240)
1775 ,new_attribute1 VARCHAR2(240)
1776 ,old_attribute2 VARCHAR2(240)
1777 ,new_attribute2 VARCHAR2(240)
1778 ,old_attribute3 VARCHAR2(240)
1779 ,new_attribute3 VARCHAR2(240)
1780 ,old_attribute4 VARCHAR2(240)
1781 ,new_attribute4 VARCHAR2(240)
1782 ,old_attribute5 VARCHAR2(240)
1783 ,new_attribute5 VARCHAR2(240)
1784 ,old_attribute6 VARCHAR2(240)
1785 ,new_attribute6 VARCHAR2(240)
1786 ,old_attribute7 VARCHAR2(240)
1787 ,new_attribute7 VARCHAR2(240)
1788 ,old_attribute8 VARCHAR2(240)
1789 ,new_attribute8 VARCHAR2(240)
1790 ,old_attribute9 VARCHAR2(240)
1791 ,new_attribute9 VARCHAR2(240)
1792 ,old_attribute10 VARCHAR2(240)
1793 ,new_attribute10 VARCHAR2(240)
1794 ,old_attribute11 VARCHAR2(240)
1795 ,new_attribute11 VARCHAR2(240)
1796 ,old_attribute12 VARCHAR2(240)
1797 ,new_attribute12 VARCHAR2(240)
1798 ,old_attribute13 VARCHAR2(240)
1802 ,old_attribute15 VARCHAR2(240)
1799 ,new_attribute13 VARCHAR2(240)
1800 ,old_attribute14 VARCHAR2(240)
1801 ,new_attribute14 VARCHAR2(240)
1803 ,new_attribute15 VARCHAR2(240)
1804 ,old_last_txn_line_detail_id NUMBER
1805 ,new_last_txn_line_detail_id NUMBER
1806 ,old_install_location_type_code VARCHAR2(30)
1807 ,new_install_location_type_code VARCHAR2(30)
1808 ,old_install_location_id NUMBER
1809 ,new_install_location_id NUMBER
1810 ,old_instance_usage_code VARCHAR2(30)
1811 ,new_instance_usage_code VARCHAR2(30)
1812 ,old_current_loc_address1 VARCHAR2(240)
1813 ,new_current_loc_address1 VARCHAR2(240)
1814 ,old_current_loc_address2 VARCHAR2(240)
1815 ,new_current_loc_address2 VARCHAR2(240)
1816 ,old_current_loc_address3 VARCHAR2(240)
1817 ,new_current_loc_address3 VARCHAR2(240)
1818 ,old_current_loc_address4 VARCHAR2(240)
1819 ,new_current_loc_address4 VARCHAR2(240)
1820 ,old_current_loc_city VARCHAR2(60)
1821 ,new_current_loc_city VARCHAR2(60)
1822 ,old_current_loc_postal_code VARCHAR2(60)
1823 ,new_current_loc_postal_code VARCHAR2(60)
1824 ,old_current_loc_country VARCHAR2(60)
1825 ,new_current_loc_country VARCHAR2(60)
1826 ,old_sales_order_number NUMBER
1827 ,new_sales_order_number NUMBER
1828 ,old_sales_order_line_number NUMBER
1829 ,new_sales_order_line_number NUMBER
1830 ,old_sales_order_date DATE
1831 ,new_sales_order_date DATE
1832 ,old_purchase_order_number VARCHAR2(50)
1833 ,new_purchase_order_number VARCHAR2(50)
1834 ,old_instance_usage_name VARCHAR2(80)
1835 ,new_instance_usage_name VARCHAR2(80)
1836 ,old_current_loc_state VARCHAR2(60)
1837 ,new_current_loc_state VARCHAR2(60)
1838 ,old_install_loc_address1 VARCHAR2(240)
1839 ,new_install_loc_address1 VARCHAR2(240)
1840 ,old_install_loc_address2 VARCHAR2(240)
1841 ,new_install_loc_address2 VARCHAR2(240)
1842 ,old_install_loc_address3 VARCHAR2(240)
1843 ,new_install_loc_address3 VARCHAR2(240)
1844 ,old_install_loc_address4 VARCHAR2(240)
1845 ,new_install_loc_address4 VARCHAR2(240)
1846 ,old_install_loc_city VARCHAR2(60)
1847 ,new_install_loc_city VARCHAR2(60)
1848 ,old_install_loc_state VARCHAR2(60)
1849 ,new_install_loc_state VARCHAR2(60)
1850 ,old_install_loc_postal_code VARCHAR2(60)
1851 ,new_install_loc_postal_code VARCHAR2(60)
1852 ,old_install_loc_country VARCHAR2(60)
1853 ,new_install_loc_country VARCHAR2(60)
1854 ,old_config_inst_rev_num NUMBER
1855 ,new_config_inst_rev_num NUMBER
1856 ,old_config_valid_status VARCHAR2(30)
1857 ,new_config_valid_status VARCHAR2(30)
1858 ,old_instance_description VARCHAR2(240)
1859 ,new_instance_description VARCHAR2(240)
1860 ,instance_history_id NUMBER
1861 ,transaction_id NUMBER
1862 ,old_last_vld_organization_id NUMBER
1863 ,new_last_vld_organization_id NUMBER
1864 ,old_oe_agreement_name VARCHAR2(240)
1865 ,new_oe_agreement_name VARCHAR2(240)
1866 ,old_inv_locator_name VARCHAR2(240)
1867 ,new_inv_locator_name VARCHAR2(240)
1868 ,old_current_location_number VARCHAR2(30)
1869 ,new_current_location_number VARCHAR2(30)
1870 ,old_install_location_number VARCHAR2(30)
1871 ,new_install_location_number VARCHAR2(30)
1872 -- Start addition of columns for EAM integration
1873 ,old_network_asset_flag VARCHAR2(1)
1874 ,new_network_asset_flag VARCHAR2(1)
1875 ,old_maintainable_flag VARCHAR2(1)
1876 ,new_maintainable_flag VARCHAR2(1)
1877 ,old_pn_location_id NUMBER
1878 ,new_pn_location_id NUMBER
1879 ,old_asset_criticality_code VARCHAR2(30)
1880 ,new_asset_criticality_code VARCHAR2(30)
1881 --start bug 4754569--
1882 ,old_criticality VARCHAR2(80)
1883 ,new_criticality VARCHAR2(80)
1884 --end bug 4754569--
1885 ,old_category_id NUMBER
1886 ,new_category_id NUMBER
1887 --start bug 4754569--
1888 ,old_category_name VARCHAR2(163)
1889 ,new_category_name VARCHAR2(163)
1890 --end bug 4754569--
1891 ,old_maintainable VARCHAR2(5) --for bug 5211068
1892 ,new_maintainable VARCHAR2(5)
1893 ,old_equipment_gen_object_id NUMBER
1894 ,new_equipment_gen_object_id NUMBER
1895 ,old_instantiation_flag VARCHAR2(1)
1896 ,new_instantiation_flag VARCHAR2(1)
1897 ,old_linear_location_id NUMBER
1898 ,new_linear_location_id NUMBER
1899 ,old_operational_log_flag VARCHAR2(1)
1900 ,new_operational_log_flag VARCHAR2(1)
1901 ,old_checkin_status NUMBER
1902 ,new_checkin_status NUMBER
1903 ,old_supplier_warranty_exp_date DATE
1904 ,new_supplier_warranty_exp_date DATE
1908 ,new_attribute17 VARCHAR2(240)
1905 ,old_attribute16 VARCHAR2(240)
1906 ,new_attribute16 VARCHAR2(240)
1907 ,old_attribute17 VARCHAR2(240)
1909 ,old_attribute18 VARCHAR2(240)
1910 ,new_attribute18 VARCHAR2(240)
1911 ,old_attribute19 VARCHAR2(240)
1912 ,new_attribute19 VARCHAR2(240)
1913 ,old_attribute20 VARCHAR2(240)
1914 ,new_attribute20 VARCHAR2(240)
1915 ,old_attribute21 VARCHAR2(240)
1916 ,new_attribute21 VARCHAR2(240)
1917 ,old_attribute22 VARCHAR2(240)
1918 ,new_attribute22 VARCHAR2(240)
1919 ,old_attribute23 VARCHAR2(240)
1920 ,new_attribute23 VARCHAR2(240)
1921 ,old_attribute24 VARCHAR2(240)
1922 ,new_attribute24 VARCHAR2(240)
1923 ,old_attribute25 VARCHAR2(240)
1924 ,new_attribute25 VARCHAR2(240)
1925 ,old_attribute26 VARCHAR2(240)
1926 ,new_attribute26 VARCHAR2(240)
1927 ,old_attribute27 VARCHAR2(240)
1928 ,new_attribute27 VARCHAR2(240)
1929 ,old_attribute28 VARCHAR2(240)
1930 ,new_attribute28 VARCHAR2(240)
1931 ,old_attribute29 VARCHAR2(240)
1932 ,new_attribute29 VARCHAR2(240)
1933 ,old_attribute30 VARCHAR2(240)
1934 ,new_attribute30 VARCHAR2(240)
1935 -- End addition of columns for EAM integration
1936 -- Addition of columns for FA Integration
1937 ,old_payables_currency_code VARCHAR2(15)
1938 ,new_payables_currency_code VARCHAR2(15)
1939 ,old_purchase_unit_price NUMBER
1940 ,new_purchase_unit_price NUMBER
1941 ,old_purchase_currency_code VARCHAR2(15)
1942 ,new_purchase_currency_code VARCHAR2(15)
1943 ,old_payables_unit_price NUMBER
1944 ,new_payables_unit_price NUMBER
1945 ,old_sales_unit_price NUMBER
1946 ,new_sales_unit_price NUMBER
1947 ,old_sales_currency_code VARCHAR2(15)
1948 ,new_sales_currency_code VARCHAR2(15)
1949 ,old_operational_status_code VARCHAR2(30)
1950 ,new_operational_status_code VARCHAR2(30)
1951 -- End addition of columns for FA Integration
1952 ,full_dump_flag VARCHAR2(30) --Added for bug 5615169
1953 ,old_inventory_item_name VARCHAR2(240) --Bug 7292862
1954 ,new_inventory_item_name VARCHAR2(240) --Bug 7292862
1955 -- Begin Add Code for Siebel Genesis Project
1956 ,old_source_code VARCHAR2(10)
1957 ,new_source_code VARCHAR2(10)
1958 -- End Add Code for Siebel Genesis Project
1959 );
1960
1961 TYPE instance_history_tbl IS TABLE OF instance_history_rec INDEX BY BINARY_INTEGER;
1962
1963
1964 -- ins_asset_history_rec record used to retreive asset history
1965 -- for a particular transaction.
1966 TYPE ins_asset_history_rec IS RECORD
1967 (
1968 instance_asset_id NUMBER
1969 ,old_instance_id NUMBER
1970 ,new_instance_id NUMBER
1971 ,old_fa_asset_id NUMBER
1972 ,new_fa_asset_id NUMBER
1973 ,old_fa_book_type_code VARCHAR2(15)
1974 ,new_fa_book_type_code VARCHAR2(15)
1975 ,old_fa_location_id NUMBER
1976 ,new_fa_location_id NUMBER
1977 ,old_asset_quantity NUMBER
1978 ,new_asset_quantity NUMBER
1979 ,old_update_status VARCHAR2(30)
1980 ,new_update_status VARCHAR2(30)
1981 ,old_active_start_date DATE
1982 ,new_active_start_date DATE
1983 ,old_active_end_date DATE
1984 ,new_active_end_date DATE
1985 ,old_asset_number VARCHAR2(15)
1986 ,new_asset_number VARCHAR2(15)
1987 ,old_serial_number VARCHAR2(35)
1988 ,new_serial_number VARCHAR2(35)
1989 ,old_tag_number VARCHAR2(15)
1990 ,new_tag_number VARCHAR2(15)
1991 ,old_category VARCHAR2(60)
1992 ,new_category VARCHAR2(60)
1993 ,old_fa_location_segment1 VARCHAR2(30)
1994 ,new_fa_location_segment1 VARCHAR2(30)
1995 ,old_fa_location_segment2 VARCHAR2(30)
1996 ,new_fa_location_segment2 VARCHAR2(30)
1997 ,old_fa_location_segment3 VARCHAR2(30)
1998 ,new_fa_location_segment3 VARCHAR2(30)
1999 ,old_fa_location_segment4 VARCHAR2(30)
2000 ,new_fa_location_segment4 VARCHAR2(30)
2001 ,old_fa_location_segment5 VARCHAR2(30)
2002 ,new_fa_location_segment5 VARCHAR2(30)
2003 ,old_fa_location_segment6 VARCHAR2(30)
2004 ,new_fa_location_segment6 VARCHAR2(30)
2005 ,old_fa_location_segment7 VARCHAR2(30)
2006 ,new_fa_location_segment7 VARCHAR2(30)
2007 ,old_date_placed_in_service DATE
2008 ,new_date_placed_in_service DATE
2009 ,old_description VARCHAR2(80)
2010 ,new_description VARCHAR2(80)
2011 ,old_employee_name VARCHAR2(240)
2015 ,instance_id NUMBER
2012 ,new_employee_name VARCHAR2(240)
2013 ,old_expense_account_number VARCHAR2(25)
2014 ,new_expense_account_number VARCHAR2(25)
2016 ,instance_asset_history_id NUMBER
2017 ,transaction_id NUMBER
2018 ,old_fa_sync_flag VARCHAR2(1)
2019 ,new_fa_sync_flag VARCHAR2(1)
2020 ,old_fa_mass_addition_id NUMBER
2021 ,new_fa_mass_addition_id NUMBER
2022 ,old_creation_complete_flag VARCHAR2(1)
2023 ,new_creation_complete_flag VARCHAR2(1)
2024 );
2025
2026 TYPE ins_asset_history_tbl IS TABLE OF ins_asset_history_rec INDEX BY BINARY_INTEGER;
2027
2028 /*--------------------------------------------------*/
2029 /* Record ext_attrib_val_history_rec */
2030 /* is used in retreiving history for a */
2031 /* given transaction */
2032 /*--------------------------------------------------*/
2033
2034 TYPE ext_attrib_val_history_rec IS RECORD
2035 (
2036 attribute_value_id NUMBER
2037 ,transaction_id NUMBER
2038 ,old_attribute_value VARCHAR2(240)
2039 ,new_attribute_value VARCHAR2(240)
2040 ,old_active_start_date DATE
2041 ,new_active_start_date DATE
2042 ,old_active_end_date DATE
2043 ,new_active_end_date DATE
2044 ,old_context VARCHAR2(30)
2045 ,new_context VARCHAR2(30)
2046 ,old_attribute1 VARCHAR2(150)
2047 ,new_attribute1 VARCHAR2(150)
2048 ,old_attribute2 VARCHAR2(150)
2049 ,new_attribute2 VARCHAR2(150)
2050 ,old_attribute3 VARCHAR2(150)
2051 ,new_attribute3 VARCHAR2(150)
2052 ,old_attribute4 VARCHAR2(150)
2053 ,new_attribute4 VARCHAR2(150)
2054 ,old_attribute5 VARCHAR2(150)
2055 ,new_attribute5 VARCHAR2(150)
2056 ,old_attribute6 VARCHAR2(150)
2057 ,new_attribute6 VARCHAR2(150)
2058 ,old_attribute7 VARCHAR2(150)
2059 ,new_attribute7 VARCHAR2(150)
2060 ,old_attribute8 VARCHAR2(150)
2061 ,new_attribute8 VARCHAR2(150)
2062 ,old_attribute9 VARCHAR2(150)
2063 ,new_attribute9 VARCHAR2(150)
2064 ,old_attribute10 VARCHAR2(150)
2065 ,new_attribute10 VARCHAR2(150)
2066 ,old_attribute11 VARCHAR2(150)
2067 ,new_attribute11 VARCHAR2(150)
2068 ,old_attribute12 VARCHAR2(150)
2069 ,new_attribute12 VARCHAR2(150)
2070 ,old_attribute13 VARCHAR2(150)
2071 ,new_attribute13 VARCHAR2(150)
2072 ,old_attribute14 VARCHAR2(150)
2073 ,new_attribute14 VARCHAR2(150)
2074 ,old_attribute15 VARCHAR2(150)
2075 ,new_attribute15 VARCHAR2(150)
2076 ,instance_id NUMBER
2077 ,attribute_code VARCHAR2(30)
2078 ,attribute_value_history_id NUMBER );
2079
2080 TYPE ext_attrib_val_history_tbl IS TABLE OF ext_attrib_val_history_rec INDEX BY BINARY_INTEGER;
2081
2082
2083 /*---------------------------------------------------------*/
2084 /* Record name: party_history_rec */
2085 /* Description : Party history information */
2086 /* */
2087 /*---------------------------------------------------------*/
2088
2089
2090
2091 TYPE party_history_rec IS RECORD
2092 (
2093 INSTANCE_PARTY_HISTORY_ID NUMBER := FND_API.G_MISS_NUM,
2094 INSTANCE_PARTY_ID NUMBER := FND_API.G_MISS_NUM,
2095 TRANSACTION_ID NUMBER := FND_API.G_MISS_NUM,
2096 OLD_PARTY_SOURCE_TABLE VARCHAR2(30) := FND_API.G_MISS_CHAR,
2097 NEW_PARTY_SOURCE_TABLE VARCHAR2(30) := FND_API.G_MISS_CHAR,
2098 OLD_PARTY_ID NUMBER := FND_API.G_MISS_NUM,
2099 NEW_PARTY_ID NUMBER := FND_API.G_MISS_NUM,
2100 OLD_RELATIONSHIP_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
2101 NEW_RELATIONSHIP_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
2102 OLD_CONTACT_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
2103 NEW_CONTACT_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
2104 OLD_CONTACT_IP_ID NUMBER := FND_API.G_MISS_NUM,
2105 NEW_CONTACT_IP_ID NUMBER := FND_API.G_MISS_NUM,
2106 OLD_ACTIVE_START_DATE DATE := FND_API.G_MISS_DATE,
2107 NEW_ACTIVE_START_DATE DATE := FND_API.G_MISS_DATE,
2108 OLD_ACTIVE_END_DATE DATE := FND_API.G_MISS_DATE,
2109 NEW_ACTIVE_END_DATE DATE := FND_API.G_MISS_DATE,
2110 OLD_CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
2111 NEW_CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
2112 OLD_ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2113 NEW_ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2114 OLD_ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2115 NEW_ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2116 OLD_ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2117 NEW_ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2121 NEW_ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2118 OLD_ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2119 NEW_ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2120 OLD_ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2122 OLD_ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2123 NEW_ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2124 OLD_ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2125 NEW_ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2126 OLD_ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2127 NEW_ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2128 OLD_ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2129 NEW_ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2130 OLD_ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2131 NEW_ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2132 OLD_ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2133 NEW_ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2134 OLD_ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2135 NEW_ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2136 OLD_ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2137 NEW_ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2138 OLD_ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2139 NEW_ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2140 OLD_ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2141 NEW_ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2142 FULL_DUMP_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
2143 OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
2144 OLD_PREFERRED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
2145 NEW_PREFERRED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
2146 OLD_PRIMARY_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
2147 NEW_PRIMARY_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
2148 old_party_number VARCHAR2(30) := FND_API.G_MISS_CHAR,
2149 old_party_name VARCHAR2(360) := FND_API.G_MISS_CHAR,
2150 old_party_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
2151 old_contact_party_number VARCHAR2(30) := FND_API.G_MISS_CHAR,
2152 old_contact_party_name VARCHAR2(360) := FND_API.G_MISS_CHAR,
2153 old_contact_party_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
2154 old_contact_address1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
2155 old_contact_address2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
2156 old_contact_address3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
2157 old_contact_address4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
2158 old_contact_city VARCHAR2(60) := FND_API.G_MISS_CHAR,
2159 old_contact_state VARCHAR2(60) := FND_API.G_MISS_CHAR,
2160 old_contact_postal_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
2161 old_contact_country VARCHAR2(60) := FND_API.G_MISS_CHAR,
2162 old_contact_work_phone_num VARCHAR2(85) := FND_API.G_MISS_CHAR,
2163 old_contact_email_address VARCHAR2(2000) := FND_API.G_MISS_CHAR,
2164 new_party_number VARCHAR2(30) := FND_API.G_MISS_CHAR,
2165 new_party_name VARCHAR2(360) := FND_API.G_MISS_CHAR,
2166 new_party_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
2167 new_contact_party_number VARCHAR2(30) := FND_API.G_MISS_CHAR,
2168 new_contact_party_name VARCHAR2(360) := FND_API.G_MISS_CHAR,
2169 new_contact_party_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
2170 new_contact_address1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
2171 new_contact_address2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
2172 new_contact_address3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
2173 new_contact_address4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
2174 new_contact_city VARCHAR2(60) := FND_API.G_MISS_CHAR,
2175 new_contact_state VARCHAR2(60) := FND_API.G_MISS_CHAR,
2176 new_contact_postal_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
2177 new_contact_country VARCHAR2(60) := FND_API.G_MISS_CHAR,
2178 new_contact_work_phone_num VARCHAR2(85) := FND_API.G_MISS_CHAR,
2179 new_contact_email_address VARCHAR2(2000) := FND_API.G_MISS_CHAR,
2180 INSTANCE_ID NUMBER := FND_API.G_MISS_NUM);
2181
2182 TYPE party_history_tbl IS table of party_history_rec INDEX BY
2183 BINARY_INTEGER;
2184
2185
2186 /*---------------------------------------------------------*/
2187 /* Record name: account_history_rec */
2188 /* Description : Account history information */
2189 /* */
2190 /*---------------------------------------------------------*/
2191
2192 TYPE account_history_rec IS RECORD
2193 (
2194 IP_ACCOUNT_HISTORY_ID NUMBER := FND_API.G_MISS_NUM,
2195 IP_ACCOUNT_ID NUMBER := FND_API.G_MISS_NUM,
2196 TRANSACTION_ID NUMBER := FND_API.G_MISS_NUM,
2197 OLD_PARTY_ACCOUNT_ID NUMBER := FND_API.G_MISS_NUM,
2198 NEW_PARTY_ACCOUNT_ID NUMBER := FND_API.G_MISS_NUM,
2199 OLD_RELATIONSHIP_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
2200 NEW_RELATIONSHIP_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
2201 OLD_ACTIVE_START_DATE DATE := FND_API.G_MISS_DATE,
2202 NEW_ACTIVE_START_DATE DATE := FND_API.G_MISS_DATE,
2206 NEW_CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
2203 OLD_ACTIVE_END_DATE DATE := FND_API.G_MISS_DATE,
2204 NEW_ACTIVE_END_DATE DATE := FND_API.G_MISS_DATE,
2205 OLD_CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
2207 OLD_ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2208 NEW_ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2209 OLD_ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2210 NEW_ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2211 OLD_ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2212 NEW_ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2213 OLD_ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2214 NEW_ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2215 OLD_ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2216 NEW_ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2217 OLD_ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2218 NEW_ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2219 OLD_ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2220 NEW_ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2221 OLD_ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2222 NEW_ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2223 OLD_ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2224 NEW_ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2225 OLD_ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2226 NEW_ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2227 OLD_ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2228 NEW_ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2229 OLD_ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2230 NEW_ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2231 OLD_ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2232 NEW_ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2233 OLD_ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2234 NEW_ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2235 OLD_ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2236 NEW_ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2237 FULL_DUMP_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
2238 OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
2239 OLD_BILL_TO_ADDRESS NUMBER := FND_API.G_MISS_NUM,
2240 NEW_BILL_TO_ADDRESS NUMBER := FND_API.G_MISS_NUM,
2241 OLD_SHIP_TO_ADDRESS NUMBER := FND_API.G_MISS_NUM,
2242 NEW_SHIP_TO_ADDRESS NUMBER := FND_API.G_MISS_NUM,
2243 old_party_account_number VARCHAR2(30) := FND_API.G_MISS_CHAR,
2244 old_party_account_name VARCHAR2(240) := FND_API.G_MISS_CHAR,
2245 old_bill_to_location VARCHAR2(40) := FND_API.G_MISS_CHAR,
2246 old_ship_to_location VARCHAR2(40) := FND_API.G_MISS_CHAR,
2247 new_party_account_number VARCHAR2(30) := FND_API.G_MISS_CHAR,
2248 new_party_account_name VARCHAR2(240) := FND_API.G_MISS_CHAR,
2249 new_bill_to_location VARCHAR2(40) := FND_API.G_MISS_CHAR,
2250 new_ship_to_location VARCHAR2(40) := FND_API.G_MISS_CHAR,
2251 INSTANCE_ID NUMBER := FND_API.G_MISS_NUM,
2252 old_bill_to_address1 VARCHAR2(240) := FND_API.G_MISS_CHAR, --added for bug 2670371
2253 new_bill_to_address1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
2254 old_bill_to_address2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
2255 new_bill_to_address2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
2256 old_bill_to_address3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
2257 new_bill_to_address3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
2258 old_bill_to_address4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
2259 new_bill_to_address4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
2260 old_bill_to_city VARCHAR2(60) := FND_API.G_MISS_CHAR,
2261 new_bill_to_city VARCHAR2(60) := FND_API.G_MISS_CHAR,
2262 old_bill_to_state VARCHAR2(60) := FND_API.G_MISS_CHAR,
2263 new_bill_to_state VARCHAR2(60) := FND_API.G_MISS_CHAR,
2264 old_bill_to_postal_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
2265 new_bill_to_postal_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
2266 old_bill_to_country VARCHAR2(60) := FND_API.G_MISS_CHAR,
2267 new_bill_to_country VARCHAR2(60) := FND_API.G_MISS_CHAR,
2268 old_ship_to_address1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
2269 new_ship_to_address1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
2270 old_ship_to_address2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
2271 new_ship_to_address2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
2272 old_ship_to_address3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
2273 new_ship_to_address3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
2274 old_ship_to_address4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
2275 new_ship_to_address4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
2276 old_ship_to_city VARCHAR2(60) := FND_API.G_MISS_CHAR,
2277 new_ship_to_city VARCHAR2(60) := FND_API.G_MISS_CHAR,
2278 old_ship_to_state VARCHAR2(60) := FND_API.G_MISS_CHAR,
2279 new_ship_to_state VARCHAR2(60) := FND_API.G_MISS_CHAR,
2280 old_ship_to_postal_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
2284 old_instance_party_id NUMBER := FND_API.G_MISS_NUM, --Added on 04-04-03
2281 new_ship_to_postal_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
2282 old_ship_to_country VARCHAR2(60) := FND_API.G_MISS_CHAR,
2283 new_ship_to_country VARCHAR2(60) := FND_API.G_MISS_CHAR, --added for bug 2670371
2285 new_instance_party_id NUMBER := FND_API.G_MISS_NUM --Added
2286 );
2287 TYPE account_history_tbl IS table of account_history_rec INDEX BY
2288 BINARY_INTEGER;
2289
2290
2291
2292
2293
2294 TYPE org_units_history_rec IS RECORD
2295 (
2296 INSTANCE_OU_HISTORY_ID NUMBER := FND_API.G_MISS_NUM,
2297 INSTANCE_OU_ID NUMBER := FND_API.G_MISS_NUM,
2298 TRANSACTION_ID NUMBER := FND_API.G_MISS_NUM,
2299 OLD_OPERATING_UNIT_ID NUMBER := FND_API.G_MISS_NUM,
2300 NEW_OPERATING_UNIT_ID NUMBER := FND_API.G_MISS_NUM,
2301 OLD_RELATIONSHIP_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
2302 NEW_RELATIONSHIP_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
2303 OLD_ACTIVE_START_DATE DATE := FND_API.G_MISS_DATE,
2304 NEW_ACTIVE_START_DATE DATE := FND_API.G_MISS_DATE,
2305 OLD_ACTIVE_END_DATE DATE := FND_API.G_MISS_DATE,
2306 NEW_ACTIVE_END_DATE DATE := FND_API.G_MISS_DATE,
2307 OLD_CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
2308 NEW_CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
2309 OLD_ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2310 NEW_ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2311 OLD_ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2312 NEW_ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2313 OLD_ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2314 NEW_ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2315 OLD_ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2316 NEW_ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2317 OLD_ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2318 NEW_ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2319 OLD_ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2320 NEW_ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2321 OLD_ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2322 NEW_ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2323 OLD_ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2324 NEW_ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2325 OLD_ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2326 NEW_ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2327 OLD_ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2328 NEW_ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2329 OLD_ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2330 NEW_ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2331 OLD_ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2332 NEW_ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2333 OLD_ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2334 NEW_ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2335 OLD_ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2336 NEW_ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2337 OLD_ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2338 NEW_ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2339 FULL_DUMP_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
2340 OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
2341 new_operating_unit_name VARCHAR2(60) := FND_API.G_MISS_CHAR,
2342 old_operating_unit_name VARCHAR2(60) := FND_API.G_MISS_CHAR,
2343 INSTANCE_ID NUMBER := FND_API.G_MISS_NUM);
2344
2345 TYPE org_units_history_tbl IS TABLE OF org_units_history_rec INDEX BY BINARY_INTEGER;
2346
2347 TYPE version_label_history_rec IS RECORD
2348 (
2349 VERSION_LABEL_HISTORY_ID NUMBER := FND_API.G_MISS_NUM,
2350 VERSION_LABEL_ID NUMBER := FND_API.G_MISS_NUM,
2351 TRANSACTION_ID NUMBER := FND_API.G_MISS_NUM,
2352 OLD_VERSION_LABEL VARCHAR2(30) := FND_API.G_MISS_CHAR,
2353 NEW_VERSION_LABEL VARCHAR2(30) := FND_API.G_MISS_CHAR,
2354 OLD_DESCRIPTION VARCHAR2(240) := FND_API.G_MISS_CHAR,
2355 NEW_DESCRIPTION VARCHAR2(240) := FND_API.G_MISS_CHAR,
2356 OLD_DATE_TIME_STAMP DATE := FND_API.G_MISS_DATE,
2357 NEW_DATE_TIME_STAMP DATE := FND_API.G_MISS_DATE,
2358 OLD_ACTIVE_START_DATE DATE := FND_API.G_MISS_DATE,
2359 NEW_ACTIVE_START_DATE DATE := FND_API.G_MISS_DATE,
2360 OLD_ACTIVE_END_DATE DATE := FND_API.G_MISS_DATE,
2361 NEW_ACTIVE_END_DATE DATE := FND_API.G_MISS_DATE,
2362 OLD_CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
2363 NEW_CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
2364 OLD_ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2368 OLD_ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2365 NEW_ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2366 OLD_ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2367 NEW_ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2369 NEW_ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2370 OLD_ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2371 NEW_ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2372 OLD_ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2373 NEW_ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2374 OLD_ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2375 NEW_ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2376 OLD_ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2377 NEW_ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2378 OLD_ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2379 NEW_ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2380 OLD_ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2381 NEW_ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2382 OLD_ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2383 NEW_ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2384 OLD_ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2385 NEW_ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2386 OLD_ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2387 NEW_ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2388 OLD_ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2389 NEW_ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2390 OLD_ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2391 NEW_ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2392 OLD_ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2393 NEW_ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2394 FULL_DUMP_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
2395 OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
2396 INSTANCE_ID NUMBER := FND_API.G_MISS_NUM);
2397
2398
2399 TYPE version_label_history_tbl IS TABLE OF version_label_history_rec INDEX BY BINARY_INTEGER;
2400
2401 -- Name : transaction_header_rec
2402 -- Package name : csi_datastructures_pub
2403 -- Type : type definition, public
2404 -- Description : record to hold the attributes of an Installed Base transaction.
2405
2406 TYPE transaction_header_rec IS RECORD
2407 (
2408 TRANSACTION_ID NUMBER := FND_API.G_MISS_NUM ,
2409 TRANSACTION_DATE DATE := FND_API.G_MISS_DATE,
2410 SOURCE_TRANSACTION_DATE DATE := FND_API.G_MISS_DATE,
2411 TRANSACTION_TYPE_ID NUMBER := FND_API.G_MISS_NUM ,
2412 TXN_SUB_TYPE_ID NUMBER := FND_API.G_MISS_NUM ,
2413 SOURCE_GROUP_REF_ID NUMBER := FND_API.G_MISS_NUM ,
2414 SOURCE_GROUP_REF VARCHAR2(50),
2415 SOURCE_HEADER_REF_ID NUMBER := FND_API.G_MISS_NUM ,
2416 SOURCE_HEADER_REF VARCHAR2(240),
2417 SOURCE_LINE_REF_ID NUMBER := FND_API.G_MISS_NUM ,
2418 SOURCE_LINE_REF VARCHAR2(150), -- Changed for bug#15931790
2419 SOURCE_DIST_REF_ID1 NUMBER := FND_API.G_MISS_NUM ,
2420 SOURCE_DIST_REF_ID2 NUMBER := FND_API.G_MISS_NUM ,
2421 INV_MATERIAL_TRANSACTION_ID NUMBER := FND_API.G_MISS_NUM ,
2422 TRANSACTION_QUANTITY NUMBER := FND_API.G_MISS_NUM ,
2423 TRANSACTION_UOM_CODE VARCHAR2(3) := FND_API.G_MISS_CHAR,
2424 TRANSACTED_BY NUMBER := FND_API.G_MISS_NUM ,
2425 TRANSACTION_STATUS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
2426 TRANSACTION_ACTION_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
2427 MESSAGE_ID NUMBER := FND_API.G_MISS_NUM ,
2428 CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
2429 ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2430 ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2431 ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2432 ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2433 ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2434 ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2435 ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2436 ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2437 ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2438 ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2439 ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2440 ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2441 ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2442 ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2443 ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2444 OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
2445 SPLIT_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
2446 TXN_USER_ID NUMBER := FND_API.G_MISS_NUM,
2447 TXN_USER_NAME VARCHAR2(30) := FND_API.G_MISS_CHAR,
2451 TRANSACTION_STATUS_NAME VARCHAR2(80) := FND_API.G_MISS_CHAR
2448 TRANSACTION_TYPE_NAME VARCHAR2(50) := FND_API.G_MISS_CHAR,
2449 TXN_SUB_TYPE_NAME VARCHAR2(80) := FND_API.G_MISS_CHAR,
2450 SOURCE_APPLICATION_NAME VARCHAR2(240) := FND_API.G_MISS_CHAR,
2452 );
2453
2454 TYPE transaction_header_tbl IS TABLE OF transaction_header_rec INDEX BY BINARY_INTEGER;
2455
2456
2457 -- Name : Grp_Error_Rec
2458 -- Package name : csi_datastructures_pub
2459 -- Type : type definition, public
2460 -- Description : record to hold the status of the Interfaced record
2461
2462 TYPE Grp_Error_Rec IS RECORD
2463 (
2464 Group_Inst_Num NUMBER := FND_API.G_MISS_NUM,
2465 Process_Status VARCHAR2(1) := FND_API.G_MISS_CHAR,
2466 Error_Message VARCHAR2(2000) := FND_API.G_MISS_CHAR
2467 );
2468
2469
2470 TYPE Grp_Error_Tbl IS TABLE OF Grp_Error_Rec INDEX BY BINARY_INTEGER;
2471
2472 -- Name : Grp_Upd_Error_Rec
2473 -- Package name : csi_datastructures_pub
2474 -- Type : type definition, public
2475 -- Description : record to hold the status of the Updated Interfaced record
2476
2477 TYPE Grp_Upd_Error_Rec IS RECORD
2478 (
2479 Instance_id NUMBER := FND_API.G_MISS_NUM,
2480 Entity_Name VARCHAR2(30) := FND_API.G_MISS_CHAR,
2481 Error_Message VARCHAR2(2000) := FND_API.G_MISS_CHAR
2482 );
2483
2484 TYPE Grp_Upd_Error_Tbl IS TABLE OF Grp_Upd_Error_Rec INDEX BY BINARY_INTEGER;
2485
2486 TYPE system_header_rec IS RECORD
2487 (
2488 SYSTEM_ID NUMBER := FND_API.G_MISS_NUM ,
2489 OPERATING_UNIT_ID NUMBER := FND_API.G_MISS_NUM ,
2490 CUSTOMER_ID NUMBER := FND_API.G_MISS_NUM ,
2491 CUSTOMER_NAME VARCHAR2(360) := FND_API.G_MISS_CHAR ,
2492 CUSTOMER_PARTY_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR ,
2493 CUSTOMER_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR ,
2494 SYSTEM_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR ,
2495 SYSTEM_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR ,
2496 SYSTEM_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR ,
2497 PARENT_SYSTEM_ID NUMBER := FND_API.G_MISS_NUM ,
2498 TECHNICAL_CONTACT_ID NUMBER := FND_API.G_MISS_NUM ,
2499 SERVICE_ADMIN_CONTACT_ID NUMBER := FND_API.G_MISS_NUM ,
2500 INSTALL_SITE_USE_ID NUMBER := FND_API.G_MISS_NUM ,
2501 BILL_TO_CONTACT_ID NUMBER := FND_API.G_MISS_NUM ,
2502 BILL_TO_SITE_USE_ID NUMBER := FND_API.G_MISS_NUM ,
2503 SHIP_TO_SITE_USE_ID NUMBER := FND_API.G_MISS_NUM ,
2504 SHIP_TO_CONTACT_ID NUMBER := FND_API.G_MISS_NUM ,
2505 COTERMINATE_DAY_MONTH VARCHAR2(6) := FND_API.G_MISS_CHAR ,
2506 START_DATE_ACTIVE DATE := FND_API.G_MISS_DATE ,
2507 END_DATE_ACTIVE DATE := FND_API.G_MISS_DATE ,
2508 AUTOCREATED_FROM_SYSTEM_ID NUMBER := FND_API.G_MISS_NUM ,
2509 ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR ,
2510 ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR ,
2511 ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR ,
2512 ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR ,
2513 ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR ,
2514 ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR ,
2515 ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR ,
2516 ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR ,
2517 ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR ,
2518 ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR ,
2519 ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR ,
2520 ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR ,
2521 ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR ,
2522 ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR ,
2523 ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR ,
2524 CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR ,
2525 CONFIG_SYSTEM_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR ,
2526 NAME VARCHAR2(50) := FND_API.G_MISS_CHAR ,
2527 DESCRIPTION VARCHAR2(240) := FND_API.G_MISS_CHAR ,
2528 OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM ,
2529 SHIP_TO_CUSTOMER_ID NUMBER := FND_API.G_MISS_NUM ,
2530 SHIP_TO_CUSTOMER VARCHAR2(360) := FND_API.G_MISS_CHAR ,
2531 SHIP_TO_CUSTOMER_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR ,
2532 SHIP_PARTY_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR ,
2533 SHIP_TO_SITE_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR ,
2534 SHIP_TO_LOCATION_ID NUMBER := FND_API.G_MISS_NUM ,
2535 SHIP_DESCRIPTION VARCHAR2(2000) := FND_API.G_MISS_CHAR ,
2536 SHIP_TO_ADDRESS1 VARCHAR2(240) := FND_API.G_MISS_CHAR ,
2537 SHIP_TO_ADDRESS2 VARCHAR2(240) := FND_API.G_MISS_CHAR ,
2538 SHIP_TO_ADDRESS3 VARCHAR2(240) := FND_API.G_MISS_CHAR ,
2539 SHIP_TO_ADDRESS4 VARCHAR2(240) := FND_API.G_MISS_CHAR ,
2540 SHIP_TO_LOCATION VARCHAR2(40) := FND_API.G_MISS_CHAR ,
2541 SHIP_STATE VARCHAR2(60) := FND_API.G_MISS_CHAR ,
2542 SHIP_POSTAL_CODE VARCHAR2(60) := FND_API.G_MISS_CHAR ,
2546 INSTALL_CUSTOMER VARCHAR2(360) := FND_API.G_MISS_CHAR ,
2543 SHIP_COUNTRY VARCHAR2(60) := FND_API.G_MISS_CHAR ,
2544 INSTALL_CUSTOMER_ID NUMBER := FND_API.G_MISS_NUM ,
2545 INSTALL_CUSTOMER_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR ,
2547 INSTALL_PARTY_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR ,
2548 INSTALL_SITE_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR ,
2549 INSTALL_LOCATION_ID NUMBER := FND_API.G_MISS_NUM ,
2550 INSTALL_DESCRIPTION VARCHAR2(2000) := FND_API.G_MISS_CHAR ,
2551 INSTALL_ADDRESS1 VARCHAR2(240) := FND_API.G_MISS_CHAR ,
2552 INSTALL_ADDRESS2 VARCHAR2(240) := FND_API.G_MISS_CHAR ,
2553 INSTALL_ADDRESS3 VARCHAR2(240) := FND_API.G_MISS_CHAR ,
2554 INSTALL_ADDRESS4 VARCHAR2(240) := FND_API.G_MISS_CHAR ,
2555 INSTALL_LOCATION VARCHAR2(40) := FND_API.G_MISS_CHAR ,
2556 INSTALL_STATE VARCHAR2(60) := FND_API.G_MISS_CHAR ,
2557 INSTALL_POSTAL_CODE VARCHAR2(60) := FND_API.G_MISS_CHAR ,
2558 INSTALL_COUNTRY VARCHAR2(60) := FND_API.G_MISS_CHAR ,
2559 BILL_TO_CUSTOMER_ID NUMBER := FND_API.G_MISS_NUM ,
2560 BILL_TO_CUSTOMER_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR ,
2561 BILL_TO_CUSTOMER VARCHAR2(360) := FND_API.G_MISS_CHAR ,
2562 BILL_PARTY_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR ,
2563 BILL_TO_SITE_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR ,
2564 BILL_TO_LOCATION_ID NUMBER := FND_API.G_MISS_NUM ,
2565 BILL_DESCRIPTION VARCHAR2(2000) := FND_API.G_MISS_CHAR ,
2566 BILL_TO_ADDRESS1 VARCHAR2(240) := FND_API.G_MISS_CHAR ,
2567 BILL_TO_ADDRESS2 VARCHAR2(240) := FND_API.G_MISS_CHAR ,
2568 BILL_TO_ADDRESS3 VARCHAR2(240) := FND_API.G_MISS_CHAR ,
2569 BILL_TO_ADDRESS4 VARCHAR2(240) := FND_API.G_MISS_CHAR ,
2570 BILL_TO_LOCATION VARCHAR2(40) := FND_API.G_MISS_CHAR ,
2571 BILL_STATE VARCHAR2(60) := FND_API.G_MISS_CHAR ,
2572 BILL_POSTAL_CODE VARCHAR2(60) := FND_API.G_MISS_CHAR ,
2573 BILL_COUNTRY VARCHAR2(60) := FND_API.G_MISS_CHAR ,
2574 TECHNICAL_CONTACT_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR ,
2575 TECHNICAL_CONTACT VARCHAR2(360) := FND_API.G_MISS_CHAR ,
2576 SERVICE_ADMIN_CONTACT_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR ,
2577 SERVICE_ADMIN_CONTACT VARCHAR2(360) := FND_API.G_MISS_CHAR ,
2578 SHIP_TO_CONTACT_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR ,
2579 SHIP_TO_CONTACT VARCHAR2(360) := FND_API.G_MISS_CHAR ,
2580 BILL_TO_CONTACT_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR ,
2581 BILL_TO_CONTACT VARCHAR2(360) := FND_API.G_MISS_CHAR ,
2582 PARTY_ID NUMBER := FND_API.G_MISS_NUM ,
2583 PARTY_NAME VARCHAR2(360) := FND_API.G_MISS_CHAR ,
2584 PARENT_NAME VARCHAR2(50) := FND_API.G_MISS_CHAR ,
2585 PARENT_DESCRIPTION VARCHAR2(240) := FND_API.G_MISS_CHAR ,
2586 PARENT_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR ,
2587 OPERATING_UNIT_NAME VARCHAR2(60) := FND_API.G_MISS_CHAR
2588 );
2589
2590 TYPE system_header_tbl IS TABLE OF system_header_rec INDEX BY BINARY_INTEGER;
2591 --
2592 TYPE pricing_history_rec IS RECORD
2593 (
2594 PRICE_ATTRIB_HISTORY_ID NUMBER := FND_API.G_MISS_NUM,
2595 PRICING_ATTRIBUTE_ID NUMBER := FND_API.G_MISS_NUM,
2596 TRANSACTION_ID NUMBER := FND_API.G_MISS_NUM,
2597 OLD_PRICING_CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
2598 NEW_PRICING_CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
2599 OLD_PRICING_ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2600 NEW_PRICING_ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2601 OLD_PRICING_ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2602 NEW_PRICING_ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2603 OLD_PRICING_ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2604 NEW_PRICING_ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2605 OLD_PRICING_ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2606 NEW_PRICING_ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2607 OLD_PRICING_ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2608 NEW_PRICING_ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2609 OLD_PRICING_ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2610 NEW_PRICING_ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2611 OLD_PRICING_ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2612 NEW_PRICING_ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2613 OLD_PRICING_ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2614 NEW_PRICING_ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2615 OLD_PRICING_ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2616 NEW_PRICING_ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2617 OLD_PRICING_ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2618 NEW_PRICING_ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2619 OLD_PRICING_ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2620 NEW_PRICING_ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2621 OLD_PRICING_ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2622 NEW_PRICING_ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2623 OLD_PRICING_ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2624 NEW_PRICING_ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2628 NEW_PRICING_ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2625 OLD_PRICING_ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2626 NEW_PRICING_ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2627 OLD_PRICING_ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2629 OLD_PRICING_ATTRIBUTE16 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2630 NEW_PRICING_ATTRIBUTE16 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2631 OLD_PRICING_ATTRIBUTE17 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2632 NEW_PRICING_ATTRIBUTE17 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2633 OLD_PRICING_ATTRIBUTE18 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2634 NEW_PRICING_ATTRIBUTE18 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2635 OLD_PRICING_ATTRIBUTE19 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2636 NEW_PRICING_ATTRIBUTE19 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2637 OLD_PRICING_ATTRIBUTE20 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2638 NEW_PRICING_ATTRIBUTE20 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2639 OLD_PRICING_ATTRIBUTE21 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2640 NEW_PRICING_ATTRIBUTE21 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2641 OLD_PRICING_ATTRIBUTE22 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2642 NEW_PRICING_ATTRIBUTE22 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2643 OLD_PRICING_ATTRIBUTE23 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2644 NEW_PRICING_ATTRIBUTE23 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2645 OLD_PRICING_ATTRIBUTE24 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2646 NEW_PRICING_ATTRIBUTE24 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2647 NEW_PRICING_ATTRIBUTE25 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2648 OLD_PRICING_ATTRIBUTE25 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2649 OLD_PRICING_ATTRIBUTE26 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2650 NEW_PRICING_ATTRIBUTE26 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2651 OLD_PRICING_ATTRIBUTE27 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2652 NEW_PRICING_ATTRIBUTE27 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2653 OLD_PRICING_ATTRIBUTE28 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2654 NEW_PRICING_ATTRIBUTE28 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2655 OLD_PRICING_ATTRIBUTE29 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2656 NEW_PRICING_ATTRIBUTE29 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2657 OLD_PRICING_ATTRIBUTE30 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2658 NEW_PRICING_ATTRIBUTE30 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2659 OLD_PRICING_ATTRIBUTE31 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2660 NEW_PRICING_ATTRIBUTE31 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2661 OLD_PRICING_ATTRIBUTE32 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2662 NEW_PRICING_ATTRIBUTE32 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2663 OLD_PRICING_ATTRIBUTE33 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2664 NEW_PRICING_ATTRIBUTE33 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2665 OLD_PRICING_ATTRIBUTE34 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2666 NEW_PRICING_ATTRIBUTE34 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2667 OLD_PRICING_ATTRIBUTE35 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2668 NEW_PRICING_ATTRIBUTE35 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2669 OLD_PRICING_ATTRIBUTE36 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2670 NEW_PRICING_ATTRIBUTE36 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2671 OLD_PRICING_ATTRIBUTE37 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2672 NEW_PRICING_ATTRIBUTE37 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2673 OLD_PRICING_ATTRIBUTE38 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2674 NEW_PRICING_ATTRIBUTE38 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2675 OLD_PRICING_ATTRIBUTE39 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2676 NEW_PRICING_ATTRIBUTE39 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2677 OLD_PRICING_ATTRIBUTE40 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2678 NEW_PRICING_ATTRIBUTE40 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2679 OLD_PRICING_ATTRIBUTE41 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2680 NEW_PRICING_ATTRIBUTE41 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2681 OLD_PRICING_ATTRIBUTE42 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2682 NEW_PRICING_ATTRIBUTE42 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2683 OLD_PRICING_ATTRIBUTE43 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2684 NEW_PRICING_ATTRIBUTE43 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2685 OLD_PRICING_ATTRIBUTE44 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2686 NEW_PRICING_ATTRIBUTE44 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2687 OLD_PRICING_ATTRIBUTE45 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2688 NEW_PRICING_ATTRIBUTE45 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2689 OLD_PRICING_ATTRIBUTE46 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2690 NEW_PRICING_ATTRIBUTE46 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2691 OLD_PRICING_ATTRIBUTE47 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2692 NEW_PRICING_ATTRIBUTE47 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2693 OLD_PRICING_ATTRIBUTE48 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2694 NEW_PRICING_ATTRIBUTE48 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2695 OLD_PRICING_ATTRIBUTE49 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2696 NEW_PRICING_ATTRIBUTE49 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2697 OLD_PRICING_ATTRIBUTE50 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2698 NEW_PRICING_ATTRIBUTE50 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2699 OLD_PRICING_ATTRIBUTE51 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2700 NEW_PRICING_ATTRIBUTE51 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2701 OLD_PRICING_ATTRIBUTE52 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2702 NEW_PRICING_ATTRIBUTE52 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2706 NEW_PRICING_ATTRIBUTE54 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2703 OLD_PRICING_ATTRIBUTE53 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2704 NEW_PRICING_ATTRIBUTE53 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2705 OLD_PRICING_ATTRIBUTE54 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2707 OLD_PRICING_ATTRIBUTE55 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2708 NEW_PRICING_ATTRIBUTE55 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2709 OLD_PRICING_ATTRIBUTE56 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2710 NEW_PRICING_ATTRIBUTE56 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2711 OLD_PRICING_ATTRIBUTE57 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2712 NEW_PRICING_ATTRIBUTE57 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2713 OLD_PRICING_ATTRIBUTE58 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2714 NEW_PRICING_ATTRIBUTE58 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2715 OLD_PRICING_ATTRIBUTE59 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2716 NEW_PRICING_ATTRIBUTE59 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2717 OLD_PRICING_ATTRIBUTE60 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2718 NEW_PRICING_ATTRIBUTE60 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2719 OLD_PRICING_ATTRIBUTE61 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2720 NEW_PRICING_ATTRIBUTE61 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2721 OLD_PRICING_ATTRIBUTE62 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2722 NEW_PRICING_ATTRIBUTE62 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2723 OLD_PRICING_ATTRIBUTE63 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2724 NEW_PRICING_ATTRIBUTE63 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2725 OLD_PRICING_ATTRIBUTE64 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2726 NEW_PRICING_ATTRIBUTE64 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2727 OLD_PRICING_ATTRIBUTE65 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2728 NEW_PRICING_ATTRIBUTE65 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2729 OLD_PRICING_ATTRIBUTE66 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2730 NEW_PRICING_ATTRIBUTE66 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2731 OLD_PRICING_ATTRIBUTE67 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2732 NEW_PRICING_ATTRIBUTE67 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2733 OLD_PRICING_ATTRIBUTE68 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2734 NEW_PRICING_ATTRIBUTE68 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2735 OLD_PRICING_ATTRIBUTE69 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2736 NEW_PRICING_ATTRIBUTE69 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2737 OLD_PRICING_ATTRIBUTE70 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2738 NEW_PRICING_ATTRIBUTE70 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2739 OLD_PRICING_ATTRIBUTE71 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2740 NEW_PRICING_ATTRIBUTE71 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2741 OLD_PRICING_ATTRIBUTE72 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2742 NEW_PRICING_ATTRIBUTE72 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2743 OLD_PRICING_ATTRIBUTE73 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2744 NEW_PRICING_ATTRIBUTE73 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2745 OLD_PRICING_ATTRIBUTE74 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2746 NEW_PRICING_ATTRIBUTE74 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2747 OLD_PRICING_ATTRIBUTE75 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2748 NEW_PRICING_ATTRIBUTE75 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2749 OLD_PRICING_ATTRIBUTE76 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2750 NEW_PRICING_ATTRIBUTE76 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2751 OLD_PRICING_ATTRIBUTE77 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2752 NEW_PRICING_ATTRIBUTE77 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2753 OLD_PRICING_ATTRIBUTE78 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2754 NEW_PRICING_ATTRIBUTE78 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2755 OLD_PRICING_ATTRIBUTE79 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2756 NEW_PRICING_ATTRIBUTE79 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2757 OLD_PRICING_ATTRIBUTE80 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2758 NEW_PRICING_ATTRIBUTE80 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2759 OLD_PRICING_ATTRIBUTE81 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2760 NEW_PRICING_ATTRIBUTE81 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2761 OLD_PRICING_ATTRIBUTE82 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2762 NEW_PRICING_ATTRIBUTE82 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2763 OLD_PRICING_ATTRIBUTE83 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2764 NEW_PRICING_ATTRIBUTE83 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2765 OLD_PRICING_ATTRIBUTE84 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2766 NEW_PRICING_ATTRIBUTE84 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2767 OLD_PRICING_ATTRIBUTE85 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2768 NEW_PRICING_ATTRIBUTE85 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2769 OLD_PRICING_ATTRIBUTE86 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2770 NEW_PRICING_ATTRIBUTE86 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2771 OLD_PRICING_ATTRIBUTE87 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2772 NEW_PRICING_ATTRIBUTE87 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2773 OLD_PRICING_ATTRIBUTE88 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2774 NEW_PRICING_ATTRIBUTE88 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2775 OLD_PRICING_ATTRIBUTE89 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2776 NEW_PRICING_ATTRIBUTE89 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2777 OLD_PRICING_ATTRIBUTE90 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2778 NEW_PRICING_ATTRIBUTE90 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2779 OLD_PRICING_ATTRIBUTE91 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2780 NEW_PRICING_ATTRIBUTE91 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2784 NEW_PRICING_ATTRIBUTE93 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2781 OLD_PRICING_ATTRIBUTE92 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2782 NEW_PRICING_ATTRIBUTE92 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2783 OLD_PRICING_ATTRIBUTE93 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2785 OLD_PRICING_ATTRIBUTE94 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2786 NEW_PRICING_ATTRIBUTE94 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2787 OLD_PRICING_ATTRIBUTE95 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2788 NEW_PRICING_ATTRIBUTE95 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2789 OLD_PRICING_ATTRIBUTE96 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2790 NEW_PRICING_ATTRIBUTE96 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2791 OLD_PRICING_ATTRIBUTE97 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2792 NEW_PRICING_ATTRIBUTE97 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2793 OLD_PRICING_ATTRIBUTE98 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2794 NEW_PRICING_ATTRIBUTE98 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2795 OLD_PRICING_ATTRIBUTE99 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2796 NEW_PRICING_ATTRIBUTE99 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2797 OLD_PRICING_ATTRIBUTE100 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2798 NEW_PRICING_ATTRIBUTE100 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2799 OLD_ACTIVE_START_DATE DATE := FND_API.G_MISS_DATE,
2800 NEW_ACTIVE_START_DATE DATE := FND_API.G_MISS_DATE,
2801 OLD_ACTIVE_END_DATE DATE := FND_API.G_MISS_DATE,
2802 NEW_ACTIVE_END_DATE DATE := FND_API.G_MISS_DATE,
2803 OLD_CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
2804 NEW_CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
2805 OLD_ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2806 NEW_ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2807 OLD_ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2808 NEW_ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2809 OLD_ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2810 NEW_ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2811 OLD_ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2812 NEW_ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2813 OLD_ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2814 NEW_ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2815 OLD_ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2816 NEW_ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2817 OLD_ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2818 NEW_ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2819 OLD_ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2820 NEW_ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2821 OLD_ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2822 NEW_ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2823 OLD_ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2824 NEW_ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2825 OLD_ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2826 NEW_ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2827 OLD_ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2828 NEW_ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2829 OLD_ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2830 NEW_ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2831 OLD_ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2832 NEW_ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2833 OLD_ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2834 NEW_ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2835 FULL_DUMP_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
2836 );
2837
2838 TYPE pricing_history_tbl IS TABLE OF pricing_history_rec INDEX BY BINARY_INTEGER;
2839
2840 -- Name : instance_link_rec
2841 -- Package name : csi_datastructures_pub
2842 -- Type : type definition, public
2843 -- Description : record to hold the Start and End Loc. addresses for network linked instances.
2844
2845 TYPE instance_link_rec is RECORD
2846 (
2847 INSTANCE_ID NUMBER := FND_API.G_MISS_NUM,
2848 START_LOC_ADDRESS1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
2849 START_LOC_ADDRESS2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
2850 START_LOC_ADDRESS3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
2851 START_LOC_ADDRESS4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
2852 START_LOC_CITY VARCHAR2(60) := FND_API.G_MISS_CHAR,
2853 START_LOC_STATE VARCHAR2(60) := FND_API.G_MISS_CHAR,
2854 START_LOC_POSTAL_CODE VARCHAR2(60) := FND_API.G_MISS_CHAR,
2855 START_LOC_COUNTRY VARCHAR2(60) := FND_API.G_MISS_CHAR,
2856 END_LOC_ADDRESS1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
2857 END_LOC_ADDRESS2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
2858 END_LOC_ADDRESS3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
2859 END_LOC_ADDRESS4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
2860 END_LOC_CITY VARCHAR2(60) := FND_API.G_MISS_CHAR,
2861 END_LOC_STATE VARCHAR2(60) := FND_API.G_MISS_CHAR,
2862 END_LOC_POSTAL_CODE VARCHAR2(60) := FND_API.G_MISS_CHAR,
2863 END_LOC_COUNTRY VARCHAR2(60) := FND_API.G_MISS_CHAR
2864 );
2865
2866 TYPE instance_link_tbl is TABLE OF instance_link_rec INDEX BY BINARY_INTEGER;
2867
2868 /* Modified Instance rec type to add the 5 columns at the end , Added ext_attrib_values_rec - Bug ref 4352732 */
2869 -- Name : instance_cz_rec
2870 -- Package name : csi_datastructures_pub
2871 -- Type : table and rec type definition, public
2872 -- Description : This holds the data that is selected from both the
2873 -- Install Base Contact Center Tab as well as the
2874 -- Item instance Query UI.
2875
2876 TYPE instance_cz_rec IS RECORD
2877 (
2878 ITEM_INSTANCE_ID NUMBER := NULL,
2879 CONFIG_INSTANCE_HDR_ID NUMBER := NULL,
2880 CONFIG_INSTANCE_REV_NUMBER NUMBER := NULL,
2881 CONFIG_INSTANCE_ITEM_ID NUMBER := NULL,
2882 BILL_TO_SITE_USE_ID NUMBER := NULL,
2883 SHIP_TO_SITE_USE_ID NUMBER := NULL,
2884 SOLD_TO_ORG_ID NUMBER := NULL,
2885 INSTANCE_NAME VARCHAR2(240) := NULL,
2886 INSTANCE_SEQUENCE NUMBER := NULL,
2887 BILL_TO_CONTACT_ID NUMBER := NULL,
2888 SHIP_TO_CONTACT_ID NUMBER := NULL,
2889 IB_OWNER VARCHAR2(60) := NULL,
2890 ACTION VARCHAR2(30) := NULL
2891 );
2892
2893 TYPE instance_cz_tbl IS TABLE OF instance_cz_rec INDEX BY BINARY_INTEGER;
2894
2895 -- Name : ext_attrib_values_rec
2896 -- Description : Extended attribute Name,Value pair records
2897 -- Package name : csi_datastructures_pub
2898 -- Type : table and rec type definition, public
2899 -- Description : This holds the data that is passed on to Configurator
2900 -- from the Install base Contact Center Tab page
2901
2902 TYPE ext_attrib_values_rec IS RECORD
2903 (
2904 attribute_level VARCHAR2(15) := NULL,
2905 attribute_code VARCHAR2(30) := NULL,
2906 attribute_value VARCHAR2(240) := NULL,
2907 attribute_sequence NUMBER := NULL,
2908 parent_tbl_index NUMBER := NULL
2909 );
2910
2911 TYPE ext_attrib_values_tbl IS TABLE OF ext_attrib_values_rec INDEX BY BINARY_INTEGER;
2912
2913 /*-----------------------------------------------------------*/
2914 /* Record Name : contact_details_rec */
2915 /* Description : This record holds the details about a party */
2916 /* contact. */
2917 /*-----------------------------------------------------------*/
2918
2919 TYPE contact_details_rec IS RECORD
2920 (
2921 contact_party_id NUMBER,
2922 party_name VARCHAR2(360),
2923 address1 VARCHAR2(500),
2924 address2 VARCHAR2(500),
2925 address3 VARCHAR2(500),
2926 address4 VARCHAR2(500),
2927 city VARCHAR2(500),
2928 state VARCHAR2(500),
2929 postal_code VARCHAR2(500),
2930 country VARCHAR2(100),
2931 email VARCHAR2(2000),
2932 fax VARCHAR2(80),
2933 mobile VARCHAR2(80),
2934 page VARCHAR2(80),
2935 officephone VARCHAR2(80),
2936 homephone VARCHAR2(80)
2937 );
2938
2939 TYPE mtl_txn_rec IS RECORD(
2940 transaction_id number,
2941 transaction_date date,
2942 creation_date date,
2943 inventory_item_id number,
2944 organization_id number,
2945 --lot_number varchar2(30) ,
2946 lot_number varchar2(80) , --bug 10279935
2947 transaction_quantity number,
2948 transaction_uom varchar2(3),
2949 primary_quantity number,
2950 primary_uom varchar2(3),
2951 transaction_type_id number,
2952 transaction_action_id number,
2953 transaction_source_type_id number,
2954 transfer_transaction_id number,
2955 serial_control_code number,
2956 lot_control_code number,
2957 trx_source_line_id number,
2958 transaction_source_id number
2959 );
2960
2961 TYPE mtl_txn_tbl IS TABLE of mtl_txn_rec INDEX BY binary_integer;
2962
2963 -- Name : mu_system_rec
2964 -- Package name : csi_datastructures_pub
2965 -- Type : type definition, public
2966 -- Description : record to holds the system ids and flag to indicate whether they
2967 -- qualify for mass update
2968
2969 TYPE mu_system_rec is RECORD
2970 (
2971 SYSTEM_ID NUMBER := FND_API.G_MISS_NUM
2972 );
2973
2974 TYPE mu_systems_tbl IS TABLE OF mu_system_rec INDEX BY BINARY_INTEGER;
2975
2976
2977
2978 END csi_datastructures_pub;