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 2026: l_enable_budg_control_flag gl_sets_of_books.enable_budgetary_control_flag%TYPE;

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

Line 2070: l_currency_code gl_sets_of_books.currency_code%TYPE;

2066: l_cc_interface_rec igc_cc_interface%ROWTYPE;
2067:
2068: l_debug VARCHAR2(1);
2069:
2070: l_currency_code gl_sets_of_books.currency_code%TYPE;
2071: l_error_message VARCHAR2(2000);
2072:
2073: l_cc_apprvl_status_old igc_cc_headers.cc_apprvl_status%TYPE;
2074: l_encumbrance_status_old VARCHAR2(1);

Line 2457: FROM gl_sets_of_books

2453:
2454: BEGIN
2455: SELECT enable_budgetary_control_flag,currency_code
2456: INTO l_enable_budg_control_flag, l_currency_code
2457: FROM gl_sets_of_books
2458: WHERE set_of_books_id = l_cc_headers_rec.set_of_books_id;
2459: EXCEPTION
2460: WHEN NO_DATA_FOUND
2461: THEN

Line 3989: l_enable_budg_control_flag gl_sets_of_books.enable_budgetary_control_flag%TYPE;

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

Line 4061: FROM gl_sets_of_books

4057: BEGIN
4058:
4059: SELECT NVL(enable_budgetary_control_flag,'N')
4060: INTO l_enable_budg_control_flag
4061: FROM gl_sets_of_books
4062: WHERE set_of_books_id = p_sob_id;
4063:
4064: EXCEPTION
4065:

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

4689: e_cc_not_found EXCEPTION;
4690: e_no_det_pf EXCEPTION;
4691: e_amt_mismatch EXCEPTION;
4692:
4693: l_sbc_enable_flag gl_sets_of_books.enable_budgetary_control_flag%TYPE := 'N';
4694: l_cbc_enable_flag igc_cc_bc_enable.cc_bc_enable_flag%TYPE := 'N';
4695: -- l_cc_prov_encmbrnc_flag igc_cc_encmbrnc_ctrls.cc_prov_encmbrnc_enable_flag%TYPE := 'N';
4696: -- l_cc_conf_encmbrnc_flag igc_cc_encmbrnc_ctrls.cc_conf_encmbrnc_enable_flag%TYPE := 'N';
4697: l_cc_prov_encmbrnc_flag VARCHAR2(1);

Line 4882: FROM gl_sets_of_books

4878:
4879: BEGIN
4880: SELECT NVL(enable_budgetary_control_flag,'N')
4881: INTO l_sbc_enable_flag
4882: FROM gl_sets_of_books
4883: WHERE set_of_books_id = p_sob_id;
4884: EXCEPTION
4885: WHEN NO_DATA_FOUND THEN
4886: x_valid_cc := FND_API.G_FALSE;

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

4975:
4976: BEGIN
4977: SELECT count(*)
4978: INTO l_COUNT
4979: FROM gl_sets_of_books sob, gl_periods gp, igc_cc_periods cp
4980: WHERE sob.set_of_books_id = p_sob_id
4981: AND sob.period_set_name = gp.period_set_name
4982: AND cp.org_id = p_org_id
4983: AND gp.period_set_name = cp.period_set_name

Line 5019: FROM gl_sets_of_books sob,

5015:
5016: BEGIN
5017: SELECT count(*)
5018: INTO l_COUNT
5019: FROM gl_sets_of_books sob,
5020: gl_period_statuses gl,
5021: igc_cc_periods cp
5022: WHERE sob.set_of_books_id = p_sob_id
5023: AND gl.set_of_books_id = sob.set_of_books_id

Line 5224: FROM gl_sets_of_books sob,

5220: -- view gl_period_statuses_v with
5221: -- gl_period_statuses
5222: SELECT count(*)
5223: INTO l_COUNT
5224: FROM gl_sets_of_books sob,
5225: gl_period_statuses gl,
5226: igc_cc_periods cp
5227: WHERE sob.set_of_books_id = p_sob_id
5228: AND gl.set_of_books_id = sob.set_of_books_id

Line 5329: FROM gl_sets_of_books sob,

5325: -- view gl_period_statuses_v with
5326: -- gl_period_statuses
5327: SELECT count(*)
5328: INTO l_COUNT
5329: FROM gl_sets_of_books sob,
5330: gl_period_statuses gl,
5331: igc_cc_periods cp
5332: WHERE sob.set_of_books_id = p_sob_id
5333: AND gl.set_of_books_id = sob.set_of_books_id

Line 5375: -- FROM gl_sets_of_books sob,

5371: -- one below as we are only
5372: -- interested in the fiscal years.
5373: -- SELECT DISTINCT cp.period_year
5374: -- INTO l_orig_fiscal_year
5375: -- FROM gl_sets_of_books sob,
5376: -- gl_period_statuses_v gl,
5377: -- igc_cc_periods_v cp
5378: -- WHERE sob.set_of_books_id = p_sob_id
5379: -- AND gl.set_of_books_id = sob.set_of_books_id

Line 5388: FROM gl_sets_of_books sob,

5384: -- AND (p_prev_acct_date BETWEEN cp.start_date AND cp.end_date
5385: -- );
5386: SELECT distinct gl.period_year
5387: INTO l_orig_fiscal_year
5388: FROM gl_sets_of_books sob,
5389: gl_periods gl
5390: WHERE sob.set_of_books_id = p_sob_id
5391: AND gl.period_set_name= sob.period_set_name
5392: AND gl.period_type = sob.accounted_period_type

Line 5403: -- FROM gl_sets_of_books sob,

5399: -- one below as we are only
5400: -- interested in the fiscal years.
5401: -- SELECT DISTINCT cp.period_year
5402: -- INTO l_new_fiscal_year
5403: -- FROM gl_sets_of_books sob,
5404: -- gl_period_statuses_v gl,
5405: -- igc_cc_periods_v cp
5406: -- WHERE sob.set_of_books_id = p_sob_id
5407: -- AND gl.set_of_books_id = sob.set_of_books_id

Line 5416: FROM gl_sets_of_books sob,

5412: -- AND (p_acct_date BETWEEN cp.start_date AND cp.end_date
5413: -- );
5414: SELECT distinct gl.period_year
5415: INTO l_new_fiscal_year
5416: FROM gl_sets_of_books sob,
5417: gl_periods gl
5418: WHERE sob.set_of_books_id = p_sob_id
5419: AND gl.period_set_name= sob.period_set_name
5420: AND gl.period_type = sob.accounted_period_type

Line 5444: FROM gl_sets_of_books sob,

5440: -- view gl_period_statuses_v with
5441: -- gl_period_statuses
5442: SELECT count(*)
5443: INTO l_COUNT
5444: FROM gl_sets_of_books sob,
5445: gl_period_statuses gl,
5446: igc_cc_periods cp
5447: WHERE sob.set_of_books_id = p_sob_id
5448: AND gl.set_of_books_id = sob.set_of_books_id

Line 5550: FROM gl_sets_of_books sob,

5546: -- view gl_period_statuses_v with
5547: -- gl_period_statuses
5548: SELECT count(*)
5549: INTO l_COUNT
5550: FROM gl_sets_of_books sob,
5551: gl_period_statuses gl,
5552: igc_cc_periods cp
5553: WHERE sob.set_of_books_id = p_sob_id
5554: AND gl.set_of_books_id = sob.set_of_books_id

Line 5595: -- FROM gl_sets_of_books sob,

5591: -- one below as we are only
5592: -- interested in the fiscal years.
5593: -- SELECT DISTINCT cp.period_year
5594: -- INTO l_orig_fiscal_year
5595: -- FROM gl_sets_of_books sob,
5596: -- gl_period_statuses_v gl,
5597: -- igc_cc_periods_v cp
5598: -- WHERE sob.set_of_books_id = p_sob_id
5599: -- AND gl.set_of_books_id = sob.set_of_books_id

Line 5608: FROM gl_sets_of_books sob,

5604: -- AND (p_prev_acct_date BETWEEN cp.start_date AND cp.end_date
5605: -- );
5606: SELECT distinct gl.period_year
5607: INTO l_orig_fiscal_year
5608: FROM gl_sets_of_books sob,
5609: gl_periods gl
5610: WHERE sob.set_of_books_id = p_sob_id
5611: AND gl.period_set_name= sob.period_set_name
5612: AND gl.period_type = sob.accounted_period_type

Line 5623: -- FROM gl_sets_of_books sob,

5619: -- one below as we are only
5620: -- interested in the fiscal years.
5621: -- SELECT DISTINCT cp.period_year
5622: -- INTO l_new_fiscal_year
5623: -- FROM gl_sets_of_books sob,
5624: -- gl_period_statuses_v gl,
5625: -- igc_cc_periods_v cp
5626: -- WHERE sob.set_of_books_id = p_sob_id
5627: -- AND gl.set_of_books_id = sob.set_of_books_id

Line 5636: FROM gl_sets_of_books sob,

5632: -- AND (p_acct_date BETWEEN cp.start_date AND cp.end_date
5633: -- );
5634: SELECT distinct gl.period_year
5635: INTO l_new_fiscal_year
5636: FROM gl_sets_of_books sob,
5637: gl_periods gl
5638: WHERE sob.set_of_books_id = p_sob_id
5639: AND gl.period_set_name= sob.period_set_name
5640: AND gl.period_type = sob.accounted_period_type

Line 5664: FROM gl_sets_of_books sob,

5660: -- view gl_period_statuses_v with
5661: -- gl_period_statuses
5662: SELECT count(*)
5663: INTO l_COUNT
5664: FROM gl_sets_of_books sob,
5665: gl_period_statuses gl,
5666: igc_cc_periods cp
5667: WHERE sob.set_of_books_id = p_sob_id
5668: AND gl.set_of_books_id = sob.set_of_books_id

Line 5945: FROM gl_sets_of_books sob,

5941: -- view gl_period_statuses_v with
5942: -- gl_period_statuses
5943: SELECT count(*)
5944: INTO l_COUNT
5945: FROM gl_sets_of_books sob,
5946: gl_period_statuses gl,
5947: igc_cc_periods cp
5948: WHERE sob.set_of_books_id = p_sob_id
5949: AND gl.set_of_books_id = sob.set_of_books_id

Line 6055: -- FROM gl_sets_of_books sob,

6051: -- one below as we are only
6052: -- interested in the fiscal years.
6053: -- SELECT DISTINCT cp.period_year
6054: -- INTO l_orig_fiscal_year
6055: -- FROM gl_sets_of_books sob,
6056: -- gl_period_statuses_v gl,
6057: -- igc_cc_periods_v cp
6058: -- WHERE sob.set_of_books_id = p_sob_id
6059: -- AND gl.set_of_books_id = sob.set_of_books_id

Line 6069: FROM gl_sets_of_books sob,

6065: -- BETWEEN cp.start_date AND cp.end_date
6066: -- );
6067: SELECT distinct gl.period_year
6068: INTO l_orig_fiscal_year
6069: FROM gl_sets_of_books sob,
6070: gl_periods gl
6071: WHERE sob.set_of_books_id = p_sob_id
6072: AND gl.period_set_name= sob.period_set_name
6073: AND gl.period_type = sob.accounted_period_type

Line 6084: -- FROM gl_sets_of_books sob,

6080: -- one below as we are only
6081: -- interested in the fiscal years.
6082: -- SELECT DISTINCT cp.period_year
6083: -- INTO l_new_fiscal_year
6084: -- FROM gl_sets_of_books sob,
6085: -- gl_period_statuses_v gl,
6086: -- igc_cc_periods_v cp
6087: -- WHERE sob.set_of_books_id = p_sob_id
6088: -- AND gl.set_of_books_id = sob.set_of_books_id

Line 6098: FROM gl_sets_of_books sob,

6094: -- BETWEEN cp.start_date AND cp.end_date
6095: -- );
6096: SELECT distinct gl.period_year
6097: INTO l_new_fiscal_year
6098: FROM gl_sets_of_books sob,
6099: gl_periods gl
6100: WHERE sob.set_of_books_id = p_sob_id
6101: AND gl.period_set_name= sob.period_set_name
6102: AND gl.period_type = sob.accounted_period_type

Line 6295: FROM gl_sets_of_books sob,

6291: -- view gl_period_statuses_v with
6292: -- gl_period_statuses
6293: SELECT count(*)
6294: INTO l_COUNT
6295: FROM gl_sets_of_books sob,
6296: gl_period_statuses gl,
6297: igc_cc_periods cp
6298: WHERE sob.set_of_books_id = p_sob_id
6299: AND gl.set_of_books_id = sob.set_of_books_id

Line 6405: -- FROM gl_sets_of_books sob,

6401: -- one below as we are only
6402: -- interested in the fiscal years.
6403: -- SELECT DISTINCT cp.period_year
6404: -- INTO l_orig_fiscal_year
6405: -- FROM gl_sets_of_books sob,
6406: -- gl_period_statuses_v gl,
6407: -- igc_cc_periods_v cp
6408: -- WHERE sob.set_of_books_id = p_sob_id
6409: -- AND gl.set_of_books_id = sob.set_of_books_id

Line 6419: FROM gl_sets_of_books sob,

6415: -- BETWEEN cp.start_date AND cp.end_date
6416: -- );
6417: SELECT distinct gl.period_year
6418: INTO l_orig_fiscal_year
6419: FROM gl_sets_of_books sob,
6420: gl_periods gl
6421: WHERE sob.set_of_books_id = p_sob_id
6422: AND gl.period_set_name= sob.period_set_name
6423: AND gl.period_type = sob.accounted_period_type

Line 6434: -- FROM gl_sets_of_books sob,

6430: -- one below as we are only
6431: -- interested in the fiscal years.
6432: -- SELECT DISTINCT cp.period_year
6433: -- INTO l_new_fiscal_year
6434: -- FROM gl_sets_of_books sob,
6435: -- gl_period_statuses_v gl,
6436: -- igc_cc_periods_v cp
6437: -- WHERE sob.set_of_books_id = p_sob_id
6438: -- AND gl.set_of_books_id = sob.set_of_books_id

Line 6448: FROM gl_sets_of_books sob,

6444: -- BETWEEN cp.start_date AND cp.end_date
6445: -- );
6446: SELECT distinct gl.period_year
6447: INTO l_new_fiscal_year
6448: FROM gl_sets_of_books sob,
6449: gl_periods gl
6450: WHERE sob.set_of_books_id = p_sob_id
6451: AND gl.period_set_name= sob.period_set_name
6452: AND gl.period_type = sob.accounted_period_type