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
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
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