APPS.BSC_SCORECARD_PUB dependencies on BSC_TABS_VL

Line 868: from BSC_TABS_VL where TAB_ID = l_tab_child;

864:
865: l_tab_child := p_child_tab_id;
866: while l_tab_child is not null loop
867: select PARENT_TAB_ID into l_tab_parent
868: from BSC_TABS_VL where TAB_ID = l_tab_child;
869: --DBMS_OUTPUT.PUT_LINE(' is_child_tab_of l_tab_parent = ' || l_tab_parent );
870:
871: if l_tab_parent is not null then
872: if l_tab_parent = p_parent_tab_id then

Line 1026: l_parent_tab_id bsc_tabs_vl.tab_id%TYPE;

1022: ,p_user_name IN VARCHAR2
1023: ,x_par_tab_name OUT NOCOPY VARCHAR2
1024: ,x_par_tabname_list OUT NOCOPY VARCHAR2
1025: ) IS
1026: l_parent_tab_id bsc_tabs_vl.tab_id%TYPE;
1027: l_parent_tab_id1 bsc_tabs_vl.tab_id%TYPE;
1028: l_par_tabname_list VARCHAR2(4000);
1029: l_name bsc_tabs_vl.name%TYPE;
1030: BEGIN

Line 1027: l_parent_tab_id1 bsc_tabs_vl.tab_id%TYPE;

1023: ,x_par_tab_name OUT NOCOPY VARCHAR2
1024: ,x_par_tabname_list OUT NOCOPY VARCHAR2
1025: ) IS
1026: l_parent_tab_id bsc_tabs_vl.tab_id%TYPE;
1027: l_parent_tab_id1 bsc_tabs_vl.tab_id%TYPE;
1028: l_par_tabname_list VARCHAR2(4000);
1029: l_name bsc_tabs_vl.name%TYPE;
1030: BEGIN
1031:

Line 1029: l_name bsc_tabs_vl.name%TYPE;

1025: ) IS
1026: l_parent_tab_id bsc_tabs_vl.tab_id%TYPE;
1027: l_parent_tab_id1 bsc_tabs_vl.tab_id%TYPE;
1028: l_par_tabname_list VARCHAR2(4000);
1029: l_name bsc_tabs_vl.name%TYPE;
1030: BEGIN
1031:
1032: SELECT parent_tab_id,name
1033: INTO l_parent_tab_id, x_par_tab_name

Line 1034: FROM bsc_tabs_vl

1030: BEGIN
1031:
1032: SELECT parent_tab_id,name
1033: INTO l_parent_tab_id, x_par_tab_name
1034: FROM bsc_tabs_vl
1035: WHERE tab_id = p_tab_id;
1036:
1037: WHILE (l_parent_tab_id IS NOT NULL) LOOP
1038: IF(Check_Tab_UserAccess_Func_Only(l_parent_tab_id, p_user_name, 'BSC_SCORECARD_ACCESS_VIEW' ) = 'N') THEN

Line 1042: FROM BSC_TABS_VL

1038: IF(Check_Tab_UserAccess_Func_Only(l_parent_tab_id, p_user_name, 'BSC_SCORECARD_ACCESS_VIEW' ) = 'N') THEN
1039:
1040: SELECT name
1041: INTO l_name
1042: FROM BSC_TABS_VL
1043: WHERE tab_id = l_parent_tab_id;
1044:
1045: IF (l_par_tabname_list IS NULL) THEN
1046: l_par_tabname_list := l_name;

Line 1080: FROM bsc_tabs_vl

1076: ) RETURN VARCHAR2 IS
1077:
1078: CURSOR c_chid_scorecards IS
1079: SELECT tab_id,name
1080: FROM bsc_tabs_vl
1081: WHERE parent_tab_id = p_tab_id;
1082:
1083: l_tablist_name VARCHAR2(4000);
1084: l_return_tablist VARCHAR2(4000);

Line 1132: l_check_child BSC_TABS_VL.NAME%TYPE;

1128: l_tab_id FND_GRANTS.INSTANCE_PK1_VALUE%TYPE;
1129: l_single_grant_guid FND_GRANTS.GRANT_GUID%TYPE;
1130: l_tablist_name VARCHAR2(4000);
1131: l_check_children VARCHAR2(4000);
1132: l_check_child BSC_TABS_VL.NAME%TYPE;
1133:
1134: BEGIN
1135: l_grant_guids := p_grant_guids;
1136:

Line 1190: FROM BSC_TABS_VL

1186: )RETURN VARCHAR2 IS
1187:
1188: CURSOR c_root_tab_ids IS
1189: SELECT tab_id
1190: FROM BSC_TABS_VL
1191: WHERE PARENT_TAB_ID IS NULL;
1192:
1193:
1194:

Line 1197: FROM BSC_TABS_VL

1193:
1194:
1195: CURSOR c_child_tab_ids IS
1196: SELECT tab_id
1197: FROM BSC_TABS_VL
1198: WHERE PARENT_TAB_ID = p_tab_id;
1199:
1200: l_istaborderEnabled VARCHAR2(3);
1201: