75: v_batch_type Xtr_Batches.Batch_Type%Type;
76:
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:
76:
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;
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;
118: -- G_end_date := p_period_end;
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('<
125:
126: Fetch BATCH_SEQ into p_curr_batch_id;
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('<
125:
126: Fetch BATCH_SEQ into p_curr_batch_id;
127: END LOOP;
178: l_batch_type XTR_BATCHES.batch_type%TYPE := null;
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:
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.
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.
188: Update XTR_DEAL_DATE_AMOUNTS
215: End If;
216:
217: Commit;
218:
219: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
220: xtr_debug_pkg.debug('<
222:
223: End CLEAR_JOURNALS;
216:
217: Commit;
218:
219: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
220: xtr_debug_pkg.debug('<
222:
223: End CLEAR_JOURNALS;
224: