[Home] [Help]
PACKAGE: APPS.IRC_PENDING_DATA_API
Source
1 Package IRC_PENDING_DATA_API AUTHID CURRENT_USER as
2 /* $Header: iripdapi.pkh 120.7 2008/02/21 14:22:51 viviswan noship $ */
3 /*#
4 * This package contains APIs for maintaining pending data
5 * @rep:scope public
6 * @rep:product irc
7 * @rep:displayname Pending Data
8 */
9 --
10 -- ----------------------------------------------------------------------------
11 -- |---------------------------< create_pending_data >------------------------|
12 -- ----------------------------------------------------------------------------
13 --
14 -- {Start Of Comments}
15 /*#
16 * This API creates new pending data record.
17 *
18 * This table stores the details of job applications that have been submitted
19 * on the high availability instance.
20 *
21 * <p><b>Licensing</b><br>
22 * This API is licensed for use with iRecruitment.
23 *
24 * <p><b>Prerequisites</b><br>
25 * None.
26 *
27 * <p><b>Post Success</b><br>
28 * The API creates a new pending data record.
29 *
30 * <p><b>Post Failure</b><br>
31 * The API does not create the pending data record and raises an error.
32 *
33 * @param p_validate If true, then validation alone will be performed and the
34 * database will remain unchanged. If false and all validation checks pass,
35 * then the database will be modified.
36 * @param p_email_address The e-mail address of the registered user.
37 * @param p_last_name The last name of the registered user.
38 * @param p_vacancy_id Identifies the vacancy for which the person has applied.
39 * @param p_first_name The first name of the registered user.
40 * @param p_user_password Password of the registered user.
41 * @param p_resume_file_name Name of the resume file.
42 * @param p_resume_description Description of the resume.
43 * @param p_resume_mime_type Resume's mime type.
44 * @param p_source_type Job posting source type.
45 * @param p_job_post_source_name Job posting source name.
46 * @param p_posting_content_id Identifies the record from IRC_POSTING_CONTENTS
47 * table.
48 * @param p_person_id Uniquely identifies the registered user.
49 * @param p_processed Processed flag for pending data.
50 * @param p_sex Gender of the registered user.
51 * @param p_date_of_birth Date of birth of the registered of user.
52 * @param p_per_information_category Obsolete parameter, do not use.
53 * @param p_per_information1 Developer descriptive flexfield segment.
54 * @param p_per_information2 Developer descriptive flexfield segment.
55 * @param p_per_information3 Developer descriptive flexfield segment.
56 * @param p_per_information4 Developer descriptive flexfield segment.
57 * @param p_per_information5 Developer descriptive flexfield segment.
58 * @param p_per_information6 Developer descriptive flexfield segment.
59 * @param p_per_information7 Developer descriptive flexfield segment.
60 * @param p_per_information8 Developer descriptive flexfield segment.
61 * @param p_per_information9 Developer descriptive flexfield segment.
62 * @param p_per_information10 Developer descriptive flexfield segment.
63 * @param p_per_information11 Developer descriptive flexfield segment.
64 * @param p_per_information12 Developer descriptive flexfield segment.
65 * @param p_per_information13 Developer descriptive flexfield segment.
66 * @param p_per_information14 Developer descriptive flexfield segment.
67 * @param p_per_information15 Developer descriptive flexfield segment.
68 * @param p_per_information16 Developer descriptive flexfield segment.
69 * @param p_per_information17 Developer descriptive flexfield segment.
70 * @param p_per_information18 Developer descriptive flexfield segment.
71 * @param p_per_information19 Developer descriptive flexfield segment.
72 * @param p_per_information20 Developer descriptive flexfield segment.
73 * @param p_per_information21 Developer descriptive flexfield segment.
74 * @param p_per_information22 Developer descriptive flexfield segment.
78 * @param p_per_information26 Developer descriptive flexfield segment.
75 * @param p_per_information23 Developer descriptive flexfield segment.
76 * @param p_per_information24 Developer descriptive flexfield segment.
77 * @param p_per_information25 Developer descriptive flexfield segment.
79 * @param p_per_information27 Developer descriptive flexfield segment.
80 * @param p_per_information28 Developer descriptive flexfield segment.
81 * @param p_per_information29 Developer descriptive flexfield segment.
82 * @param p_per_information30 Developer descriptive flexfield segment.
83 * @param p_error_message Stores error messages encountered while
84 * processing the pending data.
85 * @param p_creation_date Creation date of the job application.
86 * @param p_last_update_date Last updated date.
87 * @param p_allow_access Indicates if the user wants their account to be
88 * searchable by recruiters. Indicates whether the user's information is
89 * available when recruiters search for candidates.
90 * @param p_user_guid Unique identifier of the user.
91 * @param p_visitor_resp_key Identifies the responsibilitykey assigned to
92 * the site visitor.
93 * @param p_visitor_resp_appl_id Identifies the responsibility application
94 * assigned to the site visitor.
95 * @param p_security_group_key Identifies the security group key that the
96 * applicant belong to Security Group Key.
97 * @param p_pending_data_id Primary key of the pending data record.
98 * @rep:displayname Create Pending Data.
99 * @rep:category BUSINESS_ENTITY IRC_RECRUITMENT_CANDIDATE
100 * @rep:category BUSINESS_ENTITY FND_USER
101 * @rep:category BUSINESS_ENTITY PER_APPLICANT_ASG
102 * @rep:lifecycle active
103 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
104 * @rep:scope public
105 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
106 */
107 --
108 -- {End Of Comments}
109 --
110 procedure CREATE_PENDING_DATA
111 (p_validate in boolean default false
112 ,p_email_address in varchar2
113 ,p_last_name in varchar2
114 ,p_vacancy_id in number default null
115 ,p_first_name in varchar2 default null
116 ,p_user_password in varchar2 default null
117 ,p_resume_file_name in varchar2 default null
118 ,p_resume_description in varchar2 default null
119 ,p_resume_mime_type in varchar2 default null
120 ,p_source_type in varchar2 default null
121 ,p_job_post_source_name in varchar2 default null
122 ,p_posting_content_id in number default null
123 ,p_person_id in number default null
124 ,p_processed in varchar2 default null
125 ,p_sex in varchar2 default null
126 ,p_date_of_birth in date default null
127 ,p_per_information_category in varchar2 default null
128 ,p_per_information1 in varchar2 default null
129 ,p_per_information2 in varchar2 default null
130 ,p_per_information3 in varchar2 default null
131 ,p_per_information4 in varchar2 default null
132 ,p_per_information5 in varchar2 default null
133 ,p_per_information6 in varchar2 default null
134 ,p_per_information7 in varchar2 default null
135 ,p_per_information8 in varchar2 default null
136 ,p_per_information9 in varchar2 default null
137 ,p_per_information10 in varchar2 default null
138 ,p_per_information11 in varchar2 default null
139 ,p_per_information12 in varchar2 default null
140 ,p_per_information13 in varchar2 default null
141 ,p_per_information14 in varchar2 default null
142 ,p_per_information15 in varchar2 default null
143 ,p_per_information16 in varchar2 default null
144 ,p_per_information17 in varchar2 default null
145 ,p_per_information18 in varchar2 default null
146 ,p_per_information19 in varchar2 default null
147 ,p_per_information20 in varchar2 default null
148 ,p_per_information21 in varchar2 default null
149 ,p_per_information22 in varchar2 default null
150 ,p_per_information23 in varchar2 default null
151 ,p_per_information24 in varchar2 default null
152 ,p_per_information25 in varchar2 default null
153 ,p_per_information26 in varchar2 default null
154 ,p_per_information27 in varchar2 default null
155 ,p_per_information28 in varchar2 default null
156 ,p_per_information29 in varchar2 default null
157 ,p_per_information30 in varchar2 default null
158 ,p_error_message in varchar2 default null
159 ,p_creation_date in date
160 ,p_last_update_date in date
161 ,p_allow_access in varchar2 default null
162 ,p_user_guid in raw default null
163 ,p_visitor_resp_key in varchar2 default null
164 ,p_visitor_resp_appl_id in number default null
165 ,p_security_group_key in varchar2 default null
166 ,p_pending_data_id out nocopy number
167 );
168 --
169 -- ----------------------------------------------------------------------------
170 -- |---------------------------< update_pending_data >------------------------|
171 -- ----------------------------------------------------------------------------
172 --
173 -- {Start Of Comments}
174 /*#
175 * This API updates the pending data record.
176 *
177 *
178 * <p><b>Licensing</b><br>
179 * This API is licensed for use with iRecruitment.
180 *
184 * <p><b>Post Success</b><br>
181 * <p><b>Prerequisites</b><br>
182 * The pending data record must exsit.
183 *
185 * The API updates the record.
186 *
187 * <p><b>Post Failure</b><br>
188 * The API does not update the record and raises an error.
189 *
190 * @param p_validate If true, then validation alone will be performed and the
191 * database will remain unchanged. If false and all validation checks pass,
192 * then the database will be modified.
193 * @param p_pending_data_id Primary Key of the pending data record.
194 * @param p_email_address The e-mail address of the registered user.
195 * @param p_last_name The last name of the registered user.
196 * @param p_vacancy_id The vacancy that the registered user is applying for.
197 * @param p_first_name The first name of the registered user.
198 * @param p_user_password Password of the registered user.
199 * @param p_resume_file_name Name of the resume file.
200 * @param p_resume_description Description of the resume.
201 * @param p_resume_mime_type Resume's mime type.
202 * @param p_source_type Job posting source type.
203 * @param p_job_post_source_name Job posting source name.
204 * @param p_posting_content_id Identifies the posting content of the vacancy
205 * that the user is applying for.
206 * @param p_person_id Uniquely identifies the registered user.
207 * @param p_processed Processed flag of the pending data.
208 * @param p_sex Gender of the registered user.
209 * @param p_date_of_birth Date of birth of the registered of user.
210 * @param p_per_information_category Obsolete parameter, do not use.
211 * @param p_per_information1 Developer descriptive flexfield segment.
212 * @param p_per_information2 Developer descriptive flexfield segment.
213 * @param p_per_information3 Developer descriptive flexfield segment.
214 * @param p_per_information4 Developer descriptive flexfield segment.
215 * @param p_per_information5 Developer descriptive flexfield segment.
216 * @param p_per_information6 Developer descriptive flexfield segment.
217 * @param p_per_information7 Developer descriptive flexfield segment.
218 * @param p_per_information8 Developer descriptive flexfield segment.
219 * @param p_per_information9 Developer descriptive flexfield segment.
220 * @param p_per_information10 Developer descriptive flexfield segment.
221 * @param p_per_information11 Developer descriptive flexfield segment.
222 * @param p_per_information12 Developer descriptive flexfield segment.
223 * @param p_per_information13 Developer descriptive flexfield segment.
224 * @param p_per_information14 Developer descriptive flexfield segment.
225 * @param p_per_information15 Developer descriptive flexfield segment.
226 * @param p_per_information16 Developer descriptive flexfield segment.
227 * @param p_per_information17 Developer descriptive flexfield segment.
228 * @param p_per_information18 Developer descriptive flexfield segment.
229 * @param p_per_information19 Developer descriptive flexfield segment.
230 * @param p_per_information20 Developer descriptive flexfield segment.
231 * @param p_per_information21 Developer descriptive flexfield segment.
232 * @param p_per_information22 Developer descriptive flexfield segment.
233 * @param p_per_information23 Developer descriptive flexfield segment.
234 * @param p_per_information24 Developer descriptive flexfield segment.
235 * @param p_per_information25 Developer descriptive flexfield segment.
236 * @param p_per_information26 Developer descriptive flexfield segment.
237 * @param p_per_information27 Developer descriptive flexfield segment.
238 * @param p_per_information28 Developer descriptive flexfield segment.
239 * @param p_per_information29 Developer descriptive flexfield segment.
240 * @param p_per_information30 Developer descriptive flexfield segment.
241 * @param p_error_message Errors encountered.
242 * @param p_creation_date Creation date.
243 * @param p_last_update_date Last updated date.
244 * @param p_allow_access Indicates whether the user's information is available
245 * to recruiters when they search for candidates.
246 * @param p_user_guid Unique identifier for user.
247 * @param p_visitor_resp_key Identifies the responsibility key assigned to
248 * the site visitor.
249 * @param p_visitor_resp_appl_id Identifies the responsibility application
250 * assigned to the site visitor.
251 * @param p_security_group_key Security Group Key.
252 * @rep:displayname Update Pending Data
253 * @rep:category BUSINESS_ENTITY IRC_RECRUITMENT_CANDIDATE
254 * @rep:category BUSINESS_ENTITY FND_USER
255 * @rep:category BUSINESS_ENTITY PER_APPLICANT_ASG
256 * @rep:lifecycle active
257 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
258 * @rep:scope public
259 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
260 */
261 --
262 -- {End Of Comments}
263 --
264 procedure UPDATE_PENDING_DATA
265 (p_validate in boolean default false
266 ,p_pending_data_id in number
267 ,p_email_address in varchar2 default hr_api.g_varchar2
268 ,p_last_name in varchar2 default hr_api.g_varchar2
269 ,p_vacancy_id in number default hr_api.g_number
270 ,p_first_name in varchar2 default hr_api.g_varchar2
271 ,p_user_password in varchar2 default hr_api.g_varchar2
272 ,p_resume_file_name in varchar2 default hr_api.g_varchar2
273 ,p_resume_description in varchar2 default hr_api.g_varchar2
274 ,p_resume_mime_type in varchar2 default hr_api.g_varchar2
275 ,p_source_type in varchar2 default hr_api.g_varchar2
276 ,p_job_post_source_name in varchar2 default hr_api.g_varchar2
277 ,p_posting_content_id in number default hr_api.g_number
278 ,p_person_id in number default hr_api.g_number
279 ,p_processed in varchar2 default hr_api.g_varchar2
280 ,p_sex in varchar2 default hr_api.g_varchar2
281 ,p_date_of_birth in date default hr_api.g_date
285 ,p_per_information3 in varchar2 default hr_api.g_varchar2
282 ,p_per_information_category in varchar2 default hr_api.g_varchar2
283 ,p_per_information1 in varchar2 default hr_api.g_varchar2
284 ,p_per_information2 in varchar2 default hr_api.g_varchar2
286 ,p_per_information4 in varchar2 default hr_api.g_varchar2
287 ,p_per_information5 in varchar2 default hr_api.g_varchar2
288 ,p_per_information6 in varchar2 default hr_api.g_varchar2
289 ,p_per_information7 in varchar2 default hr_api.g_varchar2
290 ,p_per_information8 in varchar2 default hr_api.g_varchar2
291 ,p_per_information9 in varchar2 default hr_api.g_varchar2
292 ,p_per_information10 in varchar2 default hr_api.g_varchar2
293 ,p_per_information11 in varchar2 default hr_api.g_varchar2
294 ,p_per_information12 in varchar2 default hr_api.g_varchar2
295 ,p_per_information13 in varchar2 default hr_api.g_varchar2
296 ,p_per_information14 in varchar2 default hr_api.g_varchar2
297 ,p_per_information15 in varchar2 default hr_api.g_varchar2
298 ,p_per_information16 in varchar2 default hr_api.g_varchar2
299 ,p_per_information17 in varchar2 default hr_api.g_varchar2
300 ,p_per_information18 in varchar2 default hr_api.g_varchar2
301 ,p_per_information19 in varchar2 default hr_api.g_varchar2
302 ,p_per_information20 in varchar2 default hr_api.g_varchar2
303 ,p_per_information21 in varchar2 default hr_api.g_varchar2
304 ,p_per_information22 in varchar2 default hr_api.g_varchar2
305 ,p_per_information23 in varchar2 default hr_api.g_varchar2
306 ,p_per_information24 in varchar2 default hr_api.g_varchar2
307 ,p_per_information25 in varchar2 default hr_api.g_varchar2
308 ,p_per_information26 in varchar2 default hr_api.g_varchar2
309 ,p_per_information27 in varchar2 default hr_api.g_varchar2
310 ,p_per_information28 in varchar2 default hr_api.g_varchar2
311 ,p_per_information29 in varchar2 default hr_api.g_varchar2
312 ,p_per_information30 in varchar2 default hr_api.g_varchar2
313 ,p_error_message in varchar2 default hr_api.g_varchar2
314 ,p_creation_date in date default hr_api.g_date
315 ,p_last_update_date in date default hr_api.g_date
316 ,p_allow_access in varchar2 default hr_api.g_varchar2
317 ,p_user_guid in raw default null
318 ,p_visitor_resp_key in varchar2 default hr_api.g_varchar2
319 ,p_visitor_resp_appl_id in number default hr_api.g_number
320 ,p_security_group_key in varchar2 default hr_api.g_varchar2
321 );
322 --
323 -- ----------------------------------------------------------------------------
324 -- |---------------------------< delete_pending_data >------------------------|
325 -- ----------------------------------------------------------------------------
326 --
327 -- {Start Of Comments}
328 /*#
329 * This API deletes a pending data record.
330 *
331 *
332 * <p><b>Licensing</b><br>
333 * This API is licensed for use with iRecruitment.
334 *
335 * <p><b>Prerequisites</b><br>
336 * The pending data record must exist.
337 *
338 * <p><b>Post Success</b><br>
339 * The pending data record is deleted.
340 *
341 * <p><b>Post Failure</b><br>
342 * The pending data record is not deleted and an error is raised.
343 *
344 * @param p_validate If true, then validation alone will be performed and the
345 * database will remain unchanged. If false and all validation checks pass,
346 * then the database will be modified.
347 * @param p_pending_data_id The primary key of the pending data record.
348 * @rep:displayname Delete Pending Data
349 * @rep:category BUSINESS_ENTITY IRC_RECRUITMENT_CANDIDATE
350 * @rep:category BUSINESS_ENTITY FND_USER
351 * @rep:category BUSINESS_ENTITY PER_APPLICANT_ASG
352 * @rep:lifecycle active
353 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
354 * @rep:scope public
355 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
356 */
357 --
358 -- {End Of Comments}
359 --
360 procedure DELETE_PENDING_DATA
361 (p_validate in boolean default false
362 ,p_pending_data_id in number
363 );
364 --
365 -- ----------------------------------------------------------------------------
366 -- |---------------------------< process_applications >-----------------------|
367 -- ----------------------------------------------------------------------------
368 --
369 -- {Start Of Comments}
370 /*#
371 * This API processes pending data applications.
372 *
373 *
374 * <p><b>Licensing</b><br>
375 * This API is licensed for use with iRecruitment.
376 *
377 * <p><b>Prerequisites</b><br>
378 * None.
379 *
380 * <p><b>Post Success</b><br>
381 * Successfully processed records are deleted from the pending data table.
382 *
383 * <p><b>Post Failure</b><br>
384 * Records that are not successfully processed are updated with the processed
385 * flag set to 'E' and the error_message column is populated appropriately.
386 * @param p_server_name Name of the Node.
387 * @rep:displayname Process Applications
388 * @rep:category BUSINESS_ENTITY IRC_RECRUITMENT_CANDIDATE
389 * @rep:category BUSINESS_ENTITY FND_USER
390 * @rep:category BUSINESS_ENTITY PER_APPLICANT_ASG
391 * @rep:lifecycle active
392 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
393 * @rep:scope public
394 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
395 */
396 --
397 -- {End Of Comments}
398 --
399 procedure PROCESS_APPLICATIONS
400 (
401 p_server_name in fnd_nodes.node_name%type
402 );
403 --
404 -- ----------------------------------------------------------------------------
405 -- |----------------------------< send_notifications >------------------------|
406 -- ----------------------------------------------------------------------------
407 --
408 -- {Start Of Comments}
409 /*#
410 * This API sends notifications to the user.
411 *
412 *
413 * <p><b>Licensing</b><br>
414 * This API is licensed for use with iRecruitment.
415 *
416 * <p><b>Prerequisites</b><br>
417 * None.
418 *
419 * <p><b>Post Success</b><br>
420 * Notification is sent successfully with the appropriate comments.
421 *
422 * <p><b>Post Failure</b><br>
423 * Notifications are not sent, and an error is raised.
424 *
425 * @rep:displayname Send Notifications
426 * @rep:category BUSINESS_ENTITY IRC_RECRUITMENT_CANDIDATE
427 * @rep:category BUSINESS_ENTITY FND_USER
428 * @rep:category BUSINESS_ENTITY PER_APPLICANT_ASG
429 * @rep:lifecycle active
430 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
431 * @rep:scope public
432 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
433 */
434 --
435 -- {End Of Comments}
436 --
437 procedure SEND_NOTIFICATIONS;
438 --
439 end IRC_PENDING_DATA_API;