66: p_line_location_id IN NUMBER,
67: p_rcv_transaction_id IN NUMBER,
68: p_hold_lookup_code IN VARCHAR2,
69: p_hold_reason IN VARCHAR2,
70: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,
71: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
72: p_calling_sequence IN VARCHAR2);
73:
74: PROCEDURE Count_Hold(p_hold_lookup_code IN VARCHAR2,
67: p_rcv_transaction_id IN NUMBER,
68: p_hold_lookup_code IN VARCHAR2,
69: p_hold_reason IN VARCHAR2,
70: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,
71: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
72: p_calling_sequence IN VARCHAR2);
73:
74: PROCEDURE Count_Hold(p_hold_lookup_code IN VARCHAR2,
75: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,
71: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
72: p_calling_sequence IN VARCHAR2);
73:
74: PROCEDURE Count_Hold(p_hold_lookup_code IN VARCHAR2,
75: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,
76: p_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
77: p_calling_sequence IN VARCHAR2);
78:
79: PROCEDURE Get_Release_Lookup_For_Hold(p_hold_lookup_code IN VARCHAR2,
72: p_calling_sequence IN VARCHAR2);
73:
74: PROCEDURE Count_Hold(p_hold_lookup_code IN VARCHAR2,
75: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,
76: p_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
77: p_calling_sequence IN VARCHAR2);
78:
79: PROCEDURE Get_Release_Lookup_For_Hold(p_hold_lookup_code IN VARCHAR2,
80: p_release_lookup_code IN OUT NOCOPY VARCHAR2,
87: p_program_application_id IN NUMBER,
88: p_program_id IN NUMBER,
89: p_request_id IN NUMBER,
90: p_system_user IN NUMBER,
91: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,
92: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
93: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
94: p_calling_sequence IN VARCHAR2);
95: --shelley
88: p_program_id IN NUMBER,
89: p_request_id IN NUMBER,
90: p_system_user IN NUMBER,
91: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,
92: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
93: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
94: p_calling_sequence IN VARCHAR2);
95: --shelley
96: PROCEDURE Manual_Withhold_Tax(p_invoice_id IN NUMBER,
89: p_request_id IN NUMBER,
90: p_system_user IN NUMBER,
91: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,
92: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
93: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
94: p_calling_sequence IN VARCHAR2);
95: --shelley
96: PROCEDURE Manual_Withhold_Tax(p_invoice_id IN NUMBER,
97: p_last_updated_by IN NUMBER,
106: p_tax_rounding_rule IN VARCHAR2,
107: p_auto_tax_calc_flag IN VARCHAR2,
108: p_match_on_tax_flag IN VARCHAR2,
109: p_enforce_tax_on_acct IN VARCHAR2,
110: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,
111: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
112: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
113: p_calling_sequence IN OUT NOCOPY VARCHAR2);
114:
107: p_auto_tax_calc_flag IN VARCHAR2,
108: p_match_on_tax_flag IN VARCHAR2,
109: p_enforce_tax_on_acct IN VARCHAR2,
110: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,
111: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
112: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
113: p_calling_sequence IN OUT NOCOPY VARCHAR2);
114:
115: PROCEDURE Calculate_Tax_Variance(p_invoice_id IN NUMBER,
108: p_match_on_tax_flag IN VARCHAR2,
109: p_enforce_tax_on_acct IN VARCHAR2,
110: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,
111: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
112: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
113: p_calling_sequence IN OUT NOCOPY VARCHAR2);
114:
115: PROCEDURE Calculate_Tax_Variance(p_invoice_id IN NUMBER,
116: p_invoice_currency_code IN VARCHAR2,
127: p_enforce_tax_on_acct IN VARCHAR2,
128: p_acct_tax_difference IN OUT NOCOPY VARCHAR2,
129: p_match_tax_difference IN OUT NOCOPY VARCHAR2,
130: p_system_user IN NUMBER,
131: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,
132: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
133: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
134: p_calling_sequence IN VARCHAR2);
135:
128: p_acct_tax_difference IN OUT NOCOPY VARCHAR2,
129: p_match_tax_difference IN OUT NOCOPY VARCHAR2,
130: p_system_user IN NUMBER,
131: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,
132: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
133: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
134: p_calling_sequence IN VARCHAR2);
135:
136: PROCEDURE Check_Header_Lvl_Tax_Incl_Excl(p_calc_inclusive IN VARCHAR2,
129: p_match_tax_difference IN OUT NOCOPY VARCHAR2,
130: p_system_user IN NUMBER,
131: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,
132: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
133: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
134: p_calling_sequence IN VARCHAR2);
135:
136: PROCEDURE Check_Header_Lvl_Tax_Incl_Excl(p_calc_inclusive IN VARCHAR2,
137: p_invoice_id IN NUMBER,
184: p_invoice_currency_code IN VARCHAR2,
185: p_invoice_amount_limit IN NUMBER,
186: p_hold_future_payments_flag IN VARCHAR2,
187: p_system_user IN NUMBER,
188: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,
189: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
190: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
191: p_calling_sequence IN VARCHAR2);
192:
185: p_invoice_amount_limit IN NUMBER,
186: p_hold_future_payments_flag IN VARCHAR2,
187: p_system_user IN NUMBER,
188: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,
189: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
190: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
191: p_calling_sequence IN VARCHAR2);
192:
193: PROCEDURE Check_Future_Period(p_invoice_id IN NUMBER,
186: p_hold_future_payments_flag IN VARCHAR2,
187: p_system_user IN NUMBER,
188: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,
189: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
190: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
191: p_calling_sequence IN VARCHAR2);
192:
193: PROCEDURE Check_Future_Period(p_invoice_id IN NUMBER,
194: p_set_of_books_id IN NUMBER,
192:
193: PROCEDURE Check_Future_Period(p_invoice_id IN NUMBER,
194: p_set_of_books_id IN NUMBER,
195: p_system_user IN NUMBER,
196: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,
197: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
198: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
199: p_calling_sequence IN VARCHAR2);
200:
193: PROCEDURE Check_Future_Period(p_invoice_id IN NUMBER,
194: p_set_of_books_id IN NUMBER,
195: p_system_user IN NUMBER,
196: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,
197: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
198: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
199: p_calling_sequence IN VARCHAR2);
200:
201: PROCEDURE Check_Dist_Variance(p_invoice_id IN NUMBER,
194: p_set_of_books_id IN NUMBER,
195: p_system_user IN NUMBER,
196: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,
197: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
198: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
199: p_calling_sequence IN VARCHAR2);
200:
201: PROCEDURE Check_Dist_Variance(p_invoice_id IN NUMBER,
202: p_base_currency_code IN VARCHAR2,
200:
201: PROCEDURE Check_Dist_Variance(p_invoice_id IN NUMBER,
202: p_base_currency_code IN VARCHAR2,
203: p_system_user IN NUMBER,
204: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,
205: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
206: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
207: p_calling_sequence IN VARCHAR2);
208:
201: PROCEDURE Check_Dist_Variance(p_invoice_id IN NUMBER,
202: p_base_currency_code IN VARCHAR2,
203: p_system_user IN NUMBER,
204: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,
205: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
206: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
207: p_calling_sequence IN VARCHAR2);
208:
209: PROCEDURE Check_No_Rate(p_invoice_id IN NUMBER,
202: p_base_currency_code IN VARCHAR2,
203: p_system_user IN NUMBER,
204: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,
205: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
206: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
207: p_calling_sequence IN VARCHAR2);
208:
209: PROCEDURE Check_No_Rate(p_invoice_id IN NUMBER,
210: p_base_currency_code IN VARCHAR2,
208:
209: PROCEDURE Check_No_Rate(p_invoice_id IN NUMBER,
210: p_base_currency_code IN VARCHAR2,
211: p_system_user IN NUMBER,
212: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,
213: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
214: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
215: p_calling_sequence IN VARCHAR2);
216:
209: PROCEDURE Check_No_Rate(p_invoice_id IN NUMBER,
210: p_base_currency_code IN VARCHAR2,
211: p_system_user IN NUMBER,
212: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,
213: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
214: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
215: p_calling_sequence IN VARCHAR2);
216:
217: PROCEDURE Check_invoice_vendor(p_invoice_id IN NUMBER,
210: p_base_currency_code IN VARCHAR2,
211: p_system_user IN NUMBER,
212: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,
213: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
214: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
215: p_calling_sequence IN VARCHAR2);
216:
217: PROCEDURE Check_invoice_vendor(p_invoice_id IN NUMBER,
218: p_base_currency_code IN VARCHAR2,
221: p_invoice_currency_code IN VARCHAR2,
222: p_invoice_amount_limit IN NUMBER,
223: p_hold_future_payments_flag IN VARCHAR2,
224: p_system_user IN NUMBER,
225: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,
226: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
227: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
228: p_calling_sequence IN VARCHAR2);
229:
222: p_invoice_amount_limit IN NUMBER,
223: p_hold_future_payments_flag IN VARCHAR2,
224: p_system_user IN NUMBER,
225: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,
226: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
227: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
228: p_calling_sequence IN VARCHAR2);
229:
230:
223: p_hold_future_payments_flag IN VARCHAR2,
224: p_system_user IN NUMBER,
225: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,
226: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
227: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
228: p_calling_sequence IN VARCHAR2);
229:
230:
231:
230:
231:
232: PROCEDURE Check_Invalid_Dist_Acct(p_invoice_id IN NUMBER,
233: p_system_user IN NUMBER,
234: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,
235: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
236: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
237: p_calling_sequence IN VARCHAR2);
238:
231:
232: PROCEDURE Check_Invalid_Dist_Acct(p_invoice_id IN NUMBER,
233: p_system_user IN NUMBER,
234: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,
235: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
236: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
237: p_calling_sequence IN VARCHAR2);
238:
239: PROCEDURE Approve(p_run_option IN VARCHAR2,
232: PROCEDURE Check_Invalid_Dist_Acct(p_invoice_id IN NUMBER,
233: p_system_user IN NUMBER,
234: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,
235: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
236: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
237: p_calling_sequence IN VARCHAR2);
238:
239: PROCEDURE Approve(p_run_option IN VARCHAR2,
240: p_invoice_batch_id IN NUMBER,
377: p_invoice_currency_code IN VARCHAR2,
378: p_invoice_amount_limit IN NUMBER,
379: p_hold_future_payments_flag IN VARCHAR2,
380: p_system_user IN NUMBER,
381: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,
382: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
383: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
384: p_calling_sequence IN VARCHAR2) IS
385: BEGIN
378: p_invoice_amount_limit IN NUMBER,
379: p_hold_future_payments_flag IN VARCHAR2,
380: p_system_user IN NUMBER,
381: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,
382: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
383: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
384: p_calling_sequence IN VARCHAR2) IS
385: BEGIN
386: NULL;
379: p_hold_future_payments_flag IN VARCHAR2,
380: p_system_user IN NUMBER,
381: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,
382: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
383: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
384: p_calling_sequence IN VARCHAR2) IS
385: BEGIN
386: NULL;
387: END Execute_General_Checks;
394: -- the condition.
395: --============================================================================
396: PROCEDURE Check_Invalid_Dist_Acct(p_invoice_id IN NUMBER,
397: p_system_user IN NUMBER,
398: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,
399: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
400: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
401: p_calling_sequence IN VARCHAR2)IS
402: BEGIN
395: --============================================================================
396: PROCEDURE Check_Invalid_Dist_Acct(p_invoice_id IN NUMBER,
397: p_system_user IN NUMBER,
398: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,
399: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
400: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
401: p_calling_sequence IN VARCHAR2)IS
402: BEGIN
403: NULL;
396: PROCEDURE Check_Invalid_Dist_Acct(p_invoice_id IN NUMBER,
397: p_system_user IN NUMBER,
398: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,
399: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
400: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
401: p_calling_sequence IN VARCHAR2)IS
402: BEGIN
403: NULL;
404: END Check_Invalid_Dist_Acct;
411: --============================================================================
412:
413: PROCEDURE Check_PO_Required(p_invoice_id IN NUMBER,
414: p_system_user IN NUMBER,
415: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,
416: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
417: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
418: p_calling_sequence IN VARCHAR2)IS
419: BEGIN
412:
413: PROCEDURE Check_PO_Required(p_invoice_id IN NUMBER,
414: p_system_user IN NUMBER,
415: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,
416: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
417: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
418: p_calling_sequence IN VARCHAR2)IS
419: BEGIN
420: NULL;
413: PROCEDURE Check_PO_Required(p_invoice_id IN NUMBER,
414: p_system_user IN NUMBER,
415: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,
416: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
417: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
418: p_calling_sequence IN VARCHAR2)IS
419: BEGIN
420: NULL;
421: END Check_PO_Required;
428: --============================================================================
429: PROCEDURE Check_No_Rate(p_invoice_id IN NUMBER,
430: p_base_currency_code IN VARCHAR2,
431: p_system_user IN NUMBER,
432: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,
433: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
434: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
435: p_calling_sequence IN VARCHAR2)IS
436: BEGIN
429: PROCEDURE Check_No_Rate(p_invoice_id IN NUMBER,
430: p_base_currency_code IN VARCHAR2,
431: p_system_user IN NUMBER,
432: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,
433: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
434: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
435: p_calling_sequence IN VARCHAR2)IS
436: BEGIN
437: NULL;
430: p_base_currency_code IN VARCHAR2,
431: p_system_user IN NUMBER,
432: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,
433: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
434: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
435: p_calling_sequence IN VARCHAR2)IS
436: BEGIN
437: NULL;
438: END Check_No_Rate;
447:
448: PROCEDURE Check_Dist_Variance(p_invoice_id IN NUMBER,
449: p_base_currency_code IN VARCHAR2,
450: p_system_user IN NUMBER,
451: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,
452: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
453: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
454: p_calling_sequence IN VARCHAR2)IS
455: BEGIN
448: PROCEDURE Check_Dist_Variance(p_invoice_id IN NUMBER,
449: p_base_currency_code IN VARCHAR2,
450: p_system_user IN NUMBER,
451: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,
452: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
453: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
454: p_calling_sequence IN VARCHAR2)IS
455: BEGIN
456: NULL;
449: p_base_currency_code IN VARCHAR2,
450: p_system_user IN NUMBER,
451: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,
452: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
453: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
454: p_calling_sequence IN VARCHAR2)IS
455: BEGIN
456: NULL;
457: END Check_Dist_Variance;
465: --============================================================================
466: PROCEDURE Check_Future_Period(p_invoice_id IN NUMBER,
467: p_set_of_books_id IN NUMBER,
468: p_system_user IN NUMBER,
469: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,
470: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
471: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
472: p_calling_sequence IN VARCHAR2)IS
473: BEGIN
466: PROCEDURE Check_Future_Period(p_invoice_id IN NUMBER,
467: p_set_of_books_id IN NUMBER,
468: p_system_user IN NUMBER,
469: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,
470: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
471: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
472: p_calling_sequence IN VARCHAR2)IS
473: BEGIN
474: NULL;
467: p_set_of_books_id IN NUMBER,
468: p_system_user IN NUMBER,
469: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,
470: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
471: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
472: p_calling_sequence IN VARCHAR2)IS
473: BEGIN
474: NULL;
475: END Check_Future_Period;
491: p_invoice_currency_code IN VARCHAR2,
492: p_invoice_amount_limit IN NUMBER,
493: p_hold_future_payments_flag IN VARCHAR2,
494: p_system_user IN NUMBER,
495: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,
496: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
497: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
498: p_calling_sequence IN VARCHAR2)IS
499: BEGIN
492: p_invoice_amount_limit IN NUMBER,
493: p_hold_future_payments_flag IN VARCHAR2,
494: p_system_user IN NUMBER,
495: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,
496: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
497: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
498: p_calling_sequence IN VARCHAR2)IS
499: BEGIN
500: NULL;
493: p_hold_future_payments_flag IN VARCHAR2,
494: p_system_user IN NUMBER,
495: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,
496: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
497: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
498: p_calling_sequence IN VARCHAR2)IS
499: BEGIN
500: NULL;
501: END Check_invoice_vendor;
545: p_tax_rounding_rule IN VARCHAR2,
546: p_auto_tax_calc_flag IN VARCHAR2,
547: p_match_on_tax_flag IN VARCHAR2,
548: p_enforce_tax_on_acct IN VARCHAR2,
549: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,
550: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
551: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
552: p_calling_sequence IN OUT NOCOPY VARCHAR2)IS
553: BEGIN
546: p_auto_tax_calc_flag IN VARCHAR2,
547: p_match_on_tax_flag IN VARCHAR2,
548: p_enforce_tax_on_acct IN VARCHAR2,
549: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,
550: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
551: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
552: p_calling_sequence IN OUT NOCOPY VARCHAR2)IS
553: BEGIN
554: NULL;
547: p_match_on_tax_flag IN VARCHAR2,
548: p_enforce_tax_on_acct IN VARCHAR2,
549: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,
550: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
551: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
552: p_calling_sequence IN OUT NOCOPY VARCHAR2)IS
553: BEGIN
554: NULL;
555: END Execute_Tax_Checks;
830: p_program_application_id IN NUMBER,
831: p_program_id IN NUMBER,
832: p_request_id IN NUMBER,
833: p_system_user IN NUMBER,
834: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,
835: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
836: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
837: p_calling_sequence IN VARCHAR2) IS
838: BEGIN
831: p_program_id IN NUMBER,
832: p_request_id IN NUMBER,
833: p_system_user IN NUMBER,
834: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,
835: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
836: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
837: p_calling_sequence IN VARCHAR2) IS
838: BEGIN
839: NULL;
832: p_request_id IN NUMBER,
833: p_system_user IN NUMBER,
834: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,
835: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
836: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
837: p_calling_sequence IN VARCHAR2) IS
838: BEGIN
839: NULL;
840: END Withhold_Tax_On;
907: p_hold_lookup_code IN VARCHAR2,
908: p_should_have_hold IN VARCHAR2,
909: p_hold_reason IN VARCHAR2,
910: p_system_user IN NUMBER,
911: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,
912: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
913: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
914: p_calling_sequence IN VARCHAR2)IS
915: BEGIN
908: p_should_have_hold IN VARCHAR2,
909: p_hold_reason IN VARCHAR2,
910: p_system_user IN NUMBER,
911: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,
912: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
913: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
914: p_calling_sequence IN VARCHAR2)IS
915: BEGIN
916: NULL;
909: p_hold_reason IN VARCHAR2,
910: p_system_user IN NUMBER,
911: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,
912: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
913: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
914: p_calling_sequence IN VARCHAR2)IS
915: BEGIN
916: NULL;
917: END Process_Inv_Hold_Status;
943: PROCEDURE Release_Hold(p_invoice_id IN NUMBER,
944: p_line_location_id IN NUMBER,
945: p_rcv_transaction_id IN NUMBER,
946: p_hold_lookup_code IN VARCHAR2,
947: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,
948: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
949: p_calling_sequence IN VARCHAR2) IS
950: BEGIN
951: NULL;
944: p_line_location_id IN NUMBER,
945: p_rcv_transaction_id IN NUMBER,
946: p_hold_lookup_code IN VARCHAR2,
947: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,
948: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
949: p_calling_sequence IN VARCHAR2) IS
950: BEGIN
951: NULL;
952: END Release_Hold;
960: p_line_location_id IN NUMBER,
961: p_rcv_transaction_id IN NUMBER,
962: p_hold_lookup_code IN VARCHAR2,
963: p_hold_reason IN VARCHAR2,
964: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,
965: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
966: p_calling_sequence IN VARCHAR2) IS
967: BEGIN
968: NULL;
961: p_rcv_transaction_id IN NUMBER,
962: p_hold_lookup_code IN VARCHAR2,
963: p_hold_reason IN VARCHAR2,
964: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,
965: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
966: p_calling_sequence IN VARCHAR2) IS
967: BEGIN
968: NULL;
969: END Set_Hold;
972: -- COUNT_HOLD: Procedure given the hold_array and count_array, increments the
973: -- the count for a given hold.
974: --============================================================================
975: PROCEDURE Count_Hold(p_hold_lookup_code IN VARCHAR2,
976: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,
977: p_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
978: p_calling_sequence IN VARCHAR2) IS
979: BEGIN
980: NULL;
973: -- the count for a given hold.
974: --============================================================================
975: PROCEDURE Count_Hold(p_hold_lookup_code IN VARCHAR2,
976: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,
977: p_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
978: p_calling_sequence IN VARCHAR2) IS
979: BEGIN
980: NULL;
981: END Count_Hold;
1012: p_enforce_tax_on_acct IN VARCHAR2,
1013: p_acct_tax_difference IN OUT NOCOPY VARCHAR2,
1014: p_match_tax_difference IN OUT NOCOPY VARCHAR2,
1015: p_system_user IN NUMBER,
1016: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,
1017: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
1018: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
1019: p_calling_sequence IN VARCHAR2) IS
1020: BEGIN
1013: p_acct_tax_difference IN OUT NOCOPY VARCHAR2,
1014: p_match_tax_difference IN OUT NOCOPY VARCHAR2,
1015: p_system_user IN NUMBER,
1016: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,
1017: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
1018: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
1019: p_calling_sequence IN VARCHAR2) IS
1020: BEGIN
1021: NULL;
1014: p_match_tax_difference IN OUT NOCOPY VARCHAR2,
1015: p_system_user IN NUMBER,
1016: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,
1017: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
1018: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
1019: p_calling_sequence IN VARCHAR2) IS
1020: BEGIN
1021: NULL;
1022: END Verify_Tax_Code;