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_UTILITY_PKG dependencies on AP_INVOICES

Line 1: PACKAGE BODY AP_INVOICES_UTILITY_PKG AS

1: PACKAGE BODY AP_INVOICES_UTILITY_PKG AS
2: /* $Header: apinvutb.pls 120.56.12010000.5 2008/11/14 12:49:04 sbonala ship $ */
3:
4: /*=============================================================================
5: | FUNCTION - get_prepay_number

Line 26: FROM ap_invoices

22: l_prepay_number VARCHAR2(50);
23:
24: CURSOR c_prepay_number IS
25: SELECT invoice_num
26: FROM ap_invoices
27: WHERE invoice_id =
28: (SELECT invoice_id
29: FROM ap_invoice_distributions
30: WHERE invoice_distribution_id = l_prepay_dist_id);

Line 236: FROM ap_invoices_all ai,

232: SELECT nvl(sob.sla_ledger_cash_basis_flag, 'N'),
233: asp.org_id
234: INTO l_cash_basis_flag,
235: l_org_id
236: FROM ap_invoices_all ai,
237: ap_system_parameters_all asp,
238: gl_sets_of_books sob
239: WHERE ai.invoice_id = l_invoice_id
240: AND ai.org_id = asp.org_id

Line 325: current_calling_sequence := 'AP_INVOICES_UTILITY_PKG.CHECK_UNIQUE<-'||

321: debug_info VARCHAR2(100);
322:
323: BEGIN
324:
325: current_calling_sequence := 'AP_INVOICES_UTILITY_PKG.CHECK_UNIQUE<-'||
326: X_calling_sequence;
327:
328: debug_info := 'Count for same vendor_id and invoice_num';
329:

Line 332: from ap_invoices_all

328: debug_info := 'Count for same vendor_id and invoice_num';
329:
330: select count(1)
331: into dummy_a
332: from ap_invoices_all
333: where invoice_num = X_INVOICE_NUM
334: and vendor_id = X_VENDOR_ID
335: and org_id = X_ORG_ID -- Bug 5407785
336: and ((X_ROWID is null) or (rowid <> X_ROWID));

Line 400: current_calling_sequence := 'AP_INVOICES_PKG.CHECK_UNIQUE_VOUCHER_NUM<-'

396: debug_info VARCHAR2(100);
397:
398: BEGIN
399:
400: current_calling_sequence := 'AP_INVOICES_PKG.CHECK_UNIQUE_VOUCHER_NUM<-'
401: || X_calling_sequence;
402:
403: debug_info := 'Count other invoices with same voucher num';
404:

Line 407: from ap_invoices

403: debug_info := 'Count other invoices with same voucher num';
404:
405: select count(1)
406: into dummy
407: from ap_invoices
408: where voucher_num = X_VOUCHER_NUM
409: and ((X_ROWID is null) or (rowid <> X_ROWID));
410:
411: IF (dummy >= 1) THEN

Line 505: -- MOAC. Included select from ap_invoices_all to get the org_id from

501: BEGIN
502:
503: ---------------------------------------------------------------------
504: -- Get the encumbrance flag
505: -- MOAC. Included select from ap_invoices_all to get the org_id from
506: -- the invoice_id since it is unique
507:
508:
509: SELECT NVL(fsp.purch_encumbrance_flag,'N'),

Line 515: FROM ap_invoices_all ai,

511: ai.force_revalidation_flag
512: INTO encumbrance_flag,
513: l_org_id,
514: l_force_revalidation_flag
515: FROM ap_invoices_all ai,
516: financials_system_params_all fsp
517: WHERE ai.invoice_id = l_invoice_id
518: AND ai.set_of_books_id = fsp.set_of_books_id
519: AND ai.org_id = fsp.org_id;

Line 549: FROM ap_invoices_all ai

545: -- If invoice is cancelled, return 'CANCELLED'.
546: --
547: SELECT ai.cancelled_date
548: INTO cancelled_date
549: FROM ap_invoices_all ai
550: WHERE ai.invoice_id = l_invoice_id;
551:
552: IF (cancelled_date IS NOT NULL) THEN
553: RETURN('CANCELLED');

Line 762: FROM ap_invoice_lines_all AIL, ap_invoices_all A

758: BEGIN
759:
760: SELECT 'N'
761: INTO invoice_approval_flag
762: FROM ap_invoice_lines_all AIL, ap_invoices_all A
763: WHERE AIL.invoice_id = A.invoice_id
764: AND AIL.invoice_id = l_invoice_id
765: AND ((AIL.line_type_lookup_code <> 'TAX'
766: and (AIL.line_type_lookup_code NOT IN ('AWT','PREPAY')

Line 877: if (AP_INVOICES_UTILITY_PKG.get_prepay_amount_remaining(l_invoice_id) = 0) then

873: if (NVL(l_payment_status_flag , 'N') <> 'Y') then --bug6598052
874: invoice_approval_status := 'UNPAID';
875: else
876: -- This prepayment is paid
877: if (AP_INVOICES_UTILITY_PKG.get_prepay_amount_remaining(l_invoice_id) = 0) then
878: invoice_approval_status := 'FULL';
879: elsif (AP_INVOICES_UTILITY_PKG.get_prepayment_type(l_invoice_id) = 'PERMANENT') THEN
880: invoice_approval_status := 'PERMANENT';
881: else

Line 879: elsif (AP_INVOICES_UTILITY_PKG.get_prepayment_type(l_invoice_id) = 'PERMANENT') THEN

875: else
876: -- This prepayment is paid
877: if (AP_INVOICES_UTILITY_PKG.get_prepay_amount_remaining(l_invoice_id) = 0) then
878: invoice_approval_status := 'FULL';
879: elsif (AP_INVOICES_UTILITY_PKG.get_prepayment_type(l_invoice_id) = 'PERMANENT') THEN
880: invoice_approval_status := 'PERMANENT';
881: else
882: invoice_approval_status := 'AVAILABLE';
883: end if; -- end of check AP_INVOICES_UTILITY_PKG call

Line 883: end if; -- end of check AP_INVOICES_UTILITY_PKG call

879: elsif (AP_INVOICES_UTILITY_PKG.get_prepayment_type(l_invoice_id) = 'PERMANENT') THEN
880: invoice_approval_status := 'PERMANENT';
881: else
882: invoice_approval_status := 'AVAILABLE';
883: end if; -- end of check AP_INVOICES_UTILITY_PKG call
884: end if; -- end of check l_payment_status_flag
885: elsif (invoice_approval_status = 'NEVER APPROVED') then
886: -- This prepayment in unapproved
887: invoice_approval_status := 'UNAPPROVED';

Line 1292: WHERE table_name = 'AP_INVOICES'

1288:
1289: SELECT COUNT(*)
1290: INTO notes_count
1291: FROM po_note_references
1292: WHERE table_name = 'AP_INVOICES'
1293: AND foreign_id = l_invoice_id;
1294:
1295: return(notes_count);
1296:

Line 1389: FROM ap_invoices ai

1385: BEGIN
1386:
1387: SELECT COUNT(*)
1388: INTO prepay_count
1389: FROM ap_invoices ai
1390: WHERE vendor_id = l_vendor_id
1391: AND (( l_org_id IS NOT NULL AND
1392: ai.org_id = l_org_id)
1393: OR l_org_id IS NULL)

Line 1396: AND AP_INVOICES_UTILITY_PKG.get_prepay_amount_remaining(ai.invoice_id) > 0;

1392: ai.org_id = l_org_id)
1393: OR l_org_id IS NULL)
1394: AND invoice_type_lookup_code = 'PREPAYMENT'
1395: AND earliest_settlement_date IS NOT NULL
1396: AND AP_INVOICES_UTILITY_PKG.get_prepay_amount_remaining(ai.invoice_id) > 0;
1397:
1398: RETURN(prepay_count);
1399:
1400: END get_total_prepays;

Line 1437: ap_invoices

1433: as a filter is removed and logic is implemented here as this would reduce the wait time*/
1434: CURSOR prepayment_invoices IS
1435: SELECT earliest_settlement_date,invoice_id
1436: from
1437: ap_invoices
1438: where vendor_id=l_vendor_id
1439: and invoice_type_lookup_code='PREPAYMENT'
1440: /*7015402*/
1441: and payment_status_flag = 'Y'

Line 1454: AP_INVOICES_UTILITY_PKG.get_prepay_amount_remaining(i.invoice_id);

1450: loop
1451: if(i.earliest_settlement_date<=(sysdate)) then
1452: l_prepay_amount_remaining:=0;
1453: l_prepay_amount_remaining:=
1454: AP_INVOICES_UTILITY_PKG.get_prepay_amount_remaining(i.invoice_id);
1455: if(l_prepay_amount_remaining>0) then
1456: prepay_count:=prepay_count+1;
1457: end if;
1458: end if;

Line 1527: FROM ap_invoices_all ai,

1523: BEGIN
1524:
1525: SELECT NVL(fsp.purch_encumbrance_flag,'N'), ai.org_id
1526: INTO l_purch_encumbrance_flag, l_org_id
1527: FROM ap_invoices_all ai,
1528: financials_system_params_all fsp
1529: WHERE ai.invoice_id = l_invoice_id
1530: AND ai.org_id = fsp.org_id;
1531:

Line 1688: FROM ap_invoices

1684: P_calling_sequence IN varchar2) RETURN varchar2
1685: IS
1686: CURSOR similar_memo_cursor IS
1687: SELECT invoice_num
1688: FROM ap_invoices
1689: WHERE vendor_id = P_vendor_id
1690: AND vendor_site_id = P_vendor_site_id
1691: AND invoice_amount = P_invoice_amount
1692: AND invoice_currency_code = P_invoice_currency_code

Line 1698: l_invoice_num ap_invoices.invoice_num%TYPE;

1694: DECODE(P_invoice_type_lookup_code,
1695: 'CREDIT','DEBIT',
1696: 'DEBIT','CREDIT');
1697:
1698: l_invoice_num ap_invoices.invoice_num%TYPE;
1699: current_calling_sequence VARCHAR2(2000);
1700: debug_info VARCHAR2(100);
1701:
1702: BEGIN

Line 1704: current_calling_sequence := 'AP_INVOICES_PKG.get_similar_drcr_memo<-'||

1700: debug_info VARCHAR2(100);
1701:
1702: BEGIN
1703:
1704: current_calling_sequence := 'AP_INVOICES_PKG.get_similar_drcr_memo<-'||
1705: P_calling_sequence;
1706:
1707: debug_info := 'Open cursor similar_memo_cursor';
1708:

Line 1766: current_calling_sequence := 'AP_INVOICES_Utility_PKG.eft_bank_details_exist<-'||

1762: debug_info VARCHAR2(100);
1763:
1764: BEGIN
1765:
1766: current_calling_sequence := 'AP_INVOICES_Utility_PKG.eft_bank_details_exist<-'||
1767: P_calling_sequence;
1768:
1769: debug_info := 'Call AP IBY API';
1770:

Line 1782: x_calling_sequence => 'Ap_Invoices_Utility_Pkg');

1778: x_vendor_site_id => p_vendor_site_id,
1779: x_payment_function => NULL,
1780: x_org_id => NULL,
1781: x_currency_code => NULL,
1782: x_calling_sequence => 'Ap_Invoices_Utility_Pkg');
1783:
1784: IF l_ext_bank_acct_id IS NOT NULL THEN
1785: RETURN True;
1786: ELSE

Line 1833: current_calling_sequence := 'AP_INVOICES_Utility_PKG.eft_bank_details_exist<-'||

1829: debug_info VARCHAR2(100);
1830:
1831: BEGIN
1832:
1833: current_calling_sequence := 'AP_INVOICES_Utility_PKG.eft_bank_details_exist<-'||
1834: P_calling_sequence;
1835:
1836: debug_info := 'Call AP IBY API';
1837:

Line 1849: x_calling_sequence => 'Ap_Invoices_Utility_Pkg');

1845: x_vendor_site_id => p_vendor_site_id,
1846: x_payment_function => NULL,
1847: x_org_id => NULL,
1848: x_currency_code => NULL,
1849: x_calling_sequence => 'Ap_Invoices_Utility_Pkg');
1850:
1851: IF l_ext_bank_acct_id IS NOT NULL THEN
1852: RETURN True;
1853: ELSE

Line 2021: IF ( sign (AP_INVOICES_UTILITY_PKG.get_prepay_amount_applied(

2017: IS
2018: l_flag varchar2(1) := 'N';
2019: BEGIN
2020:
2021: IF ( sign (AP_INVOICES_UTILITY_PKG.get_prepay_amount_applied(
2022: P_invoice_id)) = 1 ) THEN
2023: l_flag := 'Y';
2024: ELSE
2025: l_flag := null;

Line 2145: FROM ap_invoice_distributions_all aid,ap_invoices_all ai

2141: IS
2142: l_prepay_amount_remaining number:=0;
2143: cursor c_prepay_amount_remaining IS
2144: SELECT SUM(nvl(prepay_amount_remaining,amount))
2145: FROM ap_invoice_distributions_all aid,ap_invoices_all ai
2146: WHERE aid.invoice_id = P_invoice_id
2147: AND aid.line_type_lookup_code IN ('ITEM','TAX')
2148: AND nvl(aid.reversal_flag,'N') <> 'Y'
2149: AND ai.invoice_id = P_invoice_id

Line 2184: FROM ap_invoices_all ai

2180: l_prepayment_type VARCHAR2(9);
2181:
2182: CURSOR c_prepayment_type IS
2183: SELECT decode(AI.EARLIEST_SETTLEMENT_DATE,null,'PERMANENT','TEMPORARY')
2184: FROM ap_invoices_all ai
2185: WHERE ai.invoice_id = P_invoice_id;
2186: BEGIN
2187:
2188: OPEN c_prepayment_type;

Line 2556: | reports table as well as in ap invoices or only in ap invoices

Line 2563: | information from ap invoices. This was added based on the requirement

Line 2719: l_base_amount ap_invoices.base_amount%TYPE;

2715: RETURN BOOLEAN IS
2716: l_rounded_amt NUMBER := 0;
2717: l_rounded_line_numbers inv_line_num_tab_type;
2718: l_base_currency_code ap_system_parameters.base_currency_code%TYPE;
2719: l_base_amount ap_invoices.base_amount%TYPE;
2720: l_invoice_amount ap_invoices.invoice_amount%TYPE;
2721: l_invoice_currency_code ap_invoices.invoice_currency_code%TYPE;
2722: l_reporting_currency_code ap_invoices.invoice_currency_code%TYPE;
2723: l_sum_base_amt NUMBER;

Line 2720: l_invoice_amount ap_invoices.invoice_amount%TYPE;

2716: l_rounded_amt NUMBER := 0;
2717: l_rounded_line_numbers inv_line_num_tab_type;
2718: l_base_currency_code ap_system_parameters.base_currency_code%TYPE;
2719: l_base_amount ap_invoices.base_amount%TYPE;
2720: l_invoice_amount ap_invoices.invoice_amount%TYPE;
2721: l_invoice_currency_code ap_invoices.invoice_currency_code%TYPE;
2722: l_reporting_currency_code ap_invoices.invoice_currency_code%TYPE;
2723: l_sum_base_amt NUMBER;
2724: l_sum_amt NUMBER;

Line 2721: l_invoice_currency_code ap_invoices.invoice_currency_code%TYPE;

2717: l_rounded_line_numbers inv_line_num_tab_type;
2718: l_base_currency_code ap_system_parameters.base_currency_code%TYPE;
2719: l_base_amount ap_invoices.base_amount%TYPE;
2720: l_invoice_amount ap_invoices.invoice_amount%TYPE;
2721: l_invoice_currency_code ap_invoices.invoice_currency_code%TYPE;
2722: l_reporting_currency_code ap_invoices.invoice_currency_code%TYPE;
2723: l_sum_base_amt NUMBER;
2724: l_sum_amt NUMBER;
2725: l_sum_rpt_base_amt NUMBER;

Line 2722: l_reporting_currency_code ap_invoices.invoice_currency_code%TYPE;

2718: l_base_currency_code ap_system_parameters.base_currency_code%TYPE;
2719: l_base_amount ap_invoices.base_amount%TYPE;
2720: l_invoice_amount ap_invoices.invoice_amount%TYPE;
2721: l_invoice_currency_code ap_invoices.invoice_currency_code%TYPE;
2722: l_reporting_currency_code ap_invoices.invoice_currency_code%TYPE;
2723: l_sum_base_amt NUMBER;
2724: l_sum_amt NUMBER;
2725: l_sum_rpt_base_amt NUMBER;
2726:

Line 2736: FROM ap_invoices AI, ap_system_parameters ASP

2732: SELECT decode(x_reporting_ledger_id, null, AI.base_amount, null),
2733: AI.invoice_amount, -- invoice amount
2734: AI.invoice_currency_code, -- invoice_currency_code
2735: ASP.base_currency_code -- base_currency_code
2736: FROM ap_invoices AI, ap_system_parameters ASP
2737: WHERE AI.invoice_id = X_invoice_id
2738: AND ASP.org_id = AI.org_id;
2739:
2740: BEGIN

Line 2742: current_calling_sequence := 'AP_INVOICES_UTILITY_PKG - Round_Base_Amt ' ||

2738: AND ASP.org_id = AI.org_id;
2739:
2740: BEGIN
2741:
2742: current_calling_sequence := 'AP_INVOICES_UTILITY_PKG - Round_Base_Amt ' ||
2743: X_calling_sequence;
2744:
2745: -------------------------------------------------------------
2746: debug_info := 'Round_Base_Amt - Open cursor invoice_cursor';

Line 2905: FROM ap_invoices AI

2901: --bug 5475668
2902: if (P_invoice_id is not null) then
2903: SELECT 1
2904: INTO l_quick_credit_count
2905: FROM ap_invoices AI
2906: WHERE AI.credited_invoice_id = P_invoice_id
2907: AND NVL(AI.quick_credit, 'N') = 'Y'
2908: AND AI.cancelled_date is null
2909: AND ROWNUM = 1 ;

Line 2954: FROM ap_invoices_all i

2950:
2951: IS
2952: CURSOR Invoice_Validation IS
2953: SELECT i.invoice_id
2954: FROM ap_invoices_all i
2955: WHERE i.invoice_id = P_Invoice_Id
2956: AND EXISTS
2957: (SELECT il.invoice_id
2958: FROM ap_invoice_lines_all il

Line 2965: l_invoice_id ap_invoices_all.invoice_id%TYPE;

2961: AND NVL(il.cancelled_flag, 'N') <> 'Y'
2962: AND il.match_type IN ('PRICE_CORRECTION',
2963: 'QTY_CORRECTION'));
2964:
2965: l_invoice_id ap_invoices_all.invoice_id%TYPE;
2966: current_calling_sequence VARCHAR2(4000);
2967: debug_info VARCHAR2(240);
2968: l_return_var BOOLEAN := FALSE;
2969:

Line 2971: current_calling_sequence := 'AP_INVOICES_UTILITY_PKG - Inv_With_PQ_Corrections';

2967: debug_info VARCHAR2(240);
2968: l_return_var BOOLEAN := FALSE;
2969:
2970: BEGIN
2971: current_calling_sequence := 'AP_INVOICES_UTILITY_PKG - Inv_With_PQ_Corrections';
2972:
2973: -------------------------------------------------------------
2974: debug_info := 'Inv_With_PQ_Corrections - Open cursor';
2975: -------------------------------------------------------------

Line 3042: FROM ap_invoices_all i

3038:
3039: IS
3040: CURSOR Invoice_Validation IS
3041: SELECT i.invoice_id
3042: FROM ap_invoices_all i
3043: WHERE i.invoice_id = P_Invoice_Id
3044: AND EXISTS
3045: (SELECT il.invoice_id
3046: FROM ap_invoice_lines_all il

Line 3052: l_invoice_id ap_invoices_all.invoice_id%TYPE;

3048: AND il.line_type_lookup_code = 'PREPAY'
3049: AND NVL(il.discarded_flag, 'N') <> 'Y'
3050: AND NVL(il.cancelled_flag, 'N') <> 'Y');
3051:
3052: l_invoice_id ap_invoices_all.invoice_id%TYPE;
3053: current_calling_sequence VARCHAR2(4000);
3054: debug_info VARCHAR2(240);
3055: l_return_var BOOLEAN := FALSE;
3056:

Line 3058: current_calling_sequence := 'AP_INVOICES_UTILITY_PKG - Inv_With_Prepayments';

3054: debug_info VARCHAR2(240);
3055: l_return_var BOOLEAN := FALSE;
3056:
3057: BEGIN
3058: current_calling_sequence := 'AP_INVOICES_UTILITY_PKG - Inv_With_Prepayments';
3059:
3060: -------------------------------------------------------------
3061: debug_info := 'Inv_With_Prepayments - Open cursor';
3062: -------------------------------------------------------------

Line 3129: FROM ap_invoices_all i

3125:
3126: IS
3127: CURSOR Invoice_Validation IS
3128: SELECT i.invoice_id
3129: FROM ap_invoices_all i
3130: WHERE i.invoice_id = P_Invoice_Id
3131: AND EXISTS
3132: (SELECT il.invoice_id
3133: FROM ap_invoice_lines_all il

Line 3139: l_invoice_id ap_invoices_all.invoice_id%TYPE;

3135: AND il.line_type_lookup_code = 'AWT'
3136: AND NVL(il.discarded_flag, 'N') <> 'Y'
3137: AND NVL(il.cancelled_flag, 'N') <> 'Y');
3138:
3139: l_invoice_id ap_invoices_all.invoice_id%TYPE;
3140: current_calling_sequence VARCHAR2(4000);
3141: debug_info VARCHAR2(240);
3142: l_return_var BOOLEAN := FALSE;
3143:

Line 3145: current_calling_sequence := 'AP_INVOICES_UTILITY_PKG - Invoice_Includes_Awt';

3141: debug_info VARCHAR2(240);
3142: l_return_var BOOLEAN := FALSE;
3143:
3144: BEGIN
3145: current_calling_sequence := 'AP_INVOICES_UTILITY_PKG - Invoice_Includes_Awt';
3146:
3147: -------------------------------------------------------------
3148: debug_info := 'Invoice_Includes_Awt - Open cursor';
3149: -------------------------------------------------------------

Line 3215: FROM ap_invoices_all i

3211:
3212: IS
3213: CURSOR Invoice_Validation IS
3214: SELECT i.invoice_id
3215: FROM ap_invoices_all i
3216: WHERE i.invoice_id = P_Invoice_Id
3217: AND EXISTS
3218: (SELECT ail.invoice_id
3219: FROM ap_invoice_lines_all ail,

Line 3226: l_invoice_id ap_invoices_all.invoice_id%TYPE;

3222: AND ail.po_line_location_id = pll.line_location_id
3223: AND ail.org_id = pll.org_id
3224: AND pll.closed_code = 'FINALLY CLOSED');
3225:
3226: l_invoice_id ap_invoices_all.invoice_id%TYPE;
3227: current_calling_sequence VARCHAR2(4000);
3228: debug_info VARCHAR2(240);
3229: l_return_var BOOLEAN := FALSE;
3230:

Line 3232: current_calling_sequence := 'AP_INVOICES_UTILITY_PKG - Inv_Matched_Finally_Closed_Po';

3228: debug_info VARCHAR2(240);
3229: l_return_var BOOLEAN := FALSE;
3230:
3231: BEGIN
3232: current_calling_sequence := 'AP_INVOICES_UTILITY_PKG - Inv_Matched_Finally_Closed_Po';
3233:
3234: ------------------------------------------------------------
3235: debug_info := 'Open cursor to verify if the invoice is '||
3236: 'matched to a finally closed PO';

Line 3311: FROM ap_invoices

3307: BEGIN
3308:
3309: SELECT invoice_num
3310: INTO l_invoice_num
3311: FROM ap_invoices
3312: WHERE invoice_id = p_invoice_id;
3313:
3314: RETURN(l_invoice_num);
3315:

Line 3535: FROM ap_invoices_all ai

3531: INTO l_cancelled_date,
3532: l_approval_ready_flag,
3533: l_invoice_type_lookup_code,
3534: l_invoice_source
3535: FROM ap_invoices_all ai
3536: WHERE ai.invoice_id = p_invoice_id
3537: AND ai.source = 'ISP';
3538:
3539: -- If cancelled date is not null, return 'CANCELLED'

Line 3546: -- Temporarily approval_ready_flag = 'S' in ap_invoices_all handles the

3542: RETURN('CANCELLED');
3543: END IF;
3544:
3545: -- If invoice is saved for later in ISP, return 'UNSUBMITTED'.
3546: -- Temporarily approval_ready_flag = 'S' in ap_invoices_all handles the
3547: -- the unsubmitted invoices.
3548: IF ( l_approval_ready_flag = 'S' ) THEN
3549: RETURN('UNSUBMITTED');
3550: END IF;

Line 3642: END AP_INVOICES_UTILITY_PKG;

3638: x_bank_account_id := NULL;
3639: x_bank_account_number := NULL;
3640: END get_bank_details;
3641:
3642: END AP_INVOICES_UTILITY_PKG;
3643: