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 469: confirmed_by := fnd_global.user_id;

465: close HCE;
466: --
467: if ABS(l_hce_amount) < l_above_amt then -- bug 4135644
468: -- Auto confirm inserted row
469: confirmed_by := fnd_global.user_id;
470: confirmed_on := sysdate;
471: else
472: confirmed_by := NULL;
473: confirmed_on := NULL;

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

815: insert into XTR_INTEREST_RATE_EXPOSURE(FUND_INVEST,CREATED_BY,
816: COMPANY_CODE,CREATED_ON,CURRENCY,DEAL_NUMBER,DEAL_SUBTYPE,DEAL_TYPE,
817: FIXED_OR_FLOAT,FROM_DATE,GROSS_AMOUNT,MATURITY_DATE,NO_OF_DAYS,
818: PORTFOLIO_CODE,REF_NUMBER,START_DATE,TO_DATE,TRANSACTION_NUMBER,TRANSACTION_RATE,SYN_FLAG,SYN_PHY)
819: values(p_fund_invest,fnd_global.user_id,c.COMPANY_CODE,l_sysdate,c.CURRENCY,c.DEAL_NUMBER,c.DEAL_SUBTYPE,c.DEAL_TYPE,
820: c.FIXED_OR_FLOAT,c.FROM_DATE,c.GROSS_AMOUNT,c.MATURITY_DATE,c.NO_OF_DAYS,
821: c.PORTFOLIO_CODE,p_unique_ref_number,c.START_DATE,c.TO_DATE,c.TRANSACTION_NUMBER,c.TRANSACTION_RATE,'N','P');
822: end loop;
823: for c in get_data1 loop

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

829: insert into XTR_INTEREST_RATE_EXPOSURE(FUND_INVEST,CREATED_BY,
830: COMPANY_CODE,CREATED_ON,CURRENCY,DEAL_NUMBER,DEAL_SUBTYPE,DEAL_TYPE,
831: FIXED_OR_FLOAT,FROM_DATE,GROSS_AMOUNT,MATURITY_DATE,NO_OF_DAYS,
832: PORTFOLIO_CODE,REF_NUMBER,START_DATE,TO_DATE,TRANSACTION_NUMBER,TRANSACTION_RATE,SYN_FLAG,SYN_PHY)
833: values(p_fund_invest,fnd_global.user_id,c.COMPANY_CODE,l_sysdate,c.CURRENCY,c.DEAL_NUMBER,c.DEAL_SUBTYPE,c.DEAL_TYPE,
834: c.FIXED_OR_FLOAT,c.FROM_DATE,c.GROSS_AMOUNT,c.MATURITY_DATE,c.NO_OF_DAYS,
835: c.PORTFOLIO_CODE,p_unique_ref_number,c.START_DATE,c.TO_DATE,c.TRANSACTION_NUMBER,c.TRANSACTION_RATE,'N',l_syn_phy);
836: if c.deal_type in('IRS','FRA','SWPTN','IRO','BDO') and nvl(c.gross_amount,0) <>0 then
837: if c.fixed_or_float='FIXED' then

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: l_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,'Y',l_syn_phy);
849: end if;
850: end loop;

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

852: insert into XTR_INTEREST_RATE_EXPOSURE(FUND_INVEST,CREATED_BY,
853: COMPANY_CODE,CREATED_ON,CURRENCY,DEAL_NUMBER,DEAL_SUBTYPE,DEAL_TYPE,
854: FIXED_OR_FLOAT,FROM_DATE,GROSS_AMOUNT,MATURITY_DATE,NO_OF_DAYS,
855: PORTFOLIO_CODE,REF_NUMBER,START_DATE,TO_DATE,TRANSACTION_NUMBER,TRANSACTION_RATE,SYN_FLAG,SYN_PHY)
856: values(p_fund_invest,fnd_global.user_id,c.COMPANY_CODE,l_sysdate,c.CURRENCY,c.DEAL_NUMBER,c.DEAL_SUBTYPE,c.DEAL_TYPE,
857: c.FIXED_OR_FLOAT,c.FROM_DATE,c.GROSS_AMOUNT,c.MATURITY_DATE,c.NO_OF_DAYS,
858: c.PORTFOLIO_CODE,p_unique_ref_number,c.START_DATE,c.TO_DATE,c.TRANSACTION_NUMBER,c.TRANSACTION_RATE,'N','S');
859: if nvl(c.gross_amount,0) <>0 then
860: if c.fixed_or_float='FIXED' then

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: l_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,'Y','S');
872: end if;
873: end loop;

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

881: insert into XTR_INTEREST_RATE_EXPOSURE(FUND_INVEST,CREATED_BY,
882: COMPANY_CODE,CREATED_ON,CURRENCY,DEAL_NUMBER,DEAL_SUBTYPE,DEAL_TYPE,
883: FIXED_OR_FLOAT,FROM_DATE,GROSS_AMOUNT,MATURITY_DATE,NO_OF_DAYS,
884: PORTFOLIO_CODE,REF_NUMBER,START_DATE,TO_DATE,TRANSACTION_NUMBER,TRANSACTION_RATE,SYN_FLAG,SYN_PHY)
885: values(p_fund_invest,fnd_global.user_id,c.COMPANY_CODE,l_sysdate,c.CURRENCY,c.DEAL_NUMBER,c.DEAL_SUBTYPE,c.DEAL_TYPE,
886: c.FIXED_OR_FLOAT,c.FROM_DATE,c.GROSS_AMOUNT,c.MATURITY_DATE,c.NO_OF_DAYS,
887: c.PORTFOLIO_CODE,p_unique_ref_number,c.START_DATE,c.TO_DATE,c.TRANSACTION_NUMBER,c.TRANSACTION_RATE,'N',l_syn_phy);
888: if c.deal_type in('IRS','FRA','SWPTN','IRO') and nvl(c.gross_amount,0) <>0 then
889: if c.fixed_or_float='FIXED' then

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: l_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,'Y',l_syn_phy);
901: end if;
902: end loop;

Line 1546: sysdate, fnd_global.user_id);

1542: values
1543: (l_setoff_company,l_setoff||'-'||l_bank_code,
1544: l_calc_date,l_no_days,l_this_bal,0,l_this_bal,l_int_bf,
1545: l_interest,l_rate,0,0,l_int_cf,
1546: sysdate, fnd_global.user_id);
1547: END LOOP;
1548: close SETOFF_CAL_DATE;
1549: END LOOP;
1550: close SEL_SETOFF_ACCT;