[Home] [Help]
PACKAGE: APPS.AP_INVOICES_PKG
Source
1 PACKAGE AP_INVOICES_PKG AS
2 /* $Header: apiinces.pls 120.31.12010000.4 2009/02/04 05:58:31 ctetala ship $ */
3
4 TYPE r_invoice_line_rec IS RECORD (
5 invoice_id AP_INVOICE_LINES.INVOICE_ID%TYPE,
6 line_number AP_INVOICE_LINES.LINE_NUMBER%TYPE,
7 line_type_lookup_code AP_INVOICE_LINES.LINE_TYPE_LOOKUP_CODE%TYPE,
8 requester_id AP_INVOICE_LINES.REQUESTER_ID%TYPE,
9 description AP_INVOICE_LINES.DESCRIPTION%TYPE,
10 line_source AP_INVOICE_LINES.LINE_SOURCE%TYPE,
11 org_id AP_INVOICE_LINES.ORG_ID%TYPE,
12 line_group_number AP_INVOICE_LINES.LINE_GROUP_NUMBER%TYPE,
13 inventory_item_id AP_INVOICE_LINES.INVENTORY_ITEM_ID%TYPE,
14 item_description AP_INVOICE_LINES.ITEM_DESCRIPTION%TYPE,
15 serial_number AP_INVOICE_LINES.SERIAL_NUMBER%TYPE,
16 manufacturer AP_INVOICE_LINES.MANUFACTURER%TYPE,
17 model_number AP_INVOICE_LINES.MODEL_NUMBER%TYPE,
18 warranty_number AP_INVOICE_LINES.WARRANTY_NUMBER%TYPE,
19 generate_dists AP_INVOICE_LINES.GENERATE_DISTS%TYPE,
20 match_type AP_INVOICE_LINES.MATCH_TYPE%TYPE,
21 distribution_set_id AP_INVOICE_LINES.DISTRIBUTION_SET_ID%TYPE,
22 account_segment AP_INVOICE_LINES.ACCOUNT_SEGMENT%TYPE,
23 balancing_segment AP_INVOICE_LINES.BALANCING_SEGMENT%TYPE,
24 cost_center_segment AP_INVOICE_LINES.COST_CENTER_SEGMENT%TYPE,
25 overlay_dist_code_concat AP_INVOICE_LINES.OVERLAY_DIST_CODE_CONCAT%TYPE,
26 default_dist_ccid AP_INVOICE_LINES.DEFAULT_DIST_CCID%TYPE,
27 prorate_across_all_items AP_INVOICE_LINES.PRORATE_ACROSS_ALL_ITEMS%TYPE,
28 accounting_date AP_INVOICE_LINES.ACCOUNTING_DATE%TYPE,
29 period_name AP_INVOICE_LINES.PERIOD_NAME%TYPE,
30 deferred_acctg_flag AP_INVOICE_LINES.DEFERRED_ACCTG_FLAG%TYPE,
31 def_acctg_start_date AP_INVOICE_LINES.DEF_ACCTG_START_DATE %TYPE,
32 def_acctg_end_date AP_INVOICE_LINES.DEF_ACCTG_END_DATE%TYPE,
33 def_acctg_number_of_periods
34 AP_INVOICE_LINES.DEF_ACCTG_NUMBER_OF_PERIODS%TYPE,
35 def_acctg_period_type AP_INVOICE_LINES.DEF_ACCTG_PERIOD_TYPE%TYPE,
36 set_of_books_id AP_INVOICE_LINES.SET_OF_BOOKS_ID%TYPE,
37 amount AP_INVOICE_LINES.AMOUNT%TYPE,
38 base_amount AP_INVOICE_LINES.BASE_AMOUNT%TYPE,
39 rounding_amt AP_INVOICE_LINES.ROUNDING_AMT%TYPE,
40 quantity_invoiced AP_INVOICE_LINES.QUANTITY_INVOICED%TYPE,
41 unit_meas_lookup_code AP_INVOICE_LINES.UNIT_MEAS_LOOKUP_CODE%TYPE,
42 unit_price AP_INVOICE_LINES.UNIT_PRICE%TYPE,
43 wfapproval_status AP_INVOICE_LINES.WFAPPROVAL_STATUS%TYPE,
44 discarded_flag AP_INVOICE_LINES.DISCARDED_FLAG%TYPE,
45 original_amount AP_INVOICE_LINES.ORIGINAL_AMOUNT%TYPE,
46 original_base_amount AP_INVOICE_LINES.ORIGINAL_BASE_AMOUNT%TYPE,
47 original_rounding_amt AP_INVOICE_LINES.ORIGINAL_ROUNDING_AMT%TYPE,
48 cancelled_flag AP_INVOICE_LINES.CANCELLED_FLAG%TYPE,
49 income_tax_region AP_INVOICE_LINES.INCOME_TAX_REGION%TYPE,
50 type_1099 AP_INVOICE_LINES.TYPE_1099%TYPE,
51 stat_amount AP_INVOICE_LINES.STAT_AMOUNT%TYPE,
52 prepay_invoice_id AP_INVOICE_LINES.PREPAY_INVOICE_ID%TYPE,
53 prepay_line_number AP_INVOICE_LINES.PREPAY_LINE_NUMBER%TYPE,
54 invoice_includes_prepay_flag
55 AP_INVOICE_LINES.INVOICE_INCLUDES_PREPAY_FLAG%TYPE,
56 corrected_inv_id AP_INVOICE_LINES.CORRECTED_INV_ID%TYPE,
57 corrected_line_number AP_INVOICE_LINES.CORRECTED_LINE_NUMBER%TYPE,
58 po_header_id AP_INVOICE_LINES.PO_HEADER_ID%TYPE,
59 po_line_id AP_INVOICE_LINES.PO_LINE_ID%TYPE,
60 po_release_id AP_INVOICE_LINES.PO_RELEASE_ID%TYPE,
61 po_line_location_id AP_INVOICE_LINES.PO_LINE_LOCATION_ID%TYPE,
62 po_distribution_id AP_INVOICE_LINES.PO_DISTRIBUTION_ID%TYPE,
63 rcv_transaction_id AP_INVOICE_LINES.RCV_TRANSACTION_ID%TYPE,
64 final_match_flag AP_INVOICE_LINES.FINAL_MATCH_FLAG%TYPE,
65 assets_tracking_flag AP_INVOICE_LINES.ASSETS_TRACKING_FLAG%TYPE,
66 asset_book_type_code AP_INVOICE_LINES.ASSET_BOOK_TYPE_CODE%TYPE,
67 asset_category_id AP_INVOICE_LINES.ASSET_CATEGORY_ID%TYPE,
68 project_id AP_INVOICE_LINES.PROJECT_ID%TYPE,
69 task_id AP_INVOICE_LINES.TASK_ID%TYPE,
70 expenditure_type AP_INVOICE_LINES.EXPENDITURE_TYPE%TYPE,
71 expenditure_item_date AP_INVOICE_LINES.EXPENDITURE_ITEM_DATE%TYPE,
72 expenditure_organization_id
73 AP_INVOICE_LINES.EXPENDITURE_ORGANIZATION_ID%TYPE,
74 pa_quantity AP_INVOICE_LINES.PA_QUANTITY%TYPE,
75 pa_cc_ar_invoice_id AP_INVOICE_LINES.PA_CC_AR_INVOICE_ID%TYPE,
76 pa_cc_ar_invoice_line_num AP_INVOICE_LINES.PA_CC_AR_INVOICE_LINE_NUM%TYPE,
77 pa_cc_processed_code AP_INVOICE_LINES.PA_CC_PROCESSED_CODE%TYPE,
78 award_id AP_INVOICE_LINES.AWARD_ID%TYPE,
79 awt_group_id AP_INVOICE_LINES.AWT_GROUP_ID%TYPE,
80 reference_1 AP_INVOICE_LINES.REFERENCE_1%TYPE,
81 reference_2 AP_INVOICE_LINES.REFERENCE_2%TYPE,
82 receipt_verified_flag AP_INVOICE_LINES.RECEIPT_VERIFIED_FLAG%TYPE,
83 receipt_required_flag AP_INVOICE_LINES.RECEIPT_REQUIRED_FLAG%TYPE,
84 receipt_missing_flag AP_INVOICE_LINES.RECEIPT_MISSING_FLAG%TYPE,
85 justification AP_INVOICE_LINES.JUSTIFICATION%TYPE,
86 expense_group AP_INVOICE_LINES.EXPENSE_GROUP%TYPE,
87 start_expense_date AP_INVOICE_LINES.START_EXPENSE_DATE%TYPE,
88 end_expense_date AP_INVOICE_LINES.END_EXPENSE_DATE%TYPE,
89 receipt_currency_code AP_INVOICE_LINES.RECEIPT_CURRENCY_CODE%TYPE,
90 receipt_conversion_rate AP_INVOICE_LINES.RECEIPT_CONVERSION_RATE%TYPE,
91 receipt_currency_amount AP_INVOICE_LINES.RECEIPT_CONVERSION_RATE%TYPE,
92 daily_amount AP_INVOICE_LINES.DAILY_AMOUNT%TYPE,
93 web_parameter_id AP_INVOICE_LINES.WEB_PARAMETER_ID%TYPE,
94 adjustment_reason AP_INVOICE_LINES.ADJUSTMENT_REASON%TYPE,
95 merchant_document_number AP_INVOICE_LINES.MERCHANT_DOCUMENT_NUMBER%TYPE,
96 merchant_name AP_INVOICE_LINES.MERCHANT_NAME%TYPE,
97 merchant_reference AP_INVOICE_LINES.MERCHANT_REFERENCE%TYPE,
98 merchant_tax_reg_number AP_INVOICE_LINES.MERCHANT_TAX_REG_NUMBER%TYPE,
99 merchant_taxpayer_id AP_INVOICE_LINES.MERCHANT_TAXPAYER_ID%TYPE,
100 country_of_supply AP_INVOICE_LINES.COUNTRY_OF_SUPPLY%TYPE,
101 credit_card_trx_id AP_INVOICE_LINES.CREDIT_CARD_TRX_ID%TYPE,
102 company_prepaid_invoice_id AP_INVOICE_LINES.COMPANY_PREPAID_INVOICE_ID%TYPE,
103 cc_reversal_flag AP_INVOICE_LINES.CC_REVERSAL_FLAG%TYPE,
104 creation_date AP_INVOICE_LINES.CREATION_DATE%TYPE,
105 created_by AP_INVOICE_LINES.CREATED_BY%TYPE,
106 last_updated_by AP_INVOICE_LINES.LAST_UPDATED_BY%TYPE,
107 last_update_date AP_INVOICE_LINES.LAST_UPDATE_DATE%TYPE,
108 last_update_login AP_INVOICE_LINES.LAST_UPDATE_LOGIN%TYPE,
109 program_application_id AP_INVOICE_LINES.PROGRAM_APPLICATION_ID%TYPE,
110 program_id AP_INVOICE_LINES.PROGRAM_ID%TYPE,
111 program_update_date AP_INVOICE_LINES.PROGRAM_UPDATE_DATE%TYPE,
112 request_id AP_INVOICE_LINES.REQUEST_ID%TYPE,
113 attribute_category AP_INVOICE_LINES.ATTRIBUTE_CATEGORY%TYPE,
114 attribute1 AP_INVOICE_LINES.ATTRIBUTE1%TYPE,
115 attribute2 AP_INVOICE_LINES.ATTRIBUTE2%TYPE,
116 attribute3 AP_INVOICE_LINES.ATTRIBUTE3%TYPE,
117 attribute4 AP_INVOICE_LINES.ATTRIBUTE4%TYPE,
118 attribute5 AP_INVOICE_LINES.ATTRIBUTE5%TYPE,
119 attribute6 AP_INVOICE_LINES.ATTRIBUTE6%TYPE,
120 attribute7 AP_INVOICE_LINES.ATTRIBUTE7%TYPE,
121 attribute8 AP_INVOICE_LINES.ATTRIBUTE8%TYPE,
122 attribute9 AP_INVOICE_LINES.ATTRIBUTE9%TYPE,
123 attribute10 AP_INVOICE_LINES.ATTRIBUTE10%TYPE,
124 attribute11 AP_INVOICE_LINES.ATTRIBUTE11%TYPE,
125 attribute12 AP_INVOICE_LINES.ATTRIBUTE12%TYPE,
126 attribute13 AP_INVOICE_LINES.ATTRIBUTE13%TYPE,
127 attribute14 AP_INVOICE_LINES.ATTRIBUTE14%TYPE,
128 attribute15 AP_INVOICE_LINES.ATTRIBUTE15%TYPE,
129 global_attribute_category AP_INVOICE_LINES.GLOBAL_ATTRIBUTE_CATEGORY%TYPE,
130 global_attribute1 AP_INVOICE_LINES.GLOBAL_ATTRIBUTE1%TYPE,
131 global_attribute2 AP_INVOICE_LINES.GLOBAL_ATTRIBUTE2%TYPE,
132 global_attribute3 AP_INVOICE_LINES.GLOBAL_ATTRIBUTE3%TYPE,
133 global_attribute4 AP_INVOICE_LINES.GLOBAL_ATTRIBUTE4%TYPE,
134 global_attribute5 AP_INVOICE_LINES.GLOBAL_ATTRIBUTE5%TYPE,
135 global_attribute6 AP_INVOICE_LINES.GLOBAL_ATTRIBUTE6%TYPE,
136 global_attribute7 AP_INVOICE_LINES.GLOBAL_ATTRIBUTE7%TYPE,
137 global_attribute8 AP_INVOICE_LINES.GLOBAL_ATTRIBUTE8%TYPE,
138 global_attribute9 AP_INVOICE_LINES.GLOBAL_ATTRIBUTE9%TYPE,
139 global_attribute10 AP_INVOICE_LINES.GLOBAL_ATTRIBUTE10%TYPE,
140 global_attribute11 AP_INVOICE_LINES.GLOBAL_ATTRIBUTE11%TYPE,
141 global_attribute12 AP_INVOICE_LINES.GLOBAL_ATTRIBUTE12%TYPE,
142 global_attribute13 AP_INVOICE_LINES.GLOBAL_ATTRIBUTE13%TYPE,
143 global_attribute14 AP_INVOICE_LINES.GLOBAL_ATTRIBUTE14%TYPE,
144 global_attribute15 AP_INVOICE_LINES.GLOBAL_ATTRIBUTE15%TYPE,
145 global_attribute16 AP_INVOICE_LINES.GLOBAL_ATTRIBUTE16%TYPE,
146 global_attribute17 AP_INVOICE_LINES.GLOBAL_ATTRIBUTE17%TYPE,
147 global_attribute18 AP_INVOICE_LINES.GLOBAL_ATTRIBUTE18%TYPE,
148 global_attribute19 AP_INVOICE_LINES.GLOBAL_ATTRIBUTE19%TYPE,
149 global_attribute20 AP_INVOICE_LINES.GLOBAL_ATTRIBUTE20%TYPE,
150 --ETAX: invwkb
151 included_tax_amount AP_INVOICE_LINES.INCLUDED_TAX_AMOUNT%TYPE,
152 primary_intended_use AP_INVOICE_LINES.PRIMARY_INTENDED_USE%TYPE,
153 application_id AP_INVOICE_LINES.APPLICATION_ID%TYPE,
154 product_table AP_INVOICE_LINES.PRODUCT_TABLE%TYPE,
155 reference_key1 AP_INVOICE_LINES.REFERENCE_KEY1%TYPE,
156 reference_key2 AP_INVOICE_LINES.REFERENCE_KEY2%TYPE,
157 reference_key3 AP_INVOICE_LINES.REFERENCE_KEY3%TYPE,
158 reference_key4 AP_INVOICE_LINES.REFERENCE_KEY4%TYPE,
159 reference_key5 AP_INVOICE_LINES.REFERENCE_KEY5%TYPE,
160 --bugfix:4674194
161 ship_to_location_id AP_INVOICE_LINES.SHIP_TO_LOCATION_ID%TYPE,
162 --bug7022001
163 pay_awt_group_id AP_INVOICE_LINES.PAY_AWT_GROUP_ID%TYPE);
164
165 TYPE t_invoice_lines_table is TABLE of r_invoice_line_rec
166 index by BINARY_INTEGER;
167
168 PROCEDURE Insert_Row(
169 X_Rowid IN OUT NOCOPY VARCHAR2,
170 X_Invoice_Id IN OUT NOCOPY NUMBER,
171 X_Last_Update_Date DATE,
172 X_Last_Updated_By NUMBER,
173 X_Vendor_Id NUMBER,
174 X_Invoice_Num VARCHAR2,
175 X_Invoice_Amount NUMBER,
176 X_Vendor_Site_Id NUMBER,
177 X_Amount_Paid NUMBER,
178 X_Discount_Amount_Taken NUMBER,
179 X_Invoice_Date DATE,
180 X_Source VARCHAR2,
181 X_Invoice_Type_Lookup_Code VARCHAR2,
182 X_Description VARCHAR2,
183 X_Batch_Id NUMBER,
184 X_Amt_Applicable_To_Discount NUMBER,
185 X_Terms_Id NUMBER,
186 X_Terms_Date DATE,
187 X_Goods_Received_Date DATE,
188 X_Invoice_Received_Date DATE,
189 X_Voucher_Num VARCHAR2,
190 X_Approved_Amount NUMBER,
191 X_Approval_Status VARCHAR2,
192 X_Approval_Description VARCHAR2,
193 X_Pay_Group_Lookup_Code VARCHAR2,
194 X_Set_Of_Books_Id NUMBER,
195 X_Accts_Pay_CCId NUMBER,
196 X_Recurring_Payment_Id NUMBER,
197 X_Invoice_Currency_Code VARCHAR2,
198 X_Payment_Currency_Code VARCHAR2,
199 X_Exchange_Rate NUMBER,
200 X_Payment_Amount_Total NUMBER,
201 X_Payment_Status_Flag VARCHAR2,
202 X_Posting_Status VARCHAR2,
203 X_Authorized_By VARCHAR2,
204 X_Attribute_Category VARCHAR2,
205 X_Attribute1 VARCHAR2,
206 X_Attribute2 VARCHAR2,
207 X_Attribute3 VARCHAR2,
208 X_Attribute4 VARCHAR2,
209 X_Attribute5 VARCHAR2,
210 X_Creation_Date DATE,
211 X_Created_By NUMBER,
212 X_Vendor_Prepay_Amount NUMBER,
213 X_Base_Amount NUMBER,
214 X_Exchange_Rate_Type VARCHAR2,
215 X_Exchange_Date DATE,
216 X_Payment_Cross_Rate NUMBER,
217 X_Payment_Cross_Rate_Type VARCHAR2,
218 X_Payment_Cross_Rate_Date Date,
219 X_Pay_Curr_Invoice_Amount NUMBER,
220 X_Last_Update_Login NUMBER,
221 X_Original_Prepayment_Amount NUMBER,
222 X_Earliest_Settlement_Date DATE,
223 X_Attribute11 VARCHAR2,
224 X_Attribute12 VARCHAR2,
225 X_Attribute13 VARCHAR2,
226 X_Attribute14 VARCHAR2,
227 X_Attribute6 VARCHAR2,
228 X_Attribute7 VARCHAR2,
229 X_Attribute8 VARCHAR2,
230 X_Attribute9 VARCHAR2,
231 X_Attribute10 VARCHAR2,
232 X_Attribute15 VARCHAR2,
233 X_Cancelled_Date DATE,
234 X_Cancelled_By NUMBER,
235 X_Cancelled_Amount NUMBER,
236 X_Temp_Cancelled_Amount NUMBER,
237 X_Exclusive_Payment_Flag VARCHAR2,
238 X_Po_Header_Id NUMBER,
239 X_Doc_Sequence_Id NUMBER,
240 X_Doc_Sequence_Value NUMBER,
241 X_Doc_Category_Code VARCHAR2,
242 X_Expenditure_Item_Date DATE,
243 X_Expenditure_Organization_Id NUMBER,
244 X_Expenditure_Type VARCHAR2,
245 X_Pa_Default_Dist_Ccid NUMBER,
246 X_Pa_Quantity NUMBER,
247 X_Project_Id NUMBER,
248 X_Task_Id NUMBER,
249 X_Awt_Flag VARCHAR2,
250 X_Awt_Group_Id NUMBER,
254 X_Org_Id NUMBER,
251 X_Pay_Awt_Group_Id NUMBER,--bug6639866
252 X_Reference_1 VARCHAR2,
253 X_Reference_2 VARCHAR2,
255 X_global_attribute_category VARCHAR2 DEFAULT NULL,
256 X_global_attribute1 VARCHAR2 DEFAULT NULL,
257 X_global_attribute2 VARCHAR2 DEFAULT NULL,
258 X_global_attribute3 VARCHAR2 DEFAULT NULL,
259 X_global_attribute4 VARCHAR2 DEFAULT NULL,
260 X_global_attribute5 VARCHAR2 DEFAULT NULL,
261 X_global_attribute6 VARCHAR2 DEFAULT NULL,
262 X_global_attribute7 VARCHAR2 DEFAULT NULL,
263 X_global_attribute8 VARCHAR2 DEFAULT NULL,
264 X_global_attribute9 VARCHAR2 DEFAULT NULL,
265 X_global_attribute10 VARCHAR2 DEFAULT NULL,
266 X_global_attribute11 VARCHAR2 DEFAULT NULL,
267 X_global_attribute12 VARCHAR2 DEFAULT NULL,
268 X_global_attribute13 VARCHAR2 DEFAULT NULL,
269 X_global_attribute14 VARCHAR2 DEFAULT NULL,
270 X_global_attribute15 VARCHAR2 DEFAULT NULL,
271 X_global_attribute16 VARCHAR2 DEFAULT NULL,
272 X_global_attribute17 VARCHAR2 DEFAULT NULL,
273 X_global_attribute18 VARCHAR2 DEFAULT NULL,
274 X_global_attribute19 VARCHAR2 DEFAULT NULL,
275 X_global_attribute20 VARCHAR2 DEFAULT NULL,
276 X_calling_sequence IN VARCHAR2,
277 X_gl_date DATE,
278 X_Award_Id NUMBER,
279 X_APPROVAL_ITERATION NUMBER DEFAULT NULL,
280 X_APPROVAL_READY_FLAG VARCHAR2 DEFAULT 'Y',
281 X_WFAPPROVAL_STATUS VARCHAR2 DEFAULT 'NOT REQUIRED',
282 X_REQUESTER_ID NUMBER DEFAULT NULL,
283 -- Invoice Lines Project Stage 1
284 X_QUICK_CREDIT VARCHAR2 DEFAULT NULL,
285 X_CREDITED_INVOICE_ID NUMBER DEFAULT NULL,
286 X_DISTRIBUTION_SET_ID NUMBER DEFAULT NULL,
287 --Etax: Invwkb
288 X_FORCE_REVALIDATION_FLAG VARCHAR2 DEFAULT NULL,
289 X_CONTROL_AMOUNT NUMBER DEFAULT NULL,
290 X_TAX_RELATED_INVOICE_ID NUMBER DEFAULT NULL,
291 X_TRX_BUSINESS_CATEGORY VARCHAR2 DEFAULT NULL,
292 X_USER_DEFINED_FISC_CLASS VARCHAR2 DEFAULT NULL,
293 X_TAXATION_COUNTRY VARCHAR2 DEFAULT NULL,
294 X_DOCUMENT_SUB_TYPE VARCHAR2 DEFAULT NULL,
295 X_SUPPLIER_TAX_INVOICE_NUMBER VARCHAR2 DEFAULT NULL,
296 X_SUPPLIER_TAX_INVOICE_DATE DATE DEFAULT NULL,
297 X_SUPPLIER_TAX_EXCHANGE_RATE NUMBER DEFAULT NULL,
298 X_TAX_INVOICE_RECORDING_DATE DATE DEFAULT NULL,
299 X_TAX_INVOICE_INTERNAL_SEQ NUMBER DEFAULT NULL,
300 X_LEGAL_ENTITY_ID NUMBER DEFAULT NULL,
301 X_QUICK_PO_HEADER_ID NUMBER DEFAULT NULL,
302 x_PAYMENT_METHOD_CODE varchar2 ,
303 x_PAYMENT_REASON_CODE varchar2 default null,
304 X_PAYMENT_REASON_COMMENTS varchar2 default null,
305 x_UNIQUE_REMITTANCE_IDENTIFIER varchar2 default null,
306 x_URI_CHECK_DIGIT varchar2 default null,
307 x_BANK_CHARGE_BEARER varchar2 default null,
308 x_DELIVERY_CHANNEL_CODE varchar2 default null,
309 x_SETTLEMENT_PRIORITY varchar2 default null,
310 x_NET_OF_RETAINAGE_FLAG varchar2 default null,
311 x_RELEASE_AMOUNT_NET_OF_TAX number default null,
312 x_PORT_OF_ENTRY_CODE varchar2 default null,
313 x_external_bank_account_id number default null,
314 x_party_id number default null,
315 x_party_site_id number default null,
316 /* bug 4931755. Exclude Tax and Freight from Discount */
317 x_disc_is_inv_less_tax_flag varchar2 default null,
318 x_exclude_freight_from_disc varchar2 default null,
319 x_remit_msg1 varchar2 default null,
320 x_remit_msg2 varchar2 default null,
321 x_remit_msg3 varchar2 default null,
322 x_cust_registration_number varchar2 default null,
323 /* Third Party Payments*/
324 x_remit_to_supplier_name varchar2 default null,
325 x_remit_to_supplier_id number default null,
326 x_remit_to_supplier_site varchar2 default null,
327 x_remit_to_supplier_site_id number default null,
328 x_relationship_id number default null,
329 /* Bug 7831073 */
330 x_original_invoice_amount number default null,
331 x_dispute_reason varchar2 default null
332 );
333
334 PROCEDURE Lock_Row(
335 X_Invoice_id NUMBER,
336 X_calling_sequence VARCHAR2);
337
338 PROCEDURE Lock_Row(X_Rowid VARCHAR2,
339 X_Invoice_Id NUMBER,
340 X_Vendor_Id NUMBER,
341 X_Invoice_Num VARCHAR2,
342 X_Invoice_Amount NUMBER,
346 X_Invoice_Date DATE,
343 X_Vendor_Site_Id NUMBER,
344 X_Amount_Paid NUMBER,
345 X_Discount_Amount_Taken NUMBER,
347 X_Source VARCHAR2,
348 X_Invoice_Type_Lookup_Code VARCHAR2,
349 X_Description VARCHAR2,
350 X_Batch_Id NUMBER,
351 X_Amt_Applicable_To_Discount NUMBER,
352 X_Terms_Id NUMBER,
353 X_Terms_Date DATE,
354 X_Goods_Received_Date DATE,
355 X_Invoice_Received_Date DATE,
356 X_Voucher_Num VARCHAR2,
357 X_Approved_Amount NUMBER,
358 X_Approval_Status VARCHAR2,
359 X_Approval_Description VARCHAR2,
360 X_Pay_Group_Lookup_Code VARCHAR2,
361 X_Set_Of_Books_Id NUMBER,
362 X_Accts_Pay_CCId NUMBER,
363 X_Recurring_Payment_Id NUMBER,
364 X_Invoice_Currency_Code VARCHAR2,
365 X_Payment_Currency_Code VARCHAR2,
366 X_Exchange_Rate NUMBER,
367 X_Payment_Amount_Total NUMBER,
368 X_Payment_Status_Flag VARCHAR2,
369 X_Posting_Status VARCHAR2,
370 X_Posting_Flag VARCHAR2,
371 X_Authorized_By VARCHAR2,
372 X_Attribute_Category VARCHAR2,
373 X_Attribute1 VARCHAR2,
374 X_Attribute2 VARCHAR2,
375 X_Attribute3 VARCHAR2,
376 X_Attribute4 VARCHAR2,
377 X_Attribute5 VARCHAR2,
378 X_Vendor_Prepay_Amount NUMBER,
379 X_Base_Amount NUMBER,
380 X_Exchange_Rate_Type VARCHAR2,
381 X_Exchange_Date DATE,
382 X_Payment_Cross_Rate NUMBER,
383 X_Payment_Cross_Rate_Type VARCHAR2,
384 X_Payment_Cross_Rate_Date DATE,
385 X_Pay_Curr_Invoice_Amount NUMBER,
386 X_Original_Prepayment_Amount NUMBER,
387 X_Earliest_Settlement_Date DATE,
388 X_Attribute11 VARCHAR2,
389 X_Attribute12 VARCHAR2,
390 X_Attribute13 VARCHAR2,
391 X_Attribute14 VARCHAR2,
392 X_Attribute6 VARCHAR2,
393 X_Attribute7 VARCHAR2,
394 X_Attribute8 VARCHAR2,
395 X_Attribute9 VARCHAR2,
396 X_Attribute10 VARCHAR2,
397 X_Attribute15 VARCHAR2,
398 X_Cancelled_Date DATE,
399 X_Cancelled_By NUMBER,
400 X_Cancelled_Amount NUMBER,
401 X_Temp_Cancelled_Amount NUMBER,
402 X_Exclusive_Payment_Flag VARCHAR2,
403 X_Po_Header_Id NUMBER,
404 X_Doc_Sequence_Id NUMBER,
405 X_Doc_Sequence_Value NUMBER,
406 X_Doc_Category_Code VARCHAR2,
407 X_Expenditure_Item_Date DATE,
408 X_Expenditure_Organization_Id NUMBER,
409 X_Expenditure_Type VARCHAR2,
410 X_Pa_Default_Dist_Ccid NUMBER,
411 X_Pa_Quantity NUMBER,
412 X_Project_Id NUMBER,
413 X_Task_Id NUMBER,
414 X_Awt_Flag VARCHAR2,
415 X_Awt_Group_Id NUMBER,
416 X_Pay_Awt_Group_Id NUMBER,--bug6639866
417 X_Reference_1 VARCHAR2,
418 X_Reference_2 VARCHAR2,
419 X_Org_Id NUMBER,
420 X_global_attribute_category VARCHAR2 DEFAULT NULL,
421 X_global_attribute1 VARCHAR2 DEFAULT NULL,
422 X_global_attribute2 VARCHAR2 DEFAULT NULL,
423 X_global_attribute3 VARCHAR2 DEFAULT NULL,
424 X_global_attribute4 VARCHAR2 DEFAULT NULL,
425 X_global_attribute5 VARCHAR2 DEFAULT NULL,
426 X_global_attribute6 VARCHAR2 DEFAULT NULL,
427 X_global_attribute7 VARCHAR2 DEFAULT NULL,
428 X_global_attribute8 VARCHAR2 DEFAULT NULL,
429 X_global_attribute9 VARCHAR2 DEFAULT NULL,
430 X_global_attribute10 VARCHAR2 DEFAULT NULL,
431 X_global_attribute11 VARCHAR2 DEFAULT NULL,
432 X_global_attribute12 VARCHAR2 DEFAULT NULL,
433 X_global_attribute13 VARCHAR2 DEFAULT NULL,
434 X_global_attribute14 VARCHAR2 DEFAULT NULL,
435 X_global_attribute15 VARCHAR2 DEFAULT NULL,
436 X_global_attribute16 VARCHAR2 DEFAULT NULL,
437 X_global_attribute17 VARCHAR2 DEFAULT NULL,
441 X_calling_sequence IN VARCHAR2,
438 X_global_attribute18 VARCHAR2 DEFAULT NULL,
439 X_global_attribute19 VARCHAR2 DEFAULT NULL,
440 X_global_attribute20 VARCHAR2 DEFAULT NULL,
442 X_gl_date DATE,
443 X_Award_Id NUMBER,
444 X_APPROVAL_ITERATION NUMBER,
445 X_APPROVAL_READY_FLAG VARCHAR2,
446 X_WFAPPROVAL_STATUS VARCHAR2,
447 X_REQUESTER_ID NUMBER DEFAULT NULL,
448 -- Invoice Lines Project Stage 1
449 X_QUICK_CREDIT VARCHAR2 DEFAULT NULL,
450 X_CREDITED_INVOICE_ID NUMBER DEFAULT NULL,
451 X_DISTRIBUTION_SET_ID NUMBER DEFAULT NULL,
452 --ETAX: Invwkb
453 X_FORCE_REVALIDATION_FLAG VARCHAR2 DEFAULT NULL,
454 X_CONTROL_AMOUNT NUMBER DEFAULT NULL,
455 X_TAX_RELATED_INVOICE_ID NUMBER DEFAULT NULL,
456 X_TRX_BUSINESS_CATEGORY VARCHAR2 DEFAULT NULL,
457 X_USER_DEFINED_FISC_CLASS VARCHAR2 DEFAULT NULL,
458 X_TAXATION_COUNTRY VARCHAR2 DEFAULT NULL,
459 X_DOCUMENT_SUB_TYPE VARCHAR2 DEFAULT NULL,
460 X_SUPPLIER_TAX_INVOICE_NUMBER VARCHAR2 DEFAULT NULL,
461 X_SUPPLIER_TAX_INVOICE_DATE DATE DEFAULT NULL,
462 X_SUPPLIER_TAX_EXCHANGE_RATE NUMBER DEFAULT NULL,
463 X_TAX_INVOICE_RECORDING_DATE DATE DEFAULT NULL,
464 X_TAX_INVOICE_INTERNAL_SEQ NUMBER DEFAULT NULL,
465 X_QUICK_PO_HEADER_ID NUMBER DEFAULT NULL,
466 x_PAYMENT_METHOD_CODE varchar2 ,
467 x_PAYMENT_REASON_CODE varchar2 default null,
468 X_PAYMENT_REASON_COMMENTS varchar2 default null,
469 x_UNIQUE_REMITTANCE_IDENTIFIER varchar2 default null,
470 x_URI_CHECK_DIGIT varchar2 default null,
471 x_BANK_CHARGE_BEARER varchar2 default null,
472 x_DELIVERY_CHANNEL_CODE varchar2 default null,
473 x_SETTLEMENT_PRIORITY varchar2 default null,
474 x_NET_OF_RETAINAGE_FLAG varchar2 default null,
475 x_RELEASE_AMOUNT_NET_OF_TAX number default null,
476 x_PORT_OF_ENTRY_CODE varchar2 default null,
477 x_external_bank_account_id number default null,
478 x_party_id number default null,
479 x_party_site_id number default null,
480 /* bug 4931755. Exclude Tax and Freight from Discount */
481 x_disc_is_inv_less_tax_flag varchar2 default null,
482 x_exclude_freight_from_disc varchar2 default null,
483 x_remit_msg1 varchar2 default null,
484 x_remit_msg2 varchar2 default null,
485 x_remit_msg3 varchar2 default null,
486 /* Third Party Payments*/
487 x_remit_to_supplier_name varchar2 default null,
488 x_remit_to_supplier_id number default null,
489 x_remit_to_supplier_site varchar2 default null,
490 x_remit_to_supplier_site_id number default null,
491 x_relationship_id number default null,
492 /* Bug 7831073 */
493 x_original_invoice_amount number default null,
494 x_dispute_reason varchar2 default null
495 );
496
497
498 PROCEDURE Update_Row(
499 X_Rowid VARCHAR2,
500 X_Invoice_Id NUMBER,
501 X_Last_Update_Date DATE,
502 X_Last_Updated_By NUMBER,
503 X_Vendor_Id NUMBER,
504 X_Invoice_Num VARCHAR2,
505 X_Invoice_Amount NUMBER,
506 X_Vendor_Site_Id NUMBER,
507 X_Amount_Paid NUMBER,
508 X_Discount_Amount_Taken NUMBER,
509 X_Invoice_Date DATE,
510 X_Source VARCHAR2,
511 X_Invoice_Type_Lookup_Code VARCHAR2,
512 X_Description VARCHAR2,
513 X_Batch_Id NUMBER,
514 X_Amt_Applicable_To_Discount NUMBER,
515 X_Terms_Id NUMBER,
516 X_Terms_Date DATE,
517 X_Goods_Received_Date DATE,
518 X_Invoice_Received_Date DATE,
519 X_Voucher_Num VARCHAR2,
520 X_Approved_Amount NUMBER,
521 X_Approval_Status VARCHAR2,
522 X_Approval_Description VARCHAR2,
523 X_Pay_Group_Lookup_Code VARCHAR2,
524 X_Set_Of_Books_Id NUMBER,
525 X_Accts_Pay_CCId NUMBER,
526 X_Recurring_Payment_Id NUMBER,
527 X_Invoice_Currency_Code VARCHAR2,
528 X_Payment_Currency_Code VARCHAR2,
529 X_Exchange_Rate NUMBER,
530 X_Payment_Amount_Total NUMBER,
531 X_Payment_Status_Flag VARCHAR2,
532 X_Posting_Status VARCHAR2,
533 X_Authorized_By VARCHAR2,
534 X_Attribute_Category VARCHAR2,
538 X_Attribute4 VARCHAR2,
535 X_Attribute1 VARCHAR2,
536 X_Attribute2 VARCHAR2,
537 X_Attribute3 VARCHAR2,
539 X_Attribute5 VARCHAR2,
540 X_Vendor_Prepay_Amount NUMBER,
541 X_Base_Amount NUMBER,
542 X_Exchange_Rate_Type VARCHAR2,
543 X_Exchange_Date DATE,
544 X_Payment_Cross_Rate NUMBER,
545 X_Payment_Cross_Rate_Type VARCHAR2,
546 X_Payment_Cross_Rate_Date DATE,
547 X_Pay_Curr_Invoice_Amount NUMBER,
548 X_Last_Update_Login NUMBER,
549 X_Original_Prepayment_Amount NUMBER,
550 X_Earliest_Settlement_Date DATE,
551 X_Attribute11 VARCHAR2,
552 X_Attribute12 VARCHAR2,
553 X_Attribute13 VARCHAR2,
554 X_Attribute14 VARCHAR2,
555 X_Attribute6 VARCHAR2,
556 X_Attribute7 VARCHAR2,
557 X_Attribute8 VARCHAR2,
558 X_Attribute9 VARCHAR2,
559 X_Attribute10 VARCHAR2,
560 X_Attribute15 VARCHAR2,
561 X_Cancelled_Date DATE,
562 X_Cancelled_By NUMBER,
563 X_Cancelled_Amount NUMBER,
564 X_Temp_Cancelled_Amount NUMBER,
565 X_Exclusive_Payment_Flag VARCHAR2,
566 X_Po_Header_Id NUMBER,
567 X_Doc_Sequence_Id NUMBER,
568 X_Doc_Sequence_Value NUMBER,
569 X_Doc_Category_Code VARCHAR2,
570 X_Expenditure_Item_Date DATE,
571 X_Expenditure_Organization_Id NUMBER,
572 X_Expenditure_Type VARCHAR2,
573 X_Pa_Default_Dist_Ccid NUMBER,
574 X_Pa_Quantity NUMBER,
575 X_Project_Id NUMBER,
576 X_Task_Id NUMBER,
577 X_Awt_Flag VARCHAR2,
578 X_Awt_Group_Id NUMBER,
579 X_Pay_Awt_Group_Id NUMBER,--bug6639866
580 X_Reference_1 VARCHAR2,
581 X_Reference_2 VARCHAR2,
582 X_Org_Id NUMBER,
583 X_global_attribute_category VARCHAR2 DEFAULT NULL,
584 X_global_attribute1 VARCHAR2 DEFAULT NULL,
585 X_global_attribute2 VARCHAR2 DEFAULT NULL,
586 X_global_attribute3 VARCHAR2 DEFAULT NULL,
587 X_global_attribute4 VARCHAR2 DEFAULT NULL,
588 X_global_attribute5 VARCHAR2 DEFAULT NULL,
589 X_global_attribute6 VARCHAR2 DEFAULT NULL,
590 X_global_attribute7 VARCHAR2 DEFAULT NULL,
591 X_global_attribute8 VARCHAR2 DEFAULT NULL,
592 X_global_attribute9 VARCHAR2 DEFAULT NULL,
593 X_global_attribute10 VARCHAR2 DEFAULT NULL,
594 X_global_attribute11 VARCHAR2 DEFAULT NULL,
595 X_global_attribute12 VARCHAR2 DEFAULT NULL,
596 X_global_attribute13 VARCHAR2 DEFAULT NULL,
597 X_global_attribute14 VARCHAR2 DEFAULT NULL,
598 X_global_attribute15 VARCHAR2 DEFAULT NULL,
599 X_global_attribute16 VARCHAR2 DEFAULT NULL,
600 X_global_attribute17 VARCHAR2 DEFAULT NULL,
601 X_global_attribute18 VARCHAR2 DEFAULT NULL,
602 X_global_attribute19 VARCHAR2 DEFAULT NULL,
603 X_global_attribute20 VARCHAR2 DEFAULT NULL,
604 X_calling_sequence IN VARCHAR2,
605 X_gl_date DATE,
606 X_award_Id NUMBER,
607 X_approval_iteration NUMBER,
608 X_approval_ready_flag VARCHAR2,
609 X_wfapproval_status VARCHAR2,
610 X_requester_id NUMBER DEFAULT NULL,
611 -- Invoice Lines Project Stage 1
612 X_quick_credit VARCHAR2 DEFAULT NULL,
613 X_credited_invoice_id NUMBER DEFAULT NULL,
614 X_distribution_set_id NUMBER DEFAULT NULL,
615 X_FORCE_REVALIDATION_FLAG VARCHAR2 DEFAULT NULL,
616 X_CONTROL_AMOUNT NUMBER DEFAULT NULL,
617 X_TAX_RELATED_INVOICE_ID NUMBER DEFAULT NULL,
618 X_TRX_BUSINESS_CATEGORY VARCHAR2 DEFAULT NULL,
619 X_USER_DEFINED_FISC_CLASS VARCHAR2 DEFAULT NULL,
620 X_TAXATION_COUNTRY VARCHAR2 DEFAULT NULL,
621 X_DOCUMENT_SUB_TYPE VARCHAR2 DEFAULT NULL,
622 X_SUPPLIER_TAX_INVOICE_NUMBER VARCHAR2 DEFAULT NULL,
623 X_SUPPLIER_TAX_INVOICE_DATE DATE DEFAULT NULL,
624 X_SUPPLIER_TAX_EXCHANGE_RATE NUMBER DEFAULT NULL,
625 X_TAX_INVOICE_RECORDING_DATE DATE DEFAULT NULL,
626 X_TAX_INVOICE_INTERNAL_SEQ NUMBER DEFAULT NULL,
630 X_PAYMENT_REASON_COMMENTS varchar2 default null,
627 X_QUICK_PO_HEADER_ID NUMBER DEFAULT NULL,
628 x_PAYMENT_METHOD_CODE varchar2 ,
629 x_PAYMENT_REASON_CODE varchar2 default null,
631 x_UNIQUE_REMITTANCE_IDENTIFIER varchar2 default null,
632 x_URI_CHECK_DIGIT varchar2 default null,
633 x_BANK_CHARGE_BEARER varchar2 default null,
634 x_DELIVERY_CHANNEL_CODE varchar2 default null,
635 x_SETTLEMENT_PRIORITY varchar2 default null,
636 x_NET_OF_RETAINAGE_FLAG varchar2 default null,
637 x_RELEASE_AMOUNT_NET_OF_TAX number default null,
638 x_PORT_OF_ENTRY_CODE varchar2 default null,
639 x_external_bank_account_id number default null,
640 x_party_id number default null,
641 x_party_site_id number default null,
642 /* bug 4931755. Exclude Tax and Freight from Discount */
643 x_disc_is_inv_less_tax_flag varchar2 default null,
644 x_exclude_freight_from_disc varchar2 default null,
645 x_remit_msg1 varchar2 default null,
646 x_remit_msg2 varchar2 default null,
647 x_remit_msg3 varchar2 default null,
648 /* Third Party Payments*/
649 x_remit_to_supplier_name varchar2 default null,
650 x_remit_to_supplier_id number default null,
651 x_remit_to_supplier_site varchar2 default null,
652 x_remit_to_supplier_site_id number default null,
653 x_relationship_id number default null,
654 /* Bug 7831073 */
655 x_original_invoice_amount number default null,
656 x_dispute_reason varchar2 default null
657 );
658
659
660 PROCEDURE Delete_Row(
661 X_Rowid VARCHAR2,
662 X_calling_sequence VARCHAR2);
663
664 PROCEDURE CHECK_UNIQUE (
665 X_rowid VARCHAR2,
666 X_invoice_num VARCHAR2,
667 X_vendor_id NUMBER,
668 X_org_id NUMBER, -- 5407785
669 X_calling_sequence VARCHAR2);
670
671 PROCEDURE CHECK_UNIQUE_VOUCHER_NUM(
672 X_rowid VARCHAR2,
673 X_voucher_num VARCHAR2,
674 X_calling_sequence VARCHAR2);
675
676 FUNCTION get_distribution_total(l_invoice_id IN NUMBER) RETURN NUMBER;
677 FUNCTION get_posting_status(l_invoice_id IN NUMBER) RETURN VARCHAR2;
678 FUNCTION get_approval_status(l_invoice_id IN NUMBER,
679 l_invoice_amount IN NUMBER,
680 l_payment_status_flag IN VARCHAR2,
681 l_invoice_type_lookup_code IN VARCHAR2)
682 RETURN VARCHAR2;
683
684 FUNCTION get_po_number(l_invoice_id IN NUMBER) RETURN VARCHAR2;
685 FUNCTION get_release_number(l_invoice_id IN NUMBER) RETURN VARCHAR2;
686 FUNCTION get_receipt_number(l_invoice_id IN NUMBER) RETURN VARCHAR2;
687 FUNCTION get_po_number_list(l_invoice_id IN NUMBER) RETURN VARCHAR2;
688 FUNCTION get_amount_withheld(l_invoice_id IN NUMBER) RETURN NUMBER;
689 FUNCTION get_prepaid_amount(l_invoice_id IN NUMBER) RETURN NUMBER;
690 FUNCTION get_notes_count(l_invoice_id IN NUMBER) RETURN NUMBER;
691 FUNCTION get_holds_count(l_invoice_id IN NUMBER) RETURN NUMBER;
692 FUNCTION get_sched_holds_count(l_invoice_id IN NUMBER) RETURN NUMBER; --bug 5334577
693 FUNCTION get_amount_hold_flag(l_invoice_id IN NUMBER) RETURN VARCHAR2;
694 FUNCTION get_vendor_hold_flag(l_invoice_id IN NUMBER) RETURN VARCHAR2;
695 FUNCTION get_total_prepays(l_vendor_id IN NUMBER,
696 l_org_id IN NUMBER
697 ) RETURN NUMBER;
698 FUNCTION get_available_prepays(l_vendor_id IN NUMBER,
699 l_org_id IN NUMBER
700 ) RETURN NUMBER;
701 FUNCTION get_encumbered_flag(l_invoice_id IN NUMBER) RETURN VARCHAR2;
702 FUNCTION get_gl_date(l_invoice_date IN date,
703 l_receipt_date IN date default null) RETURN DATE;
704 FUNCTION get_period_name(l_invoice_date IN date,
705 l_receipt_date IN date default null,
706 l_org_id IN NUMBER DEFAULT
707 MO_GLOBAL.GET_CURRENT_ORG_ID
708 ) RETURN VARCHAR2;
709 FUNCTION get_similar_drcr_memo(
710 P_vendor_id IN NUMBER,
711 P_vendor_site_id IN NUMBER,
712 P_invoice_amount IN NUMBER,
713 P_invoice_type_lookup_code IN VARCHAR2,
714 P_invoice_currency_code IN VARCHAR2,
715 P_calling_sequence IN VARCHAR2) RETURN varchar2;
716
717 PROCEDURE get_gl_date_and_period(
718 P_Date IN DATE,
719 P_Receipt_Date IN DATE DEFAULT NULL,
720 P_Period_Name OUT NOCOPY VARCHAR2,
721 P_GL_Date OUT NOCOPY DATE,
722 P_Batch_GL_Date IN DATE DEFAULT NULL,
723 P_Org_Id IN NUMBER DEFAULT
724 MO_GLOBAL.GET_CURRENT_ORG_ID);
725 FUNCTION eft_bank_details_exist (
726 P_vendor_site_id IN NUMBER,
727 P_calling_sequence IN VARCHAR2) RETURN BOOLEAN;
728 FUNCTION eft_bank_curr_details_exist (
729 P_vendor_site_id IN NUMBER,
730 P_currency_code IN VARCHAR2,
734 RETURN VARCHAR2;
731 P_calling_sequence IN VARCHAR2) RETURN boolean;
732 FUNCTION selected_for_payment_flag (P_invoice_id IN NUMBER) RETURN VARCHAR2;
733 FUNCTION get_unposted_void_payment (P_invoice_id IN NUMBER)
735 FUNCTION get_discount_pay_dists_flag (P_invoice_id IN NUMBER)
736 RETURN VARCHAR2;
737 FUNCTION get_prepayments_applied_flag (P_invoice_id IN NUMBER)
738 RETURN VARCHAR2;
739 FUNCTION get_payments_exist_flag (P_invoice_id IN NUMBER)
740 RETURN VARCHAR2;
741 FUNCTION get_prepay_amount_applied (P_invoice_id IN NUMBER)
742 RETURN NUMBER;
743 FUNCTION get_packet_id (P_invoice_id IN NUMBER)
744 RETURN NUMBER;
745
746 PROCEDURE create_holds (
747 X_invoice_id IN NUMBER,
748 X_event IN VARCHAR2 DEFAULT 'UPDATE',
749 X_update_base IN VARCHAR2 DEFAULT 'N',
750 X_vendor_changed_flag IN VARCHAR2 DEFAULT 'N',
751 X_calling_sequence IN VARCHAR2);
752
753 PROCEDURE insert_children (
754 X_invoice_id IN NUMBER,
755 X_Payment_Priority IN NUMBER,
756 X_Hold_count IN OUT NOCOPY NUMBER,
757 X_Line_count IN OUT NOCOPY NUMBER,
758 X_Line_Total IN OUT NOCOPY NUMBER,
759 X_calling_sequence IN VARCHAR2,
760 X_Sched_Hold_count IN OUT NOCOPY NUMBER); -- bug 5334577
761
762 PROCEDURE invoice_pre_update (
763 X_invoice_id IN NUMBER,
764 X_invoice_amount IN NUMBER,
765 X_payment_status_flag IN OUT NOCOPY VARCHAR2,
766 X_invoice_type_lookup_code IN VARCHAR2,
767 X_last_updated_by IN NUMBER,
768 X_accts_pay_ccid IN NUMBER,
769 X_terms_id IN NUMBER,
770 X_terms_date IN DATE,
771 X_discount_amount IN NUMBER,
772 X_exchange_rate_type IN VARCHAR2,
773 X_exchange_date IN DATE,
774 X_exchange_rate IN NUMBER,
775 X_vendor_id IN NUMBER,
776 X_payment_method_code IN VARCHAR2,
777 X_message1 IN OUT NOCOPY VARCHAR2,
778 X_message2 IN OUT NOCOPY VARCHAR2,
779 X_reset_match_status IN OUT NOCOPY VARCHAR2,
780 X_vendor_changed_flag IN OUT NOCOPY VARCHAR2,
781 X_recalc_pay_sched IN OUT NOCOPY VARCHAR2,
782 X_liability_adjusted_flag IN OUT NOCOPY VARCHAR2,
783 X_external_bank_account_id IN NUMBER, --bug 7714053
784 X_calling_sequence IN VARCHAR2,
785 X_revalidate_ps IN OUT NOCOPY VARCHAR2);
786
787 PROCEDURE invoice_post_update (
788 X_invoice_id IN NUMBER,
789 X_payment_priority IN NUMBER,
790 X_recalc_pay_sched IN OUT NOCOPY VARCHAR2,
791 X_Hold_count IN OUT NOCOPY NUMBER,
792 X_update_base IN VARCHAR2,
793 X_vendor_changed_flag IN VARCHAR2,
794 X_calling_sequence IN VARCHAR2,
795 X_Sched_Hold_count IN OUT NOCOPY NUMBER); -- bug 5334577
796
797 PROCEDURE Select_Summary(
798 X_Batch_ID IN NUMBER,
799 X_Total IN OUT NOCOPY NUMBER,
800 X_Total_Rtot_DB IN OUT NOCOPY NUMBER,
801 X_Calling_Sequence IN VARCHAR2);
802
803 --Invoice Lines: Distributions
804 PROCEDURE post_forms_commit(
805 X_invoice_id IN NUMBER,
806 X_type_1099 IN VARCHAR2,
807 X_income_tax_region IN VARCHAR2,
808 X_vendor_changed_flag IN OUT NOCOPY VARCHAR2,
809 X_update_base IN OUT NOCOPY VARCHAR2,
810 X_reset_match_status IN OUT NOCOPY VARCHAR2,
811 X_update_occurred IN OUT NOCOPY VARCHAR2,
812 X_approval_status_lookup_code IN OUT NOCOPY VARCHAR2,
813 X_holds_count IN OUT NOCOPY NUMBER,
814 X_posting_flag IN OUT NOCOPY VARCHAR2,
815 X_amount_paid IN OUT NOCOPY NUMBER,
816 X_highest_line_num IN OUT NOCOPY NUMBER,
817 X_line_total IN OUT NOCOPY NUMBER,
818 X_actual_invoice_count IN OUT NOCOPY NUMBER,
819 X_actual_invoice_total IN OUT NOCOPY NUMBER,
820 X_calling_sequence IN VARCHAR2,
821 X_sched_holds_count IN OUT NOCOPY NUMBER); --bug 5334577
822
823
824 /*==========================================================================*/
825 /* */
826 /* This RETURNs the max line NUMBER given an invoice. */
827 /* */
828 /*==========================================================================*/
829
830 FUNCTION Get_Max_Line_Number(
831 X_invoice_id IN NUMBER) RETURN NUMBER;
832
833 /*==========================================================================*/
834 /* */
835 /* This FUNCTION RETURNs the expenditure item date for a project related */
836 /* invoice, line or distribution based on the Projects profile: 'PA: Default*/
837 /* Expenditure Item Date for AP Invoices'. This FUNCTION should not be */
838 /* invoked unless the invoice/line or distribution is project related. */
839 /* This function's parameters work as follows: */
840 /* X_invoice_id: Always required. */
841 /* X_invoice_date:Invoice Date. */
842 /* X_GL_Date: Accounting Date */
843 /* X_po_dist_id: Dist ID of PO distribution IF such information available */
844 /* at line or distribution level. */
845 /* X_rcv_trx_id: Receipt Transaction ID for Receipt IF such information */
846 /* is available at the line or distribution level. */
847 /* X_error_found: Out parameter RETURNing Y IF an error was found. */
848 /* */
849 /*==========================================================================*/
850
851 FUNCTION Get_Expenditure_Item_Date(
852 X_invoice_id IN NUMBER,
853 X_invoice_date IN DATE,
854 X_GL_date IN DATE,
855 X_po_dist_id IN NUMBER DEFAULT NULL,
856 X_rcv_trx_id IN NUMBER DEFAULT NULL,
857 X_error_found OUT NOCOPY VARCHAR2) RETURN DATE;
858
859 --bug4299234
860 FUNCTION Get_WFapproval_Status(
861 P_invoice_id IN NUMBER,
862 P_org_id IN NUMBER) RETURN VARCHAR2;
863
864
865 procedure get_payment_attributes (p_le_id IN NUMBER,
866 p_org_id in number,
867 p_payee_party_id in number,
868 p_payee_party_site_id in number,
869 p_supplier_site_id in number,
870 p_payment_currency in varchar2,
871 p_payment_amount in number,
872 p_payment_function in varchar2,
873 p_pay_proc_trxn_type_code in varchar2,
874 p_PAYMENT_METHOD_CODE out nocopy varchar2,
875 p_IBY_PAYMENT_METHOD out nocopy varchar2,
876 p_PAYMENT_REASON_CODE out nocopy varchar2,
877 p_PAYMENT_REASON out nocopy varchar2,
878 p_BANK_CHARGE_BEARER out nocopy varchar2,
879 p_BANK_CHARGE_BEARER_DSP out nocopy varchar2,
880 p_DELIVERY_CHANNEL_CODE out nocopy varchar2,
881 p_DELIVERY_CHANNEL out nocopy varchar2,
882 p_SETTLEMENT_PRIORITY out nocopy varchar2,
883 p_SETTLEMENT_PRIORITY_DSP out nocopy varchar2,
884 p_PAY_ALONE out nocopy varchar2,
885 p_external_bank_account_id out nocopy number,
886 p_bank_account_num out nocopy varchar2,
887 p_bank_account_name out nocopy varchar2,
888 p_bank_branch_name out nocopy varchar2,
889 p_bank_branch_num out nocopy varchar2,
890 p_bank_name out nocopy varchar2,
891 p_bank_number out nocopy varchar2,
892 p_payment_reason_comments out nocopy varchar2, --4874297
893 p_application_id in number default 200 -- 5115632
894 );
895
896 -- Bug 5652886
897 TYPE iby_error_rec_type is RECORD
898 (error_message IBY_TRANSACTION_ERRORS_GT.error_message%TYPE,
899 transaction_id IBY_TRANSACTION_ERRORS_GT.transaction_id%TYPE);
900
901 TYPE iby_error_tab_type is TABLE OF iby_error_rec_type
902 index by BINARY_INTEGER;
903
904 procedure validate_docs_payable(p_invoice_id in number,
905 p_payment_num in number default null,
906 p_hold_flag out nocopy varchar2);
907
908
909 END AP_INVOICES_PKG;