1 Package ghr_rei_bus as
2 /* $Header: ghreirhi.pkh 120.1.12010000.1 2008/07/28 10:38:38 appldev ship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |---------------------------< insert_validate >----------------------------|
6 -- ----------------------------------------------------------------------------
7 -- {Start Of Comments}
8 --
9 -- Description:
10 -- This procedure controls the execution of all insert business rules
11 -- validation.
12 --
13 -- Pre Conditions:
14 -- This private procedure is called from ins procedure.
15 --
16 -- In Parameters:
17 -- A Pl/Sql record structre.
18 --
19 -- Post Success:
20 -- Processing continues.
21 --
22 -- Post Failure:
23 -- If a business rules fails the error will not be handled by this procedure
24 -- unless explicity coded.
25 --
26 -- Developer Implementation Notes:
27 -- For insert, your business rules should be executed from this procedure and
28 -- should ideally (unless really necessary) just be straight procedure or
29 -- function calls. Try and avoid using conditional branching logic.
30 --
31 -- Access Status:
32 -- Internal Table Handler Use Only.
33 --
34 -- {End Of Comments}
35 -- ----------------------------------------------------------------------------
36 Procedure insert_validate(p_rec in ghr_rei_shd.g_rec_type);
37 --
38 -- ----------------------------------------------------------------------------
39 -- |---------------------------< update_validate >----------------------------|
40 -- ----------------------------------------------------------------------------
41 -- {Start Of Comments}
42 --
43 -- Description:
44 -- This procedure controls the execution of all update business rules
45 -- validation.
46 --
47 -- Pre Conditions:
48 -- This private procedure is called from upd procedure.
49 --
50 -- In Parameters:
51 -- A Pl/Sql record structre.
52 --
53 -- Post Success:
54 -- Processing continues.
55 --
56 -- Post Failure:
57 -- If a business rules fails the error will not be handled by this procedure
58 -- unless explicity coded.
59 --
60 -- Developer Implementation Notes:
61 -- For update, your business rules should be executed from this procedure and
62 -- should ideally (unless really necessary) just be straight procedure or
63 -- function calls. Try and avoid using conditional branching logic.
64 --
65 -- Access Status:
66 -- Internal Table Handler Use Only.
67 --
68 -- {End Of Comments}
69 -- ----------------------------------------------------------------------------
70 Procedure update_validate(p_rec in ghr_rei_shd.g_rec_type);
71 --
72 -- ----------------------------------------------------------------------------
73 -- |---------------------------< delete_validate >----------------------------|
74 -- ----------------------------------------------------------------------------
75 -- {Start Of Comments}
76 --
77 -- Description:
78 -- This procedure controls the execution of all delete business rules
79 -- validation.
80 --
81 -- Pre Conditions:
82 -- This private procedure is called from del procedure.
83 --
84 -- In Parameters:
85 -- A Pl/Sql record structre.
86 --
87 -- Post Success:
88 -- Processing continues.
89 --
90 -- Post Failure:
91 -- If a business rules fails the error will not be handled by this procedure
92 -- unless explicity coded.
93 --
94 -- Developer Implementation Notes:
95 -- For delete, your business rules should be executed from this procedure and
96 -- should ideally (unless really necessary) just be straight procedure or
97 -- function calls. Try and avoid using conditional branching logic.
98 --
99 -- Access Status:
100 -- Internal Table Handler Use Only.
101 --
102 -- {End Of Comments}
103 -- ----------------------------------------------------------------------------
104 Procedure delete_validate(p_rec in ghr_rei_shd.g_rec_type);
105 --
106 -- -----------------------------------------------------------------------------
107 -- |-------------------------------< chk_ddf_extra_val >--------------------------------------|
108 -- -----------------------------------------------------------------------------
109 -- {Start of Comments}
110 --
111 -- Description:
112 -- This procedure controls the validation processing required for
113 -- developer descriptive flexfields by calling the relevant validation
114 -- procedures. These are called dependant on the value of the relevant
115 -- entity reference field value.
116 --
117 -- Pre Conditions:
118 -- A fully validated entity record structure.
119 --
120 -- In Arguments:
121 -- p_rec (Record structure for relevant entity).
122 --
123 -- Post Success:
124 -- Processing of the calling api continues.
125 --
126 -- Post Failure:
127 -- A failure can only occur under two circumstances:
128 -- 1) The value of reference field is not supported.
129 -- 2) If when the refence field value is null and not all
130 -- the attribute arguments are not null(i.e. attribute
131 -- arguments cannot be set without a corresponding reference
132 -- field value).
133 --
134 -- Developer Implementation Notes:
135 -- Developer defined.
136 --
137 -- Access Status:
138 -- Internal Development Use Only.
139 --
140 -- {End of Comments}
141 -- -----------------------------------------------------------------------------
142 procedure chk_ddf_extra_val
143 (p_rec in ghr_rei_shd.g_rec_type
144 );
145 --
146 -- -----------------------------------------------------------------------------------------
147 -- |--------------------------< chk_reason_for_submission >--------------------------------|
148 -- -----------------------------------------------------------------------------------------
149 -- {Start of Comments}
150 --
151 -- Description:
152 -- This procedure validates the descriptive flexfield containing the information about reason
153 -- for submission. An error message is returned if this validation fails.
154 --
155 -- Pre Conditions:
156 -- None.
157 --
158 -- In Arguments:
159 -- p_pa_request_extra_info_id
160 -- p_reason_for_submission
161 -- p_effective_date
162 -- p_object_version_number
163 --
164 -- Post Success:
165 -- Processing of the calling api continues.
166 --
167 -- Post Failure:
168 -- Processing stops and error raised.
169 --
170 -- Developer Implementation Notes:
171 -- Developer defined.
172 --
173 -- Access Status:
174 -- Internal Development Use Only.
175 --
176 -- {End of Comments}
177 -- -----------------------------------------------------------------------------
178 --
179 procedure chk_reason_for_submission
180 (p_pa_request_extra_info_id in ghr_pa_request_extra_info.pa_request_extra_info_id%TYPE
181 ,p_reason_for_submission in ghr_pa_request_extra_info.rei_information3%TYPE
182 ,p_effective_date in date
183 ,p_object_version_number in number
184 );
185
186 -- -----------------------------------------------------------------------------------------
187 -- |-----------------------------------< chk_explanation >---------------------------------|
188 -- -----------------------------------------------------------------------------------------
189 -- {Start of Comments}
190 --
191 -- Description:
192 -- This procedure validates the descriptive flexfield containing the information about
193 -- explanation. An error message is returned if this validation fails.
194 --
195 -- Pre Conditions:
196 -- None.
197 --
198 -- In Arguments:
199 -- p_reason_for_sbmission
200 -- p_pa_request_extra_info_id
201 -- p_explanation
202 -- p_object_version_number
203 --
204 -- Post Success:
205 -- Processing of the calling api continues.
206 --
207 -- Post Failure:
208 -- Processing stops and error raised.
209 --
210 -- Developer Implementation Notes:
211 -- Developer defined.
212 --
213 -- Access Status:
214 -- Internal Development Use Only.
215 --
216 -- {End of Comments}
217 -- -----------------------------------------------------------------------------
218 --
219 procedure chk_explanation
220 (p_reason_for_submission in ghr_pa_request_extra_info.rei_information3%TYPE
221 ,p_pa_request_extra_info_id in ghr_pa_request_extra_info.pa_request_extra_info_id%TYPE
222 ,p_explanation in ghr_pa_request_extra_info.rei_information4%TYPE
223 ,p_object_version_number in number
224 );
225 --
226 -- -----------------------------------------------------------------------------------------
227 -- |-----------------------------------< chk_service>--------------------------------------|
228 -- -----------------------------------------------------------------------------------------
229 -- {Start of Comments}
230 --
231 -- Description:
232 -- This procedure validates the descriptive flexfield containing the information about service.
233 -- An error message is returned if this validation fails.
234 --
235 -- Pre Conditions:
236 -- None.
237 --
238 -- In Arguments:
239 -- p_pa_request_extra_info_id
240 -- p_service
241 -- p_effective_date
242 -- p_object_version_number
243 --
244 -- Post Success:
245 -- Processing of the calling api continues.
246 --
247 -- Post Failure:
248 -- Processing stops and error raised.
249 --
250 -- Developer Implementation Notes:
251 -- Developer defined.
252 --
253 -- Access Status:
254 -- Internal Development Use Only.
255 --
256 -- {End of Comments}
257 -- -----------------------------------------------------------------------------
258 --
259
260 procedure chk_service
261 (p_pa_request_extra_info_id in ghr_pa_request_extra_info.pa_request_extra_info_id%TYPE
262 ,p_service in ghr_pa_request_extra_info.rei_information5%TYPE
263 ,p_effective_date in date
264 ,p_object_version_number in number
265 );
266 end ghr_rei_bus;