eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.XTR_REVAL_PROCESS_P dependencies on XTR_BATCH_EVENTS

Line 342: XTR_BATCH_EVENTS EV

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
346: and pre.batch_id = ev.batch_id

Line 352: From XTR_BATCH_EVENTS

348: order by pre.batch_id desc;
349:
350: Cursor CHK_BATCH_RUN is
351: Select 'Y'
352: From XTR_BATCH_EVENTS
353: Where batch_id = p_batch_id
354: and event_code = 'REVAL';
355:
356: rec xtr_revl_rec;

Line 615: -- Insert into XTR_BATCH_EVENTS table

611: rec.revldate := l_batch_end;
612: rec.sob_ccy := l_sob_ccy;
613: rec.ex_rate_type := l_exchange_type;
614:
615: -- Insert into XTR_BATCH_EVENTS table
616: xtr_insert_event(p_batch_id);
617:
618: /********************* BDO revaluation ***********************/
619: for l_tmp in c_bdo_deal loop

Line 9854: l_event_id XTR_BATCH_EVENTS.BATCH_EVENT_ID%TYPE;

9850: p_hedge_flag IN VARCHAR2 DEFAULT NULL) IS
9851:
9852: l_ROWID VARCHAR2(20);
9853: l_reval_detail_id NUMBER;
9854: l_event_id XTR_BATCH_EVENTS.BATCH_EVENT_ID%TYPE;
9855: l_sysdate DATE := trunc(sysdate);
9856: l_complete VARCHAR2(1);
9857: l_deal_rowid VARCHAR2(30);
9858: r_err_log err_log; -- record type

Line 10055: l_event_id XTR_BATCH_EVENTS.BATCH_EVENT_ID%TYPE;

10051: retcode OUT NOCOPY NUMBER) IS
10052:
10053: l_ROWID VARCHAR2(20);
10054: l_reval_detail_id NUMBER;
10055: l_event_id XTR_BATCH_EVENTS.BATCH_EVENT_ID%TYPE;
10056: l_sysdate DATE := trunc(sysdate);
10057: l_complete VARCHAR2(1);
10058: l_deal_rowid VARCHAR2(30);
10059: r_err_log err_log; -- record type

Line 10187: /* This procedure insert value into XTR_BATCH_EVENTS table */

10183: end xtr_revl_real_log;
10184:
10185: ------------------------------------------------------------------------------
10186: /***********************************************************/
10187: /* This procedure insert value into XTR_BATCH_EVENTS table */
10188: /***********************************************************/
10189: PROCEDURE xtr_insert_event(
10190: p_batch_ID IN NUMBER) is
10191:

Line 10194: From XTR_BATCH_EVENTS

10190: p_batch_ID IN NUMBER) is
10191:
10192: Cursor CHK_BATCH_RUN is
10193: Select 'Y'
10194: From XTR_BATCH_EVENTS
10195: Where batch_id = p_batch_id
10196: and event_code = 'REVAL';
10197:
10198: l_event_id XTR_BATCH_EVENTS.BATCH_EVENT_ID%TYPE;

Line 10198: l_event_id XTR_BATCH_EVENTS.BATCH_EVENT_ID%TYPE;

10194: From XTR_BATCH_EVENTS
10195: Where batch_id = p_batch_id
10196: and event_code = 'REVAL';
10197:
10198: l_event_id XTR_BATCH_EVENTS.BATCH_EVENT_ID%TYPE;
10199: l_sysdate DATE := trunc(sysdate);
10200: l_cur VARCHAR2(1);
10201: Begin
10202: Open CHK_BATCH_RUN;

Line 10210: -- insert new row to XTR_BATCH_EVENTS table

10206: Raise e_batch_been_run;
10207: End If;
10208: Close CHK_BATCH_RUN;
10209:
10210: -- insert new row to XTR_BATCH_EVENTS table
10211: select XTR_BATCH_EVENTS_S.NEXTVAL
10212: into l_event_id from DUAL;
10213:
10214: Insert into XTR_BATCH_EVENTS(batch_event_id, batch_id, event_code, authorized,

Line 10211: select XTR_BATCH_EVENTS_S.NEXTVAL

10207: End If;
10208: Close CHK_BATCH_RUN;
10209:
10210: -- insert new row to XTR_BATCH_EVENTS table
10211: select XTR_BATCH_EVENTS_S.NEXTVAL
10212: into l_event_id from DUAL;
10213:
10214: Insert into XTR_BATCH_EVENTS(batch_event_id, batch_id, event_code, authorized,
10215: authorized_by, authorized_on, created_by, creation_date,

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

10210: -- insert new row to XTR_BATCH_EVENTS table
10211: select XTR_BATCH_EVENTS_S.NEXTVAL
10212: into l_event_id from DUAL;
10213:
10214: Insert into XTR_BATCH_EVENTS(batch_event_id, batch_id, event_code, authorized,
10215: authorized_by, authorized_on, created_by, creation_date,
10216: last_updated_by, last_update_date, last_update_login)
10217: values(l_event_id, p_batch_id, 'REVAL', 'N', null, null, fnd_global.user_id,
10218: l_sysdate, fnd_global.user_id, l_sysdate, fnd_global.login_id);