eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AP_INVOICES_POST_PROCESS_PKG dependencies on AP_INVOICES

Line 1: PACKAGE BODY AP_INVOICES_POST_PROCESS_PKG AS

1: PACKAGE BODY AP_INVOICES_POST_PROCESS_PKG AS
2: /* $Header: apinvppb.pls 120.13.12010000.7 2010/02/10 08:58:37 asansari ship $ */
3:
4: -----------------------------------------------------------------------
5: -- Procedure create_holds

Line 17: l_invoice_amount AP_INVOICES.invoice_amount%TYPE;

13: X_calling_sequence IN varchar2)
14: IS
15: current_calling_sequence VARCHAR2(2000);
16: debug_info VARCHAR2(100);
17: l_invoice_amount AP_INVOICES.invoice_amount%TYPE;
18: l_base_amount AP_INVOICES.base_amount%TYPE;
19: l_invoice_currency_code
20: AP_INVOICES.invoice_currency_code%TYPE;
21: l_invoice_amount_limit

Line 18: l_base_amount AP_INVOICES.base_amount%TYPE;

14: IS
15: current_calling_sequence VARCHAR2(2000);
16: debug_info VARCHAR2(100);
17: l_invoice_amount AP_INVOICES.invoice_amount%TYPE;
18: l_base_amount AP_INVOICES.base_amount%TYPE;
19: l_invoice_currency_code
20: AP_INVOICES.invoice_currency_code%TYPE;
21: l_invoice_amount_limit
22: PO_VENDOR_SITES.invoice_amount_limit%TYPE;

Line 20: AP_INVOICES.invoice_currency_code%TYPE;

16: debug_info VARCHAR2(100);
17: l_invoice_amount AP_INVOICES.invoice_amount%TYPE;
18: l_base_amount AP_INVOICES.base_amount%TYPE;
19: l_invoice_currency_code
20: AP_INVOICES.invoice_currency_code%TYPE;
21: l_invoice_amount_limit
22: PO_VENDOR_SITES.invoice_amount_limit%TYPE;
23: l_base_currency_code
24: AP_SYSTEM_PARAMETERS.base_currency_code%TYPE;

Line 37: from ap_invoices_all AI,

33: AI.invoice_currency_code,
34: VS.invoice_amount_limit,
35: SP.base_currency_code,
36: nvl(VS.hold_future_payments_flag,'N')
37: from ap_invoices_all AI,
38: ap_batches_all AB,
39: ap_system_parameters_all SP,
40: po_vendor_sites VS
41: where AI.invoice_id = X_invoice_id

Line 51: 'AP_INVOICES_POST_PROCESS_PKG.create_holds<-'

47:
48: -- Update the calling sequence
49: --
50: current_calling_sequence :=
51: 'AP_INVOICES_POST_PROCESS_PKG.create_holds<-'
52: ||X_calling_sequence;
53:
54: open invoice_cursor;
55: fetch invoice_cursor

Line 170: l_terms_id AP_INVOICES.terms_id%TYPE;

166:
167: IS
168: current_calling_sequence VARCHAR2(2000);
169: debug_info VARCHAR2(1000);
170: l_terms_id AP_INVOICES.terms_id%TYPE;
171: l_created_by AP_INVOICES.created_by%TYPE;
172: l_Last_Updated_By AP_INVOICES.Last_Updated_By%TYPE;
173: l_batch_id AP_INVOICES.batch_id%TYPE;
174: l_terms_date AP_INVOICES.terms_date%TYPE;

Line 171: l_created_by AP_INVOICES.created_by%TYPE;

167: IS
168: current_calling_sequence VARCHAR2(2000);
169: debug_info VARCHAR2(1000);
170: l_terms_id AP_INVOICES.terms_id%TYPE;
171: l_created_by AP_INVOICES.created_by%TYPE;
172: l_Last_Updated_By AP_INVOICES.Last_Updated_By%TYPE;
173: l_batch_id AP_INVOICES.batch_id%TYPE;
174: l_terms_date AP_INVOICES.terms_date%TYPE;
175: l_invoice_amount AP_INVOICES.invoice_amount%TYPE;

Line 172: l_Last_Updated_By AP_INVOICES.Last_Updated_By%TYPE;

168: current_calling_sequence VARCHAR2(2000);
169: debug_info VARCHAR2(1000);
170: l_terms_id AP_INVOICES.terms_id%TYPE;
171: l_created_by AP_INVOICES.created_by%TYPE;
172: l_Last_Updated_By AP_INVOICES.Last_Updated_By%TYPE;
173: l_batch_id AP_INVOICES.batch_id%TYPE;
174: l_terms_date AP_INVOICES.terms_date%TYPE;
175: l_invoice_amount AP_INVOICES.invoice_amount%TYPE;
176: l_pay_curr_invoice_amount AP_INVOICES.invoice_amount%TYPE;

Line 173: l_batch_id AP_INVOICES.batch_id%TYPE;

169: debug_info VARCHAR2(1000);
170: l_terms_id AP_INVOICES.terms_id%TYPE;
171: l_created_by AP_INVOICES.created_by%TYPE;
172: l_Last_Updated_By AP_INVOICES.Last_Updated_By%TYPE;
173: l_batch_id AP_INVOICES.batch_id%TYPE;
174: l_terms_date AP_INVOICES.terms_date%TYPE;
175: l_invoice_amount AP_INVOICES.invoice_amount%TYPE;
176: l_pay_curr_invoice_amount AP_INVOICES.invoice_amount%TYPE;
177: l_payment_cross_rate AP_INVOICES.payment_cross_rate%TYPE;

Line 174: l_terms_date AP_INVOICES.terms_date%TYPE;

170: l_terms_id AP_INVOICES.terms_id%TYPE;
171: l_created_by AP_INVOICES.created_by%TYPE;
172: l_Last_Updated_By AP_INVOICES.Last_Updated_By%TYPE;
173: l_batch_id AP_INVOICES.batch_id%TYPE;
174: l_terms_date AP_INVOICES.terms_date%TYPE;
175: l_invoice_amount AP_INVOICES.invoice_amount%TYPE;
176: l_pay_curr_invoice_amount AP_INVOICES.invoice_amount%TYPE;
177: l_payment_cross_rate AP_INVOICES.payment_cross_rate%TYPE;
178: l_amt_applicable_to_discount

Line 175: l_invoice_amount AP_INVOICES.invoice_amount%TYPE;

171: l_created_by AP_INVOICES.created_by%TYPE;
172: l_Last_Updated_By AP_INVOICES.Last_Updated_By%TYPE;
173: l_batch_id AP_INVOICES.batch_id%TYPE;
174: l_terms_date AP_INVOICES.terms_date%TYPE;
175: l_invoice_amount AP_INVOICES.invoice_amount%TYPE;
176: l_pay_curr_invoice_amount AP_INVOICES.invoice_amount%TYPE;
177: l_payment_cross_rate AP_INVOICES.payment_cross_rate%TYPE;
178: l_amt_applicable_to_discount
179: AP_INVOICES.amount_applicable_to_discount%TYPE;

Line 176: l_pay_curr_invoice_amount AP_INVOICES.invoice_amount%TYPE;

172: l_Last_Updated_By AP_INVOICES.Last_Updated_By%TYPE;
173: l_batch_id AP_INVOICES.batch_id%TYPE;
174: l_terms_date AP_INVOICES.terms_date%TYPE;
175: l_invoice_amount AP_INVOICES.invoice_amount%TYPE;
176: l_pay_curr_invoice_amount AP_INVOICES.invoice_amount%TYPE;
177: l_payment_cross_rate AP_INVOICES.payment_cross_rate%TYPE;
178: l_amt_applicable_to_discount
179: AP_INVOICES.amount_applicable_to_discount%TYPE;
180: l_payment_method_code

Line 177: l_payment_cross_rate AP_INVOICES.payment_cross_rate%TYPE;

173: l_batch_id AP_INVOICES.batch_id%TYPE;
174: l_terms_date AP_INVOICES.terms_date%TYPE;
175: l_invoice_amount AP_INVOICES.invoice_amount%TYPE;
176: l_pay_curr_invoice_amount AP_INVOICES.invoice_amount%TYPE;
177: l_payment_cross_rate AP_INVOICES.payment_cross_rate%TYPE;
178: l_amt_applicable_to_discount
179: AP_INVOICES.amount_applicable_to_discount%TYPE;
180: l_payment_method_code
181: AP_INVOICES.payment_method_code%TYPE;

Line 179: AP_INVOICES.amount_applicable_to_discount%TYPE;

