APPS.AP_INVOICES_UTILITY_PKG dependencies on AP_SYSTEM_PARAMETERS_ALL

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 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: /*-----------------------------------------------------------------+