eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGC_CC_BUDGETARY_CTRL_PKG dependencies on GL_SETS_OF_BOOKS

Line 2084: l_enable_budg_control_flag gl_sets_of_books.enable_budgetary_control_flag%TYPE;

2080: IS
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;

Line 2128: l_currency_code gl_sets_of_books.currency_code%TYPE;

2124: l_cc_interface_rec igc_cc_interface%ROWTYPE;
2125:
2126: l_debug VARCHAR2(1);
2127:
2128: l_currency_code gl_sets_of_books.currency_code%TYPE;
2129: l_error_message VARCHAR2(2000);
2130:
2131: l_cc_apprvl_status_old igc_cc_headers.cc_apprvl_status%TYPE;
2132: l_encumbrance_status_old VARCHAR2(1);

Line 2515: FROM gl_sets_of_books

2511:
2512: BEGIN
2513: SELECT enable_budgetary_control_flag,currency_code
2514: INTO l_enable_budg_control_flag, l_currency_code
2515: FROM gl_sets_of_books
2516: WHERE set_of_books_id = l_cc_headers_rec.set_of_books_id;
2517: EXCEPTION
2518: WHEN NO_DATA_FOUND
2519: THEN

Line 4047: l_enable_budg_control_flag gl_sets_of_books.enable_budgetary_control_flag%TYPE;

4043: IS
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;

Line 4119: FROM gl_sets_of_books

4115: BEGIN
4116:
4117: SELECT NVL(enable_budgetary_control_flag,'N')
4118: INTO l_enable_budg_control_flag
4119: FROM gl_sets_of_books
4120: WHERE set_of_books_id = p_sob_id;
4121:
4122: EXCEPTION
4123:

Line 4751: l_sbc_enable_flag gl_sets_of_books.enable_budgetary_control_flag%TYPE := 'N';

4747: e_cc_not_found EXCEPTION;
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);

Line 4940: FROM gl_sets_of_books

4936:
4937: BEGIN
4938: SELECT NVL(enable_budgetary_control_flag,'N')
4939: INTO l_sbc_enable_flag
4940: FROM gl_sets_of_books
4941: WHERE set_of_books_id = p_sob_id;
4942: EXCEPTION
4943: WHEN NO_DATA_FOUND THEN
4944: x_valid_cc := FND_API.G_FALSE;

Line 5037: FROM gl_sets_of_books sob, gl_periods gp, igc_cc_periods cp

5033:
5034: BEGIN
5035: SELECT count(*)
5036: INTO l_COUNT
5037: FROM gl_sets_of_books sob, gl_periods gp, igc_cc_periods cp
5038: WHERE sob.set_of_books_id = p_sob_id
5039: AND sob.period_set_name = gp.period_set_name
5040: AND cp.org_id = p_org_id
5041: AND gp.period_set_name = cp.period_set_name

Line 5077: FROM gl_sets_of_books sob,

5073:
5074: BEGIN
5075: SELECT count(*)
5076: INTO l_COUNT
5077: FROM gl_sets_of_books sob,
5078: gl_period_statuses gl,
5079: igc_cc_periods cp
5080: WHERE sob.set_of_books_id = p_sob_id
5081: AND gl.set_of_books_id = sob.set_of_books_id

Line 5282: FROM gl_sets_of_books sob,

5278: -- view gl_period_statuses_v with
5279: -- gl_period_statuses
5280: SELECT count(*)
5281: INTO l_COUNT
5282: FROM gl_sets_of_books sob,
5283: gl_period_statuses gl,
5284: igc_cc_periods cp
5285: WHERE sob.set_of_books_id = p_sob_id
5286: AND gl.set_of_books_id = sob.set_of_books_id

Line 5387: FROM gl_sets_of_books sob,

5383: -- view gl_period_statuses_v with
5384: -- gl_period_statuses
5385: SELECT count(*)
5386: INTO l_COUNT
5387: FROM gl_sets_of_books sob,
5388: gl_period_statuses gl,
5389: igc_cc_periods cp
5390: WHERE sob.set_of_books_id = p_sob_id
5391: AND gl.set_of_books_id = sob.set_of_books_id

Line 5433: -- FROM gl_sets_of_books sob,

5429: -- one below as we are only
5430: -- interested in the fiscal years.
5431: -- SELECT DISTINCT cp.period_year
5432: -- INTO l_orig_fiscal_year
5433: -- FROM gl_sets_of_books sob,
5434: -- gl_period_statuses_v gl,
5435: -- igc_cc_periods_v cp
5436: -- WHERE sob.set_of_books_id = p_sob_id
5437: -- AND gl.set_of_books_id = sob.set_of_books_id

Line 5446: FROM gl_sets_of_books sob,

