DBA Data[Home] [Help]

APPS.IGC_CC_BUDGETARY_CTRL_PKG dependencies on FINANCIALS_SYSTEM_PARAMS_ALL

Line 2028: l_req_encumbrance_flag financials_system_params_all.req_encumbrance_flag%TYPE;

2024: l_api_version CONSTANT NUMBER := 1.0;
2025:
2026: l_enable_budg_control_flag gl_sets_of_books.enable_budgetary_control_flag%TYPE;
2027: l_cc_bc_enable_flag igc_cc_bc_enable.cc_bc_enable_flag%TYPE;
2028: l_req_encumbrance_flag financials_system_params_all.req_encumbrance_flag%TYPE;
2029: l_purch_encumbrance_flag financials_system_params_all.purch_encumbrance_flag%TYPE;
2030: -- l_cc_prov_enc_enable_flag igc_cc_encmbrnc_ctrls.cc_prov_encmbrnc_enable_flag%TYPE;
2031: -- l_cc_conf_enc_enable_flag igc_cc_encmbrnc_ctrls.cc_conf_encmbrnc_enable_flag%TYPE;
2032:

Line 2029: l_purch_encumbrance_flag financials_system_params_all.purch_encumbrance_flag%TYPE;

2025:
2026: l_enable_budg_control_flag gl_sets_of_books.enable_budgetary_control_flag%TYPE;
2027: l_cc_bc_enable_flag igc_cc_bc_enable.cc_bc_enable_flag%TYPE;
2028: l_req_encumbrance_flag financials_system_params_all.req_encumbrance_flag%TYPE;
2029: l_purch_encumbrance_flag financials_system_params_all.purch_encumbrance_flag%TYPE;
2030: -- l_cc_prov_enc_enable_flag igc_cc_encmbrnc_ctrls.cc_prov_encmbrnc_enable_flag%TYPE;
2031: -- l_cc_conf_enc_enable_flag igc_cc_encmbrnc_ctrls.cc_conf_encmbrnc_enable_flag%TYPE;
2032:
2033: l_cc_header_id igc_cc_headers.cc_header_id%TYPE;

Line 3991: l_req_encumbrance_flag financials_system_params_all.req_encumbrance_flag%TYPE;

3987: l_api_version CONSTANT NUMBER := 1.0;
3988:
3989: l_enable_budg_control_flag gl_sets_of_books.enable_budgetary_control_flag%TYPE;
3990: l_cc_bc_enable_flag igc_cc_bc_enable.cc_bc_enable_flag%TYPE;
3991: l_req_encumbrance_flag financials_system_params_all.req_encumbrance_flag%TYPE;
3992: l_purch_encumbrance_flag financials_system_params_all.purch_encumbrance_flag%TYPE;
3993: -- l_cc_prov_enc_enable_flag igc_cc_encmbrnc_ctrls.cc_prov_encmbrnc_enable_flag%TYPE;
3994: -- l_cc_conf_enc_enable_flag igc_cc_encmbrnc_ctrls.cc_conf_encmbrnc_enable_flag%TYPE;
3995:

Line 3992: l_purch_encumbrance_flag financials_system_params_all.purch_encumbrance_flag%TYPE;

3988:
3989: l_enable_budg_control_flag gl_sets_of_books.enable_budgetary_control_flag%TYPE;
3990: l_cc_bc_enable_flag igc_cc_bc_enable.cc_bc_enable_flag%TYPE;
3991: l_req_encumbrance_flag financials_system_params_all.req_encumbrance_flag%TYPE;
3992: l_purch_encumbrance_flag financials_system_params_all.purch_encumbrance_flag%TYPE;
3993: -- l_cc_prov_enc_enable_flag igc_cc_encmbrnc_ctrls.cc_prov_encmbrnc_enable_flag%TYPE;
3994: -- l_cc_conf_enc_enable_flag igc_cc_encmbrnc_ctrls.cc_conf_encmbrnc_enable_flag%TYPE;
3995:
3996: l_error_message VARCHAR2(2000);

Line 4082: FROM financials_system_params_all

4078: THEN
4079: BEGIN
4080: SELECT req_encumbrance_flag, purch_encumbrance_flag
4081: INTO l_req_encumbrance_flag, l_purch_encumbrance_flag
4082: FROM financials_system_params_all
4083: WHERE set_of_books_id = p_sob_id AND
4084: org_id = p_org_id;
4085: EXCEPTION
4086: WHEN NO_DATA_FOUND