4: PROCEDURE INSERT_ROUT_STATUS IS
5: /*Cursor to get all the routing information */
6: CURSOR Cur_routing IS
7: SELECT *
8: FROM gmd_routings_b r
9: WHERE EXISTS (Select 1
10: from gmd_routings_b
11: Where routing_id = r.routing_id AND
12: routing_status IS NULL)
6: CURSOR Cur_routing IS
7: SELECT *
8: FROM gmd_routings_b r
9: WHERE EXISTS (Select 1
10: from gmd_routings_b
11: Where routing_id = r.routing_id AND
12: routing_status IS NULL)
13: ORDER BY routing_id;
14:
49: IF ((rout_rec.inactive_ind = 1) OR (rout_rec.delete_mark = 1)) THEN
50: l_routing_status := '1000';
51: END IF;
52:
53: UPDATE gmd_routings_b
54: SET process_loss = 0,
55: effective_start_date = rout_rec.creation_date ,
56: effective_end_date = NULL,
57: owner_id = rout_rec.created_by,
62: EXCEPTION
63: WHEN OTHERS THEN
64: error_msg := SQLERRM;
65: GMD_RECIPE_MIGRATION.insert_message (p_source_table => 'FM_ROUT_HDR'
66: ,p_target_table => 'GMD_ROUTINGS_B'
67: ,p_source_id => rout_rec.routing_id
68: ,p_target_id => rout_rec.routing_id
69: ,p_message => error_msg
70: ,p_error_type => 'U');