DBA Data[Home] [Help]

APPS.ISC_DBI_PLAN_INV_T_TREND_PKG dependencies on FII_TIME_API

Line 160: l_cur_end := FII_TIME_API.next_period_end_date(l_cur_end, l_period_type);

156: l_cur_end := l_time_from;
157:
158: FOR i IN 1..l_loop
159: LOOP
160: l_cur_end := FII_TIME_API.next_period_end_date(l_cur_end, l_period_type);
161: END LOOP;
162:
163: l_pre_start := FII_TIME_API.ent_pper_start(l_cur_start); -- get the previous month
164: l_pre_end := FII_TIME_API.ent_pper_end(l_cur_end); -- get the previous month

Line 163: l_pre_start := FII_TIME_API.ent_pper_start(l_cur_start); -- get the previous month

159: LOOP
160: l_cur_end := FII_TIME_API.next_period_end_date(l_cur_end, l_period_type);
161: END LOOP;
162:
163: l_pre_start := FII_TIME_API.ent_pper_start(l_cur_start); -- get the previous month
164: l_pre_end := FII_TIME_API.ent_pper_end(l_cur_end); -- get the previous month
165:
166:
167: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

Line 164: l_pre_end := FII_TIME_API.ent_pper_end(l_cur_end); -- get the previous month

160: l_cur_end := FII_TIME_API.next_period_end_date(l_cur_end, l_period_type);
161: END LOOP;
162:
163: l_pre_start := FII_TIME_API.ent_pper_start(l_cur_start); -- get the previous month
164: l_pre_end := FII_TIME_API.ent_pper_end(l_cur_end); -- get the previous month
165:
166:
167: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
168: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();