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_UTILITY_PKG

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 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 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 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 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 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 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 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 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 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 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 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: