APPS.XTR_CLEAR_JOURNAL_PROCESS_P dependencies on XTR_BATCHES

Line 32: p_curr_batch_id XTR_BATCHES.BATCH_ID%TYPE;

28: p_company_code IN VARCHAR2,
29: p_batch_id_from IN NUMBER,
30: p_batch_id_to IN NUMBER) IS
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:

Line 39: From XTR_BATCHES

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
40: Where company_code = p_company_code
41: and batch_id between p_batch_id_from and p_batch_id_to
42: Order by batch_id desc;
43:

Line 46: From XTR_BATCHES

42: Order by batch_id desc;
43:
44: CURSOR BATCH_PERIOD is
45: Select period_start, period_end
46: From XTR_BATCHES
47: Where batch_id = p_curr_batch_id;
48:
49: CURSOR CHK_TRANS_GL is -- Check if the current batch has been transferred
50: Select 1

Line 51: From XTR_BATCHES

47: Where batch_id = p_curr_batch_id;
48:
49: CURSOR CHK_TRANS_GL is -- Check if the current batch has been transferred
50: Select 1
51: From XTR_BATCHES
52: Where batch_id = p_curr_batch_id
53: and gl_group_id is not null;
54:
55: CURSOR FIND_LATE_BATCH is

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 64: l_late_batch_id XTR_BATCHES.BATCH_ID%TYPE;

60: and b.company_code = p_company_code
61: and e.event_code = p_event_code
62: and b.batch_type is null
63: order by e.batch_id asc;
64: l_late_batch_id XTR_BATCHES.BATCH_ID%TYPE;
65:
66: /* CURSOR CHK_LATE_BATCH is
67: Select 1
68: From XTR_BATCHES

Line 68: From XTR_BATCHES

64: l_late_batch_id XTR_BATCHES.BATCH_ID%TYPE;
65:
66: /* CURSOR CHK_LATE_BATCH is
67: Select 1
68: From XTR_BATCHES
69: where batch_id = l_late_batch_id
70: and gl_group_id is not null; */
71:
72: ex_late_batch EXCEPTION;

Line 75: v_batch_type Xtr_Batches.Batch_Type%Type;

71:
72: ex_late_batch EXCEPTION;
73: ex_trans_gl EXCEPTION;
74: l_temp NUMBER;
75: v_batch_type Xtr_Batches.Batch_Type%Type;
76:
77: --
78: BEGIN
79: -- xtr_debug_pkg.enable_debug (null,null);

Line 100: From Xtr_Batches

96: End if;
97:
98: Select batch_type
99: Into v_batch_type
100: From Xtr_Batches
101: Where batch_id = p_curr_batch_id;
102:
103: If nvl(v_batch_type, 'R') <> 'J' then
104: -- Raise exception if the deleted batch id which has later batch id existed.

Line 175: from xtr_batches

171: in_batch_id IN NUMBER) is
172:
173: Cursor GET_BATCH_TYPE is
174: Select batch_type
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';

Line 178: l_batch_type XTR_BATCHES.batch_type%TYPE := null;

174: Select batch_type
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

Line 206: -- of batch from XTR_BATCHES also.

202: and event_code = p_event_code;
203:
204: -- Flex Journals.
205: -- If Non-Reval/Non-Accrual related batch, need to remove existence
206: -- of batch from XTR_BATCHES also.
207:
208: Open GET_BATCH_TYPE;
209: Fetch GET_BATCH_TYPE into l_batch_type;
210: Close GET_BATCH_TYPE;

Line 213: Delete from XTR_BATCHES

209: Fetch GET_BATCH_TYPE into l_batch_type;
210: Close GET_BATCH_TYPE;
211:
212: If (nvl(l_batch_type,'X') = 'J') then
213: Delete from XTR_BATCHES
214: Where batch_id = in_batch_id;
215: End If;
216:
217: Commit;