APPS.AP_APPROVAL_PKG dependencies on AP_INVOICES_UTILITY_PKG

Line 5045: l_round_inv_line_numbers AP_INVOICES_UTILITY_PKG.inv_line_num_tab_type; --6892789

5041: l_debug_context VARCHAR2(2000);
5042:
5043: l_modified_line_rounding_amt NUMBER; --6892789
5044: l_base_amt NUMBER; --6892789
5045: l_round_inv_line_numbers AP_INVOICES_UTILITY_PKG.inv_line_num_tab_type; --6892789
5046: l_amt NUMBER; -- Bug 12686348
5047: l_invoice_type AP_INVOICES.INVOICE_TYPE_LOOKUP_CODE%TYPE; --Bug#10416960
5048:
5049: BEGIN

Line 5131: l_round_amt_exist := AP_INVOICES_UTILITY_PKG.round_base_amts(

5127: WHERE INVOICE_ID=p_invoice_id;
5128:
5129: IF(l_invoice_type <> 'PO PRICE ADJUST')THEN
5130: -- get the lines which can be adjusted
5131: l_round_amt_exist := AP_INVOICES_UTILITY_PKG.round_base_amts(
5132: X_Invoice_Id => p_invoice_id,
5133: X_Reporting_Ledger_Id => NULL,
5134: X_Rounded_Line_Numbers => l_round_inv_line_numbers,
5135: X_Rounded_Amt => l_rounded_amt,

Line 7865: l_retained_amount := abs(nvl(ap_invoices_utility_pkg.get_retained_total

7861: --Introduced abs() for bug#9356460
7862: --8405589 Starts
7863:
7864: if nvl(p_net_of_retainage_flag, 'N') <> 'Y' then
7865: l_retained_amount := abs(nvl(ap_invoices_utility_pkg.get_retained_total
7866: (p_invoice_id, l_org_id),0));
7867: end if;
7868: --8405589 Ends
7869:

Line 11921: l_retained_amount := nvl(ap_invoices_utility_pkg.get_retained_total(p_invoice_rec.invoice_id, null),0);

11917: END IF;
11918: END LOOP;
11919:
11920: /* Bug#14582311
11921: l_retained_amount := nvl(ap_invoices_utility_pkg.get_retained_total(p_invoice_rec.invoice_id, null),0);
11922:
11923: IF l_retained_amount <> 0 THEN
11924:
11925: ----------------------------------------------------------------

Line 12440: l_retained_amount := nvl(ap_invoices_utility_pkg.get_retained_total(p_invoice_rec.invoice_id, null),0);

12436: END IF;
12437: END LOOP;
12438:
12439: /* Bug#14582311
12440: l_retained_amount := nvl(ap_invoices_utility_pkg.get_retained_total(p_invoice_rec.invoice_id, null),0);
12441:
12442: IF l_retained_amount <> 0 THEN
12443:
12444: ----------------------------------------------------------------

Line 12692: IF (AP_INVOICES_UTILITY_PKG.FV_ENABLED) THEN

12688: IF g_debug_mode = 'Y' THEN
12689: AP_Debug_Pkg.Print(g_debug_mode, l_debug_info );
12690: END IF;
12691:
12692: IF (AP_INVOICES_UTILITY_PKG.FV_ENABLED) THEN
12693:
12694: ----------------------------------------------------------------
12695: l_debug_info := 'Select invoice type';
12696: IF g_debug_mode = 'Y' THEN

Line 12817: AP_INVOICES_UTILITY_PKG.CHECK_GDF_VALID

12813: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
12814: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, l_debug_info );
12815: END IF;
12816:
12817: AP_INVOICES_UTILITY_PKG.CHECK_GDF_VALID
12818: (P_INVOICE_ID, --P_id
12819: 'INV_VLD', --P_calling_mode
12820: 'AP_INVOICE_DISTRIBUTIONS', --P_table_name
12821: l_hold_reject_exists_flag, --P_hold_reject_exists_flag