The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT DISTINCT ABS(OPERATION_SEQ_NUM) OPERATION_SEQ_NUM
FROM WIP_REQUIREMENT_OPERATIONS WRO
WHERE WRO.WIP_ENTITY_ID = X_Wip_Entity_Id
AND WRO.ORGANIZATION_ID = X_Organization_Id
AND NOT EXISTS
(SELECT 'op exists'
FROM WIP_OPERATIONS WO
WHERE WO.WIP_ENTITY_ID = WRO.WIP_ENTITY_ID
AND WO.ORGANIZATION_ID = WRO.ORGANIZATION_ID
AND WO.OPERATION_SEQ_NUM = ABS(WRO.OPERATION_SEQ_NUM));
SELECT DISTINCT OPERATION_SEQ_NUM
FROM WIP_REQUIREMENT_OPERATIONS WRO
WHERE WRO.WIP_ENTITY_ID = X_Wip_Entity_Id
AND WRO.ORGANIZATION_ID = X_Organization_Id
AND WRO.REPETITIVE_SCHEDULE_ID = X_Repetitive_Schedule_Id
AND NOT EXISTS
(SELECT 'op exists'
FROM WIP_OPERATIONS WO
WHERE WO.WIP_ENTITY_ID = WRO.WIP_ENTITY_ID
AND WO.ORGANIZATION_ID = WRO.ORGANIZATION_ID
AND WO.REPETITIVE_SCHEDULE_ID = WRO.REPETITIVE_SCHEDULE_ID
AND WO.OPERATION_SEQ_NUM = WRO.OPERATION_SEQ_NUM);
/* Just update the department and date_required if the op exists */
UPDATE WIP_REQUIREMENT_OPERATIONS WRO
SET (WRO.DEPARTMENT_ID, WRO.DATE_REQUIRED) =
(SELECT DEPARTMENT_ID, FIRST_UNIT_START_DATE
FROM WIP_OPERATIONS WO
WHERE WO.WIP_ENTITY_ID = WRO.WIP_ENTITY_ID
AND WO.OPERATION_SEQ_NUM = WRO.OPERATION_SEQ_NUM
AND WO.ORGANIZATION_ID = WRO.ORGANIZATION_ID)
WHERE WRO.WIP_ENTITY_ID = X_Wip_Entity_Id
AND WRO.ORGANIZATION_ID = X_Organization_Id
AND EXISTS
(SELECT 'operation exists'
FROM WIP_OPERATIONS WO
WHERE WO.WIP_ENTITY_ID = WRO.WIP_ENTITY_ID
AND WO.OPERATION_SEQ_NUM = WRO.OPERATION_SEQ_NUM
AND WO.ORGANIZATION_ID = WRO.ORGANIZATION_ID);
/* Otherwise treat the same as a deleted operation */
FOR C1 IN Cdisc LOOP
WIP_OPERATIONS_UTILITIES.Check_Requirements(
X_Wip_Entity_Id,
X_Organization_Id,
C1.operation_seq_num,
X_Repetitive_Schedule_Id,
X_Entity_Start_Date
);
UPDATE WIP_REQUIREMENT_OPERATIONS WRO
SET (WRO.DEPARTMENT_ID, WRO.DATE_REQUIRED) =
(SELECT DEPARTMENT_ID, FIRST_UNIT_START_DATE
FROM WIP_OPERATIONS WO
WHERE WO.WIP_ENTITY_ID = WRO.WIP_ENTITY_ID
AND WO.OPERATION_SEQ_NUM = WRO.OPERATION_SEQ_NUM
AND WO.REPETITIVE_SCHEDULE_ID = WRO.REPETITIVE_SCHEDULE_ID
AND WO.ORGANIZATION_ID = WRO.ORGANIZATION_ID)
WHERE WRO.WIP_ENTITY_ID = X_Wip_Entity_Id
AND WRO.ORGANIZATION_ID = X_Organization_Id
AND WRO.REPETITIVE_SCHEDULE_ID = X_Repetitive_Schedule_Id
AND EXISTS
(SELECT 'operation exists'
FROM WIP_OPERATIONS WO
WHERE WO.WIP_ENTITY_ID = WRO.WIP_ENTITY_ID
AND WO.OPERATION_SEQ_NUM = WRO.OPERATION_SEQ_NUM
AND WO.REPETITIVE_SCHEDULE_ID = WRO.REPETITIVE_SCHEDULE_ID
AND WO.ORGANIZATION_ID = WRO.ORGANIZATION_ID);