175: l_invoice_amount AP_INVOICES.invoice_amount%TYPE;
176: l_pay_curr_invoice_amount AP_INVOICES.invoice_amount%TYPE;
177: l_payment_cross_rate AP_INVOICES.payment_cross_rate%TYPE;
178: l_amt_applicable_to_discount
179: AP_INVOICES.amount_applicable_to_discount%TYPE;
180: l_payment_method_code
181: AP_INVOICES.payment_method_code%TYPE;
182: l_invoice_currency_code
183: AP_INVOICES.invoice_currency_code%TYPE;

Line 181: AP_INVOICES.payment_method_code%TYPE;

177: l_payment_cross_rate AP_INVOICES.payment_cross_rate%TYPE;
178: l_amt_applicable_to_discount
179: AP_INVOICES.amount_applicable_to_discount%TYPE;
180: l_payment_method_code
181: AP_INVOICES.payment_method_code%TYPE;
182: l_invoice_currency_code
183: AP_INVOICES.invoice_currency_code%TYPE;
184: l_payment_currency_code
185: AP_INVOICES.payment_currency_code%TYPE;

Line 183: AP_INVOICES.invoice_currency_code%TYPE;

179: AP_INVOICES.amount_applicable_to_discount%TYPE;
180: l_payment_method_code
181: AP_INVOICES.payment_method_code%TYPE;
182: l_invoice_currency_code
183: AP_INVOICES.invoice_currency_code%TYPE;
184: l_payment_currency_code
185: AP_INVOICES.payment_currency_code%TYPE;
186: l_invoice_type_lookup_code
187: AP_INVOICES.invoice_type_lookup_code%TYPE;

Line 185: AP_INVOICES.payment_currency_code%TYPE;

181: AP_INVOICES.payment_method_code%TYPE;
182: l_invoice_currency_code
183: AP_INVOICES.invoice_currency_code%TYPE;
184: l_payment_currency_code
185: AP_INVOICES.payment_currency_code%TYPE;
186: l_invoice_type_lookup_code
187: AP_INVOICES.invoice_type_lookup_code%TYPE;
188: l_batch_hold_lookup_code AP_BATCHES.hold_lookup_code%TYPE;
189: l_batch_hold_reason AP_BATCHES.hold_reason%TYPE;

Line 187: AP_INVOICES.invoice_type_lookup_code%TYPE;

183: AP_INVOICES.invoice_currency_code%TYPE;
184: l_payment_currency_code
185: AP_INVOICES.payment_currency_code%TYPE;
186: l_invoice_type_lookup_code
187: AP_INVOICES.invoice_type_lookup_code%TYPE;
188: l_batch_hold_lookup_code AP_BATCHES.hold_lookup_code%TYPE;
189: l_batch_hold_reason AP_BATCHES.hold_reason%TYPE;
190: l_vendor_id NUMBER;
191: l_vendor_site_id NUMBER;

Line 192: l_invoice_date AP_INVOICES.invoice_date%TYPE;

188: l_batch_hold_lookup_code AP_BATCHES.hold_lookup_code%TYPE;
189: l_batch_hold_reason AP_BATCHES.hold_reason%TYPE;
190: l_vendor_id NUMBER;
191: l_vendor_site_id NUMBER;
192: l_invoice_date AP_INVOICES.invoice_date%TYPE;
193: l_error_code VARCHAR2(30);
194: l_msg_data VARCHAR2(30);
195: l_msg_application VARCHAR2(25);
196: l_msg_type VARCHAR2(25);

Line 219: from ap_invoices AI,

215: AI.vendor_site_id,
216: AB.hold_lookup_code,
217: AB.hold_reason,
218: AI.invoice_date
219: from ap_invoices AI,
220: ap_batches_all AB --Bug8409056
221: where AI.invoice_id = X_invoice_id
222: and AI.batch_id = AB.batch_id (+);
223:

Line 229: 'AP_INVOICES_POST_PROCESS_PKG.insert_children<-'

225:
226: -- Update the calling sequence
227: --
228: current_calling_sequence :=
229: 'AP_INVOICES_POST_PROCESS_PKG.insert_children<-'
230: ||X_calling_sequence;
231:
232: -- Retrieve the values we need from the newly inserted
233: -- invoice so we can create the payment schedules

Line 375: FROM ap_invoices AI,

