[Home] [Help]
PACKAGE: APPS.HR_PROCESS_PHONE_NUMBERS_SS
Source
1 PACKAGE hr_process_phone_numbers_ss AUTHID CURRENT_USER AS
2 /* $Header: hrphnwrs.pkh 120.0 2005/05/31 02:10:40 appldev noship $*/
3
4 gv_wf_review_region_item constant wf_item_attributes.name%type
5 := 'HR_REVIEW_REGION_ITEM';
6 g_date_format constant varchar2(10):='RRRR-MM-DD';
7
8 /*
9 ||===========================================================================
10 || PROCEDURE: create_phone
11 ||---------------------------------------------------------------------------
12 ||
13 || Description:
14 || Description:
15 || This procedure will call the actual API -
16 || hr_phone_api.create_phone()
17 ||
18 || Pre Conditions:
19 ||
20 || In Arguments:
21 || Contains entire list of parameters that are defined in the actual
22 || API. For details see pephnapi.pkb file.
23 ||
24 || out nocopy Arguments:
25 ||
26 || In out nocopy Arguments:
27 ||
28 || Post Success:
29 || Executes the API call.
30 ||
31 || Post Failure:
32 || Raises an exception
33 ||
34 || Access Status:
35 || Public.
36 ||
37 ||===========================================================================
38 */
39
40 procedure create_phone(p_date_from date
41 , p_date_to date default null
42 , p_phone_type VARCHAR2
43 , p_phone_number VARCHAR2
44 , p_parent_id NUMBER
45 , p_parent_table VARCHAR2
46 --
47 -- PB Add :
48 -- The transaction steps have to be created by the login personid.
49 -- In case of adding phones for contacts parent_is is contact_person_id.
50 -- Login person id is say employee who is adding the phones to his contact.
51 --
52 , p_login_person_id NUMBER default null
53 , p_business_group_id number default null
54 , p_attribute_category VARCHAR2 default hr_api.g_varchar2
55 , p_attribute1 VARCHAR2 default hr_api.g_varchar2
56 , p_attribute2 VARCHAR2 default hr_api.g_varchar2
57 , p_attribute3 VARCHAR2 default hr_api.g_varchar2
58 , p_attribute4 VARCHAR2 default hr_api.g_varchar2
59 , p_attribute5 VARCHAR2 default hr_api.g_varchar2
60 , p_attribute6 VARCHAR2 default hr_api.g_varchar2
61 , p_attribute7 VARCHAR2 default hr_api.g_varchar2
62 , p_attribute8 VARCHAR2 default hr_api.g_varchar2
63 , p_attribute9 VARCHAR2 default hr_api.g_varchar2
64 , p_attribute10 VARCHAR2 default hr_api.g_varchar2
65 , p_attribute11 VARCHAR2 default hr_api.g_varchar2
66 , p_attribute12 VARCHAR2 default hr_api.g_varchar2
67 , p_attribute13 VARCHAR2 default hr_api.g_varchar2
68 , p_attribute14 VARCHAR2 default hr_api.g_varchar2
69 , p_attribute15 VARCHAR2 default hr_api.g_varchar2
70 , p_attribute16 VARCHAR2 default hr_api.g_varchar2
71 , p_attribute17 VARCHAR2 default hr_api.g_varchar2
72 , p_attribute18 VARCHAR2 default hr_api.g_varchar2
73 , p_attribute19 VARCHAR2 default hr_api.g_varchar2
74 , p_attribute20 VARCHAR2 default hr_api.g_varchar2
75 , p_attribute21 VARCHAR2 default hr_api.g_varchar2
76 , p_attribute22 VARCHAR2 default hr_api.g_varchar2
77 , p_attribute23 VARCHAR2 default hr_api.g_varchar2
78 , p_attribute24 VARCHAR2 default hr_api.g_varchar2
79 , p_attribute25 VARCHAR2 default hr_api.g_varchar2
80 , p_attribute26 VARCHAR2 default hr_api.g_varchar2
81 , p_attribute27 VARCHAR2 default hr_api.g_varchar2
82 , p_attribute28 VARCHAR2 default hr_api.g_varchar2
83 , p_attribute29 VARCHAR2 default hr_api.g_varchar2
84 , p_attribute30 VARCHAR2 default hr_api.g_varchar2
85 -- StartRegistration
86 ,p_per_or_contact varchar2 default null
87 -- EndRegistration
88 , p_validate number default 0
89 , p_effective_date date
90 , p_object_version_number out nocopy NUMBER
91 , p_phone_id out nocopy NUMBER
92 , p_item_type in varchar2
93 , p_item_key in varchar2
94 , p_activity_id in number
95 , p_phone_type_meaning in varchar2
96 , p_save_mode in varchar2 default null
97 , p_error_message out nocopy varchar2
98 , p_contact_relationship_id in number default hr_api.g_number
99 );
100
101 /*
102 ||===========================================================================
103 || PROCEDURE: update_phone
104 ||---------------------------------------------------------------------------
105 ||
106 || Description:
107 || Description:
108 || This procedure will call the actual API -
109 || hr_phone_api.update_phone()
110 ||
111 || Pre Conditions:
112 ||
113 || In Arguments:
114 || Contains entire list of parameters that are defined in the actual
115 || API. For details see pephnapi.pkb file.
116 ||
117 || out nocopy Arguments:
118 ||
119 || In out nocopy Arguments:
120 ||
121 || Post Success:
122 || Executes the API call.
123 ||
124 || Post Failure:
125 || Raises an exception
126 ||
127 || Access Status:
128 || Public.
129 ||
130 ||===========================================================================
131 */
132
133 procedure update_phone(p_phone_id NUMBER
134 , p_date_from date default hr_api.g_date
135 , p_date_to date default hr_api.g_date
136 , p_phone_type VARCHAR2 default hr_api.g_varchar2
137 , p_phone_number VARCHAR2 default hr_api.g_number
138 , p_per_or_contact varchar2 default null
139 --
140 -- PB Add :
141 -- The transaction steps have to be created by the login personid.
142 -- In case of adding phones for contacts parent_is is contact_person_id.
143 -- Login person id is say employee who is adding the phones to his contact.
144 --
145 , p_login_person_id NUMBER default hr_api.g_number
146 , p_attribute_category VARCHAR2 default hr_api.g_varchar2
147 , p_attribute1 VARCHAR2 default hr_api.g_varchar2
148 , p_attribute2 VARCHAR2 default hr_api.g_varchar2
149 , p_attribute3 VARCHAR2 default hr_api.g_varchar2
150 , p_attribute4 VARCHAR2 default hr_api.g_varchar2
151 , p_attribute5 VARCHAR2 default hr_api.g_varchar2
152 , p_attribute6 VARCHAR2 default hr_api.g_varchar2
153 , p_attribute7 VARCHAR2 default hr_api.g_varchar2
154 , p_attribute8 VARCHAR2 default hr_api.g_varchar2
155 , p_attribute9 VARCHAR2 default hr_api.g_varchar2
156 , p_attribute10 VARCHAR2 default hr_api.g_varchar2
157 , p_attribute11 VARCHAR2 default hr_api.g_varchar2
158 , p_attribute12 VARCHAR2 default hr_api.g_varchar2
159 , p_attribute13 VARCHAR2 default hr_api.g_varchar2
160 , p_attribute14 VARCHAR2 default hr_api.g_varchar2
161 , p_attribute15 VARCHAR2 default hr_api.g_varchar2
162 , p_attribute16 VARCHAR2 default hr_api.g_varchar2
163 , p_attribute17 VARCHAR2 default hr_api.g_varchar2
164 , p_attribute18 VARCHAR2 default hr_api.g_varchar2
165 , p_attribute19 VARCHAR2 default hr_api.g_varchar2
166 , p_attribute20 VARCHAR2 default hr_api.g_varchar2
167 , p_attribute21 VARCHAR2 default hr_api.g_varchar2
168 , p_attribute22 VARCHAR2 default hr_api.g_varchar2
169 , p_attribute23 VARCHAR2 default hr_api.g_varchar2
170 , p_attribute24 VARCHAR2 default hr_api.g_varchar2
171 , p_attribute25 VARCHAR2 default hr_api.g_varchar2
172 , p_attribute26 VARCHAR2 default hr_api.g_varchar2
173 , p_attribute27 VARCHAR2 default hr_api.g_varchar2
174 , p_attribute28 VARCHAR2 default hr_api.g_varchar2
175 , p_attribute29 VARCHAR2 default hr_api.g_varchar2
176 , p_attribute30 VARCHAR2 default hr_api.g_varchar2
177 , p_object_version_number in out nocopy NUMBER
178 , p_validate number default 0
179 , p_effective_date date
180 , p_parent_id NUMBER
181 , p_item_type in varchar2
182 , p_item_key in varchar2
183 , p_activity_id in number
184 , p_phone_type_meaning in varchar2
185 , p_save_mode in varchar2 default null
186 , p_error_message out nocopy varchar2
187 , p_contact_relationship_id in number default hr_api.g_number
188 );
189
190 /*
191 ||===========================================================================
192 || PROCEDURE: delete_phone
193 ||---------------------------------------------------------------------------
194 ||
195 || Description:
196 || Description:
197 || This procedure will call the actual API -
198 || hr_phone_api.delete_phone()
199 ||
200 || Pre Conditions:
201 ||
202 || In Arguments:
203 || Contains entire list of parameters that are defined in the actual
204 || API. For details see pephnapi.pkb file.
205 ||
206 || out nocopy Arguments:
207 ||
208 || In out nocopy Arguments:
209 ||
210 || Post Success:
211 || Executes the API call.
212 ||
213 || Post Failure:
214 || Raises an exception
215 ||
216 || Access Status:
217 || Public.
218 ||
219 ||===========================================================================
220 */
221
222 procedure delete_phone(p_validate number default 0
223 , p_phone_id in NUMBER
224 , p_object_version_number in NUMBER
225 , p_parent_id in number
226 --
227 -- PB Add :
228 -- The transaction steps have to be created by the login personid.
229 -- In case of adding phones for contacts parent_is is contact_person_id.
230 -- Login person id is say employee who is adding the phones to his contact.
231 --
232 , p_login_person_id NUMBER default hr_api.g_number
233 , p_item_type in varchar2
234 , p_item_key in varchar2
235 , p_activity_id in number
236 , p_phone_type_meaning in varchar2
237 , p_save_mode in varchar2 default null
238 , p_error_message out nocopy varchar2
239 , p_per_or_contact varchar2 default null
240 );
241
242 /*
243 ||===========================================================================
244 || PROCEDURE: create_or_update_phone
245 ||---------------------------------------------------------------------------
246 ||
247 || Description:
248 || Description:
249 || This procedure will call the actual API -
250 || hr_phone_api.create_or_update_phone()
251 ||
252 || Pre Conditions:
253 ||
254 || In Arguments:
255 || Contains entire list of parameters that are defined in the actual
256 || API. For details see pephnapi.pkb file.
257 ||
258 || out nocopy Arguments:
259 ||
260 || In out nocopy Arguments:
261 ||
262 || Post Success:
263 || Executes the API call.
264 ||
265 || Post Failure:
266 || Raises an exception
267 ||
268 || Access Status:
269 || Public.
270 ||
271 ||===========================================================================
272 */
273
274 procedure create_or_update_phone(p_update_mode VARCHAR2
275 , p_phone_id in out nocopy NUMBER
276 , p_object_version_number in out nocopy NUMBER
277 , p_date_from date
278 , p_date_to date
279 , p_phone_type VARCHAR2
280 , p_phone_number VARCHAR2
281 , p_parent_id NUMBER
282 , p_parent_table VARCHAR2
283 , p_attribute_category VARCHAR2
284 , p_attribute1 VARCHAR2 default hr_api.g_varchar2
285 , p_attribute2 VARCHAR2 default hr_api.g_varchar2
286 , p_attribute3 VARCHAR2 default hr_api.g_varchar2
287 , p_attribute4 VARCHAR2 default hr_api.g_varchar2
288 , p_attribute5 VARCHAR2 default hr_api.g_varchar2
289 , p_attribute6 VARCHAR2 default hr_api.g_varchar2
290 , p_attribute7 VARCHAR2 default hr_api.g_varchar2
291 , p_attribute8 VARCHAR2 default hr_api.g_varchar2
292 , p_attribute9 VARCHAR2 default hr_api.g_varchar2
293 , p_attribute10 VARCHAR2 default hr_api.g_varchar2
294 , p_attribute11 VARCHAR2 default hr_api.g_varchar2
295 , p_attribute12 VARCHAR2 default hr_api.g_varchar2
296 , p_attribute13 VARCHAR2 default hr_api.g_varchar2
297 , p_attribute14 VARCHAR2 default hr_api.g_varchar2
298 , p_attribute15 VARCHAR2 default hr_api.g_varchar2
299 , p_attribute16 VARCHAR2 default hr_api.g_varchar2
300 , p_attribute17 VARCHAR2 default hr_api.g_varchar2
301 , p_attribute18 VARCHAR2 default hr_api.g_varchar2
302 , p_attribute19 VARCHAR2 default hr_api.g_varchar2
303 , p_attribute20 VARCHAR2 default hr_api.g_varchar2
304 , p_attribute21 VARCHAR2 default hr_api.g_varchar2
305 , p_attribute22 VARCHAR2 default hr_api.g_varchar2
306 , p_attribute23 VARCHAR2 default hr_api.g_varchar2
307 , p_attribute24 VARCHAR2 default hr_api.g_varchar2
308 , p_attribute25 VARCHAR2 default hr_api.g_varchar2
309 , p_attribute26 VARCHAR2 default hr_api.g_varchar2
310 , p_attribute27 VARCHAR2 default hr_api.g_varchar2
311 , p_attribute28 VARCHAR2 default hr_api.g_varchar2
312 , p_attribute29 VARCHAR2 default hr_api.g_varchar2
313 , p_attribute30 VARCHAR2 default hr_api.g_varchar2
314 , p_validate number
315 , p_effective_date date
316 , p_item_type in varchar2
317 , p_item_key in varchar2
318 , p_activity_id in number
319 , p_phone_type_meaning in varchar2
320 );
321
322 -- ---------------------------------------------------------------------------
323 -- ---------------------- < get_phone_data_from_tt> -------------------------
324 -- ---------------------------------------------------------------------------
325 -- Purpose: This procedure will get transaction data which are saved earlier
326 -- in the current transaction. This is invoked when a user click BACK
327 -- button to go back from the Review page to Update page to correct
328 -- typos or make further changes or vice-versa. Hence, we need to use
329 -- the item_type item_key passed in to retrieve the transaction record.
330 -- ---------------------------------------------------------------------------
331 PROCEDURE get_phone_data_from_tt
332 (p_item_type in varchar2
333 ,p_item_key in varchar2
334 ,p_activity_id in varchar2
335 ,p_trans_rec_count out nocopy number
336 ,p_person_id out nocopy number
337 ,p_phone_numbers_data out nocopy varchar2
338 );
339
340 -- ---------------------------------------------------------------------------
341 -- ---------------------- < get_phone_data_from_tt> -------------------------
342 -- ---------------------------------------------------------------------------
343 -- Purpose: This procedure will get transaction data which are pending for
344 -- approval in workflow for a transaction step id.
345 -- This is a overloaded version
346 -- ---------------------------------------------------------------------------
347 procedure get_phone_data_from_tt
348 (p_transaction_step_id in number
349 ,p_person_id out nocopy number
350 ,p_phone_data out nocopy varchar2
351 );
352
353 /*---------------------------------------------------------------------------+
354 | |
355 | Name : process_api |
356 | |
357 | Purpose : This will procedure is invoked whenever approver |
358 | approves the address change. |
359 | |
360 +-----------------------------------------------------------------------------*/
361 procedure process_api
362 (p_validate in boolean default false
363 ,p_transaction_step_id in number
364 ,p_effective_date in varchar2 default null
365 );
366
367 procedure get_transaction_details
368 (p_item_type in varchar2
369 ,p_item_key in varchar2
370 ,p_activity_id in varchar2
371 ,p_trans_rec_count out nocopy number
372 ,p_person_id out nocopy number
373 ,p_phone_numbers_details in out nocopy sshr_phone_details_tab_typ
374 );
375
376 PROCEDURE get_transaction_details
377 (p_item_type in varchar2
378 ,p_item_key in varchar2
379 ,p_activity_id in varchar2
380 ,p_trans_rec_count out nocopy number
381 ,p_person_id out nocopy number
382 ,p_con_phone_numbers_details in out nocopy sshr_con_phone_details_tab_typ
383 );
384
385
386 end hr_process_phone_numbers_ss;