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_HEDGE_PROCESS_P dependencies on FND_GLOBAL

Line 256: p_batch_id, p_date, fnd_global.user_id, sysdate, fnd_global.user_id,

252: RECLASS_GAIN_LOSS_AMT,
253: EFF_CUM_GAIN_LOSS_AMT, INEFF_CUM_GAIN_LOSS_AMT, EXCLUDED_CUM_GAIN_LOSS_AMT
254: )
255: values (l_retro_test_id, p_company, p_hedge_no, NULL,
256: p_batch_id, p_date, fnd_global.user_id, sysdate, fnd_global.user_id,
257: sysdate, fnd_global.login_id, fnd_global.conc_program_id, fnd_global.conc_login_id,
258: fnd_global.prog_appl_id, fnd_global.conc_request_id,'Y', l_gain_loss_ccy,
259: l_amount_type, 0, 0, l_item_prv_cum, l_inst_prv_cum, NULL, 0,0,0,
260: nvl(l_rec_gl_amt,0), l_eff_prv_cum, l_ineff_prv_cum, l_excl_prv_cum

Line 257: sysdate, fnd_global.login_id, fnd_global.conc_program_id, fnd_global.conc_login_id,

253: EFF_CUM_GAIN_LOSS_AMT, INEFF_CUM_GAIN_LOSS_AMT, EXCLUDED_CUM_GAIN_LOSS_AMT
254: )
255: values (l_retro_test_id, p_company, p_hedge_no, NULL,
256: p_batch_id, p_date, fnd_global.user_id, sysdate, fnd_global.user_id,
257: sysdate, fnd_global.login_id, fnd_global.conc_program_id, fnd_global.conc_login_id,
258: fnd_global.prog_appl_id, fnd_global.conc_request_id,'Y', l_gain_loss_ccy,
259: l_amount_type, 0, 0, l_item_prv_cum, l_inst_prv_cum, NULL, 0,0,0,
260: nvl(l_rec_gl_amt,0), l_eff_prv_cum, l_ineff_prv_cum, l_excl_prv_cum
261: );

Line 258: fnd_global.prog_appl_id, fnd_global.conc_request_id,'Y', l_gain_loss_ccy,

254: )
255: values (l_retro_test_id, p_company, p_hedge_no, NULL,
256: p_batch_id, p_date, fnd_global.user_id, sysdate, fnd_global.user_id,
257: sysdate, fnd_global.login_id, fnd_global.conc_program_id, fnd_global.conc_login_id,
258: fnd_global.prog_appl_id, fnd_global.conc_request_id,'Y', l_gain_loss_ccy,
259: l_amount_type, 0, 0, l_item_prv_cum, l_inst_prv_cum, NULL, 0,0,0,
260: nvl(l_rec_gl_amt,0), l_eff_prv_cum, l_ineff_prv_cum, l_excl_prv_cum
261: );
262: end if;

Line 324: fnd_global.user_id,

320: xtr_deal_retro_tests_s.nextval,
321: l_retro_test_id,
322: p_batch_id,
323: p_hedge_no,
324: fnd_global.user_id,
325: sysdate,
326: fnd_global.user_id,
327: sysdate,
328: fnd_global.login_id,

Line 326: fnd_global.user_id,

322: p_batch_id,
323: p_hedge_no,
324: fnd_global.user_id,
325: sysdate,
326: fnd_global.user_id,
327: sysdate,
328: fnd_global.login_id,
329: fnd_global.conc_program_id,
330: fnd_global.conc_login_id,

Line 328: fnd_global.login_id,

324: fnd_global.user_id,
325: sysdate,
326: fnd_global.user_id,
327: sysdate,
328: fnd_global.login_id,
329: fnd_global.conc_program_id,
330: fnd_global.conc_login_id,
331: fnd_global.prog_appl_id,
332: fnd_global.conc_request_id,

Line 329: fnd_global.conc_program_id,

325: sysdate,
326: fnd_global.user_id,
327: sysdate,
328: fnd_global.login_id,
329: fnd_global.conc_program_id,
330: fnd_global.conc_login_id,
331: fnd_global.prog_appl_id,
332: fnd_global.conc_request_id,
333: r.deal_no,

Line 330: fnd_global.conc_login_id,

326: fnd_global.user_id,
327: sysdate,
328: fnd_global.login_id,
329: fnd_global.conc_program_id,
330: fnd_global.conc_login_id,
331: fnd_global.prog_appl_id,
332: fnd_global.conc_request_id,
333: r.deal_no,
334: l_amount_type,

Line 331: fnd_global.prog_appl_id,

327: sysdate,
328: fnd_global.login_id,
329: fnd_global.conc_program_id,
330: fnd_global.conc_login_id,
331: fnd_global.prog_appl_id,
332: fnd_global.conc_request_id,
333: r.deal_no,
334: l_amount_type,
335: 0,

Line 332: fnd_global.conc_request_id,

328: fnd_global.login_id,
329: fnd_global.conc_program_id,
330: fnd_global.conc_login_id,
331: fnd_global.prog_appl_id,
332: fnd_global.conc_request_id,
333: r.deal_no,
334: l_amount_type,
335: 0,
336: 0,

Line 498: fnd_global.user_id,

494: l_gl_ccy,
495: p_date,
496: 'T',
497: sysdate,
498: fnd_global.user_id,
499: sysdate,
500: fnd_global.user_id,
501: fnd_global.login_id
502: );

Line 500: fnd_global.user_id,

496: 'T',
497: sysdate,
498: fnd_global.user_id,
499: sysdate,
500: fnd_global.user_id,
501: fnd_global.login_id
502: );
503:
504: Exception

Line 501: fnd_global.login_id

497: sysdate,
498: fnd_global.user_id,
499: sysdate,
500: fnd_global.user_id,
501: fnd_global.login_id
502: );
503:
504: Exception
505: when others then

Line 694: AUTHORIZED_BY = FND_GLOBAL.USER_ID,

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,
697: LAST_UPDATE_DATE = SYSDATE,
698: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

Line 696: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

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,
697: LAST_UPDATE_DATE = SYSDATE,
698: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
699: where BATCH_ID = P_BATCH_ID
700: and EVENT_CODE = 'RETROET'

Line 698: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

694: AUTHORIZED_BY = FND_GLOBAL.USER_ID,
695: AUTHORIZED_ON = SYSDATE,
696: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
697: LAST_UPDATE_DATE = SYSDATE,
698: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
699: where BATCH_ID = P_BATCH_ID
700: and EVENT_CODE = 'RETROET'
701: and nvl(AUTHORIZED,'N') <> 'Y';
702:

Line 1364: p_batch_id, hdg_rec.period_to, fnd_global.user_id, sysdate, fnd_global.user_id,

1360: ITEM_CUM_GAIN_LOSS_AMT, INST_CUM_GAIN_LOSS_AMT, PCT_EFFECTIVE, EFF_PRD_GAIN_LOSS_AMT,
1361: INEFF_PRD_GAIN_LOSS_AMT, EXCLUDED_PRD_GAIN_LOSS_AMT, RECLASS_GAIN_LOSS_AMT,
1362: EFF_CUM_GAIN_LOSS_AMT, INEFF_CUM_GAIN_LOSS_AMT, EXCLUDED_CUM_GAIN_LOSS_AMT)
1363: values (l_retro_test_id, p_company, hdg_rec.hedge_no, NULL,
1364: p_batch_id, hdg_rec.period_to, fnd_global.user_id, sysdate, fnd_global.user_id,
1365: sysdate, fnd_global.login_id, fnd_global.conc_program_id, fnd_global.conc_login_id,
1366: fnd_global.prog_appl_id, fnd_global.conc_request_id,'N',l_gain_loss_ccy,
1367: l_amount_type, l_item_prd, l_inst_prd, l_item_cum, l_inst_cum, NULL, NULL,
1368: NULL, l_excl_prd, NULL, NULL, NULL, l_excl_cum);

Line 1365: sysdate, fnd_global.login_id, fnd_global.conc_program_id, fnd_global.conc_login_id,

