DBA Data[Home] [Help]

APPS.XTR_CLEAR_JOURNAL_PROCESS_P dependencies on XTR_CLEAR_JOURNAL_PROCESS_P

Line 1: PACKAGE BODY XTR_CLEAR_JOURNAL_PROCESS_P as

1: PACKAGE BODY XTR_CLEAR_JOURNAL_PROCESS_P as
2: /* $Header: xtrcljnb.pls 120.3 2005/06/29 06:01:05 badiredd ship $ */
3: ----------------------------------------------------------------------------------------------------------------
4:
5: /* ---------------------------------------------------------------------

Line 81: xtr_debug_pkg.debug('>>XTR_CLEAR_JOURNAL_PROCESS_P.Clear_Journal_Process');

77: --
78: BEGIN
79: -- xtr_debug_pkg.enable_debug (null,null);
80: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
81: xtr_debug_pkg.debug('>>XTR_CLEAR_JOURNAL_PROCESS_P.Clear_Journal_Process');
82: END IF;
83:
84: Open BATCH_SEQ;
85: Fetch BATCH_SEQ into p_curr_batch_id;

Line 123: xtr_debug_pkg.debug('<

119:
120: Clear_Journals(G_company_code,G_batch_id);
121:
122: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
123: xtr_debug_pkg.debug('< 124: END IF;
125:
126: Fetch BATCH_SEQ into p_curr_batch_id;
127: END LOOP;

Line 183: xtr_debug_pkg.debug('>>XTR_CLEAR_JOURNAL_PROCESS_P.Clear_Journals');

179: p_event_code XTR_BATCH_EVENTS.EVENT_CODE%TYPE :='JRNLGN';
180: --
181: Begin
182: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
183: xtr_debug_pkg.debug('>>XTR_CLEAR_JOURNAL_PROCESS_P.Clear_Journals');
184: xtr_debug_pkg.debug('CLEAR_JOURNALS: ' || 'Current Batch = ' || to_char(in_batch_id));
185: END IF;
186:
187: -- Turn BATCH_ID to null value once we delete journals.

Line 220: xtr_debug_pkg.debug('<

216:
217: Commit;
218:
219: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
220: xtr_debug_pkg.debug('< 221: END IF;
222:
223: End CLEAR_JOURNALS;
224:

Line 226: END XTR_CLEAR_JOURNAL_PROCESS_P;

222:
223: End CLEAR_JOURNALS;
224:
225: --------------------------------------------------------------------------------------------------------------------------
226: END XTR_CLEAR_JOURNAL_PROCESS_P;