[Home] [Help]
384: FROM
385: ALL_SYNONYMS
386: WHERE
387: TABLE_NAME = 'EDW_TIME_M'
388: AND owner = BSC_APPS.get_user_schema;
389:
390: EXCEPTION
391: WHEN NO_DATA_FOUND THEN
392: l_object_name := NULL;
1356: --Bug#3431750 appended schema name
1357: SELECT COUNT(*) INTO l_Count
1358: FROM ALL_MVIEWS
1359: WHERE MVIEW_NAME = l_Tab_Name
1360: AND OWNER = BSC_APPS.get_user_schema;
1361:
1362: IF (l_Count <> 0) THEN
1363: RETURN TRUE;
1364: ELSE
1382: l_Tab_Name := UPPER(TRIM(p_View_Name));
1383: SELECT COUNT(0) INTO l_Count
1384: FROM ALL_VIEWS
1385: WHERE VIEW_NAME = l_Tab_Name
1386: AND OWNER = BSC_APPS.get_user_schema('APPS');
1387:
1388: IF (l_Count <> 0) THEN
1389: RETURN TRUE;
1390: ELSE
1473: CLOSE c_object_type;
1474:
1475: IF (l_object_type = 'VIEW') THEN
1476: -- view always in apps schema
1477: l_owner := BSC_APPS.get_user_schema('APPS');
1478: ELSE
1479: -- table then it should be synonym
1480: IF (c_owner%ISOPEN) THEN
1481: CLOSE c_owner;
1485: FETCH c_owner INTO l_owner;
1486: CLOSE c_owner;
1487:
1488: IF(l_owner IS NULL) THEN
1489: l_owner := BSC_APPS.get_user_schema('APPS');
1490: END IF;
1491: END IF;
1492:
1493: RETURN l_owner;
2988:
2989: CURSOR c_Parse_Package_Spec IS
2990: SELECT A.LINE, A.TEXT
2991: FROM ALL_SOURCE A
2992: WHERE A.OWNER = BSC_APPS.get_user_schema(C_PACKAGE_OWNER)
2993: AND A.TYPE = C_PACKAGE_SPECIFICATION
2994: AND A.NAME = l_Package_Name;
2995: BEGIN
2996:
3142:
3143: SELECT COUNT(1) INTO l_Count
3144: FROM ALL_SOURCE A
3145: WHERE A.TYPE = C_PACKAGE_SPECIFICATION
3146: AND A.OWNER = BSC_APPS.get_user_schema(C_PACKAGE_OWNER)
3147: AND A.NAME = l_Package_Name;
3148:
3149: -- BIS_PLSQL_PKG_NOT_EXIST
3150: -- The PL/SQL procedure or function does not exist in the database
3629: CURSOR c_Get_Column_Names IS
3630: SELECT A.COLUMN_NAME
3631: FROM ALL_TAB_COLS A
3632: WHERE A.TABLE_NAME = l_Temp_View_Name
3633: AND A.OWNER = BSC_APPS.get_user_schema(C_PACKAGE_OWNER)
3634: ORDER BY A.COLUMN_NAME;
3635:
3636: BEGIN
3637: FND_MSG_PUB.Initialize;