APPS.BSC_PMF_UI_WRAPPER dependencies on BSC_TABS_VL

Line 1557: FROM BSC_TABS_VL

1553: l_commit varchar2(10);
1554: l_Count NUMBER := 0;
1555: CURSOR c_Tab_Name IS
1556: SELECT Name
1557: FROM BSC_TABS_VL
1558: WHERE Tab_Id = l_Bsc_Tab_Entity_Rec.Bsc_Tab_Id;
1559: begin
1560: FND_MSG_PUB.Initialize;
1561: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1582: FROM BSC_TABS_VL

1578: IF ((p_tab_name IS NOT NULL) AND (l_Bsc_Tab_Entity_Rec.Bsc_Tab_Name <> p_tab_name)) THEN
1579: l_Bsc_Tab_Entity_Rec.Bsc_Tab_Name := TRIM(p_tab_name);
1580:
1581: SELECT COUNT(*) INTO l_Count
1582: FROM BSC_TABS_VL
1583: WHERE Tab_Id <> l_Bsc_Tab_Entity_Rec.Bsc_Tab_Id
1584: AND UPPER(Name) = UPPER(l_Bsc_Tab_Entity_Rec.Bsc_Tab_Name);
1585: IF (l_Count <> 0) THEN
1586: FND_MESSAGE.SET_NAME('BSC', 'BSC_TAB_NAME_EXISTS');

Line 4413: from BSC_TABS_VL where tab_id = p_tab_id;

4409: -- check to see tab is not being made a child of itself.
4410: if p_tab_id = p_parent_tab_id then
4411: --get tab name to display error.
4412: select name into l_tab_name
4413: from BSC_TABS_VL where tab_id = p_tab_id;
4414: FND_MESSAGE.SET_NAME('BSC','BSC_TAB_SELF_REL');
4415: FND_MESSAGE.SET_TOKEN('BSC_TAB', l_tab_name);
4416: FND_MSG_PUB.ADD;
4417: RAISE FND_API.G_EXC_ERROR;

Line 4425: from BSC_TABS_VL where tab_id = p_tab_id;

4421: if l_return_value = FND_API.G_TRUE then
4422: --DBMS_OUTPUT.PUT_LINE(' Update_Tab_Parent l_return_value = ' || l_return_value );
4423: FND_MESSAGE.SET_NAME('BSC','BSC_TAB_CIRCULAR_REL');
4424: select name into l_tab_name
4425: from BSC_TABS_VL where tab_id = p_tab_id;
4426: FND_MESSAGE.SET_TOKEN('BSC_TAB', l_tab_name);
4427: select name into l_tab_name
4428: from BSC_TABS_VL where tab_id = p_parent_tab_id;
4429: FND_MESSAGE.SET_TOKEN('BSC_TABCHILD', l_tab_name);

Line 4428: from BSC_TABS_VL where tab_id = p_parent_tab_id;

4424: select name into l_tab_name
4425: from BSC_TABS_VL where tab_id = p_tab_id;
4426: FND_MESSAGE.SET_TOKEN('BSC_TAB', l_tab_name);
4427: select name into l_tab_name
4428: from BSC_TABS_VL where tab_id = p_parent_tab_id;
4429: FND_MESSAGE.SET_TOKEN('BSC_TABCHILD', l_tab_name);
4430: FND_MSG_PUB.ADD;
4431: RAISE FND_API.G_EXC_ERROR;
4432: end if;

Line 5168: FROM BSC_TABS_VL

5164: ) RETURN NUMBER IS
5165:
5166: CURSOR c_Tab_Id IS
5167: SELECT Tab_ID
5168: FROM BSC_TABS_VL
5169: WHERE Name = p_Tab_Name;
5170:
5171: l_Tab_Id NUMBER := -2;
5172: BEGIN

Line 5922: l_scr_name BSC_TABS_VL.NAME%TYPE;

5918: l_index integer;
5919: l_dep_obj_name varchar2(240);
5920: l_dep_obj_message varchar2(1000);
5921: l_dep_obj_list varchar2(2000);
5922: l_scr_name BSC_TABS_VL.NAME%TYPE;
5923: l_scr_short_name BSC_TABS_VL.SHORT_NAME%TYPE;
5924: l_objective_name BSC_KPIS_VL.NAME%TYPE;
5925: l_Is_Ag_Type_Scorecard VARCHAR2(1);
5926: l_exist_dependency VARCHAR2(10);

Line 5923: l_scr_short_name BSC_TABS_VL.SHORT_NAME%TYPE;

5919: l_dep_obj_name varchar2(240);
5920: l_dep_obj_message varchar2(1000);
5921: l_dep_obj_list varchar2(2000);
5922: l_scr_name BSC_TABS_VL.NAME%TYPE;
5923: l_scr_short_name BSC_TABS_VL.SHORT_NAME%TYPE;
5924: l_objective_name BSC_KPIS_VL.NAME%TYPE;
5925: l_Is_Ag_Type_Scorecard VARCHAR2(1);
5926: l_exist_dependency VARCHAR2(10);
5927:

Line 5930: FROM bsc_tabs_vl

5926: l_exist_dependency VARCHAR2(10);
5927:
5928: CURSOR c_scr IS
5929: SELECT name, short_name
5930: FROM bsc_tabs_vl
5931: WHERE tab_id = p_tab_id;
5932:
5933: CURSOR c_Kpi_function IS
5934: SELECT c.function_name,d.name