DBA Data[Home] [Help]

APPS.IGC_CC_BUDGETARY_CTRL_PKG dependencies on IGC_CC_BC_ENABLE

Line 2085: l_cc_bc_enable_flag igc_cc_bc_enable.cc_bc_enable_flag%TYPE;

2081: l_api_name CONSTANT VARCHAR2(30) := 'Execute_Budgetary_Ctrl';
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;

Line 2535: FROM igc_cc_bc_enable

2531: l_cc_bc_enable_flag := 'N';
2532:
2533: SELECT cc_bc_enable_flag
2534: INTO l_cc_bc_enable_flag
2535: FROM igc_cc_bc_enable
2536: WHERE set_of_books_id = l_cc_headers_rec.set_of_books_id;
2537: EXCEPTION
2538: WHEN NO_DATA_FOUND
2539: THEN

Line 4048: l_cc_bc_enable_flag igc_cc_bc_enable.cc_bc_enable_flag%TYPE;

4044: l_api_name CONSTANT VARCHAR2(30) := 'Check_Budgetary_Ctrl_On';
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;

Line 4154: FROM igc_cc_bc_enable

4150:
4151: BEGIN
4152: SELECT cc_bc_enable_flag
4153: INTO l_cc_bc_enable_flag
4154: FROM igc_cc_bc_enable
4155: WHERE set_of_books_id = p_sob_id;
4156: EXCEPTION
4157: WHEN NO_DATA_FOUND
4158: THEN

Line 4752: l_cbc_enable_flag igc_cc_bc_enable.cc_bc_enable_flag%TYPE := 'N';

4748: e_no_det_pf EXCEPTION;
4749: e_amt_mismatch EXCEPTION;
4750:
4751: l_sbc_enable_flag gl_sets_of_books.enable_budgetary_control_flag%TYPE := 'N';
4752: l_cbc_enable_flag igc_cc_bc_enable.cc_bc_enable_flag%TYPE := 'N';
4753: -- l_cc_prov_encmbrnc_flag igc_cc_encmbrnc_ctrls.cc_prov_encmbrnc_enable_flag%TYPE := 'N';
4754: -- l_cc_conf_encmbrnc_flag igc_cc_encmbrnc_ctrls.cc_conf_encmbrnc_enable_flag%TYPE := 'N';
4755: l_cc_prov_encmbrnc_flag VARCHAR2(1);
4756: l_cc_conf_encmbrnc_flag VARCHAR2(1);

Line 4961: FROM igc_cc_bc_enable

4957: THEN
4958: BEGIN
4959: SELECT cc_bc_enable_flag
4960: INTO l_cbc_enable_flag
4961: FROM igc_cc_bc_enable
4962: WHERE set_of_books_id = p_sob_id;
4963: EXCEPTION
4964: WHEN NO_DATA_FOUND THEN
4965: l_cbc_enable_flag := 'N';