[Home] [Help]
547: from msc_undo_summary
548: where plan_id = p_plan_id
549: and (undo_id = p_undo_id or parent_id = p_undo_id));
550: elsif ( p_table_changed in ( 4, 8) ) then
551: --Msc_net_resource_Avail
552: -- bug 1314938 - typical one .. do not delete the row,
553: --instead update the capacity to zero, for this record and its parent record
554: /*
555: Delete from msc_net_resource_avail
551: --Msc_net_resource_Avail
552: -- bug 1314938 - typical one .. do not delete the row,
553: --instead update the capacity to zero, for this record and its parent record
554: /*
555: Delete from msc_net_resource_avail
556: where transaction_id = p_transaction_id
557: and plan_id = p_plan_id
558: and sr_instance_id = p_sr_instance_id ;
559: */
563: l_transaction_id, l_old_value,
564: l_action, l_column_name;
565: exit when c_net_res%notfound;
566: if (l_action = 1) then
567: update msc_net_resource_avail
568: set capacity_units = -1,
569: status = 0,
570: applied = 2
571: where plan_id = p_plan_id
571: where plan_id = p_plan_id
572: and sr_instance_id = l_sr_instance_id
573: and transaction_id = l_transaction_id;
574: else
575: update msc_net_resource_avail
576: set capacity_units =
577: decode(l_column_name,'CAPACITY_UNITS',
578: l_old_value,capacity_units),
579: from_time =
750: l_transaction_id, l_old_value,
751: l_action, l_column_name;
752: exit when c_net_res%notfound;
753: if (l_action = 1) then
754: update msc_net_resource_avail
755: set capacity_units = -1,
756: status = 0,
757: applied = 2
758: where plan_id = p_plan_id
758: where plan_id = p_plan_id
759: and sr_instance_id = l_sr_instance_id
760: and transaction_id = l_transaction_id;
761: else
762: update msc_net_resource_avail
763: set capacity_units =
764: decode(l_column_name,'CAPACITY_UNITS',
765: l_old_value,capacity_units),
766: from_time =