DBA Data[Home] [Help]

APPS.BSC_PMF_UI_API_PUB dependencies on BSC_UTILITY

Line 435: l_owner := bsc_utility.get_owner_for_object(g_Bsc_Pmf_Dim_Tbl(i).Dimension_Level_View_Name);

431: ' upper(level_table_col_name) like ''%PK_KEY%''';
432: */
433:
434: -- Change to query data dictionary due to EDW APIs not being there.
435: l_owner := bsc_utility.get_owner_for_object(g_Bsc_Pmf_Dim_Tbl(i).Dimension_Level_View_Name);
436:
437: l_sql1 := ' SELECT column_name ' ||
438: ' FROM ALL_TAB_COLUMNS ' ||
439: ' WHERE table_name = UPPER(:1) AND ' ||

Line 1325: IF (NOT BSC_UTILITY.is_Table_View_Exists(x_Bsc_Pmf_Dim_Rec.Dimension_Level_View_Name)) THEN

1321:
1322: --DBMS_OUTPUT.PUT_LINE('Populate_Bsc_Pmf_Dim_Rec XX x_Bsc_Pmf_Dim_Rec.Dimension_Level_View_Name = ' || x_Bsc_Pmf_Dim_Rec.Dimension_Level_View_Name );
1323:
1324: -- Included to fixed bug 2382059
1325: IF (NOT BSC_UTILITY.is_Table_View_Exists(x_Bsc_Pmf_Dim_Rec.Dimension_Level_View_Name)) THEN
1326: FND_MESSAGE.SET_NAME('BSC','BSC_PMF_LEVEL_NOT_EXISTS');
1327: FND_MESSAGE.SET_TOKEN('BSC_LEVEL_NAME', x_Bsc_Pmf_Dim_Rec.Dimension_Level_View_Name);
1328: FND_MSG_PUB.ADD;
1329: RAISE FND_API.G_EXC_ERROR;