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 AMS_UTILITY_PVT

Line 23: vIn := ams_utility_pvt.get_lookup_meaning('AMS_IO_OTHER','IN');

19: vFor varchar2(80);
20: vCurrency varchar2(80);
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

Line 24: vFor := ams_utility_pvt.get_lookup_meaning('AMS_IO_OTHER','FOR');

20: vCurrency varchar2(80);
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;

Line 81: vFor := ams_utility_pvt.get_lookup_meaning('AMS_IO_OTHER','FOR');

77: and lookup_code = vCompCode
78: and language = userenv('LANG');
79: vContext := jtfb_dcf.get_parameter_value(p_parameters, 'pContext');
80: vPeriod := jtfb_dcf.get_parameter_value(p_parameters, 'P_PERIOD_TYPE');
81: vFor := ams_utility_pvt.get_lookup_meaning('AMS_IO_OTHER','FOR');
82: select to_char(start_date,'mm-dd') ||' to '|| to_char(end_date,'mm-dd') into xPeriod from bim_r_periods where calc_type = 'FIXED' and period_type = vPeriod;
83:
84: return (vRepName || get_currency(p_parameters) || xPeriod);
85: EXCEPTION

Line 112: vFor := ams_utility_pvt.get_lookup_meaning('AMS_IO_OTHER','FOR');

108: and lookup_code = vCompCode
109: and language = userenv('LANG');
110: vPeriod := jtfb_dcf.get_parameter_value(p_parameters, 'P_PERIOD');
111: --vRepName := jtfb_dcf.get_parameter_value(p_parameters, 'P_REPORT_NAME');
112: vFor := ams_utility_pvt.get_lookup_meaning('AMS_IO_OTHER','FOR');
113: xRetString := '';
114: if (vPeriod is not NULL) then
115: select substr(vPeriod,0,INSTR(vPeriod,'|')-1) into xRetString from dual;
116: xRetString := ' '||vFor||' ' || xRetString;

Line 186: vIn := ams_utility_pvt.get_lookup_meaning('AMS_IO_OTHER','IN');

182: where
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';

Line 227: vIn := ams_utility_pvt.get_lookup_meaning('AMS_IO_OTHER','IN');

223: where
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';

Line 268: vIn := ams_utility_pvt.get_lookup_meaning('AMS_IO_OTHER','IN');

264: where
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';

Line 310: vIn := ams_utility_pvt.get_lookup_meaning('AMS_IO_OTHER','IN');

306: where
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';

Line 377: vTo := ams_utility_pvt.get_lookup_meaning('AMS_IO_OTHER','TO');

373: end if;
374: end if;
375: -- vSource := jtfb_dcf.get_parameter_value(p_parameters, 'P_BIN_NAME');
376: vDefPeriod := jtfb_dcf.get_parameter_value(p_parameters, 'P_DEF_PERIOD');
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;

Line 563: vIn := ams_utility_pvt.get_lookup_meaning('AMS_IO_OTHER','IN');

559: vFor varchar2(80);
560: vCurrency varchar2(80);
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:

Line 564: vFor := ams_utility_pvt.get_lookup_meaning('AMS_IO_OTHER','FOR');

560: vCurrency varchar2(80);
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

Line 618: vTo := ams_utility_pvt.get_lookup_meaning('AMS_IO_OTHER','TO');

614: vSource :='AMS_BIN_CAMP_EFFECTIVENESS';
615: end if;
616: end if;
617: vDefPeriod := jtfb_dcf.get_parameter_value(p_parameters, 'P_DEF_PERIOD');
618: vTo := ams_utility_pvt.get_lookup_meaning('AMS_IO_OTHER','TO');
619:
620: xRetString := 'x';
621: if (vDefPeriod is not NULL) then
622: select substr(vDefPeriod,0,INSTR(vDefPeriod,'-',10)-1) into xRetString from dual;

Line 687: vFor := ams_utility_pvt.get_lookup_meaning('AMS_IO_OTHER','FOR');

683: xRetString := xMonth;
684: end if;
685: end if;
686: end if;
687: vFor := ams_utility_pvt.get_lookup_meaning('AMS_IO_OTHER','FOR');
688: if (xRetString <> 'x') then
689: xRetString := ' '||vfor||' '||xRetString;
690: else
691: xRetString := '';