2705: stmt_num := 9;
2706: BEGIN
2707: SELECT delete_group_sequence_id, delete_type
2708: INTO X_delete_group_seq_id, X_delete_type
2709: FROM bom_delete_groups
2710: WHERE delete_group_name = X_bill_group_name
2711: AND organization_id = c2rec.OI;
2712:
2713: /* if delete group if of type routings. make it
2713: /* if delete group if of type routings. make it
2714: * of type bill, routings
2715: */
2716: if X_delete_type = 3 then
2717: update bom_delete_groups
2718: set delete_type = 6
2719: WHERE delete_group_name = X_bill_group_name
2720: AND organization_id = c2rec.OI;
2721: