70: END IF;
71: END IF;
72:
73: IF (p_aggregate = l_month_code) THEN
74: l_cur_period_start_date := BIM_SET_OF_BOOKS.GET_FISCAL_MONTH_START(l_date, l_org_id);
75: l_cur_period_end_date := BIM_SET_OF_BOOKS.GET_FISCAL_MONTH_END(l_date, l_org_id);
76: IF (p_period = 'Previous') THEN
77: l_pre_period_start_date := BIM_SET_OF_BOOKS.GET_FISCAL_MONTH_START(l_cur_period_start_date - 1, l_org_id);
78: l_pre_period_end_date := BIM_SET_OF_BOOKS.GET_FISCAL_MONTH_END(l_cur_period_start_date - 1, l_org_id);
71: END IF;
72:
73: IF (p_aggregate = l_month_code) THEN
74: l_cur_period_start_date := BIM_SET_OF_BOOKS.GET_FISCAL_MONTH_START(l_date, l_org_id);
75: l_cur_period_end_date := BIM_SET_OF_BOOKS.GET_FISCAL_MONTH_END(l_date, l_org_id);
76: IF (p_period = 'Previous') THEN
77: l_pre_period_start_date := BIM_SET_OF_BOOKS.GET_FISCAL_MONTH_START(l_cur_period_start_date - 1, l_org_id);
78: l_pre_period_end_date := BIM_SET_OF_BOOKS.GET_FISCAL_MONTH_END(l_cur_period_start_date - 1, l_org_id);
79: END IF;
73: IF (p_aggregate = l_month_code) THEN
74: l_cur_period_start_date := BIM_SET_OF_BOOKS.GET_FISCAL_MONTH_START(l_date, l_org_id);
75: l_cur_period_end_date := BIM_SET_OF_BOOKS.GET_FISCAL_MONTH_END(l_date, l_org_id);
76: IF (p_period = 'Previous') THEN
77: l_pre_period_start_date := BIM_SET_OF_BOOKS.GET_FISCAL_MONTH_START(l_cur_period_start_date - 1, l_org_id);
78: l_pre_period_end_date := BIM_SET_OF_BOOKS.GET_FISCAL_MONTH_END(l_cur_period_start_date - 1, l_org_id);
79: END IF;
80: ELSIF (p_aggregate = l_quarter_code) THEN
81: l_cur_period_start_date := BIM_SET_OF_BOOKS.GET_FISCAL_QTR_START(l_date, l_org_id);
74: l_cur_period_start_date := BIM_SET_OF_BOOKS.GET_FISCAL_MONTH_START(l_date, l_org_id);
75: l_cur_period_end_date := BIM_SET_OF_BOOKS.GET_FISCAL_MONTH_END(l_date, l_org_id);
76: IF (p_period = 'Previous') THEN
77: l_pre_period_start_date := BIM_SET_OF_BOOKS.GET_FISCAL_MONTH_START(l_cur_period_start_date - 1, l_org_id);
78: l_pre_period_end_date := BIM_SET_OF_BOOKS.GET_FISCAL_MONTH_END(l_cur_period_start_date - 1, l_org_id);
79: END IF;
80: ELSIF (p_aggregate = l_quarter_code) THEN
81: l_cur_period_start_date := BIM_SET_OF_BOOKS.GET_FISCAL_QTR_START(l_date, l_org_id);
82: l_cur_period_end_date := BIM_SET_OF_BOOKS.GET_FISCAL_QTR_END(l_date, l_org_id);
77: l_pre_period_start_date := BIM_SET_OF_BOOKS.GET_FISCAL_MONTH_START(l_cur_period_start_date - 1, l_org_id);
78: l_pre_period_end_date := BIM_SET_OF_BOOKS.GET_FISCAL_MONTH_END(l_cur_period_start_date - 1, l_org_id);
79: END IF;
80: ELSIF (p_aggregate = l_quarter_code) THEN
81: l_cur_period_start_date := BIM_SET_OF_BOOKS.GET_FISCAL_QTR_START(l_date, l_org_id);
82: l_cur_period_end_date := BIM_SET_OF_BOOKS.GET_FISCAL_QTR_END(l_date, l_org_id);
83: IF (p_period = 'Previous') THEN
84: l_pre_period_start_date := BIM_SET_OF_BOOKS.GET_FISCAL_QTR_START(l_cur_period_start_date - 1, l_org_id);
85: l_pre_period_end_date := BIM_SET_OF_BOOKS.GET_FISCAL_QTR_END(l_cur_period_start_date - 1, l_org_id);
78: l_pre_period_end_date := BIM_SET_OF_BOOKS.GET_FISCAL_MONTH_END(l_cur_period_start_date - 1, l_org_id);
79: END IF;
80: ELSIF (p_aggregate = l_quarter_code) THEN
81: l_cur_period_start_date := BIM_SET_OF_BOOKS.GET_FISCAL_QTR_START(l_date, l_org_id);
82: l_cur_period_end_date := BIM_SET_OF_BOOKS.GET_FISCAL_QTR_END(l_date, l_org_id);
83: IF (p_period = 'Previous') THEN
84: l_pre_period_start_date := BIM_SET_OF_BOOKS.GET_FISCAL_QTR_START(l_cur_period_start_date - 1, l_org_id);
85: l_pre_period_end_date := BIM_SET_OF_BOOKS.GET_FISCAL_QTR_END(l_cur_period_start_date - 1, l_org_id);
86: END IF;
80: ELSIF (p_aggregate = l_quarter_code) THEN
81: l_cur_period_start_date := BIM_SET_OF_BOOKS.GET_FISCAL_QTR_START(l_date, l_org_id);
82: l_cur_period_end_date := BIM_SET_OF_BOOKS.GET_FISCAL_QTR_END(l_date, l_org_id);
83: IF (p_period = 'Previous') THEN
84: l_pre_period_start_date := BIM_SET_OF_BOOKS.GET_FISCAL_QTR_START(l_cur_period_start_date - 1, l_org_id);
85: l_pre_period_end_date := BIM_SET_OF_BOOKS.GET_FISCAL_QTR_END(l_cur_period_start_date - 1, l_org_id);
86: END IF;
87: ELSIF (p_aggregate = l_year_code) THEN
88: l_cur_period_start_date := BIM_SET_OF_BOOKS.GET_FISCAL_ROLL_YEAR_START(l_date, l_org_id);
81: l_cur_period_start_date := BIM_SET_OF_BOOKS.GET_FISCAL_QTR_START(l_date, l_org_id);
82: l_cur_period_end_date := BIM_SET_OF_BOOKS.GET_FISCAL_QTR_END(l_date, l_org_id);
83: IF (p_period = 'Previous') THEN
84: l_pre_period_start_date := BIM_SET_OF_BOOKS.GET_FISCAL_QTR_START(l_cur_period_start_date - 1, l_org_id);
85: l_pre_period_end_date := BIM_SET_OF_BOOKS.GET_FISCAL_QTR_END(l_cur_period_start_date - 1, l_org_id);
86: END IF;
87: ELSIF (p_aggregate = l_year_code) THEN
88: l_cur_period_start_date := BIM_SET_OF_BOOKS.GET_FISCAL_ROLL_YEAR_START(l_date, l_org_id);
89: l_cur_period_end_date := BIM_SET_OF_BOOKS.GET_FISCAL_QTR_END(l_date, l_org_id);
84: l_pre_period_start_date := BIM_SET_OF_BOOKS.GET_FISCAL_QTR_START(l_cur_period_start_date - 1, l_org_id);
85: l_pre_period_end_date := BIM_SET_OF_BOOKS.GET_FISCAL_QTR_END(l_cur_period_start_date - 1, l_org_id);
86: END IF;
87: ELSIF (p_aggregate = l_year_code) THEN
88: l_cur_period_start_date := BIM_SET_OF_BOOKS.GET_FISCAL_ROLL_YEAR_START(l_date, l_org_id);
89: l_cur_period_end_date := BIM_SET_OF_BOOKS.GET_FISCAL_QTR_END(l_date, l_org_id);
90: IF (p_period = 'Previous') THEN
91: l_pre_period_start_date := BIM_SET_OF_BOOKS.GET_PRE_FISCAL_ROLL_YEAR_START(l_date, l_org_id);
92: l_pre_period_end_date := BIM_SET_OF_BOOKS.GET_PRE_FISCAL_ROLL_YEAR_END(l_date, l_org_id);
85: l_pre_period_end_date := BIM_SET_OF_BOOKS.GET_FISCAL_QTR_END(l_cur_period_start_date - 1, l_org_id);
86: END IF;
87: ELSIF (p_aggregate = l_year_code) THEN
88: l_cur_period_start_date := BIM_SET_OF_BOOKS.GET_FISCAL_ROLL_YEAR_START(l_date, l_org_id);
89: l_cur_period_end_date := BIM_SET_OF_BOOKS.GET_FISCAL_QTR_END(l_date, l_org_id);
90: IF (p_period = 'Previous') THEN
91: l_pre_period_start_date := BIM_SET_OF_BOOKS.GET_PRE_FISCAL_ROLL_YEAR_START(l_date, l_org_id);
92: l_pre_period_end_date := BIM_SET_OF_BOOKS.GET_PRE_FISCAL_ROLL_YEAR_END(l_date, l_org_id);
93: END IF;
87: ELSIF (p_aggregate = l_year_code) THEN
88: l_cur_period_start_date := BIM_SET_OF_BOOKS.GET_FISCAL_ROLL_YEAR_START(l_date, l_org_id);
89: l_cur_period_end_date := BIM_SET_OF_BOOKS.GET_FISCAL_QTR_END(l_date, l_org_id);
90: IF (p_period = 'Previous') THEN
91: l_pre_period_start_date := BIM_SET_OF_BOOKS.GET_PRE_FISCAL_ROLL_YEAR_START(l_date, l_org_id);
92: l_pre_period_end_date := BIM_SET_OF_BOOKS.GET_PRE_FISCAL_ROLL_YEAR_END(l_date, l_org_id);
93: END IF;
94: ELSIF (p_aggregate = l_week_code) THEN
95: l_cur_period_start_date := l_date-7;
88: l_cur_period_start_date := BIM_SET_OF_BOOKS.GET_FISCAL_ROLL_YEAR_START(l_date, l_org_id);
89: l_cur_period_end_date := BIM_SET_OF_BOOKS.GET_FISCAL_QTR_END(l_date, l_org_id);
90: IF (p_period = 'Previous') THEN
91: l_pre_period_start_date := BIM_SET_OF_BOOKS.GET_PRE_FISCAL_ROLL_YEAR_START(l_date, l_org_id);
92: l_pre_period_end_date := BIM_SET_OF_BOOKS.GET_PRE_FISCAL_ROLL_YEAR_END(l_date, l_org_id);
93: END IF;
94: ELSIF (p_aggregate = l_week_code) THEN
95: l_cur_period_start_date := l_date-7;
96: l_cur_period_end_date := l_date;