APPS.AHL_PP_RESRC_REQUIRE_PVT dependencies on AHL_OPERATION_RESOURCES_S

Line 301: UPDATE AHL_OPERATION_RESOURCES SET

297: )
298: IS
299:
300: BEGIN
301: UPDATE AHL_OPERATION_RESOURCES SET
302: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER + 1,
303: RESOURCE_ID = X_RESOURCE_ID ,
304: WORKORDER_OPERATION_ID = X_WORKORDER_OPERATION_ID ,
305: RESOURCE_SEQUENCE_NUM = X_RESOURCE_SEQ_NUMBER ,

Line 1906: SELECT AHL_OPERATION_RESOURCES_S.NEXTVAL

1902: END IF;
1903:
1904: --
1905: -- Get Sequence Number for Resource Requirement ID
1906: SELECT AHL_OPERATION_RESOURCES_S.NEXTVAL
1907: INTO l_Resrc_Require_Rec.Operation_Resource_id
1908: FROM DUAL;
1909:
1910: --Check for Record Exists