APPS.MSC_UNDO dependencies on MSC_SUPPLIES

Line 493: --Msc_supplies

489: --Set the User-id
490: set_vars;
491:
492: if ( p_table_changed = 1 ) then
493: --Msc_supplies
494: /*
495: Delete from msc_supplies
496: where transaction_id = p_transaction_id
497: and plan_id = p_plan_id

Line 495: Delete from msc_supplies

491:
492: if ( p_table_changed = 1 ) then
493: --Msc_supplies
494: /*
495: Delete from msc_supplies
496: where transaction_id = p_transaction_id
497: and plan_id = p_plan_id
498: and sr_instance_id = p_sr_instance_id ;
499: */

Line 500: update msc_supplies

496: where transaction_id = p_transaction_id
497: and plan_id = p_plan_id
498: and sr_instance_id = p_sr_instance_id ;
499: */
500: update msc_supplies
501: set firm_quantity = 0,
502: firm_planned_type = 0,
503: status = 0,
504: applied = 2

Line 699: update_str := 'UPDATE MSC_SUPPLIES SET STATUS=0, APPLIED=2, ';

695: --Set the user-id
696: set_vars;
697:
698: if (p_table_changed = 1) then
699: update_str := 'UPDATE MSC_SUPPLIES SET STATUS=0, APPLIED=2, ';
700: if (p_column_type = 'DATE') then
701: set_str := p_column_changed
702: ||' = fnd_date.canonical_to_date(:p_old_value) ';
703: else

Line 935: from msc_supplies

931:
932: cursor c_nofirm (v_plan_id number, v_sr_instance_id number,
933: v_transaction_id number) is
934: select firm_planned_type
935: from msc_supplies
936: where transaction_id = v_transaction_id
937: and sr_instance_id = v_sr_instance_id
938: and plan_id = v_plan_id ;
939: