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