eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.XTR_JOURNAL_PROCESS_P dependencies on XTR_BATCHES

Line 163: p_curr_batch_id XTR_BATCHES.BATCH_ID%TYPE;

159: p_batch_id_from IN NUMBER,
160: p_batch_id_to IN NUMBER,
161: p_cutoff_date IN DATE) IS
162: --
163: p_curr_batch_id XTR_BATCHES.BATCH_ID%TYPE;
164: p_upgrade_batch XTR_BATCHES.UPGRADE_BATCH%TYPE;
165: p_period_start DATE;
166: p_period_end DATE;
167:

Line 164: p_upgrade_batch XTR_BATCHES.UPGRADE_BATCH%TYPE;

160: p_batch_id_to IN NUMBER,
161: p_cutoff_date IN DATE) IS
162: --
163: p_curr_batch_id XTR_BATCHES.BATCH_ID%TYPE;
164: p_upgrade_batch XTR_BATCHES.UPGRADE_BATCH%TYPE;
165: p_period_start DATE;
166: p_period_end DATE;
167:
168:

Line 171: From XTR_BATCHES

167:
168:
169: CURSOR BATCH_SEQ is
170: Select batch_id
171: From XTR_BATCHES
172: Where company_code = p_company_code
173: and batch_type is null
174: and batch_id between nvl(p_batch_id_from, batch_id) and nvl(p_batch_id_to, batch_id)
175: Order by batch_id asc;

Line 179: From XTR_BATCHES

175: Order by batch_id asc;
176:
177: CURSOR BATCH_PERIOD is
178: Select period_start, period_end, upgrade_batch
179: From XTR_BATCHES
180: Where batch_id = p_curr_batch_id;
181:
182: CURSOR FIND_USER (fnd_user_id in number) is
183: select dealer_code

Line 203: from XTR_BATCHES PRE,

199: and b.parameter_code = 'ACCNT_SUSAC';
200: --
201: CURSOR FIND_PRE_BATCH is -- Find the previous Non-Reval/Non-Accrual related Batch ID
202: select pre.batch_id
203: from XTR_BATCHES PRE,
204: XTR_BATCHES CUR
205: where cur.company_code = p_company_code
206: and cur.batch_id = p_curr_batch_id
207: and pre.company_code = cur.company_code

Line 204: XTR_BATCHES CUR

200: --
201: CURSOR FIND_PRE_BATCH is -- Find the previous Non-Reval/Non-Accrual related Batch ID
202: select pre.batch_id
203: from XTR_BATCHES PRE,
204: XTR_BATCHES CUR
205: where cur.company_code = p_company_code
206: and cur.batch_id = p_curr_batch_id
207: and pre.company_code = cur.company_code
208: and cur.period_start = (pre.period_end + 1)

Line 212: l_pre_batch_id XTR_BATCHES.BATCH_ID%TYPE;

208: and cur.period_start = (pre.period_end + 1)
209: and pre.upgrade_batch <> 'Y'
210: and pre.batch_type is null;
211:
212: l_pre_batch_id XTR_BATCHES.BATCH_ID%TYPE;
213:
214: CURSOR CHK_EARLY_BATCH is -- chck if the early batch id been generated journal
215: select 1
216: from XTR_BATCH_EVENTS

Line 243: Select XTR_BATCHES_S.NEXTVAL

239:
240: -- Added for flex journals. 2404342. Creation of a new journal only batch.
241:
242: Cursor GEN_BATCH is
243: Select XTR_BATCHES_S.NEXTVAL
244: from DUAL;
245:
246: l_retcode NUMBER := 0;
247: l_warn_flag BOOLEAN;

Line 408: Insert into XTR_BATCHES(batch_id, company_code, period_start, period_end,

404: Close GEN_BATCH;
405:
406: -- Insert new row to XTR_BATCH when new batch process staring from accrual
407:
408: Insert into XTR_BATCHES(batch_id, company_code, period_start, period_end,
409: gl_group_id, upgrade_batch, created_by, creation_date,
410: last_updated_by, last_update_date, last_update_login, batch_type)
411: values (p_curr_batch_id, p_company_code, p_cutoff_date, p_cutoff_date,
412: null, 'N', fnd_global.user_id, sysdate,

Line 1110: XTR_BATCHES b

1106: -----------------------------------
1107: cursor UPGRADE_REVAL is
1108: select b.upgrade_batch
1109: from XTR_REVALUATION_DETAILS a,
1110: XTR_BATCHES b
1111: where a.company_code = in_company
1112: and a.batch_id = b.batch_id
1113: and nvl(b.upgrade_batch,'N') = 'Y';
1114: --

Line 2972: -- In such an event, do not create records in xtr_batches and

2968: If (nvl(l_ret_value,0) < 2) then
2969:
2970: -- Bug 3805480 begin
2971: -- Added condition to check for RA batch w/o jrnl entries.
2972: -- In such an event, do not create records in xtr_batches and
2973: -- xtr_batch_events table for it.
2974:
2975: If (nvl(in_source_option,'R') = 'J') then
2976: l_empty := 0;

Line 3039: Update xtr_batches

3035: CLOSE C_NRA_PERIOD_FROM;
3036:
3037: If l_nra_period_from is not null then
3038:
3039: Update xtr_batches
3040: set period_start = l_nra_period_from
3041: where batch_id = in_batch_id;
3042:
3043: End if;

Line 3322: from xtr_batches

3318: and (party_code = nvl(p_company_code, party_code));
3319:
3320: Cursor BATCHES_BY_BID_RANGE (l_company_code IN VARCHAR2) is
3321: Select batch_id
3322: from xtr_batches
3323: where batch_id between nvl(p_batch_id_from, batch_id) and nvl(p_batch_id_to, batch_id)
3324: and batch_id in (Select BA.batch_id
3325: from xtr_batches BA,
3326: xtr_batch_events BE

Line 3325: from xtr_batches BA,

3321: Select batch_id
3322: from xtr_batches
3323: where batch_id between nvl(p_batch_id_from, batch_id) and nvl(p_batch_id_to, batch_id)
3324: and batch_id in (Select BA.batch_id
3325: from xtr_batches BA,
3326: xtr_batch_events BE
3327: where BA.batch_id = BE.batch_id
3328: and BE.event_code = 'JRNLGN'
3329: and BA.company_code = l_company_code

Line 3339: from xtr_batches

3335: order by period_end, batch_id asc;
3336:
3337: Cursor BATCHES_BY_DATE (l_company_code IN VARCHAR2, l_cutoff_date IN DATE) is
3338: Select batch_id
3339: from xtr_batches
3340: where period_end <= nvl(l_cutoff_date, sysdate)
3341: and batch_id in (Select BA.batch_id
3342: from xtr_batches BA,
3343: xtr_batch_events BE

Line 3342: from xtr_batches BA,

3338: Select batch_id
3339: from xtr_batches
3340: where period_end <= nvl(l_cutoff_date, sysdate)
3341: and batch_id in (Select BA.batch_id
3342: from xtr_batches BA,
3343: xtr_batch_events BE
3344: where BA.batch_id = BE.batch_id
3345: and BE.event_code = 'JRNLGN'
3346: and BA.company_code = l_company_code