DBA Data[Home] [Help]

APPS.GL_AUTOREVERSE_DATE_PKG dependencies on GL_AUTOREVERSE_OPTIONS

Line 201: Error_Buffer := 'Invalid REVERSAL_DATE_CODE, '||X_Date_Rule||', in GL_AUTOREVERSE_OPTIONS.';

197: EXCEPTION
198: WHEN NORMAL_EXIT THEN
199: X_Reversal_Date := reversal_date;
200: WHEN WRONG_CRITERIA THEN
201: Error_Buffer := 'Invalid REVERSAL_DATE_CODE, '||X_Date_Rule||', in GL_AUTOREVERSE_OPTIONS.';
202: Raise GET_REV_PERIOD_DATE_FAILED;
203: WHEN OTHERS THEN
204: Error_Buffer := '.get_reversal_date.'||Error_Buffer;
205: Raise;

Line 247: FROM gl_autoreverse_options

243:
244: CURSOR get_criteria IS
245: SELECT decode(method_code,'C','Y','N'),
246: reversal_period_code,reversal_date_code
247: FROM gl_autoreverse_options
248: WHERE criteria_set_id = l_Criteria_Set_Id
249: AND je_category_name = X_Je_Category;
250:
251:

Line 608: FROM GL_LEDGERS gll, GL_AUTOREVERSE_OPTIONS glao

604: gll.consolidation_ledger_flag
605: INTO
606: X_Reversal_Method_code,
607: adb_flag, cons_flag
608: FROM GL_LEDGERS gll, GL_AUTOREVERSE_OPTIONS glao
609: WHERE gll.ledger_id = X_Ledger_Id
610: AND glao.criteria_set_id(+) = gll.Criteria_Set_Id
611: AND glao.je_category_name(+) = X_Category_Name;
612: