[Home] [Help]
PACKAGE: APPS.AP_AIL_TABLE_HANDLER_PKG
Source
1 PACKAGE AP_AIL_TABLE_HANDLER_PKG AUTHID CURRENT_USER as
2 /* $Header: apilnths.pls 120.8 2008/01/23 15:39:17 schamaku ship $ */
3
4 PROCEDURE CHECK_UNIQUE (
5 P_ROWID VARCHAR2,
6 P_INVOICE_ID NUMBER,
7 P_LINE_NUMBER NUMBER,
8 P_CALLING_SEQUENCE VARCHAR2);
9
10
11 PROCEDURE Insert_Row (
12 p_ROWID IN OUT NOCOPY VARCHAR2,
13 p_INVOICE_ID NUMBER,
14 p_LINE_NUMBER NUMBER,
15 p_LINE_TYPE_LOOKUP_CODE VARCHAR2,
16 p_LINE_GROUP_NUMBER NUMBER,
17 p_REQUESTER_ID NUMBER,
18 p_DESCRIPTION VARCHAR2,
19 p_LINE_SOURCE VARCHAR2,
20 p_ORG_ID NUMBER,
21 p_INVENTORY_ITEM_ID NUMBER,
22 p_ITEM_DESCRIPTION VARCHAR2,
23 p_SERIAL_NUMBER VARCHAR2,
24 p_MANUFACTURER VARCHAR2,
25 p_MODEL_NUMBER VARCHAR2,
26 p_WARRANTY_NUMBER VARCHAR2,
27 p_GENERATE_DISTS VARCHAR2,
28 p_MATCH_TYPE VARCHAR2,
29 p_DISTRIBUTION_SET_ID NUMBER,
30 p_ACCOUNT_SEGMENT VARCHAR2,
31 p_BALANCING_SEGMENT VARCHAR2,
32 p_COST_CENTER_SEGMENT VARCHAR2,
33 p_OVERLAY_DIST_CODE_CONCAT VARCHAR2,
34 p_DEFAULT_DIST_CCID NUMBER,
35 p_PRORATE_ACROSS_ALL_ITEMS VARCHAR2,
36 p_ACCOUNTING_DATE DATE,
37 p_PERIOD_NAME VARCHAR2,
38 p_DEFERRED_ACCTG_FLAG VARCHAR2,
39 p_DEF_ACCTG_START_DATE DATE,
40 p_DEF_ACCTG_END_DATE DATE,
41 p_DEF_ACCTG_NUMBER_OF_PERIODS NUMBER,
42 p_DEF_ACCTG_PERIOD_TYPE VARCHAR2,
43 p_SET_OF_BOOKS_ID NUMBER,
44 p_AMOUNT NUMBER,
45 p_BASE_AMOUNT NUMBER,
46 p_ROUNDING_AMT NUMBER,
47 p_QUANTITY_INVOICED NUMBER,
48 p_UNIT_MEAS_LOOKUP_CODE VARCHAR2,
49 p_UNIT_PRICE NUMBER,
50 p_WFAPPROVAL_STATUS VARCHAR2,
51 p_DISCARDED_FLAG VARCHAR2,
52 p_ORIGINAL_AMOUNT NUMBER,
53 p_ORIGINAL_BASE_AMOUNT NUMBER,
54 p_ORIGINAL_ROUNDING_AMT NUMBER,
55 p_CANCELLED_FLAG VARCHAR2,
56 p_INCOME_TAX_REGION VARCHAR2,
57 p_TYPE_1099 VARCHAR2,
58 p_STAT_AMOUNT NUMBER,
59 p_PREPAY_INVOICE_ID NUMBER,
60 p_PREPAY_LINE_NUMBER NUMBER,
61 p_INVOICE_INCLUDES_PREPAY_FLAG VARCHAR2,
62 p_CORRECTED_INV_ID NUMBER,
63 p_CORRECTED_LINE_NUMBER NUMBER,
64 p_PO_HEADER_ID NUMBER,
65 p_PO_LINE_ID NUMBER,
66 p_PO_RELEASE_ID NUMBER,
67 p_PO_LINE_LOCATION_ID NUMBER,
68 p_PO_DISTRIBUTION_ID NUMBER,
69 p_RCV_TRANSACTION_ID NUMBER,
70 p_FINAL_MATCH_FLAG VARCHAR2,
71 p_ASSETS_TRACKING_FLAG VARCHAR2,
72 p_ASSET_BOOK_TYPE_CODE VARCHAR2,
73 p_ASSET_CATEGORY_ID NUMBER,
74 p_PROJECT_ID NUMBER,
75 p_TASK_ID NUMBER,
76 p_EXPENDITURE_TYPE VARCHAR2,
77 p_EXPENDITURE_ITEM_DATE DATE,
78 p_EXPENDITURE_ORGANIZATION_ID NUMBER,
79 p_PA_QUANTITY NUMBER,
80 p_PA_CC_AR_INVOICE_ID NUMBER,
81 p_PA_CC_AR_INVOICE_LINE_NUM NUMBER,
82 p_PA_CC_PROCESSED_CODE VARCHAR2,
83 p_AWARD_ID NUMBER,
84 p_AWT_GROUP_ID NUMBER,
85 p_PAY_AWT_GROUP_ID NUMBER,--bug6639866
86 p_REFERENCE_1 VARCHAR2,
87 p_REFERENCE_2 VARCHAR2,
88 p_RECEIPT_VERIFIED_FLAG VARCHAR2,
89 p_RECEIPT_REQUIRED_FLAG VARCHAR2,
90 p_RECEIPT_MISSING_FLAG VARCHAR2,
91 p_JUSTIFICATION VARCHAR2,
92 p_EXPENSE_GROUP VARCHAR2,
93 p_START_EXPENSE_DATE DATE,
94 p_END_EXPENSE_DATE DATE,
95 p_RECEIPT_CURRENCY_CODE VARCHAR2,
96 p_RECEIPT_CONVERSION_RATE NUMBER,
97 p_RECEIPT_CURRENCY_AMOUNT NUMBER,
98 p_DAILY_AMOUNT NUMBER,
99 p_WEB_PARAMETER_ID NUMBER,
100 p_ADJUSTMENT_REASON VARCHAR2,
101 p_MERCHANT_DOCUMENT_NUMBER VARCHAR2,
102 p_MERCHANT_NAME VARCHAR2,
103 p_MERCHANT_REFERENCE VARCHAR2,
104 p_MERCHANT_TAX_REG_NUMBER VARCHAR2,
105 p_MERCHANT_TAXPAYER_ID VARCHAR2,
106 p_COUNTRY_OF_SUPPLY VARCHAR2,
107 p_CREDIT_CARD_TRX_ID NUMBER,
108 p_COMPANY_PREPAID_INVOICE_ID NUMBER,
109 p_CC_REVERSAL_FLAG VARCHAR2,
110 p_CREATION_DATE DATE,
111 p_CREATED_BY NUMBER,
112 p_LAST_UPDATED_BY NUMBER,
113 p_LAST_UPDATE_DATE DATE,
114 p_LAST_UPDATE_LOGIN NUMBER,
115 p_PROGRAM_APPLICATION_ID NUMBER,
116 p_PROGRAM_ID NUMBER,
117 p_PROGRAM_UPDATE_DATE DATE,
118 p_REQUEST_ID NUMBER,
119 p_ATTRIBUTE_CATEGORY VARCHAR2,
120 p_ATTRIBUTE1 VARCHAR2,
121 p_ATTRIBUTE2 VARCHAR2,
122 p_ATTRIBUTE3 VARCHAR2,
123 p_ATTRIBUTE4 VARCHAR2,
124 p_ATTRIBUTE5 VARCHAR2,
125 p_ATTRIBUTE6 VARCHAR2 DEFAULT NULL,
126 p_ATTRIBUTE7 VARCHAR2 DEFAULT NULL,
127 p_ATTRIBUTE8 VARCHAR2 DEFAULT NULL,
128 p_ATTRIBUTE9 VARCHAR2 DEFAULT NULL,
129 p_ATTRIBUTE10 VARCHAR2 DEFAULT NULL,
130 p_ATTRIBUTE11 VARCHAR2 DEFAULT NULL,
131 p_ATTRIBUTE12 VARCHAR2 DEFAULT NULL,
132 p_ATTRIBUTE13 VARCHAR2 DEFAULT NULL,
133 p_ATTRIBUTE14 VARCHAR2 DEFAULT NULL,
134 p_ATTRIBUTE15 VARCHAR2 DEFAULT NULL,
135 p_GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2 DEFAULT NULL,
136 p_GLOBAL_ATTRIBUTE1 VARCHAR2 DEFAULT NULL,
137 p_GLOBAL_ATTRIBUTE2 VARCHAR2 DEFAULT NULL,
138 p_GLOBAL_ATTRIBUTE3 VARCHAR2 DEFAULT NULL,
139 p_GLOBAL_ATTRIBUTE4 VARCHAR2 DEFAULT NULL,
140 p_GLOBAL_ATTRIBUTE5 VARCHAR2 DEFAULT NULL,
141 p_GLOBAL_ATTRIBUTE6 VARCHAR2 DEFAULT NULL,
142 p_GLOBAL_ATTRIBUTE7 VARCHAR2 DEFAULT NULL,
143 p_GLOBAL_ATTRIBUTE8 VARCHAR2 DEFAULT NULL,
144 p_GLOBAL_ATTRIBUTE9 VARCHAR2 DEFAULT NULL,
145 p_GLOBAL_ATTRIBUTE10 VARCHAR2 DEFAULT NULL,
146 p_GLOBAL_ATTRIBUTE11 VARCHAR2 DEFAULT NULL,
147 p_GLOBAL_ATTRIBUTE12 VARCHAR2 DEFAULT NULL,
148 p_GLOBAL_ATTRIBUTE13 VARCHAR2 DEFAULT NULL,
149 p_GLOBAL_ATTRIBUTE14 VARCHAR2 DEFAULT NULL,
150 p_GLOBAL_ATTRIBUTE15 VARCHAR2 DEFAULT NULL,
151 p_GLOBAL_ATTRIBUTE16 VARCHAR2 DEFAULT NULL,
152 p_GLOBAL_ATTRIBUTE17 VARCHAR2 DEFAULT NULL,
153 p_GLOBAL_ATTRIBUTE18 VARCHAR2 DEFAULT NULL,
154 p_GLOBAL_ATTRIBUTE19 VARCHAR2 DEFAULT NULL,
155 p_GLOBAL_ATTRIBUTE20 VARCHAR2 DEFAULT NULL,
156 p_PRIMARY_INTENDED_USE VARCHAR2 DEFAULT NULL,
157 p_SHIP_TO_LOCATION_ID NUMBER DEFAULT NULL,
158 p_PRODUCT_FISC_CLASSIFICATION VARCHAR2 DEFAULT NULL,
159 p_USER_DEFINED_FISC_CLASS VARCHAR2 DEFAULT NULL,
160 p_TRX_BUSINESS_CATEGORY VARCHAR2 DEFAULT NULL,
161 p_PRODUCT_TYPE VARCHAR2 DEFAULT NULL,
162 p_PRODUCT_CATEGORY VARCHAR2 DEFAULT NULL,
163 p_ASSESSABLE_VALUE NUMBER DEFAULT NULL,
164 p_CONTROL_AMOUNT NUMBER DEFAULT NULL,
165 p_TAX_REGIME_CODE VARCHAR2 DEFAULT NULL,
166 p_TAX VARCHAR2 DEFAULT NULL,
167 p_TAX_STATUS_CODE VARCHAR2 DEFAULT NULL,
168 p_TAX_RATE_CODE VARCHAR2 DEFAULT NULL,
169 p_TAX_RATE_ID NUMBER DEFAULT NULL,
170 p_TAX_RATE NUMBER DEFAULT NULL,
171 p_TAX_JURISDICTION_CODE VARCHAR2 DEFAULT NULL,
172 p_PURCHASING_CATEGORY_ID NUMBER DEFAULT NULL,
173 p_COST_FACTOR_ID NUMBER DEFAULT NULL,
174 p_RETAINED_AMOUNT NUMBER DEFAULT NULL,
175 p_RETAINED_INVOICE_ID NUMBER DEFAULT NULL,
176 p_RETAINED_LINE_NUMBER NUMBER DEFAULT NULL,
177 p_TAX_CLASSIFICATION_CODE VARCHAR2 DEFAULT NULL,
178 p_CALLING_SEQUENCE VARCHAR2);
179
180
181 PROCEDURE Lock_Row(
182 p_ROWID VARCHAR2,
183 p_INVOICE_ID NUMBER,
184 p_LINE_NUMBER NUMBER,
185 p_LINE_TYPE_LOOKUP_CODE VARCHAR2,
186 p_LINE_GROUP_NUMBER NUMBER,
187 p_REQUESTER_ID NUMBER,
188 p_DESCRIPTION VARCHAR2,
189 p_LINE_SOURCE VARCHAR2,
190 p_ORG_ID NUMBER,
191 p_INVENTORY_ITEM_ID NUMBER,
192 p_ITEM_DESCRIPTION VARCHAR2,
193 p_SERIAL_NUMBER VARCHAR2,
194 p_MANUFACTURER VARCHAR2,
195 p_MODEL_NUMBER VARCHAR2,
196 p_WARRANTY_NUMBER VARCHAR2,
197 p_GENERATE_DISTS VARCHAR2,
198 p_MATCH_TYPE VARCHAR2,
199 p_DISTRIBUTION_SET_ID NUMBER,
200 p_ACCOUNT_SEGMENT VARCHAR2,
201 p_BALANCING_SEGMENT VARCHAR2,
202 p_COST_CENTER_SEGMENT VARCHAR2,
203 p_OVERLAY_DIST_CODE_CONCAT VARCHAR2,
204 p_DEFAULT_DIST_CCID NUMBER,
205 p_PRORATE_ACROSS_ALL_ITEMS VARCHAR2,
206 p_ACCOUNTING_DATE DATE,
207 p_PERIOD_NAME VARCHAR2,
208 p_DEFERRED_ACCTG_FLAG VARCHAR2,
209 p_DEF_ACCTG_START_DATE DATE,
210 p_DEF_ACCTG_END_DATE DATE,
211 p_DEF_ACCTG_NUMBER_OF_PERIODS NUMBER,
212 p_DEF_ACCTG_PERIOD_TYPE VARCHAR2,
213 p_SET_OF_BOOKS_ID NUMBER,
214 p_AMOUNT NUMBER,
215 p_BASE_AMOUNT NUMBER,
216 p_ROUNDING_AMT NUMBER,
217 p_QUANTITY_INVOICED NUMBER,
218 p_UNIT_MEAS_LOOKUP_CODE VARCHAR2,
219 p_UNIT_PRICE NUMBER,
220 p_WFAPPROVAL_STATUS VARCHAR2,
221 p_DISCARDED_FLAG VARCHAR2,
222 p_ORIGINAL_AMOUNT NUMBER,
223 p_ORIGINAL_BASE_AMOUNT NUMBER,
224 p_ORIGINAL_ROUNDING_AMT NUMBER,
225 p_CANCELLED_FLAG VARCHAR2,
226 p_INCOME_TAX_REGION VARCHAR2,
227 p_TYPE_1099 VARCHAR2,
228 p_STAT_AMOUNT NUMBER,
229 p_PREPAY_INVOICE_ID NUMBER,
230 p_PREPAY_LINE_NUMBER NUMBER,
231 p_INVOICE_INCLUDES_PREPAY_FLAG VARCHAR2,
232 p_CORRECTED_INV_ID NUMBER,
233 p_CORRECTED_LINE_NUMBER NUMBER,
234 p_PO_HEADER_ID NUMBER,
235 p_PO_LINE_ID NUMBER,
236 p_PO_RELEASE_ID NUMBER,
237 p_PO_LINE_LOCATION_ID NUMBER,
238 p_PO_DISTRIBUTION_ID NUMBER,
239 p_RCV_TRANSACTION_ID NUMBER,
240 p_FINAL_MATCH_FLAG VARCHAR2,
241 p_ASSETS_TRACKING_FLAG VARCHAR2,
242 p_ASSET_BOOK_TYPE_CODE VARCHAR2,
243 p_ASSET_CATEGORY_ID NUMBER,
244 p_PROJECT_ID NUMBER,
245 p_TASK_ID NUMBER,
246 p_EXPENDITURE_TYPE VARCHAR2,
247 p_EXPENDITURE_ITEM_DATE DATE,
248 p_EXPENDITURE_ORGANIZATION_ID NUMBER,
249 p_PA_QUANTITY NUMBER,
250 p_PA_CC_AR_INVOICE_ID NUMBER,
251 p_PA_CC_AR_INVOICE_LINE_NUM NUMBER,
252 p_PA_CC_PROCESSED_CODE VARCHAR2,
253 p_AWARD_ID NUMBER,
254 p_AWT_GROUP_ID NUMBER,
255 p_PAY_AWT_GROUP_ID NUMBER,--bug6639866
256 p_REFERENCE_1 VARCHAR2,
257 p_REFERENCE_2 VARCHAR2,
258 p_RECEIPT_VERIFIED_FLAG VARCHAR2,
259 p_RECEIPT_REQUIRED_FLAG VARCHAR2,
260 p_RECEIPT_MISSING_FLAG VARCHAR2,
261 p_JUSTIFICATION VARCHAR2,
262 p_EXPENSE_GROUP VARCHAR2,
263 p_START_EXPENSE_DATE DATE,
264 p_END_EXPENSE_DATE DATE,
265 p_RECEIPT_CURRENCY_CODE VARCHAR2,
266 p_RECEIPT_CONVERSION_RATE NUMBER,
267 p_RECEIPT_CURRENCY_AMOUNT NUMBER,
268 p_DAILY_AMOUNT NUMBER,
269 p_WEB_PARAMETER_ID NUMBER,
270 p_ADJUSTMENT_REASON VARCHAR2,
271 p_MERCHANT_DOCUMENT_NUMBER VARCHAR2,
272 p_MERCHANT_NAME VARCHAR2,
273 p_MERCHANT_REFERENCE VARCHAR2,
274 p_MERCHANT_TAX_REG_NUMBER VARCHAR2,
275 p_MERCHANT_TAXPAYER_ID VARCHAR2,
276 p_COUNTRY_OF_SUPPLY VARCHAR2,
277 p_CREDIT_CARD_TRX_ID NUMBER,
278 p_COMPANY_PREPAID_INVOICE_ID NUMBER,
279 p_CC_REVERSAL_FLAG VARCHAR2,
280 p_CREATION_DATE DATE,
281 p_CREATED_BY NUMBER,
282 p_LAST_UPDATED_BY NUMBER,
283 p_LAST_UPDATE_DATE DATE,
284 p_LAST_UPDATE_LOGIN NUMBER,
285 p_PROGRAM_APPLICATION_ID NUMBER,
286 p_PROGRAM_ID NUMBER,
287 p_PROGRAM_UPDATE_DATE DATE,
288 p_REQUEST_ID NUMBER,
289 p_ATTRIBUTE_CATEGORY VARCHAR2,
290 p_ATTRIBUTE1 VARCHAR2,
291 p_ATTRIBUTE2 VARCHAR2,
292 p_ATTRIBUTE3 VARCHAR2,
293 p_ATTRIBUTE4 VARCHAR2,
294 p_ATTRIBUTE5 VARCHAR2,
295 p_ATTRIBUTE6 VARCHAR2 DEFAULT NULL,
296 p_ATTRIBUTE7 VARCHAR2 DEFAULT NULL,
297 p_ATTRIBUTE8 VARCHAR2 DEFAULT NULL,
298 p_ATTRIBUTE9 VARCHAR2 DEFAULT NULL,
299 p_ATTRIBUTE10 VARCHAR2 DEFAULT NULL,
300 p_ATTRIBUTE11 VARCHAR2 DEFAULT NULL,
301 p_ATTRIBUTE12 VARCHAR2 DEFAULT NULL,
302 p_ATTRIBUTE13 VARCHAR2 DEFAULT NULL,
303 p_ATTRIBUTE14 VARCHAR2 DEFAULT NULL,
304 p_ATTRIBUTE15 VARCHAR2 DEFAULT NULL,
305 p_GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2 DEFAULT NULL,
309 p_GLOBAL_ATTRIBUTE4 VARCHAR2 DEFAULT NULL,
306 p_GLOBAL_ATTRIBUTE1 VARCHAR2 DEFAULT NULL,
307 p_GLOBAL_ATTRIBUTE2 VARCHAR2 DEFAULT NULL,
308 p_GLOBAL_ATTRIBUTE3 VARCHAR2 DEFAULT NULL,
310 p_GLOBAL_ATTRIBUTE5 VARCHAR2 DEFAULT NULL,
311 p_GLOBAL_ATTRIBUTE6 VARCHAR2 DEFAULT NULL,
312 p_GLOBAL_ATTRIBUTE7 VARCHAR2 DEFAULT NULL,
313 p_GLOBAL_ATTRIBUTE8 VARCHAR2 DEFAULT NULL,
314 p_GLOBAL_ATTRIBUTE9 VARCHAR2 DEFAULT NULL,
315 p_GLOBAL_ATTRIBUTE10 VARCHAR2 DEFAULT NULL,
316 p_GLOBAL_ATTRIBUTE11 VARCHAR2 DEFAULT NULL,
317 p_GLOBAL_ATTRIBUTE12 VARCHAR2 DEFAULT NULL,
318 p_GLOBAL_ATTRIBUTE13 VARCHAR2 DEFAULT NULL,
319 p_GLOBAL_ATTRIBUTE14 VARCHAR2 DEFAULT NULL,
320 p_GLOBAL_ATTRIBUTE15 VARCHAR2 DEFAULT NULL,
321 p_GLOBAL_ATTRIBUTE16 VARCHAR2 DEFAULT NULL,
322 p_GLOBAL_ATTRIBUTE17 VARCHAR2 DEFAULT NULL,
323 p_GLOBAL_ATTRIBUTE18 VARCHAR2 DEFAULT NULL,
324 p_GLOBAL_ATTRIBUTE19 VARCHAR2 DEFAULT NULL,
325 p_GLOBAL_ATTRIBUTE20 VARCHAR2 DEFAULT NULL,
326 p_PRIMARY_INTENDED_USE VARCHAR2 DEFAULT NULL,
327 p_SHIP_TO_LOCATION_ID NUMBER DEFAULT NULL,
328 p_PRODUCT_FISC_CLASSIFICATION VARCHAR2 DEFAULT NULL,
329 p_USER_DEFINED_FISC_CLASS VARCHAR2 DEFAULT NULL,
330 p_TRX_BUSINESS_CATEGORY VARCHAR2 DEFAULT NULL,
331 p_PRODUCT_TYPE VARCHAR2 DEFAULT NULL,
332 p_PRODUCT_CATEGORY VARCHAR2 DEFAULT NULL,
333 p_ASSESSABLE_VALUE NUMBER DEFAULT NULL,
334 p_CONTROL_AMOUNT NUMBER DEFAULT NULL,
335 p_TAX_REGIME_CODE VARCHAR2 DEFAULT NULL,
336 p_TAX VARCHAR2 DEFAULT NULL,
337 p_TAX_STATUS_CODE VARCHAR2 DEFAULT NULL,
338 p_TAX_RATE_CODE VARCHAR2 DEFAULT NULL,
339 p_TAX_RATE_ID NUMBER DEFAULT NULL,
340 p_TAX_RATE NUMBER DEFAULT NULL,
341 p_TAX_JURISDICTION_CODE VARCHAR2 DEFAULT NULL,
342 p_PURCHASING_CATEGORY_ID NUMBER DEFAULT NULL,
343 p_COST_FACTOR_ID NUMBER DEFAULT NULL,
344 p_RETAINED_AMOUNT NUMBER DEFAULT NULL,
345 p_RETAINED_INVOICE_ID NUMBER DEFAULT NULL,
346 p_RETAINED_LINE_NUMBER NUMBER DEFAULT NULL,
347 p_TAX_CLASSIFICATION_CODE VARCHAR2 DEFAULT NULL,
348 p_Calling_Sequence VARCHAR2);
349
350 PROCEDURE Update_Row (
351 p_ROWID IN OUT NOCOPY VARCHAR2,
352 p_INVOICE_ID NUMBER,
353 p_LINE_NUMBER NUMBER,
354 p_LINE_TYPE_LOOKUP_CODE VARCHAR2,
355 p_LINE_GROUP_NUMBER NUMBER,
356 p_REQUESTER_ID NUMBER,
357 p_DESCRIPTION VARCHAR2,
358 p_LINE_SOURCE VARCHAR2,
359 p_ORG_ID NUMBER,
360 p_INVENTORY_ITEM_ID NUMBER,
361 p_ITEM_DESCRIPTION VARCHAR2,
362 p_SERIAL_NUMBER VARCHAR2,
363 p_MANUFACTURER VARCHAR2,
364 p_MODEL_NUMBER VARCHAR2,
365 p_WARRANTY_NUMBER VARCHAR2,
366 p_GENERATE_DISTS VARCHAR2,
367 p_MATCH_TYPE VARCHAR2,
368 p_DISTRIBUTION_SET_ID NUMBER,
369 p_ACCOUNT_SEGMENT VARCHAR2,
370 p_BALANCING_SEGMENT VARCHAR2,
371 p_COST_CENTER_SEGMENT VARCHAR2,
372 p_OVERLAY_DIST_CODE_CONCAT VARCHAR2,
373 p_DEFAULT_DIST_CCID NUMBER,
374 p_PRORATE_ACROSS_ALL_ITEMS VARCHAR2,
375 p_ACCOUNTING_DATE DATE,
376 p_PERIOD_NAME VARCHAR2,
377 p_DEFERRED_ACCTG_FLAG VARCHAR2,
378 p_DEF_ACCTG_START_DATE DATE,
379 p_DEF_ACCTG_END_DATE DATE,
380 p_DEF_ACCTG_NUMBER_OF_PERIODS NUMBER,
381 p_DEF_ACCTG_PERIOD_TYPE VARCHAR2,
382 p_SET_OF_BOOKS_ID NUMBER,
383 p_AMOUNT NUMBER,
384 p_BASE_AMOUNT NUMBER,
385 p_ROUNDING_AMT NUMBER,
386 p_QUANTITY_INVOICED NUMBER,
387 p_UNIT_MEAS_LOOKUP_CODE VARCHAR2,
388 p_UNIT_PRICE NUMBER,
389 p_WFAPPROVAL_STATUS VARCHAR2,
390 p_DISCARDED_FLAG VARCHAR2,
391 p_ORIGINAL_AMOUNT NUMBER,
392 p_ORIGINAL_BASE_AMOUNT NUMBER,
393 p_ORIGINAL_ROUNDING_AMT NUMBER,
394 p_CANCELLED_FLAG VARCHAR2,
395 p_INCOME_TAX_REGION VARCHAR2,
396 p_TYPE_1099 VARCHAR2,
397 p_STAT_AMOUNT NUMBER,
398 p_PREPAY_INVOICE_ID NUMBER,
399 p_PREPAY_LINE_NUMBER NUMBER,
400 p_INVOICE_INCLUDES_PREPAY_FLAG VARCHAR2,
401 p_CORRECTED_INV_ID NUMBER,
405 p_PO_RELEASE_ID NUMBER,
402 p_CORRECTED_LINE_NUMBER NUMBER,
403 p_PO_HEADER_ID NUMBER,
404 p_PO_LINE_ID NUMBER,
406 p_PO_LINE_LOCATION_ID NUMBER,
407 p_PO_DISTRIBUTION_ID NUMBER,
408 p_RCV_TRANSACTION_ID NUMBER,
409 p_FINAL_MATCH_FLAG VARCHAR2,
410 p_ASSETS_TRACKING_FLAG VARCHAR2,
411 p_ASSET_BOOK_TYPE_CODE VARCHAR2,
412 p_ASSET_CATEGORY_ID NUMBER,
413 p_PROJECT_ID NUMBER,
414 p_TASK_ID NUMBER,
415 p_EXPENDITURE_TYPE VARCHAR2,
416 p_EXPENDITURE_ITEM_DATE DATE,
417 p_EXPENDITURE_ORGANIZATION_ID NUMBER,
418 p_PA_QUANTITY NUMBER,
419 p_PA_CC_AR_INVOICE_ID NUMBER,
420 p_PA_CC_AR_INVOICE_LINE_NUM NUMBER,
421 p_PA_CC_PROCESSED_CODE VARCHAR2,
422 p_AWARD_ID NUMBER,
423 p_AWT_GROUP_ID NUMBER,
424 p_PAY_AWT_GROUP_ID NUMBER,--bug6639866
425 p_REFERENCE_1 VARCHAR2,
426 p_REFERENCE_2 VARCHAR2,
427 p_RECEIPT_VERIFIED_FLAG VARCHAR2,
428 p_RECEIPT_REQUIRED_FLAG VARCHAR2,
429 p_RECEIPT_MISSING_FLAG VARCHAR2,
430 p_JUSTIFICATION VARCHAR2,
431 p_EXPENSE_GROUP VARCHAR2,
432 p_START_EXPENSE_DATE DATE,
433 p_END_EXPENSE_DATE DATE,
434 p_RECEIPT_CURRENCY_CODE VARCHAR2,
435 p_RECEIPT_CONVERSION_RATE NUMBER,
436 p_RECEIPT_CURRENCY_AMOUNT NUMBER,
437 p_DAILY_AMOUNT NUMBER,
438 p_WEB_PARAMETER_ID NUMBER,
439 p_ADJUSTMENT_REASON VARCHAR2,
440 p_MERCHANT_DOCUMENT_NUMBER VARCHAR2,
441 p_MERCHANT_NAME VARCHAR2,
442 p_MERCHANT_REFERENCE VARCHAR2,
443 p_MERCHANT_TAX_REG_NUMBER VARCHAR2,
444 p_MERCHANT_TAXPAYER_ID VARCHAR2,
445 p_COUNTRY_OF_SUPPLY VARCHAR2,
446 p_CREDIT_CARD_TRX_ID NUMBER,
447 p_COMPANY_PREPAID_INVOICE_ID NUMBER,
448 p_CC_REVERSAL_FLAG VARCHAR2,
449 p_CREATION_DATE DATE,
450 p_CREATED_BY NUMBER,
451 p_LAST_UPDATED_BY NUMBER,
452 p_LAST_UPDATE_DATE DATE,
453 p_LAST_UPDATE_LOGIN NUMBER,
454 p_PROGRAM_APPLICATION_ID NUMBER,
455 p_PROGRAM_ID NUMBER,
456 p_PROGRAM_UPDATE_DATE DATE,
457 p_REQUEST_ID NUMBER,
458 p_ATTRIBUTE_CATEGORY VARCHAR2,
459 p_ATTRIBUTE1 VARCHAR2,
460 p_ATTRIBUTE2 VARCHAR2,
461 p_ATTRIBUTE3 VARCHAR2,
462 p_ATTRIBUTE4 VARCHAR2,
463 p_ATTRIBUTE5 VARCHAR2,
464 p_ATTRIBUTE6 VARCHAR2 DEFAULT NULL,
465 p_ATTRIBUTE7 VARCHAR2 DEFAULT NULL,
466 p_ATTRIBUTE8 VARCHAR2 DEFAULT NULL,
467 p_ATTRIBUTE9 VARCHAR2 DEFAULT NULL,
468 p_ATTRIBUTE10 VARCHAR2 DEFAULT NULL,
469 p_ATTRIBUTE11 VARCHAR2 DEFAULT NULL,
470 p_ATTRIBUTE12 VARCHAR2 DEFAULT NULL,
471 p_ATTRIBUTE13 VARCHAR2 DEFAULT NULL,
472 p_ATTRIBUTE14 VARCHAR2 DEFAULT NULL,
473 p_ATTRIBUTE15 VARCHAR2 DEFAULT NULL,
474 p_GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2 DEFAULT NULL,
475 p_GLOBAL_ATTRIBUTE1 VARCHAR2 DEFAULT NULL,
476 p_GLOBAL_ATTRIBUTE2 VARCHAR2 DEFAULT NULL,
477 p_GLOBAL_ATTRIBUTE3 VARCHAR2 DEFAULT NULL,
478 p_GLOBAL_ATTRIBUTE4 VARCHAR2 DEFAULT NULL,
479 p_GLOBAL_ATTRIBUTE5 VARCHAR2 DEFAULT NULL,
480 p_GLOBAL_ATTRIBUTE6 VARCHAR2 DEFAULT NULL,
481 p_GLOBAL_ATTRIBUTE7 VARCHAR2 DEFAULT NULL,
482 p_GLOBAL_ATTRIBUTE8 VARCHAR2 DEFAULT NULL,
483 p_GLOBAL_ATTRIBUTE9 VARCHAR2 DEFAULT NULL,
484 p_GLOBAL_ATTRIBUTE10 VARCHAR2 DEFAULT NULL,
485 p_GLOBAL_ATTRIBUTE11 VARCHAR2 DEFAULT NULL,
486 p_GLOBAL_ATTRIBUTE12 VARCHAR2 DEFAULT NULL,
487 p_GLOBAL_ATTRIBUTE13 VARCHAR2 DEFAULT NULL,
488 p_GLOBAL_ATTRIBUTE14 VARCHAR2 DEFAULT NULL,
489 p_GLOBAL_ATTRIBUTE15 VARCHAR2 DEFAULT NULL,
490 p_GLOBAL_ATTRIBUTE16 VARCHAR2 DEFAULT NULL,
491 p_GLOBAL_ATTRIBUTE17 VARCHAR2 DEFAULT NULL,
492 p_GLOBAL_ATTRIBUTE18 VARCHAR2 DEFAULT NULL,
493 p_GLOBAL_ATTRIBUTE19 VARCHAR2 DEFAULT NULL,
494 p_GLOBAL_ATTRIBUTE20 VARCHAR2 DEFAULT NULL,
495 p_PRIMARY_INTENDED_USE VARCHAR2 DEFAULT NULL,
499 p_TRX_BUSINESS_CATEGORY VARCHAR2 DEFAULT NULL,
496 p_SHIP_TO_LOCATION_ID NUMBER DEFAULT NULL,
497 p_PRODUCT_FISC_CLASSIFICATION VARCHAR2 DEFAULT NULL,
498 p_USER_DEFINED_FISC_CLASS VARCHAR2 DEFAULT NULL,
500 p_PRODUCT_TYPE VARCHAR2 DEFAULT NULL,
501 p_PRODUCT_CATEGORY VARCHAR2 DEFAULT NULL,
502 p_ASSESSABLE_VALUE NUMBER DEFAULT NULL,
503 p_CONTROL_AMOUNT NUMBER DEFAULT NULL,
504 p_TAX_REGIME_CODE VARCHAR2 DEFAULT NULL,
505 p_TAX VARCHAR2 DEFAULT NULL,
506 p_TAX_STATUS_CODE VARCHAR2 DEFAULT NULL,
507 p_TAX_RATE_CODE VARCHAR2 DEFAULT NULL,
508 p_TAX_RATE_ID NUMBER DEFAULT NULL,
509 p_TAX_RATE NUMBER DEFAULT NULL,
510 p_TAX_JURISDICTION_CODE VARCHAR2 DEFAULT NULL,
511 p_PURCHASING_CATEGORY_ID NUMBER DEFAULT NULL,
512 p_COST_FACTOR_ID NUMBER DEFAULT NULL,
513 p_RETAINED_AMOUNT NUMBER DEFAULT NULL,
514 p_RETAINED_INVOICE_ID NUMBER DEFAULT NULL,
515 p_RETAINED_LINE_NUMBER NUMBER DEFAULT NULL,
516 p_TAX_CLASSIFICATION_CODE VARCHAR2 DEFAULT NULL,
517 p_Calling_Sequence VARCHAR2);
518
519 PROCEDURE Delete_Row (
520 p_Rowid VARCHAR2,
521 p_Calling_Sequence VARCHAR2);
522
523 END AP_AIL_TABLE_HANDLER_PKG;