The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT distinct parent_header_id,operation_seq_num, standard_operation_id,
department_id, description , first_unit_start_date,
first_unit_completion_date, last_unit_start_date,
last_unit_completion_date, minimum_transfer_quantity,
count_point_type, backflush_flag,last_update_date,
last_updated_by, creation_date,created_by, last_update_login,
request_id, program_application_id, program_id, program_update_date,
attribute_category, attribute1, attribute2, attribute3,
attribute4, attribute5,
attribute6, attribute7, attribute8, attribute9, attribute10,
attribute11, attribute12, attribute13, attribute14, attribute15
FROM WIP_JOB_DTLS_INTERFACE
WHERE group_id = p_group_id
AND process_phase = WIP_CONSTANTS.ML_VALIDATION
AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
AND wip_entity_id = p_wip_entity_id
AND organization_id = p_organization_id
AND load_type = WIP_JOB_DETAILS.WIP_OPERATION
AND substitution_type = p_substitution_type
ORDER BY operation_seq_num;
select count(*) into l_standard_oper
from bom_standard_operations
where standard_operation_id = p_standard_operation_id
and organization_id = p_organization_id;
SELECT department_id, minimum_transfer_quantity,
count_point_type, operation_description,
backflush_flag
INTO l_department_id, l_min_xfer_qty, l_count_point_type,
l_operation_description, l_backflush_flag
FROM BOM_STANDARD_OPERATIONS
WHERE standard_operation_id = p_standard_operation_id
AND organization_id = p_organization_id;
SELECT COUNT(*) INTO l_parent_header
FROM WIP_JOB_SCHEDULE_INTERFACE
WHERE header_id = p_parent_header_id
AND group_id = p_group_id;
SELECT organization_id, first_unit_start_date,
first_unit_completion_date, last_unit_start_date,
last_unit_completion_date, start_quantity
INTO l_organization_id, l_first_unit_start_date,
l_first_unit_completion_date, l_last_unit_start_date,
l_last_unit_completion_date, l_start_quantity
FROM WIP_JOB_SCHEDULE_INTERFACE
WHERE header_id = p_parent_header_id
AND group_id = p_group_id;
/******* UPDATE THE WIP_JOB_DTLS_INTERFACE TABLE *************/
UPDATE WIP_JOB_DTLS_INTERFACE
SET
department_id = decode(p_department_id,
NULL, l_department_id, p_department_id),
minimum_transfer_quantity = decode(p_min_xfer_qty,
NULL,l_min_xfer_qty,p_min_xfer_qty),
count_point_type = decode(p_count_point,
NULL, l_count_point_type,p_count_point),
description = decode(p_description,
NULL, l_operation_description,p_description),
backflush_flag= decode(p_backflush_flag,
NULL,l_backflush_flag,p_backflush_flag),
first_unit_start_date= decode(p_fusd,
NULL,
l_first_unit_start_date,
p_fusd),
first_unit_completion_date= decode(p_fucd,
NULL,
l_first_unit_completion_date,
p_fucd),
last_unit_start_date = decode(p_lusd,
NULL,
l_last_unit_start_date,
p_lusd),
last_unit_completion_date = decode(p_lucd,
NULL,
l_last_unit_completion_date,
p_lucd)
WHERE group_id = p_group_id
AND (parent_header_id = p_parent_header_id OR
wip_entity_id = p_wip_entity_id)
AND organization_id = p_organization_id
AND load_type = WIP_JOB_DETAILS.WIP_OPERATION
AND substitution_type = WIP_JOB_DETAILS.WIP_ADD
AND operation_seq_num = p_operation_seq_num;