DBA Data[Home] [Help]

APPS.IGC_CC_BUDGETARY_CTRL_PKG dependencies on FINANCIALS_SYSTEM_PARAMS_ALL

Line 2086: l_req_encumbrance_flag financials_system_params_all.req_encumbrance_flag%TYPE;

2082: l_api_version CONSTANT NUMBER := 1.0;
2083:
2084: l_enable_budg_control_flag gl_sets_of_books.enable_budgetary_control_flag%TYPE;
2085: l_cc_bc_enable_flag igc_cc_bc_enable.cc_bc_enable_flag%TYPE;
2086: l_req_encumbrance_flag financials_system_params_all.req_encumbrance_flag%TYPE;
2087: l_purch_encumbrance_flag financials_system_params_all.purch_encumbrance_flag%TYPE;
2088: -- l_cc_prov_enc_enable_flag igc_cc_encmbrnc_ctrls.cc_prov_encmbrnc_enable_flag%TYPE;
2089: -- l_cc_conf_enc_enable_flag igc_cc_encmbrnc_ctrls.cc_conf_encmbrnc_enable_flag%TYPE;
2090:

Line 2087: l_purch_encumbrance_flag financials_system_params_all.purch_encumbrance_flag%TYPE;

2083:
2084: l_enable_budg_control_flag gl_sets_of_books.enable_budgetary_control_flag%TYPE;
2085: l_cc_bc_enable_flag igc_cc_bc_enable.cc_bc_enable_flag%TYPE;
2086: l_req_encumbrance_flag financials_system_params_all.req_encumbrance_flag%TYPE;
2087: l_purch_encumbrance_flag financials_system_params_all.purch_encumbrance_flag%TYPE;
2088: -- l_cc_prov_enc_enable_flag igc_cc_encmbrnc_ctrls.cc_prov_encmbrnc_enable_flag%TYPE;
2089: -- l_cc_conf_enc_enable_flag igc_cc_encmbrnc_ctrls.cc_conf_encmbrnc_enable_flag%TYPE;
2090:
2091: l_cc_header_id igc_cc_headers.cc_header_id%TYPE;

Line 4049: l_req_encumbrance_flag financials_system_params_all.req_encumbrance_flag%TYPE;

4045: l_api_version CONSTANT NUMBER := 1.0;
4046:
4047: l_enable_budg_control_flag gl_sets_of_books.enable_budgetary_control_flag%TYPE;
4048: l_cc_bc_enable_flag igc_cc_bc_enable.cc_bc_enable_flag%TYPE;
4049: l_req_encumbrance_flag financials_system_params_all.req_encumbrance_flag%TYPE;
4050: l_purch_encumbrance_flag financials_system_params_all.purch_encumbrance_flag%TYPE;
4051: -- l_cc_prov_enc_enable_flag igc_cc_encmbrnc_ctrls.cc_prov_encmbrnc_enable_flag%TYPE;
4052: -- l_cc_conf_enc_enable_flag igc_cc_encmbrnc_ctrls.cc_conf_encmbrnc_enable_flag%TYPE;
4053:

Line 4050: l_purch_encumbrance_flag financials_system_params_all.purch_encumbrance_flag%TYPE;

4046:
4047: l_enable_budg_control_flag gl_sets_of_books.enable_budgetary_control_flag%TYPE;
4048: l_cc_bc_enable_flag igc_cc_bc_enable.cc_bc_enable_flag%TYPE;
4049: l_req_encumbrance_flag financials_system_params_all.req_encumbrance_flag%TYPE;
4050: l_purch_encumbrance_flag financials_system_params_all.purch_encumbrance_flag%TYPE;
4051: -- l_cc_prov_enc_enable_flag igc_cc_encmbrnc_ctrls.cc_prov_encmbrnc_enable_flag%TYPE;
4052: -- l_cc_conf_enc_enable_flag igc_cc_encmbrnc_ctrls.cc_conf_encmbrnc_enable_flag%TYPE;
4053:
4054: l_error_message VARCHAR2(2000);

Line 4140: FROM financials_system_params_all

4136: THEN
4137: BEGIN
4138: SELECT req_encumbrance_flag, purch_encumbrance_flag
4139: INTO l_req_encumbrance_flag, l_purch_encumbrance_flag
4140: FROM financials_system_params_all
4141: WHERE set_of_books_id = p_sob_id AND
4142: org_id = p_org_id;
4143: EXCEPTION
4144: WHEN NO_DATA_FOUND