DBA Data[Home] [Help]

APPS.BIM_IRES_COLLECTION_PKG dependencies on BIM_SET_OF_BOOKS

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

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

Line 75: l_cur_period_end_date := BIM_SET_OF_BOOKS.GET_FISCAL_MONTH_END(l_date, 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;

Line 77: l_pre_period_start_date := BIM_SET_OF_BOOKS.GET_FISCAL_MONTH_START(l_cur_period_start_date - 1, l_org_id);

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

Line 78: l_pre_period_end_date := BIM_SET_OF_BOOKS.GET_FISCAL_MONTH_END(l_cur_period_start_date - 1, 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);

Line 81: l_cur_period_start_date := BIM_SET_OF_BOOKS.GET_FISCAL_QTR_START(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);

Line 82: l_cur_period_end_date := BIM_SET_OF_BOOKS.GET_FISCAL_QTR_END(l_date, 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;

Line 84: l_pre_period_start_date := BIM_SET_OF_BOOKS.GET_FISCAL_QTR_START(l_cur_period_start_date - 1, l_org_id);

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

Line 85: l_pre_period_end_date := BIM_SET_OF_BOOKS.GET_FISCAL_QTR_END(l_cur_period_start_date - 1, 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);

Line 88: l_cur_period_start_date := BIM_SET_OF_BOOKS.GET_FISCAL_ROLL_YEAR_START(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);

Line 89: l_cur_period_end_date := BIM_SET_OF_BOOKS.GET_FISCAL_QTR_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;

Line 91: l_pre_period_start_date := BIM_SET_OF_BOOKS.GET_PRE_FISCAL_ROLL_YEAR_START(l_date, l_org_id);

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;

Line 92: l_pre_period_end_date := BIM_SET_OF_BOOKS.GET_PRE_FISCAL_ROLL_YEAR_END(l_date, l_org_id);

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;