eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_RECRUITMENT_ACTIVITY_SWI dependencies on HR_API

Line 12: (p_validate in number default hr_api.g_false_num

8: -- ----------------------------------------------------------------------------
9: -- |----------------------< create_recruitment_activity >---------------------|
10: -- ----------------------------------------------------------------------------
11: PROCEDURE create_recruitment_activity
12: (p_validate in number default hr_api.g_false_num
13: ,p_business_group_id in number
14: ,p_date_start in date
15: ,p_name in varchar2
16: ,p_authorising_person_id in number default null

Line 85: hr_api.constant_to_boolean

81: --
82: -- Convert constant values to their corresponding boolean value
83: --
84: l_validate :=
85: hr_api.constant_to_boolean
86: (p_constant_value => p_validate);
87: --
88: -- Register Surrogate ID or user key values
89: --

Line 196: (p_validate in number default hr_api.g_false_num

192: -- ----------------------------------------------------------------------------
193: -- |----------------------< delete_recruitment_activity >---------------------|
194: -- ----------------------------------------------------------------------------
195: PROCEDURE delete_recruitment_activity
196: (p_validate in number default hr_api.g_false_num
197: ,p_object_version_number in number
198: ,p_recruitment_activity_id in number
199: ,p_return_status out nocopy varchar2
200: ) is

Line 226: hr_api.constant_to_boolean

222: --
223: -- Convert constant values to their corresponding boolean value
224: --
225: l_validate :=
226: hr_api.constant_to_boolean
227: (p_constant_value => p_validate);
228: --
229: -- Register Surrogate ID or user key values
230: --

Line 290: (p_validate in number default hr_api.g_false_num

286: -- ----------------------------------------------------------------------------
287: -- |----------------------< update_recruitment_activity >---------------------|
288: -- ----------------------------------------------------------------------------
289: PROCEDURE update_recruitment_activity
290: (p_validate in number default hr_api.g_false_num
291: ,p_recruitment_activity_id in number
292: ,p_authorising_person_id in number default hr_api.g_number
293: ,p_run_by_organization_id in number default hr_api.g_number
294: ,p_internal_contact_person_id in number default hr_api.g_number

Line 292: ,p_authorising_person_id in number default hr_api.g_number

288: -- ----------------------------------------------------------------------------
289: PROCEDURE update_recruitment_activity
290: (p_validate in number default hr_api.g_false_num
291: ,p_recruitment_activity_id in number
292: ,p_authorising_person_id in number default hr_api.g_number
293: ,p_run_by_organization_id in number default hr_api.g_number
294: ,p_internal_contact_person_id in number default hr_api.g_number
295: ,p_parent_recruitment_activity in number default hr_api.g_number
296: ,p_currency_code in varchar2 default hr_api.g_varchar2

Line 293: ,p_run_by_organization_id in number default hr_api.g_number

289: PROCEDURE update_recruitment_activity
290: (p_validate in number default hr_api.g_false_num
291: ,p_recruitment_activity_id in number
292: ,p_authorising_person_id in number default hr_api.g_number
293: ,p_run_by_organization_id in number default hr_api.g_number
294: ,p_internal_contact_person_id in number default hr_api.g_number
295: ,p_parent_recruitment_activity in number default hr_api.g_number
296: ,p_currency_code in varchar2 default hr_api.g_varchar2
297: ,p_date_start in date default hr_api.g_date

Line 294: ,p_internal_contact_person_id in number default hr_api.g_number

290: (p_validate in number default hr_api.g_false_num
291: ,p_recruitment_activity_id in number
292: ,p_authorising_person_id in number default hr_api.g_number
293: ,p_run_by_organization_id in number default hr_api.g_number
294: ,p_internal_contact_person_id in number default hr_api.g_number
295: ,p_parent_recruitment_activity in number default hr_api.g_number
296: ,p_currency_code in varchar2 default hr_api.g_varchar2
297: ,p_date_start in date default hr_api.g_date
298: ,p_name in varchar2 default hr_api.g_varchar2

Line 295: ,p_parent_recruitment_activity in number default hr_api.g_number

291: ,p_recruitment_activity_id in number
292: ,p_authorising_person_id in number default hr_api.g_number
293: ,p_run_by_organization_id in number default hr_api.g_number
294: ,p_internal_contact_person_id in number default hr_api.g_number
295: ,p_parent_recruitment_activity in number default hr_api.g_number
296: ,p_currency_code in varchar2 default hr_api.g_varchar2
297: ,p_date_start in date default hr_api.g_date
298: ,p_name in varchar2 default hr_api.g_varchar2
299: ,p_actual_cost in varchar2 default hr_api.g_varchar2

Line 296: ,p_currency_code in varchar2 default hr_api.g_varchar2

292: ,p_authorising_person_id in number default hr_api.g_number
293: ,p_run_by_organization_id in number default hr_api.g_number
294: ,p_internal_contact_person_id in number default hr_api.g_number
295: ,p_parent_recruitment_activity in number default hr_api.g_number
296: ,p_currency_code in varchar2 default hr_api.g_varchar2
297: ,p_date_start in date default hr_api.g_date
298: ,p_name in varchar2 default hr_api.g_varchar2
299: ,p_actual_cost in varchar2 default hr_api.g_varchar2
300: ,p_comments in clob default hr_api.g_varchar2

Line 297: ,p_date_start in date default hr_api.g_date

293: ,p_run_by_organization_id in number default hr_api.g_number
294: ,p_internal_contact_person_id in number default hr_api.g_number
295: ,p_parent_recruitment_activity in number default hr_api.g_number
296: ,p_currency_code in varchar2 default hr_api.g_varchar2
297: ,p_date_start in date default hr_api.g_date
298: ,p_name in varchar2 default hr_api.g_varchar2
299: ,p_actual_cost in varchar2 default hr_api.g_varchar2
300: ,p_comments in clob default hr_api.g_varchar2
301: ,p_contact_telephone_number in varchar2 default hr_api.g_varchar2

Line 298: ,p_name in varchar2 default hr_api.g_varchar2

294: ,p_internal_contact_person_id in number default hr_api.g_number
295: ,p_parent_recruitment_activity in number default hr_api.g_number
296: ,p_currency_code in varchar2 default hr_api.g_varchar2
297: ,p_date_start in date default hr_api.g_date
298: ,p_name in varchar2 default hr_api.g_varchar2
299: ,p_actual_cost in varchar2 default hr_api.g_varchar2
300: ,p_comments in clob default hr_api.g_varchar2
301: ,p_contact_telephone_number in varchar2 default hr_api.g_varchar2
302: ,p_date_closing in date default hr_api.g_date

Line 299: ,p_actual_cost in varchar2 default hr_api.g_varchar2

295: ,p_parent_recruitment_activity in number default hr_api.g_number
296: ,p_currency_code in varchar2 default hr_api.g_varchar2
297: ,p_date_start in date default hr_api.g_date
298: ,p_name in varchar2 default hr_api.g_varchar2
299: ,p_actual_cost in varchar2 default hr_api.g_varchar2
300: ,p_comments in clob default hr_api.g_varchar2
301: ,p_contact_telephone_number in varchar2 default hr_api.g_varchar2
302: ,p_date_closing in date default hr_api.g_date
303: ,p_date_end in date default hr_api.g_date

Line 300: ,p_comments in clob default hr_api.g_varchar2

296: ,p_currency_code in varchar2 default hr_api.g_varchar2
297: ,p_date_start in date default hr_api.g_date
298: ,p_name in varchar2 default hr_api.g_varchar2
299: ,p_actual_cost in varchar2 default hr_api.g_varchar2
300: ,p_comments in clob default hr_api.g_varchar2
301: ,p_contact_telephone_number in varchar2 default hr_api.g_varchar2
302: ,p_date_closing in date default hr_api.g_date
303: ,p_date_end in date default hr_api.g_date
304: ,p_external_contact in varchar2 default hr_api.g_varchar2

Line 301: ,p_contact_telephone_number in varchar2 default hr_api.g_varchar2

297: ,p_date_start in date default hr_api.g_date
298: ,p_name in varchar2 default hr_api.g_varchar2
299: ,p_actual_cost in varchar2 default hr_api.g_varchar2
300: ,p_comments in clob default hr_api.g_varchar2
301: ,p_contact_telephone_number in varchar2 default hr_api.g_varchar2
302: ,p_date_closing in date default hr_api.g_date
303: ,p_date_end in date default hr_api.g_date
304: ,p_external_contact in varchar2 default hr_api.g_varchar2
305: ,p_planned_cost in varchar2 default hr_api.g_varchar2

Line 302: ,p_date_closing in date default hr_api.g_date

298: ,p_name in varchar2 default hr_api.g_varchar2
299: ,p_actual_cost in varchar2 default hr_api.g_varchar2
300: ,p_comments in clob default hr_api.g_varchar2
301: ,p_contact_telephone_number in varchar2 default hr_api.g_varchar2
302: ,p_date_closing in date default hr_api.g_date
303: ,p_date_end in date default hr_api.g_date
304: ,p_external_contact in varchar2 default hr_api.g_varchar2
305: ,p_planned_cost in varchar2 default hr_api.g_varchar2
306: ,p_recruiting_site_id in number default hr_api.g_number

Line 303: ,p_date_end in date default hr_api.g_date

299: ,p_actual_cost in varchar2 default hr_api.g_varchar2
300: ,p_comments in clob default hr_api.g_varchar2
301: ,p_contact_telephone_number in varchar2 default hr_api.g_varchar2
302: ,p_date_closing in date default hr_api.g_date
303: ,p_date_end in date default hr_api.g_date
304: ,p_external_contact in varchar2 default hr_api.g_varchar2
305: ,p_planned_cost in varchar2 default hr_api.g_varchar2
306: ,p_recruiting_site_id in number default hr_api.g_number
307: ,p_recruiting_site_response in varchar2 default hr_api.g_varchar2

Line 304: ,p_external_contact in varchar2 default hr_api.g_varchar2

300: ,p_comments in clob default hr_api.g_varchar2
301: ,p_contact_telephone_number in varchar2 default hr_api.g_varchar2
302: ,p_date_closing in date default hr_api.g_date
303: ,p_date_end in date default hr_api.g_date
304: ,p_external_contact in varchar2 default hr_api.g_varchar2
305: ,p_planned_cost in varchar2 default hr_api.g_varchar2
306: ,p_recruiting_site_id in number default hr_api.g_number
307: ,p_recruiting_site_response in varchar2 default hr_api.g_varchar2
308: ,p_last_posted_date in date default hr_api.g_date

Line 305: ,p_planned_cost in varchar2 default hr_api.g_varchar2

301: ,p_contact_telephone_number in varchar2 default hr_api.g_varchar2
302: ,p_date_closing in date default hr_api.g_date
303: ,p_date_end in date default hr_api.g_date
304: ,p_external_contact in varchar2 default hr_api.g_varchar2
305: ,p_planned_cost in varchar2 default hr_api.g_varchar2
306: ,p_recruiting_site_id in number default hr_api.g_number
307: ,p_recruiting_site_response in varchar2 default hr_api.g_varchar2
308: ,p_last_posted_date in date default hr_api.g_date
309: ,p_type in varchar2 default hr_api.g_varchar2

Line 306: ,p_recruiting_site_id in number default hr_api.g_number

302: ,p_date_closing in date default hr_api.g_date
303: ,p_date_end in date default hr_api.g_date
304: ,p_external_contact in varchar2 default hr_api.g_varchar2
305: ,p_planned_cost in varchar2 default hr_api.g_varchar2
306: ,p_recruiting_site_id in number default hr_api.g_number
307: ,p_recruiting_site_response in varchar2 default hr_api.g_varchar2
308: ,p_last_posted_date in date default hr_api.g_date
309: ,p_type in varchar2 default hr_api.g_varchar2
310: ,p_attribute_category in varchar2 default hr_api.g_varchar2

Line 307: ,p_recruiting_site_response in varchar2 default hr_api.g_varchar2

303: ,p_date_end in date default hr_api.g_date
304: ,p_external_contact in varchar2 default hr_api.g_varchar2
305: ,p_planned_cost in varchar2 default hr_api.g_varchar2
306: ,p_recruiting_site_id in number default hr_api.g_number
307: ,p_recruiting_site_response in varchar2 default hr_api.g_varchar2
308: ,p_last_posted_date in date default hr_api.g_date
309: ,p_type in varchar2 default hr_api.g_varchar2
310: ,p_attribute_category in varchar2 default hr_api.g_varchar2
311: ,p_attribute1 in varchar2 default hr_api.g_varchar2

Line 308: ,p_last_posted_date in date default hr_api.g_date

304: ,p_external_contact in varchar2 default hr_api.g_varchar2
305: ,p_planned_cost in varchar2 default hr_api.g_varchar2
306: ,p_recruiting_site_id in number default hr_api.g_number
307: ,p_recruiting_site_response in varchar2 default hr_api.g_varchar2
308: ,p_last_posted_date in date default hr_api.g_date
309: ,p_type in varchar2 default hr_api.g_varchar2
310: ,p_attribute_category in varchar2 default hr_api.g_varchar2
311: ,p_attribute1 in varchar2 default hr_api.g_varchar2
312: ,p_attribute2 in varchar2 default hr_api.g_varchar2

Line 309: ,p_type in varchar2 default hr_api.g_varchar2

305: ,p_planned_cost in varchar2 default hr_api.g_varchar2
306: ,p_recruiting_site_id in number default hr_api.g_number
307: ,p_recruiting_site_response in varchar2 default hr_api.g_varchar2
308: ,p_last_posted_date in date default hr_api.g_date
309: ,p_type in varchar2 default hr_api.g_varchar2
310: ,p_attribute_category in varchar2 default hr_api.g_varchar2
311: ,p_attribute1 in varchar2 default hr_api.g_varchar2
312: ,p_attribute2 in varchar2 default hr_api.g_varchar2
313: ,p_attribute3 in varchar2 default hr_api.g_varchar2

Line 310: ,p_attribute_category in varchar2 default hr_api.g_varchar2

306: ,p_recruiting_site_id in number default hr_api.g_number
307: ,p_recruiting_site_response in varchar2 default hr_api.g_varchar2
308: ,p_last_posted_date in date default hr_api.g_date
309: ,p_type in varchar2 default hr_api.g_varchar2
310: ,p_attribute_category in varchar2 default hr_api.g_varchar2
311: ,p_attribute1 in varchar2 default hr_api.g_varchar2
312: ,p_attribute2 in varchar2 default hr_api.g_varchar2
313: ,p_attribute3 in varchar2 default hr_api.g_varchar2
314: ,p_attribute4 in varchar2 default hr_api.g_varchar2

Line 311: ,p_attribute1 in varchar2 default hr_api.g_varchar2

307: ,p_recruiting_site_response in varchar2 default hr_api.g_varchar2
308: ,p_last_posted_date in date default hr_api.g_date
309: ,p_type in varchar2 default hr_api.g_varchar2
310: ,p_attribute_category in varchar2 default hr_api.g_varchar2
311: ,p_attribute1 in varchar2 default hr_api.g_varchar2
312: ,p_attribute2 in varchar2 default hr_api.g_varchar2
313: ,p_attribute3 in varchar2 default hr_api.g_varchar2
314: ,p_attribute4 in varchar2 default hr_api.g_varchar2
315: ,p_attribute5 in varchar2 default hr_api.g_varchar2

Line 312: ,p_attribute2 in varchar2 default hr_api.g_varchar2

308: ,p_last_posted_date in date default hr_api.g_date
309: ,p_type in varchar2 default hr_api.g_varchar2
310: ,p_attribute_category in varchar2 default hr_api.g_varchar2
311: ,p_attribute1 in varchar2 default hr_api.g_varchar2
312: ,p_attribute2 in varchar2 default hr_api.g_varchar2
313: ,p_attribute3 in varchar2 default hr_api.g_varchar2
314: ,p_attribute4 in varchar2 default hr_api.g_varchar2
315: ,p_attribute5 in varchar2 default hr_api.g_varchar2
316: ,p_attribute6 in varchar2 default hr_api.g_varchar2

Line 313: ,p_attribute3 in varchar2 default hr_api.g_varchar2

309: ,p_type in varchar2 default hr_api.g_varchar2
310: ,p_attribute_category in varchar2 default hr_api.g_varchar2
311: ,p_attribute1 in varchar2 default hr_api.g_varchar2
312: ,p_attribute2 in varchar2 default hr_api.g_varchar2
313: ,p_attribute3 in varchar2 default hr_api.g_varchar2
314: ,p_attribute4 in varchar2 default hr_api.g_varchar2
315: ,p_attribute5 in varchar2 default hr_api.g_varchar2
316: ,p_attribute6 in varchar2 default hr_api.g_varchar2
317: ,p_attribute7 in varchar2 default hr_api.g_varchar2

Line 314: ,p_attribute4 in varchar2 default hr_api.g_varchar2

310: ,p_attribute_category in varchar2 default hr_api.g_varchar2
311: ,p_attribute1 in varchar2 default hr_api.g_varchar2
312: ,p_attribute2 in varchar2 default hr_api.g_varchar2
313: ,p_attribute3 in varchar2 default hr_api.g_varchar2
314: ,p_attribute4 in varchar2 default hr_api.g_varchar2
315: ,p_attribute5 in varchar2 default hr_api.g_varchar2
316: ,p_attribute6 in varchar2 default hr_api.g_varchar2
317: ,p_attribute7 in varchar2 default hr_api.g_varchar2
318: ,p_attribute8 in varchar2 default hr_api.g_varchar2

Line 315: ,p_attribute5 in varchar2 default hr_api.g_varchar2

311: ,p_attribute1 in varchar2 default hr_api.g_varchar2
312: ,p_attribute2 in varchar2 default hr_api.g_varchar2
313: ,p_attribute3 in varchar2 default hr_api.g_varchar2
314: ,p_attribute4 in varchar2 default hr_api.g_varchar2
315: ,p_attribute5 in varchar2 default hr_api.g_varchar2
316: ,p_attribute6 in varchar2 default hr_api.g_varchar2
317: ,p_attribute7 in varchar2 default hr_api.g_varchar2
318: ,p_attribute8 in varchar2 default hr_api.g_varchar2
319: ,p_attribute9 in varchar2 default hr_api.g_varchar2

Line 316: ,p_attribute6 in varchar2 default hr_api.g_varchar2

312: ,p_attribute2 in varchar2 default hr_api.g_varchar2
313: ,p_attribute3 in varchar2 default hr_api.g_varchar2
314: ,p_attribute4 in varchar2 default hr_api.g_varchar2
315: ,p_attribute5 in varchar2 default hr_api.g_varchar2
316: ,p_attribute6 in varchar2 default hr_api.g_varchar2
317: ,p_attribute7 in varchar2 default hr_api.g_varchar2
318: ,p_attribute8 in varchar2 default hr_api.g_varchar2
319: ,p_attribute9 in varchar2 default hr_api.g_varchar2
320: ,p_attribute10 in varchar2 default hr_api.g_varchar2

Line 317: ,p_attribute7 in varchar2 default hr_api.g_varchar2

313: ,p_attribute3 in varchar2 default hr_api.g_varchar2
314: ,p_attribute4 in varchar2 default hr_api.g_varchar2
315: ,p_attribute5 in varchar2 default hr_api.g_varchar2
316: ,p_attribute6 in varchar2 default hr_api.g_varchar2
317: ,p_attribute7 in varchar2 default hr_api.g_varchar2
318: ,p_attribute8 in varchar2 default hr_api.g_varchar2
319: ,p_attribute9 in varchar2 default hr_api.g_varchar2
320: ,p_attribute10 in varchar2 default hr_api.g_varchar2
321: ,p_attribute11 in varchar2 default hr_api.g_varchar2

Line 318: ,p_attribute8 in varchar2 default hr_api.g_varchar2

314: ,p_attribute4 in varchar2 default hr_api.g_varchar2
315: ,p_attribute5 in varchar2 default hr_api.g_varchar2
316: ,p_attribute6 in varchar2 default hr_api.g_varchar2
317: ,p_attribute7 in varchar2 default hr_api.g_varchar2
318: ,p_attribute8 in varchar2 default hr_api.g_varchar2
319: ,p_attribute9 in varchar2 default hr_api.g_varchar2
320: ,p_attribute10 in varchar2 default hr_api.g_varchar2
321: ,p_attribute11 in varchar2 default hr_api.g_varchar2
322: ,p_attribute12 in varchar2 default hr_api.g_varchar2

Line 319: ,p_attribute9 in varchar2 default hr_api.g_varchar2

315: ,p_attribute5 in varchar2 default hr_api.g_varchar2
316: ,p_attribute6 in varchar2 default hr_api.g_varchar2
317: ,p_attribute7 in varchar2 default hr_api.g_varchar2
318: ,p_attribute8 in varchar2 default hr_api.g_varchar2
319: ,p_attribute9 in varchar2 default hr_api.g_varchar2
320: ,p_attribute10 in varchar2 default hr_api.g_varchar2
321: ,p_attribute11 in varchar2 default hr_api.g_varchar2
322: ,p_attribute12 in varchar2 default hr_api.g_varchar2
323: ,p_attribute13 in varchar2 default hr_api.g_varchar2

Line 320: ,p_attribute10 in varchar2 default hr_api.g_varchar2

316: ,p_attribute6 in varchar2 default hr_api.g_varchar2
317: ,p_attribute7 in varchar2 default hr_api.g_varchar2
318: ,p_attribute8 in varchar2 default hr_api.g_varchar2
319: ,p_attribute9 in varchar2 default hr_api.g_varchar2
320: ,p_attribute10 in varchar2 default hr_api.g_varchar2
321: ,p_attribute11 in varchar2 default hr_api.g_varchar2
322: ,p_attribute12 in varchar2 default hr_api.g_varchar2
323: ,p_attribute13 in varchar2 default hr_api.g_varchar2
324: ,p_attribute14 in varchar2 default hr_api.g_varchar2

Line 321: ,p_attribute11 in varchar2 default hr_api.g_varchar2

317: ,p_attribute7 in varchar2 default hr_api.g_varchar2
318: ,p_attribute8 in varchar2 default hr_api.g_varchar2
319: ,p_attribute9 in varchar2 default hr_api.g_varchar2
320: ,p_attribute10 in varchar2 default hr_api.g_varchar2
321: ,p_attribute11 in varchar2 default hr_api.g_varchar2
322: ,p_attribute12 in varchar2 default hr_api.g_varchar2
323: ,p_attribute13 in varchar2 default hr_api.g_varchar2
324: ,p_attribute14 in varchar2 default hr_api.g_varchar2
325: ,p_attribute15 in varchar2 default hr_api.g_varchar2

Line 322: ,p_attribute12 in varchar2 default hr_api.g_varchar2

318: ,p_attribute8 in varchar2 default hr_api.g_varchar2
319: ,p_attribute9 in varchar2 default hr_api.g_varchar2
320: ,p_attribute10 in varchar2 default hr_api.g_varchar2
321: ,p_attribute11 in varchar2 default hr_api.g_varchar2
322: ,p_attribute12 in varchar2 default hr_api.g_varchar2
323: ,p_attribute13 in varchar2 default hr_api.g_varchar2
324: ,p_attribute14 in varchar2 default hr_api.g_varchar2
325: ,p_attribute15 in varchar2 default hr_api.g_varchar2
326: ,p_attribute16 in varchar2 default hr_api.g_varchar2

Line 323: ,p_attribute13 in varchar2 default hr_api.g_varchar2

319: ,p_attribute9 in varchar2 default hr_api.g_varchar2
320: ,p_attribute10 in varchar2 default hr_api.g_varchar2
321: ,p_attribute11 in varchar2 default hr_api.g_varchar2
322: ,p_attribute12 in varchar2 default hr_api.g_varchar2
323: ,p_attribute13 in varchar2 default hr_api.g_varchar2
324: ,p_attribute14 in varchar2 default hr_api.g_varchar2
325: ,p_attribute15 in varchar2 default hr_api.g_varchar2
326: ,p_attribute16 in varchar2 default hr_api.g_varchar2
327: ,p_attribute17 in varchar2 default hr_api.g_varchar2

Line 324: ,p_attribute14 in varchar2 default hr_api.g_varchar2

320: ,p_attribute10 in varchar2 default hr_api.g_varchar2
321: ,p_attribute11 in varchar2 default hr_api.g_varchar2
322: ,p_attribute12 in varchar2 default hr_api.g_varchar2
323: ,p_attribute13 in varchar2 default hr_api.g_varchar2
324: ,p_attribute14 in varchar2 default hr_api.g_varchar2
325: ,p_attribute15 in varchar2 default hr_api.g_varchar2
326: ,p_attribute16 in varchar2 default hr_api.g_varchar2
327: ,p_attribute17 in varchar2 default hr_api.g_varchar2
328: ,p_attribute18 in varchar2 default hr_api.g_varchar2

Line 325: ,p_attribute15 in varchar2 default hr_api.g_varchar2

321: ,p_attribute11 in varchar2 default hr_api.g_varchar2
322: ,p_attribute12 in varchar2 default hr_api.g_varchar2
323: ,p_attribute13 in varchar2 default hr_api.g_varchar2
324: ,p_attribute14 in varchar2 default hr_api.g_varchar2
325: ,p_attribute15 in varchar2 default hr_api.g_varchar2
326: ,p_attribute16 in varchar2 default hr_api.g_varchar2
327: ,p_attribute17 in varchar2 default hr_api.g_varchar2
328: ,p_attribute18 in varchar2 default hr_api.g_varchar2
329: ,p_attribute19 in varchar2 default hr_api.g_varchar2

Line 326: ,p_attribute16 in varchar2 default hr_api.g_varchar2

322: ,p_attribute12 in varchar2 default hr_api.g_varchar2
323: ,p_attribute13 in varchar2 default hr_api.g_varchar2
324: ,p_attribute14 in varchar2 default hr_api.g_varchar2
325: ,p_attribute15 in varchar2 default hr_api.g_varchar2
326: ,p_attribute16 in varchar2 default hr_api.g_varchar2
327: ,p_attribute17 in varchar2 default hr_api.g_varchar2
328: ,p_attribute18 in varchar2 default hr_api.g_varchar2
329: ,p_attribute19 in varchar2 default hr_api.g_varchar2
330: ,p_attribute20 in varchar2 default hr_api.g_varchar2

Line 327: ,p_attribute17 in varchar2 default hr_api.g_varchar2

323: ,p_attribute13 in varchar2 default hr_api.g_varchar2
324: ,p_attribute14 in varchar2 default hr_api.g_varchar2
325: ,p_attribute15 in varchar2 default hr_api.g_varchar2
326: ,p_attribute16 in varchar2 default hr_api.g_varchar2
327: ,p_attribute17 in varchar2 default hr_api.g_varchar2
328: ,p_attribute18 in varchar2 default hr_api.g_varchar2
329: ,p_attribute19 in varchar2 default hr_api.g_varchar2
330: ,p_attribute20 in varchar2 default hr_api.g_varchar2
331: ,p_posting_content_id in number default hr_api.g_number

Line 328: ,p_attribute18 in varchar2 default hr_api.g_varchar2

324: ,p_attribute14 in varchar2 default hr_api.g_varchar2
325: ,p_attribute15 in varchar2 default hr_api.g_varchar2
326: ,p_attribute16 in varchar2 default hr_api.g_varchar2
327: ,p_attribute17 in varchar2 default hr_api.g_varchar2
328: ,p_attribute18 in varchar2 default hr_api.g_varchar2
329: ,p_attribute19 in varchar2 default hr_api.g_varchar2
330: ,p_attribute20 in varchar2 default hr_api.g_varchar2
331: ,p_posting_content_id in number default hr_api.g_number
332: ,p_status in varchar2 default hr_api.g_varchar2

Line 329: ,p_attribute19 in varchar2 default hr_api.g_varchar2

325: ,p_attribute15 in varchar2 default hr_api.g_varchar2
326: ,p_attribute16 in varchar2 default hr_api.g_varchar2
327: ,p_attribute17 in varchar2 default hr_api.g_varchar2
328: ,p_attribute18 in varchar2 default hr_api.g_varchar2
329: ,p_attribute19 in varchar2 default hr_api.g_varchar2
330: ,p_attribute20 in varchar2 default hr_api.g_varchar2
331: ,p_posting_content_id in number default hr_api.g_number
332: ,p_status in varchar2 default hr_api.g_varchar2
333: ,p_object_version_number in out nocopy number

Line 330: ,p_attribute20 in varchar2 default hr_api.g_varchar2

326: ,p_attribute16 in varchar2 default hr_api.g_varchar2
327: ,p_attribute17 in varchar2 default hr_api.g_varchar2
328: ,p_attribute18 in varchar2 default hr_api.g_varchar2
329: ,p_attribute19 in varchar2 default hr_api.g_varchar2
330: ,p_attribute20 in varchar2 default hr_api.g_varchar2
331: ,p_posting_content_id in number default hr_api.g_number
332: ,p_status in varchar2 default hr_api.g_varchar2
333: ,p_object_version_number in out nocopy number
334: ,p_return_status out nocopy varchar2

Line 331: ,p_posting_content_id in number default hr_api.g_number

327: ,p_attribute17 in varchar2 default hr_api.g_varchar2
328: ,p_attribute18 in varchar2 default hr_api.g_varchar2
329: ,p_attribute19 in varchar2 default hr_api.g_varchar2
330: ,p_attribute20 in varchar2 default hr_api.g_varchar2
331: ,p_posting_content_id in number default hr_api.g_number
332: ,p_status in varchar2 default hr_api.g_varchar2
333: ,p_object_version_number in out nocopy number
334: ,p_return_status out nocopy varchar2
335: ) is

Line 332: ,p_status in varchar2 default hr_api.g_varchar2

328: ,p_attribute18 in varchar2 default hr_api.g_varchar2
329: ,p_attribute19 in varchar2 default hr_api.g_varchar2
330: ,p_attribute20 in varchar2 default hr_api.g_varchar2
331: ,p_posting_content_id in number default hr_api.g_number
332: ,p_status in varchar2 default hr_api.g_varchar2
333: ,p_object_version_number in out nocopy number
334: ,p_return_status out nocopy varchar2
335: ) is
336: --

Line 363: hr_api.constant_to_boolean

359: --
360: -- Convert constant values to their corresponding boolean value
361: --
362: l_validate :=
363: hr_api.constant_to_boolean
364: (p_constant_value => p_validate);
365: --
366: -- Register Surrogate ID or user key values
367: --

Line 475: ,p_validate in number default hr_api.g_false_num

471: procedure process_api
472: (
473: p_document in CLOB
474: ,p_return_status out nocopy VARCHAR2
475: ,p_validate in number default hr_api.g_false_num
476: ,p_effective_date in date default null
477: )
478: IS
479: l_postState VARCHAR2(2);

Line 639: if l_object_version_number = hr_api.g_number then

635: );
636: end loop;
637:
638: -- the following if block is a work around for SSHR bug 5353275
639: if l_object_version_number = hr_api.g_number then
640: hr_utility.set_location('OVN is NULL for delete ' || l_proc, 36);
641: open csr_rec_act_ovn(l_recruitment_activity_id);
642: fetch csr_rec_act_ovn into l_object_version_number;
643: close csr_rec_act_ovn;