PACKAGE: APPS.PER_TMPROFILE_PKG

Source

1 package PER_TMPROFILE_PKG AUTHID CURRENT_USER as
2 /* $Header: pertppkg.pkh 120.2 2011/11/24 08:43:27 sgnanama ship $ */
3   FUNCTION is_subordinate (p_subordinate_person_id    in number
4                           ,p_person_id                in number
5                           ,p_effective_date           in date) return varchar2;
6 
7   FUNCTION get_address (p_person_id       in number
8                        ,p_effective_date  in date) return varchar2;
9 
10   pragma restrict_references (get_address, WNPS, WNDS);
11 
12   FUNCTION encode64 (p_blob in blob) return clob;
13 
14   FUNCTION get_value_for_9box(p_person_id IN NUMBER
15                              ,p_effective_date IN DATE
16                              ,p_type IN VARCHAR2) RETURN NUMBER;
17 
18    FUNCTION get_sshr_actions_menu_name(p_person_id IN NUMBER
19 			     ,p_effective_date IN DATE ) RETURN VARCHAR2;
20 
21    TYPE TABLE_OF_NUMBER IS TABLE OF NUMBER;
22 
23 end PER_TMPROFILE_PKG;