1 Package per_asn_bus AUTHID CURRENT_USER as
2 /* $Header: peasnrhi.pkh 120.1 2008/02/29 12:13:09 rsykam ship $ */
3 -- ----------------------------------------------------------------------------
4 -- |------------------------< Externalized chk_ procedures >------------------|
5 -- ----------------------------------------------------------------------------
6 -- ----------------------------------------------------------------------------
7 -- |------------------------< chk_assessment_type_id >------------------------|
8 -- ----------------------------------------------------------------------------
9 -- {Start of Comments}
10 -- see body
11 --
12 -- ACCESS STATUS
13 -- Internal Development Use Only
14 --
15 -- {End of Comments}
16 -- ----------------------------------------------------------------------------
17 Procedure chk_assessment_type_id
18 (p_assessment_id in per_assessments.assessment_id%TYPE
19 ,p_assessment_type_id in per_assessments.assessment_type_id%TYPE
20 ,p_assessment_date in per_assessments.assessment_date%TYPE
21 ,p_business_group_id in per_assessments.business_group_id%TYPE
22 ,p_object_version_number in per_assessments.object_version_number%TYPE
23 );
24 -- ----------------------------------------------------------------------------
25 -- |------------------------< chk_assessment_date >---------------------------|
26 -- ----------------------------------------------------------------------------
27 -- {Start of Comments}
28 -- see body
29 --
30 -- ACCESS STATUS
31 -- Internal Development Use Only
32 --
33 -- {End of Comments}
34 -- ----------------------------------------------------------------------------
35 Procedure chk_assessment_date
36 (p_assessment_date in per_assessments.assessment_date%TYPE
37 ,p_assessment_id in per_assessments.assessment_id%TYPE
38 ,p_object_version_number in per_assessments.object_version_number%TYPE
39 );
40 -- ----------------------------------------------------------------------------
41 -- |------------------------< chk_person_id >---------------------------------|
42 -- ----------------------------------------------------------------------------
43 -- {Start of Comments}
44 -- see body
45 --
46 -- ACCESS STATUS
47 -- Internal Development Use Only
48 --
49 -- {End of Comments}
50 -- ----------------------------------------------------------------------------
51 Procedure chk_person_id
52 (p_assessment_id in per_assessments.assessment_id%TYPE
53 ,p_person_id in per_assessments.person_id%TYPE
54 ,p_business_group_id in per_assessments.business_group_id%TYPE
55 ,p_assessment_date in per_assessments.assessment_date%TYPE
56 ,p_object_version_number in per_assessments.object_version_number%TYPE
57 );
58 -- ----------------------------------------------------------------------------
59 -- |------------------------< chk_assessor_person_id >------------------------|
60 -- ----------------------------------------------------------------------------
61 -- {Start of Comments}
62 -- see body
63 --
64 -- ACCESS STATUS
65 -- Internal Development Use Only
66 --
67 -- {End of Comments}
68 -- ----------------------------------------------------------------------------
69 Procedure chk_assessor_person_id
70 (p_assessor_person_id in per_assessments.assessor_person_id%TYPE
71 ,p_business_group_id in per_assessments.business_group_id%TYPE
72 ,p_assessment_date in per_assessments.assessment_date%TYPE
73 ,p_assessment_id in per_assessments.assessment_id%TYPE
74 ,p_object_version_number in per_assessments.object_version_number%TYPE
75 );
76 -- ----------------------------------------------------------------------------
77 -- |------------------------< chk_group_date_id >-----------------------------|
78 -- ----------------------------------------------------------------------------
79 -- {Start of Comments}
80 -- see body
81 --
82 -- ACCESS STATUS
83 -- Internal Development Use Only
84 --
85 -- {End of Comments}
86 -- ----------------------------------------------------------------------------
87 Procedure chk_group_date_id
88 (p_group_initiator_id in per_assessments.group_initiator_id%TYPE
89 ,p_group_date in per_assessments.group_date%TYPE
90 ,p_assessment_id in per_assessments.assessment_id%TYPE
91 ,p_object_version_number in per_assessments.object_version_number%TYPE
92 );
93 -- ----------------------------------------------------------------------------
94 -- |------------------------< chk_group_initiator_id >------------------------|
95 -- ----------------------------------------------------------------------------
96 -- {Start of Comments}
97 -- see body
98 --
99 -- ACCESS STATUS
100 -- Internal Development Use Only
101 --
102 -- {End of Comments}
103 -- ----------------------------------------------------------------------------
104 Procedure chk_group_initiator_id
105 (p_group_initiator_id in per_assessments.group_initiator_id%TYPE
106 ,p_business_group_id in per_assessments.business_group_id%TYPE
107 ,p_group_date in per_assessments.group_date%TYPE
108 ,p_assessment_id in per_assessments.assessment_id%TYPE
109 ,p_object_version_number in per_assessments.object_version_number%TYPE
110 );
111 -- ----------------------------------------------------------------------------
112 -- |------------------------< chk_status >------------------------------------|
113 -- ----------------------------------------------------------------------------
114 -- {Start of Comments}
115 -- see body
116 --
117 -- ACCESS STATUS
118 -- Internal Development Use Only
119 --
120 -- {End of Comments}
121 -- ----------------------------------------------------------------------------
122 Procedure chk_status
123 (p_status in per_assessments.status%TYPE
124 ,p_effective_date in date
125 ,p_assessment_id in per_assessments.assessment_id%TYPE
126 ,p_object_version_number in per_assessments.object_version_number%TYPE
127 );
128 -- ----------------------------------------------------------------------------
129 -- |------------------------< chk_assessment_period >-------------------------|
130 -- ----------------------------------------------------------------------------
131 -- {Start of Comments}
132 -- see body
133 --
134 -- ACCESS STATUS
135 -- Internal Development Use Only
136 --
137 -- {End of Comments}
138 -- ----------------------------------------------------------------------------
139 Procedure chk_assessment_period
140 (p_assessment_period_start_date in per_assessments.assessment_period_start_date%TYPE
141 ,p_assessment_period_end_date in per_assessments.assessment_period_end_date%TYPE
142 ,p_assessment_id in per_assessments.assessment_id%TYPE
143 ,p_object_version_number in per_assessments.object_version_number%TYPE
144 );
145 -- ----------------------------------------------------------------------------
146 -- |------------------------< chk_unique_combination >------------------------|
147 -- ----------------------------------------------------------------------------
148 -- {Start of Comments}
149 -- see body
150 --
151 -- ACCESS STATUS
152 -- Internal Development Use Only
153 --
154 -- {End of Comments}
155 -- ----------------------------------------------------------------------------
156 Procedure chk_unique_combination
157 (p_assessment_id in per_assessments.assessment_id%TYPE
158 ,p_assessment_type_id in per_assessments.assessment_type_id%TYPE
159 ,p_assessment_date in per_assessments.assessment_date%TYPE
160 ,p_person_id in per_assessments.person_id%TYPE
161 ,p_assessor_person_id in per_assessments.assessor_person_id%TYPE
162 ,p_group_date in per_assessments.group_date%TYPE
163 ,p_object_version_number in per_assessments.object_version_number%TYPE
164 );
165 -- ----------------------------------------------------------------------------
166 -- |------------------------< chk_assessment_group_id >-----------------------|
167 -- ----------------------------------------------------------------------------
168 -- {Start of Comments}
169 -- see body
170 --
171 -- ACCESS STATUS
172 -- Internal Development Use Only
173 --
174 -- {End of Comments}
175 -- ----------------------------------------------------------------------------
176 Procedure chk_assessment_group_id
177 (p_assessment_group_id in per_assessments.assessment_group_id%TYPE
178 ,p_business_group_id in per_assessments.business_group_id%TYPE
179 ,p_assessment_id in per_assessments.assessment_id%TYPE
180 ,p_object_version_number in per_assessments.object_version_number%TYPE
181 );
182 -- ----------------------------------------------------------------------------
183 -- |------------------------< chk_appraisal_id >------------------------------|
184 -- ----------------------------------------------------------------------------
185 -- {Start of Comments}
186 -- see body
187 --
188 -- ACCESS STATUS
189 -- Internal Development Use Only
190 --
191 -- {End of Comments}
192 -- ----------------------------------------------------------------------------
193 Procedure chk_appraisal_id
194 (p_appraisal_id in per_assessments.assessment_group_id%TYPE
195 ,p_business_group_id in per_assessments.business_group_id%TYPE
196 ,p_assessment_id in per_assessments.assessment_id%TYPE
197 ,p_object_version_number in per_assessments.object_version_number%TYPE
198 );
199 -- ----------------------------------------------------------------------------
200 -- |---------------------------< insert_validate >----------------------------|
201 -- ----------------------------------------------------------------------------
202 -- {Start Of Comments}
203 --
204 -- Description:
205 -- This procedure controls the execution of all insert business rules
206 -- validation.
207 --
208 -- Pre Conditions:
209 -- This private procedure is called from ins procedure.
210 --
211 -- In Parameters:
212 -- A Pl/Sql record structre.
213 --
214 -- Post Success:
215 -- Processing continues.
216 --
217 -- Post Failure:
218 -- If a business rules fails the error will not be handled by this procedure
219 -- unless explicity coded.
220 --
221 -- Developer Implementation Notes:
222 -- For insert, your business rules should be executed from this procedure and
223 -- should ideally (unless really necessary) just be straight procedure or
224 -- function calls. Try and avoid using conditional branching logic.
225 --
226 -- Access Status:
227 -- Internal Table Handler Use Only.
228 --
229 -- {End Of Comments}
230 -- ----------------------------------------------------------------------------
231 Procedure insert_validate
232 (p_rec in per_asn_shd.g_rec_type
233 ,p_effective_date in date);
234 --
235 -- ----------------------------------------------------------------------------
236 -- |---------------------------< update_validate >----------------------------|
237 -- ----------------------------------------------------------------------------
238 -- {Start Of Comments}
239 --
240 -- Description:
241 -- This procedure controls the execution of all update business rules
242 -- validation.
243 --
244 -- Pre Conditions:
245 -- This private procedure is called from upd procedure.
246 --
247 -- In Parameters:
248 -- A Pl/Sql record structre.
249 --
250 -- Post Success:
251 -- Processing continues.
252 --
253 -- Post Failure:
254 -- If a business rules fails the error will not be handled by this procedure
255 -- unless explicity coded.
256 --
257 -- Developer Implementation Notes:
258 -- For update, your business rules should be executed from this procedure and
259 -- should ideally (unless really necessary) just be straight procedure or
260 -- function calls. Try and avoid using conditional branching logic.
261 --
262 -- Access Status:
263 -- Internal Table Handler Use Only.
264 --
265 -- {End Of Comments}
266 -- ----------------------------------------------------------------------------
267 Procedure update_validate
268 (p_rec in per_asn_shd.g_rec_type
269 ,p_effective_date in date);
270 --
271 -- ----------------------------------------------------------------------------
272 -- |---------------------------< delete_validate >----------------------------|
273 -- ----------------------------------------------------------------------------
274 -- {Start Of Comments}
275 --
276 -- Description:
277 -- This procedure controls the execution of all delete business rules
278 -- validation.
279 --
280 -- Pre Conditions:
281 -- This private procedure is called from del procedure.
282 --
283 -- In Parameters:
284 -- A Pl/Sql record structre.
285 --
286 -- Post Success:
287 -- Processing continues.
288 --
289 -- Post Failure:
290 -- If a business rules fails the error will not be handled by this procedure
291 -- unless explicity coded.
292 --
293 -- Developer Implementation Notes:
294 -- For delete, your business rules should be executed from this procedure and
295 -- should ideally (unless really necessary) just be straight procedure or
296 -- function calls. Try and avoid using conditional branching logic.
297 --
298 -- Access Status:
299 -- Internal Table Handler Use Only.
300 --
301 -- {End Of Comments}
302 -- ----------------------------------------------------------------------------
303 Procedure delete_validate(p_rec in per_asn_shd.g_rec_type);
304 --
305 --
306 -- ----------------------------------------------------------------------------
307 -- |-----------------------< return_legislation_code >-------------------------|
308 -- ----------------------------------------------------------------------------
309 -- {Start Of Comments}
310 --
311 -- Description:
312 -- This function gets the legislation code
313 --
314 -- Pre Conditions:
315 -- This private procedure will be called from the user hook procedures.
316 --
317 -- In Parameters:
318 -- the primary key of the table (per_assessments)
319 --
320 -- Post Success:
321 -- Processing continues.
322 --
323 -- Post Failure:
324 -- If the legislation code is not found then it errors out
325 --
326 -- Developer Implementation Notes:
327 --
328 -- Access Status:
329 -- Internal Table Handler Use Only.
330 --
331 -- {End Of Comments}
332 --
333 Function return_legislation_code (
334 p_assessment_id in number)
335 return varchar2;
336 --
337 --
338 end per_asn_bus;