[Home] [Help]
PACKAGE: APPS.CSE_DATASTRUCTURES_PUB
Source
1 package cse_datastructures_pub as
2 -- $Header: CSEDATAS.pls 120.4 2006/02/01 02:15:04 brmanesh noship $
3
4 G_IN_PROCESS CONSTANT VARCHAR2(30) := 'IN_PROCESS';
5 G_IN_INVENTORY CONSTANT VARCHAR2(30) := 'IN_INVENTORY';
6 G_IN_SERVICE CONSTANT VARCHAR2(30) := 'IN_SERVICE';
7 G_OUT_OF_SERVICE CONSTANT VARCHAR2(30) := 'OUT_OF_SERVICE';
8 G_IN_TRANSIT CONSTANT VARCHAR2(30) := 'IN_TRANSIT';
9 G_INSTALLED CONSTANT VARCHAR2(30) := 'INSTALLED';
10 G_COMPLETE CONSTANT VARCHAR2(30) := 'COMPLETE';
11 G_PENDING CONSTANT VARCHAR2(30) := 'PENDING';
12 G_INTERFACED_TO_PA CONSTANT VARCHAR2(30) := 'INTERFACED_TO_PA';
13 G_RETIRED CONSTANT VARCHAR2(30) := 'RETIRED';
14 G_TXN_ERROR CONSTANT VARCHAR2(1) := 'E';
15 G_BYPASS_FLAG CONSTANT VARCHAR2(1) := 'B';
16 G_SUCCESS_FLAG CONSTANT VARCHAR2(1) := 'S';
17 G_IB_UPDATE CONSTANT VARCHAR2(30) := 'IB_UPDATE';
18 G_PA_INTERFACE CONSTANT VARCHAR2(30) := 'PA_INTERFACE';
19 G_OUTBOUND CONSTANT VARCHAR2(30) := 'OUTBOUND';
20 G_BYPASS CONSTANT VARCHAR2(30) := 'BYPASS';
21 G_NOTIFY CONSTANT VARCHAR2(1) := 'N';
22 G_FA_UPDATE CONSTANT VARCHAR2(30) := 'FA_UPDATE';
23 G_COMP_ADJ_PENDING CONSTANT VARCHAR2(30) := 'COMP_ADJ_PENDING';
24
25 TYPE ASSET_ATTRIBUTES_REC_TYPE IS RECORD
26 ( ASSET_ID NUMBER,
27 BOOK_TYPE_CODE VARCHAR2(15),
28 UNITS NUMBER,
29 TRANSACTED_BY NUMBER,
30 TRANSACTION_DATE DATE,
31 Message_Id NUMBER
32 );
33 TYPE RCV_ATTRIBUTES_REC_TYPE IS RECORD
34 ( RCV_TRANSACTION_ID NUMBER,
35 Message_Id NUMBER
36 );
37
38 TYPE IPV_ATTRIBUTES_REC_TYPE IS RECORD
39 ( INVOICE_DISTRIBUTION_ID NUMBER,
40 Message_Id NUMBER
41 );
42 TYPE MTL_ITEM_REC_TYPE IS RECORD
43 ( INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
44 ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
45 SUBINVENTORY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
46 REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,
47 TRANSACTION_QUANTITY NUMBER := FND_API.G_MISS_NUM,
48 TRANSACTION_UOM VARCHAR2(3) := FND_API.G_MISS_CHAR,
49 TRANSACTION_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
50 TRANSACTION_ACTION_ID NUMBER := FND_API.G_MISS_NUM,
51 TRANSACTION_SOURCE_ID NUMBER := FND_API.G_MISS_NUM,
52 TRANSACTION_SOURCE_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
53 TRANSFER_LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
54 TRANSFER_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
55 TRANSFER_SUBINVENTORY VARCHAR2(10) := FND_API.G_MISS_CHAR,
56 LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
57 SOURCE_PROJECT_ID NUMBER := FND_API.G_MISS_NUM,
58 SOURCE_TASK_ID NUMBER := FND_API.G_MISS_NUM,
59 FROM_PROJECT_ID NUMBER := FND_API.G_MISS_NUM,
60 FROM_TASK_ID NUMBER := FND_API.G_MISS_NUM,
61 TO_PROJECT_ID NUMBER := FND_API.G_MISS_NUM,
62 TO_TASK_ID NUMBER := FND_API.G_MISS_NUM,
63 TRANSACTION_DATE DATE := FND_API.G_MISS_DATE,
64 LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
65 SERIAL_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
66 LOT_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
67 HR_LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
68 PO_DISTRIBUTION_ID NUMBER := FND_API.G_MISS_NUM,
69 SUBINV_LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
70 SHIPMENT_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
71 TRX_SOURCE_LINE_ID NUMBER := FND_API.G_MISS_NUM,
72 MOVE_ORDER_LINE_ID NUMBER := FND_API.G_MISS_NUM,
73 SERIAL_NUMBER_CONTROL_CODE NUMBER := FND_API.G_MISS_NUM,
74 SHIP_TO_LOCATION_ID NUMBER := FND_API.G_MISS_NUM
75 );
76 TYPE MTL_ITEM_TBL_TYPE is TABLE OF MTL_ITEM_REC_TYPE INDEX BY BINARY_INTEGER;
77
78 TYPE MTL_INSTANCE_REC_TYPE is RECORD
79 ( INSTANCE_ID NUMBER,
80 INSTANCE_NUMBER VARCHAR2(30),
81 INVENTORY_ITEM_ID NUMBER,
82 INVENTORY_REVISION VARCHAR2(3),
83 INV_MASTER_ORGANIZATION_ID NUMBER,
84 SERIAL_NUMBER VARCHAR2(30),
85 MFG_SERIAL_NUMBER_FLAG VARCHAR2(1),
86 LOT_NUMBER VARCHAR2(30),
87 QUANTITY NUMBER,
88 UNIT_OF_MEASURE VARCHAR2(3),
89 INSTANCE_STATUS_ID NUMBER,
90 CUSTOMER_VIEW_FLAG VARCHAR2(1),
91 MERCHANT_VIEW_FLAG VARCHAR2(1),
92 INSTANCE_TYPE_CODE VARCHAR2(30),
93 LOCATION_TYPE_CODE VARCHAR2(30),
94 LOCATION_ID NUMBER,
95 INV_ORGANIZATION_ID NUMBER,
96 INV_SUBINVENTORY_NAME VARCHAR2(10),
97 INV_LOCATOR_ID NUMBER,
98 PA_PROJECT_ID NUMBER,
99 PA_PROJECT_TASK_ID NUMBER
100 );
101 TYPE MTL_INSTANCE_TBL_TYPE is TABLE OF MTL_INSTANCE_REC_TYPE INDEX BY BINARY_INTEGER;
102
103 TYPE MTL_TRX_TYPE is RECORD
104 ( MTL_TRANSACTION_ID NUMBER);
105
106 TYPE PROJ_ITEM_UNINST_ATTR_REC_TYPE IS RECORD
107 ( ITEM_ID NUMBER,
108 REVISION VARCHAR2(3),
109 LOT_NUMBER VARCHAR2(30),
110 SERIAL_NUMBER VARCHAR2(30),
111 QUANTITY NUMBER,
112 NETWORK_LOCATION_ID NUMBER,
113 PARTY_SITE_ID NUMBER,
114 WORK_ORDER_NUMBER VARCHAR2(30),
115 PROJECT_ID NUMBER,
116 TASK_ID NUMBER,
117 TRANSACTION_DATE DATE,
118 TRANSACTED_BY NUMBER,
119 MESSAGE_ID NUMBER
120 );
121 TYPE PROJ_ITEM_UNINST_ATTR_TBL_TYPE is TABLE OF PROJ_ITEM_UNINST_ATTR_REC_TYPE INDEX BY BINARY_INTEGER;
122 TYPE PROJ_ITEM_INST_ATTR_REC_TYPE IS RECORD
123 ( ITEM_ID NUMBER,
124 REVISION VARCHAR2(3),
125 LOT_NUMBER VARCHAR2(30),
126 SERIAL_NUMBER VARCHAR2(30),
127 QUANTITY NUMBER,
128 NETWORK_LOCATION_ID NUMBER,
129 PARTY_SITE_ID NUMBER,
130 WORK_ORDER_NUMBER VARCHAR2(30),
131 PROJECT_ID NUMBER,
132 TASK_ID NUMBER,
133 TRANSACTION_DATE DATE,
134 TRANSACTED_BY NUMBER,
135 MESSAGE_ID NUMBER
136 );
137 TYPE PROJ_ITEM_INST_ATTR_TBL_TYPE is TABLE OF PROJ_ITEM_INST_ATTR_REC_TYPE INDEX BY BINARY_INTEGER;
138 TYPE OUT_OF_SERVICE_ATTR_REC_TYPE IS RECORD
139 ( ITEM_ID NUMBER,
140 REVISION VARCHAR2(3),
141 LOT_NUMBER VARCHAR2(30),
142 SERIAL_NUMBER VARCHAR2(30),
143 QUANTITY NUMBER,
144 NETWORK_LOCATION_ID NUMBER,
145 PARTY_SITE_ID NUMBER,
146 WORK_ORDER_NUMBER VARCHAR2(30),
147 TRANSACTION_DATE DATE,
148 TRANSACTED_BY NUMBER,
149 MESSAGE_ID NUMBER
150 );
151 TYPE OUT_OF_SERVICE_ATTR_TBL_TYPE is TABLE OF OUT_OF_SERVICE_ATTR_REC_TYPE INDEX BY BINARY_INTEGER;
152 TYPE IN_SERVICE_ATTR_REC_TYPE IS RECORD
153 ( ITEM_ID NUMBER,
154 REVISION VARCHAR2(3),
155 LOT_NUMBER VARCHAR2(30),
156 SERIAL_NUMBER VARCHAR2(30),
157 QUANTITY NUMBER,
158 NETWORK_LOCATION_ID NUMBER,
159 PARTY_SITE_ID NUMBER,
160 WORK_ORDER_NUMBER VARCHAR2(30),
161 TRANSACTION_DATE DATE,
162 TRANSACTED_BY NUMBER,
163 MESSAGE_ID NUMBER
164 );
165 TYPE IN_SERVICE_ATTR_TBL_TYPE is TABLE OF IN_SERVICE_ATTR_REC_TYPE INDEX BY BINARY_INTEGER;
166 TYPE ITEM_MOVE_ATTR_REC_TYPE IS RECORD
167 ( ITEM_ID NUMBER,
168 REVISION VARCHAR2(3),
169 LOT_NUMBER VARCHAR2(30),
170 SERIAL_NUMBER VARCHAR2(30),
171 QUANTITY NUMBER,
172 FROM_NETWORK_LOCATION_ID NUMBER,
173 TO_NETWORK_LOCATION_ID NUMBER,
174 FROM_PARTY_SITE_ID NUMBER,
175 TO_PARTY_SITE_ID NUMBER,
176 WORK_ORDER_NUMBER VARCHAR2(30),
177 TRANSACTION_DATE DATE,
178 TRANSACTED_BY NUMBER,
179 MESSAGE_ID NUMBER
180 );
181 TYPE ITEM_MOVE_ATTR_TBL_TYPE is TABLE OF ITEM_MOVE_ATTR_REC_TYPE INDEX BY BINARY_INTEGER;
182
183 TYPE PROJ_ITM_INSV_ATTR_REC_TYPE IS RECORD
184 ( ITEM_ID NUMBER,
185 REVISION VARCHAR2(3),
186 LOT_NUMBER VARCHAR2(30),
187 SERIAL_NUMBER VARCHAR2(30),
188 QUANTITY NUMBER,
189 NETWORK_LOCATION_ID NUMBER,
190 PARTY_SITE_ID NUMBER,
191 WORK_ORDER_NUMBER VARCHAR2(30),
192 PROJECT_ID NUMBER,
193 TASK_ID NUMBER,
194 EFFECTIVE_DATE DATE,
195 TRANSACTION_DATE DATE,
196 TRANSACTED_BY NUMBER,
197 MESSAGE_ID NUMBER
198 );
199 TYPE PROJ_ITM_INSV_ATTR_TBL_TYPE is TABLE OF PROJ_ITM_INSV_ATTR_REC_TYPE INDEX BY BINARY_INTEGER;
200
201 TYPE PROJ_ITM_INSV_PA_ATTR_REC_TYPE IS RECORD
202 ( ITEM_ID NUMBER,
203 INV_MASTER_ORG_ID NUMBER,
204 SERIAL_NUMBER VARCHAR2(30),
205 QUANTITY NUMBER,
206 LOCATION_ID NUMBER,
207 LOCATION_TYPE VARCHAR2(30),
208 PROJECT_ID NUMBER,
209 TASK_ID NUMBER,
210 INSTANCE_ID NUMBER,
211 OBJECT_VERSION_NUMBER NUMBER,
212 TRANSACTION_ID NUMBER,
213 TRANSACTION_DATE DATE,
214 TRANSACTED_BY NUMBER,
215 MESSAGE_ID NUMBER,
216 org_id number
217 );
218
219 TYPE PROJ_ITM_INSV_PA_ATTR_TBL_TYPE is TABLE OF PROJ_ITM_INSV_PA_ATTR_REC_TYPE INDEX BY BINARY_INTEGER;
220
221 TYPE Rcv_Txn_Rec_Type IS RECORD (
222 Rcv_Transaction_ID NUMBER,
223 Temp_Txn_Id NUMBER,
224 Organization_ID NUMBER,
225 Txn_Organization_ID NUMBER,
226 PO_Header_Id NUMBER,
227 PO_Line_Id NUMBER,
228 PO_Distribution_Id NUMBER,
229 Project_ID NUMBER,
230 Task_ID NUMBER,
231 Transacted_By NUMBER,
232 Transaction_Date DATE,
233 Inventory_Item_ID NUMBER,
234 Revision_Id VARCHAR2(3),
235 Lot_Number VARCHAR2(30),
236 Serial_Number VARCHAR2(30),
237 Quantity NUMBER,
238 UOM VARCHAR2(3),
239 Amount NUMBER,
240 CSI_Transaction_Id NUMBER,
241 PO_Number VARCHAR2(50),
242 PO_Line_Number VARCHAR2(50),
243 po_vendor_id number,
244 transaction_type varchar2(30),
245 destination_type_code varchar2(30));
246
247 TYPE Rcv_Txn_tbl_Type IS TABLE OF Rcv_Txn_Rec_Type INDEX BY BINARY_INTEGER;
248
249 TYPE IPV_Txn_Rec_Type IS RECORD (
250 Project_Id NUMBER,
251 Task_Id NUMBER,
252 Inventory_Item_Id NUMBER,
253 Item_Name VARCHAR2(30),
254 Serial_Number VARCHAR2(30),
255 Invoice_Distribution_Id NUMBER,
256 Accounting_Date DATE,
257 Invoice_Id NUMBER,
258 IPV NUMBER,
259 Transacted_By NUMBER,
260 Transaction_Date DATE,
261 Organization_Id NUMBER,
262 Invoice_Quantity NUMBER,
263 Price_Var_CC_Id NUMBER,
264 PO_Header_Id NUMBER,
265 PO_line_id NUMBER,
266 PO_distribution_id NUMBER,
267 Cr_CC_Id NUMBER,
268 Vendor_Number VARCHAR2(30),
269 UOM VARCHAR2(15),
270 CSI_Transaction_ID NUMBER,
271 INVOICE_NUMBER VARCHAR2(50));
272 TYPE IPV_Txn_tbl_Type IS TABLE OF IPV_Txn_Rec_Type
273 INDEX BY BINARY_INTEGER;
274
275 TYPE asset_query_rec IS RECORD
276 (
277 parent_mass_addition_id NUMBER := FND_API.G_MISS_NUM
278 ,mass_addition_id NUMBER := FND_API.G_MISS_NUM
279 ,asset_id NUMBER := FND_API.G_MISS_NUM
280 ,search_method VARCHAR2(4) := FND_API.G_MISS_CHAR
281 ,asset_number VARCHAR2(15) := FND_API.G_MISS_CHAR
282 ,category_id NUMBER := FND_API.G_MISS_NUM
283 ,book_type_code VARCHAR2(15) := FND_API.G_MISS_CHAR
284 ,date_placed_in_service DATE := FND_API.G_MISS_DATE
285 ,asset_key_ccid NUMBER := FND_API.G_MISS_NUM
286 ,tag_number VARCHAR2(15) := FND_API.G_MISS_CHAR
287 ,description VARCHAR2(80) := FND_API.G_MISS_CHAR
288 ,manufacturer_name VARCHAR2(30) := FND_API.G_MISS_CHAR
289 ,serial_number VARCHAR2(35) := FND_API.G_MISS_CHAR
290 ,model_number VARCHAR2(40) := FND_API.G_MISS_CHAR
291 ,location_id NUMBER := FND_API.G_MISS_NUM
292 ,employee_id NUMBER := FND_API.G_MISS_NUM
293 ,deprn_employee_id NUMBER := FND_API.G_MISS_NUM
294 ,deprn_expense_ccid NUMBER := FND_API.G_MISS_NUM
295 ,inventory_item_id NUMBER := FND_API.G_MISS_NUM
296 ,distribution_id NUMBER := FND_API.G_MISS_NUM
297 ,current_mtl_cost NUMBER := FND_API.G_MISS_NUM
301 ,pending_adj_non_mtl_cost NUMBER := FND_API.G_MISS_NUM
298 ,current_non_mtl_cost NUMBER := FND_API.G_MISS_NUM
299 ,current_units NUMBER := FND_API.G_MISS_NUM
300 ,pending_adj_mtl_cost NUMBER := FND_API.G_MISS_NUM
302 ,pending_ret_mtl_cost NUMBER := FND_API.G_MISS_NUM
303 ,pending_ret_non_mtl_cost NUMBER := FND_API.G_MISS_NUM
304 ,pending_ret_units NUMBER := FND_API.G_MISS_NUM
308 INDEX BY BINARY_INTEGER;
305 );
306
307 TYPE asset_query_tbl IS TABLE OF asset_query_rec
309
310
311 --bnarayan added for R12
312 TYPE asset_attrib_rec IS RECORD
313 (
314 Instance_ID NUMBER := FND_API.G_MISS_NUM
315 ,Inventory_Item_ID NUMBER := FND_API.G_MISS_NUM
316 ,Serial_Number VARCHAR2(30) := FND_API.G_MISS_CHAR
317 ,Organization_ID NUMBER := FND_API.G_MISS_NUM
318 ,INV_MASTER_Organization_ID NUMBER := FND_API.G_MISS_NUM
319 ,Subinventory_Name VARCHAR2(30) := FND_API.G_MISS_CHAR
320 ,Transaction_Quantity NUMBER := FND_API.G_MISS_NUM
321 ,Transaction_ID NUMBER := FND_API.G_MISS_NUM
322 ,Transaction_Date DATE := FND_API.G_MISS_DATE
323 ,Source_Transaction_type VARCHAR2(30) := FND_API.G_MISS_CHAR
324 ,Depreciable_Flag VARCHAR2(1) := FND_API.G_MISS_CHAR
325 ,Location_Type_Code VARCHAR2(40) := FND_API.G_MISS_CHAR
326 ,Transaction_Type_ID NUMBER := FND_API.G_MISS_NUM
327 ,Source_Header_Ref_ID NUMBER := FND_API.G_MISS_NUM
328 ,RCV_Transaction_ID NUMBER := FND_API.G_MISS_NUM
329 ,PO_Distribution_Id NUMBER := FND_API.G_MISS_NUM
330 ,Inv_Material_Transaction_ID NUMBER := FND_API.G_MISS_NUM
331 ,Location_id NUMBER := FND_API.G_MISS_NUM
332 ,Asset_Category_ID NUMBER := FND_API.G_MISS_NUM
333 ,book_type_code VARCHAR2(15) := FND_API.G_MISS_CHAR
334
335 );
336
337
338 TYPE asset_attrib_tbl IS TABLE OF asset_attrib_rec
339 INDEX BY BINARY_INTEGER;
340
341
342
343
344 TYPE distribution_rec IS RECORD
345 (
346 asset_id NUMBER := FND_API.G_MISS_NUM
347 ,book_type_code VARCHAR2(15) := FND_API.G_MISS_CHAR
348 ,distribution_id NUMBER := FND_API.G_MISS_NUM
349 ,location_id NUMBER := FND_API.G_MISS_NUM
350 ,employee_id NUMBER := FND_API.G_MISS_NUM
351 ,deprn_expense_ccid NUMBER := FND_API.G_MISS_NUM
352 ,current_units NUMBER := FND_API.G_MISS_NUM
353 ,pending_ret_units NUMBER := FND_API.G_MISS_NUM
354 );
355
356 TYPE distribution_tbl IS TABLE OF distribution_rec
357 INDEX BY BINARY_INTEGER ;
358
359 G_LIFO_SEARCH CONSTANT VARCHAR2(4) := 'LIFO';
360 G_FIFO_SEARCH CONSTANT VARCHAR2(4) := 'FIFO';
361 G_APPLICATION_NAME CONSTANT VARCHAR2(3) := 'CSE';
362
363 TYPE WFM_TRX_VALUES_REC is RECORD
364 ( INVENTORY_ITEM_ID NUMBER,
365 INVENTORY_REVISION VARCHAR2(3),
366 LOT_NUMBER VARCHAR2(30),
367 SERIAL_NUMBER VARCHAR2(30),
368 QUANTITY NUMBER,
369 NETWORK_LOCATION_ID NUMBER,
370 PARTY_SITE_ID NUMBER,
371 FROM_NETWORK_LOCATION_ID NUMBER,
372 TO_NETWORK_LOCATION_ID NUMBER,
373 FROM_PARTY_SITE_ID NUMBER,
374 TO_PARTY_SITE_ID NUMBER,
375 WORK_ORDER_NUMBER VARCHAR2(30),
376 SOURCE_TRANSACTION_DATE DATE,
377 SOURCE_TRANSACTION_BY NUMBER,
378 TRANSACTION_DATE DATE,
379 TRANSACTED_BY NUMBER,
380 EFFECTIVE_DATE DATE,
381 PROJECT_ID NUMBER,
382 TASK_ID NUMBER,
383 RETURN_STATUS VARCHAR2(1),
384 ERROR_MESSAGE VARCHAR2(2000)
385 );
386
387 TYPE WFM_TRX_VALUES_TBL IS TABLE OF WFM_TRX_VALUES_REC INDEX BY BINARY_INTEGER;
388
389 END CSE_DATASTRUCTURES_PUB;