eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSC_UNDO dependencies on MSC_PLANS

Line 622: --Msc_plans

618:
619:
620: elsif ( p_table_changed = 5 ) then
621:
622: --Msc_plans
623: Delete from msc_plans
624: where plan_id = p_plan_id ;
625: elsif ( p_table_changed = 7 ) then
626: -- Trips

Line 623: Delete from msc_plans

619:
620: elsif ( p_table_changed = 5 ) then
621:
622: --Msc_plans
623: Delete from msc_plans
624: where plan_id = p_plan_id ;
625: elsif ( p_table_changed = 7 ) then
626: -- Trips
627: delete from msc_shipments

Line 807: update_str := 'UPDATE MSC_PLANS SET ';

803: end loop;
804: close c_net_res;
805:
806: elsif (p_table_changed = 5) then
807: update_str := 'UPDATE MSC_PLANS SET ';
808: set_str := p_column_changed||' = :p_old_value ';
809: where_str := ' WHERE plan_id = :p_plan_id ';
810: sql_string := update_str||' '||set_str||' '||where_str;
811: Execute immediate sql_string