APPS.XTR_HEDGE_PROCESS_P dependencies on XTR_BATCH_EVENTS

Line 692: Update XTR_BATCH_EVENTS

688: l_mbst_date := dnm_rec.result_date; -- Unit Test Change
689:
690: end loop;
691:
692: Update XTR_BATCH_EVENTS
693: set AUTHORIZED = 'Y',
694: AUTHORIZED_BY = FND_GLOBAL.USER_ID,
695: AUTHORIZED_ON = SYSDATE,
696: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

Line 927: and not exists (select 'Y' from xtr_batch_events e

923: ,realized_flag realized_flag
924: from xtr_revaluation_details r
925: where batch_id is not null
926: and company_code = p_company
927: and not exists (select 'Y' from xtr_batch_events e
928: where e.batch_id = r.batch_id and
929: e.event_code = 'RETROET')
930: and batch_id in (select batch_id from xtr_batches b where
931: b.period_end <= p_cb_end_date)

Line 958: and not exists (select 'Y' from xtr_batch_events e

954: and r.realized_flag = 'N'
955: and hr.instrument_item_flag = 'U'
956: and ha.deal_no = hr.hedge_attribute_id
957: and r.period_to > ha.maturity_date
958: and not exists (select 'Y' from xtr_batch_events e
959: where e.batch_id = r.batch_id and
960: e.event_code = 'RETROET')
961: and batch_id in (select batch_id from xtr_batches b where
962: b.period_end <= p_cb_end_date)

Line 1108: select max(period_end) from xtr_batches b, xtr_batch_events e

1104: /*-------------------------------------------------------
1105: get end date for immedietly previous batch
1106: --------------------------------------------------------*/
1107: cursor prv_date is
1108: select max(period_end) from xtr_batches b, xtr_batch_events e
1109: where b.batch_id = e.batch_id
1110: and b.batch_id < p_batch_id
1111: and e.event_code = 'RETROET'
1112: and b.company_code = p_company;

Line 1540: into XTR_BATCH_EVENTS table

1536:
1537:
1538: /***************************************************************
1539: This procedure inserts a new RETROET event
1540: into XTR_BATCH_EVENTS table
1541: ***************************************************************/
1542: PROCEDURE ins_retro_event(p_batch_id IN NUMBER, p_event in VARCHAR2) is
1543:
1544: Cursor CHK_BATCH_RUN is

Line 1546: From XTR_BATCH_EVENTS

1542: PROCEDURE ins_retro_event(p_batch_id IN NUMBER, p_event in VARCHAR2) is
1543:
1544: Cursor CHK_BATCH_RUN is
1545: Select 'Y'
1546: From XTR_BATCH_EVENTS
1547: Where batch_id = p_batch_id
1548: and event_code = p_event;
1549:
1550: l_event_id XTR_BATCH_EVENTS.BATCH_EVENT_ID%TYPE;

Line 1550: l_event_id XTR_BATCH_EVENTS.BATCH_EVENT_ID%TYPE;

1546: From XTR_BATCH_EVENTS
1547: Where batch_id = p_batch_id
1548: and event_code = p_event;
1549:
1550: l_event_id XTR_BATCH_EVENTS.BATCH_EVENT_ID%TYPE;
1551: l_sysdate DATE := trunc(sysdate);
1552: l_cur VARCHAR2(1);
1553:
1554: Begin

Line 1563: select XTR_BATCH_EVENTS_S.NEXTVAL into l_event_id from DUAL;

1559: Raise e_batch_been_run;
1560: Else
1561: Close CHK_BATCH_RUN;
1562:
1563: select XTR_BATCH_EVENTS_S.NEXTVAL into l_event_id from DUAL;
1564:
1565: Insert into XTR_BATCH_EVENTS(batch_event_id, batch_id, event_code, authorized,
1566: authorized_by, authorized_on, created_by, creation_date,
1567: last_updated_by, last_update_date, last_update_login)

Line 1565: Insert into XTR_BATCH_EVENTS(batch_event_id, batch_id, event_code, authorized,

1561: Close CHK_BATCH_RUN;
1562:
1563: select XTR_BATCH_EVENTS_S.NEXTVAL into l_event_id from DUAL;
1564:
1565: Insert into XTR_BATCH_EVENTS(batch_event_id, batch_id, event_code, authorized,
1566: authorized_by, authorized_on, created_by, creation_date,
1567: last_updated_by, last_update_date, last_update_login)
1568: values(l_event_id, p_batch_id, p_event, 'N', null, null, fnd_global.user_id,
1569: l_sysdate, fnd_global.user_id, l_sysdate, fnd_global.login_id);