DBA Data[Home] [Help]

APPS.BSC_BIS_CUSTOM_KPI_UTIL_PUB dependencies on BSC_TAB_IND_GROUPS_TL

Line 535: WHERE table_name = 'BSC_TAB_IND_GROUPS_TL'

531: AND column_name = 'USER_FUNCTION_NAME';
532:
533: SELECT data_length INTO l_tab_group_length
534: FROM SYS.ALL_TAB_COLUMNS
535: WHERE table_name = 'BSC_TAB_IND_GROUPS_TL'
536: AND column_name = 'NAME';
537:
538: --return the min of these two
539: IF (l_fnd_length > l_tab_group_length) THEN

Line 643: p_tab_grp_name BSC_TAB_IND_GROUPS_TL.NAME%TYPE

639: RETURN p_tab_name;
640: END Get_Unqiue_Tab_Name;
641:
642: FUNCTION Get_Unqiue_Tab_Group_Name(
643: p_tab_grp_name BSC_TAB_IND_GROUPS_TL.NAME%TYPE
644: ) RETURN BSC_TAB_IND_GROUPS_TL.NAME%TYPE IS
645: l_tab_grp_name BSC_TAB_IND_GROUPS_TL.NAME%TYPE;
646: l_flag BOOLEAN := TRUE;
647: l_count NUMBER;

Line 644: ) RETURN BSC_TAB_IND_GROUPS_TL.NAME%TYPE IS

640: END Get_Unqiue_Tab_Name;
641:
642: FUNCTION Get_Unqiue_Tab_Group_Name(
643: p_tab_grp_name BSC_TAB_IND_GROUPS_TL.NAME%TYPE
644: ) RETURN BSC_TAB_IND_GROUPS_TL.NAME%TYPE IS
645: l_tab_grp_name BSC_TAB_IND_GROUPS_TL.NAME%TYPE;
646: l_flag BOOLEAN := TRUE;
647: l_count NUMBER;
648: l_loop_count NUMBER := 0;

Line 645: l_tab_grp_name BSC_TAB_IND_GROUPS_TL.NAME%TYPE;

641:
642: FUNCTION Get_Unqiue_Tab_Group_Name(
643: p_tab_grp_name BSC_TAB_IND_GROUPS_TL.NAME%TYPE
644: ) RETURN BSC_TAB_IND_GROUPS_TL.NAME%TYPE IS
645: l_tab_grp_name BSC_TAB_IND_GROUPS_TL.NAME%TYPE;
646: l_flag BOOLEAN := TRUE;
647: l_count NUMBER;
648: l_loop_count NUMBER := 0;
649: l_alias VARCHAR2(5) := NULL;

Line 689: p_tab_grp_name BSC_TAB_IND_GROUPS_TL.NAME%TYPE,

685: RETURN p_tab_grp_name;
686: END Get_Unqiue_Tab_Group_Name;
687:
688: FUNCTION Get_Unqiue_Tab_Group_Name(
689: p_tab_grp_name BSC_TAB_IND_GROUPS_TL.NAME%TYPE,
690: p_tab_grp_id BSC_TAB_IND_GROUPS_TL.IND_GROUP_ID%TYPE
691: ) RETURN BSC_TAB_IND_GROUPS_TL.NAME%TYPE IS
692: l_tab_grp_name BSC_TAB_IND_GROUPS_TL.NAME%TYPE;
693: l_flag BOOLEAN := TRUE;

Line 690: p_tab_grp_id BSC_TAB_IND_GROUPS_TL.IND_GROUP_ID%TYPE

686: END Get_Unqiue_Tab_Group_Name;
687:
688: FUNCTION Get_Unqiue_Tab_Group_Name(
689: p_tab_grp_name BSC_TAB_IND_GROUPS_TL.NAME%TYPE,
690: p_tab_grp_id BSC_TAB_IND_GROUPS_TL.IND_GROUP_ID%TYPE
691: ) RETURN BSC_TAB_IND_GROUPS_TL.NAME%TYPE IS
692: l_tab_grp_name BSC_TAB_IND_GROUPS_TL.NAME%TYPE;
693: l_flag BOOLEAN := TRUE;
694: l_count NUMBER;

Line 691: ) RETURN BSC_TAB_IND_GROUPS_TL.NAME%TYPE IS

687:
688: FUNCTION Get_Unqiue_Tab_Group_Name(
689: p_tab_grp_name BSC_TAB_IND_GROUPS_TL.NAME%TYPE,
690: p_tab_grp_id BSC_TAB_IND_GROUPS_TL.IND_GROUP_ID%TYPE
691: ) RETURN BSC_TAB_IND_GROUPS_TL.NAME%TYPE IS
692: l_tab_grp_name BSC_TAB_IND_GROUPS_TL.NAME%TYPE;
693: l_flag BOOLEAN := TRUE;
694: l_count NUMBER;
695: l_loop_count NUMBER := 0;

Line 692: l_tab_grp_name BSC_TAB_IND_GROUPS_TL.NAME%TYPE;

688: FUNCTION Get_Unqiue_Tab_Group_Name(
689: p_tab_grp_name BSC_TAB_IND_GROUPS_TL.NAME%TYPE,
690: p_tab_grp_id BSC_TAB_IND_GROUPS_TL.IND_GROUP_ID%TYPE
691: ) RETURN BSC_TAB_IND_GROUPS_TL.NAME%TYPE IS
692: l_tab_grp_name BSC_TAB_IND_GROUPS_TL.NAME%TYPE;
693: l_flag BOOLEAN := TRUE;
694: l_count NUMBER;
695: l_loop_count NUMBER := 0;
696: l_alias VARCHAR2(5) := NULL;