APPS.MSC_UNDO dependencies on MSC_SUPPLIER_CAPACITIES

Line 532: --Msc_supplier_capacities

528: and sr_instance_id = p_sr_instance_id ;
529: end if;
530: */
531: elsif ( p_table_changed = 3 ) then
532: --Msc_supplier_capacities
533: /*
534: Delete from msc_supplier_capacities
535: where transaction_id in (select transaction_id
536: from msc_undo_summary

Line 534: Delete from msc_supplier_capacities

530: */
531: elsif ( p_table_changed = 3 ) then
532: --Msc_supplier_capacities
533: /*
534: Delete from msc_supplier_capacities
535: where transaction_id in (select transaction_id
536: from msc_undo_summary
537: where plan_id = p_plan_id
538: and (undo_id = p_undo_id or parent_id = p_undo_id))

Line 541: update msc_supplier_capacities

537: where plan_id = p_plan_id
538: and (undo_id = p_undo_id or parent_id = p_undo_id))
539: and plan_id = p_plan_id ;
540: */
541: update msc_supplier_capacities
542: set capacity = 0,
543: status = 0,
544: applied = 2
545: where plan_id = p_plan_id

Line 732: update_str := 'UPDATE MSC_SUPPLIER_CAPACITIES SET ';

728: using p_old_value, p_plan_id,
729: p_transaction_id, p_sr_instance_id ;
730:
731: elsif (p_table_changed = 3) then
732: update_str := 'UPDATE MSC_SUPPLIER_CAPACITIES SET ';
733: update_str := update_str||' STATUS=0, APPLIED=2, ';
734: if (p_column_type = 'DATE') then
735: set_str := p_column_changed
736: ||' = fnd_date.canonical_to_date(:p_old_value) ';