APPS.BIS_OBJECT_EXTENSIONS_PUB dependencies on BIS_FUNCTIONAL_AREAS

Line 1204: FROM BIS_FUNCTIONAL_AREAS

1200: l_FA_Id NUMBER;
1201: BEGIN
1202: SELECT FUNCTIONAL_AREA_ID
1203: INTO l_FA_Id
1204: FROM BIS_FUNCTIONAL_AREAS
1205: WHERE UPPER(SHORT_NAME) = UPPER(Trim(p_Functional_Area_Short_Name));
1206:
1207: RETURN l_FA_Id;
1208:

Line 1245: FROM BIS_FUNCTIONAL_AREAS B

1241: END IF;
1242:
1243: IF(BIS_UTILITIES_PVT.Value_Missing_Or_Null(p_Meas_Extn_Rec.Functional_Area_Id) = FND_API.G_FALSE) THEN
1244: SELECT COUNT(1) INTO l_Count
1245: FROM BIS_FUNCTIONAL_AREAS B
1246: WHERE B.FUNCTIONAL_AREA_ID = p_Meas_Extn_Rec.Functional_Area_Id;
1247:
1248: IF (l_Count = 0) THEN
1249: FND_MESSAGE.SET_NAME('BIS','BIS_FUNCID_WRONG');

Line 1283: FROM BIS_FUNCTIONAL_AREAS

1279: RAISE FND_API.G_EXC_ERROR;
1280: ELSE
1281: SELECT COUNT(1)
1282: INTO l_Count
1283: FROM BIS_FUNCTIONAL_AREAS
1284: WHERE UPPER(SHORT_NAME) = UPPER(TRIM(l_Meas_Extn_Rec.Func_Area_Short_Name));
1285: IF(l_Count = 0 ) THEN
1286: FND_MESSAGE.SET_NAME('BIS','BIS_FUNCSHTNAME_WRONG');
1287: FND_MESSAGE.SET_TOKEN('FORM_FUNC',Trim(l_Meas_Extn_Rec.Func_Area_Short_Name));

Line 1367: FROM BIS_FUNCTIONAL_AREAS

1363: WHERE UPPER(OBJECT_NAME) = UPPER(TRIM(p_Form_Func_Extn_Rec.Object_Name));
1364:
1365: SELECT COUNT(1)
1366: INTO l_cnt_func_id
1367: FROM BIS_FUNCTIONAL_AREAS
1368: WHERE FUNCTIONAL_AREA_ID = p_Form_Func_Extn_Rec.Func_Area_Id;
1369:
1370: IF (BIS_UTILITIES_PVT.Value_Missing_Or_Null(TRIM(p_Form_Func_Extn_Rec.Object_Name)) = FND_API.G_TRUE) THEN
1371: FND_MESSAGE.SET_NAME('BIS','BIS_FORM_FUNC_SHTNAME_NULL');

Line 1433: FROM BIS_FUNCTIONAL_AREAS

1429: RAISE FND_API.G_EXC_ERROR;
1430: ELSE
1431: SELECT COUNT(1)
1432: INTO l_cnt_func_id
1433: FROM BIS_FUNCTIONAL_AREAS
1434: WHERE SHORT_NAME = p_Form_Func_Extn_Rec.Func_Area_short_name;
1435: IF(l_cnt_func_id = 0 ) THEN
1436: FND_MESSAGE.SET_NAME('BIS','BIS_FUNCSHTNAME_WRONG');
1437: FND_MESSAGE.SET_TOKEN('FORM_FUNC',Trim(p_Form_Func_Extn_Rec.Func_Area_short_name));