1361: INEFF_PRD_GAIN_LOSS_AMT, EXCLUDED_PRD_GAIN_LOSS_AMT, RECLASS_GAIN_LOSS_AMT,
1362: EFF_CUM_GAIN_LOSS_AMT, INEFF_CUM_GAIN_LOSS_AMT, EXCLUDED_CUM_GAIN_LOSS_AMT)
1363: values (l_retro_test_id, p_company, hdg_rec.hedge_no, NULL,
1364: p_batch_id, hdg_rec.period_to, fnd_global.user_id, sysdate, fnd_global.user_id,
1365: sysdate, fnd_global.login_id, fnd_global.conc_program_id, fnd_global.conc_login_id,
1366: fnd_global.prog_appl_id, fnd_global.conc_request_id,'N',l_gain_loss_ccy,
1367: l_amount_type, l_item_prd, l_inst_prd, l_item_cum, l_inst_cum, NULL, NULL,
1368: NULL, l_excl_prd, NULL, NULL, NULL, l_excl_cum);
1369:

Line 1366: fnd_global.prog_appl_id, fnd_global.conc_request_id,'N',l_gain_loss_ccy,

1362: EFF_CUM_GAIN_LOSS_AMT, INEFF_CUM_GAIN_LOSS_AMT, EXCLUDED_CUM_GAIN_LOSS_AMT)
1363: values (l_retro_test_id, p_company, hdg_rec.hedge_no, NULL,
1364: p_batch_id, hdg_rec.period_to, fnd_global.user_id, sysdate, fnd_global.user_id,
1365: sysdate, fnd_global.login_id, fnd_global.conc_program_id, fnd_global.conc_login_id,
1366: fnd_global.prog_appl_id, fnd_global.conc_request_id,'N',l_gain_loss_ccy,
1367: l_amount_type, l_item_prd, l_inst_prd, l_item_cum, l_inst_cum, NULL, NULL,
1368: NULL, l_excl_prd, NULL, NULL, NULL, l_excl_cum);
1369:
1370: elsif NVL(l_test_method, '@@@') <> 'MANUAL' then

Line 1407: p_batch_id, hdg_rec.period_to, fnd_global.user_id, sysdate, fnd_global.user_id,

1403: ITEM_CUM_GAIN_LOSS_AMT, INST_CUM_GAIN_LOSS_AMT, PCT_EFFECTIVE, EFF_PRD_GAIN_LOSS_AMT,
1404: INEFF_PRD_GAIN_LOSS_AMT, EXCLUDED_PRD_GAIN_LOSS_AMT, RECLASS_GAIN_LOSS_AMT,
1405: EFF_CUM_GAIN_LOSS_AMT, INEFF_CUM_GAIN_LOSS_AMT, EXCLUDED_CUM_GAIN_LOSS_AMT)
1406: values (l_retro_test_id, p_company, hdg_rec.hedge_no, l_result,
1407: p_batch_id, hdg_rec.period_to, fnd_global.user_id, sysdate, fnd_global.user_id,
1408: sysdate, fnd_global.login_id, fnd_global.conc_program_id, fnd_global.conc_login_id,
1409: fnd_global.prog_appl_id, fnd_global.conc_request_id,'Y',l_gain_loss_ccy,
1410: l_amount_type, l_item_prd, l_inst_prd, l_item_cum, l_inst_cum, l_pct_eff, l_eff_prd,
1411: l_ineff_prd, l_excl_prd, NULL, l_eff_cum, l_ineff_cum, l_excl_cum);

Line 1408: sysdate, fnd_global.login_id, fnd_global.conc_program_id, fnd_global.conc_login_id,

1404: INEFF_PRD_GAIN_LOSS_AMT, EXCLUDED_PRD_GAIN_LOSS_AMT, RECLASS_GAIN_LOSS_AMT,
1405: EFF_CUM_GAIN_LOSS_AMT, INEFF_CUM_GAIN_LOSS_AMT, EXCLUDED_CUM_GAIN_LOSS_AMT)
1406: values (l_retro_test_id, p_company, hdg_rec.hedge_no, l_result,
1407: p_batch_id, hdg_rec.period_to, fnd_global.user_id, sysdate, fnd_global.user_id,
1408: sysdate, fnd_global.login_id, fnd_global.conc_program_id, fnd_global.conc_login_id,
1409: fnd_global.prog_appl_id, fnd_global.conc_request_id,'Y',l_gain_loss_ccy,
1410: l_amount_type, l_item_prd, l_inst_prd, l_item_cum, l_inst_cum, l_pct_eff, l_eff_prd,
1411: l_ineff_prd, l_excl_prd, NULL, l_eff_cum, l_ineff_cum, l_excl_cum);
1412:

