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;