371: l_recouped_amount NUMBER; --bug8891266
372:
373: cursor liability_changed_cursor is
374: SELECT 'Y'
375: FROM ap_invoices AI,
376: financials_system_parameters FSP
377: WHERE invoice_id = X_invoice_id
378: AND (AI.accts_pay_code_combination_id <> X_accts_pay_ccid OR
379: --

Line 402: FROM ap_invoices

398: AND FSP.purch_encumbrance_flag <> 'Y';
399:
400: cursor vendor_changed_cursor is
401: SELECT 'Y'
402: FROM ap_invoices
403: WHERE vendor_id <> X_vendor_id
404: AND invoice_id = X_invoice_id;
405:
406: --bug 8891266 added cursor parameter here

Line 426: FROM ap_invoices AI

422: -- (4) payment method (new for 10SC),
423: -- (5) amount applicable to discount
424: -- (6) payment currency code (Bug9294551)
425: SELECT 'Y'
426: FROM ap_invoices AI
427: WHERE invoice_id = X_invoice_id
428: AND (AI.invoice_amount <> X_invoice_amount OR
429: AI.terms_id <> X_terms_id OR
430: AI.terms_date <> X_terms_date OR

Line 446: 'AP_INVOICES_POST_PROCESS_PKG.invoice_pre_update<-'||X_calling_sequence;

442:
443: -- Update the calling sequence
444: --
445: current_calling_sequence :=
446: 'AP_INVOICES_POST_PROCESS_PKG.invoice_pre_update<-'||X_calling_sequence;
447:
448: -- Determine whether the vendor has changed
449: open vendor_changed_cursor;
450: fetch vendor_changed_cursor into X_vendor_changed_flag;

Line 545: l_terms_id AP_INVOICES.terms_id%TYPE;

541: X_Sched_Hold_count IN OUT NOCOPY number) -- bug 5334577
542: IS
543: current_calling_sequence VARCHAR2(2000);
544: debug_info VARCHAR2(100);
545: l_terms_id AP_INVOICES.terms_id%TYPE;
546: l_created_by AP_INVOICES.created_by%TYPE;
547: l_Last_Updated_By AP_INVOICES.Last_Updated_By%TYPE;
548: l_batch_id AP_INVOICES.batch_id%TYPE;
549: l_terms_date AP_INVOICES.terms_date%TYPE;

Line 546: l_created_by AP_INVOICES.created_by%TYPE;

542: IS
543: current_calling_sequence VARCHAR2(2000);
544: debug_info VARCHAR2(100);
545: l_terms_id AP_INVOICES.terms_id%TYPE;
546: l_created_by AP_INVOICES.created_by%TYPE;
547: l_Last_Updated_By AP_INVOICES.Last_Updated_By%TYPE;
548: l_batch_id AP_INVOICES.batch_id%TYPE;
549: l_terms_date AP_INVOICES.terms_date%TYPE;
550: l_invoice_amount AP_INVOICES.invoice_amount%TYPE;

Line 547: l_Last_Updated_By AP_INVOICES.Last_Updated_By%TYPE;

543: current_calling_sequence VARCHAR2(2000);
544: debug_info VARCHAR2(100);
545: l_terms_id AP_INVOICES.terms_id%TYPE;
546: l_created_by AP_INVOICES.created_by%TYPE;
547: l_Last_Updated_By AP_INVOICES.Last_Updated_By%TYPE;
548: l_batch_id AP_INVOICES.batch_id%TYPE;
549: l_terms_date AP_INVOICES.terms_date%TYPE;
550: l_invoice_amount AP_INVOICES.invoice_amount%TYPE;
551: l_pay_curr_invoice_amount AP_INVOICES.invoice_amount%TYPE;

Line 548: l_batch_id AP_INVOICES.batch_id%TYPE;

544: debug_info VARCHAR2(100);
545: l_terms_id AP_INVOICES.terms_id%TYPE;
546: l_created_by AP_INVOICES.created_by%TYPE;
547: l_Last_Updated_By AP_INVOICES.Last_Updated_By%TYPE;
548: l_batch_id AP_INVOICES.batch_id%TYPE;
549: l_terms_date AP_INVOICES.terms_date%TYPE;
550: l_invoice_amount AP_INVOICES.invoice_amount%TYPE;
551: l_pay_curr_invoice_amount AP_INVOICES.invoice_amount%TYPE;
552: l_payment_cross_rate AP_INVOICES.payment_cross_rate%TYPE;

Line 549: l_terms_date AP_INVOICES.terms_date%TYPE;

545: l_terms_id AP_INVOICES.terms_id%TYPE;
546: l_created_by AP_INVOICES.created_by%TYPE;
547: l_Last_Updated_By AP_INVOICES.Last_Updated_By%TYPE;
548: l_batch_id AP_INVOICES.batch_id%TYPE;
549: l_terms_date AP_INVOICES.terms_date%TYPE;
550: l_invoice_amount AP_INVOICES.invoice_amount%TYPE;
551: l_pay_curr_invoice_amount AP_INVOICES.invoice_amount%TYPE;
552: l_payment_cross_rate AP_INVOICES.payment_cross_rate%TYPE;
553: l_amt_applicable_to_discount

Line 550: l_invoice_amount AP_INVOICES.invoice_amount%TYPE;

546: l_created_by AP_INVOICES.created_by%TYPE;
547: l_Last_Updated_By AP_INVOICES.Last_Updated_By%TYPE;
548: l_batch_id AP_INVOICES.batch_id%TYPE;
549: l_terms_date AP_INVOICES.terms_date%TYPE;
550: l_invoice_amount AP_INVOICES.invoice_amount%TYPE;
551: l_pay_curr_invoice_amount AP_INVOICES.invoice_amount%TYPE;
552: l_payment_cross_rate AP_INVOICES.payment_cross_rate%TYPE;
553: l_amt_applicable_to_discount
554: AP_INVOICES.amount_applicable_to_discount%TYPE;

Line 551: l_pay_curr_invoice_amount AP_INVOICES.invoice_amount%TYPE;

547: l_Last_Updated_By AP_INVOICES.Last_Updated_By%TYPE;
548: l_batch_id AP_INVOICES.batch_id%TYPE;
549: l_terms_date AP_INVOICES.terms_date%TYPE;
550: l_invoice_amount AP_INVOICES.invoice_amount%TYPE;
551: l_pay_curr_invoice_amount AP_INVOICES.invoice_amount%TYPE;
552: l_payment_cross_rate AP_INVOICES.payment_cross_rate%TYPE;
553: l_amt_applicable_to_discount
554: AP_INVOICES.amount_applicable_to_discount%TYPE;
555: l_payment_method_code

Line 552: l_payment_cross_rate AP_INVOICES.payment_cross_rate%TYPE;

548: l_batch_id AP_INVOICES.batch_id%TYPE;
549: l_terms_date AP_INVOICES.terms_date%TYPE;
550: l_invoice_amount AP_INVOICES.invoice_amount%TYPE;
551: l_pay_curr_invoice_amount AP_INVOICES.invoice_amount%TYPE;
552: l_payment_cross_rate AP_INVOICES.payment_cross_rate%TYPE;
553: l_amt_applicable_to_discount
554: AP_INVOICES.amount_applicable_to_discount%TYPE;
555: l_payment_method_code
556: AP_INVOICES.payment_method_code%TYPE;

Line 554: AP_INVOICES.amount_applicable_to_discount%TYPE;

550: l_invoice_amount AP_INVOICES.invoice_amount%TYPE;
551: l_pay_curr_invoice_amount AP_INVOICES.invoice_amount%TYPE;
552: l_payment_cross_rate AP_INVOICES.payment_cross_rate%TYPE;
553: l_amt_applicable_to_discount
554: AP_INVOICES.amount_applicable_to_discount%TYPE;
555: l_payment_method_code
556: AP_INVOICES.payment_method_code%TYPE;
557: l_invoice_currency_code
558: AP_INVOICES.invoice_currency_code%TYPE;

Line 556: AP_INVOICES.payment_method_code%TYPE;

552: l_payment_cross_rate AP_INVOICES.payment_cross_rate%TYPE;
553: l_amt_applicable_to_discount
554: AP_INVOICES.amount_applicable_to_discount%TYPE;
555: l_payment_method_code
556: AP_INVOICES.payment_method_code%TYPE;
557: l_invoice_currency_code
558: AP_INVOICES.invoice_currency_code%TYPE;
559: l_payment_currency_code
560: AP_INVOICES.payment_currency_code%TYPE;

Line 558: AP_INVOICES.invoice_currency_code%TYPE;

554: AP_INVOICES.amount_applicable_to_discount%TYPE;
555: l_payment_method_code
556: AP_INVOICES.payment_method_code%TYPE;
557: l_invoice_currency_code
558: AP_INVOICES.invoice_currency_code%TYPE;
559: l_payment_currency_code
560: AP_INVOICES.payment_currency_code%TYPE;
561:
562: -- bug 2663549 variables declared

Line 560: AP_INVOICES.payment_currency_code%TYPE;

556: AP_INVOICES.payment_method_code%TYPE;
557: l_invoice_currency_code
558: AP_INVOICES.invoice_currency_code%TYPE;
559: l_payment_currency_code
560: AP_INVOICES.payment_currency_code%TYPE;
561:
562: -- bug 2663549 variables declared
563: l_awt_amount NUMBER;
564: l_inv_amt_remaining NUMBER;

Line 586: from ap_invoices AI

582: AI.amount_applicable_to_discount,
583: AI.payment_method_code,
584: AI.invoice_currency_code,
585: AI.payment_currency_code
586: from ap_invoices AI
587: where AI.invoice_id = X_invoice_id;
588:
589: BEGIN
590:

Line 594: 'AP_INVOICES_POST_PROCESS_PKG.invoice_post_update<-'

590:
591: -- Update the calling sequence
592: --
593: current_calling_sequence :=
594: 'AP_INVOICES_POST_PROCESS_PKG.invoice_post_update<-'
595: ||X_calling_sequence;
596:
597: -- Retrieve the values we need from the recently updated
598: -- invoice so we can create the payment schedules

Line 692: UPDATE ap_invoices

688: payment_status_flag = DECODE(payment_status_flag,
689: 'Y','P',payment_status_flag)
690: WHERE invoice_id = X_invoice_id;
691:
692: UPDATE ap_invoices
693: SET payment_status_flag = DECODE(payment_status_flag,
694: 'Y','P',payment_status_flag)
695: WHERE invoice_id = X_invoice_id;
696: end if;

Line 703: l_po_number := AP_INVOICES_UTILITY_PKG.get_po_number(X_invoice_id);

699: --Bug8891266
700: l_recouped_amount := AP_MATCHING_UTILS_PKG.Get_Inv_Line_Recouped_Amount
701: (P_Invoice_Id => X_invoice_id,
702: P_Invoice_Line_Number => Null);
703: l_po_number := AP_INVOICES_UTILITY_PKG.get_po_number(X_invoice_id);
704:
705:
706: debug_info := ' l_recouped_amount : '|| l_recouped_amount ||', '||'l_po_number: '||
707: l_po_number ;

Line 785: AP_INVOICES_PKG.GET_APPROVAL_STATUS(

781: debug_info VARCHAR2(100);
782:
783: CURSOR invoice_status_cursor is
784: select
785: AP_INVOICES_PKG.GET_APPROVAL_STATUS(
786: AI.INVOICE_ID,
787: AI.INVOICE_AMOUNT,
788: AI.PAYMENT_STATUS_FLAG,
789: AI.INVOICE_TYPE_LOOKUP_CODE),

Line 790: AP_INVOICES_PKG.GET_HOLDS_COUNT(

786: AI.INVOICE_ID,
787: AI.INVOICE_AMOUNT,
788: AI.PAYMENT_STATUS_FLAG,
789: AI.INVOICE_TYPE_LOOKUP_CODE),
790: AP_INVOICES_PKG.GET_HOLDS_COUNT(
791: AI.INVOICE_ID),
792: AP_INVOICES_PKG.GET_SCHED_HOLDS_COUNT( --bug 5334577
793: AI.INVOICE_ID),
794: AP_INVOICES_PKG.GET_POSTING_STATUS(

Line 792: AP_INVOICES_PKG.GET_SCHED_HOLDS_COUNT( --bug 5334577

788: AI.PAYMENT_STATUS_FLAG,
789: AI.INVOICE_TYPE_LOOKUP_CODE),
790: AP_INVOICES_PKG.GET_HOLDS_COUNT(
791: AI.INVOICE_ID),
792: AP_INVOICES_PKG.GET_SCHED_HOLDS_COUNT( --bug 5334577
793: AI.INVOICE_ID),
794: AP_INVOICES_PKG.GET_POSTING_STATUS(
795: AI.INVOICE_ID),
796: AI.AMOUNT_PAID,

Line 794: AP_INVOICES_PKG.GET_POSTING_STATUS(

790: AP_INVOICES_PKG.GET_HOLDS_COUNT(
791: AI.INVOICE_ID),
792: AP_INVOICES_PKG.GET_SCHED_HOLDS_COUNT( --bug 5334577
793: AI.INVOICE_ID),
794: AP_INVOICES_PKG.GET_POSTING_STATUS(
795: AI.INVOICE_ID),
796: AI.AMOUNT_PAID,
797: AP_INVOICES_PKG.GET_MAX_LINE_NUMBER(
798: AI.INVOICE_ID) + 1,

Line 797: AP_INVOICES_PKG.GET_MAX_LINE_NUMBER(

793: AI.INVOICE_ID),
794: AP_INVOICES_PKG.GET_POSTING_STATUS(
795: AI.INVOICE_ID),
796: AI.AMOUNT_PAID,
797: AP_INVOICES_PKG.GET_MAX_LINE_NUMBER(
798: AI.INVOICE_ID) + 1,
799: AP_INVOICES_UTILITY_PKG.GET_LINE_TOTAL(
800: AI.INVOICE_ID),
801: decode(AB.BATCH_ID,

Line 799: AP_INVOICES_UTILITY_PKG.GET_LINE_TOTAL(

795: AI.INVOICE_ID),
796: AI.AMOUNT_PAID,
797: AP_INVOICES_PKG.GET_MAX_LINE_NUMBER(
798: AI.INVOICE_ID) + 1,
799: AP_INVOICES_UTILITY_PKG.GET_LINE_TOTAL(
800: AI.INVOICE_ID),
801: decode(AB.BATCH_ID,
802: '',null,
803: AP_BATCHES_PKG.GET_ACTUAL_INV_COUNT(

Line 809: from ap_invoices AI,

805: decode(AB.BATCH_ID,
806: '',null,
807: AP_BATCHES_PKG.GET_ACTUAL_INV_AMOUNT(
808: AB.BATCH_ID))
809: from ap_invoices AI,
810: ap_batches_all AB --Bug: 6668692 : Added _all to table name
811: where AI.invoice_id = X_invoice_id
812: and AI.batch_id = AB.batch_id (+);
813: BEGIN

Line 818: 'AP_INVOICES_POST_PROCESS_PKG.post_forms_commit<-'||X_calling_sequence;

814:
815: -- Update the calling sequence
816: --
817: current_calling_sequence :=
818: 'AP_INVOICES_POST_PROCESS_PKG.post_forms_commit<-'||X_calling_sequence;
819:
820: -- Update the invoice distributions if necessary
821: --
822: if (nvl(X_update_base,'N') = 'Y' or

Line 841: debug_info := 'Select invoice statuses from AP_INVOICES';

837:
838: -- Determine the current invoice statuses
839: --
840:
841: debug_info := 'Select invoice statuses from AP_INVOICES';
842:
843: open invoice_status_cursor;
844: fetch invoice_status_cursor into X_approval_status_lookup_code,
845: X_holds_count,

Line 902: 'AP_INVOICES_POST_PROCESS_PKG.Select_Summary<-'||X_Calling_Sequence;

898:
899: -- Update the calling sequence
900: --
901: current_calling_sequence :=
902: 'AP_INVOICES_POST_PROCESS_PKG.Select_Summary<-'||X_Calling_Sequence;
903:
904: debug_info := 'Select from AP_INVOICES';
905:
906: select sum(nvl(invoice_amount,0))

Line 904: debug_info := 'Select from AP_INVOICES';

900: --
901: current_calling_sequence :=
902: 'AP_INVOICES_POST_PROCESS_PKG.Select_Summary<-'||X_Calling_Sequence;
903:
904: debug_info := 'Select from AP_INVOICES';
905:
906: select sum(nvl(invoice_amount,0))
907: into X_Total
908: from ap_invoices

Line 908: from ap_invoices

904: debug_info := 'Select from AP_INVOICES';
905:
906: select sum(nvl(invoice_amount,0))
907: into X_Total
908: from ap_invoices
909: where Batch_ID = X_Batch_ID;
910:
911: X_Total_Rtot_DB := X_Total;
912:

Line 928: END AP_INVOICES_POST_PROCESS_PKG;

924: end if;
925: APP_EXCEPTION.RAISE_EXCEPTION;
926: END Select_Summary;
927:
928: END AP_INVOICES_POST_PROCESS_PKG;