APPS.XTR_REVAL_PROCESS_P dependencies on XTR_BATCHES

Line 42: select XTR_BATCHES_S.NEXTVAL

38: im_nos_of_days NUMBER;
39: l_sysdate DATE :=trunc(sysdate);
40:
41: cursor BATCH is
42: select XTR_BATCHES_S.NEXTVAL
43: from DUAL;
44:
45: cursor BATCH_EXIST is
46: select 1

Line 47: from XTR_BATCHES

43: from DUAL;
44:
45: cursor BATCH_EXIST is
46: select 1
47: from XTR_BATCHES
48: where BATCH_ID = l_batch_id;
49:
50: l_exist number;
51:

Line 148: insert into XTR_BATCHES

144: open BATCH;
145: fetch BATCH into p_BATCH_ID;
146: close BATCH;
147:
148: insert into XTR_BATCHES
149: (batch_id, company_code, period_start, period_end, created_by, creation_date,
150: last_updated_by, last_update_date, last_update_login, gl_group_id, upgrade_batch)
151: values
152: (p_BATCH_ID, l_company, nvl(l_start_date, to_date('01/01/1980', 'DD/MM/YYYY')),

Line 159: update XTR_BATCHES

155:
156: l_batch_id := p_BATCH_ID;
157: else
158: p_BATCH_ID := l_batch_id;
159: update XTR_BATCHES
160: set last_updated_by = fnd_global.user_id,
161: last_update_date = l_sysdate
162: where BATCH_ID = l_batch_id;
163: end if;

Line 341: From XTR_BATCHES CUR, XTR_BATCHES PRE,

337: p_batch_id IN NUMBER) IS
338:
339: Cursor CHK_PRE_BATCH is
340: Select 'Y'
341: From XTR_BATCHES CUR, XTR_BATCHES PRE,
342: XTR_BATCH_EVENTS EV
343: Where cur.batch_id = p_batch_id
344: and cur.company_code = pre.company_code
345: and (( cur.batch_id > pre.batch_id

Line 583: from xtr_batches

579: set_call_by_curr;
580:
581: select PERIOD_END, COMPANY_CODE, PERIOD_START
582: into l_batch_end, l_company_code, l_batch_start
583: from xtr_batches
584: where BATCH_ID = p_batch_id;
585:
586: select PARAMETER_VALUE_CODE into l_accounting
587: from xtr_company_parameters

Line 4118: l_batch_id xtr_batches.BATCH_ID%type; -- previous batch id

4114: p_ni_disc_amt OUT NOCOPY NUMBER,
4115: p_cumm_unrel_gl OUT NOCOPY NUMBER,
4116: p_reval_rate OUT NOCOPY NUMBER) IS
4117:
4118: l_batch_id xtr_batches.BATCH_ID%type; -- previous batch id
4119: l_found boolean := FALSE;
4120: r_err_log err_log; -- record type
4121: retcode NUMBER;
4122: l_buf Varchar2(500);

Line 4779: from xtr_batches

4775: rec IN xtr_revl_rec) return NUMBER is
4776:
4777: cursor c_batchid is
4778: select batch_id
4779: from xtr_batches
4780: where COMPANY_CODE = rec.company_code
4781: and PERIOD_END = (select max(b.period_end)
4782: from xtr_batches b, xtr_revaluation_details r
4783: where b.BATCH_ID <> rec.batch_id

Line 4782: from xtr_batches b, xtr_revaluation_details r

4778: select batch_id
4779: from xtr_batches
4780: where COMPANY_CODE = rec.company_code
4781: and PERIOD_END = (select max(b.period_end)
4782: from xtr_batches b, xtr_revaluation_details r
4783: where b.BATCH_ID <> rec.batch_id
4784: and r.deal_no = rec.deal_no
4785: and b.batch_id = r.batch_id)
4786: and nvl(upgrade_batch, 'N') <> 'Y'

Line 5536: XTR_BATCHES B

5532:
5533: cursor c_fx is
5534: select 'Y'
5535: from XTR_REVALUATION_DETAILS R,
5536: XTR_BATCHES B
5537: where r.deal_no = rec.deal_no
5538: and r.batch_id = b.batch_id
5539: and r.batch_id <> rec.batch_id
5540: and b.upgrade_batch <> 'Y';

Line 6037: from xtr_batches b, xtr_revaluation_details r

6033: /* that includes the FX deals */
6034: /***************************************************/
6035: cursor C_LAST_END_DATE is
6036: select max(b.period_end)
6037: from xtr_batches b, xtr_revaluation_details r
6038: where b.batch_id = r.batch_id
6039: and b.company_code = rec.company_code
6040: and b.batch_type is NULL
6041: and r.deal_no = rec.deal_no;

Line 6082: from xtr_batches

6078: where deal_no = rec.deal_no
6079: and effective_date < rec.revldate
6080: union
6081: select period_end reval_date
6082: from xtr_batches
6083: where batch_id = rec.batch_id
6084: order by reval_date asc;
6085:
6086: l_first BOOLEAN;

Line 6194: from xtr_batches

6190: where deal_no = rec.deal_no
6191: and effective_date < rec.revldate
6192: union
6193: select period_end reval_date
6194: from xtr_batches
6195: where batch_id = rec.batch_id
6196: order by reval_date asc;
6197:
6198: -- Bug 4234575 This cursor has been added so that totally reclassified