1 Package per_seu_bus AUTHID CURRENT_USER as
2 /* $Header: peseurhi.pkh 120.3 2005/11/08 16:30:29 vbanner noship $ */
3 --
4 -- ---------------------------------------------------------------------------
5 -- |----------------------< set_security_group_id >--------------------------|
6 -- ---------------------------------------------------------------------------
7 -- {Start Of Comments}
8 --
9 -- Description:
10 -- Sets the security_group_id in CLIENT_INFO for the appropriate business
11 -- group context.
12 --
13 -- Prerequisites:
14 -- The primary key identified by p_security_user_id
15 -- already exists.
16 --
17 -- In Arguments:
18 -- p_security_user_id
19 --
20 --
21 -- Post Success:
22 -- The security_group_id will be set in CLIENT_INFO.
23 --
24 -- Post Failure:
25 -- An error is raised if the value does not exist.
26 --
27 -- Access Status:
28 -- Internal Development Use Only.
29 --
30 -- {End Of Comments}
31 -- ---------------------------------------------------------------------------
32 procedure set_security_group_id
33 (p_security_user_id in number
34 ,p_associated_column1 in varchar2 default null
35 );
36 --
37 --
38 -- ---------------------------------------------------------------------------
39 -- |---------------------< return_legislation_code >-------------------------|
40 -- ---------------------------------------------------------------------------
41 -- {Start Of Comments}
42 --
43 -- Description:
44 -- Return the legislation code for a specific primary key value
45 --
46 -- Prerequisites:
47 -- The primary key identified by p_security_user_id
48 -- already exists.
49 --
50 -- In Arguments:
51 -- p_security_user_id
52 --
53 --
54 -- Post Success:
55 -- The business group's legislation code will be returned.
56 --
57 -- Post Failure:
58 -- An error is raised if the value does not exist.
59 --
60 -- Access Status:
61 -- Internal Development Use Only.
62 --
63 -- {End Of Comments}
64 -- ---------------------------------------------------------------------------
65 FUNCTION return_legislation_code
66 (p_security_user_id in number
67 ) RETURN varchar2;
68 --
69 -- ----------------------------------------------------------------------------
70 -- |-----------------------< chk_user_id >------------------------------------|
71 -- ----------------------------------------------------------------------------
72 -- {Start Of Comments}
73 --
74 -- Description:
75 -- This procedure is used to validate that the user_id passed in, is
76 -- a valid and active user.
77 -- This proceure does not validate that the user is linked to a HR person
78 -- nor does it validate that the user has a responsibility attached to
79 -- the current security profile.
80 --
81 -- Prerequisites:
82 -- The primary key identified by p_security_user_id already exists.
83 --
84 -- In Arguments:
85 -- p_security_user_id
86 -- p_user_id
87 -- p_object_version_number
88 -- p_effective_date
89 --
90 -- Post Success:
91 -- Processing continues if the user given passes the validated.
92 --
93 -- Post Failure:
94 -- An application error is raised if the user is not valid.
95 --
96 -- Access Status:
97 -- Internal Development Use Only.
98 --
99 -- {End Of Comments}
100 -- ----------------------------------------------------------------------------
101 --
102 procedure chk_user_id
103 (p_security_user_id in number
104 ,p_user_id in number
105 ,p_object_version_number in number
106 ,p_effective_date in date);
107 --
108 -- ----------------------------------------------------------------------------
109 -- |-----------------------< chk_security_profile_id >------------------------|
110 -- ----------------------------------------------------------------------------
111 -- {Start Of Comments}
112 --
113 -- Description:
114 -- This procedure is used to validate that the security profile passed
115 -- in exists.
116 --
117 -- Prerequisites:
118 -- The primary key identified by p_security_user_id already exists.
119 --
120 -- In Arguments:
121 -- p_security_user_id
122 -- p_security_profile_id
123 -- p_object_version_number
124 --
125 -- Post Success:
126 -- Processing continues if the security profile is validated.
127 --
128 -- Post Failure:
129 -- An application error is raised if the security profile is not valid.
130 --
131 -- Access Status:
132 -- Internal Development Use Only.
133 --
134 -- {End Of Comments}
135 -- ----------------------------------------------------------------------------
136 --
137 procedure chk_security_profile_id
138 (p_security_user_id in number
139 ,p_security_profile_id in number
140 ,p_object_version_number in number);
141 --
142 -- ----------------------------------------------------------------------------
143 -- |-----------------------< chk_association_unique >-------------------------|
144 -- ----------------------------------------------------------------------------
145 -- {Start Of Comments}
146 --
147 -- Description:
148 -- This procedure is used to validate that this user does not already
149 -- exist in this security profile's static list.
150 --
151 -- Prerequisites:
152 -- The primary key identified by p_security_user_id already exists.
153 -- The user_id column is already validated.
154 -- The security_profile_id column is already validated.
155 --
156 -- In Arguments:
157 -- p_security_user_id
158 -- p_user_id
159 -- p_security_profile_id
160 -- p_object_version_number
161 --
162 -- Post Success:
163 -- Processing continues if the association is unique.
164 --
165 -- Post Failure:
166 -- An application error is raised if this security profile already
167 -- includes this user.
168 --
169 -- Access Status:
170 -- Internal Development Use Only.
171 --
172 -- {End Of Comments}
173 -- ----------------------------------------------------------------------------
174 --
175 procedure chk_association_unique
176 (p_security_user_id in number
177 ,p_user_id in number
178 ,p_security_profile_id in number
179 ,p_object_version_number in number);
180 --
181 -- ----------------------------------------------------------------------------
182 --
183 procedure chk_process_in_next_run_flag
184 (p_security_user_id in number
185 ,p_process_in_next_run_flag in varchar2
186 ,p_object_version_number in number);
187 --
188 -- ----------------------------------------------------------------------------
189 -- |---------------------------< insert_validate >----------------------------|
190 -- ----------------------------------------------------------------------------
191 -- {Start of comments}
192 --
193 -- Description:
194 -- This procedure controls the execution of all insert business rules
195 -- validation.
196 --
197 -- Prerequisites:
198 -- This private procedure is called from ins procedure.
199 --
200 -- In Parameters:
201 -- A Pl/Sql record structure.
202 --
203 -- Post Success:
204 -- Processing continues.
205 --
206 -- Post Failure:
207 -- If a business rules fails the error will not be handled by this procedure
208 -- unless explicity coded.
209 --
210 -- Developer Implementation Notes:
211 -- For insert, your business rules should be executed from this procedure
212 -- and should ideally (unless really necessary) just be straight procedure
213 -- or function calls. Try and avoid using conditional branching logic.
214 --
215 -- Access Status:
216 -- Internal Row Handler Use Only.
217 --
218 -- {End of comments}
219 -- ----------------------------------------------------------------------------
220 Procedure insert_validate
221 (p_effective_date in date
222 ,p_rec in per_seu_shd.g_rec_type
223 );
224 --
225 -- ----------------------------------------------------------------------------
226 -- |---------------------------< update_validate >----------------------------|
227 -- ----------------------------------------------------------------------------
228 -- {Start Of Comments}
229 --
230 -- Description:
231 -- This procedure controls the execution of all update business rules
232 -- validation.
233 --
234 -- Prerequisites:
235 -- This private procedure is called from upd procedure.
236 --
237 -- In Parameters:
238 -- A Pl/Sql record structure.
239 --
240 -- Post Success:
241 -- Processing continues.
242 --
243 -- Post Failure:
244 -- If a business rules fails the error will not be handled by this procedure
245 -- unless explicity coded.
246 --
247 -- Access Status:
248 -- Internal Row Handler Use Only.
249 --
250 -- {End Of Comments}
251 -- ----------------------------------------------------------------------------
252 Procedure update_validate
253 (p_effective_date in date
254 ,p_rec in per_seu_shd.g_rec_type
255 );
256 --
257 -- ----------------------------------------------------------------------------
258 -- |---------------------------< delete_validate >----------------------------|
259 -- ----------------------------------------------------------------------------
260 -- {Start Of Comments}
261 --
262 -- Description:
263 -- This procedure controls the execution of all delete business rules
264 -- validation.
265 --
266 -- Prerequisites:
267 -- This private procedure is called from del procedure.
268 --
269 -- In Parameters:
270 -- A Pl/Sql record structure.
271 --
272 -- Post Success:
273 -- Processing continues.
274 --
275 -- Post Failure:
276 -- If a business rules fails the error will not be handled by this procedure
277 -- unless explicity coded.
278 --
279 -- Developer Implementation Notes:
280 -- For delete, your business rules should be executed from this procedure
281 -- and should ideally (unless really necessary) just be straight procedure
282 -- or function calls. Try and avoid using conditional branching logic.
283 --
284 -- Access Status:
285 -- Internal Row Handler Use Only.
286 --
287 -- {End Of Comments}
288 -- ----------------------------------------------------------------------------
289 Procedure delete_validate
290 (p_rec in per_seu_shd.g_rec_type
291 );
292 --
293 end per_seu_bus;