APPS.GHR_PDI_PKG dependencies on GHR_ROUTING_LIST_MEMBERS

Line 8: ,p_next_seq_number OUT ghr_routing_list_members.seq_number%TYPE

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

Line 9: ,p_next_user_name OUT ghr_routing_list_members.user_name%TYPE

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

Line 10: ,p_next_groupbox_id OUT ghr_routing_list_members.groupbox_id%TYPE

6: ,p_routing_list_id OUT ghr_routing_lists.routing_list_id%TYPE
7: ,p_routing_list_name OUT ghr_routing_lists.name%TYPE
8: ,p_next_seq_number OUT ghr_routing_list_members.seq_number%TYPE
9: ,p_next_user_name OUT ghr_routing_list_members.user_name%TYPE
10: ,p_next_groupbox_id OUT ghr_routing_list_members.groupbox_id%TYPE
11: ,p_broken IN OUT BOOLEAN) IS
12:
13: CURSOR cur_pdh_last_rli IS
14: SELECT rli.routing_list_id

Line 42: FROM ghr_routing_list_members rlm

38: ,p_seq_number IN NUMBER) IS
39: SELECT rlm.seq_number
40: ,rlm.user_name
41: ,rlm.groupbox_id
42: FROM ghr_routing_list_members rlm
43: WHERE rlm.routing_list_id = p_routing_list_id
44: AND rlm.seq_number > p_seq_number
45: ORDER BY rlm.seq_number asc;
46: BEGIN