APPS.AP_INVOICES_UTILITY_PKG dependencies on AP_SYSTEM_PARAMETERS

Line 163: l_org_id AP_SYSTEM_PARAMETERS_ALL.ORG_ID%TYPE;

159: RETURN VARCHAR2 IS
160: invoice_posting_flag VARCHAR2(1);
161: distribution_posting_flag VARCHAR2(1);
162: l_cash_basis_flag VARCHAR2(1);
163: l_org_id AP_SYSTEM_PARAMETERS_ALL.ORG_ID%TYPE;
164:
165:
166: CURSOR posting_cursor IS
167: SELECT cash_posted_flag

Line 237: ap_system_parameters_all asp,

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
241: AND asp.set_of_books_id = sob.set_of_books_id;

Line 1974: l_org_id AP_SYSTEM_PARAMETERS_ALL.ORG_ID%TYPE;

1970: FUNCTION get_unposted_void_payment (P_invoice_id IN number)
1971: RETURN varchar2
1972: IS
1973: l_flag varchar2(1) := 'N';
1974: l_org_id AP_SYSTEM_PARAMETERS_ALL.ORG_ID%TYPE;
1975:
1976: CURSOR payment_cursor IS
1977: SELECT 'Y', p.org_id
1978: FROM ap_invoice_payments p,

Line 1980: ap_system_parameters SP

1976: CURSOR payment_cursor IS
1977: SELECT 'Y', p.org_id
1978: FROM ap_invoice_payments p,
1979: ap_checks c,
1980: ap_system_parameters SP
1981: WHERE p.invoice_id = P_invoice_id
1982: AND p.org_id = sp.org_id
1983: AND nvl(p.cash_posted_flag,'N') <> 'Y'
1984: AND p.check_id = c.check_id

Line 2323: l_org_id AP_SYSTEM_PARAMETERS_ALL.ORG_ID%TYPE;

2319: l_count_pmt_hist_posted NUMBER := 0;
2320: l_count_prepaid_posted NUMBER := 0;
2321: l_primary_acctg_method VARCHAR2(25);
2322: l_secondary_acctg_method VARCHAR2(25);
2323: l_org_id AP_SYSTEM_PARAMETERS_ALL.ORG_ID%TYPE;
2324: BEGIN
2325:
2326: select asp.accounting_method_option,
2327: nvl(asp.secondary_accounting_method, 'None'),

Line 2332: from ap_system_parameters_all asp

2328: asp.org_id
2329: into l_primary_acctg_method,
2330: l_secondary_acctg_method,
2331: l_org_id
2332: from ap_system_parameters_all asp
2333: where asp.org_id = P_org_id;
2334:
2335:
2336: /*-----------------------------------------------------------------+

Line 2718: l_base_currency_code ap_system_parameters.base_currency_code%TYPE;

2714: X_Calling_sequence IN VARCHAR2)
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;

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