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 FND_GLOBAL

Line 153: l_end_date, fnd_global.user_id, l_sysdate, fnd_global.user_id,

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')),
153: l_end_date, fnd_global.user_id, l_sysdate, fnd_global.user_id,
154: l_sysdate, fnd_global.login_id, null, nvl(l_upgrade_batch, 'N'));
155:
156: l_batch_id := p_BATCH_ID;
157: else

Line 154: l_sysdate, fnd_global.login_id, null, nvl(l_upgrade_batch, 'N'));

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')),
153: l_end_date, fnd_global.user_id, l_sysdate, fnd_global.user_id,
154: l_sysdate, fnd_global.login_id, null, nvl(l_upgrade_batch, 'N'));
155:
156: l_batch_id := p_BATCH_ID;
157: else
158: p_BATCH_ID := l_batch_id;

Line 160: set last_updated_by = fnd_global.user_id,

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;
164: close BATCH_EXIST;

Line 206: l_sysdate,fnd_global.user_id,nvl(p_RATE_DATE,l_end_date),p_VOLATILITY_OR_RATE,

202: period_ref2,number_of_days,created_on,created_by)
203: values
204: (p_BATCH_ID,p_UNIQUE_REF_NUM,l_company,l_start_date,l_end_date,
205: l_vol_code,p_CURRENCYA,p_BID,p_ASK,
206: l_sysdate,fnd_global.user_id,nvl(p_RATE_DATE,l_end_date),p_VOLATILITY_OR_RATE,
207: p_DAY_MTH,p_DAY_COUNT_BASIS,p_CURRENCYB,p_PERIOD_REF1,p_PERIOD_REF2,
208: IM_NOS_OF_DAYS,l_sysdate,fnd_global.user_id);
209: end if;
210: END LOOP;

Line 208: IM_NOS_OF_DAYS,l_sysdate,fnd_global.user_id);

204: (p_BATCH_ID,p_UNIQUE_REF_NUM,l_company,l_start_date,l_end_date,
205: l_vol_code,p_CURRENCYA,p_BID,p_ASK,
206: l_sysdate,fnd_global.user_id,nvl(p_RATE_DATE,l_end_date),p_VOLATILITY_OR_RATE,
207: p_DAY_MTH,p_DAY_COUNT_BASIS,p_CURRENCYB,p_PERIOD_REF1,p_PERIOD_REF2,
208: IM_NOS_OF_DAYS,l_sysdate,fnd_global.user_id);
209: end if;
210: END LOOP;
211: close OPTION_VOLS;
212: --

Line 285: l_sysdate,fnd_global.user_id,nvl(p_RATE_DATE,l_end_date),p_VOLATILITY_OR_RATE,

281: period_ref2,number_of_days,created_on,created_by)
282: values
283: (p_BATCH_ID,p_UNIQUE_REF_NUM,l_company,l_start_date,l_end_date,
284: p_REVAL_TYPE,p_CURRENCYA,p_BID,p_ASK,
285: l_sysdate,fnd_global.user_id,nvl(p_RATE_DATE,l_end_date),p_VOLATILITY_OR_RATE,
286: p_DAY_MTH,p_day_count_basis,p_CURRENCYB,p_PERIOD_REF1,p_PERIOD_REF2,
287: IM_NOS_OF_DAYS,l_sysdate,fnd_global.user_id);
288: else
289: p_UNIQUE_REF_NUM := NULL;

Line 287: IM_NOS_OF_DAYS,l_sysdate,fnd_global.user_id);

283: (p_BATCH_ID,p_UNIQUE_REF_NUM,l_company,l_start_date,l_end_date,
284: p_REVAL_TYPE,p_CURRENCYA,p_BID,p_ASK,
285: l_sysdate,fnd_global.user_id,nvl(p_RATE_DATE,l_end_date),p_VOLATILITY_OR_RATE,
286: p_DAY_MTH,p_day_count_basis,p_CURRENCYB,p_PERIOD_REF1,p_PERIOD_REF2,
287: IM_NOS_OF_DAYS,l_sysdate,fnd_global.user_id);
288: else
289: p_UNIQUE_REF_NUM := NULL;
290: -- Get OTHER Rates
291: open RATES_NON_FX;

Line 313: l_sysdate,fnd_global.user_id,nvl(p_RATE_DATE,l_end_date),p_VOLATILITY_OR_RATE,

309: period_ref2,number_of_days,created_on,created_by)
310: values
311: (p_BATCH_ID,p_UNIQUE_REF_NUM,l_company,l_start_date,l_end_date,
312: p_REVAL_TYPE,p_CURRENCYA,p_BID,p_ASK,
313: l_sysdate,fnd_global.user_id,nvl(p_RATE_DATE,l_end_date),p_VOLATILITY_OR_RATE,
314: p_DAY_MTH,p_DAY_COUNT_BASIS,p_CURRENCYB,p_PERIOD_REF1,p_PERIOD_REF2,
315: IM_NOS_OF_DAYS,l_sysdate,fnd_global.user_id);
316: end if;
317: fetch INSTRUMENTS_MAINTAINED INTO p_REVAL_TYPE,p_PERIOD_REF1,p_PERIOD_REF2,

Line 315: IM_NOS_OF_DAYS,l_sysdate,fnd_global.user_id);

