eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GHR_PA_REQUESTS_PKG dependencies on GHR_ROUTING_LIST_MEMBERS

Line 389: ,p_next_seq_number OUT NOCOPY ghr_routing_list_members.seq_number%TYPE

385:
386: PROCEDURE get_last_routing_list(p_pa_request_id IN ghr_pa_requests.pa_request_id%TYPE
387: ,p_routing_list_id OUT NOCOPY ghr_routing_lists.routing_list_id%TYPE
388: ,p_routing_list_name OUT NOCOPY ghr_routing_lists.name%TYPE
389: ,p_next_seq_number OUT NOCOPY ghr_routing_list_members.seq_number%TYPE
390: ,p_next_user_name OUT NOCOPY ghr_routing_list_members.user_name%TYPE
391: ,p_next_groupbox_id OUT NOCOPY ghr_routing_list_members.groupbox_id%TYPE
392: ,p_broken IN OUT NOCOPY BOOLEAN) IS
393:

Line 390: ,p_next_user_name OUT NOCOPY ghr_routing_list_members.user_name%TYPE

386: PROCEDURE get_last_routing_list(p_pa_request_id IN ghr_pa_requests.pa_request_id%TYPE
387: ,p_routing_list_id OUT NOCOPY ghr_routing_lists.routing_list_id%TYPE
388: ,p_routing_list_name OUT NOCOPY ghr_routing_lists.name%TYPE
389: ,p_next_seq_number OUT NOCOPY ghr_routing_list_members.seq_number%TYPE
390: ,p_next_user_name OUT NOCOPY ghr_routing_list_members.user_name%TYPE
391: ,p_next_groupbox_id OUT NOCOPY ghr_routing_list_members.groupbox_id%TYPE
392: ,p_broken IN OUT NOCOPY BOOLEAN) IS
393:
394:

Line 391: ,p_next_groupbox_id OUT NOCOPY ghr_routing_list_members.groupbox_id%TYPE

387: ,p_routing_list_id OUT NOCOPY ghr_routing_lists.routing_list_id%TYPE
388: ,p_routing_list_name OUT NOCOPY ghr_routing_lists.name%TYPE
389: ,p_next_seq_number OUT NOCOPY ghr_routing_list_members.seq_number%TYPE
390: ,p_next_user_name OUT NOCOPY ghr_routing_list_members.user_name%TYPE
391: ,p_next_groupbox_id OUT NOCOPY ghr_routing_list_members.groupbox_id%TYPE
392: ,p_broken IN OUT NOCOPY BOOLEAN) IS
393:
394:
395: l_broken BOOLEAN ;

Line 425: FROM ghr_routing_list_members rlm

421: ,p_seq_number IN NUMBER) IS
422: SELECT rlm.seq_number
423: ,rlm.user_name
424: ,rlm.groupbox_id
425: FROM ghr_routing_list_members rlm
426: WHERE rlm.routing_list_id = p_routing_list_id
427: AND rlm.seq_number > p_seq_number
428: ORDER BY rlm.seq_number asc;
429: