[Home] [Help]
PACKAGE: APPS.OZF_AR_INTERFACE_PVT
Source
1 PACKAGE OZF_Ar_Interface_PVT AUTHID CURRENT_USER AS
2 /*$Header: ozfvaris.pls 120.7.12020000.4 2013/02/19 05:18:38 kdass ship $*/
3
4 /*=======================================================================+
5 | Declare PUBLIC Data Types and Variables
6 +=======================================================================*/
7
8 TYPE RA_Interface_Lines_Rec_Type IS RECORD
9 ( CREATED_BY NUMBER(15) :=NULL
10 , CREATION_DATE DATE :=NULL
11 , LAST_UPDATED_BY NUMBER(15) :=NULL
12 , LAST_UPDATE_DATE DATE :=NULL
13 , INTERFACE_LINE_ATTRIBUTE1 VARCHAR2(30) :=NULL
14 , INTERFACE_LINE_ATTRIBUTE2 VARCHAR2(30) :=NULL
15 , INTERFACE_LINE_ATTRIBUTE3 VARCHAR2(30) :=NULL
16 , INTERFACE_LINE_ATTRIBUTE4 VARCHAR2(30) :=NULL
17 , INTERFACE_LINE_ATTRIBUTE5 VARCHAR2(100) :=NULL --AMITAMKU - fix for Bug 16104747
18 , INTERFACE_LINE_ATTRIBUTE6 VARCHAR2(30) :=NULL
19 , INTERFACE_LINE_ATTRIBUTE7 VARCHAR2(30) :=NULL
20 , INTERFACE_LINE_ATTRIBUTE8 VARCHAR2(30) :=NULL
21 , INTERFACE_LINE_ATTRIBUTE9 VARCHAR2(30) :=NULL
22 , INTERFACE_LINE_ATTRIBUTE10 VARCHAR2(30) :=NULL
23 , INTERFACE_LINE_ATTRIBUTE11 VARCHAR2(30) :=NULL
24 , INTERFACE_LINE_ATTRIBUTE12 VARCHAR2(30) :=NULL
25 , INTERFACE_LINE_ATTRIBUTE13 VARCHAR2(30) :=NULL
26 , INTERFACE_LINE_ATTRIBUTE14 VARCHAR2(30) :=NULL
27 , INTERFACE_LINE_ATTRIBUTE15 VARCHAR2(30) :=NULL
28 , INTERFACE_LINE_CONTEXT VARCHAR2(30) :=NULL
29 , BATCH_SOURCE_NAME VARCHAR2(50) :=NULL
30 , GL_DATE DATE :=NULL -- *
31 , SET_OF_BOOKS_ID NUMBER(15) :=NULL -- *
32 , LINE_TYPE VARCHAR2(20) :=NULL
33 , DESCRIPTION VARCHAR2(240) :=NULL
34 , CURRENCY_CODE VARCHAR2(15) :=NULL -- *
35 , AMOUNT NUMBER :=NULL
36 , CONVERSION_TYPE VARCHAR2(30) :=NULL -- *
37 , CONVERSION_DATE DATE :=NULL -- *
38 , CONVERSION_RATE NUMBER :=NULL -- *
39 , CUST_TRX_TYPE_ID NUMBER(15) :=NULL -- *
40 , TERM_ID NUMBER(15) :=NULL -- *
41 , ORIG_SYSTEM_BILL_CUSTOMER_ID NUMBER(15) :=NULL -- *
42 --Bug# 8619806 fixed by ateotia(+)
43 --, ORIG_SYSTEM_BILL_ADDRESS_ID NUMBER(15) :=NULL -- *
44 , ORIG_SYSTEM_BILL_ADDRESS_ID NUMBER :=NULL
45 --Bug# 8619806 fixed by ateotia(-)
46 , ORIG_SYSTEM_BILL_CONTACT_ID NUMBER(15) :=NULL -- *
47 , ORIG_SYSTEM_SHIP_CUSTOMER_ID NUMBER(15) :=NULL -- *
48 --Bug# 8619806 fixed by ateotia(+)
49 --, ORIG_SYSTEM_SHIP_ADDRESS_ID NUMBER(15) :=NULL -- *
50 , ORIG_SYSTEM_SHIP_ADDRESS_ID NUMBER :=NULL
51 --Bug# 8619806 fixed by ateotia(-)
52 , ORIG_SYSTEM_SHIP_CONTACT_ID NUMBER(15) :=NULL -- *
53 , ORIG_SYSTEM_SOLD_CUSTOMER_ID NUMBER(15) :=NULL -- *
54 , ORG_ID NUMBER(15) :=NULL
55 /* Attributes required by grouping rule and are not selected above */
56 , AGREEMENT_ID NUMBER(15) :=NULL
57 --, COMMENTS VARCHAR2(240) :=NULL
58 , COMMENTS VARCHAR2(1760) :=NULL -- Fix for Bug: 6116037
59 , CREDIT_METHOD_FOR_ACCT_RULE VARCHAR2(30) :=NULL --Fix for Bug 13596752
60 , CREDIT_METHOD_FOR_INSTALLMENTS VARCHAR2(30) :=NULL
61 , CUSTOMER_BANK_ACCOUNT_ID NUMBER(15) :=NULL
62 , DOCUMENT_NUMBER NUMBER(15) :=NULL
63 , DOCUMENT_NUMBER_SEQUENCE_ID NUMBER(15) :=NULL
64 , HEADER_ATTRIBUTE_CATEGORY VARCHAR2(30) :=NULL
65 , HEADER_ATTRIBUTE1 VARCHAR2(150) :=NULL
66 , HEADER_ATTRIBUTE2 VARCHAR2(150) :=NULL
67 , HEADER_ATTRIBUTE3 VARCHAR2(150) :=NULL
68 , HEADER_ATTRIBUTE4 VARCHAR2(150) :=NULL
69 , HEADER_ATTRIBUTE5 VARCHAR2(150) :=NULL
70 , HEADER_ATTRIBUTE6 VARCHAR2(150) :=NULL
71 , HEADER_ATTRIBUTE7 VARCHAR2(150) :=NULL
72 , HEADER_ATTRIBUTE8 VARCHAR2(150) :=NULL
73 , HEADER_ATTRIBUTE9 VARCHAR2(150) :=NULL
74 , HEADER_ATTRIBUTE10 VARCHAR2(150) :=NULL
75 , HEADER_ATTRIBUTE11 VARCHAR2(150) :=NULL
76 , HEADER_ATTRIBUTE12 VARCHAR2(150) :=NULL
77 , HEADER_ATTRIBUTE13 VARCHAR2(150) :=NULL
78 , HEADER_ATTRIBUTE14 VARCHAR2(150) :=NULL
79 , HEADER_ATTRIBUTE15 VARCHAR2(150) :=NULL
80 , INITIAL_CUSTOMER_TRX_ID NUMBER(15) :=NULL
81 , INTERNAL_NOTES VARCHAR2(240) :=NULL
82 , INVOICING_RULE_ID NUMBER(15) :=NULL
83 , ORIG_SYSTEM_BATCH_NAME VARCHAR2(40) :=NULL
84 , PREVIOUS_CUSTOMER_TRX_ID NUMBER(15) :=NULL
85 , PRIMARY_SALESREP_ID NUMBER(15) :=NULL
86 , PRINTING_OPTION VARCHAR2(20) :=NULL
87 , PURCHASE_ORDER VARCHAR2(50) :=NULL
88 , PURCHASE_ORDER_REVISION VARCHAR2(50) :=NULL
89 , PURCHASE_ORDER_DATE DATE :=NULL
90 , REASON_CODE VARCHAR2(30) :=NULL
91 , RECEIPT_METHOD_ID NUMBER(15) :=NULL
92 , RELATED_CUSTOMER_TRX_ID NUMBER(15) :=NULL
93 , TERRITORY_ID NUMBER(15) :=NULL
94 , TRX_DATE DATE :=NULL
95 , TRX_NUMBER VARCHAR2(20) :=NULL
96 , MEMO_LINE_ID NUMBER(15) :=NULL
97 /* 18-FEb-2002 MCHANG: Attributes required by passing tax lines */
98 , TAX_CODE VARCHAR2(50) :=NULL
99 , TAX_RATE NUMBER :=NULL
100 , LINK_TO_LINE_CONTEXT VARCHAR2(30) :=NULL
101 , LINK_TO_LINE_ATTRIBUTE1 VARCHAR2(30) :=NULL
102 , LINK_TO_LINE_ATTRIBUTE2 VARCHAR2(30) :=NULL
103 , LINK_TO_LINE_ATTRIBUTE3 VARCHAR2(30) :=NULL
104 , LINK_TO_LINE_ATTRIBUTE4 VARCHAR2(30) :=NULL
105 , LINK_TO_LINE_ATTRIBUTE5 VARCHAR2(30) :=NULL
106 , LINK_TO_LINE_ATTRIBUTE6 VARCHAR2(30) :=NULL
107 , LINK_TO_LINE_ATTRIBUTE7 VARCHAR2(30) :=NULL
108 , LINK_TO_LINE_ATTRIBUTE8 VARCHAR2(30) :=NULL
109 , LINK_TO_LINE_ATTRIBUTE9 VARCHAR2(30) :=NULL
110 , LINK_TO_LINE_ATTRIBUTE10 VARCHAR2(30) :=NULL
111 , LINK_TO_LINE_ATTRIBUTE11 VARCHAR2(30) :=NULL
112 , LINK_TO_LINE_ATTRIBUTE12 VARCHAR2(30) :=NULL
113 , LINK_TO_LINE_ATTRIBUTE13 VARCHAR2(30) :=NULL
114 , LINK_TO_LINE_ATTRIBUTE14 VARCHAR2(30) :=NULL
115 , LINK_TO_LINE_ATTRIBUTE15 VARCHAR2(30) :=NULL
116 , INVENTORY_ITEM_ID NUMBER :=NULL
117 , QUANTITY NUMBER :=NULL
118 , UOM_CODE VARCHAR2(3) :=NULL
119 , UNIT_SELLING_PRICE NUMBER :=NULL
120 , LEGAL_ENTITY_ID NUMBER(15) :=NULL
121 );
122
123 TYPE RA_Interface_Lines_Tbl_Type IS TABLE OF RA_Interface_Lines_Rec_Type
124 INDEX BY BINARY_INTEGER;
125
126
127 TYPE RA_Int_Distributions_Rec_Type IS RECORD
128 (
129 INTERFACE_DISTRIBUTION_ID NUMBER(15),
130 INTERFACE_LINE_ID NUMBER(15),
131 INTERFACE_LINE_CONTEXT VARCHAR2(30),
132 INTERFACE_LINE_ATTRIBUTE1 VARCHAR2(30),
133 INTERFACE_LINE_ATTRIBUTE2 VARCHAR2(30),
134 INTERFACE_LINE_ATTRIBUTE3 VARCHAR2(30),
135 INTERFACE_LINE_ATTRIBUTE4 VARCHAR2(30),
136 INTERFACE_LINE_ATTRIBUTE5 VARCHAR2(100), --AMITAMKU - fix for Bug 16104747
137 INTERFACE_LINE_ATTRIBUTE6 VARCHAR2(30),
138 INTERFACE_LINE_ATTRIBUTE7 VARCHAR2(30),
139 INTERFACE_LINE_ATTRIBUTE8 VARCHAR2(30),
140 INTERFACE_LINE_ATTRIBUTE9 VARCHAR2(30),
141 INTERFACE_LINE_ATTRIBUTE10 VARCHAR2(30),
142 INTERFACE_LINE_ATTRIBUTE11 VARCHAR2(30),
143 INTERFACE_LINE_ATTRIBUTE12 VARCHAR2(30),
144 INTERFACE_LINE_ATTRIBUTE13 VARCHAR2(30),
145 INTERFACE_LINE_ATTRIBUTE14 VARCHAR2(30),
146 INTERFACE_LINE_ATTRIBUTE15 VARCHAR2(30),
147 ACCOUNT_CLASS VARCHAR2(20),
148 AMOUNT NUMBER,
149 ACCTD_AMOUNT NUMBER,
150 PERCENT NUMBER,
151 INTERFACE_STATUS VARCHAR2(1),
152 REQUEST_ID NUMBER(15),
153 CODE_COMBINATION_ID NUMBER(15),
154 SEGMENT1 VARCHAR2(25),
155 SEGMENT2 VARCHAR2(25),
156 SEGMENT3 VARCHAR2(25),
157 SEGMENT4 VARCHAR2(25),
158 SEGMENT5 VARCHAR2(25),
159 SEGMENT6 VARCHAR2(25),
160 SEGMENT7 VARCHAR2(25),
161 SEGMENT8 VARCHAR2(25),
162 SEGMENT9 VARCHAR2(25),
163 SEGMENT10 VARCHAR2(25),
164 SEGMENT11 VARCHAR2(25),
165 SEGMENT12 VARCHAR2(25),
166 SEGMENT13 VARCHAR2(25),
167 SEGMENT14 VARCHAR2(25),
168 SEGMENT15 VARCHAR2(25),
169 SEGMENT16 VARCHAR2(25),
170 SEGMENT17 VARCHAR2(25),
171 SEGMENT18 VARCHAR2(25),
172 SEGMENT19 VARCHAR2(25),
173 SEGMENT20 VARCHAR2(25),
174 SEGMENT21 VARCHAR2(25),
175 SEGMENT22 VARCHAR2(25),
176 SEGMENT23 VARCHAR2(25),
177 SEGMENT24 VARCHAR2(25),
178 SEGMENT25 VARCHAR2(25),
179 SEGMENT26 VARCHAR2(25),
180 SEGMENT27 VARCHAR2(25),
181 SEGMENT28 VARCHAR2(25),
182 SEGMENT29 VARCHAR2(25),
183 SEGMENT30 VARCHAR2(25),
184 COMMENTS VARCHAR2(240),
185 ATTRIBUTE_CATEGORY VARCHAR2(30),
186 ATTRIBUTE1 VARCHAR2(150),
187 ATTRIBUTE2 VARCHAR2(150),
188 ATTRIBUTE3 VARCHAR2(150),
189 ATTRIBUTE4 VARCHAR2(150),
190 ATTRIBUTE5 VARCHAR2(150),
191 ATTRIBUTE6 VARCHAR2(150),
192 ATTRIBUTE7 VARCHAR2(150),
193 ATTRIBUTE8 VARCHAR2(150),
194 ATTRIBUTE9 VARCHAR2(150),
195 ATTRIBUTE10 VARCHAR2(150),
196 ATTRIBUTE11 VARCHAR2(150),
197 ATTRIBUTE12 VARCHAR2(150),
198 ATTRIBUTE13 VARCHAR2(150),
199 ATTRIBUTE14 VARCHAR2(150),
200 ATTRIBUTE15 VARCHAR2(150),
201 CREATED_BY NUMBER(15),
202 CREATION_DATE DATE,
203 LAST_UPDATED_BY NUMBER(15),
204 LAST_UPDATE_DATE DATE,
205 LAST_UPDATE_LOGIN NUMBER(15),
206 ORG_ID NUMBER(15),
207 INTERIM_TAX_CCID NUMBER(15),
208 INTERIM_TAX_SEGMENT1 VARCHAR2(25),
209 INTERIM_TAX_SEGMENT2 VARCHAR2(25),
210 INTERIM_TAX_SEGMENT3 VARCHAR2(25),
211 INTERIM_TAX_SEGMENT4 VARCHAR2(25),
212 INTERIM_TAX_SEGMENT5 VARCHAR2(25),
213 INTERIM_TAX_SEGMENT6 VARCHAR2(25),
214 INTERIM_TAX_SEGMENT7 VARCHAR2(25),
215 INTERIM_TAX_SEGMENT8 VARCHAR2(25),
216 INTERIM_TAX_SEGMENT9 VARCHAR2(25),
217 INTERIM_TAX_SEGMENT10 VARCHAR2(25),
218 INTERIM_TAX_SEGMENT11 VARCHAR2(25),
219 INTERIM_TAX_SEGMENT12 VARCHAR2(25),
220 INTERIM_TAX_SEGMENT13 VARCHAR2(25),
221 INTERIM_TAX_SEGMENT14 VARCHAR2(25),
222 INTERIM_TAX_SEGMENT15 VARCHAR2(25),
223 INTERIM_TAX_SEGMENT16 VARCHAR2(25),
224 INTERIM_TAX_SEGMENT17 VARCHAR2(25),
225 INTERIM_TAX_SEGMENT18 VARCHAR2(25),
226 INTERIM_TAX_SEGMENT19 VARCHAR2(25),
227 INTERIM_TAX_SEGMENT20 VARCHAR2(25),
228 INTERIM_TAX_SEGMENT21 VARCHAR2(25),
229 INTERIM_TAX_SEGMENT22 VARCHAR2(25),
230 INTERIM_TAX_SEGMENT23 VARCHAR2(25),
231 INTERIM_TAX_SEGMENT24 VARCHAR2(25),
232 INTERIM_TAX_SEGMENT25 VARCHAR2(25),
233 INTERIM_TAX_SEGMENT26 VARCHAR2(25),
234 INTERIM_TAX_SEGMENT27 VARCHAR2(25),
235 INTERIM_TAX_SEGMENT28 VARCHAR2(25),
236 INTERIM_TAX_SEGMENT29 VARCHAR2(25),
237 INTERIM_TAX_SEGMENT30 VARCHAR2(25)
238 );
239
240 TYPE RA_Int_Distributions_Tbl_Type IS TABLE OF RA_Int_Distributions_Rec_Type
241 INDEX BY BINARY_INTEGER;
242
243 TYPE RA_Int_Sales_Credits_Rec_Type IS RECORD(
244 INTERFACE_LINE_CONTEXT VARCHAR2 (30),
245 INTERFACE_LINE_ATTRIBUTE1 VARCHAR2 (30),
246 INTERFACE_LINE_ATTRIBUTE2 VARCHAR2 (30),
247 INTERFACE_LINE_ATTRIBUTE3 VARCHAR2 (30),
248 INTERFACE_LINE_ATTRIBUTE4 VARCHAR2 (30),
249 INTERFACE_LINE_ATTRIBUTE5 VARCHAR2 (100), --AMITAMKU - fix for Bug 16104747
250 INTERFACE_LINE_ATTRIBUTE6 VARCHAR2 (30),
251 INTERFACE_LINE_ATTRIBUTE7 VARCHAR2 (30),
252 INTERFACE_LINE_ATTRIBUTE8 VARCHAR2 (30),
253 SALESREP_NUMBER VARCHAR2 (30),
254 SALESREP_ID NUMBER (15),
255 SALES_CREDIT_TYPE_NAME VARCHAR2 (30),
256 SALES_CREDIT_TYPE_ID NUMBER (15),
257 SALES_CREDIT_AMOUNT_SPLIT NUMBER,
258 SALES_CREDIT_PERCENT_SPLIT NUMBER,
259 INTERFACE_STATUS VARCHAR2 (1),
260 REQUEST_ID NUMBER (15),
261 ATTRIBUTE_CATEGORY VARCHAR2 (30),
262 ATTRIBUTE1 VARCHAR2 (150),
263 ATTRIBUTE2 VARCHAR2 (150),
264 ATTRIBUTE3 VARCHAR2 (150),
265 ATTRIBUTE4 VARCHAR2 (150),
266 ATTRIBUTE5 VARCHAR2 (150),
267 ATTRIBUTE6 VARCHAR2 (150),
268 ATTRIBUTE7 VARCHAR2 (150),
269 ATTRIBUTE8 VARCHAR2 (150),
270 ATTRIBUTE9 VARCHAR2 (150),
271 ATTRIBUTE10 VARCHAR2 (150),
272 ATTRIBUTE11 VARCHAR2 (150),
273 ATTRIBUTE12 VARCHAR2 (150),
274 ATTRIBUTE13 VARCHAR2 (150),
275 ATTRIBUTE14 VARCHAR2 (150),
276 ATTRIBUTE15 VARCHAR2 (150),
277 INTERFACE_LINE_ATTRIBUTE10 VARCHAR2 (30),
278 INTERFACE_LINE_ATTRIBUTE11 VARCHAR2 (30),
279 INTERFACE_LINE_ATTRIBUTE12 VARCHAR2 (30),
280 INTERFACE_LINE_ATTRIBUTE13 VARCHAR2 (30),
281 INTERFACE_LINE_ATTRIBUTE14 VARCHAR2 (30),
285 CREATION_DATE DATE,
282 INTERFACE_LINE_ATTRIBUTE15 VARCHAR2 (30),
283 INTERFACE_LINE_ATTRIBUTE9 VARCHAR2 (30),
284 CREATED_BY NUMBER (15),
286 LAST_UPDATED_BY NUMBER (15),
287 LAST_UPDATE_DATE DATE,
288 LAST_UPDATE_LOGIN NUMBER (15),
289 ORG_ID NUMBER (15)
290 );
291
292 TYPE RA_Int_Sales_Credits_Rec_Tbl IS TABLE OF RA_Int_Sales_Credits_Rec_Type
293 INDEX BY BINARY_INTEGER;
294
295 TYPE Claim_Rec_Type IS RECORD
296 (
297 CLAIM_ID NUMBER :=NULL
298 , OBJECT_VERSION_NUMBER NUMBER(9) :=NULL
299 , LAST_UPDATE_DATE DATE :=NULL
300 , LAST_UPDATED_BY NUMBER(15) :=NULL
301 , CREATION_DATE DATE :=NULL
302 , CREATED_BY NUMBER(15) :=NULL
303 , LAST_UPDATE_LOGIN NUMBER(15) :=NULL
304 , REQUEST_ID NUMBER :=NULL
305 , PROGRAM_APPLICATION_ID NUMBER :=NULL
306 , PROGRAM_UPDATE_DATE DATE :=NULL
307 , PROGRAM_ID NUMBER :=NULL
308 , CREATED_FROM VARCHAR2(30) :=NULL
309 , BATCH_ID NUMBER :=NULL
310 , CLAIM_NUMBER VARCHAR2(30) :=NULL
311 , CLAIM_TYPE_ID NUMBER :=NULL
312 , CLAIM_CLASS VARCHAR2(30) :=NULL
313 , CLAIM_DATE DATE :=NULL
314 , DUE_DATE DATE :=NULL
315 , OWNER_ID NUMBER :=NULL
316 , HISTORY_EVENT VARCHAR2(30) :=NULL
317 , HISTORY_EVENT_DATE DATE :=NULL
318 , HISTORY_EVENT_DESCRIPTION VARCHAR2(2000) :=NULL
319 , SPLIT_FROM_CLAIM_ID NUMBER :=NULL
320 , DUPLICATE_CLAIM_ID NUMBER :=NULL
321 , SPLIT_DATE DATE :=NULL
322 , ROOT_CLAIM_ID NUMBER :=NULL
323 , AMOUNT NUMBER :=NULL
324 , AMOUNT_ADJUSTED NUMBER :=NULL
325 , AMOUNT_REMAINING NUMBER :=NULL
326 , AMOUNT_SETTLED NUMBER :=NULL
327 , ACCTD_AMOUNT NUMBER :=NULL
328 , ACCTD_AMOUNT_REMAINING NUMBER :=NULL
329 , TAX_AMOUNT NUMBER :=NULL
330 , TAX_CODE VARCHAR2(50) :=NULL
331 , TAX_CALCULATION_FLAG VARCHAR2(1) :=NULL
332 , CURRENCY_CODE VARCHAR2(15) :=NULL
333 , EXCHANGE_RATE_TYPE VARCHAR2(30) :=NULL
334 , EXCHANGE_RATE_DATE DATE :=NULL
335 , EXCHANGE_RATE NUMBER :=NULL
336 , SET_OF_BOOKS_ID NUMBER :=NULL
337 , ORIGINAL_CLAIM_DATE DATE :=NULL
338 , SOURCE_OBJECT_ID NUMBER :=NULL
339 , SOURCE_OBJECT_CLASS VARCHAR2(15) :=NULL
340 , SOURCE_OBJECT_TYPE_ID NUMBER :=NULL
341 , SOURCE_OBJECT_NUMBER VARCHAR2(30) :=NULL
342 , CUST_ACCOUNT_ID NUMBER :=NULL
343 , CUST_BILLTO_ACCT_SITE_ID NUMBER :=NULL
344 , CUST_SHIPTO_ACCT_SITE_ID VARCHAR2(240) :=NULL
345 , LOCATION_ID NUMBER :=NULL
346 , PAY_RELATED_ACCOUNT_FLAG VARCHAR2(1) :=NULL
347 , RELATED_CUST_ACCOUNT_ID NUMBER :=NULL
348 , RELATED_SITE_USE_ID NUMBER :=NULL
349 , RELATIONSHIP_TYPE VARCHAR2(30) :=NULL
350 , VENDOR_ID NUMBER :=NULL
351 , VENDOR_SITE_ID NUMBER :=NULL
352 , REASON_TYPE VARCHAR2(30) :=NULL
353 , REASON_CODE_ID NUMBER :=NULL
354 , TASK_TEMPLATE_GROUP_ID NUMBER :=NULL
355 , STATUS_CODE VARCHAR2(30) :=NULL
356 , USER_STATUS_ID NUMBER :=NULL
357 , SALES_REP_ID NUMBER :=NULL
358 , COLLECTOR_ID NUMBER :=NULL
359 , CONTACT_ID NUMBER :=NULL
360 , BROKER_ID NUMBER :=NULL
361 , TERRITORY_ID NUMBER :=NULL
362 , CUSTOMER_REF_DATE DATE :=NULL
363 , CUSTOMER_REF_NUMBER VARCHAR2(100) :=NULL
364 , ASSIGNED_TO NUMBER :=NULL
365 , RECEIPT_ID NUMBER :=NULL
366 , RECEIPT_NUMBER VARCHAR2(30) :=NULL
367 , DOC_SEQUENCE_ID NUMBER :=NULL
368 , DOC_SEQUENCE_VALUE NUMBER :=NULL
369 , GL_DATE DATE :=NULL
370 , PAYMENT_METHOD VARCHAR2(15) :=NULL
371 , VOUCHER_ID NUMBER :=NULL
372 , VOUCHER_NUMBER VARCHAR2(30) :=NULL
373 , PAYMENT_REFERENCE_ID NUMBER :=NULL
374 , PAYMENT_REFERENCE_NUMBER VARCHAR2(15) :=NULL
378 , APPROVED_DATE DATE :=NULL
375 , PAYMENT_REFERENCE_DATE DATE :=NULL
376 , PAYMENT_STATUS VARCHAR2(10) :=NULL
377 , APPROVED_FLAG VARCHAR2(1) :=NULL
379 , APPROVED_BY NUMBER :=NULL
380 , SETTLED_DATE DATE :=NULL
381 , SETTLED_BY NUMBER :=NULL
382 , EFFECTIVE_DATE DATE :=NULL
383 , CUSTOM_SETUP_ID NUMBER :=NULL
384 , TASK_ID NUMBER :=NULL
385 , COUNTRY_ID NUMBER :=NULL
386 , COMMENTS VARCHAR2(2000) :=NULL
387 , ATTRIBUTE_CATEGORY VARCHAR2(30) :=NULL
388 , ATTRIBUTE1 VARCHAR2(150) :=NULL
389 , ATTRIBUTE2 VARCHAR2(150) :=NULL
390 , ATTRIBUTE3 VARCHAR2(150) :=NULL
391 , ATTRIBUTE4 VARCHAR2(150) :=NULL
392 , ATTRIBUTE5 VARCHAR2(150) :=NULL
393 , ATTRIBUTE6 VARCHAR2(150) :=NULL
394 , ATTRIBUTE7 VARCHAR2(150) :=NULL
395 , ATTRIBUTE8 VARCHAR2(150) :=NULL
396 , ATTRIBUTE9 VARCHAR2(150) :=NULL
397 , ATTRIBUTE10 VARCHAR2(150) :=NULL
398 , ATTRIBUTE11 VARCHAR2(150) :=NULL
399 , ATTRIBUTE12 VARCHAR2(150) :=NULL
400 , ATTRIBUTE13 VARCHAR2(150) :=NULL
401 , ATTRIBUTE14 VARCHAR2(150) :=NULL
402 , ATTRIBUTE15 VARCHAR2(150) :=NULL
403 , DEDUCTION_ATTRIBUTE_CATEGORY VARCHAR2(30) :=NULL
404 , DEDUCTION_ATTRIBUTE1 VARCHAR2(150) :=NULL
405 , DEDUCTION_ATTRIBUTE2 VARCHAR2(150) :=NULL
406 , DEDUCTION_ATTRIBUTE3 VARCHAR2(150) :=NULL
407 , DEDUCTION_ATTRIBUTE4 VARCHAR2(150) :=NULL
408 , DEDUCTION_ATTRIBUTE5 VARCHAR2(150) :=NULL
409 , DEDUCTION_ATTRIBUTE6 VARCHAR2(150) :=NULL
410 , DEDUCTION_ATTRIBUTE7 VARCHAR2(150) :=NULL
411 , DEDUCTION_ATTRIBUTE8 VARCHAR2(150) :=NULL
412 , DEDUCTION_ATTRIBUTE9 VARCHAR2(150) :=NULL
413 , DEDUCTION_ATTRIBUTE10 VARCHAR2(150) :=NULL
414 , DEDUCTION_ATTRIBUTE11 VARCHAR2(150) :=NULL
415 , DEDUCTION_ATTRIBUTE12 VARCHAR2(150) :=NULL
416 , DEDUCTION_ATTRIBUTE13 VARCHAR2(150) :=NULL
417 , DEDUCTION_ATTRIBUTE14 VARCHAR2(150) :=NULL
418 , DEDUCTION_ATTRIBUTE15 VARCHAR2(150) :=NULL
419 , ORG_ID NUMBER :=NULL
420 , CUSTOMER_REASON VARCHAR2(30) :=NULL
421 , SHIP_TO_CUST_ACCOUNT_ID NUMBER :=NULL
422 , LEGAL_ENTITY_ID NUMBER :=NULL
423 );
424
425 TYPE Claim_Tbl_Type IS TABLE OF Claim_Rec_Type
426 INDEX BY BINARY_INTEGER;
427
428 PROCEDURE Interface_Claim
429 ( p_api_version IN NUMBER
430 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
431 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
432 ,p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL
433 ,p_claim_id IN NUMBER
434 ,x_return_status OUT NOCOPY VARCHAR2
435 ,x_msg_data OUT NOCOPY VARCHAR2
436 ,x_msg_count OUT NOCOPY NUMBER
437 );
438
439 PROCEDURE Query_Claim
440 (
441 p_claim_id IN NUMBER
442 ,x_claim_rec IN OUT NOCOPY Claim_Rec_Type
443 ,x_return_status OUT NOCOPY VARCHAR2
444 );
445
446 FUNCTION Get_Memo_Line_Id(p_claim_line_id IN NUMBER) RETURN NUMBER ;
447
448 END OZF_Ar_Interface_PVT;