APPS.BIS_FUNCTIONAL_AREA_PUB dependencies on BIS_FUNCTIONAL_AREAS

Line 785: FROM BIS_FUNCTIONAL_AREAS

781: IF(p_Action_Type = C_CREATE) THEN
782:
783:
784: SELECT COUNT(1) INTO l_Count
785: FROM BIS_FUNCTIONAL_AREAS
786: WHERE UPPER(SHORT_NAME) = UPPER(p_Func_Area_Rec.Short_Name);
787:
788: IF (l_Count <> 0) THEN
789: FND_MESSAGE.SET_NAME('BIS','BIS_FA_SHORT_NAME_EXISTS');

Line 819: FROM BIS_FUNCTIONAL_AREAS_VL

815: END IF;
816: */
817:
818: SELECT COUNT(1) INTO l_Count
819: FROM BIS_FUNCTIONAL_AREAS_VL
820: WHERE SHORT_NAME = p_Func_Area_Rec.Short_Name;
821:
822: IF (l_Count = 0) THEN
823: FND_MESSAGE.SET_NAME('BIS','BIS_FA_SHORT_NAME_NOT_EXISTS');

Line 895: FROM BIS_FUNCTIONAL_AREAS

891: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
892: END IF;
893:
894: SELECT COUNT(1) INTO l_Count
895: FROM BIS_FUNCTIONAL_AREAS
896: WHERE FUNCTIONAL_AREA_ID = p_Functional_Area_Id;
897:
898: IF (l_Count = 0) THEN
899: FND_MESSAGE.SET_NAME('BIS','BIS_FA_ID_NOT_EXISTS');

Line 1015: FROM BIS_FUNCTIONAL_AREAS;

1011: l_next := 0;
1012:
1013: /*SELECT (NVL(MAX(FUNCTIONAL_AREA_ID), 0)+1)
1014: INTO l_Max_Id
1015: FROM BIS_FUNCTIONAL_AREAS;
1016:
1017: RETURN l_Max_Id;
1018: */
1019:

Line 1039: FROM BIS_FUNCTIONAL_AREAS

1035: l_FA_Id NUMBER;
1036: BEGIN
1037: SELECT FUNCTIONAL_AREA_ID
1038: INTO l_FA_Id
1039: FROM BIS_FUNCTIONAL_AREAS
1040: WHERE UPPER(SHORT_NAME) = UPPER(p_Functional_Area_Short_Name);
1041:
1042: RETURN l_FA_Id;
1043: