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

Line 317: X_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,

313: X_ITEM_NAME => v_item_name,
314: X_ORIGINAL_TEXT => null,
315: X_TEXT => l_new_val,
316: X_LAST_UPDATE_DATE => sysdate,
317: X_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
318: X_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID);
319: l_cnt :=1;
320:
321: end loop; -- lang_cursor

Line 318: X_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID);

314: X_ORIGINAL_TEXT => null,
315: X_TEXT => l_new_val,
316: X_LAST_UPDATE_DATE => sysdate,
317: X_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
318: X_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID);
319: l_cnt :=1;
320:
321: end loop; -- lang_cursor
322: if l_cnt =0 then

Line 332: X_CREATED_BY => FND_GLOBAL.USER_ID,

328: X_ITEM_NAME => l_item,
329: X_ORIGINAL_TEXT => l_orginal_text,
330: X_TEXT => l_new_val,
331: X_CREATION_DATE => sysdate,
332: X_CREATED_BY => FND_GLOBAL.USER_ID,
333: X_LAST_UPDATE_DATE => sysdate,
334: X_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
335: X_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID);
336: end if;

Line 334: X_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,

330: X_TEXT => l_new_val,
331: X_CREATION_DATE => sysdate,
332: X_CREATED_BY => FND_GLOBAL.USER_ID,
333: X_LAST_UPDATE_DATE => sysdate,
334: X_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
335: X_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID);
336: end if;
337:
338:

Line 335: X_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID);

331: X_CREATION_DATE => sysdate,
332: X_CREATED_BY => FND_GLOBAL.USER_ID,
333: X_LAST_UPDATE_DATE => sysdate,
334: X_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
335: X_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID);
336: end if;
337:
338:
339: --

Line 482: confirmed_by := fnd_global.user_id;

478: close HCE;
479: --
480: if ABS(l_hce_amount) < l_above_amt then -- bug 4135644
481: -- Auto confirm inserted row
482: confirmed_by := fnd_global.user_id;
483: confirmed_on := sysdate;
484: else
485: confirmed_by := NULL;
486: confirmed_on := NULL;

Line 832: values(p_fund_invest,fnd_global.user_id,c.COMPANY_CODE,l_sysdate,c.CURRENCY,c.DEAL_NUMBER,c.DEAL_SUBTYPE,c.DEAL_TYPE,

828: insert into XTR_INTEREST_RATE_EXPOSURE(FUND_INVEST,CREATED_BY,
829: COMPANY_CODE,CREATED_ON,CURRENCY,DEAL_NUMBER,DEAL_SUBTYPE,DEAL_TYPE,
830: FIXED_OR_FLOAT,FROM_DATE,GROSS_AMOUNT,MATURITY_DATE,NO_OF_DAYS,
831: PORTFOLIO_CODE,REF_NUMBER,START_DATE,TO_DATE,TRANSACTION_NUMBER,TRANSACTION_RATE,SYN_FLAG,SYN_PHY)
832: values(p_fund_invest,fnd_global.user_id,c.COMPANY_CODE,l_sysdate,c.CURRENCY,c.DEAL_NUMBER,c.DEAL_SUBTYPE,c.DEAL_TYPE,
833: c.FIXED_OR_FLOAT,c.FROM_DATE,c.GROSS_AMOUNT,c.MATURITY_DATE,c.NO_OF_DAYS,
834: c.PORTFOLIO_CODE,p_unique_ref_number,c.START_DATE,c.TO_DATE,c.TRANSACTION_NUMBER,c.TRANSACTION_RATE,'N','P');
835: end loop;
836: for c in get_data1 loop

Line 846: values(p_fund_invest,fnd_global.user_id,c.COMPANY_CODE,l_sysdate,c.CURRENCY,c.DEAL_NUMBER,c.DEAL_SUBTYPE,c.DEAL_TYPE,

842: insert into XTR_INTEREST_RATE_EXPOSURE(FUND_INVEST,CREATED_BY,
843: COMPANY_CODE,CREATED_ON,CURRENCY,DEAL_NUMBER,DEAL_SUBTYPE,DEAL_TYPE,
844: FIXED_OR_FLOAT,FROM_DATE,GROSS_AMOUNT,MATURITY_DATE,NO_OF_DAYS,
845: PORTFOLIO_CODE,REF_NUMBER,START_DATE,TO_DATE,TRANSACTION_NUMBER,TRANSACTION_RATE,SYN_FLAG,SYN_PHY)
846: values(p_fund_invest,fnd_global.user_id,c.COMPANY_CODE,l_sysdate,c.CURRENCY,c.DEAL_NUMBER,c.DEAL_SUBTYPE,c.DEAL_TYPE,
847: c.FIXED_OR_FLOAT,c.FROM_DATE,c.GROSS_AMOUNT,c.MATURITY_DATE,c.NO_OF_DAYS,
848: c.PORTFOLIO_CODE,p_unique_ref_number,c.START_DATE,c.TO_DATE,c.TRANSACTION_NUMBER,c.TRANSACTION_RATE,'N',l_syn_phy);
849: if c.deal_type in('IRS','FRA','SWPTN','IRO','BDO') and nvl(c.gross_amount,0) <>0 then
850: if c.fixed_or_float='FIXED' then

Line 859: values(p_fund_invest,fnd_global.user_id,c.COMPANY_CODE,l_sysdate,c.CURRENCY,c.DEAL_NUMBER,c.DEAL_SUBTYPE,c.DEAL_TYPE,

855: insert into XTR_INTEREST_RATE_EXPOSURE(FUND_INVEST,CREATED_BY,
856: COMPANY_CODE,CREATED_ON,CURRENCY,DEAL_NUMBER,DEAL_SUBTYPE,DEAL_TYPE,
857: FIXED_OR_FLOAT,FROM_DATE,GROSS_AMOUNT,MATURITY_DATE,NO_OF_DAYS,
858: PORTFOLIO_CODE,REF_NUMBER,START_DATE,TO_DATE,TRANSACTION_NUMBER,TRANSACTION_RATE,SYN_FLAG,SYN_PHY)
859: values(p_fund_invest,fnd_global.user_id,c.COMPANY_CODE,l_sysdate,c.CURRENCY,c.DEAL_NUMBER,c.DEAL_SUBTYPE,c.DEAL_TYPE,
860: l_fixed_or_float,c.FROM_DATE,-c.GROSS_AMOUNT,c.MATURITY_DATE,c.NO_OF_DAYS,
861: c.PORTFOLIO_CODE,p_unique_ref_number,c.START_DATE,c.TO_DATE,c.TRANSACTION_NUMBER,c.TRANSACTION_RATE,'Y',l_syn_phy);
862: end if;
863: end loop;

Line 869: values(p_fund_invest,fnd_global.user_id,c.COMPANY_CODE,l_sysdate,c.CURRENCY,c.DEAL_NUMBER,c.DEAL_SUBTYPE,c.DEAL_TYPE,

865: insert into XTR_INTEREST_RATE_EXPOSURE(FUND_INVEST,CREATED_BY,
866: COMPANY_CODE,CREATED_ON,CURRENCY,DEAL_NUMBER,DEAL_SUBTYPE,DEAL_TYPE,
867: FIXED_OR_FLOAT,FROM_DATE,GROSS_AMOUNT,MATURITY_DATE,NO_OF_DAYS,
868: PORTFOLIO_CODE,REF_NUMBER,START_DATE,TO_DATE,TRANSACTION_NUMBER,TRANSACTION_RATE,SYN_FLAG,SYN_PHY)
869: values(p_fund_invest,fnd_global.user_id,c.COMPANY_CODE,l_sysdate,c.CURRENCY,c.DEAL_NUMBER,c.DEAL_SUBTYPE,c.DEAL_TYPE,
870: c.FIXED_OR_FLOAT,c.FROM_DATE,c.GROSS_AMOUNT,c.MATURITY_DATE,c.NO_OF_DAYS,
871: c.PORTFOLIO_CODE,p_unique_ref_number,c.START_DATE,c.TO_DATE,c.TRANSACTION_NUMBER,c.TRANSACTION_RATE,'N','S');
872: if nvl(c.gross_amount,0) <>0 then
873: if c.fixed_or_float='FIXED' then

Line 882: values(p_fund_invest,fnd_global.user_id,c.COMPANY_CODE,l_sysdate,c.CURRENCY,c.DEAL_NUMBER,c.DEAL_SUBTYPE,c.DEAL_TYPE,

878: insert into XTR_INTEREST_RATE_EXPOSURE(FUND_INVEST,CREATED_BY,
879: COMPANY_CODE,CREATED_ON,CURRENCY,DEAL_NUMBER,DEAL_SUBTYPE,DEAL_TYPE,
880: FIXED_OR_FLOAT,FROM_DATE,GROSS_AMOUNT,MATURITY_DATE,NO_OF_DAYS,
881: PORTFOLIO_CODE,REF_NUMBER,START_DATE,TO_DATE,TRANSACTION_NUMBER,TRANSACTION_RATE,SYN_FLAG,SYN_PHY)
882: values(p_fund_invest,fnd_global.user_id,c.COMPANY_CODE,l_sysdate,c.CURRENCY,c.DEAL_NUMBER,c.DEAL_SUBTYPE,c.DEAL_TYPE,
883: l_fixed_or_float,c.FROM_DATE,-c.GROSS_AMOUNT,c.MATURITY_DATE,c.NO_OF_DAYS,
884: c.PORTFOLIO_CODE,p_unique_ref_number,c.START_DATE,c.TO_DATE,c.TRANSACTION_NUMBER,c.TRANSACTION_RATE,'Y','S');
885: end if;
886: end loop;

Line 898: values(p_fund_invest,fnd_global.user_id,c.COMPANY_CODE,l_sysdate,c.CURRENCY,c.DEAL_NUMBER,c.DEAL_SUBTYPE,c.DEAL_TYPE,

894: insert into XTR_INTEREST_RATE_EXPOSURE(FUND_INVEST,CREATED_BY,
895: COMPANY_CODE,CREATED_ON,CURRENCY,DEAL_NUMBER,DEAL_SUBTYPE,DEAL_TYPE,
896: FIXED_OR_FLOAT,FROM_DATE,GROSS_AMOUNT,MATURITY_DATE,NO_OF_DAYS,
897: PORTFOLIO_CODE,REF_NUMBER,START_DATE,TO_DATE,TRANSACTION_NUMBER,TRANSACTION_RATE,SYN_FLAG,SYN_PHY)
898: values(p_fund_invest,fnd_global.user_id,c.COMPANY_CODE,l_sysdate,c.CURRENCY,c.DEAL_NUMBER,c.DEAL_SUBTYPE,c.DEAL_TYPE,
899: c.FIXED_OR_FLOAT,c.FROM_DATE,c.GROSS_AMOUNT,c.MATURITY_DATE,c.NO_OF_DAYS,
900: c.PORTFOLIO_CODE,p_unique_ref_number,c.START_DATE,c.TO_DATE,c.TRANSACTION_NUMBER,c.TRANSACTION_RATE,'N',l_syn_phy);
901: if c.deal_type in('IRS','FRA','SWPTN','IRO') and nvl(c.gross_amount,0) <>0 then
902: if c.fixed_or_float='FIXED' then

Line 911: values(p_fund_invest,fnd_global.user_id,c.COMPANY_CODE,l_sysdate,c.CURRENCY,c.DEAL_NUMBER,c.DEAL_SUBTYPE,c.DEAL_TYPE,

907: insert into XTR_INTEREST_RATE_EXPOSURE(FUND_INVEST,CREATED_BY,
908: COMPANY_CODE,CREATED_ON,CURRENCY,DEAL_NUMBER,DEAL_SUBTYPE,DEAL_TYPE,
909: FIXED_OR_FLOAT,FROM_DATE,GROSS_AMOUNT,MATURITY_DATE,NO_OF_DAYS,
910: PORTFOLIO_CODE,REF_NUMBER,START_DATE,TO_DATE,TRANSACTION_NUMBER,TRANSACTION_RATE,SYN_FLAG,SYN_PHY)
911: values(p_fund_invest,fnd_global.user_id,c.COMPANY_CODE,l_sysdate,c.CURRENCY,c.DEAL_NUMBER,c.DEAL_SUBTYPE,c.DEAL_TYPE,
912: l_fixed_or_float,c.FROM_DATE,-c.GROSS_AMOUNT,c.MATURITY_DATE,c.NO_OF_DAYS,
913: c.PORTFOLIO_CODE,p_unique_ref_number,c.START_DATE,c.TO_DATE,c.TRANSACTION_NUMBER,c.TRANSACTION_RATE,'Y',l_syn_phy);
914: end if;
915: end loop;

Line 1559: sysdate, fnd_global.user_id);

1555: values
1556: (l_setoff_company,l_setoff||'-'||l_bank_code,
1557: l_calc_date,l_no_days,l_this_bal,0,l_this_bal,l_int_bf,
1558: l_interest,l_rate,0,0,l_int_cf,
1559: sysdate, fnd_global.user_id);
1560: END LOOP;
1561: close SETOFF_CAL_DATE;
1562: END LOOP;
1563: close SEL_SETOFF_ACCT;