APPS.XTR_STREAMLINE_P dependencies on XTR_BATCH_EVENTS

Line 161: from xtr_batch_events a,

157: and batch_type is null; -- 3527080 exclude NRA batch
158:
159: cursor find_event is
160: select 'Y'
161: from xtr_batch_events a,
162: xtr_batches b
163: where a.batch_id = nvl(p_batch_id, a.batch_id)
164: and a.event_code = p_event
165: and a.authorized = nvl(p_authorize,a.authorized)

Line 420: from xtr_batch_events a

416: --==========================================================================================--
417:
418: select rowid
419: into l_rowid
420: from xtr_batch_events a
421: where batch_id = p_batch_id
422: and event_code = p_event
423: and authorized = nvl(p_authorized,authorized)
424: for update of authorized nowait;

Line 511: from XTR_BATCH_EVENTS b

507: and period_end <= p_cutoff_date
508: and nvl(upgrade_batch,'N') = 'N'
509: and batch_type is null
510: and not exists (select 1
511: from XTR_BATCH_EVENTS b
512: where b.batch_id = a.batch_id
513: and event_code = C_JOURNAL)
514: order by period_end, period_start;
515:

Line 526: from XTR_BATCH_EVENTS b

522: and period_end <= p_cutoff_date
523: and nvl(upgrade_batch,'N') = 'N'
524: and batch_type is null
525: and not exists (select 1
526: from XTR_BATCH_EVENTS b
527: where b.batch_id = a.batch_id
528: and event_code = C_ACCRUAL
529: and nvl(authorized,'N') = 'Y')
530: order by period_end, period_start;

Line 547: from XTR_BATCH_EVENTS b

543: and period_end <= p_cutoff_date
544: and nvl(upgrade_batch,'N') = 'N'
545: and batch_type is null
546: and not exists (select 1
547: from XTR_BATCH_EVENTS b
548: where b.batch_id = a.batch_id
549: and event_code = C_RETROET
550: and nvl(authorized,'N') = 'Y')
551: and not exists (select 1

Line 552: from XTR_BATCH_EVENTS c

548: where b.batch_id = a.batch_id
549: and event_code = C_RETROET
550: and nvl(authorized,'N') = 'Y')
551: and not exists (select 1
552: from XTR_BATCH_EVENTS c
553: where c.batch_id = a.batch_id
554: and event_code = C_ACCRUAL) -- Intended for company that skips RETROSPECTIVE TEST
555: -- Need not check for AUTHORIZED flag in this case.
556: order by period_end, period_start;

Line 569: from XTR_BATCH_EVENTS b

565: and period_end <= p_cutoff_date
566: and nvl(upgrade_batch,'N') = 'N'
567: and batch_type is null
568: and not exists (select 1
569: from XTR_BATCH_EVENTS b
570: where b.batch_id = a.batch_id
571: and event_code = C_REVAL
572: and nvl(authorized,'N') = 'Y')
573: order by period_end, period_start;

Line 1189: update xtr_batch_events

1185: /*===================================================*/
1186: /* Authorize Revaluation Details */
1187: /*===================================================*/
1188: /* 3050444 old issue 2
1189: update xtr_batch_events
1190: set authorized = 'Y',
1191: authorized_by = fnd_global.user_id,
1192: authorized_on = trunc(sysdate),
1193: last_updated_by = fnd_global.user_id,

Line 1628: update xtr_batch_events

1624: if p_retcode = 0 then
1625: /*===================================================*/
1626: /* Authorize Accrual Details */
1627: /*===================================================*/
1628: update xtr_batch_events
1629: set authorized = 'Y',
1630: authorized_by = fnd_global.user_id,
1631: authorized_on = trunc(sysdate),
1632: last_updated_by = fnd_global.user_id,

Line 1850: from xtr_batch_events b

1846: and period_end <= p_cutoff_date
1847: and batch_type is null
1848: and nvl(upgrade_batch,'N') = 'N'
1849: and not exists (select 1
1850: from xtr_batch_events b
1851: where b.batch_id = a.batch_id
1852: and event_code = C_REVAL
1853: and nvl(authorized,'N') = 'Y')
1854: order by period_end, period_start;

Line 2081: from XTR_BATCH_EVENTS b

2077: and period_end <= p_cutoff_date
2078: and batch_type is null
2079: and nvl(upgrade_batch,'N') = 'N'
2080: and not exists (select 1
2081: from XTR_BATCH_EVENTS b
2082: where b.batch_id = a.batch_id
2083: and event_code = C_RETROET
2084: and nvl(authorized,'N') = 'Y')
2085: and not exists (select 1

Line 2086: from XTR_BATCH_EVENTS b

2082: where b.batch_id = a.batch_id
2083: and event_code = C_RETROET
2084: and nvl(authorized,'N') = 'Y')
2085: and not exists (select 1
2086: from XTR_BATCH_EVENTS b
2087: where b.batch_id = a.batch_id
2088: and event_code = C_ACCRUAL) -- Need not check for AUTHORISED flag
2089: order by period_end, period_start;
2090:

Line 2197: from XTR_BATCH_EVENTS b

2193: and period_end <= p_cutoff_date
2194: and batch_type is null
2195: and nvl(upgrade_batch,'N') = 'N'
2196: and not exists (select 1
2197: from XTR_BATCH_EVENTS b
2198: where b.batch_id = a.batch_id
2199: and event_code = C_ACCRUAL
2200: and nvl(authorized,'N') = 'Y')
2201: order by period_end, period_start;

Line 2409: from XTR_BATCH_EVENTS b

2405: and period_end <= p_cutoff_date
2406: and batch_type is null
2407: and nvl(upgrade_batch,'N') = 'N'
2408: and not exists (select 1
2409: from XTR_BATCH_EVENTS b
2410: where b.batch_id = a.batch_id
2411: and event_code = C_JOURNAL)
2412: order by period_end, period_start;
2413: