DBA Data[Home] [Help]

PACKAGE: APPS.GHR_PDI_PKG

Source


1 PACKAGE ghr_pdi_pkg AUTHID CURRENT_USER AS
2 /* $Header: ghrwspdi.pkh 115.2 99/10/14 12:12:42 porting ship  $ */
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 
12 PROCEDURE get_roles (p_position_description_id     in number
13                       ,p_routing_group_id  in number
14                       ,p_user_name         in varchar2 default null
15                       ,p_initiator_flag    in out varchar2
16                       ,p_requester_flag    in out varchar2
17                       ,p_authorizer_flag   in out varchar2
18                       ,p_personnelist_flag in out varchar2
19                       ,p_approver_flag     in out varchar2
20                       ,p_reviewer_flag     in out varchar2);
21 END;