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 JTFB_DCF

Line 26: vScaleByCode := jtfb_dcf.get_parameter_value(p_parameters, 'P_SCALE_BY');

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
30: vScaleByMeaning := '';

Line 47: vPeriod := jtfb_dcf.get_parameter_value(p_parameters, 'P_PERIOD_TYPE');

43: vPeriod varchar2(80);
44: xPeriod varchar2(80);
45:
46: BEGIN
47: vPeriod := jtfb_dcf.get_parameter_value(p_parameters, 'P_PERIOD_TYPE');
48: 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;
49: return (xPeriod);
50: --return ('The data reported is for Region: ' || xRegion || ', Country: ' || xCountry || ', Business Unit: ' || xBusinessUnit || ', Activity Type: ' || xActivityType || ', Campaign Status: ' || xCampaignStatus || ' aggregated by ' || xAggregateBy);
51: EXCEPTION

Line 70: vCompCode := jtfb_dcf.get_parameter_value(p_parameters, 'DCF.componentCode');

66: vFor varchar2(80);
67: vCompCode varchar2(80);
68:
69: BEGIN
70: vCompCode := jtfb_dcf.get_parameter_value(p_parameters, 'DCF.componentCode');
71: select
72: meaning into vRepName
73: from
74: fnd_lookup_values

Line 79: vContext := jtfb_dcf.get_parameter_value(p_parameters, 'pContext');

75: where
76: lookup_type= 'BIM_DBC_DCF_TITLES'
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:

Line 80: vPeriod := jtfb_dcf.get_parameter_value(p_parameters, 'P_PERIOD_TYPE');

76: lookup_type= 'BIM_DBC_DCF_TITLES'
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);

Line 101: vCompCode := jtfb_dcf.get_parameter_value(p_parameters, 'DCF.componentCode');

97: vFor varchar2(80);
98: vCompCode varchar2(80);
99:
100: BEGIN
101: vCompCode := jtfb_dcf.get_parameter_value(p_parameters, 'DCF.componentCode');
102: select
103: meaning into vRepName
104: from
105: fnd_lookup_values

Line 110: vPeriod := jtfb_dcf.get_parameter_value(p_parameters, 'P_PERIOD');

106: where
107: lookup_type= 'BIM_DBC_DCF_TITLES'
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

Line 111: --vRepName := jtfb_dcf.get_parameter_value(p_parameters, 'P_REPORT_NAME');

107: lookup_type= 'BIM_DBC_DCF_TITLES'
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;

Line 137: vCompCode := jtfb_dcf.get_parameter_value(p_parameters, 'DCF.componentCode');

133: --vCurrency varchar2(80);
134: vCompCode varchar2(80);
135:
136: BEGIN
137: vCompCode := jtfb_dcf.get_parameter_value(p_parameters, 'DCF.componentCode');
138: select
139: meaning into vRepName
140: from
141: fnd_lookup_values

Line 146: vPeriod := jtfb_dcf.get_parameter_value(p_parameters, 'P_PERIOD');

142: where
143: lookup_type= 'BIM_DBC_DCF_TITLES'
144: and lookup_code = vCompCode
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

Line 147: --vRepName := jtfb_dcf.get_parameter_value(p_parameters, 'P_REPORT_NAME');

143: lookup_type= 'BIM_DBC_DCF_TITLES'
144: and lookup_code = vCompCode
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;

Line 177: vCompCode := jtfb_dcf.get_parameter_value(p_parameters, 'DCF.componentCode');

173: vScaleByMeaning varchar2(80);
174: vCompCode varchar2(80);
175:
176: BEGIN
177: vCompCode := jtfb_dcf.get_parameter_value(p_parameters, 'DCF.componentCode');
178: select
179: meaning into vRepName
180: from
181: fnd_lookup_values

Line 188: vScaleByCode := jtfb_dcf.get_parameter_value(p_parameters, 'P_SCALE_BY');

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
192: select meaning into vScaleByMeaning from ams_lookups

Line 189: --vRepName := jtfb_dcf.get_parameter_value(p_parameters, 'P_TITLE_NAME_KP');

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
192: select meaning into vScaleByMeaning from ams_lookups
193: where lookup_type ='AMS_IO_SCALE_BY' and lookup_code = vScaleByCode;

Line 218: vCompCode := jtfb_dcf.get_parameter_value(p_parameters, 'DCF.componentCode');

214: vScaleByMeaning varchar2(80);
215: vCompCode varchar2(80);
216:
217: BEGIN
218: vCompCode := jtfb_dcf.get_parameter_value(p_parameters, 'DCF.componentCode');
219: select
220: meaning into vRepName
221: from
222: fnd_lookup_values

Line 229: vScaleByCode := jtfb_dcf.get_parameter_value(p_parameters, 'P_SCALE_BY');

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
233: select meaning into vScaleByMeaning from ams_lookups

Line 230: --vRepName := jtfb_dcf.get_parameter_value(p_parameters, 'P_TITLE_NAME_MB');

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
233: select meaning into vScaleByMeaning from ams_lookups
234: where lookup_type ='AMS_IO_SCALE_BY' and lookup_code = vScaleByCode;

Line 259: vCompCode := jtfb_dcf.get_parameter_value(p_parameters, 'DCF.componentCode');

255: vScaleByMeaning varchar2(80);
256: vCompCode varchar2(80);
257:
258: BEGIN
259: vCompCode := jtfb_dcf.get_parameter_value(p_parameters, 'DCF.componentCode');
260: select
261: meaning into vRepName
262: from
263: fnd_lookup_values

Line 270: vScaleByCode := jtfb_dcf.get_parameter_value(p_parameters, 'P_SCALE_BY');

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
274: select meaning into vScaleByMeaning from ams_lookups

Line 271: --vRepName := jtfb_dcf.get_parameter_value(p_parameters, 'P_TITLE_NAME_CE');

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
274: select meaning into vScaleByMeaning from ams_lookups
275: where lookup_type ='AMS_IO_SCALE_BY' and lookup_code = vScaleByCode;

Line 301: vCompCode := jtfb_dcf.get_parameter_value(p_parameters, 'DCF.componentCode');

297: vScaleByMeaning varchar2(80);
298: vCompCode varchar2(80);
299:
300: BEGIN
301: vCompCode := jtfb_dcf.get_parameter_value(p_parameters, 'DCF.componentCode');
302: select
303: meaning into vRepName
304: from
305: fnd_lookup_values

Line 312: vScaleByCode := jtfb_dcf.get_parameter_value(p_parameters, 'P_SCALE_BY');

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
316: select meaning into vScaleByMeaning from ams_lookups

Line 313: --vRepName := jtfb_dcf.get_parameter_value(p_parameters, 'P_TITLE_NAME_EE');

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
316: select meaning into vScaleByMeaning from ams_lookups
317: where lookup_type ='AMS_IO_SCALE_BY' and lookup_code = vScaleByCode;

Line 352: vCompCode := jtfb_dcf.get_parameter_value(p_parameters, 'DCF.componentCode');

348:
349:
350:
351: BEGIN
352: vCompCode := jtfb_dcf.get_parameter_value(p_parameters, 'DCF.componentCode');
353: select
354: meaning into vRepName
355: from
356: fnd_lookup_values

Line 361: vContext := jtfb_dcf.get_parameter_value(p_parameters, 'pContext');

357: where
358: lookup_type= 'BIM_DBC_DCF_TITLES'
359: and lookup_code = vCompCode
360: and language = userenv('LANG');
361: vContext := jtfb_dcf.get_parameter_value(p_parameters, 'pContext');
362: --vRepName := jtfb_dcf.get_parameter_value(p_parameters, 'P_REPORT_NAME');
363: vSource := jtfb_dcf.get_parameter_value(p_parameters, 'P_BIN_NAME');
364: if vSource not in ('N','NOT_FOUND') then
365: if vCompcode in ('AMS_REP_CAMP_BY_LEAD_OPPO','AMS_REP_CAMP_BY_BUDGET_AMT','AMS_REP_CAMPAIGNS_BY_ORDER','AMS_CAMP_BY_ACTIVITY') then

Line 362: --vRepName := jtfb_dcf.get_parameter_value(p_parameters, 'P_REPORT_NAME');

358: lookup_type= 'BIM_DBC_DCF_TITLES'
359: and lookup_code = vCompCode
360: and language = userenv('LANG');
361: vContext := jtfb_dcf.get_parameter_value(p_parameters, 'pContext');
362: --vRepName := jtfb_dcf.get_parameter_value(p_parameters, 'P_REPORT_NAME');
363: vSource := jtfb_dcf.get_parameter_value(p_parameters, 'P_BIN_NAME');
364: if vSource not in ('N','NOT_FOUND') then
365: if vCompcode in ('AMS_REP_CAMP_BY_LEAD_OPPO','AMS_REP_CAMP_BY_BUDGET_AMT','AMS_REP_CAMPAIGNS_BY_ORDER','AMS_CAMP_BY_ACTIVITY') then
366: vSource :='AMS_BIN_CAMP_EFFECTIVENESS';

Line 363: vSource := jtfb_dcf.get_parameter_value(p_parameters, 'P_BIN_NAME');

359: and lookup_code = vCompCode
360: and language = userenv('LANG');
361: vContext := jtfb_dcf.get_parameter_value(p_parameters, 'pContext');
362: --vRepName := jtfb_dcf.get_parameter_value(p_parameters, 'P_REPORT_NAME');
363: vSource := jtfb_dcf.get_parameter_value(p_parameters, 'P_BIN_NAME');
364: if vSource not in ('N','NOT_FOUND') then
365: if vCompcode in ('AMS_REP_CAMP_BY_LEAD_OPPO','AMS_REP_CAMP_BY_BUDGET_AMT','AMS_REP_CAMPAIGNS_BY_ORDER','AMS_CAMP_BY_ACTIVITY') then
366: vSource :='AMS_BIN_CAMP_EFFECTIVENESS';
367: elsif vCompcode in ('AMS_BUDGET_TOTAL_AMT','AMS_BUDGET_ACTIVITY','AMS_REP_BUD_BY_CAMPAIGN','AMS_REP_BUD_BY_BU','AMS_GRAPH_BGT_UTL_BY_BU','AMS_GRAPH_BGT_UTL_BY_CAT') then

Line 375: -- vSource := jtfb_dcf.get_parameter_value(p_parameters, 'P_BIN_NAME');

371: elsif vCompcode in ( 'AMS_REP_MARK_ACTI','AMS_REP_MARK_CAMP') then
372: vSource :='AMS_BIN_MARKET_ACTIV';
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';

Line 376: vDefPeriod := jtfb_dcf.get_parameter_value(p_parameters, 'P_DEF_PERIOD');

372: vSource :='AMS_BIN_MARKET_ACTIV';
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';

Line 477: vCompCode := jtfb_dcf.get_parameter_value(p_parameters, 'DCF.componentCode');

473: xPeriod varchar2(80);
474: vCompCode varchar2(80);
475:
476: BEGIN
477: vCompCode := jtfb_dcf.get_parameter_value(p_parameters, 'DCF.componentCode');
478: select
479: meaning into vRepName
480: from
481: fnd_lookup_values

Line 486: vContext := jtfb_dcf.get_parameter_value(p_parameters, 'pContext');

482: where
483: lookup_type= 'BIM_DBC_DCF_TITLES'
484: and lookup_code = vCompCode
485: and language = userenv('LANG');
486: vContext := jtfb_dcf.get_parameter_value(p_parameters, 'pContext');
487: --vRepName := jtfb_dcf.get_parameter_value(p_parameters, 'P_REPORT_NAME');
488:
489: select substr(vContext,INSTR(vContext,'-',-1)+1) into xIncr from dual;
490:

Line 487: --vRepName := jtfb_dcf.get_parameter_value(p_parameters, 'P_REPORT_NAME');

483: lookup_type= 'BIM_DBC_DCF_TITLES'
484: and lookup_code = vCompCode
485: and language = userenv('LANG');
486: vContext := jtfb_dcf.get_parameter_value(p_parameters, 'pContext');
487: --vRepName := jtfb_dcf.get_parameter_value(p_parameters, 'P_REPORT_NAME');
488:
489: select substr(vContext,INSTR(vContext,'-',-1)+1) into xIncr from dual;
490:
491: select start_date ||'-'|| end_date into xPeriod from bim_r_periods where calc_type = 'ROLLING' and period_type = xIncr;

Line 510: vCompCode := jtfb_dcf.get_parameter_value(p_parameters, 'DCF.componentCode');

506: xCount varchar2(80);
507: vCompCode varchar2(80);
508:
509: BEGIN
510: vCompCode := jtfb_dcf.get_parameter_value(p_parameters, 'DCF.componentCode');
511: select
512: meaning into vRepName
513: from
514: fnd_lookup_values

Line 519: vPeriod := jtfb_dcf.get_parameter_value(p_parameters, 'P_AGGREGATE_BY');

515: where
516: lookup_type= 'BIM_DBC_DCF_TITLES'
517: and lookup_code = vCompCode
518: and language = userenv('LANG');
519: vPeriod := jtfb_dcf.get_parameter_value(p_parameters, 'P_AGGREGATE_BY');
520: --vReportName := jtfb_dcf.get_parameter_value(p_parameters, 'P_REP_NAME');
521: if (vPeriod = 'INCREMENT') then
522: select to_char(current_count_value,'999,999,999,999') into xCount from bim_r_camp_act_bin_mv a
523: where a.aggregate_by = 'INCREMENT'

