APPS.BIS_FUNCTIONAL_AREA_PUB dependencies on BIS_FUNC_AREA_APP_DEPENDENCY

Line 686: FROM BIS_FUNC_AREA_APP_DEPENDENCY

682: := BIS_UTIL.Get_Apps_Id_By_Short_Name (l_Func_Area_App_Dep_Rec.Apps_Short_Name);
683: END IF;
684:
685: SELECT COUNT(1) INTO l_Count
686: FROM BIS_FUNC_AREA_APP_DEPENDENCY
687: WHERE FUNCTIONAL_AREA_ID = l_Func_Area_App_Dep_Rec.Functional_Area_Id
688: AND APPLICATION_ID = l_Func_Area_App_Dep_Rec.Application_Id;
689:
690: IF (l_Count = 0) THEN

Line 923: FROM BIS_FUNC_AREA_APP_DEPENDENCY

919: END IF;
920: END IF;
921:
922: SELECT COUNT(1) INTO l_Count
923: FROM BIS_FUNC_AREA_APP_DEPENDENCY
924: WHERE FUNCTIONAL_AREA_ID = p_Functional_Area_Id
925: AND APPLICATION_ID = p_Application_Id;
926:
927: IF l_Count <> 0 THEN

Line 937: FROM BIS_FUNC_AREA_APP_DEPENDENCY

933: END IF;
934:
935:
936: SELECT COUNT(1) INTO l_Count
937: FROM BIS_FUNC_AREA_APP_DEPENDENCY
938: WHERE APPLICATION_ID = p_Application_Id;
939:
940: IF l_Count > 0 THEN
941: FND_MESSAGE.SET_NAME('BIS','BIS_FA_APPS_ID_ALREADY_EXIST');

Line 953: FROM BIS_FUNC_AREA_APP_DEPENDENCY

949:
950: ELSIF(p_Action_Type = C_UPDATE OR p_Action_Type = C_DELETE) THEN
951:
952: SELECT COUNT(1) INTO l_Count
953: FROM BIS_FUNC_AREA_APP_DEPENDENCY
954: WHERE FUNCTIONAL_AREA_ID = p_Functional_Area_Id
955: AND APPLICATION_ID = p_Application_Id;
956:
957: IF (l_Count = 0) THEN

Line 1064: FROM BIS_FUNC_AREA_APP_DEPENDENCY B

1060:
1061: CURSOR c_FuncArea_Dep IS
1062: SELECT B.FUNCTIONAL_AREA_ID,
1063: B.APPLICATION_ID
1064: FROM BIS_FUNC_AREA_APP_DEPENDENCY B
1065: WHERE B.FUNCTIONAL_AREA_ID = l_Func_Area_Rec.Functional_Area_Id;
1066: BEGIN
1067: SAVEPOINT DeleteFuncAreaSP;
1068: FND_MSG_PUB.Initialize;