APPS.AMS_DCF_TITLE dependencies on BIM_R_PERIODS

Line 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;

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
52: WHEN OTHERS THEN

Line 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;

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
86: WHEN OTHERS THEN

Line 397: from bim_r_periods where calc_type = 'ROLLING' and period_type = xDisplayType;

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;
401: if (xQtr <> 'N') then

Line 415: from bim_r_periods where calc_type = 'ROLLING' and period_type = xDisplayType;

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;
419: if (xQtr <> 'N') then

Line 491: select start_date ||'-'|| end_date into xPeriod from bim_r_periods where calc_type = 'ROLLING' and period_type = xIncr;

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;
492:
493: return (vRepName||' '||xPeriod );
494: EXCEPTION
495: WHEN OTHERS THEN

Line 636: from bim_r_periods where calc_type = 'ROLLING' and period_type = xDisplayType;

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;
640: if (xQtr <> 'N') then

Line 654: from bim_r_periods where calc_type = 'ROLLING' and period_type = xDisplayType;

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;
658: if (xQtr <> 'N') then