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.BIM_KPI_FACT dependencies on DUAL

Line 91: select next_day(l_date-7, TO_NUMBER(to_char(to_date('01/09/2004', 'DD/MM/RRRR'), 'DD'))) into l_cur_period_start_date from dual;

87: l_prev_period_start_date := BIM_SET_OF_BOOKS.GET_FISCAL_YEAR_START(l_cur_period_start_date - 1, l_org_id);
88: l_prev_period_end_date := BIM_SET_OF_BOOKS.GET_FISCAL_YEAR_END(l_cur_period_start_date - 1, l_org_id);
89: END IF;
90: ELSIF (p_aggregate = l_week_code) THEN
91: select next_day(l_date-7, TO_NUMBER(to_char(to_date('01/09/2004', 'DD/MM/RRRR'), 'DD'))) into l_cur_period_start_date from dual;
92: select next_day(l_date, TO_NUMBER(to_char(to_date('07/09/2004', 'DD/MM/RRRR'), 'DD'))) into l_cur_period_end_date from dual;
93: IF (p_period = 'Previous') THEN
94: select next_day(l_date-14, TO_NUMBER(to_char(to_date('01/09/2004', 'DD/MM/RRRR'), 'DD'))) into l_prev_period_start_date from dual;
95: select next_day(l_prev_period_start_date, TO_NUMBER(to_char(to_date('07/09/2004', 'DD/MM/RRRR'), 'DD'))) into l_prev_period_end_date from dual;

Line 92: select next_day(l_date, TO_NUMBER(to_char(to_date('07/09/2004', 'DD/MM/RRRR'), 'DD'))) into l_cur_period_end_date from dual;

88: l_prev_period_end_date := BIM_SET_OF_BOOKS.GET_FISCAL_YEAR_END(l_cur_period_start_date - 1, l_org_id);
89: END IF;
90: ELSIF (p_aggregate = l_week_code) THEN
91: select next_day(l_date-7, TO_NUMBER(to_char(to_date('01/09/2004', 'DD/MM/RRRR'), 'DD'))) into l_cur_period_start_date from dual;
92: select next_day(l_date, TO_NUMBER(to_char(to_date('07/09/2004', 'DD/MM/RRRR'), 'DD'))) into l_cur_period_end_date from dual;
93: IF (p_period = 'Previous') THEN
94: select next_day(l_date-14, TO_NUMBER(to_char(to_date('01/09/2004', 'DD/MM/RRRR'), 'DD'))) into l_prev_period_start_date from dual;
95: select next_day(l_prev_period_start_date, TO_NUMBER(to_char(to_date('07/09/2004', 'DD/MM/RRRR'), 'DD'))) into l_prev_period_end_date from dual;
96: END IF;

Line 94: select next_day(l_date-14, TO_NUMBER(to_char(to_date('01/09/2004', 'DD/MM/RRRR'), 'DD'))) into l_prev_period_start_date from dual;

90: ELSIF (p_aggregate = l_week_code) THEN
91: select next_day(l_date-7, TO_NUMBER(to_char(to_date('01/09/2004', 'DD/MM/RRRR'), 'DD'))) into l_cur_period_start_date from dual;
92: select next_day(l_date, TO_NUMBER(to_char(to_date('07/09/2004', 'DD/MM/RRRR'), 'DD'))) into l_cur_period_end_date from dual;
93: IF (p_period = 'Previous') THEN
94: select next_day(l_date-14, TO_NUMBER(to_char(to_date('01/09/2004', 'DD/MM/RRRR'), 'DD'))) into l_prev_period_start_date from dual;
95: select next_day(l_prev_period_start_date, TO_NUMBER(to_char(to_date('07/09/2004', 'DD/MM/RRRR'), 'DD'))) into l_prev_period_end_date from dual;
96: END IF;
97: END IF;
98: IF (p_period = 'Previous') THEN

Line 95: select next_day(l_prev_period_start_date, TO_NUMBER(to_char(to_date('07/09/2004', 'DD/MM/RRRR'), 'DD'))) into l_prev_period_end_date from dual;

91: select next_day(l_date-7, TO_NUMBER(to_char(to_date('01/09/2004', 'DD/MM/RRRR'), 'DD'))) into l_cur_period_start_date from dual;
92: select next_day(l_date, TO_NUMBER(to_char(to_date('07/09/2004', 'DD/MM/RRRR'), 'DD'))) into l_cur_period_end_date from dual;
93: IF (p_period = 'Previous') THEN
94: select next_day(l_date-14, TO_NUMBER(to_char(to_date('01/09/2004', 'DD/MM/RRRR'), 'DD'))) into l_prev_period_start_date from dual;
95: select next_day(l_prev_period_start_date, TO_NUMBER(to_char(to_date('07/09/2004', 'DD/MM/RRRR'), 'DD'))) into l_prev_period_end_date from dual;
96: END IF;
97: END IF;
98: IF (p_period = 'Previous') THEN
99: l_days := trunc(l_date) - trunc(l_cur_period_start_date);

Line 211: select next_day(trunc(l_date)-7, TO_NUMBER(to_char(to_date('01/09/2004', 'DD/MM/RRRR'), 'DD'))) into l_cur_week_start_date from dual;

207: l_cur_month_start_date := BIM_SET_OF_BOOKS.GET_FISCAL_MONTH_START(l_date, l_org_id);
208: l_cur_month_end_date := l_date;
209: l_pre_month_start_date := BIM_SET_OF_BOOKS.GET_PRE_FISCAL_MONTH_START(l_date, l_org_id);
210: l_pre_month_end_date := BIM_SET_OF_BOOKS.GET_PRE_FISCAL_MONTH_END(l_date, l_org_id);
211: select next_day(trunc(l_date)-7, TO_NUMBER(to_char(to_date('01/09/2004', 'DD/MM/RRRR'), 'DD'))) into l_cur_week_start_date from dual;
212: l_cur_week_end_date := trunc(l_date);
213: l_days := l_cur_week_end_date-l_cur_week_start_date ;
214: --l_days := l_days+1;
215: select next_day(trunc(l_date)-14, TO_NUMBER(to_char(to_date('01/09/2004', 'DD/MM/RRRR'), 'DD'))) into l_pre_week_start_date from dual;

Line 215: select next_day(trunc(l_date)-14, TO_NUMBER(to_char(to_date('01/09/2004', 'DD/MM/RRRR'), 'DD'))) into l_pre_week_start_date from dual;

211: select next_day(trunc(l_date)-7, TO_NUMBER(to_char(to_date('01/09/2004', 'DD/MM/RRRR'), 'DD'))) into l_cur_week_start_date from dual;
212: l_cur_week_end_date := trunc(l_date);
213: l_days := l_cur_week_end_date-l_cur_week_start_date ;
214: --l_days := l_days+1;
215: select next_day(trunc(l_date)-14, TO_NUMBER(to_char(to_date('01/09/2004', 'DD/MM/RRRR'), 'DD'))) into l_pre_week_start_date from dual;
216: l_pre_week_end_date := l_pre_week_start_date+l_days;
217:
218: ams_utility_pvt.write_conc_log('BIM_R_KPI_FACT: INSERT START');
219: