117:
118: BEGIN
119:
120: IF l_period_type = 'FII_TIME_ENT_YEAR'
121: THEN l_effective_start_date := FII_TIME_API.Ent_Cyr_Start(l_as_of_date);
122: ELSIF l_period_type = 'FII_TIME_ENT_QTR'
123: THEN l_effective_start_date := FII_TIME_API.Ent_Cqtr_Start(l_as_of_date);
124: ELSIF l_period_type = 'FII_TIME_ENT_PERIOD'
125: THEN l_effective_start_date := FII_TIME_API.Ent_Cper_Start(l_as_of_date);
119:
120: IF l_period_type = 'FII_TIME_ENT_YEAR'
121: THEN l_effective_start_date := FII_TIME_API.Ent_Cyr_Start(l_as_of_date);
122: ELSIF l_period_type = 'FII_TIME_ENT_QTR'
123: THEN l_effective_start_date := FII_TIME_API.Ent_Cqtr_Start(l_as_of_date);
124: ELSIF l_period_type = 'FII_TIME_ENT_PERIOD'
125: THEN l_effective_start_date := FII_TIME_API.Ent_Cper_Start(l_as_of_date);
126: ELSE -- l_period_type = 'FII_TIME_WEEK'
127: l_effective_start_date := FII_TIME_API.Cwk_Start(l_as_of_date);
121: THEN l_effective_start_date := FII_TIME_API.Ent_Cyr_Start(l_as_of_date);
122: ELSIF l_period_type = 'FII_TIME_ENT_QTR'
123: THEN l_effective_start_date := FII_TIME_API.Ent_Cqtr_Start(l_as_of_date);
124: ELSIF l_period_type = 'FII_TIME_ENT_PERIOD'
125: THEN l_effective_start_date := FII_TIME_API.Ent_Cper_Start(l_as_of_date);
126: ELSE -- l_period_type = 'FII_TIME_WEEK'
127: l_effective_start_date := FII_TIME_API.Cwk_Start(l_as_of_date);
128: END IF;
129:
123: THEN l_effective_start_date := FII_TIME_API.Ent_Cqtr_Start(l_as_of_date);
124: ELSIF l_period_type = 'FII_TIME_ENT_PERIOD'
125: THEN l_effective_start_date := FII_TIME_API.Ent_Cper_Start(l_as_of_date);
126: ELSE -- l_period_type = 'FII_TIME_WEEK'
127: l_effective_start_date := FII_TIME_API.Cwk_Start(l_as_of_date);
128: END IF;
129:
130: l_cursor_id := DBMS_SQL.Open_Cursor;
131: l_stmt := '