Line 1409: fnd_global.prog_appl_id, fnd_global.conc_request_id,'Y',l_gain_loss_ccy,

1405: EFF_CUM_GAIN_LOSS_AMT, INEFF_CUM_GAIN_LOSS_AMT, EXCLUDED_CUM_GAIN_LOSS_AMT)
1406: values (l_retro_test_id, p_company, hdg_rec.hedge_no, l_result,
1407: p_batch_id, hdg_rec.period_to, fnd_global.user_id, sysdate, fnd_global.user_id,
1408: sysdate, fnd_global.login_id, fnd_global.conc_program_id, fnd_global.conc_login_id,
1409: fnd_global.prog_appl_id, fnd_global.conc_request_id,'Y',l_gain_loss_ccy,
1410: l_amount_type, l_item_prd, l_inst_prd, l_item_cum, l_inst_cum, l_pct_eff, l_eff_prd,
1411: l_ineff_prd, l_excl_prd, NULL, l_eff_cum, l_ineff_cum, l_excl_cum);
1412:
1413: /*-------------------------------------------------------

Line 1459: fnd_global.user_id, sysdate, fnd_global.user_id, sysdate, fnd_global.login_id,

1455: RECLASS_GAIN_LOSS_AMT, EFF_CUM_GAIN_LOSS_AMT, INEFF_CUM_GAIN_LOSS_AMT,
1456: EXCLUDED_CUM_GAIN_LOSS_AMT, RESULT_DATE)
1457:
1458: values (xtr_deal_retro_tests_s.nextval, l_retro_test_id, p_batch_id, hdg_rec.hedge_no,
1459: fnd_global.user_id, sysdate, fnd_global.user_id, sysdate, fnd_global.login_id,
1460: fnd_global.conc_program_id, fnd_global.conc_login_id, fnd_global.prog_appl_id,
1461: fnd_global.conc_request_id, deal_rec.deal_no, l_amount_type,
1462: round(l_eff_prd * (deal_rec.alloc_ref_amt/l_deal_total), l_round),
1463: l_hd_ineff_prd,

Line 1460: fnd_global.conc_program_id, fnd_global.conc_login_id, fnd_global.prog_appl_id,

1456: EXCLUDED_CUM_GAIN_LOSS_AMT, RESULT_DATE)
1457:
1458: values (xtr_deal_retro_tests_s.nextval, l_retro_test_id, p_batch_id, hdg_rec.hedge_no,
1459: fnd_global.user_id, sysdate, fnd_global.user_id, sysdate, fnd_global.login_id,
1460: fnd_global.conc_program_id, fnd_global.conc_login_id, fnd_global.prog_appl_id,
1461: fnd_global.conc_request_id, deal_rec.deal_no, l_amount_type,
1462: round(l_eff_prd * (deal_rec.alloc_ref_amt/l_deal_total), l_round),
1463: l_hd_ineff_prd,
1464: round(l_excl_prd * (deal_rec.alloc_ref_amt/l_deal_total), l_round), NULL,

Line 1461: fnd_global.conc_request_id, deal_rec.deal_no, l_amount_type,

1457:
1458: values (xtr_deal_retro_tests_s.nextval, l_retro_test_id, p_batch_id, hdg_rec.hedge_no,
1459: fnd_global.user_id, sysdate, fnd_global.user_id, sysdate, fnd_global.login_id,
1460: fnd_global.conc_program_id, fnd_global.conc_login_id, fnd_global.prog_appl_id,
1461: fnd_global.conc_request_id, deal_rec.deal_no, l_amount_type,
1462: round(l_eff_prd * (deal_rec.alloc_ref_amt/l_deal_total), l_round),
1463: l_hd_ineff_prd,
1464: round(l_excl_prd * (deal_rec.alloc_ref_amt/l_deal_total), l_round), NULL,
1465: round(l_eff_cum * (deal_rec.alloc_ref_amt/l_deal_total), l_round),

Line 1568: values(l_event_id, p_batch_id, p_event, 'N', null, null, fnd_global.user_id,

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);
1570: End If;
1571:
1572: EXCEPTION

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

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);
1570: End If;
1571:
1572: EXCEPTION
1573: When e_batch_been_run then

Line 1790: REQUEST_ID(idx) := FND_GLOBAL.CONC_REQUEST_ID;

1786: HEDGE_ATTRIBUTE_ID(idx) := P_HEDGE_NO;
1787: PCT_ALLOCATION(idx) := NULL;
1788: REFERENCE_AMOUNT(idx) := NULL;
1789: EXIT WHEN hcur%NOTFOUND;
1790: REQUEST_ID(idx) := FND_GLOBAL.CONC_REQUEST_ID;
1791: CREATED_BY(idx) := FND_GLOBAL.USER_ID;
1792: CREATION_DATE(idx) := SYSDATE;
1793: LAST_UPDATED_BY(idx) := FND_GLOBAL.USER_ID;
1794: LAST_UPDATE_DATE(idx) := SYSDATE;

Line 1791: CREATED_BY(idx) := FND_GLOBAL.USER_ID;

1787: PCT_ALLOCATION(idx) := NULL;
1788: REFERENCE_AMOUNT(idx) := NULL;
1789: EXIT WHEN hcur%NOTFOUND;
1790: REQUEST_ID(idx) := FND_GLOBAL.CONC_REQUEST_ID;
1791: CREATED_BY(idx) := FND_GLOBAL.USER_ID;
1792: CREATION_DATE(idx) := SYSDATE;
1793: LAST_UPDATED_BY(idx) := FND_GLOBAL.USER_ID;
1794: LAST_UPDATE_DATE(idx) := SYSDATE;
1795: LAST_UPDATE_LOGIN(idx) := FND_GLOBAL.LOGIN_ID;

Line 1793: LAST_UPDATED_BY(idx) := FND_GLOBAL.USER_ID;

1789: EXIT WHEN hcur%NOTFOUND;
1790: REQUEST_ID(idx) := FND_GLOBAL.CONC_REQUEST_ID;
1791: CREATED_BY(idx) := FND_GLOBAL.USER_ID;
1792: CREATION_DATE(idx) := SYSDATE;
1793: LAST_UPDATED_BY(idx) := FND_GLOBAL.USER_ID;
1794: LAST_UPDATE_DATE(idx) := SYSDATE;
1795: LAST_UPDATE_LOGIN(idx) := FND_GLOBAL.LOGIN_ID;
1796: idx := idx+1;
1797: END LOOP;

Line 1795: LAST_UPDATE_LOGIN(idx) := FND_GLOBAL.LOGIN_ID;

1791: CREATED_BY(idx) := FND_GLOBAL.USER_ID;
1792: CREATION_DATE(idx) := SYSDATE;
1793: LAST_UPDATED_BY(idx) := FND_GLOBAL.USER_ID;
1794: LAST_UPDATE_DATE(idx) := SYSDATE;
1795: LAST_UPDATE_LOGIN(idx) := FND_GLOBAL.LOGIN_ID;
1796: idx := idx+1;
1797: END LOOP;
1798: CLOSE hcur;
1799: Elsif (l_status in ('FULFILLED','FAILED') or (l_status = 'CURRENT' and l_count <> 0)) then

Line 1916: REQUEST_ID(cnt) := FND_GLOBAL.CONC_REQUEST_ID;

1912: end if;
1913: close ar_org;
1914:
1915: End If;
1916: REQUEST_ID(cnt) := FND_GLOBAL.CONC_REQUEST_ID;
1917: CREATED_BY(cnt) := FND_GLOBAL.USER_ID;
1918: CREATION_DATE(cnt) := SYSDATE;
1919: LAST_UPDATED_BY(cnt) := FND_GLOBAL.USER_ID;
1920: LAST_UPDATE_DATE(cnt) := SYSDATE;

Line 1917: CREATED_BY(cnt) := FND_GLOBAL.USER_ID;

1913: close ar_org;
1914:
1915: End If;
1916: REQUEST_ID(cnt) := FND_GLOBAL.CONC_REQUEST_ID;
1917: CREATED_BY(cnt) := FND_GLOBAL.USER_ID;
1918: CREATION_DATE(cnt) := SYSDATE;
1919: LAST_UPDATED_BY(cnt) := FND_GLOBAL.USER_ID;
1920: LAST_UPDATE_DATE(cnt) := SYSDATE;
1921: LAST_UPDATE_LOGIN(cnt) := FND_GLOBAL.LOGIN_ID;

Line 1919: LAST_UPDATED_BY(cnt) := FND_GLOBAL.USER_ID;

1915: End If;
1916: REQUEST_ID(cnt) := FND_GLOBAL.CONC_REQUEST_ID;
1917: CREATED_BY(cnt) := FND_GLOBAL.USER_ID;
1918: CREATION_DATE(cnt) := SYSDATE;
1919: LAST_UPDATED_BY(cnt) := FND_GLOBAL.USER_ID;
1920: LAST_UPDATE_DATE(cnt) := SYSDATE;
1921: LAST_UPDATE_LOGIN(cnt) := FND_GLOBAL.LOGIN_ID;
1922: cnt := cnt+1;
1923: END LOOP;

Line 1921: LAST_UPDATE_LOGIN(cnt) := FND_GLOBAL.LOGIN_ID;

1917: CREATED_BY(cnt) := FND_GLOBAL.USER_ID;
1918: CREATION_DATE(cnt) := SYSDATE;
1919: LAST_UPDATED_BY(cnt) := FND_GLOBAL.USER_ID;
1920: LAST_UPDATE_DATE(cnt) := SYSDATE;
1921: LAST_UPDATE_LOGIN(cnt) := FND_GLOBAL.LOGIN_ID;
1922: cnt := cnt+1;
1923: END LOOP;
1924: CLOSE hcur;
1925: End If;

Line 2050: CREATED_BY(k) := fnd_global.user_id;

2046:
2047: HEDGE_ATTRIBUTE_ID(k) := p_hedge_no;
2048: SOURCE_TYPE_ID(k) := l_source_id;
2049: INSTRUMENT_ITEM_FLAG(k) := l_iu_flag;
2050: CREATED_BY(k) := fnd_global.user_id;
2051: CREATION_DATE(k) := sysdate;
2052: LAST_UPDATED_BY(k) := fnd_global.user_id;
2053: LAST_UPDATE_DATE(k) := sysdate;
2054: LAST_UPDATE_LOGIN(k) := fnd_global.login_id;

Line 2052: LAST_UPDATED_BY(k) := fnd_global.user_id;

2048: SOURCE_TYPE_ID(k) := l_source_id;
2049: INSTRUMENT_ITEM_FLAG(k) := l_iu_flag;
2050: CREATED_BY(k) := fnd_global.user_id;
2051: CREATION_DATE(k) := sysdate;
2052: LAST_UPDATED_BY(k) := fnd_global.user_id;
2053: LAST_UPDATE_DATE(k) := sysdate;
2054: LAST_UPDATE_LOGIN(k) := fnd_global.login_id;
2055: END LOOP;
2056:

Line 2054: LAST_UPDATE_LOGIN(k) := fnd_global.login_id;

2050: CREATED_BY(k) := fnd_global.user_id;
2051: CREATION_DATE(k) := sysdate;
2052: LAST_UPDATED_BY(k) := fnd_global.user_id;
2053: LAST_UPDATE_DATE(k) := sysdate;
2054: LAST_UPDATE_LOGIN(k) := fnd_global.login_id;
2055: END LOOP;
2056:
2057: FORALL J in PRIMARY_CODE.FIRST..PRIMARY_CODE.LAST
2058: insert into xtr_hedge_relationships

Line 2831: v_user_id NUMBER := FND_GLOBAL.user_id;

2827: Note: date is saved relative to system date.
2828: */
2829: PROCEDURE SAVE_CRITERIA_SET(p_crit_set CRITERIA_SET_REC_TYPE) IS
2830:
2831: v_user_id NUMBER := FND_GLOBAL.user_id;
2832: v_date DATE := sysdate;
2833: v_log_in_id NUMBER := FND_GLOBAL.login_id;
2834: v_create_id NUMBER;
2835: v_create_date DATE;

Line 2833: v_log_in_id NUMBER := FND_GLOBAL.login_id;

2829: PROCEDURE SAVE_CRITERIA_SET(p_crit_set CRITERIA_SET_REC_TYPE) IS
2830:
2831: v_user_id NUMBER := FND_GLOBAL.user_id;
2832: v_date DATE := sysdate;
2833: v_log_in_id NUMBER := FND_GLOBAL.login_id;
2834: v_create_id NUMBER;
2835: v_create_date DATE;
2836:
2837: cursor get_old_set_info(p_criteria_set varchar2,p_criteria_set_owner number) is