104:
105: BEGIN
106:
107: IF l_period_type = 'FII_TIME_ENT_YEAR'
108: THEN l_effective_start_date := FII_TIME_API.Ent_Cyr_Start(l_as_of_date);
109: ELSIF l_period_type = 'FII_TIME_ENT_QTR'
110: THEN l_effective_start_date := FII_TIME_API.Ent_Cqtr_Start(l_as_of_date);
111: ELSIF l_period_type = 'FII_TIME_ENT_PERIOD'
112: THEN l_effective_start_date := FII_TIME_API.Ent_Cper_Start(l_as_of_date);
106:
107: IF l_period_type = 'FII_TIME_ENT_YEAR'
108: THEN l_effective_start_date := FII_TIME_API.Ent_Cyr_Start(l_as_of_date);
109: ELSIF l_period_type = 'FII_TIME_ENT_QTR'
110: THEN l_effective_start_date := FII_TIME_API.Ent_Cqtr_Start(l_as_of_date);
111: ELSIF l_period_type = 'FII_TIME_ENT_PERIOD'
112: THEN l_effective_start_date := FII_TIME_API.Ent_Cper_Start(l_as_of_date);
113: ELSE -- l_period_type = 'FII_TIME_WEEK'
114: l_effective_start_date := FII_TIME_API.Cwk_Start(l_as_of_date);
108: THEN l_effective_start_date := FII_TIME_API.Ent_Cyr_Start(l_as_of_date);
109: ELSIF l_period_type = 'FII_TIME_ENT_QTR'
110: THEN l_effective_start_date := FII_TIME_API.Ent_Cqtr_Start(l_as_of_date);
111: ELSIF l_period_type = 'FII_TIME_ENT_PERIOD'
112: THEN l_effective_start_date := FII_TIME_API.Ent_Cper_Start(l_as_of_date);
113: ELSE -- l_period_type = 'FII_TIME_WEEK'
114: l_effective_start_date := FII_TIME_API.Cwk_Start(l_as_of_date);
115: END IF;
116:
110: THEN l_effective_start_date := FII_TIME_API.Ent_Cqtr_Start(l_as_of_date);
111: ELSIF l_period_type = 'FII_TIME_ENT_PERIOD'
112: THEN l_effective_start_date := FII_TIME_API.Ent_Cper_Start(l_as_of_date);
113: ELSE -- l_period_type = 'FII_TIME_WEEK'
114: l_effective_start_date := FII_TIME_API.Cwk_Start(l_as_of_date);
115: END IF;
116:
117: l_cursor_id := DBMS_SQL.Open_Cursor;
118: