APPS.AHL_PP_RESRC_REQUIRE_PVT dependencies on AHL_OPERATION_RESOURCES_S

Line 309: UPDATE AHL_OPERATION_RESOURCES SET

305: )
306: IS
307:
308: BEGIN
309: UPDATE AHL_OPERATION_RESOURCES SET
310: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER + 1,
311: RESOURCE_ID = X_RESOURCE_ID ,
312: WORKORDER_OPERATION_ID = X_WORKORDER_OPERATION_ID ,
313: RESOURCE_SEQUENCE_NUM = X_RESOURCE_SEQ_NUMBER ,

Line 2101: SELECT AHL_OPERATION_RESOURCES_S.NEXTVAL

2097: END IF;
2098:
2099: --
2100: -- Get Sequence Number for Resource Requirement ID
2101: SELECT AHL_OPERATION_RESOURCES_S.NEXTVAL
2102: INTO l_Resrc_Require_Rec.Operation_Resource_id
2103: FROM DUAL;
2104:
2105: --Check for Record Exists