[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
/* If resource_seq_num for the setup instance is null, we need to update
with the resource_seq_num of parent setup resource */
SELECT resource_seq_num into x_resource_seq
FROM wip_operation_resources
WHERE organization_id = p_organization_id
and wip_entity_id = p_wip_entity_id
and operation_seq_num = p_operation_seq_num
and resource_id = p_resource_id
and parent_resource_seq = p_parent_seq_num;
SELECT start_date, completion_date
INTO x_start_date, x_completion_date
FROM WIP_OPERATION_RESOURCES
WHERE wip_entity_id = p_wip_entity_id
AND organization_id = p_organization_id
AND operation_seq_num = p_operation_seq_num
AND resource_seq_num = p_resource_seq_num;
UPDATE WIP_JOB_DTLS_INTERFACE
SET start_date = nvl(start_date,x_start_date),
completion_date = nvl(completion_date,x_completion_date),
resource_seq_num = nvl(resource_seq_num, x_resource_seq)
WHERE rowid = p_rowid;