77: l_cursor := 'DELETE STATEMENTS';
78: DELETE FROM mrp_bis_inv_detail
79: WHERE compile_designator = p_designator;
80:
81: DELETE FROM mrp_bis_plan_profit
82: WHERE compile_designator = p_designator;
83:
84: DELETE FROM mrp_bis_res_summary
85: WHERE compile_designator = p_designator;
497: AND sys.repetitive_type = 2
498: AND sys.compile_designator = plan_name
499: AND sys.organization_id = p_org_id;
500:
501: INSERT into mrp_bis_plan_profit
502: (compile_designator,
503: organization_id,
504: owning_org_id,
505: schedule_designator,