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 BIM_SET_OF_BOOKS

Line 70: l_cur_period_start_date := BIM_SET_OF_BOOKS.GET_FISCAL_MONTH_START(l_date, l_org_id);

66: END IF;
67: END IF;
68:
69: IF (p_aggregate = l_month_code) THEN
70: l_cur_period_start_date := BIM_SET_OF_BOOKS.GET_FISCAL_MONTH_START(l_date, l_org_id);
71: l_cur_period_end_date := BIM_SET_OF_BOOKS.GET_FISCAL_MONTH_END(l_date, l_org_id);
72: IF (p_period = 'Previous') THEN
73: l_prev_period_start_date := BIM_SET_OF_BOOKS.GET_FISCAL_MONTH_START(l_cur_period_start_date - 1, l_org_id);
74: l_prev_period_end_date := BIM_SET_OF_BOOKS.GET_FISCAL_MONTH_END(l_cur_period_start_date - 1, l_org_id);

Line 71: l_cur_period_end_date := BIM_SET_OF_BOOKS.GET_FISCAL_MONTH_END(l_date, l_org_id);

67: END IF;
68:
69: IF (p_aggregate = l_month_code) THEN
70: l_cur_period_start_date := BIM_SET_OF_BOOKS.GET_FISCAL_MONTH_START(l_date, l_org_id);
71: l_cur_period_end_date := BIM_SET_OF_BOOKS.GET_FISCAL_MONTH_END(l_date, l_org_id);
72: IF (p_period = 'Previous') THEN
73: l_prev_period_start_date := BIM_SET_OF_BOOKS.GET_FISCAL_MONTH_START(l_cur_period_start_date - 1, l_org_id);
74: l_prev_period_end_date := BIM_SET_OF_BOOKS.GET_FISCAL_MONTH_END(l_cur_period_start_date - 1, l_org_id);
75: END IF;

Line 73: l_prev_period_start_date := BIM_SET_OF_BOOKS.GET_FISCAL_MONTH_START(l_cur_period_start_date - 1, l_org_id);

69: IF (p_aggregate = l_month_code) THEN
70: l_cur_period_start_date := BIM_SET_OF_BOOKS.GET_FISCAL_MONTH_START(l_date, l_org_id);
71: l_cur_period_end_date := BIM_SET_OF_BOOKS.GET_FISCAL_MONTH_END(l_date, l_org_id);
72: IF (p_period = 'Previous') THEN
73: l_prev_period_start_date := BIM_SET_OF_BOOKS.GET_FISCAL_MONTH_START(l_cur_period_start_date - 1, l_org_id);
74: l_prev_period_end_date := BIM_SET_OF_BOOKS.GET_FISCAL_MONTH_END(l_cur_period_start_date - 1, l_org_id);
75: END IF;
76: ELSIF (p_aggregate = l_quarter_code) THEN
77: l_cur_period_start_date := BIM_SET_OF_BOOKS.GET_FISCAL_QTR_START(l_date, l_org_id);

Line 74: l_prev_period_end_date := BIM_SET_OF_BOOKS.GET_FISCAL_MONTH_END(l_cur_period_start_date - 1, l_org_id);

70: l_cur_period_start_date := BIM_SET_OF_BOOKS.GET_FISCAL_MONTH_START(l_date, l_org_id);
71: l_cur_period_end_date := BIM_SET_OF_BOOKS.GET_FISCAL_MONTH_END(l_date, l_org_id);
72: IF (p_period = 'Previous') THEN
73: l_prev_period_start_date := BIM_SET_OF_BOOKS.GET_FISCAL_MONTH_START(l_cur_period_start_date - 1, l_org_id);
74: l_prev_period_end_date := BIM_SET_OF_BOOKS.GET_FISCAL_MONTH_END(l_cur_period_start_date - 1, l_org_id);
75: END IF;
76: ELSIF (p_aggregate = l_quarter_code) THEN
77: l_cur_period_start_date := BIM_SET_OF_BOOKS.GET_FISCAL_QTR_START(l_date, l_org_id);
78: l_cur_period_end_date := BIM_SET_OF_BOOKS.GET_FISCAL_QTR_END(l_date, l_org_id);

Line 77: l_cur_period_start_date := BIM_SET_OF_BOOKS.GET_FISCAL_QTR_START(l_date, l_org_id);

