[Home] [Help]
PACKAGE: APPS.GHR_PRH_BUS
Source
1 Package ghr_prh_bus AUTHID CURRENT_USER as
2 /* $Header: ghprhrhi.pkh 120.1.12020000.2 2012/07/11 09:30:41 vmididho ship $ */
3
4 -- -- ----------------------------------------------------------------------------
5 -- |---------------------------< chk_non_updateable_args >----------------------------|
6 -- ----------------------------------------------------------------------------
7 --
8 Procedure chk_non_updateable_args(p_rec in ghr_prh_shd.g_rec_type) ;
9 --
10 --
11 --
12
13 -- ---------------------------------------------------------------------------
14 -- |-----------------------< chk_pa_request_id >--------------------------|
15 -- ---------------------------------------------------------------------------
16 --
17 -- Description:
18 --
19 -- Validates that the pa_request_id exists in the ghr_pa_requests_table
20 --
21 -- Pre-conditions:
22 -- None
23 --
24 -- In Arguments:
25 -- p_pa_request_id
26 --
27 -- Post Success:
28 -- Processing continues
29 --
30 -- Post Failure:
31 -- An application error is raised and processing is terminated.
32 --
33 -- Access Status:
34 -- Internal Table Handler Use Only.
35 --
36
37 Procedure chk_pa_request_id
38 (p_pa_request_id in ghr_pa_routing_history.pa_request_id%TYPE
39 ,p_pa_routing_history_id in ghr_pa_routing_history.pa_routing_history_id%TYPE
40 ,p_object_Version_number in ghr_pa_routing_history.object_version_number%TYPE
41 );
42
43
44 --
45 -- -- ----------------------------------------------------------------------------
46 -- |---------------------------< chk_groupbox_id>----------------------------|
47 -- ----------------------------------------------------------------------------
48 --
49 -- Description:
50 -- Validates that the group_box_name exists in the table ghr_GROUPBOXES
51 -- for a specific routing_group
52 --
53 -- Pre-conditions:
54 --
55 --
56 -- In Arguments:
57 -- p_pa_routing_history_id
58 -- p_pa_request_id
59 -- p_groupbox_id
60 -- p_object_version_number
61 --
62 -- Post Success:
63 -- If the group_box_name is valid
64 -- processing continues
65 --
66 -- Post Failure:
67 -- An application error is raised and processing is terminated
68 --
69 -- Access Status:
70 -- Internal Table Handler Use Only.
71 --
72 procedure chk_groupbox_id
73 (p_pa_routing_history_id in ghr_pa_routing_history.pa_routing_history_id%TYPE
74 ,p_pa_request_id in ghr_pa_requests.pa_request_id%TYPE
75 ,p_groupbox_id in ghr_pa_routing_history.groupbox_id%TYPE
76 ,p_object_version_number in ghr_pa_routing_history.object_version_number%TYPE
77 );
78
79
80 -- ----------------------------------------------------------------------------
81 -- |---------------------------< chk_user_name>----------------------------|
82 -- ----------------------------------------------------------------------------
83
84 -- Description:
85 -- Validates that the user_name exists in the table fnd_user and
86 -- Pre-conditions:
87 --
88 --
89 -- In Arguments:
90 -- p_pa_routing_history_id
91 -- p_user_name
92 -- p_object_version_number
93 --
94 -- Post Success:
95 -- If the user_person_id is valid
96 -- processing continues
97 --
98 -- Post Failure:
99 -- An application error is raised and processing is terminated
100 --
101 -- Access Status:
102 -- Internal Table Handler Use Only.
103 --
104
105 Procedure chk_user_name
106 (p_pa_routing_history_id in ghr_pa_routing_history.pa_routing_history_id%TYPE
107 ,p_user_name in ghr_pa_routing_history.user_name%TYPE
108 ,p_groupbox_id in ghr_pa_routing_history.groupbox_id%TYPE
109 ,P_object_version_number in ghr_pa_routing_history.object_version_number%TYPE
110 );
111 --
112
113 -- ---------------------------------------------------------------------------
114 -- |-----------------------< chk_routing_list_id >--------------------------|
115 -- ---------------------------------------------------------------------------
116 --
117 -- Description:
118 -- Validates that the routing_list_id exists in the table
119 -- ghr_routing_lists
120 --
121 -- Pre-conditions:
122 -- None
123 --
124 -- In Arguments:
125 -- p_routing_list_id
126 -- p_pa_routing_history_id
127 -- p_object_version_number
128 --
129 -- Post Success:
130 -- Processing continues
131 --
132 -- Post Failure:
133 -- An application error is raised and processing is terminated.
134 --
135 -- Access Status:
136 -- Internal Table Handler Use Only.
137 --
138
139 Procedure chk_routing_list_id
140 (p_routing_list_id in ghr_pa_routing_history.routing_list_id%TYPE
141 ,p_pa_routing_history_id in ghr_pa_routing_history.pa_routing_history_id%TYPE
142 ,p_object_Version_number in ghr_pa_routing_history.object_version_number%TYPE
143 );
144
145 -- -- ----------------------------------------------------------------------------
146 -- |---------------------------< chk_rout_user_sequ_numb>----------------------------|
147 -- ----------------------------------------------------------------------------
148 --
149 -- Description:
150 -- Validates that the routing_seq_number exists in the table
151 -- 'ghr_ROUTING_LIST_NAMES for the specific routing_list
152 --
153 -- Pre-conditions:
154 --
155 --
156 -- In Arguments:
157 --
158 -- p_pa_routing_history_id
159 -- p_routing_list_id
160 -- p_routing_seq_number
161 -- p_object_version_number
162 --
163 -- Post Success:
164 -- If the routing_seq_number is valid
165 -- processing continues
166 --
167 -- Post Failure:
168 -- An application error is raised and processing is terminated
169 --
170 -- Access Status:
171 -- Internal Table Handler Use Only.
172 --
173 procedure chk_rout_user_sequ_numb
174 (p_pa_routing_history_id in ghr_pa_routing_history.pa_routing_history_id%TYPE
175 ,p_routing_list_id in ghr_pa_routing_history.routing_list_id%TYPE
176 ,p_routing_seq_number in ghr_pa_routing_history.routing_seq_number %TYPE
177 ,p_object_version_number in ghr_pa_routing_history.object_version_number%TYPE
178 );
179 --
180 --
181 -- ----------------------------------------------------------------------------
182 -- |---------------------------< insert_validate >----------------------------|
183 -- ----------------------------------------------------------------------------
184 -- {Start Of Comments}
185 --
186 -- Description:
187 -- This procedure controls the execution of all insert business rules
188 -- validation.
189 --
190 -- Pre Conditions:
191 -- This private procedure is called from ins procedure.
192 --
193 -- In Parameters:
194 -- A Pl/Sql record structre.
195 --
196 -- Post Success:
197 -- Processing continues.
198 --
199 -- Post Failure:
200 -- If a business rules fails the error will not be handled by this procedure
201 -- unless explicity coded.
202 --
203 -- Developer Implementation Notes:
204 -- For insert, your business rules should be executed from this procedure and
205 -- should ideally (unless really necessary) just be straight procedure or
206 -- function calls. Try and avoid using conditional branching logic.
207 --
208 -- Access Status:
209 -- Internal Table Handler Use Only.
210 --
211 -- {End Of Comments}
212 -- ----------------------------------------------------------------------------
213
214 Procedure insert_validate
215 (p_rec in ghr_prh_shd.g_rec_type);
216
217 --
218 -- ----------------------------------------------------------------------------
219 -- |---------------------------< update_validate >----------------------------|
220 -- ----------------------------------------------------------------------------
221 -- {Start Of Comments}
222 --
223 -- Description:
224 -- This procedure controls the execution of all update business rules
225 -- validation.
226 --
227 -- Pre Conditions:
228 -- This private procedure is called from upd procedure.
229 --
230 -- In Parameters:
231 -- A Pl/Sql record structre.
232 --
233 -- Post Success:
234 -- Processing continues.
235 --
236 -- Post Failure:
237 -- If a business rules fails the error will not be handled by this procedure
238 -- unless explicity coded.
239 --
240 -- Developer Implementation Notes:
241 -- For update, your business rules should be executed from this procedure and
242 -- should ideally (unless really necessary) just be straight procedure or
243 -- function calls. Try and avoid using conditional branching logic.
244 --
245 -- Access Status:
246 -- Internal Table Handler Use Only.
247 --
248 -- {End Of Comments}
249 -- ----------------------------------------------------------------------------
250 Procedure update_validate(p_rec in ghr_prh_shd.g_rec_type);
251 --
252 -- ----------------------------------------------------------------------------
253 -- |---------------------------< delete_validate >----------------------------|
254 -- ----------------------------------------------------------------------------
255 -- {Start Of Comments}
256 --
257 -- Description:
258 -- This procedure controls the execution of all delete business rules
259 -- validation.
260 --
261 -- Pre Conditions:
262 -- This private procedure is called from del procedure.
263 --
264 -- In Parameters:
265 -- A Pl/Sql record structre.
266 --
267 -- Post Success:
268 -- Processing continues.
269 --
270 -- Post Failure:
271 -- If a business rules fails the error will not be handled by this procedure
272 -- unless explicity coded.
273 --
274 -- Developer Implementation Notes:
275 -- For delete, your business rules should be executed from this procedure and
276 -- should ideally (unless really necessary) just be straight procedure or
277 -- function calls. Try and avoid using conditional branching logic.
278 --
279 -- Access Status:
280 -- Internal Table Handler Use Only.
281 --
282 -- {End Of Comments}
283 -- ----------------------------------------------------------------------------
284 Procedure delete_validate(p_rec in ghr_prh_shd.g_rec_type);
285 --
286 end ghr_prh_bus;