APPS.GHR_PDI_PKG dependencies on GHR_ROUTING_LIST_MEMBERS

Line 7: ,p_next_seq_number OUT ghr_routing_list_members.seq_number%TYPE

3:
4: PROCEDURE get_last_routing_list(p_position_description_id IN ghr_position_descriptions.position_description_id%TYPE
5: ,p_routing_list_id OUT ghr_routing_lists.routing_list_id%TYPE
6: ,p_routing_list_name OUT ghr_routing_lists.name%TYPE
7: ,p_next_seq_number OUT ghr_routing_list_members.seq_number%TYPE
8: ,p_next_user_name OUT ghr_routing_list_members.user_name%TYPE
9: ,p_next_groupbox_id OUT ghr_routing_list_members.groupbox_id%TYPE
10: ,p_broken IN OUT BOOLEAN);
11:

Line 8: ,p_next_user_name OUT ghr_routing_list_members.user_name%TYPE

4: PROCEDURE get_last_routing_list(p_position_description_id IN ghr_position_descriptions.position_description_id%TYPE
5: ,p_routing_list_id OUT ghr_routing_lists.routing_list_id%TYPE
6: ,p_routing_list_name OUT ghr_routing_lists.name%TYPE
7: ,p_next_seq_number OUT ghr_routing_list_members.seq_number%TYPE
8: ,p_next_user_name OUT ghr_routing_list_members.user_name%TYPE
9: ,p_next_groupbox_id OUT ghr_routing_list_members.groupbox_id%TYPE
10: ,p_broken IN OUT BOOLEAN);
11:
12: PROCEDURE get_roles (p_position_description_id in number

Line 9: ,p_next_groupbox_id OUT ghr_routing_list_members.groupbox_id%TYPE

5: ,p_routing_list_id OUT ghr_routing_lists.routing_list_id%TYPE
6: ,p_routing_list_name OUT ghr_routing_lists.name%TYPE
7: ,p_next_seq_number OUT ghr_routing_list_members.seq_number%TYPE
8: ,p_next_user_name OUT ghr_routing_list_members.user_name%TYPE
9: ,p_next_groupbox_id OUT ghr_routing_list_members.groupbox_id%TYPE
10: ,p_broken IN OUT BOOLEAN);
11:
12: PROCEDURE get_roles (p_position_description_id in number
13: ,p_routing_group_id in number