940:
941:
942:
943: -- Having got the l_1_pa_routing_history_id and l_1_prh_object_version_number
944: -- from the above procedure, use it in the ghr_prh_upd.upd to update the groupbox_id
945: -- ( use ghr_mass_actions_pkg.get_personnel_off_groupbox to get the groupbox_id and
946: -- the routing_group_id)
947: -- Also update the ghr_pa_requests with the routing_group_id passed out
948: -- ghr_par_upd.upd
967: || '; Error: '||sqlerrm(sqlcode);
968: RAISE groupbox_err;
969: END;
970:
971: -- Call ghr_prh_upd.upd here
972:
973: ghr_prh_upd.upd(
974: p_pa_routing_history_id => l_1_pa_routing_history_id,
975: p_groupbox_id => l_groupbox_id,
969: END;
970:
971: -- Call ghr_prh_upd.upd here
972:
973: ghr_prh_upd.upd(
974: p_pa_routing_history_id => l_1_pa_routing_history_id,
975: p_groupbox_id => l_groupbox_id,
976: p_object_version_number => l_1_prh_object_version_number);
977:
1140: l_object_version_number := routing_history_id.object_version_number;
1141: exit;
1142: end loop;
1143:
1144: ghr_prh_upd.upd
1145: (p_pa_routing_history_id => l_pa_routing_history_id,
1146: p_object_version_number => l_object_version_number,
1147: p_action_taken => 'FUTURE_ACTION'
1148: );