APPS.XTR_CLEAR_JOURNAL_PROCESS_P dependencies on XTR_BATCH_EVENTS

Line 35: p_event_code XTR_BATCH_EVENTS.EVENT_CODE%TYPE :='JRNLGN';

31:
32: p_curr_batch_id XTR_BATCHES.BATCH_ID%TYPE;
33: p_period_start DATE;
34: p_period_end DATE;
35: p_event_code XTR_BATCH_EVENTS.EVENT_CODE%TYPE :='JRNLGN';
36:
37: CURSOR BATCH_SEQ is
38: Select batch_id
39: From XTR_BATCHES

Line 57: From XTR_BATCHES B, XTR_BATCH_EVENTS E

53: and gl_group_id is not null;
54:
55: CURSOR FIND_LATE_BATCH is
56: Select e.batch_id
57: From XTR_BATCHES B, XTR_BATCH_EVENTS E
58: Where b.batch_id = e.batch_id
59: and e.batch_id > p_curr_batch_id
60: and b.company_code = p_company_code
61: and e.event_code = p_event_code

Line 179: p_event_code XTR_BATCH_EVENTS.EVENT_CODE%TYPE :='JRNLGN';

175: from xtr_batches
176: where batch_id = in_batch_id;
177:
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');

Line 199: -- Update XTR_BATCH_EVENTS, remove the journal_generate row

195: Delete from XTR_JOURNALS
196: Where company_code = in_company
197: and batch_id = in_batch_id;
198:
199: -- Update XTR_BATCH_EVENTS, remove the journal_generate row
200: Delete from XTR_BATCH_EVENTS
201: Where batch_id = in_batch_id
202: and event_code = p_event_code;
203:

Line 200: Delete from XTR_BATCH_EVENTS

196: Where company_code = in_company
197: and batch_id = in_batch_id;
198:
199: -- Update XTR_BATCH_EVENTS, remove the journal_generate row
200: Delete from XTR_BATCH_EVENTS
201: Where batch_id = in_batch_id
202: and event_code = p_event_code;
203:
204: -- Flex Journals.