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