73: l_prev_period_start_date := BIM_SET_OF_BOOKS.GET_FISCAL_MONTH_START(l_cur_period_start_date - 1, l_org_id);
74: l_prev_period_end_date := BIM_SET_OF_BOOKS.GET_FISCAL_MONTH_END(l_cur_period_start_date - 1, l_org_id);
75: END IF;
76: ELSIF (p_aggregate = l_quarter_code) THEN
77: l_cur_period_start_date := BIM_SET_OF_BOOKS.GET_FISCAL_QTR_START(l_date, l_org_id);
78: l_cur_period_end_date := BIM_SET_OF_BOOKS.GET_FISCAL_QTR_END(l_date, l_org_id);
79: IF (p_period = 'Previous') THEN
80: l_prev_period_start_date := BIM_SET_OF_BOOKS.GET_FISCAL_QTR_START(l_cur_period_start_date - 1, l_org_id);
81: l_prev_period_end_date := BIM_SET_OF_BOOKS.GET_FISCAL_QTR_END(l_cur_period_start_date - 1, l_org_id);

Line 78: l_cur_period_end_date := BIM_SET_OF_BOOKS.GET_FISCAL_QTR_END(l_date, l_org_id);

74: l_prev_period_end_date := BIM_SET_OF_BOOKS.GET_FISCAL_MONTH_END(l_cur_period_start_date - 1, l_org_id);
75: END IF;
76: ELSIF (p_aggregate = l_quarter_code) THEN
77: l_cur_period_start_date := BIM_SET_OF_BOOKS.GET_FISCAL_QTR_START(l_date, l_org_id);
78: l_cur_period_end_date := BIM_SET_OF_BOOKS.GET_FISCAL_QTR_END(l_date, l_org_id);
79: IF (p_period = 'Previous') THEN
80: l_prev_period_start_date := BIM_SET_OF_BOOKS.GET_FISCAL_QTR_START(l_cur_period_start_date - 1, l_org_id);
81: l_prev_period_end_date := BIM_SET_OF_BOOKS.GET_FISCAL_QTR_END(l_cur_period_start_date - 1, l_org_id);
82: END IF;

Line 80: l_prev_period_start_date := BIM_SET_OF_BOOKS.GET_FISCAL_QTR_START(l_cur_period_start_date - 1, l_org_id);

76: ELSIF (p_aggregate = l_quarter_code) THEN
77: l_cur_period_start_date := BIM_SET_OF_BOOKS.GET_FISCAL_QTR_START(l_date, l_org_id);
78: l_cur_period_end_date := BIM_SET_OF_BOOKS.GET_FISCAL_QTR_END(l_date, l_org_id);
79: IF (p_period = 'Previous') THEN
80: l_prev_period_start_date := BIM_SET_OF_BOOKS.GET_FISCAL_QTR_START(l_cur_period_start_date - 1, l_org_id);
81: l_prev_period_end_date := BIM_SET_OF_BOOKS.GET_FISCAL_QTR_END(l_cur_period_start_date - 1, l_org_id);
82: END IF;
83: ELSIF (p_aggregate = l_year_code) THEN
84: l_cur_period_start_date := BIM_SET_OF_BOOKS.GET_FISCAL_YEAR_START(l_date, l_org_id);

Line 81: l_prev_period_end_date := BIM_SET_OF_BOOKS.GET_FISCAL_QTR_END(l_cur_period_start_date - 1, l_org_id);

77: l_cur_period_start_date := BIM_SET_OF_BOOKS.GET_FISCAL_QTR_START(l_date, l_org_id);
78: l_cur_period_end_date := BIM_SET_OF_BOOKS.GET_FISCAL_QTR_END(l_date, l_org_id);
79: IF (p_period = 'Previous') THEN
80: l_prev_period_start_date := BIM_SET_OF_BOOKS.GET_FISCAL_QTR_START(l_cur_period_start_date - 1, l_org_id);
81: l_prev_period_end_date := BIM_SET_OF_BOOKS.GET_FISCAL_QTR_END(l_cur_period_start_date - 1, l_org_id);
82: END IF;
83: ELSIF (p_aggregate = l_year_code) THEN
84: l_cur_period_start_date := BIM_SET_OF_BOOKS.GET_FISCAL_YEAR_START(l_date, l_org_id);
85: l_cur_period_end_date := BIM_SET_OF_BOOKS.GET_FISCAL_YEAR_END(l_date, l_org_id);

Line 84: l_cur_period_start_date := BIM_SET_OF_BOOKS.GET_FISCAL_YEAR_START(l_date, l_org_id);

80: l_prev_period_start_date := BIM_SET_OF_BOOKS.GET_FISCAL_QTR_START(l_cur_period_start_date - 1, l_org_id);
81: l_prev_period_end_date := BIM_SET_OF_BOOKS.GET_FISCAL_QTR_END(l_cur_period_start_date - 1, l_org_id);
82: END IF;
83: ELSIF (p_aggregate = l_year_code) THEN
84: l_cur_period_start_date := BIM_SET_OF_BOOKS.GET_FISCAL_YEAR_START(l_date, l_org_id);
85: l_cur_period_end_date := BIM_SET_OF_BOOKS.GET_FISCAL_YEAR_END(l_date, l_org_id);
86: IF (p_period = 'Previous') THEN
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);

