1 Package per_apr_bus as
2 /* $Header: peaprrhi.pkh 120.2 2007/06/20 07:45:00 rapandi ship $ */
3
4 -- ---------------------------------------------------------------------------+
5 -- |------------------------< set_security_group_id >-------------------------|
6 -- ---------------------------------------------------------------------------+
7 -- {Start Of Comments}
8
9 -- Description:
10 -- Set the security_group_id in CLIENT_INFO for the appraisals's business
11 -- group context.
12
13 -- Prerequisites:
14 -- None,
15
16 -- In Parameters:
17 -- Name Reqd Type Description
18 -- appraisal_id Yes Number appraisal_id to use for
19 -- deriving the security group
20 -- context.
21
22 -- Post Success:
23 -- The security_group_id will be set in CLIENT_INFO.
24
25 -- Post Failure:
26 -- An error is raised if the appraisal_id does not exist.
27
28 -- Access Status:
29 -- Internal Development Use Only.
30
31 -- {End Of Comments}
32
33 -- ---------------------------------------------------------------------------+
34 procedure set_security_group_id
35 (
36 p_appraisal_id in per_appraisals.appraisal_id%TYPE,
37 p_associated_column1 in varchar2 default null
38 );
39 -- ---------------------------------------------------------------------------+
40 -- |------------------------< Externalized chk_ procedures >------------------|
41 -- ---------------------------------------------------------------------------+
42 -- ---------------------------------------------------------------------------+
43 -- |------------------------< chk_appraisal_template>-------------------------|
44 -- ---------------------------------------------------------------------------+
45 -- {Start of Comments}
46 -- see body
47
48 -- ACCESS STATUS
49 -- Internal HR Development Use Only
50
51 -- {End of Comments}
52 -- ---------------------------------------------------------------------------+
53 procedure chk_appraisal_template
54 (p_appraisal_template_id in per_appraisals.appraisal_template_id%TYPE
55 ,p_business_group_id in per_appraisals.business_group_id%TYPE
56 ,p_effective_date in date
57 );
58 -- ---------------------------------------------------------------------------+
59 -- |------------------------< chk_appraisee_appraiser>------------------------|
60 -- ---------------------------------------------------------------------------+
61 -- {Start of Comments}
62 -- see body
63
64 -- ACCESS STATUS
65 -- Internal HR Development Use Only
66
67 -- {End of Comments}
68 -- ---------------------------------------------------------------------------+
69 procedure chk_appraisee_appraiser
70 (p_person_id in per_people_f.person_id%TYPE
71 ,p_business_group_id in per_appraisals.business_group_id%TYPE
72 ,p_effective_date in date
73 ,p_person_type in varchar2
74 );
75
76
77 -- ---------------------------------------------------------------------------+
78 -- |--------------------------<chk_main_appraiser_id>-------------------------+
79 -- ---------------------------------------------------------------------------+
80 -- {Start of Comments}
81 -- see body
82
83 -- ACCESS STATUS
84 -- Internal HR Development Use Only
85
86 -- {End of Comments}
87
88 procedure chk_main_appraiser_id
89 (p_main_appraiser_id in per_appraisals.main_appraiser_id%TYPE
90 ,p_business_group_id in per_appraisals.business_group_id%TYPE
91 ,p_effective_date in date
92 );
93
94
95 -- ---------------------------------------------------------------------------+
96 -- |------------------------< chk_appraisal_type >----------------------------|
97 -- ---------------------------------------------------------------------------+
98 -- {Start of Comments}
99 -- see body
100
101 -- ACCESS STATUS
102 -- Internal HR Development Use Only
103
104 -- {End of Comments}
105 -- ---------------------------------------------------------------------------+
106 procedure chk_appraisal_type
107 (p_appraisal_id in per_appraisals.appraisal_id%TYPE
108 ,p_object_version_number in per_appraisals.object_version_number%TYPE
109 ,p_type in per_appraisals.type%TYPE
110 ,p_effective_date in date
111 );
112 -- ---------------------------------------------------------------------------+
113 -- |------------------------< chk_appraisal_status >--------------------------|
114 -- ---------------------------------------------------------------------------+
115 -- {Start of Comments}
116 -- see body
117
118 -- ACCESS STATUS
119 -- Internal HR Development Use Only
120
121 -- {End of Comments}
122 -- ---------------------------------------------------------------------------+
123 procedure chk_appraisal_status
124 (p_appraisal_id in per_appraisals.appraisal_id%TYPE
125 ,p_object_version_number in per_appraisals.object_version_number%TYPE
126 ,p_status in per_appraisals.status%TYPE
127 ,p_effective_date in date
128 );
129 -- ---------------------------------------------------------------------------+
130 -- |------------------------< chk_appraisal_status >--------------------------|
131 -- ---------------------------------------------------------------------------+
132 -- {Start of Comments}
133 -- see body
134
135 -- ACCESS STATUS
136 -- Internal HR Development Use Only
137
138 -- {End of Comments}
139 -- ---------------------------------------------------------------------------+
140 procedure chk_overall_rating
141 (p_appraisal_id in per_appraisals.appraisal_id%TYPE
142 ,p_object_version_number in per_appraisals.object_version_number%TYPE
143 ,p_appraisal_template_id in per_appraisals.appraisal_template_id%TYPE
144 ,p_overall_performance_level_id in per_appraisals.overall_performance_level_id
145 %TYPE
146 ,p_business_group_id in per_appraisals.business_group_id%TYPE
147 );
148 -- ---------------------------------------------------------------------------+
149 -- |------------------------< chk_appraisal_period_dates >--------------------|
150 -- ---------------------------------------------------------------------------+
151 -- {Start of Comments}
152 -- see body
153
154 -- ACCESS STATUS
155 -- Internal HR Development Use Only
156
157 -- {End of Comments}
158 -- ---------------------------------------------------------------------------+
159 procedure chk_appraisal_period_dates
160 (p_appraisal_id in per_appraisals.appraisal_id%TYPE
161 ,p_object_version_number in per_appraisals.object_version_number%TYPE
162 ,p_appraisal_period_start_date in
163 per_appraisals.appraisal_period_start_date%TYPE
164 ,p_appraisal_period_end_date in
165 per_appraisals.appraisal_period_end_date%TYPE
166 );
167
168 -- ---------------------------------------------------------------------------+
169 -- |---------------------------< insert_validate >----------------------------|
170 -- ---------------------------------------------------------------------------+
171 -- {Start Of Comments}
172
173 -- Description:
174 -- This procedure controls the execution of all insert business rules
175 -- validation.
176
177 -- Pre Conditions:
178 -- This private procedure is called from ins procedure.
179
180 -- In Parameters:
181 -- A Pl/Sql record structre.
182
183 -- Post Success:
184 -- Processing continues.
185
186 -- Post Failure:
187 -- If a business rules fails the error will not be handled by this procedure
188 -- unless explicity coded.
189
190 -- Developer Implementation Notes:
191 -- For insert, your business rules should be executed from this procedure and
192 -- should ideally (unless really necessary) just be straight procedure or
193 -- function calls. Try and avoid using conditional branching logic.
194
195 -- Access Status:
196 -- Internal Table Handler Use Only.
197
198 -- {End Of Comments}
199 -- ---------------------------------------------------------------------------+
200 Procedure insert_validate(p_rec in per_apr_shd.g_rec_type
201 ,p_effective_date in date);
202
203 -- ---------------------------------------------------------------------------+
204 -- |---------------------------< update_validate >----------------------------|
205 -- ---------------------------------------------------------------------------+
206 -- {Start Of Comments}
207
208 -- Description:
209 -- This procedure controls the execution of all update business rules
210 -- validation.
211
212 -- Pre Conditions:
213 -- This private procedure is called from upd procedure.
214
215 -- In Parameters:
216 -- A Pl/Sql record structre.
217
218 -- Post Success:
219 -- Processing continues.
220
221 -- Post Failure:
222 -- If a business rules fails the error will not be handled by this procedure
223 -- unless explicity coded.
224
225 -- Developer Implementation Notes:
226 -- For update, your business rules should be executed from this procedure and
227 -- should ideally (unless really necessary) just be straight procedure or
228 -- function calls. Try and avoid using conditional branching logic.
229
230 -- Access Status:
231 -- Internal Table Handler Use Only.
232
233 -- {End Of Comments}
234 -- ---------------------------------------------------------------------------+
235 Procedure update_validate(p_rec in per_apr_shd.g_rec_type
236 ,p_effective_date in date);
237
238 -- ---------------------------------------------------------------------------+
239 -- |---------------------------< delete_validate >----------------------------|
240 -- ---------------------------------------------------------------------------+
241 -- {Start Of Comments}
242
243 -- Description:
244 -- This procedure controls the execution of all delete business rules
245 -- validation.
246
247 -- Pre Conditions:
248 -- This private procedure is called from del procedure.
249
250 -- In Parameters:
251 -- A Pl/Sql record structre.
252
253 -- Post Success:
254 -- Processing continues.
255
256 -- Post Failure:
257 -- If a business rules fails the error will not be handled by this procedure
258 -- unless explicity coded.
259
260 -- Developer Implementation Notes:
261 -- For delete, your business rules should be executed from this procedure and
262 -- should ideally (unless really necessary) just be straight procedure or
263 -- function calls. Try and avoid using conditional branching logic.
264
265 -- Access Status:
266 -- Internal Table Handler Use Only.
267
268 -- {End Of Comments}
269 -- ---------------------------------------------------------------------------+
270 Procedure delete_validate(p_rec in per_apr_shd.g_rec_type);
271
272 -- ---------------------------------------------------------------------------+
273 -- |-----------------------< return_legislation_code >------------------------|
274 -- ---------------------------------------------------------------------------+
275 -- {Start Of Comments}
276
277 -- Description:
278 -- This function gets the legislation code
279
280 -- Pre Conditions:
281 -- This private procedure will be called from the user hook procedures.
282
283 -- In Parameters:
284 -- the primary key of the table (per_appraisals)
285
286 -- Post Success:
287 -- Processing continues.
288
289 -- Post Failure:
290 -- If the legislation code is not found then it errors out
291
292 -- Developer Implementation Notes:
293
294 -- Access Status:
295 -- Internal Table Handler Use Only.
296
297 -- {End Of Comments}
298
299 Function return_legislation_code (
300 p_appraisal_id in number)
301 return varchar2;
302
303
304 end per_apr_bus;