Line 520: --vReportName := jtfb_dcf.get_parameter_value(p_parameters, 'P_REP_NAME');

516: lookup_type= 'BIM_DBC_DCF_TITLES'
517: and lookup_code = vCompCode
518: and language = userenv('LANG');
519: vPeriod := jtfb_dcf.get_parameter_value(p_parameters, 'P_AGGREGATE_BY');
520: --vReportName := jtfb_dcf.get_parameter_value(p_parameters, 'P_REP_NAME');
521: if (vPeriod = 'INCREMENT') then
522: select to_char(current_count_value,'999,999,999,999') into xCount from bim_r_camp_act_bin_mv a
523: where a.aggregate_by = 'INCREMENT'
524: and a.year is not null

Line 562: vRepName := jtfb_dcf.get_parameter_value(p_parameters, 'P_REPORT_NAME');

558: vIn varchar2(80);
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||') ' );

Line 596: vCompCode := jtfb_dcf.get_parameter_value(p_parameters, 'DCF.componentCode');

592: vCompCode varchar2(80);
593:
594:
595: BEGIN
596: vCompCode := jtfb_dcf.get_parameter_value(p_parameters, 'DCF.componentCode');
597: select
598: meaning into vRepName
599: from
600: fnd_lookup_values

Line 605: vContext := jtfb_dcf.get_parameter_value(p_parameters, 'pContext');

601: where
602: lookup_type= 'BIM_DBC_DCF_TITLES'
603: and lookup_code = vCompCode
604: and language = userenv('LANG');
605: vContext := jtfb_dcf.get_parameter_value(p_parameters, 'pContext');
606: --vRepName := jtfb_dcf.get_parameter_value(p_parameters, 'P_REPORT_NAME');
607: vSource := jtfb_dcf.get_parameter_value(p_parameters, 'P_BIN_NAME');
608: if vSource not in ('NOT_FOUND','N') then
609: if vCompCode in ('AMS_GRAPH_EVENT_BY_ATTEND','AMS_GRAPH_EVENT_BY_LEAD','AMS_REP_EVENT_BY_REGISTRAN') then

Line 606: --vRepName := jtfb_dcf.get_parameter_value(p_parameters, 'P_REPORT_NAME');

602: lookup_type= 'BIM_DBC_DCF_TITLES'
603: and lookup_code = vCompCode
604: and language = userenv('LANG');
605: vContext := jtfb_dcf.get_parameter_value(p_parameters, 'pContext');
606: --vRepName := jtfb_dcf.get_parameter_value(p_parameters, 'P_REPORT_NAME');
607: vSource := jtfb_dcf.get_parameter_value(p_parameters, 'P_BIN_NAME');
608: if vSource not in ('NOT_FOUND','N') then
609: if vCompCode in ('AMS_GRAPH_EVENT_BY_ATTEND','AMS_GRAPH_EVENT_BY_LEAD','AMS_REP_EVENT_BY_REGISTRAN') then
610: vSource := 'AMS_BIN_EVENT_EFFECTIVENES';

Line 607: vSource := jtfb_dcf.get_parameter_value(p_parameters, 'P_BIN_NAME');

603: and lookup_code = vCompCode
604: and language = userenv('LANG');
605: vContext := jtfb_dcf.get_parameter_value(p_parameters, 'pContext');
606: --vRepName := jtfb_dcf.get_parameter_value(p_parameters, 'P_REPORT_NAME');
607: vSource := jtfb_dcf.get_parameter_value(p_parameters, 'P_BIN_NAME');
608: if vSource not in ('NOT_FOUND','N') then
609: if vCompCode in ('AMS_GRAPH_EVENT_BY_ATTEND','AMS_GRAPH_EVENT_BY_LEAD','AMS_REP_EVENT_BY_REGISTRAN') then
610: vSource := 'AMS_BIN_EVENT_EFFECTIVENES';
611: elsif vCompCode in ('AMS_GRAPH_BGT_UTL_BY_BU','AMS_GRAPH_BGT_UTL_BY_CAT') then

Line 617: vDefPeriod := jtfb_dcf.get_parameter_value(p_parameters, 'P_DEF_PERIOD');

613: elsif vCompCode in ('AMS_GRAPH_CAMP_BY_LEADS','AMS_GRAPH_CAMP_BY_OPPOR') then
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