APPS.BIS_FUNCTIONAL_AREA_PVT dependencies on BIS_FUNC_AREA_APP_DEPENDENCY

Line 515: INSERT INTO BIS_FUNC_AREA_APP_DEPENDENCY

511: FND_MSG_PUB.Initialize;
512:
513: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
514:
515: INSERT INTO BIS_FUNC_AREA_APP_DEPENDENCY
516: (
517: FUNCTIONAL_AREA_ID
518: ,APPLICATION_ID
519: )

Line 654: FROM BIS_FUNC_AREA_APP_DEPENDENCY B

650:
651: CURSOR c_FuncArea_Dep IS
652: SELECT B.FUNCTIONAL_AREA_ID,
653: B.APPLICATION_ID
654: FROM BIS_FUNC_AREA_APP_DEPENDENCY B
655: WHERE B.FUNCTIONAL_AREA_ID = l_Func_Area_Rec.Functional_Area_Id;
656: BEGIN
657: SAVEPOINT DeleteFuncAreaSP_Pvt;
658: FND_MSG_PUB.Initialize;

Line 745: DELETE BIS_FUNC_AREA_APP_DEPENDENCY B

741: SAVEPOINT RemoveFuncAreaDependencySP_Pvt;
742: FND_MSG_PUB.Initialize;
743: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
744:
745: DELETE BIS_FUNC_AREA_APP_DEPENDENCY B
746: WHERE B.FUNCTIONAL_AREA_ID = p_Functional_Area_Id
747: AND B.APPLICATION_ID = p_Application_Id;
748:
749: -- Commit if required