APPS.PO_VAL_DISTRIBUTIONS dependencies on FINANCIALS_SYSTEM_PARAMS_ALL

Line 744: l_sob_id FINANCIALS_SYSTEM_PARAMS_ALL.set_of_books_id%TYPE;

740: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
741: , x_result_type OUT NOCOPY VARCHAR2
742: )
743: IS
744: l_sob_id FINANCIALS_SYSTEM_PARAMS_ALL.set_of_books_id%TYPE;
745: l_po_enc_flag FINANCIALS_SYSTEM_PARAMS_ALL.purch_encumbrance_flag%TYPE;
746: l_gl_enc_period_name PO_DISTRIBUTIONS_ALL.gl_encumbered_period_name %TYPE;
747: l_results_count NUMBER;
748: BEGIN

Line 745: l_po_enc_flag FINANCIALS_SYSTEM_PARAMS_ALL.purch_encumbrance_flag%TYPE;

741: , x_result_type OUT NOCOPY VARCHAR2
742: )
743: IS
744: l_sob_id FINANCIALS_SYSTEM_PARAMS_ALL.set_of_books_id%TYPE;
745: l_po_enc_flag FINANCIALS_SYSTEM_PARAMS_ALL.purch_encumbrance_flag%TYPE;
746: l_gl_enc_period_name PO_DISTRIBUTIONS_ALL.gl_encumbered_period_name %TYPE;
747: l_results_count NUMBER;
748: BEGIN
749:

Line 759: FROM financials_system_params_all

755:
756: FOR I IN 1..p_dist_id_tbl.COUNT LOOP
757: SELECT purch_encumbrance_flag, set_of_books_id
758: INTO l_po_enc_flag, l_sob_id
759: FROM financials_system_params_all
760: WHERE org_id = p_org_id_tbl(i);
761:
762: IF (l_po_enc_flag = 'Y') THEN
763:

Line 896: l_ledger_id FINANCIALS_SYSTEM_PARAMS_ALL.set_of_books_id%TYPE;

892: )
893: IS
894: d_mod CONSTANT VARCHAR2(100) := D_check_fv_validations;
895:
896: l_ledger_id FINANCIALS_SYSTEM_PARAMS_ALL.set_of_books_id%TYPE;
897: l_return_status VARCHAR2(1);
898: l_error_message VARCHAR2(2000);
899: l_results_count NUMBER;
900: l_result_type VARCHAR2(30);

Line 922: FROM financials_system_params_all

918: IF FV_INSTALL.enabled(p_org_id_tbl(i)) THEN
919:
920: SELECT set_of_books_id
921: INTO l_ledger_id
922: FROM financials_system_params_all
923: WHERE org_id = p_org_id_tbl(i);
924:
925: FV_PO_VALIDATE_GRP.CHECK_AGREEMENT_DATES(
926: x_code_combination_id => p_ccid_tbl(i),