[Home] [Help]
PACKAGE: APPS.PER_IN_ORG_INFO_LEG_HOOK
Source
1 PACKAGE per_in_org_info_leg_hook AUTHID CURRENT_USER AS
2 /* $Header: peinlhoi.pkh 120.4 2008/04/22 08:09:05 mdubasi ship $*/
3
4
5 -- Legislative Procedures related to Oranization Classification
6 --
7 --------------------------------------------------------------------------
8 -- Name : CHECK_UNIQUE_NUM_INS --
9 -- Type : Procedure --
10 -- Access : Public --
11 -- Description : Procedure is the driver procedure for the validation--
12 -- of the Organizaition Information data for the --
13 -- context IN_CONTRACTOR_INFO. --
14 -- This procedure is the hook procedure for --
15 -- for org information when org info is updated --
16 -- Parameters : --
17 -- IN : p_org_info_type_code VARCHAR2 --
18 -- p_org_information1 VARCHAR2 --
19 -- p_org_information2 VARCHAR2 --
20 -- p_org_information3 VARCHAR2 --
21 -- p_org_information4 VARCHAR2 --
22 -- p_org_information5 VARCHAR2 --
23 -- OUT : N/A --
24 -- RETURN : N/A --
25 -- Change History : --
26 --------------------------------------------------------------------------
27 -- Rev# Date Userid Description --
28 --------------------------------------------------------------------------
29 -- 1.0 16-May-2005 sukukuma created this procedure --
30 --------------------------------------------------------------------------
31 PROCEDURE check_unique_num_ins (p_org_info_type_code IN VARCHAR2
32 ,p_org_information1 IN VARCHAR2
33 ,p_org_information2 IN VARCHAR2
34 ,p_org_information3 IN VARCHAR2
35 ,p_org_information4 IN VARCHAR2
36 ,p_org_information5 IN VARCHAR2);
37
38 --------------------------------------------------------------------------
39 -- Name : CHECK_UNIQUE_NUM_UPD --
40 -- Type : Procedure --
41 -- Access : Public --
42 -- Description : Procedure is the driver procedure for the validation--
43 -- of the Organizaition Information data for the --
44 -- context IN_CONTRACTOR_INFO. --
45 -- This procedure is the hook procedure for --
46 -- for org information when org info is updated --
47 -- Parameters : --
48 -- IN : p_org_information_id NUMBER --
49 -- p_org_info_type_code VARCHAR2 --
50 -- p_org_information1 VARCHAR2 --
51 -- p_org_information2 VARCHAR2 --
52 -- p_org_information3 VARCHAR2 --
53 -- p_org_information4 VARCHAR2 --
54 -- p_org_information5 VARCHAR2 --
55 -- OUT : 3 --
56 -- RETURN : N/A --
57 -- Change History : --
58 --------------------------------------------------------------------------
59 -- Rev# Date Userid Description --
60 --------------------------------------------------------------------------
61 -- 1.0 16-May-2005 sukukuma Modified this procedure --
62 --------------------------------------------------------------------------
63
64 PROCEDURE check_unique_num_upd (p_org_information_id IN NUMBER
65 ,p_org_info_type_code IN VARCHAR2
66 ,p_org_information1 IN VARCHAR2
67 ,p_org_information2 IN VARCHAR2
68 ,p_org_information3 IN VARCHAR2
69 ,p_org_information4 IN VARCHAR2
70 ,p_org_information5 IN VARCHAR2);
71
72 ---------------------------------------------------------------------------
73 -- --
74 -- Name : check_rep_ins --
75 -- Type : Procedure --
76 -- Access : Public --
77 -- Description : Procedure is the driver procedure for the validation--
78 -- of the dates,so that they do not overlap.This also --
79 -- performs PAN Validation and uniqueness checking of --
80 -- TAN ,IF applicable.This is the hook procedure for --
81 -- organization information when representative details--
82 -- are inserted. --
83 -- Parameters : --
84 -- IN : p_org_information1 VARCHAR2 --
85 -- p_org_information2 VARCHAR2 --
86 -- p_org_information3 VARCHAR2 --
87 -- p_organization_id NUMBER --
88 -- p_org_info_type_code VARCHAR2 --
89 -- --
90 -- OUT : N/A --
91 -- RETURN : N/A --
92 -- Change History : --
93 ---------------------------------------------------------------------------
94 -- Rev# Date Userid Description --
95 ---------------------------------------------------------------------------
96 -- 1.0 16-May-2005 sukukuma Modified this procedure --
97 ---------------------------------------------------------------------------
98
99 PROCEDURE check_rep_ins(p_org_information1 IN VARCHAR2
100 ,p_org_information2 IN VARCHAR2
101 ,p_org_information3 IN VARCHAR2
102 ,p_organization_id IN NUMBER
103 ,p_org_info_type_code IN VARCHAR2);
104
105
106 --------------------------------------------------------------------------
107 -- --
108 -- Name : check_rep_upd --
109 -- Type : Procedure --
110 -- Access : Public --
111 -- Description : Procedure is the driver procedure for the validation--
112 -- of the dates,so that they do not overlap. --
113 -- This is the hook procedure for the --
114 -- organization information type when representative --
115 -- details is updated. --
116 -- Parameters : --
117 -- IN : p_org_information1 VARCHAR2 --
118 -- p_org_information2 VARCHAR2 --
119 -- p_org_information3 VARCHAR2 --
120 -- p_org_information_id NUMBER --
121 -- p_org_info_type_code VARCHAR2 --
122 -- --
123 -- OUT : N/A --
124 -- RETURN : N/A --
125 -- Change History : --
126 ---------------------------------------------------------------------------
127 -- Rev# Date Userid Description --
128 ---------------------------------------------------------------------------
129 -- 1.0 16-May-2005 sukukuma Modified this procedure --
130
131 ---------------------------------------------------------------------------
132
133 PROCEDURE check_rep_upd(p_org_information1 IN VARCHAR2
134 ,p_org_information2 IN VARCHAR2
135 ,p_org_information3 IN VARCHAR2
136 ,p_org_information_id IN NUMBER
137 ,p_org_info_type_code IN VARCHAR2);
138
139
140
141 --------------------------------------------------------------------------
142 -- Name : check_pf_challan_accounts --
143 -- Type : Procedure --
144 -- Access : Public --
145 -- Description : Dummy procedure --
146 -- Parameters : --
147 -- IN : p_org_info_type_code VARCHAR2 --
148 -- p_org_information3 VARCHAR2 --
149 -- p_org_information4 VARCHAR2 --
150 -- p_org_information5 VARCHAR2 --
151 -- p_org_information6 VARCHAR2 --
152 -- p_org_information7 VARCHAR2 --
153 -- p_org_information8 VARCHAR2 --
154 -- Change History : --
155 --------------------------------------------------------------------------
156 -- Rev# Date Userid Description --
157 --------------------------------------------------------------------------
158 -- 1.0 16-May-2005 sukukuma Modified this procedure --
159 -- 1.1 17-sep-2007 sivanara Added message parameters and --
160 -- removed fnd_message code --
161 -- 1.2 22-Apr-2008 mdubasi Removed above fix to resolve --
162 -- P1 6967621 --
163
164 --------------------------------------------------------------------------
165 PROCEDURE check_pf_challan_accounts (p_org_info_type_code IN VARCHAR2
166 ,p_org_information3 IN VARCHAR2
167 ,p_org_information4 IN VARCHAR2
168 ,p_org_information5 IN VARCHAR2
169 ,p_org_information6 IN VARCHAR2
170 ,p_org_information7 IN VARCHAR2
171 ,p_org_information8 IN VARCHAR2
172 );
173
174 --------------------------------------------------------------------------
175 -- Name : check_organization_update --
176 -- Type : Procedure --
177 -- Access : Public --
178 -- Description : Main Procedure to be called from the Org Hook --
179 -- Parameters : --
180 -- IN : p_effective_date DATE --
181 -- p_organization_id NUMBER --
182 -- p_name VARCHAR2 --
183 -- p_date_from DATE --
184 -- p_date_to DATE --
185 -- p_location_id NUMBER --
186 -- Change History : --
187 --------------------------------------------------------------------------
188 -- Rev# Date Userid Description --
189 --------------------------------------------------------------------------
190 -- 1.0 16-May-2005 sukukuma Modified this procedure --
191 --------------------------------------------------------------------------
192
193
194 PROCEDURE check_organization_update
195 (p_effective_date IN DATE,
196 p_organization_id IN NUMBER,
197 p_name IN VARCHAR2,
198 p_date_from IN DATE,
199 p_date_to IN DATE,
200 p_location_id IN NUMBER);
201
202 --------------------------------------------------------------------------
203 -- Name : check_org_class_create --
204 -- Type : Procedure --
205 -- Access : Private --
206 -- Description : Internal Proc to be called from the Org Class Hook --
207 -- Parameters : --
208 -- IN : p_effective_date DATE --
209 -- p_organization_id NUMBER --
210 -- p_org_classif_code VARCHAR2 --
211 -- Change History : --
212 --------------------------------------------------------------------------
213 -- Rev# Date Userid Description --
214 --------------------------------------------------------------------------
215 -- 1.0 16-May-2005 sukukuma Modified this procedure --
216 --------------------------------------------------------------------------
217
218 PROCEDURE check_org_class_create
219 (p_effective_date IN DATE
220 ,p_organization_id IN NUMBER
221 ,p_org_classif_code IN VARCHAR2
222 );
223
224
225 --------------------------------------------------------------------------
226 -- Name : check_org_class_internal --
227 -- Type : Procedure --
228 -- Access : Private --
229 -- Description : Internal Proc to be called from the Org Class Hook --
230 -- Parameters : --
231 -- IN : p_effective_date DATE --
232 -- : p_organization_id NUMBER --
233 -- : p_org_classif_code VARCHAR2 --
234 -- OUT : p_message_name VARCHAR2 --
235 -- : p_token_name VARCHAR2 --
236 -- : p_token_value VARCHAR2 --
237 -- --
238 -- OUT : 3 --
239 -- RETURN : N/A --
240 -- Change History : --
241 --------------------------------------------------------------------------
242 -- Rev# Date Userid Description --
243 --------------------------------------------------------------------------
244 -- 1.0 16-May-2005 sukukuma Modified this procedure --
245 --------------------------------------------------------------------------
246
247
248 PROCEDURE check_org_class_internal
249 (p_effective_date IN DATE,
250 p_organization_id IN NUMBER,
251 p_org_classif_code IN VARCHAR2,
252 p_calling_procedure IN VARCHAR2,
253 p_message_name OUT NOCOPY VARCHAR2,
254 p_token_name OUT NOCOPY pay_in_utils.char_tab_type,
255 p_token_value OUT NOCOPY pay_in_utils.char_tab_type);
256 --
257 -- Legislative Procedures related to Oranization Information
258
259
260 --------------------------------------------------------------------------
261 -- Name : check_org_info_create --
262 -- Type : Procedure --
263 -- Access : Public --
264 -- Description : Main Procedure to be called from the Org Info Hook --
265 -- Parameters : --
266 -- IN : p_effective_date IN DATE --
267 -- : p_organization_id IN NUMBER --
268 -- : p_org_info_type_code IN VARCHAR2 --
269 -- : p_org_information1 IN VARCHAR2 --
270 -- : p_org_information2 IN VARCHAR2 --
271 -- : p_org_information3 IN VARCHAR2 --
272 -- : p_org_information4 IN VARCHAR2 --
273 -- : p_org_information5 IN VARCHAR2 --
274 -- : p_org_information6 IN VARCHAR2 --
275 -- : p_org_information8 IN VARCHAR2 --
276 -- : p_org_information9 IN VARCHAR2 --
277 -- : p_org_information10 IN VARCHAR2 --
278 -- : p_org_information11 IN VARCHAR2 --
279 -- : p_org_information12 IN VARCHAR2 --
280 -- : p_org_information13 IN VARCHAR2 --
281 -- : p_org_information14 IN VARCHAR2 --
282 -- : p_org_information15 IN VARCHAR2 --
283 -- : p_org_information16 IN VARCHAR2 --
284 -- : p_org_information17 IN VARCHAR2 --
285 -- : p_org_information18 IN VARCHAR2 --
286 -- : p_org_information19 IN VARCHAR2 --
287 -- : p_org_information20 IN VARCHAR2 --
288 -- Change History : --
289 --------------------------------------------------------------------------
290 -- Rev# Date Userid Description --
291 --------------------------------------------------------------------------
292 -- 1.0 16-May-2005 sukukuma Modified this procedure --
293 --------------------------------------------------------------------------
294
295 PROCEDURE check_org_info_create
296 (p_effective_date IN DATE,
297 p_organization_id IN NUMBER,
298 p_org_info_type_code IN VARCHAR2,
299 p_org_information1 IN VARCHAR2,
300 p_org_information2 IN VARCHAR2,
301 p_org_information3 IN VARCHAR2,
302 p_org_information4 IN VARCHAR2,
303 p_org_information5 IN VARCHAR2,
304 p_org_information6 IN VARCHAR2,
305 p_org_information7 IN VARCHAR2,
306 p_org_information8 IN VARCHAR2,
307 p_org_information9 IN VARCHAR2,
308 p_org_information10 IN VARCHAR2,
309 p_org_information11 IN VARCHAR2,
310 p_org_information12 IN VARCHAR2,
311 p_org_information13 IN VARCHAR2,
312 p_org_information14 IN VARCHAR2,
313 p_org_information15 IN VARCHAR2,
314 p_org_information16 IN VARCHAR2,
315 p_org_information17 IN VARCHAR2,
316 p_org_information18 IN VARCHAR2,
317 p_org_information19 IN VARCHAR2,
318 p_org_information20 IN VARCHAR2);
319
320
321
322 --------------------------------------------------------------------------
323 -- Name : check_org_info_update --
324 -- Type : Procedure --
325 -- Access : Public --
326 -- Description : Main Procedure to be called from the Org Info Hook --
327 -- Parameters : --
328 -- IN : p_effective_date IN DATE --
329 -- : p_org_information_id IN NUMBER --
330 -- : p_org_info_type_code IN VARCHAR2 --
331 -- : p_org_information1 IN VARCHAR2 --
332 -- : p_org_information2 IN VARCHAR2 --
333 -- : p_org_information3 IN VARCHAR2 --
334 -- : p_org_information4 IN VARCHAR2 --
335 -- : p_org_information5 IN VARCHAR2 --
336 -- : p_org_information6 IN VARCHAR2 --
337 -- : p_org_information8 IN VARCHAR2 --
338 -- : p_org_information9 IN VARCHAR2 --
339 -- : p_org_information10 IN VARCHAR2 --
340 -- : p_org_information11 IN VARCHAR2 --
341 -- : p_org_information12 IN VARCHAR2 --
342 -- : p_org_information13 IN VARCHAR2 --
343 -- : p_org_information14 IN VARCHAR2 --
344 -- : p_org_information15 IN VARCHAR2 --
345 -- : p_org_information16 IN VARCHAR2 --
346 -- : p_org_information17 IN VARCHAR2 --
347 -- : p_org_information18 IN VARCHAR2 --
348 -- : p_org_information19 IN VARCHAR2 --
349 -- : p_org_information20 IN VARCHAR2 --
350 -- Change History : --
351 --------------------------------------------------------------------------
352 -- Rev# Date Userid Description --
353 --------------------------------------------------------------------------
354 -- 1.0 16-May-2005 sukukuma Modified this procedure --
355 --------------------------------------------------------------------------
356
357
358 PROCEDURE check_org_info_update
359 (p_effective_date IN DATE,
360 p_org_information_id IN NUMBER,
361 p_org_info_type_code IN VARCHAR2,
362 p_org_information1 IN VARCHAR2,
363 p_org_information2 IN VARCHAR2,
364 p_org_information3 IN VARCHAR2,
365 p_org_information4 IN VARCHAR2,
366 p_org_information5 IN VARCHAR2,
367 p_org_information6 IN VARCHAR2,
368 p_org_information7 IN VARCHAR2,
369 p_org_information8 IN VARCHAR2,
370 p_org_information9 IN VARCHAR2,
371 p_org_information10 IN VARCHAR2,
372 p_org_information11 IN VARCHAR2,
373 p_org_information12 IN VARCHAR2,
374 p_org_information13 IN VARCHAR2,
375 p_org_information14 IN VARCHAR2,
376 p_org_information15 IN VARCHAR2,
377 p_org_information16 IN VARCHAR2,
378 p_org_information17 IN VARCHAR2,
379 p_org_information18 IN VARCHAR2,
380 p_org_information19 IN VARCHAR2,
381 p_org_information20 IN VARCHAR2);
382
383 END per_in_org_info_leg_hook;