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