[Home] [Help]
PACKAGE: APPS.PER_CTK_BUS
Source
1 Package per_ctk_bus as
2 /* $Header: pectkrhi.pkh 120.5 2006/09/06 06:03:49 sturlapa 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_task_in_checklist_id
15 -- already exists.
16 --
17 -- In Arguments:
18 -- p_task_in_checklist_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_task_in_checklist_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_task_in_checklist_id
48 -- already exists.
49 --
50 -- In Arguments:
51 -- p_task_in_checklist_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_task_in_checklist_id in number
67 ) RETURN varchar2;
68 --
69 -- ---------------------------------------------------------------------------
70 -- |---------------------------< chk_checklist_id >--------------------------|
71 -- ---------------------------------------------------------------------------
72 --
73 -- Desciption :
74 --
75 -- Validates that CHECKLIST_ID exists in per_checklists on the
76 -- effective_date.
77 --
78 --
79 -- Pre-conditions :
80 --
81 --
82 -- In Arguments :
83 -- p_checklist_task_id
84 -- p_effective_date
85 --
86 -- Post Success :
87 -- Processing continues
88 --
89 -- Post Failure :
90 -- An application error will be raised and processing is
91 -- terminated
92 --
93 -- Access Status :
94 -- Internal Row Handler Use only.
95 --
96 -- {End of Comments}
97 --
98 -- ---------------------------------------------------------------------------
99 procedure chk_checklist_id
100 (p_checklist_id in per_tasks_in_checklist.checklist_id%TYPE
101 );
102 --
103
104 -- ---------------------------------------------------------------------------
105 -- |------------------------------< chk_task_name >--------------------------|
106 -- ---------------------------------------------------------------------------
107 --
108 -- Desciption :
109 --
110 -- Validates that TASK_NAME is mandatory
111 --
112 -- Pre-conditions :
113 --
114 --
115 -- In Arguments :
116 -- p_checklist_task_name
117 --
118 -- Post Success :
119 -- Processing continues
120 --
121 -- Post Failure :
122 -- An application error will be raised and processing is
123 -- terminated
124 --
125 -- Access Status :
126 -- Internal Row Handler Use only.
127 --
128 -- {End of Comments}
129 --
130 -- ---------------------------------------------------------------------------
131 procedure chk_task_name
132 (p_checklist_task_name in per_tasks_in_checklist.checklist_task_name%TYPE
133 ,p_task_in_checklist_id in per_tasks_in_checklist.task_in_checklist_id%TYPE
134 ,p_checklist_id in per_tasks_in_checklist.checklist_id%TYPE
135 ,p_object_version_number in per_tasks_in_checklist.object_version_number%type
136 );
137 --
138 -- ---------------------------------------------------------------------------
139 -- |----------------------------< chk_duration_uom >-------------------------|
140 -- ---------------------------------------------------------------------------
141 --
142 -- Desciption :
143 --
144 -- Validates that target_duration and target_duration_uom are in synch
145 -- if target_duration has value, target_duration_uom is mandatory
146 -- target_duration_uom must be one of these values 'D','W', 'M'
147 --
148 -- Pre-conditions :
149 -- Target_duration_uom units must exist in hr-Lookups for
150 -- lookup_type = QUALIFYING_UNITS
151 --
152 -- In Arguments :
153 -- p_checklist_task_name
154 --
155 -- Post Success :
156 -- Processing continues
157 --
158 -- Post Failure :
159 -- An application error will be raised and processing is
160 -- terminated
161 --
162 -- Access Status :
163 -- Internal Row Handler Use only.
164 --
165 -- {End of Comments}
166 --
167 --
168 procedure chk_duration_uom
169 (p_target_duration in per_tasks_in_checklist.target_duration%TYPE
170 ,p_target_duration_uom in per_tasks_in_checklist.target_duration_uom%TYPE
171 ,p_task_in_checklist_id in per_tasks_in_checklist.task_in_checklist_id%TYPE
172 ,p_object_version_number in per_tasks_in_checklist.object_version_number%type
173 ,p_effective_date in date
174 );
175
176 /*
177 --
178 -- ---------------------------------------------------------------------------
179 -- |--------------------------< chk_ckl_tsk_unique >------------------------|
180 -- ---------------------------------------------------------------------------
181 --
182 -- Desciption :
183 --
184 -- Validates that CHECKLIST_ID and TASK_NAME combination not already exists
185 -- in per_tasks_in_checklist table.
186 --
187 --
188 -- Pre-conditions :
189 --
190 --
191 -- In Arguments :
192 -- p_checklist_id
193 -- p_checklist_task_name
194 --
195 -- Post Success :
196 -- Processing continues
197 --
198 -- Post Failure :
199 -- An application error will be raised and processing is
200 -- terminated
201 --
202 -- Access Status :
203 -- Internal Row Handler Use only.
204 --
205 -- {End of Comments}
206 --
207 -- ---------------------------------------------------------------------------
208 procedure chk_ckl_tsk_unique
209 (p_checklist_id in per_tasks_in_checklist.checklist_id%TYPE
210 ,p_checklist_task_name in per_tasks_in_checklist.checklist_task_name%TYPE
211 );
212 --
213
214 -- ---------------------------------------------------------------------------
215 -- |---------------------------< CHK_ELIG_PRFL_ID >--------------------------|
216 -- ---------------------------------------------------------------------------
217 --
218 -- Desciption :
219 --
220 -- Validates that ELIGIBILITY_PROFILE_ID already exists
221 -- in BEN_ELIGY_PRFL_F table.
222 --
223 --
224 -- Pre-conditions :
225 --
226 --
227 -- In Arguments :
228 -- p_checklist_task_id
229 -- p_business_group_id
230 -- p_effective_date
231 --
232 -- Post Success :
233 -- Processing continues
234 --
235 -- Post Failure :
236 -- An application error will be raised and processing is
237 -- terminated
238 --
239 -- Access Status :
240 -- Internal Row Handler Use only.
241 --
242 -- {End of Comments}
243 --
244 -- ---------------------------------------------------------------------------
245 procedure chk_elig_prfl_id
246 (p_eligibility_profile_id in per_tasks_in_checklist.eligibility_profile_id%TYPE
247 ,p_business_group_id in per_checklists.business_group_id%TYPE
248 ,p_effective_date in date
249 );
250 --
251 --
252 -- ---------------------------------------------------------------------------
253 -- |---------------------------< CHK_ELIG_OBJ_ID >--------------------------|
254 -- ---------------------------------------------------------------------------
255 --
256 -- Desciption :
257 --
258 -- Validates that eligibility_object_id already exists
259 -- in ben_elig_obj_f table.
260 --
261 --
262 -- Pre-conditions :
263 --
264 --
265 -- In Arguments :
266 -- p_elig_obj_id
267 -- p_business_group_id
268 -- p_effective_date
269 --
270 -- Post Success :
271 -- Processing continues
272 --
273 -- Post Failure :
274 -- An application error will be raised and processing is
275 -- terminated
276 --
277 -- Access Status :
278 -- Internal Row Handler Use only.
279 --
280 -- {End of Comments}
281 --
282 -- ---------------------------------------------------------------------------
283 procedure chk_elig_obj_id
284 (p_elig_obj_id in per_tasks_inchecklist.eligibility_object_id%TYPE
285 ,p_business_group_id in per_checklists.business_group_id%TYPE
286 ,p_effective_date in date
287 );
288 --
289 */
290 --
291 -- ----------------------------------------------------------------------------
292 -- |---------------------------< insert_validate >----------------------------|
293 -- ----------------------------------------------------------------------------
294 -- {Start of comments}
295 --
296 -- Description:
297 -- This procedure controls the execution of all insert business rules
298 -- validation.
299 --
300 -- Prerequisites:
301 -- This private procedure is called from ins procedure.
302 --
303 -- In Parameters:
304 -- A Pl/Sql record structure.
305 --
306 -- Post Success:
307 -- Processing continues.
308 --
309 -- Post Failure:
310 -- If a business rules fails the error will not be handled by this procedure
311 -- unless explicity coded.
312 --
313 -- Developer Implementation Notes:
314 -- For insert, your business rules should be executed from this procedure
315 -- and should ideally (unless really necessary) just be straight procedure
316 -- or function calls. Try and avoid using conditional branching logic.
317 --
318 -- Access Status:
319 -- Internal Row Handler Use Only.
320 --
321 -- {End of comments}
322 -- ----------------------------------------------------------------------------
323 Procedure insert_validate
324 (p_effective_date in date
325 ,p_rec in per_ctk_shd.g_rec_type
326 );
327 --
328 -- ----------------------------------------------------------------------------
329 -- |---------------------------< update_validate >----------------------------|
330 -- ----------------------------------------------------------------------------
331 -- {Start Of Comments}
332 --
333 -- Description:
334 -- This procedure controls the execution of all update business rules
335 -- validation.
336 --
337 -- Prerequisites:
338 -- This private procedure is called from upd procedure.
339 --
340 -- In Parameters:
341 -- A Pl/Sql record structure.
342 --
343 -- Post Success:
344 -- Processing continues.
345 --
346 -- Post Failure:
347 -- If a business rules fails the error will not be handled by this procedure
348 -- unless explicity coded.
349 --
350 -- Access Status:
351 -- Internal Row Handler Use Only.
352 --
353 -- {End Of Comments}
354 -- ----------------------------------------------------------------------------
355 Procedure update_validate
356 (p_effective_date in date
357 ,p_rec in per_ctk_shd.g_rec_type
361 -- |---------------------------< delete_validate >----------------------------|
358 );
359 --
360 -- ----------------------------------------------------------------------------
362 -- ----------------------------------------------------------------------------
363 -- {Start Of Comments}
364 --
365 -- Description:
366 -- This procedure controls the execution of all delete business rules
367 -- validation.
368 --
369 -- Prerequisites:
370 -- This private procedure is called from del procedure.
371 --
372 -- In Parameters:
373 -- A Pl/Sql record structure.
374 --
375 -- Post Success:
376 -- Processing continues.
377 --
378 -- Post Failure:
379 -- If a business rules fails the error will not be handled by this procedure
380 -- unless explicity coded.
381 --
382 -- Developer Implementation Notes:
383 -- For delete, your business rules should be executed from this procedure
384 -- and should ideally (unless really necessary) just be straight procedure
388 -- Internal Row Handler Use Only.
385 -- or function calls. Try and avoid using conditional branching logic.
386 --
387 -- Access Status:
389 --
390 -- {End Of Comments}
391 -- ----------------------------------------------------------------------------
392 Procedure delete_validate
393 (p_rec in per_ctk_shd.g_rec_type
394 );
395 --
396 end per_ctk_bus;