APPS.AP_INVOICES_UTILITY_PKG dependencies on AP_SYSTEM_PARAMETERS

Line 169: l_org_id AP_SYSTEM_PARAMETERS_ALL.ORG_ID%TYPE;

165: RETURN VARCHAR2 IS
166: invoice_posting_flag VARCHAR2(1);
167: distribution_posting_flag VARCHAR2(1);
168: l_cash_basis_flag VARCHAR2(1);
169: l_org_id AP_SYSTEM_PARAMETERS_ALL.ORG_ID%TYPE;
170:
171:
172: CURSOR posting_cursor IS
173: SELECT cash_posted_flag

Line 310: ap_system_parameters_all asp,

306: asp.org_id
307: INTO l_cash_basis_flag,
308: l_org_id
309: FROM ap_invoices_all ai,
310: ap_system_parameters_all asp,
311: gl_sets_of_books sob
312: WHERE ai.invoice_id = l_invoice_id
313: AND ai.org_id = asp.org_id
314: AND asp.set_of_books_id = sob.set_of_books_id;

Line 2046: l_org_id AP_SYSTEM_PARAMETERS_ALL.ORG_ID%TYPE;

2042: FUNCTION get_unposted_void_payment (P_invoice_id IN number)
2043: RETURN varchar2
2044: IS
2045: l_flag varchar2(1) := 'N';
2046: l_org_id AP_SYSTEM_PARAMETERS_ALL.ORG_ID%TYPE;
2047:
2048: CURSOR payment_cursor IS
2049: SELECT 'Y', p.org_id
2050: FROM ap_invoice_payments p,

Line 2052: ap_system_parameters SP

2048: CURSOR payment_cursor IS
2049: SELECT 'Y', p.org_id
2050: FROM ap_invoice_payments p,
2051: ap_checks c,
2052: ap_system_parameters SP
2053: WHERE p.invoice_id = P_invoice_id
2054: AND p.org_id = sp.org_id
2055: AND nvl(p.cash_posted_flag,'N') <> 'Y'
2056: AND p.check_id = c.check_id

Line 2395: l_org_id AP_SYSTEM_PARAMETERS_ALL.ORG_ID%TYPE;

2391: l_count_pmt_hist_posted NUMBER := 0;
2392: l_count_prepaid_posted NUMBER := 0;
2393: l_primary_acctg_method VARCHAR2(25);
2394: l_secondary_acctg_method VARCHAR2(25);
2395: l_org_id AP_SYSTEM_PARAMETERS_ALL.ORG_ID%TYPE;
2396: BEGIN
2397:
2398: select asp.accounting_method_option,
2399: nvl(asp.secondary_accounting_method, 'None'),

Line 2404: from ap_system_parameters_all asp

2400: asp.org_id
2401: into l_primary_acctg_method,
2402: l_secondary_acctg_method,
2403: l_org_id
2404: from ap_system_parameters_all asp
2405: where asp.org_id = P_org_id;
2406:
2407:
2408: /*-----------------------------------------------------------------+

Line 2790: l_base_currency_code ap_system_parameters.base_currency_code%TYPE;

2786: X_Calling_sequence IN VARCHAR2)
2787: RETURN BOOLEAN IS
2788: l_rounded_amt NUMBER := 0;
2789: l_rounded_line_numbers inv_line_num_tab_type;
2790: l_base_currency_code ap_system_parameters.base_currency_code%TYPE;
2791: l_base_amount ap_invoices.base_amount%TYPE;
2792: l_invoice_amount ap_invoices.invoice_amount%TYPE;
2793: l_invoice_currency_code ap_invoices.invoice_currency_code%TYPE;
2794: l_reporting_currency_code ap_invoices.invoice_currency_code%TYPE;

Line 2808: FROM ap_invoices AI, ap_system_parameters ASP

2804: SELECT decode(x_reporting_ledger_id, null, AI.base_amount, null),
2805: AI.invoice_amount, -- invoice amount
2806: AI.invoice_currency_code, -- invoice_currency_code
2807: ASP.base_currency_code -- base_currency_code
2808: FROM ap_invoices AI, ap_system_parameters ASP
2809: WHERE AI.invoice_id = X_invoice_id
2810: AND ASP.org_id = AI.org_id;
2811:
2812: BEGIN