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.BIX_CAMP_PERF_REPORT dependencies on JTFB_DCF

Line 320: v_campaign_id := to_number(jtfb_dcf.get_parameter_value(p_context,'P_CAMPAIGN_ID'));

316:
317: IF g_time_range IS NULL THEN
318: g_time_range := 1;
319: END IF;
320: v_campaign_id := to_number(jtfb_dcf.get_parameter_value(p_context,'P_CAMPAIGN_ID'));
321: v_site_id := to_number(jtfb_dcf.get_parameter_value(p_context,'P_SITE_ID'));
322: v_group_id := to_number(jtfb_dcf.get_parameter_value(p_context,'P_GROUP_ID'));
323: v_time := to_number(jtfb_dcf.get_parameter_value(p_context,'P_TIME'));
324: -- get the start period and end period

Line 321: v_site_id := to_number(jtfb_dcf.get_parameter_value(p_context,'P_SITE_ID'));

317: IF g_time_range IS NULL THEN
318: g_time_range := 1;
319: END IF;
320: v_campaign_id := to_number(jtfb_dcf.get_parameter_value(p_context,'P_CAMPAIGN_ID'));
321: v_site_id := to_number(jtfb_dcf.get_parameter_value(p_context,'P_SITE_ID'));
322: v_group_id := to_number(jtfb_dcf.get_parameter_value(p_context,'P_GROUP_ID'));
323: v_time := to_number(jtfb_dcf.get_parameter_value(p_context,'P_TIME'));
324: -- get the start period and end period
325: if (v_time <> 9) then

Line 322: v_group_id := to_number(jtfb_dcf.get_parameter_value(p_context,'P_GROUP_ID'));

318: g_time_range := 1;
319: END IF;
320: v_campaign_id := to_number(jtfb_dcf.get_parameter_value(p_context,'P_CAMPAIGN_ID'));
321: v_site_id := to_number(jtfb_dcf.get_parameter_value(p_context,'P_SITE_ID'));
322: v_group_id := to_number(jtfb_dcf.get_parameter_value(p_context,'P_GROUP_ID'));
323: v_time := to_number(jtfb_dcf.get_parameter_value(p_context,'P_TIME'));
324: -- get the start period and end period
325: if (v_time <> 9) then
326: if (v_time = 7) then

Line 323: v_time := to_number(jtfb_dcf.get_parameter_value(p_context,'P_TIME'));

319: END IF;
320: v_campaign_id := to_number(jtfb_dcf.get_parameter_value(p_context,'P_CAMPAIGN_ID'));
321: v_site_id := to_number(jtfb_dcf.get_parameter_value(p_context,'P_SITE_ID'));
322: v_group_id := to_number(jtfb_dcf.get_parameter_value(p_context,'P_GROUP_ID'));
323: v_time := to_number(jtfb_dcf.get_parameter_value(p_context,'P_TIME'));
324: -- get the start period and end period
325: if (v_time <> 9) then
326: if (v_time = 7) then
327: v_start_period := sysdate - 2;

Line 336: v_start_period := to_date(jtfb_dcf.get_parameter_value(p_context,'P_START_PERIOD'));

332: else
333: bix_util_pkg.get_time_range(v_time , v_start_period, v_end_period);
334: end if;
335: else
336: v_start_period := to_date(jtfb_dcf.get_parameter_value(p_context,'P_START_PERIOD'));
337: v_end_period := to_date(jtfb_dcf.get_parameter_value(p_context,'P_END_PERIOD'));
338: end if;
339: insert_temp_table(v_campaign_id, v_site_id, v_group_id, v_time, v_start_period, v_end_period);
340: EXCEPTION

Line 337: v_end_period := to_date(jtfb_dcf.get_parameter_value(p_context,'P_END_PERIOD'));

333: bix_util_pkg.get_time_range(v_time , v_start_period, v_end_period);
334: end if;
335: else
336: v_start_period := to_date(jtfb_dcf.get_parameter_value(p_context,'P_START_PERIOD'));
337: v_end_period := to_date(jtfb_dcf.get_parameter_value(p_context,'P_END_PERIOD'));
338: end if;
339: insert_temp_table(v_campaign_id, v_site_id, v_group_id, v_time, v_start_period, v_end_period);
340: EXCEPTION
341: WHEN OTHERS