143:
144: BEGIN
145:
146: IF l_period_type = 'FII_TIME_ENT_YEAR'
147: THEN l_effective_start_date := FII_TIME_API.Ent_Cyr_Start(l_as_of_date);
148: ELSIF l_period_type = 'FII_TIME_ENT_QTR'
149: THEN l_effective_start_date := FII_TIME_API.Ent_Cqtr_Start(l_as_of_date);
150: ELSIF l_period_type = 'FII_TIME_ENT_PERIOD'
151: THEN l_effective_start_date := FII_TIME_API.Ent_Cper_Start(l_as_of_date);
145:
146: IF l_period_type = 'FII_TIME_ENT_YEAR'
147: THEN l_effective_start_date := FII_TIME_API.Ent_Cyr_Start(l_as_of_date);
148: ELSIF l_period_type = 'FII_TIME_ENT_QTR'
149: THEN l_effective_start_date := FII_TIME_API.Ent_Cqtr_Start(l_as_of_date);
150: ELSIF l_period_type = 'FII_TIME_ENT_PERIOD'
151: THEN l_effective_start_date := FII_TIME_API.Ent_Cper_Start(l_as_of_date);
152: ELSE -- l_period_type = 'FII_TIME_WEEK'
153: l_effective_start_date := FII_TIME_API.Cwk_Start(l_as_of_date);
147: THEN l_effective_start_date := FII_TIME_API.Ent_Cyr_Start(l_as_of_date);
148: ELSIF l_period_type = 'FII_TIME_ENT_QTR'
149: THEN l_effective_start_date := FII_TIME_API.Ent_Cqtr_Start(l_as_of_date);
150: ELSIF l_period_type = 'FII_TIME_ENT_PERIOD'
151: THEN l_effective_start_date := FII_TIME_API.Ent_Cper_Start(l_as_of_date);
152: ELSE -- l_period_type = 'FII_TIME_WEEK'
153: l_effective_start_date := FII_TIME_API.Cwk_Start(l_as_of_date);
154: END IF;
155:
149: THEN l_effective_start_date := FII_TIME_API.Ent_Cqtr_Start(l_as_of_date);
150: ELSIF l_period_type = 'FII_TIME_ENT_PERIOD'
151: THEN l_effective_start_date := FII_TIME_API.Ent_Cper_Start(l_as_of_date);
152: ELSE -- l_period_type = 'FII_TIME_WEEK'
153: l_effective_start_date := FII_TIME_API.Cwk_Start(l_as_of_date);
154: END IF;
155:
156: l_cursor_id := DBMS_SQL.Open_Cursor;
157: l_stmt := '