614: ,p_Period_Id IN NUMBER
615: )RETURN VARCHAR2 IS
616: l_Short_Name BSC_SYS_PERIODICITIES.SHORT_NAME%TYPE;
617: l_Flag BOOLEAN;
618: l_Temp_Var BIS_LEVELS.SHORT_NAME%TYPE;
619: l_Count NUMBER;
620: l_alias VARCHAR2(4);
621:
622: BEGIN
629:
630: WHILE (l_flag) LOOP
631: SELECT COUNT(1)
632: INTO l_Count
633: FROM BIS_LEVELS_VL
634: WHERE UPPER(Short_Name) = UPPER(l_temp_var);
635:
636: IF (l_Count = 0) THEN
637: l_flag := FALSE;
661: , p_Periodicity_Name IN VARCHAR2
662: ) RETURN VARCHAR2 IS
663: l_Count NUMBER;
664: l_Calendar_Name BSC_SYS_CALENDARS_TL.NAME%TYPE;
665: l_Return_Name BIS_LEVELS_TL.NAME%TYPE;
666: l_Flag BOOLEAN;
667: l_Sequence NUMBER;
668: l_Temp_Var BIS_LEVELS_TL.NAME%TYPE;
669: BEGIN
664: l_Calendar_Name BSC_SYS_CALENDARS_TL.NAME%TYPE;
665: l_Return_Name BIS_LEVELS_TL.NAME%TYPE;
666: l_Flag BOOLEAN;
667: l_Sequence NUMBER;
668: l_Temp_Var BIS_LEVELS_TL.NAME%TYPE;
669: BEGIN
670: SELECT name
671: INTO l_Calendar_Name
672: FROM bsc_sys_calendars_vl
679: l_Temp_Var := l_Return_Name;
680: WHILE(l_Flag) LOOP
681: SELECT COUNT(1)
682: INTO l_Count
683: FROM bis_levels_vl
684: WHERE UPPER(name) = UPPER(l_Temp_Var);
685:
686: IF(l_Count = 0 ) THEN
687: l_Flag := FALSE;