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 4101: l_batch_id xtr_batches.BATCH_ID%type; -- previous batch id

4097: p_ni_disc_amt OUT NOCOPY NUMBER,
4098: p_cumm_unrel_gl OUT NOCOPY NUMBER,
4099: p_reval_rate OUT NOCOPY NUMBER) IS
4100:
4101: l_batch_id xtr_batches.BATCH_ID%type; -- previous batch id
4102: l_found boolean := FALSE;
4103: r_err_log err_log; -- record type
4104: retcode NUMBER;
4105: l_buf Varchar2(500);

Line 4762: from xtr_batches

4758: rec IN xtr_revl_rec) return NUMBER is
4759:
4760: cursor c_batchid is
4761: select batch_id
4762: from xtr_batches
4763: where COMPANY_CODE = rec.company_code
4764: and PERIOD_END = (select max(b.period_end)
4765: from xtr_batches b, xtr_revaluation_details r
4766: where b.BATCH_ID <> rec.batch_id

Line 4765: from xtr_batches b, xtr_revaluation_details r

4761: select batch_id
4762: from xtr_batches
4763: where COMPANY_CODE = rec.company_code
4764: and PERIOD_END = (select max(b.period_end)
4765: from xtr_batches b, xtr_revaluation_details r
4766: where b.BATCH_ID <> rec.batch_id
4767: and r.deal_no = rec.deal_no
4768: and b.batch_id = r.batch_id)
4769: and nvl(upgrade_batch, 'N') <> 'Y'

Line 5519: XTR_BATCHES B

5515:
5516: cursor c_fx is
5517: select 'Y'
5518: from XTR_REVALUATION_DETAILS R,
5519: XTR_BATCHES B
5520: where r.deal_no = rec.deal_no
5521: and r.batch_id = b.batch_id
5522: and r.batch_id <> rec.batch_id
5523: and b.upgrade_batch <> 'Y';

Line 6020: from xtr_batches b, xtr_revaluation_details r

6016: /* that includes the FX deals */
6017: /***************************************************/
6018: cursor C_LAST_END_DATE is
6019: select max(b.period_end)
6020: from xtr_batches b, xtr_revaluation_details r
6021: where b.batch_id = r.batch_id
6022: and b.company_code = rec.company_code
6023: and b.batch_type is NULL
6024: and r.deal_no = rec.deal_no;

Line 6065: from xtr_batches

6061: where deal_no = rec.deal_no
6062: and effective_date < rec.revldate
6063: union
6064: select period_end reval_date
6065: from xtr_batches
6066: where batch_id = rec.batch_id
6067: order by reval_date asc;
6068:
6069: l_first BOOLEAN;

Line 6177: from xtr_batches

6173: where deal_no = rec.deal_no
6174: and effective_date < rec.revldate
6175: union
6176: select period_end reval_date
6177: from xtr_batches
6178: where batch_id = rec.batch_id
6179: order by reval_date asc;
6180:
6181: -- Bug 4234575 This cursor has been added so that totally reclassified