DBA Data[Home] [Help]

APPS.BSC_PMF_UI_WRAPPER dependencies on BSC_TAB_VIEWS_VL

Line 6100: l_tab_view_id BSC_TAB_VIEWS_VL.tab_view_id%TYPE;

6096: ,x_msg_count OUT NOCOPY NUMBER
6097: ,x_msg_data OUT NOCOPY VARCHAR2
6098: ) IS
6099:
6100: l_tab_view_id BSC_TAB_VIEWS_VL.tab_view_id%TYPE;
6101: l_tab_view_name BSC_TAB_VIEWS_VL.NAME%TYPE;
6102: l_dep_obj_list VARCHAR2(2000);
6103: l_dep_obj_count NUMBER;
6104: l_msg_data VARCHAR2(1000);

Line 6101: l_tab_view_name BSC_TAB_VIEWS_VL.NAME%TYPE;

6097: ,x_msg_data OUT NOCOPY VARCHAR2
6098: ) IS
6099:
6100: l_tab_view_id BSC_TAB_VIEWS_VL.tab_view_id%TYPE;
6101: l_tab_view_name BSC_TAB_VIEWS_VL.NAME%TYPE;
6102: l_dep_obj_list VARCHAR2(2000);
6103: l_dep_obj_count NUMBER;
6104: l_msg_data VARCHAR2(1000);
6105: l_temp_list VARCHAR2(200);

Line 6111: FROM BSC_TAB_VIEWS_VL

6107: l_exist_dependency VARCHAR2(10);
6108:
6109: CURSOR c_tab_views IS
6110: SELECT UNIQUE NAME, tab_view_id
6111: FROM BSC_TAB_VIEWS_VL
6112: WHERE tab_id = p_tab_id;
6113:
6114: BEGIN
6115: x_return_status := FND_API.G_RET_STS_SUCCESS;