193:
194: BEGIN
195:
196: IF l_period_type = 'FII_TIME_ENT_YEAR'
197: THEN l_effective_start_date := FII_TIME_API.Ent_Cyr_Start(l_as_of_date);
198: ELSIF l_period_type = 'FII_TIME_ENT_QTR'
199: THEN l_effective_start_date := FII_TIME_API.Ent_Cqtr_Start(l_as_of_date);
200: ELSIF l_period_type = 'FII_TIME_ENT_PERIOD'
201: THEN l_effective_start_date := FII_TIME_API.Ent_Cper_Start(l_as_of_date);
195:
196: IF l_period_type = 'FII_TIME_ENT_YEAR'
197: THEN l_effective_start_date := FII_TIME_API.Ent_Cyr_Start(l_as_of_date);
198: ELSIF l_period_type = 'FII_TIME_ENT_QTR'
199: THEN l_effective_start_date := FII_TIME_API.Ent_Cqtr_Start(l_as_of_date);
200: ELSIF l_period_type = 'FII_TIME_ENT_PERIOD'
201: THEN l_effective_start_date := FII_TIME_API.Ent_Cper_Start(l_as_of_date);
202: ELSE -- l_period_type = 'FII_TIME_WEEK'
203: l_effective_start_date := FII_TIME_API.Cwk_Start(l_as_of_date);
197: THEN l_effective_start_date := FII_TIME_API.Ent_Cyr_Start(l_as_of_date);
198: ELSIF l_period_type = 'FII_TIME_ENT_QTR'
199: THEN l_effective_start_date := FII_TIME_API.Ent_Cqtr_Start(l_as_of_date);
200: ELSIF l_period_type = 'FII_TIME_ENT_PERIOD'
201: THEN l_effective_start_date := FII_TIME_API.Ent_Cper_Start(l_as_of_date);
202: ELSE -- l_period_type = 'FII_TIME_WEEK'
203: l_effective_start_date := FII_TIME_API.Cwk_Start(l_as_of_date);
204: END IF;
205:
199: THEN l_effective_start_date := FII_TIME_API.Ent_Cqtr_Start(l_as_of_date);
200: ELSIF l_period_type = 'FII_TIME_ENT_PERIOD'
201: THEN l_effective_start_date := FII_TIME_API.Ent_Cper_Start(l_as_of_date);
202: ELSE -- l_period_type = 'FII_TIME_WEEK'
203: l_effective_start_date := FII_TIME_API.Cwk_Start(l_as_of_date);
204: END IF;
205:
206: l_cursor_id := DBMS_SQL.Open_Cursor;
207: l_stmt := '