DBA Data[Home] [Help]

APPS.GL_BUDGET_UTILS_PKG dependencies on GL_BUDGET_FROZEN_RANGES

Line 190: FROM gl_code_combinations cc, gl_budget_frozen_ranges bfr

186: ledger_id NUMBER,
187: currency_code VARCHAR2) RETURN BOOLEAN IS
188: CURSOR chk_frozen (entity_id NUMBER) IS
189: SELECT 'Frozen'
190: FROM gl_code_combinations cc, gl_budget_frozen_ranges bfr
191: WHERE bfr.budget_version_id = frozen_account.budget_version_id
192: AND bfr.budget_entity_id = entity_id
193: AND cc.code_combination_id = frozen_account.code_combination_id
194: AND cc.chart_of_accounts_id = frozen_account.coa_id

Line 411: SELECT GL_BUDGET_FROZEN_RANGES_S.NEXTVAL

407:
408: FUNCTION get_unique_id RETURN NUMBER IS
409: -- get unique id for range_id
410: CURSOR c_getid IS
411: SELECT GL_BUDGET_FROZEN_RANGES_S.NEXTVAL
412: FROM dual;
413: id number;
414:
415: BEGIN

Line 425: fnd_message.set_token('SEQUENCE', 'GL_BUDGET_FROZEN_RANGES_S');

421: RETURN( id );
422: ELSE
423: CLOSE c_getid;
424: fnd_message.set_name('SQLGL', 'GL_ERROR_GETTING_UNIQUE_ID');
425: fnd_message.set_token('SEQUENCE', 'GL_BUDGET_FROZEN_RANGES_S');
426: app_exception.raise_exception;
427: END IF;
428:
429: EXCEPTION