DBA Data[Home] [Help]

PACKAGE: APPS.PER_ASN_BUS

Source


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;