311: (p_BATCH_ID,p_UNIQUE_REF_NUM,l_company,l_start_date,l_end_date,
312: p_REVAL_TYPE,p_CURRENCYA,p_BID,p_ASK,
313: l_sysdate,fnd_global.user_id,nvl(p_RATE_DATE,l_end_date),p_VOLATILITY_OR_RATE,
314: p_DAY_MTH,p_DAY_COUNT_BASIS,p_CURRENCYB,p_PERIOD_REF1,p_PERIOD_REF2,
315: IM_NOS_OF_DAYS,l_sysdate,fnd_global.user_id);
316: end if;
317: fetch INSTRUMENTS_MAINTAINED INTO p_REVAL_TYPE,p_PERIOD_REF1,p_PERIOD_REF2,
318: p_CURRENCYA, p_CURRENCYB,l_term_type, l_day_count_basis,
319: l_bid_curr_rate, l_ask_curr_rate,l_latest_rate_date,

Line 9926: X_ENTERED_BY => fnd_global.user_id,

9922: X_DEAL_SUBTYPE => rec.deal_subtype,
9923: X_DEAL_TYPE => rec.deal_type,
9924: X_EFFECTIVE_DATE => rec.EFFECTIVE_DATE,
9925: X_EFFECTIVE_DAYS => r.EFFECTIVE_DAYS,
9926: X_ENTERED_BY => fnd_global.user_id,
9927: X_ENTERED_ON => l_sysdate,
9928: X_FACE_VALUE => rec.FACE_VALUE,
9929: X_FXO_SELL_REF_AMOUNT => rec.FXO_SELL_REF_AMOUNT,
9930: X_PERIOD_FROM => rec.period_start,

Line 9941: X_UPDATED_BY => fnd_global.user_id,

9937: X_TRANSACTION_NO => rec.trans_no,
9938: X_TRANSACTION_PERIOD => r.TRANSACTION_PERIOD,
9939: X_TRANSACTION_RATE => rec.TRANSACTION_RATE,
9940: X_UNREALISED_PL => unrel_pl_value,
9941: X_UPDATED_BY => fnd_global.user_id,
9942: X_UPDATED_ON => l_sysdate,
9943: X_YEAR_BASIS => rec.YEAR_BASIS,
9944: X_CREATED_ON => l_sysdate,
9945: X_EXCHANGE_RATE_ONE => rec.reval_ex_rate_one,

Line 9951: X_CREATED_BY => fnd_global.user_id,

9947: X_OVERWRITE_TYPE => rec.ow_type,
9948: X_OVERWRITE_VALUE => rec.ow_value,
9949: X_OVERWRITE_REASON => null,
9950: X_BATCH_ID => rec.batch_id,
9951: X_CREATED_BY => fnd_global.user_id,
9952: X_ACCOUNT_NO => rec.account_no,
9953: X_SWAP_REF => rec.swap_ref,
9954: X_NI_DISC_AMOUNT => rec.ni_disc_amount,
9955: X_AMOUNT_TYPE => nvl(r.amount_type, 'UNREAL'),

Line 10110: X_ENTERED_BY => fnd_global.user_id,

10106: X_DEAL_SUBTYPE => rec.deal_subtype,
10107: X_DEAL_TYPE => rec.deal_type,
10108: X_EFFECTIVE_DATE => rec.EFFECTIVE_DATE,
10109: X_EFFECTIVE_DAYS => r.EFFECTIVE_DAYS,
10110: X_ENTERED_BY => fnd_global.user_id,
10111: X_ENTERED_ON => l_sysdate,
10112: X_FACE_VALUE => rec.FACE_VALUE,
10113: X_FXO_SELL_REF_AMOUNT => rec.FXO_SELL_REF_AMOUNT,
10114: X_PERIOD_FROM => rec.period_start,

Line 10125: X_UPDATED_BY => fnd_global.user_id,

10121: X_TRANSACTION_NO => rec.trans_no,
10122: X_TRANSACTION_PERIOD => r.TRANSACTION_PERIOD,
10123: X_TRANSACTION_RATE => rec.TRANSACTION_RATE,
10124: X_UNREALISED_PL => null,
10125: X_UPDATED_BY => fnd_global.user_id,
10126: X_UPDATED_ON => l_sysdate,
10127: X_YEAR_BASIS => rec.YEAR_BASIS,
10128: X_CREATED_ON => l_sysdate,
10129: X_EXCHANGE_RATE_ONE => rec.reval_ex_rate_one,

Line 10135: X_CREATED_BY => fnd_global.user_id,

10131: X_OVERWRITE_TYPE => rec.ow_type,
10132: X_OVERWRITE_VALUE => rec.ow_value,
10133: X_OVERWRITE_REASON => null,
10134: X_BATCH_ID => rec.batch_id,
10135: X_CREATED_BY => fnd_global.user_id,
10136: X_ACCOUNT_NO => rec.account_no,
10137: X_SWAP_REF => rec.swap_ref,
10138: X_NI_DISC_AMOUNT => rec.ni_disc_amount,
10139: X_AMOUNT_TYPE => nvl(r.amount_type, 'REAL'),

Line 10217: values(l_event_id, p_batch_id, 'REVAL', 'N', null, null, fnd_global.user_id,

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);
10219:
10220: EXCEPTION
10221: When e_batch_been_run then

Line 10218: l_sysdate, fnd_global.user_id, l_sysdate, fnd_global.login_id);

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);
10219:
10220: EXCEPTION
10221: When e_batch_been_run then
10222: FND_MESSAGE.Set_Name('XTR', 'XTR_BATCH_IN_REVAL');