1 Package per_ssm_bus AUTHID CURRENT_USER as
2 /* $Header: pessmrhi.pkh 120.0 2005/05/31 21:51:12 appldev noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |------------------------< return_legislation_code >-----------------------|
6 -- ----------------------------------------------------------------------------
7 Function return_legislation_code( p_salary_survey_mapping_id in number )
8 return varchar2;
9 --
10 -- ----------------------------------------------------------------------------
11 -- |----------------------< chk_non_updateable_args >-----------------------|
12 -- ----------------------------------------------------------------------------
13 --
14 Procedure chk_non_updateable_args(p_rec in per_ssm_shd.g_rec_type);
15
16 -- ----------------------------------------------------------------------------
17 -- |--------------------< get_salary_survey_line_start >----------------------|
18 -- ----------------------------------------------------------------------------
19 --
20 Function get_salary_survey_line_start
21 (p_salary_survey_line_id in number)
22 return date;
23 --
24
25 -- ----------------------------------------------------------------------------
26 -- |---------------------< get_salary_survey_line_end >-----------------------|
27 -- ----------------------------------------------------------------------------
28 --
29 Function get_salary_survey_line_end
30 (p_salary_survey_line_id in number)
31 return date;
32 --
33
34 -- ----------------------------------------------------------------------------
35 -- |---------------------< chk_salary_survey_line_id >------------------------|
36 -- ----------------------------------------------------------------------------
37 --
38 -- Description
39 -- This Procedure checks that a referenced foreign key actually exists
40 -- in the referenced table.
41 --
42 -- Pre-Conditions
43 -- None.
44 --
45 -- In Parameters
46 -- p_salary_survey_mapping_id PK
47 -- p_salary_survey_line_id ID of FK column
48 -- p_object_version_number object version number
49 --
50 -- Post Success
51 -- Processing continues If the foreign key exists in the referenced table.
52 --
53 -- Post Failure
54 -- Processing stops and an error is raised If the foreign key does not
55 -- exist in the referenced table.
56 --
57 -- Access Status
58 -- Internal row handler use only.
59 --
60 Procedure chk_salary_survey_line_id
61 (p_salary_survey_mapping_id in number,
62 p_salary_survey_line_id in number,
63 p_object_version_number in number);
64
65
66 -- ----------------------------------------------------------------------------
67 -- |-----------------------------< chk_parent >-------------------------------|
68 -- ----------------------------------------------------------------------------
69 --
70 -- Description
71 -- This Procedure checks that a referenced foreign key actually exists
72 -- in the referenced table.
73 --
74 -- Pre-Conditions
75 -- None.
76 --
77 -- In Parameters
78 -- p_salary_survey_mapping_id PK
79 -- p_parent_id ID of FK column in table p_parent_table_name
80 -- p_parent_table_name is the name of the table for which parent_id is the PK
81 -- p_business_group_id is the business group ID of the salary survey mapping
82 -- p_object_version_number object version number
83 --
84 -- Post Success
85 -- Processing continues If the foreign key exists in the referenced table.
86 --
87 -- Post Failure
88 -- Processing stops and an error is raised If the foreign key does not
89 -- exist in the referenced table.
90 --
91 -- Access Status
92 -- Internal row handler use only.
93 --
94 Procedure chk_parent
95 (p_salary_survey_mapping_id in number,
96 p_parent_id in number,
97 p_parent_table_name in varchar2,
98 p_business_group_id in number,
99 p_object_version_number in number,
100 p_ssl_start_date in date,
101 p_ssl_end_date in date);
102 --
103 --
104
105 --
106 -- ----------------------------------------------------------------------------
107 -- |---------------------------< chk_unique_key >-----------------------------|
108 -- ----------------------------------------------------------------------------
109 --
110 -- Description
111 -- This Procedure is used to check that salary_survey_line_id,
112 -- parent_table_name and the parent_table_id are in a unique combination
113 -- compared to other rows in the table per_salary_survey_mappings.
114 --
115 --
116 -- Pre-Conditions
117 -- None.
118 --
119 -- In Parameters
120 -- p_salary_survey_mapping_id PK
121 -- p_parent_id ID of FK column in table p_parent_table_name
122 -- p_parent_table_name is the name of the table for which parent_id is the PK
123 -- p_salary_survey_line_id is the salary survey line ID of the salary survey
124 -- mapping
125 -- p_object_version_number object version number
126 --
127 -- Post Success
128 -- Processing continues If the salary_survey_line_id, parent_table_name
129 -- and the parent_table_id are in a unique combination compared to
130 -- other rows in the table per_salary_survey_mappings.
131 --
132 -- Post Failure
133 -- Processing stops and an error is raised if the unique key validation
134 -- is breeched.
135 --
136 -- Access Status
137 -- Internal row handler use only.
138 --
139 Procedure chk_unique_key
140 (p_salary_survey_mapping_id in number,
141 p_parent_id in number,
142 p_parent_table_name in varchar2,
143 p_salary_survey_line_id in number,
144 p_grade_id in number,
145 p_location_id in number,
146 p_company_organization_id in number,
147 p_company_age_code in varchar2,
148 p_object_version_number in number);
149 --
150 -- ----------------------------------------------------------------------------
151 -- |--------------------------< chk_location_id >-----------------------------|
152 -- ----------------------------------------------------------------------------
153 --
154 -- Description
155 -- This Procedure checks that a referenced foreign key actually exists
156 -- in the referenced table.
157 --
158 -- Pre-Conditions
159 -- None.
160 --
161 -- In Parameters
162 -- p_salary_survey_mapping_id PK
163 -- p_location_id ID of FK column
164 -- p_object_version_number object version number
165 --
166 -- Post Success
167 -- Processing continues If the foreign key exists in the referenced table.
168 --
169 -- Post Failure
170 -- Processing stops and an error is raised If the foreign key does not
171 -- exist in the referenced table.
172 --
173 -- Access Status
174 -- Internal row handler use only.
175 --
176 Procedure chk_location_id
177 (p_salary_survey_mapping_id in number,
178 p_location_id in number,
179 p_object_version_number in number,
180 p_ssl_start_date in date);
181 --
182 --
183 -- ----------------------------------------------------------------------------
184 -- |----------------------------< chk_grade_id >------------------------------|
185 -- ----------------------------------------------------------------------------
186 --
187 -- Description
188 -- This Procedure checks that a referenced foreign key actually exists
189 -- in the referenced table.
190 --
191 -- Pre-Conditions
192 -- None.
193 --
194 -- In Parameters
195 -- p_salary_survey_mapping_id PK
196 -- p_grade_id ID of FK column
197 -- p_business_group_id the business group ID of the salary survey mapping
198 -- p_object_version_number object version number
199 --
200 -- Post Success
201 -- Processing continues If the foreign key exists in the referenced table.
202 --
203 -- Post Failure
204 -- Processing stops and an error is raised If the foreign key does not
205 -- exist in the referenced table.
206 --
207 -- Access Status
208 -- Internal row handler use only.
209 --
210 Procedure chk_grade_id
211 (p_salary_survey_mapping_id in number,
212 p_grade_id in number,
213 p_business_group_id in number,
214 p_object_version_number in number,
215 p_ssl_start_date in date,
216 p_ssl_end_date in date);
217 --
218 --
219 --
220 -- ----------------------------------------------------------------------------
221 -- |--------------------< chk_company_organization_id >-----------------------|
222 -- ----------------------------------------------------------------------------
223 --
224 -- Description
225 -- This Procedure checks that a referenced foreign key actually exists
226 -- in the referenced table.
227 --
228 -- Pre-Conditions
229 -- None.
230 --
231 -- In Parameters
232 -- p_salary_survey_mapping_id PK
233 -- p_company_organization_id ID of FK column
234 -- p_business_group_id the business group ID of the salary survey mapping
235 -- p_object_version_number object version number
236 --
237 -- Post Success
238 -- Processing continues If the foreign key exists in the referenced table.
239 --
240 -- Post Failure
241 -- Processing stops and an error is raised If the foreign key does not
242 -- exist in the referenced table.
243 --
244 -- Access Status
245 -- Internal row handler use only.
246 --
247 Procedure chk_company_organization_id
248 (p_salary_survey_mapping_id in number,
249 p_company_organization_id in number,
250 p_business_group_id in number,
251 p_object_version_number in number,
252 p_ssl_start_date in date,
253 p_ssl_end_date in date);
254 --
255 --
256 --
257 --
258 -- ----------------------------------------------------------------------------
259 -- |------------------------< chk_company_age_code >--------------------------|
260 -- ----------------------------------------------------------------------------
261 --
262 -- Description
263 -- This Procedure checks that a referenced foreign key actually exists
264 -- in the referenced table.
265 --
266 -- Pre-Conditions
267 -- None.
268 --
269 -- In Parameters
270 -- p_salary_survey_mapping_id PK
271 -- p_company_age_code code for lookup in hr_lookups
272 -- p_object_version_number object version number
273 --
274 -- Post Success
275 -- Processing continues If the lookup exists in the lookup table.
276 --
277 -- Post Failure
278 -- Processing stops and an error is raised If the lookup does not
279 -- exist in the lookup table.
280 --
281 -- Access Status
282 -- Internal row handler use only.
283 --
284 Procedure chk_company_age_code
285 (p_salary_survey_mapping_id in number,
286 p_company_age_code in varchar2,
287 p_effective_date in date,
288 p_object_version_number in number);
289
290 -- ----------------------------------------------------------------------------
291 -- |------------------------< chk_effective_date >----------------------------|
292 -- ----------------------------------------------------------------------------
293 --
294 -- Description
295 -- This Procedure checks that the effective date is not null and is valid
296 --
297 -- Pre-Conditions
298 -- None.
299 --
300 -- In Parameters
301 -- p_effective_date
302 --
303 -- Post Success
304 -- Processing continues If the effective_date is valid
305 --
306 -- Post Failure
307 -- Processing stops and an error is raised.
308 --
309 -- Access Status
310 -- Internal row handler use only.
311 --
312 Procedure chk_effective_date
313 (p_effective_date in date);
314
315 --
316 -- -----------------------------------------------------------------------
317 -- |------------------------------< chk_df >-----------------------------|
318 -- -----------------------------------------------------------------------
319 --
320 -- Description:
321 -- Validates the all Descriptive Flexfield values.
322 --
323 -- Pre-conditions:
324 -- All other columns have been validated. Must be called as the
325 -- last step from insert_validate and update_validate.
326 --
327 -- In Arguments:
328 -- p_rec
329 --
330 -- Post Success:
331 -- If the Descriptive Flexfield structure column and data values are
332 -- all valid this Procedure will End normally and processing will
333 -- continue.
334 --
335 -- Post Failure:
336 -- If the Descriptive Flexfield structure column value or any of
337 -- the data values are invalid Then an application error is raised as
338 -- a PL/SQL exception.
339 --
340 -- Access Status:
341 -- Internal Row Handler Use Only.
342 --
343 Procedure chk_df
344 (p_rec in per_ssm_shd.g_rec_type);
345 --
346 -- ----------------------------------------------------------------------------
347 -- |---------------------------< insert_validate >----------------------------|
348 -- ----------------------------------------------------------------------------
349 -- {Start Of Comments}
350 --
351 -- Description:
352 -- This procedure controls the execution of all insert business rules
353 -- validation.
354 --
355 -- Prerequisites:
356 -- This private procedure is called from ins procedure.
357 --
358 -- In Parameters:
359 -- A Pl/Sql record structre.
360 --
361 -- Post Success:
362 -- Processing continues.
363 --
364 -- Post Failure:
365 -- If a business rules fails the error will not be handled by this procedure
366 -- unless explicity coded.
367 --
368 -- Developer Implementation Notes:
369 -- For insert, your business rules should be executed from this procedure and
370 -- should ideally (unless really necessary) just be straight procedure or
371 -- function calls. Try and avoid using conditional branching logic.
372 --
373 -- Access Status:
374 -- Internal Row Handler Use Only.
375 --
376 -- {End Of Comments}
377 -- ----------------------------------------------------------------------------
378 Procedure insert_validate( p_rec in per_ssm_shd.g_rec_type
379 , p_effective_date in date);
380 --
381 -- ----------------------------------------------------------------------------
382 -- |---------------------------< update_validate >----------------------------|
383 -- ----------------------------------------------------------------------------
384 -- {Start Of Comments}
385 --
386 -- Description:
387 -- This procedure controls the execution of all update business rules
388 -- validation.
389 --
390 -- Prerequisites:
391 -- This private procedure is called from upd procedure.
392 --
393 -- In Parameters:
394 -- A Pl/Sql record structre.
395 --
396 -- Post Success:
397 -- Processing continues.
398 --
399 -- Post Failure:
400 -- If a business rules fails the error will not be handled by this procedure
401 -- unless explicity coded.
402 --
403 -- Developer Implementation Notes:
404 -- For update, your business rules should be executed from this procedure and
405 -- should ideally (unless really necessary) just be straight procedure or
406 -- function calls. Try and avoid using conditional branching logic.
407 --
408 -- Access Status:
409 -- Internal Row Handler Use Only.
410 --
411 -- {End Of Comments}
412 -- ----------------------------------------------------------------------------
413 Procedure update_validate( p_rec in per_ssm_shd.g_rec_type
414 , p_effective_date in date);
415 --
416 -- ----------------------------------------------------------------------------
417 -- |---------------------------< delete_validate >----------------------------|
418 -- ----------------------------------------------------------------------------
419 -- {Start Of Comments}
420 --
421 -- Description:
422 -- This procedure controls the execution of all delete business rules
423 -- validation.
424 --
425 -- Prerequisites:
426 -- This private procedure is called from del procedure.
427 --
428 -- In Parameters:
429 -- A Pl/Sql record structre.
430 --
431 -- Post Success:
432 -- Processing continues.
433 --
434 -- Post Failure:
435 -- If a business rules fails the error will not be handled by this procedure
436 -- unless explicity coded.
437 --
438 -- Developer Implementation Notes:
439 -- For delete, your business rules should be executed from this procedure and
440 -- should ideally (unless really necessary) just be straight procedure or
441 -- function calls. Try and avoid using conditional branching logic.
442 --
443 -- Access Status:
444 -- Internal Row Handler Use Only.
445 --
446 -- {End Of Comments}
447 -- ----------------------------------------------------------------------------
448 Procedure delete_validate(p_rec in per_ssm_shd.g_rec_type);
449 --
450 end per_ssm_bus;
[Home] [Help]