DBA Data[Home] [Help]

APPS.IGI_APPROVAL_PKG dependencies on AP_APPROVAL_PKG

Line 70: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,

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,

Line 71: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,

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,

Line 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,

Line 76: p_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,
80: p_release_lookup_code IN OUT NOCOPY VARCHAR2,

Line 91: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,

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

Line 92: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,

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,

Line 93: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,

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,

Line 110: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,

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:

Line 111: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,

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,

Line 112: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,

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,

Line 131: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,

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:

Line 132: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,

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,

Line 133: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,

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,

Line 188: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,

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:

Line 189: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,

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,

Line 190: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,

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,

Line 196: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,

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:

Line 197: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,

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,

Line 198: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,

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,

Line 204: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,

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:

Line 205: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,

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,

Line 206: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,

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,

Line 212: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,

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:

Line 213: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,

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,

Line 214: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,

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,

Line 225: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,

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:

Line 226: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,

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:

Line 227: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,

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:

Line 234: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,

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:

Line 235: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,

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,

Line 236: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,

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,

Line 381: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,

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

Line 382: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,

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;

Line 383: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,

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;

Line 398: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,

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

Line 399: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,

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;

Line 400: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,

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;

Line 415: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,

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

Line 416: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,

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;

Line 417: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,

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;

Line 432: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,

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

Line 433: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,

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;

Line 434: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,

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;

Line 451: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,

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

Line 452: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,

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;

Line 453: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,

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;

Line 469: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,

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

Line 470: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,

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;

Line 471: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,

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;

Line 495: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,

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

Line 496: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,

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;

Line 497: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,

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;

Line 549: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,

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

Line 550: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,

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;

Line 551: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,

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;

Line 834: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,

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

Line 835: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,

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;

Line 836: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,

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;

Line 911: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,

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

Line 912: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,

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;

Line 913: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,

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;

Line 947: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,

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;

Line 948: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,

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;

Line 964: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,

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;

Line 965: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,

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;

Line 976: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,

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;

Line 977: p_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,

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;

Line 1016: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,

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

Line 1017: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,

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;

Line 1018: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,

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;