DBA Data[Home] [Help]

APPS.BSC_PMF_UI_WRAPPER dependencies on BSC_DIM_FILTERS_PUB

Line 2061: AND C.Source_Type = BSC_DIM_FILTERS_PUB.Source_Type_Tab

2057: FROM BSC_TAB_INDICATORS A
2058: , BSC_KPIS_B B
2059: , BSC_SYS_FILTERS_VIEWS C
2060: WHERE A.Indicator = B.Indicator
2061: AND C.Source_Type = BSC_DIM_FILTERS_PUB.Source_Type_Tab
2062: AND C.Source_Code = A.Tab_Id
2063: AND ((B.Indicator = p_kpi_id) OR (B.Source_Indicator = p_kpi_id));
2064:
2065: begin

Line 2106: BSC_DIM_FILTERS_PUB.Check_Filters_Not_Apply

2102: END IF;
2103: -- if indicator assigned to a tab then get tab id and update time stamp.
2104:
2105: FOR i IN 0..(l_Tabs_Tbl_Type.COUNT-1 ) LOOP
2106: BSC_DIM_FILTERS_PUB.Check_Filters_Not_Apply
2107: ( p_Tab_Id => l_Tabs_Tbl_Type(i).Bsc_tab_id
2108: , x_return_status => x_return_status
2109: , x_msg_count => x_msg_count
2110: , x_msg_data => x_msg_data

Line 2113: --DBMS_OUTPUT.PUT_LINE('BSC_PMF_UI_WRAPPER.Delete_Kpi Failed: at BSC_DIM_FILTERS_PUB.Check_Filters_Not_Apply');

2109: , x_msg_count => x_msg_count
2110: , x_msg_data => x_msg_data
2111: );
2112: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2113: --DBMS_OUTPUT.PUT_LINE('BSC_PMF_UI_WRAPPER.Delete_Kpi Failed: at BSC_DIM_FILTERS_PUB.Check_Filters_Not_Apply');
2114: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2115: END IF;
2116: END LOOP;
2117:

Line 2358: BSC_DIM_FILTERS_PUB.Drop_Filter_By_Tab (

2354:
2355: -- Fix for bug 3459282
2356: -- Delete the Dim Object Filters Associated to the Scorecard.
2357: -- It needs to be at the final it deletes view objects
2358: BSC_DIM_FILTERS_PUB.Drop_Filter_By_Tab (
2359: p_Tab_Id => p_Tab_Id
2360: , x_return_status => x_return_status
2361: , x_msg_COUNT => x_msg_COUNT
2362: , x_msg_data => x_msg_data

Line 2623: BSC_DIM_FILTERS_PUB.Synch_Fiters_And_Kpi_Dim

2619:
2620:
2621:
2622: -- Need to fix bug 3543675
2623: BSC_DIM_FILTERS_PUB.Synch_Fiters_And_Kpi_Dim
2624: ( p_Tab_Id => p_tab_id
2625: , x_return_status => x_return_status
2626: , x_msg_count => x_msg_count
2627: , x_msg_data => x_msg_data

Line 3001: BSC_DIM_FILTERS_PUB.Check_Filters_Not_Apply

2997: IF ((x_return_status IS NOT NULL) AND (x_return_status <> FND_API.G_RET_STS_SUCCESS)) THEN
2998: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2999: END IF;
3000:
3001: BSC_DIM_FILTERS_PUB.Check_Filters_Not_Apply
3002: ( p_Tab_Id => p_tab_id
3003: , x_return_status => x_return_status
3004: , x_msg_count => x_msg_count
3005: , x_msg_data => x_msg_data

Line 3008: --DBMS_OUTPUT.PUT_LINE('BSC_PMF_UI_WRAPPER.Unassign_KPI Failed: at BSC_DIM_FILTERS_PUB.Check_Filters_Not_Apply');

3004: , x_msg_count => x_msg_count
3005: , x_msg_data => x_msg_data
3006: );
3007: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3008: --DBMS_OUTPUT.PUT_LINE('BSC_PMF_UI_WRAPPER.Unassign_KPI Failed: at BSC_DIM_FILTERS_PUB.Check_Filters_Not_Apply');
3009: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3010: END IF;
3011:
3012: -- Need to fix bug 3543675

Line 3014: BSC_DIM_FILTERS_PUB.Synch_Fiters_And_Kpi_Dim

3010: END IF;
3011:
3012: -- Need to fix bug 3543675
3013: -- it pass null in order to syscronize KPIs not assigned to any tab
3014: BSC_DIM_FILTERS_PUB.Synch_Fiters_And_Kpi_Dim
3015: ( p_Tab_Id => null
3016: , x_return_status => x_return_status
3017: , x_msg_count => x_msg_count
3018: , x_msg_data => x_msg_data