APPS.AP_INVOICES_UTILITY_PKG dependencies on FINANCIALS_SYSTEM_PARAMS_ALL

Line 474: l_org_id FINANCIALS_SYSTEM_PARAMS_ALL.ORG_ID%TYPE;

470: sum_distributions NUMBER;
471: dist_var_hold NUMBER;
472: match_flag_cnt NUMBER;
473: l_validated_cnt NUMBER;
474: l_org_id FINANCIALS_SYSTEM_PARAMS_ALL.ORG_ID%TYPE;
475: l_force_revalidation_flag VARCHAR2(1);
476: --Bugfix: 3854385
477: l_dist_variance VARCHAR2(20) := 'DIST VARIANCE';
478: l_line_variance VARCHAR2(20) := 'LINE VARIANCE';

Line 516: financials_system_params_all fsp

512: INTO encumbrance_flag,
513: l_org_id,
514: l_force_revalidation_flag
515: FROM ap_invoices_all ai,
516: financials_system_params_all fsp
517: WHERE ai.invoice_id = l_invoice_id
518: AND ai.set_of_books_id = fsp.set_of_books_id
519: AND ai.org_id = fsp.org_id;
520:

Line 1507: l_org_id FINANCIALS_SYSTEM_PARAMS_ALL.ORG_ID%TYPE;

1503: l_purch_encumbrance_flag VARCHAR2(1) := '';
1504: l_encumbered_flag VARCHAR2(1) := '';
1505: l_distribution_count number := 0;
1506: l_encumbered_count number := 0;
1507: l_org_id FINANCIALS_SYSTEM_PARAMS_ALL.ORG_ID%TYPE;
1508:
1509: CURSOR encumbrance_flag_cursor is
1510: SELECT nvl(encumbered_flag,'N')
1511: FROM ap_invoice_distributions

Line 1528: financials_system_params_all fsp

1524:
1525: SELECT NVL(fsp.purch_encumbrance_flag,'N'), ai.org_id
1526: INTO l_purch_encumbrance_flag, l_org_id
1527: FROM ap_invoices_all ai,
1528: financials_system_params_all fsp
1529: WHERE ai.invoice_id = l_invoice_id
1530: AND ai.org_id = fsp.org_id;
1531:
1532: IF (l_purch_encumbrance_flag = 'N') THEN