[Home] [Help]
PACKAGE: APPS.HR_BPL_ALERT_RECIPIENT
Source
1 PACKAGE HR_BPL_ALERT_RECIPIENT AUTHID CURRENT_USER AS
2 /* $Header: perbarpt.pkh 115.2 2003/05/14 14:57:51 jrstewar noship $ */
3 --
4 -- -----------------------------------------------------------------------
5 --
6 -- Globals used in cache_asg_sup_psn_details
7 --
8 g_pasg_sup_assignment_id NUMBER;
9 g_pasg_sup_person_email VARCHAR2(240);
10 g_pasg_sup_person_email_set NUMBER;
11 g_pasg_sup_person_available NUMBER;
12 g_pasg_sup_sup_person_id NUMBER;
13 g_pasg_sup_person_name VARCHAR2(240);
14 g_pasg_sup_person_lang VARCHAR2(10);
15 g_pasg_sup_business_group_id NUMBER;
16 --
17 -- -----------------------------------------------------------------------
18 --
19 -- Globals used in cache_asg_sup_psn_details
20 --
21 g_asg_sup_assignment_id NUMBER;
22 g_asg_sup_person_email VARCHAR2(240);
23 g_asg_sup_person_email_set NUMBER;
24 g_asg_sup_person_available NUMBER;
25 g_asg_sup_sup_person_id NUMBER;
26 g_asg_sup_person_name VARCHAR2(240);
27 g_asg_sup_person_lang VARCHAR2(10);
28 g_asg_sup_business_group_id NUMBER;
29 --
30 -- -----------------------------------------------------------------------
31 --
32 -- Globals used in cache_asg_psn_details
33 --
34 g_assignment_id NUMBER;
35 g_asg_person_email VARCHAR2(240);
36 g_asg_person_email_set NUMBER;
37 g_asg_sup_person_id NUMBER;
38 g_asg_person_name VARCHAR2(240);
39 g_asg_person_lang VARCHAR2(10);
40 g_asg_business_group_id NUMBER;
41 --
42 -- -----------------------------------------------------------------------
43 --
44 -- Globals used in Get_psn_eml_addrss
45 --
46 g_person_id NUMBER;
47 g_person_email VARCHAR2(240);
48 g_person_email_set NUMBER;
49 g_person_name VARCHAR2(240);
50 g_person_lang VARCHAR2(10);
51 g_person_bg_id NUMBER;
52 -- -----------------------------------------------------------------------
53 --
54 -- Globals used in cache_all_psn_details
55 --
56 g_all_person_id NUMBER;
57 g_all_person_email VARCHAR2(240);
58 g_all_person_email_set NUMBER;
59 g_all_person_name VARCHAR2(240);
60 g_all_person_lang VARCHAR2(10);
61 g_all_person_bg_id NUMBER;
62 --
63 -- -----------------------------------------------------------------------
64 --
65 -- Globals used in Get_psn_sup_psn_eml_addrss
66 --
67 g_psn_sup_person_id NUMBER; -- The id of the psn who's supervisor
68 -- we are checking.
69 g_sup_person_id NUMBER; -- The id of the Supervisor for the Person
70 g_sup_person_name VARCHAR2(240);
71 g_sup_person_email VARCHAR2(240);
72 g_sup_person_email_set NUMBER;
73 g_sup_person_lang VARCHAR2(10);
74 g_sup_business_group_id NUMBER;
75 --
76 FUNCTION Get_psn_eml_addrss(p_person_id IN NUMBER)
77 RETURN VARCHAR2;
78 --
79 FUNCTION Get_psn_sup_psn_eml_addrss(p_person_id IN NUMBER)
80 RETURN VARCHAR2;
81 --
82 FUNCTION Get_psn_prsn_nm(p_person_id IN NUMBER)
83 RETURN VARCHAR2;
84 --
85 FUNCTION Get_all_psn_prsn_nm(p_person_id IN NUMBER)
86 RETURN VARCHAR2;
87 --
88 FUNCTION Get_psn_sup_psn_nm(p_person_id IN NUMBER)
89
90 RETURN VARCHAR2;
91 --
92 FUNCTION Get_psn_lng(p_person_id IN NUMBER)
93 RETURN VARCHAR2;
94 --
95 FUNCTION Get_psn_sup_psn_lng(p_person_id IN NUMBER)
96 RETURN VARCHAR2;
97 --
98 FUNCTION Get_bg_lng(p_business_group_id IN NUMBER)
99 RETURN VARCHAR2;
100 --
101 FUNCTION Check_person_in_scope(p_person_id IN NUMBER)
102 RETURN NUMBER;
103 --
104 FUNCTION Check_sup_person_in_scope(p_person_id IN NUMBER)
105 RETURN NUMBER;
106 --
107 --
108 FUNCTION Get_asg_sup_eml_addrss(p_assignment_id IN NUMBER)
109 RETURN VARCHAR2;
110 --
111 FUNCTION Get_asg_sup_nm(p_assignment_id IN NUMBER)
112 RETURN VARCHAR2;
113 --
114 FUNCTION Get_asg_sup_lng(p_assignment_id IN NUMBER)
115 RETURN VARCHAR2;
116 --
117 FUNCTION Check_asg_sup_in_scope(p_assignment_id IN NUMBER)
118 RETURN NUMBER;
119 --
120 FUNCTION Get_pasg_sup_eml_addrss(p_assignment_id IN NUMBER)
121 RETURN VARCHAR2;
122 --
123 FUNCTION Get_pasg_sup_nm(p_assignment_id IN NUMBER)
124 RETURN VARCHAR2;
125 --
126 FUNCTION Get_pasg_sup_lng(p_assignment_id IN NUMBER)
127 RETURN VARCHAR2;
128 --
129 FUNCTION Check_pasg_sup_in_scope(p_assignment_id IN NUMBER)
130 RETURN NUMBER;
131 --
132 FUNCTION Get_asg_psn_eml_addrss(p_assignment_id IN NUMBER)
133 RETURN VARCHAR2;
134 --
135 FUNCTION Get_asg_psn_nm(p_assignment_id IN NUMBER)
136 RETURN VARCHAR2;
137 --
138 FUNCTION Get_asg_psn_lng(p_assignment_id IN NUMBER)
139 RETURN VARCHAR2;
140 --
141 FUNCTION Check_asg_psn_in_scope(p_assignment_id IN NUMBER)
142 RETURN NUMBER;
143 --
144 FUNCTION validate_email_address(p_email_address VARCHAR2)
145 RETURN BOOLEAN;
146 --
147 FUNCTION c_validate_email_address(p_email_address VARCHAR2)
148 RETURN VARCHAR2;
149 --
150 FUNCTION Check_asg_sup_available(p_assignment_id IN NUMBER)
151 RETURN NUMBER;
152 --
153 FUNCTION Check_pasg_sup_available(p_assignment_id IN NUMBER)
154 RETURN NUMBER;
155 --
156 END HR_BPL_ALERT_RECIPIENT;