APPS.AP_INVOICE_LINES_UTILITY_PKG dependencies on FINANCIALS_SYSTEM_PARAMS_ALL

Line 45: l_org_id FINANCIALS_SYSTEM_PARAMS_ALL.ORG_ID%TYPE;

41: l_purch_encumbrance_flag VARCHAR2(1) := '';
42: l_encumbered_flag VARCHAR2(1) := '';
43: l_distribution_count number := 0;
44: l_encumbered_count number := 0;
45: l_org_id FINANCIALS_SYSTEM_PARAMS_ALL.ORG_ID%TYPE;
46:
47: CURSOR encumbrance_flag_cursor is
48: SELECT nvl(encumbered_flag,'N')
49: FROM ap_invoice_distributions

Line 63: financials_system_params_all fsp

59: ai.org_id
60: INTO l_purch_encumbrance_flag,
61: l_org_id
62: FROM ap_invoices_all ai,
63: financials_system_params_all fsp
64: WHERE ai.invoice_id = p_invoice_id
65: AND ai.org_id = fsp.org_id;
66:
67: IF (l_purch_encumbrance_flag = 'N') THEN

Line 276: l_org_id FINANCIALS_SYSTEM_PARAMS_ALL.ORG_ID%TYPE;

272: dist_var_hold NUMBER;
273: match_flag_cnt NUMBER;
274: l_cancelled_count NUMBER;
275: l_discarded_count NUMBER;
276: l_org_id FINANCIALS_SYSTEM_PARAMS_ALL.ORG_ID%TYPE;
277: ---------------------------------------------------------------------
278: -- Declare cursor to establish the invoice-level approval flag
279: --
280: -- The first select simply looks at the match status flag for the

Line 301: financials_system_params_all fsp

297:
298: SELECT NVL(fsp.purch_encumbrance_flag,'N'), ai.org_id
299: INTO encumbrance_flag, l_org_id
300: FROM ap_invoices_all ai,
301: financials_system_params_all fsp
302: WHERE ai.invoice_id = p_invoice_id
303: AND ai.org_id = fsp.org_id;
304:
305: ---------------------------------------------------------------------

Line 627: FROM financials_system_params_all FSP,

623: +-----------------------------------------------------------------*/
624:
625: SELECT NVL(purch_encumbrance_flag,'N')
626: INTO l_enc_enabled
627: FROM financials_system_params_all FSP,
628: ap_invoices_all AI
629: WHERE AI.invoice_id = p_line_rec.invoice_id
630: AND FSP.org_id = AI.org_id;
631: