127: AND plan_level = LAST_SUBMITTED;
128:
129: COMMIT;
130:
131: DELETE FROM mrp_plan_schedules
132: WHERE organization_id = arg_org_id
133: AND compile_designator = arg_compile_desig
134: AND plan_level = LAST_SUBMITTED;
135:
170:
171: COMMIT;
172:
173: INSERT
174: INTO mrp_plan_schedules
175: (organization_id,
176: compile_designator,
177: input_type,
178: input_name,
193: SYSDATE,
194: arg_user_id,
195: SYSDATE,
196: -1
197: FROM mrp_plan_schedules
198: WHERE organization_id = arg_org_id
199: AND compile_designator = arg_compile_desig
200: AND plan_level = CURRENT_LEVEL;
201: