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.AMS_DCF_TITLE dependencies on FND_PROFILE

Line 25: vCurrency := fnd_profile.VALUE('AMS_DEFAULT_CURR_CODE');

21:
22: BEGIN
23: vIn := ams_utility_pvt.get_lookup_meaning('AMS_IO_OTHER','IN');
24: vFor := ams_utility_pvt.get_lookup_meaning('AMS_IO_OTHER','FOR');
25: vCurrency := fnd_profile.VALUE('AMS_DEFAULT_CURR_CODE');
26: vScaleByCode := jtfb_dcf.get_parameter_value(p_parameters, 'P_SCALE_BY');
27: if (vScaleByCode <> '1') then
28: select meaning into vScaleByMeaning from ams_lookups where lookup_type ='AMS_IO_SCALE_BY' and lookup_code = vScaleByCode;
29: else

Line 149: --select fnd_profile.VALUE('AMS_DEFAULT_CURR_CODE') into vCurrency from dual;

145: and language = userenv('LANG');
146: vPeriod := jtfb_dcf.get_parameter_value(p_parameters, 'P_PERIOD');
147: --vRepName := jtfb_dcf.get_parameter_value(p_parameters, 'P_REPORT_NAME');
148: xRetString := '';
149: --select fnd_profile.VALUE('AMS_DEFAULT_CURR_CODE') into vCurrency from dual;
150: if (vPeriod is not NULL) then
151: select substr(vPeriod,0,INSTR(vPeriod,'|')-1) into xRetString from dual;
152: --xRetString := ' - ' || xRetString;
153: end if;

Line 187: vCurrency := fnd_profile.VALUE('AMS_DEFAULT_CURR_CODE');

183: lookup_type= 'BIM_DBC_DCF_TITLES'
184: and lookup_code = vCompCode
185: and language = userenv('LANG');
186: vIn := ams_utility_pvt.get_lookup_meaning('AMS_IO_OTHER','IN');
187: vCurrency := fnd_profile.VALUE('AMS_DEFAULT_CURR_CODE');
188: vScaleByCode := jtfb_dcf.get_parameter_value(p_parameters, 'P_SCALE_BY');
189: --vRepName := jtfb_dcf.get_parameter_value(p_parameters, 'P_TITLE_NAME_KP');
190: vDefRepName := 'Response to Lead';
191: if (vScaleByCode <> '1') then

Line 228: vCurrency := fnd_profile.VALUE('AMS_DEFAULT_CURR_CODE');

224: lookup_type= 'BIM_DBC_DCF_TITLES'
225: and lookup_code = vCompCode
226: and language = userenv('LANG');
227: vIn := ams_utility_pvt.get_lookup_meaning('AMS_IO_OTHER','IN');
228: vCurrency := fnd_profile.VALUE('AMS_DEFAULT_CURR_CODE');
229: vScaleByCode := jtfb_dcf.get_parameter_value(p_parameters, 'P_SCALE_BY');
230: --vRepName := jtfb_dcf.get_parameter_value(p_parameters, 'P_TITLE_NAME_MB');
231: vDefRepName := 'Marketing Budgets';
232: if (vScaleByCode <> '1') then

Line 269: vCurrency := fnd_profile.VALUE('AMS_DEFAULT_CURR_CODE');

265: lookup_type= 'BIM_DBC_DCF_TITLES'
266: and lookup_code = vCompCode
267: and language = userenv('LANG');
268: vIn := ams_utility_pvt.get_lookup_meaning('AMS_IO_OTHER','IN');
269: vCurrency := fnd_profile.VALUE('AMS_DEFAULT_CURR_CODE');
270: vScaleByCode := jtfb_dcf.get_parameter_value(p_parameters, 'P_SCALE_BY');
271: --vRepName := jtfb_dcf.get_parameter_value(p_parameters, 'P_TITLE_NAME_CE');
272: vDefRepName := 'Campaign Effectiveness';
273: if (vScaleByCode <> '1') then

Line 311: vCurrency := fnd_profile.VALUE('AMS_DEFAULT_CURR_CODE');

307: lookup_type= 'BIM_DBC_DCF_TITLES'
308: and lookup_code = vCompCode
309: and language = userenv('LANG');
310: vIn := ams_utility_pvt.get_lookup_meaning('AMS_IO_OTHER','IN');
311: vCurrency := fnd_profile.VALUE('AMS_DEFAULT_CURR_CODE');
312: vScaleByCode := jtfb_dcf.get_parameter_value(p_parameters, 'P_SCALE_BY');
313: --vRepName := jtfb_dcf.get_parameter_value(p_parameters, 'P_TITLE_NAME_EE');
314: vDefRepName := 'Event Effectiveness';
315: if (vScaleByCode <> '1') then

Line 381: select fnd_profile.VALUE('AMS_DEFAULT_CURR_CODE') into vCurrency from dual;

377: vTo := ams_utility_pvt.get_lookup_meaning('AMS_IO_OTHER','TO');
378:
379: xRetString := 'x';
380: xDisplayType := 'Z';
381: select fnd_profile.VALUE('AMS_DEFAULT_CURR_CODE') into vCurrency from dual;
382: if (vDefPeriod is not NULL) then
383: select substr(vDefPeriod,0,INSTR(vDefPeriod,'-',10)-1) into xRetString from dual;
384: select year, qtr into xYear, xQtr
385: from bim_r_fd_dim_sum_mv where year||'-'||qtr = xRetString and rownum < 2;

Line 395: select to_char(start_date,fnd_profile.VALUE('ICX_DATE_FORMAT_MASK')) ||' ' ||vTo||' '||

391: select year, qtr,month,display_type into xYear, xQtr, xMonth,xDisplayType
392: from bim_r_fd_dim_sum_mv where year||'-'||qtr||'-'||month||'-'||display_type = vContext
393: and rownum < 2;
394: if (xDisplayType <> 'Z') then
395: select to_char(start_date,fnd_profile.VALUE('ICX_DATE_FORMAT_MASK')) ||' ' ||vTo||' '||
396: to_char(end_date,fnd_profile.VALUE('ICX_DATE_FORMAT_MASK')) into xPeriod
397: from bim_r_periods where calc_type = 'ROLLING' and period_type = xDisplayType;
398: xRetString := ' ' || xDisplayType || ' ('||xPeriod ||')';
399: else

Line 396: to_char(end_date,fnd_profile.VALUE('ICX_DATE_FORMAT_MASK')) into xPeriod

392: from bim_r_fd_dim_sum_mv where year||'-'||qtr||'-'||month||'-'||display_type = vContext
393: and rownum < 2;
394: if (xDisplayType <> 'Z') then
395: select to_char(start_date,fnd_profile.VALUE('ICX_DATE_FORMAT_MASK')) ||' ' ||vTo||' '||
396: to_char(end_date,fnd_profile.VALUE('ICX_DATE_FORMAT_MASK')) into xPeriod
397: from bim_r_periods where calc_type = 'ROLLING' and period_type = xDisplayType;
398: xRetString := ' ' || xDisplayType || ' ('||xPeriod ||')';
399: else
400: xRetString := xYear;

Line 413: select to_char(start_date,fnd_profile.VALUE('ICX_DATE_FORMAT_MASK')) ||' ' ||vTo||' '||

409: select year, qtr,month,display_type into xYear, xQtr, xMonth,xDisplayType
410: from bim_r_fd_dim_sum_mv where year||'-'||qtr||'-'||month||'-'||display_type = vContext
411: and rownum < 2;
412: if (xDisplayType <> 'Z') then
413: select to_char(start_date,fnd_profile.VALUE('ICX_DATE_FORMAT_MASK')) ||' ' ||vTo||' '||
414: to_char(end_date,fnd_profile.VALUE('ICX_DATE_FORMAT_MASK')) into xPeriod
415: from bim_r_periods where calc_type = 'ROLLING' and period_type = xDisplayType;
416: xRetString := ' ' || xDisplayType || ' ('||xPeriod ||')';
417: else

Line 414: to_char(end_date,fnd_profile.VALUE('ICX_DATE_FORMAT_MASK')) into xPeriod

410: from bim_r_fd_dim_sum_mv where year||'-'||qtr||'-'||month||'-'||display_type = vContext
411: and rownum < 2;
412: if (xDisplayType <> 'Z') then
413: select to_char(start_date,fnd_profile.VALUE('ICX_DATE_FORMAT_MASK')) ||' ' ||vTo||' '||
414: to_char(end_date,fnd_profile.VALUE('ICX_DATE_FORMAT_MASK')) into xPeriod
415: from bim_r_periods where calc_type = 'ROLLING' and period_type = xDisplayType;
416: xRetString := ' ' || xDisplayType || ' ('||xPeriod ||')';
417: else
418: xRetString := xYear;

