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 59: financials_system_params_all fsp

55: ai.org_id
56: INTO l_purch_encumbrance_flag,
57: l_org_id
58: FROM ap_invoices_all ai,
59: financials_system_params_all fsp
60: WHERE ai.invoice_id = p_invoice_id
61: AND ai.org_id = fsp.org_id;
62:
63: IF (l_purch_encumbrance_flag = 'N') THEN

Line 258: l_org_id FINANCIALS_SYSTEM_PARAMS_ALL.ORG_ID%TYPE;

254: dist_var_hold NUMBER;
255: match_flag_cnt NUMBER;
256: l_cancelled_count NUMBER;
257: l_discarded_count NUMBER;
258: l_org_id FINANCIALS_SYSTEM_PARAMS_ALL.ORG_ID%TYPE;
259: ---------------------------------------------------------------------
260: -- Declare cursor to establish the invoice-level approval flag
261: --
262: -- The first select simply looks at the match status flag for the

Line 283: financials_system_params_all fsp

279:
280: SELECT NVL(fsp.purch_encumbrance_flag,'N'), ai.org_id
281: INTO encumbrance_flag, l_org_id
282: FROM ap_invoices_all ai,
283: financials_system_params_all fsp
284: WHERE ai.invoice_id = p_invoice_id
285: AND ai.org_id = fsp.org_id;
286:
287: ---------------------------------------------------------------------

Line 719: FROM financials_system_params_all FSP,

715: +-----------------------------------------------------------------*/
716:
717: SELECT NVL(purch_encumbrance_flag,'N')
718: INTO l_enc_enabled
719: FROM financials_system_params_all FSP,
720: ap_invoices_all AI
721: WHERE AI.invoice_id = p_line_rec.invoice_id
722: AND FSP.org_id = AI.org_id;
723: