[Home] [Help]
2211: SELECT acd_type,
2212: operation_sequence_id,
2213: resource_seq_num,
2214: resource_id
2215: FROM bom_operation_resources
2216: WHERE operation_sequence_id= chng_operation_rec.operation_sequence_id;
2217:
2218: chng_resource_rec chng_resource_rows%rowtype;
2219:
5163: IF chng_operation_rec.acd_type = acd_change
5164: -- Copy attached resources in the old operation to the new operation,
5165: -- except the disabled resource.
5166: THEN
5167: INSERT INTO bom_operation_resources
5168: (
5169: operation_sequence_id
5170: , resource_seq_num
5171: , resource_id
5253: , principle_flag
5254: , change_notice
5255: , acd_type
5256: , original_system_reference
5257: FROM bom_operation_resources a
5258: WHERE operation_sequence_id =
5259: chng_operation_rec.old_operation_sequence_id
5260: --* Commented following line for Bug 3520302
5261: --* AND nvl(acd_type, acd_add) = acd_add
5262: --* Added for Bug 3520302
5263: AND nvl(acd_type, acd_add) in (acd_add,acd_change)
5264: AND resource_seq_num NOT IN (
5265: SELECT b.resource_seq_num
5266: FROM bom_operation_resources b
5267: WHERE b.operation_sequence_id =
5268: chng_operation_rec.operation_sequence_id);
5269:
5270: /* Fix for bug 4606950 - In the above select query, modified the sub-query in the where clause.
5271: Replaced the resource_id with resource_seq_num. The old sub-query was commented as below*/
5272: /*
5273: AND resource_id NOT IN (
5274: SELECT b.resource_id
5275: FROM bom_operation_resources b
5276: WHERE b.operation_sequence_id =
5277: chng_operation_rec.operation_sequence_id
5278: and b.resource_seq_num = a.resource_seq_num);
5279: */
5538: -- Check whether all resources in same resource group have been
5539: -- disabled, if so, delete the sub resources too.
5540: /* Commented the below delete st for bug 4577459 . This delete st deletes all rows from the table
5541: that have been created through the routing form irrespective of which routing they belong to.
5542: As while implementing the ECO we do not delete the bom_operation_resources data the sub resources
5543: associated need not be deleted */
5544: /* DELETE
5545: FROM bom_sub_operation_resources sr
5546: WHERE NOT EXISTS (
5544: /* DELETE
5545: FROM bom_sub_operation_resources sr
5546: WHERE NOT EXISTS (
5547: SELECT 1
5548: FROM bom_operation_resources bor
5549: WHERE bor.operation_sequence_id = sr.operation_sequence_id
5550: AND bor.substitute_group_num = sr.substitute_group_num
5551: AND bor.acd_type <> 3
5552: );*/
8694: */
8695: -- Delete all the resources assigned to the operations whose
8696: -- eco_for_production = 1.
8697: /*
8698: DELETE FROM bom_operation_resources
8699: WHERE operation_sequence_id IN
8700: ( SELECT operation_sequence_id
8701: FROM bom_operation_sequences
8702: WHERE revised_item_sequence_id = p_revised_item_sequence_id