[Home] [Help]
PACKAGE: APPS.HR_VIEW_ALERT_RECIPIENT
Source
1 PACKAGE HR_VIEW_ALERT_RECIPIENT AUTHID CURRENT_USER AS
2 /* $Header: pervarpt.pkh 115.1 2003/05/14 15:14:04 jrstewar noship $ */
3 --
4 FUNCTION Get_all_psn_prsn_nm(p_person_id IN NUMBER)
5 RETURN VARCHAR2;
6 --
7 FUNCTION Get_all_psn_prsn_nm(p_person_id IN VARCHAR2)
8 RETURN VARCHAR2;
9 --
10 FUNCTION Get_psn_eml_addrss(p_person_id IN NUMBER)
11 RETURN VARCHAR2;
12 --
13 FUNCTION Get_psn_eml_addrss(p_person_id IN VARCHAR2)
14 RETURN VARCHAR2;
15 --
16 FUNCTION Get_psn_sup_psn_eml_addrss(p_person_id IN NUMBER)
17 RETURN VARCHAR2;
18 --
19 FUNCTION Get_psn_sup_psn_eml_addrss(p_person_id IN VARCHAR2)
20 RETURN VARCHAR2;
21 --
22 FUNCTION Get_psn_prsn_nm(p_person_id IN NUMBER)
23 RETURN VARCHAR2;
24 --
25 FUNCTION Get_psn_prsn_nm(p_person_id IN VARCHAR2)
26 RETURN VARCHAR2;
27 --
28 FUNCTION Get_psn_sup_psn_nm(p_person_id IN NUMBER)
29 RETURN VARCHAR2;
30 --
31 FUNCTION Get_psn_sup_psn_nm(p_person_id IN VARCHAR2)
32 RETURN VARCHAR2;
33 --
34 FUNCTION Get_psn_lng(p_person_id IN NUMBER)
35 RETURN VARCHAR2;
36 --
37 FUNCTION Get_psn_sup_psn_lng(p_person_id IN NUMBER)
38 RETURN VARCHAR2;
39 --
40 FUNCTION Check_person_in_scope(p_person_id IN NUMBER)
41 RETURN VARCHAR2;
42 --
43 FUNCTION Check_sup_person_in_scope(p_person_id IN NUMBER)
44 RETURN VARCHAR2;
45 --
46 FUNCTION Get_asg_sup_eml_addrss(p_assignment_id IN NUMBER)
47 RETURN VARCHAR2;
48 --
49 FUNCTION Get_asg_sup_nm(p_assignment_id IN NUMBER)
50 RETURN VARCHAR2;
51 --
52 FUNCTION Get_asg_sup_lng(p_assignment_id IN NUMBER)
53 RETURN VARCHAR2;
54 --
55 FUNCTION Check_asg_sup_in_scope(p_assignment_id IN NUMBER)
56 RETURN NUMBER;
57 --
58 FUNCTION Get_pasg_sup_eml_addrss(p_assignment_id IN NUMBER)
59 RETURN VARCHAR2;
60 --
61 FUNCTION Get_pasg_sup_nm(p_assignment_id IN NUMBER)
62 RETURN VARCHAR2;
63 --
64 FUNCTION Get_pasg_sup_lng(p_assignment_id IN NUMBER)
65 RETURN VARCHAR2;
66 --
67 FUNCTION Check_pasg_sup_in_scope(p_assignment_id IN NUMBER)
68 RETURN NUMBER;
69 --
70 FUNCTION Get_asg_psn_eml_addrss(p_assignment_id IN NUMBER)
71 RETURN VARCHAR2;
72 --
73 FUNCTION Get_asg_psn_nm(p_assignment_id IN NUMBER)
74 RETURN VARCHAR2;
75 --
76 FUNCTION Get_asg_psn_lng(p_assignment_id IN NUMBER)
77 RETURN VARCHAR2;
78 --
79 FUNCTION Check_asg_psn_in_scope(p_assignment_id IN NUMBER)
80 RETURN NUMBER;
81 --
82 FUNCTION Check_asg_sup_available(p_assignment_id IN NUMBER)
83 RETURN NUMBER;
84 --
85 FUNCTION Check_pasg_sup_available(p_assignment_id IN NUMBER)
86 RETURN NUMBER;
87 --
88 END HR_VIEW_ALERT_RECIPIENT;