APPS.XTR_ACCRUAL_PROCESS_P dependencies on XTR_BATCH_EVENTS

Line 769: Select XTR_BATCH_EVENTS_S.NEXTVAL

765: /*-----------------------*/
766: /* Generate new Event_id */
767: /*-----------------------*/
768: Cursor EVENT_ID is
769: Select XTR_BATCH_EVENTS_S.NEXTVAL
770: From DUAL;
771:
772: /*-----------------------------------------------------------------------*/
773: /* If batch start from Reval, check reval authorization before Accruals */

Line 777: from XTR_BATCH_EVENTS

773: /* If batch start from Reval, check reval authorization before Accruals */
774: /*-----------------------------------------------------------------------*/
775: cursor CHK_REVAL_AUTH is
776: select 1
777: from XTR_BATCH_EVENTS
778: where batch_id = p_batch_id
779: and event_code = 'REVAL'
780: and authorized = 'Y';
781:

Line 3266: -- Insert row to XTR_BATCH_EVENTS table after generating Accrual for the Batch

3262: end if;
3263:
3264:
3265: -------------------------------------------------------------------------------
3266: -- Insert row to XTR_BATCH_EVENTS table after generating Accrual for the Batch
3267: -------------------------------------------------------------------------------
3268: open EVENT_ID;
3269: fetch EVENT_ID into l_event_id;
3270: cLose EVENT_ID;

Line 3272: insert into XTR_BATCH_EVENTS(batch_event_id, batch_id,event_code, authorized,

3268: open EVENT_ID;
3269: fetch EVENT_ID into l_event_id;
3270: cLose EVENT_ID;
3271:
3272: insert into XTR_BATCH_EVENTS(batch_event_id, batch_id,event_code, authorized,
3273: authorized_by, authorized_on, created_by, creation_date, last_updated_by,
3274: last_update_date, last_update_login)
3275: values (l_event_id, l_batch_id, 'ACCRUAL', decode(p_upgrade_batch,'I','Y','N'),
3276: null, null, fnd_global.user_id,