DBA Data[Home] [Help]

PACKAGE: APPS.GHR_PDI_PKG

Source


1 PACKAGE ghr_pdi_pkg AUTHID CURRENT_USER AS
2 /* $Header: ghrwspdi.pkh 120.0.12010000.3 2009/05/26 12:08:45 utokachi noship $ */
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 NOCOPY ghr_routing_lists.routing_list_id%TYPE
6                                  ,p_routing_list_name    OUT NOCOPY ghr_routing_lists.name%TYPE
7                                  ,p_next_seq_number      OUT NOCOPY ghr_routing_list_members.seq_number%TYPE
8                                  ,p_next_user_name       OUT NOCOPY ghr_routing_list_members.user_name%TYPE
9                                  ,p_next_groupbox_id     OUT NOCOPY ghr_routing_list_members.groupbox_id%TYPE
10                                  ,p_broken            IN OUT NOCOPY 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 NOCOPY varchar2
16                       ,p_requester_flag    in out NOCOPY varchar2
17                       ,p_authorizer_flag   in out NOCOPY varchar2
18                       ,p_personnelist_flag in out NOCOPY varchar2
19                       ,p_approver_flag     in out NOCOPY varchar2
20                       ,p_reviewer_flag     in out NOCOPY varchar2);
21 END;