5442: -- AND (p_prev_acct_date BETWEEN cp.start_date AND cp.end_date
5443: -- );
5444: SELECT distinct gl.period_year
5445: INTO l_orig_fiscal_year
5446: FROM gl_sets_of_books sob,
5447: gl_periods gl
5448: WHERE sob.set_of_books_id = p_sob_id
5449: AND gl.period_set_name= sob.period_set_name
5450: AND gl.period_type = sob.accounted_period_type

Line 5461: -- FROM gl_sets_of_books sob,

5457: -- one below as we are only
5458: -- interested in the fiscal years.
5459: -- SELECT DISTINCT cp.period_year
5460: -- INTO l_new_fiscal_year
5461: -- FROM gl_sets_of_books sob,
5462: -- gl_period_statuses_v gl,
5463: -- igc_cc_periods_v cp
5464: -- WHERE sob.set_of_books_id = p_sob_id
5465: -- AND gl.set_of_books_id = sob.set_of_books_id

Line 5474: FROM gl_sets_of_books sob,

5470: -- AND (p_acct_date BETWEEN cp.start_date AND cp.end_date
5471: -- );
5472: SELECT distinct gl.period_year
5473: INTO l_new_fiscal_year
5474: FROM gl_sets_of_books sob,
5475: gl_periods gl
5476: WHERE sob.set_of_books_id = p_sob_id
5477: AND gl.period_set_name= sob.period_set_name
5478: AND gl.period_type = sob.accounted_period_type

Line 5502: FROM gl_sets_of_books sob,

5498: -- view gl_period_statuses_v with
5499: -- gl_period_statuses
5500: SELECT count(*)
5501: INTO l_COUNT
5502: FROM gl_sets_of_books sob,
5503: gl_period_statuses gl,
5504: igc_cc_periods cp
5505: WHERE sob.set_of_books_id = p_sob_id
5506: AND gl.set_of_books_id = sob.set_of_books_id

Line 5608: FROM gl_sets_of_books sob,

5604: -- view gl_period_statuses_v with
5605: -- gl_period_statuses
5606: SELECT count(*)
5607: INTO l_COUNT
5608: FROM gl_sets_of_books sob,
5609: gl_period_statuses gl,
5610: igc_cc_periods cp
5611: WHERE sob.set_of_books_id = p_sob_id
5612: AND gl.set_of_books_id = sob.set_of_books_id

Line 5653: -- FROM gl_sets_of_books sob,

5649: -- one below as we are only
5650: -- interested in the fiscal years.
5651: -- SELECT DISTINCT cp.period_year
5652: -- INTO l_orig_fiscal_year
5653: -- FROM gl_sets_of_books sob,
5654: -- gl_period_statuses_v gl,
5655: -- igc_cc_periods_v cp
5656: -- WHERE sob.set_of_books_id = p_sob_id
5657: -- AND gl.set_of_books_id = sob.set_of_books_id

Line 5666: FROM gl_sets_of_books sob,

5662: -- AND (p_prev_acct_date BETWEEN cp.start_date AND cp.end_date
5663: -- );
5664: SELECT distinct gl.period_year
5665: INTO l_orig_fiscal_year
5666: FROM gl_sets_of_books sob,
5667: gl_periods gl
5668: WHERE sob.set_of_books_id = p_sob_id
5669: AND gl.period_set_name= sob.period_set_name
5670: AND gl.period_type = sob.accounted_period_type

Line 5681: -- FROM gl_sets_of_books sob,

5677: -- one below as we are only
5678: -- interested in the fiscal years.
5679: -- SELECT DISTINCT cp.period_year
5680: -- INTO l_new_fiscal_year
5681: -- FROM gl_sets_of_books sob,
5682: -- gl_period_statuses_v gl,
5683: -- igc_cc_periods_v cp
5684: -- WHERE sob.set_of_books_id = p_sob_id
5685: -- AND gl.set_of_books_id = sob.set_of_books_id

Line 5694: FROM gl_sets_of_books sob,

5690: -- AND (p_acct_date BETWEEN cp.start_date AND cp.end_date
5691: -- );
5692: SELECT distinct gl.period_year
5693: INTO l_new_fiscal_year
5694: FROM gl_sets_of_books sob,
5695: gl_periods gl
5696: WHERE sob.set_of_books_id = p_sob_id
5697: AND gl.period_set_name= sob.period_set_name
5698: AND gl.period_type = sob.accounted_period_type

Line 5722: FROM gl_sets_of_books sob,

5718: -- view gl_period_statuses_v with
5719: -- gl_period_statuses
5720: SELECT count(*)
5721: INTO l_COUNT
5722: FROM gl_sets_of_books sob,
5723: gl_period_statuses gl,
5724: igc_cc_periods cp
5725: WHERE sob.set_of_books_id = p_sob_id
5726: AND gl.set_of_books_id = sob.set_of_books_id

Line 6005: FROM gl_sets_of_books sob,

6001: -- view gl_period_statuses_v with
6002: -- gl_period_statuses
6003: SELECT count(*)
6004: INTO l_COUNT
6005: FROM gl_sets_of_books sob,
6006: gl_period_statuses gl,
6007: igc_cc_periods cp
6008: WHERE sob.set_of_books_id = p_sob_id
6009: AND gl.set_of_books_id = sob.set_of_books_id

Line 6115: -- FROM gl_sets_of_books sob,

6111: -- one below as we are only
6112: -- interested in the fiscal years.
6113: -- SELECT DISTINCT cp.period_year
6114: -- INTO l_orig_fiscal_year
6115: -- FROM gl_sets_of_books sob,
6116: -- gl_period_statuses_v gl,
6117: -- igc_cc_periods_v cp
6118: -- WHERE sob.set_of_books_id = p_sob_id
6119: -- AND gl.set_of_books_id = sob.set_of_books_id

Line 6129: FROM gl_sets_of_books sob,

6125: -- BETWEEN cp.start_date AND cp.end_date
6126: -- );
6127: SELECT distinct gl.period_year
6128: INTO l_orig_fiscal_year
6129: FROM gl_sets_of_books sob,
6130: gl_periods gl
6131: WHERE sob.set_of_books_id = p_sob_id
6132: AND gl.period_set_name= sob.period_set_name
6133: AND gl.period_type = sob.accounted_period_type

Line 6144: -- FROM gl_sets_of_books sob,

6140: -- one below as we are only
6141: -- interested in the fiscal years.
6142: -- SELECT DISTINCT cp.period_year
6143: -- INTO l_new_fiscal_year
6144: -- FROM gl_sets_of_books sob,
6145: -- gl_period_statuses_v gl,
6146: -- igc_cc_periods_v cp
6147: -- WHERE sob.set_of_books_id = p_sob_id
6148: -- AND gl.set_of_books_id = sob.set_of_books_id

Line 6158: FROM gl_sets_of_books sob,

6154: -- BETWEEN cp.start_date AND cp.end_date
6155: -- );
6156: SELECT distinct gl.period_year
6157: INTO l_new_fiscal_year
6158: FROM gl_sets_of_books sob,
6159: gl_periods gl
6160: WHERE sob.set_of_books_id = p_sob_id
6161: AND gl.period_set_name= sob.period_set_name
6162: AND gl.period_type = sob.accounted_period_type

Line 6357: FROM gl_sets_of_books sob,

6353: -- view gl_period_statuses_v with
6354: -- gl_period_statuses
6355: SELECT count(*)
6356: INTO l_COUNT
6357: FROM gl_sets_of_books sob,
6358: gl_period_statuses gl,
6359: igc_cc_periods cp
6360: WHERE sob.set_of_books_id = p_sob_id
6361: AND gl.set_of_books_id = sob.set_of_books_id

Line 6467: -- FROM gl_sets_of_books sob,

6463: -- one below as we are only
6464: -- interested in the fiscal years.
6465: -- SELECT DISTINCT cp.period_year
6466: -- INTO l_orig_fiscal_year
6467: -- FROM gl_sets_of_books sob,
6468: -- gl_period_statuses_v gl,
6469: -- igc_cc_periods_v cp
6470: -- WHERE sob.set_of_books_id = p_sob_id
6471: -- AND gl.set_of_books_id = sob.set_of_books_id

Line 6481: FROM gl_sets_of_books sob,

6477: -- BETWEEN cp.start_date AND cp.end_date
6478: -- );
6479: SELECT distinct gl.period_year
6480: INTO l_orig_fiscal_year
6481: FROM gl_sets_of_books sob,
6482: gl_periods gl
6483: WHERE sob.set_of_books_id = p_sob_id
6484: AND gl.period_set_name= sob.period_set_name
6485: AND gl.period_type = sob.accounted_period_type

Line 6496: -- FROM gl_sets_of_books sob,

6492: -- one below as we are only
6493: -- interested in the fiscal years.
6494: -- SELECT DISTINCT cp.period_year
6495: -- INTO l_new_fiscal_year
6496: -- FROM gl_sets_of_books sob,
6497: -- gl_period_statuses_v gl,
6498: -- igc_cc_periods_v cp
6499: -- WHERE sob.set_of_books_id = p_sob_id
6500: -- AND gl.set_of_books_id = sob.set_of_books_id

Line 6510: FROM gl_sets_of_books sob,

6506: -- BETWEEN cp.start_date AND cp.end_date
6507: -- );
6508: SELECT distinct gl.period_year
6509: INTO l_new_fiscal_year
6510: FROM gl_sets_of_books sob,
6511: gl_periods gl
6512: WHERE sob.set_of_books_id = p_sob_id
6513: AND gl.period_set_name= sob.period_set_name
6514: AND gl.period_type = sob.accounted_period_type