Line 565: vCurrency := fnd_profile.VALUE('AMS_DEFAULT_CURR_CODE');

561: BEGIN
562: vRepName := jtfb_dcf.get_parameter_value(p_parameters, 'P_REPORT_NAME');
563: vIn := ams_utility_pvt.get_lookup_meaning('AMS_IO_OTHER','IN');
564: vFor := ams_utility_pvt.get_lookup_meaning('AMS_IO_OTHER','FOR');
565: vCurrency := fnd_profile.VALUE('AMS_DEFAULT_CURR_CODE');
566: return (vRepName||' (' ||vIn|| ' '||vCurrency||') ' );
567:
568: EXCEPTION
569: WHEN OTHERS THEN

Line 634: select to_char(start_date,fnd_profile.VALUE('ICX_DATE_FORMAT_MASK')) ||' ' ||vTo||' '||

630: select year, qtr,month,display_type into xYear, xQtr, xMonth,xDisplayType
631: from bim_r_fd_dim_sum_mv where year||'-'||qtr||'-'||month||'-'||display_type = vContext
632: and rownum < 2;
633: if (xDisplayType <> 'Z') then
634: select to_char(start_date,fnd_profile.VALUE('ICX_DATE_FORMAT_MASK')) ||' ' ||vTo||' '||
635: to_char(end_date,fnd_profile.VALUE('ICX_DATE_FORMAT_MASK')) into xPeriod
636: from bim_r_periods where calc_type = 'ROLLING' and period_type = xDisplayType;
637: xRetString := ' ' || xDisplayType || ' ('||xPeriod ||')';
638: else

Line 635: to_char(end_date,fnd_profile.VALUE('ICX_DATE_FORMAT_MASK')) into xPeriod

631: from bim_r_fd_dim_sum_mv where year||'-'||qtr||'-'||month||'-'||display_type = vContext
632: and rownum < 2;
633: if (xDisplayType <> 'Z') then
634: select to_char(start_date,fnd_profile.VALUE('ICX_DATE_FORMAT_MASK')) ||' ' ||vTo||' '||
635: to_char(end_date,fnd_profile.VALUE('ICX_DATE_FORMAT_MASK')) into xPeriod
636: from bim_r_periods where calc_type = 'ROLLING' and period_type = xDisplayType;
637: xRetString := ' ' || xDisplayType || ' ('||xPeriod ||')';
638: else
639: xRetString := xYear;

Line 652: select to_char(start_date,fnd_profile.VALUE('ICX_DATE_FORMAT_MASK')) ||' ' ||vTo||' '||

648: select year, qtr,month,display_type into xYear, xQtr, xMonth,xDisplayType
649: from bim_r_fd_dim_sum_mv where year||'-'||qtr||'-'||month||'-'||display_type = vContext
650: and rownum < 2;
651: if (xDisplayType <> 'Z') then
652: select to_char(start_date,fnd_profile.VALUE('ICX_DATE_FORMAT_MASK')) ||' ' ||vTo||' '||
653: to_char(end_date,fnd_profile.VALUE('ICX_DATE_FORMAT_MASK')) into xPeriod
654: from bim_r_periods where calc_type = 'ROLLING' and period_type = xDisplayType;
655: xRetString := ' ' || xDisplayType || ' ('||xPeriod ||')';
656: else

Line 653: to_char(end_date,fnd_profile.VALUE('ICX_DATE_FORMAT_MASK')) into xPeriod

649: from bim_r_fd_dim_sum_mv where year||'-'||qtr||'-'||month||'-'||display_type = vContext
650: and rownum < 2;
651: if (xDisplayType <> 'Z') then
652: select to_char(start_date,fnd_profile.VALUE('ICX_DATE_FORMAT_MASK')) ||' ' ||vTo||' '||
653: to_char(end_date,fnd_profile.VALUE('ICX_DATE_FORMAT_MASK')) into xPeriod
654: from bim_r_periods where calc_type = 'ROLLING' and period_type = xDisplayType;
655: xRetString := ' ' || xDisplayType || ' ('||xPeriod ||')';
656: else
657: xRetString := xYear;