Line 85: l_cur_period_end_date := BIM_SET_OF_BOOKS.GET_FISCAL_YEAR_END(l_date, l_org_id);

81: l_prev_period_end_date := BIM_SET_OF_BOOKS.GET_FISCAL_QTR_END(l_cur_period_start_date - 1, l_org_id);
82: END IF;
83: ELSIF (p_aggregate = l_year_code) THEN
84: l_cur_period_start_date := BIM_SET_OF_BOOKS.GET_FISCAL_YEAR_START(l_date, l_org_id);
85: l_cur_period_end_date := BIM_SET_OF_BOOKS.GET_FISCAL_YEAR_END(l_date, l_org_id);
86: IF (p_period = 'Previous') THEN
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;

Line 87: l_prev_period_start_date := BIM_SET_OF_BOOKS.GET_FISCAL_YEAR_START(l_cur_period_start_date - 1, l_org_id);

83: ELSIF (p_aggregate = l_year_code) THEN
84: l_cur_period_start_date := BIM_SET_OF_BOOKS.GET_FISCAL_YEAR_START(l_date, l_org_id);
85: l_cur_period_end_date := BIM_SET_OF_BOOKS.GET_FISCAL_YEAR_END(l_date, l_org_id);
86: IF (p_period = 'Previous') THEN
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;

Line 88: l_prev_period_end_date := BIM_SET_OF_BOOKS.GET_FISCAL_YEAR_END(l_cur_period_start_date - 1, l_org_id);

84: l_cur_period_start_date := BIM_SET_OF_BOOKS.GET_FISCAL_YEAR_START(l_date, l_org_id);
85: l_cur_period_end_date := BIM_SET_OF_BOOKS.GET_FISCAL_YEAR_END(l_date, l_org_id);
86: IF (p_period = 'Previous') THEN
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;

Line 199: l_cur_year_start_date := BIM_SET_OF_BOOKS.GET_FISCAL_YEAR_START(l_date, l_org_id);

195: ams_utility_pvt.write_conc_log('BIM_R_KPI_FACT: POPULATE START');
196: l_return := fnd_installation.get_app_info('BIM', l_status, l_industry, l_schema);
197: l_date := sysdate - 1;
198: l_org_id := 204;
199: l_cur_year_start_date := BIM_SET_OF_BOOKS.GET_FISCAL_YEAR_START(l_date, l_org_id);
200: l_cur_year_end_date := l_date;
201: l_pre_year_start_date := BIM_SET_OF_BOOKS.GET_PRE_FISCAL_YEAR_START(l_date, l_org_id);
202: l_pre_year_end_date := BIM_SET_OF_BOOKS.GET_PRE_FISCAL_YEAR_END(l_date, l_org_id);
203: l_cur_qtr_start_date := BIM_SET_OF_BOOKS.GET_FISCAL_QTR_START(l_date, l_org_id);

Line 201: l_pre_year_start_date := BIM_SET_OF_BOOKS.GET_PRE_FISCAL_YEAR_START(l_date, l_org_id);

197: l_date := sysdate - 1;
198: l_org_id := 204;
199: l_cur_year_start_date := BIM_SET_OF_BOOKS.GET_FISCAL_YEAR_START(l_date, l_org_id);
200: l_cur_year_end_date := l_date;
201: l_pre_year_start_date := BIM_SET_OF_BOOKS.GET_PRE_FISCAL_YEAR_START(l_date, l_org_id);
202: l_pre_year_end_date := BIM_SET_OF_BOOKS.GET_PRE_FISCAL_YEAR_END(l_date, l_org_id);
203: l_cur_qtr_start_date := BIM_SET_OF_BOOKS.GET_FISCAL_QTR_START(l_date, l_org_id);
204: l_cur_qtr_end_date := l_date;
205: l_pre_qtr_start_date := BIM_SET_OF_BOOKS.GET_PRE_FISCAL_QTR_START(l_date, l_org_id);

Line 202: l_pre_year_end_date := BIM_SET_OF_BOOKS.GET_PRE_FISCAL_YEAR_END(l_date, l_org_id);

198: l_org_id := 204;
199: l_cur_year_start_date := BIM_SET_OF_BOOKS.GET_FISCAL_YEAR_START(l_date, l_org_id);
200: l_cur_year_end_date := l_date;
201: l_pre_year_start_date := BIM_SET_OF_BOOKS.GET_PRE_FISCAL_YEAR_START(l_date, l_org_id);
202: l_pre_year_end_date := BIM_SET_OF_BOOKS.GET_PRE_FISCAL_YEAR_END(l_date, l_org_id);
203: l_cur_qtr_start_date := BIM_SET_OF_BOOKS.GET_FISCAL_QTR_START(l_date, l_org_id);
204: l_cur_qtr_end_date := l_date;
205: l_pre_qtr_start_date := BIM_SET_OF_BOOKS.GET_PRE_FISCAL_QTR_START(l_date, l_org_id);
206: l_pre_qtr_end_date := BIM_SET_OF_BOOKS.GET_PRE_FISCAL_QTR_END(l_date, l_org_id);

Line 203: l_cur_qtr_start_date := BIM_SET_OF_BOOKS.GET_FISCAL_QTR_START(l_date, l_org_id);

199: l_cur_year_start_date := BIM_SET_OF_BOOKS.GET_FISCAL_YEAR_START(l_date, l_org_id);
200: l_cur_year_end_date := l_date;
201: l_pre_year_start_date := BIM_SET_OF_BOOKS.GET_PRE_FISCAL_YEAR_START(l_date, l_org_id);
202: l_pre_year_end_date := BIM_SET_OF_BOOKS.GET_PRE_FISCAL_YEAR_END(l_date, l_org_id);
203: l_cur_qtr_start_date := BIM_SET_OF_BOOKS.GET_FISCAL_QTR_START(l_date, l_org_id);
204: l_cur_qtr_end_date := l_date;
205: l_pre_qtr_start_date := BIM_SET_OF_BOOKS.GET_PRE_FISCAL_QTR_START(l_date, l_org_id);
206: l_pre_qtr_end_date := BIM_SET_OF_BOOKS.GET_PRE_FISCAL_QTR_END(l_date, l_org_id);
207: l_cur_month_start_date := BIM_SET_OF_BOOKS.GET_FISCAL_MONTH_START(l_date, l_org_id);

Line 205: l_pre_qtr_start_date := BIM_SET_OF_BOOKS.GET_PRE_FISCAL_QTR_START(l_date, l_org_id);

201: l_pre_year_start_date := BIM_SET_OF_BOOKS.GET_PRE_FISCAL_YEAR_START(l_date, l_org_id);
202: l_pre_year_end_date := BIM_SET_OF_BOOKS.GET_PRE_FISCAL_YEAR_END(l_date, l_org_id);
203: l_cur_qtr_start_date := BIM_SET_OF_BOOKS.GET_FISCAL_QTR_START(l_date, l_org_id);
204: l_cur_qtr_end_date := l_date;
205: l_pre_qtr_start_date := BIM_SET_OF_BOOKS.GET_PRE_FISCAL_QTR_START(l_date, l_org_id);
206: l_pre_qtr_end_date := BIM_SET_OF_BOOKS.GET_PRE_FISCAL_QTR_END(l_date, l_org_id);
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);

Line 206: l_pre_qtr_end_date := BIM_SET_OF_BOOKS.GET_PRE_FISCAL_QTR_END(l_date, l_org_id);

202: l_pre_year_end_date := BIM_SET_OF_BOOKS.GET_PRE_FISCAL_YEAR_END(l_date, l_org_id);
203: l_cur_qtr_start_date := BIM_SET_OF_BOOKS.GET_FISCAL_QTR_START(l_date, l_org_id);
204: l_cur_qtr_end_date := l_date;
205: l_pre_qtr_start_date := BIM_SET_OF_BOOKS.GET_PRE_FISCAL_QTR_START(l_date, l_org_id);
206: l_pre_qtr_end_date := BIM_SET_OF_BOOKS.GET_PRE_FISCAL_QTR_END(l_date, l_org_id);
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);

Line 207: l_cur_month_start_date := BIM_SET_OF_BOOKS.GET_FISCAL_MONTH_START(l_date, l_org_id);

203: l_cur_qtr_start_date := BIM_SET_OF_BOOKS.GET_FISCAL_QTR_START(l_date, l_org_id);
204: l_cur_qtr_end_date := l_date;
205: l_pre_qtr_start_date := BIM_SET_OF_BOOKS.GET_PRE_FISCAL_QTR_START(l_date, l_org_id);
206: l_pre_qtr_end_date := BIM_SET_OF_BOOKS.GET_PRE_FISCAL_QTR_END(l_date, l_org_id);
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;

Line 209: l_pre_month_start_date := BIM_SET_OF_BOOKS.GET_PRE_FISCAL_MONTH_START(l_date, l_org_id);

205: l_pre_qtr_start_date := BIM_SET_OF_BOOKS.GET_PRE_FISCAL_QTR_START(l_date, l_org_id);
206: l_pre_qtr_end_date := BIM_SET_OF_BOOKS.GET_PRE_FISCAL_QTR_END(l_date, l_org_id);
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 ;

Line 210: l_pre_month_end_date := BIM_SET_OF_BOOKS.GET_PRE_FISCAL_MONTH_END(l_date, l_org_id);

206: l_pre_qtr_end_date := BIM_SET_OF_BOOKS.GET_PRE_FISCAL_QTR_END(l_date, l_org_id);
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;