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_VAC_UPD dependencies on PER_VAC_SHD

Line 55: (p_rec in out nocopy per_vac_shd.g_rec_type

51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml
55: (p_rec in out nocopy per_vac_shd.g_rec_type
56: ) is
57: --
58: l_proc varchar2(72) := g_package||'update_dml';
59: --

Line 66: per_vac_shd.g_api_dml := true; -- Set the dml status

62: --
63: -- Increment the object version
64: p_rec.object_version_number := p_rec.object_version_number + 1;
65: --
66: per_vac_shd.g_api_dml := true; -- Set the dml status
67: --
68: -- Update the per_all_vacancies Row
69: --
70: update per_all_vacancies

Line 131: per_vac_shd.g_api_dml := false; -- Unset the dml status

127: --
128: Exception
129: When hr_api.check_integrity_violated then
130: -- A check constraint has been violated
131: per_vac_shd.g_api_dml := false; -- Unset the dml status
132: per_vac_shd.constraint_error
133: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
134: When hr_api.parent_integrity_violated then
135: -- Parent integrity has been violated

Line 132: per_vac_shd.constraint_error

128: Exception
129: When hr_api.check_integrity_violated then
130: -- A check constraint has been violated
131: per_vac_shd.g_api_dml := false; -- Unset the dml status
132: per_vac_shd.constraint_error
133: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
134: When hr_api.parent_integrity_violated then
135: -- Parent integrity has been violated
136: per_vac_shd.g_api_dml := false; -- Unset the dml status

Line 136: per_vac_shd.g_api_dml := false; -- Unset the dml status

132: per_vac_shd.constraint_error
133: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
134: When hr_api.parent_integrity_violated then
135: -- Parent integrity has been violated
136: per_vac_shd.g_api_dml := false; -- Unset the dml status
137: per_vac_shd.constraint_error
138: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
139: When hr_api.unique_integrity_violated then
140: -- Unique integrity has been violated

Line 137: per_vac_shd.constraint_error

133: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
134: When hr_api.parent_integrity_violated then
135: -- Parent integrity has been violated
136: per_vac_shd.g_api_dml := false; -- Unset the dml status
137: per_vac_shd.constraint_error
138: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
139: When hr_api.unique_integrity_violated then
140: -- Unique integrity has been violated
141: per_vac_shd.g_api_dml := false; -- Unset the dml status

Line 141: per_vac_shd.g_api_dml := false; -- Unset the dml status

137: per_vac_shd.constraint_error
138: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
139: When hr_api.unique_integrity_violated then
140: -- Unique integrity has been violated
141: per_vac_shd.g_api_dml := false; -- Unset the dml status
142: per_vac_shd.constraint_error
143: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
144: When Others then
145: per_vac_shd.g_api_dml := false; -- Unset the dml status

Line 142: per_vac_shd.constraint_error

138: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
139: When hr_api.unique_integrity_violated then
140: -- Unique integrity has been violated
141: per_vac_shd.g_api_dml := false; -- Unset the dml status
142: per_vac_shd.constraint_error
143: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
144: When Others then
145: per_vac_shd.g_api_dml := false; -- Unset the dml status
146: Raise;

Line 145: per_vac_shd.g_api_dml := false; -- Unset the dml status

141: per_vac_shd.g_api_dml := false; -- Unset the dml status
142: per_vac_shd.constraint_error
143: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
144: When Others then
145: per_vac_shd.g_api_dml := false; -- Unset the dml status
146: Raise;
147: End update_dml;
148: --
149: -- ----------------------------------------------------------------------------

Line 182: (p_rec in per_vac_shd.g_rec_type

178: --
179: -- {End Of Comments}
180: -- ----------------------------------------------------------------------------
181: Procedure pre_update
182: (p_rec in per_vac_shd.g_rec_type
183: ) is
184: --
185: l_proc varchar2(72) := g_package||'pre_update';
186: --

Line 226: (p_rec in per_vac_shd.g_rec_type

222: --
223: -- {End Of Comments}
224: -- ----------------------------------------------------------------------------
225: Procedure post_update
226: (p_rec in per_vac_shd.g_rec_type
227: ,p_effective_date in date
228: ) is
229: --
230: l_proc varchar2(72) := g_package||'post_update';

Line 340: => per_vac_shd.g_old_rec.position_id

336: => p_rec.assessment_id
337: ,p_object_version_number
338: => p_rec.object_version_number
339: ,p_position_id_o
340: => per_vac_shd.g_old_rec.position_id
341: ,p_job_id_o
342: => per_vac_shd.g_old_rec.job_id
343: ,p_grade_id_o
344: => per_vac_shd.g_old_rec.grade_id

Line 342: => per_vac_shd.g_old_rec.job_id

338: => p_rec.object_version_number
339: ,p_position_id_o
340: => per_vac_shd.g_old_rec.position_id
341: ,p_job_id_o
342: => per_vac_shd.g_old_rec.job_id
343: ,p_grade_id_o
344: => per_vac_shd.g_old_rec.grade_id
345: ,p_organization_id_o
346: => per_vac_shd.g_old_rec.organization_id

Line 344: => per_vac_shd.g_old_rec.grade_id

340: => per_vac_shd.g_old_rec.position_id
341: ,p_job_id_o
342: => per_vac_shd.g_old_rec.job_id
343: ,p_grade_id_o
344: => per_vac_shd.g_old_rec.grade_id
345: ,p_organization_id_o
346: => per_vac_shd.g_old_rec.organization_id
347: ,p_requisition_id_o
348: => per_vac_shd.g_old_rec.requisition_id

Line 346: => per_vac_shd.g_old_rec.organization_id

342: => per_vac_shd.g_old_rec.job_id
343: ,p_grade_id_o
344: => per_vac_shd.g_old_rec.grade_id
345: ,p_organization_id_o
346: => per_vac_shd.g_old_rec.organization_id
347: ,p_requisition_id_o
348: => per_vac_shd.g_old_rec.requisition_id
349: ,p_people_group_id_o
350: => per_vac_shd.g_old_rec.people_group_id

Line 348: => per_vac_shd.g_old_rec.requisition_id

344: => per_vac_shd.g_old_rec.grade_id
345: ,p_organization_id_o
346: => per_vac_shd.g_old_rec.organization_id
347: ,p_requisition_id_o
348: => per_vac_shd.g_old_rec.requisition_id
349: ,p_people_group_id_o
350: => per_vac_shd.g_old_rec.people_group_id
351: ,p_location_id_o
352: => per_vac_shd.g_old_rec.location_id

Line 350: => per_vac_shd.g_old_rec.people_group_id

346: => per_vac_shd.g_old_rec.organization_id
347: ,p_requisition_id_o
348: => per_vac_shd.g_old_rec.requisition_id
349: ,p_people_group_id_o
350: => per_vac_shd.g_old_rec.people_group_id
351: ,p_location_id_o
352: => per_vac_shd.g_old_rec.location_id
353: ,p_recruiter_id_o
354: => per_vac_shd.g_old_rec.recruiter_id

Line 352: => per_vac_shd.g_old_rec.location_id

348: => per_vac_shd.g_old_rec.requisition_id
349: ,p_people_group_id_o
350: => per_vac_shd.g_old_rec.people_group_id
351: ,p_location_id_o
352: => per_vac_shd.g_old_rec.location_id
353: ,p_recruiter_id_o
354: => per_vac_shd.g_old_rec.recruiter_id
355: ,p_date_from_o
356: => per_vac_shd.g_old_rec.date_from

Line 354: => per_vac_shd.g_old_rec.recruiter_id

350: => per_vac_shd.g_old_rec.people_group_id
351: ,p_location_id_o
352: => per_vac_shd.g_old_rec.location_id
353: ,p_recruiter_id_o
354: => per_vac_shd.g_old_rec.recruiter_id
355: ,p_date_from_o
356: => per_vac_shd.g_old_rec.date_from
357: ,p_comments_o
358: => per_vac_shd.g_old_rec.comments

Line 356: => per_vac_shd.g_old_rec.date_from

352: => per_vac_shd.g_old_rec.location_id
353: ,p_recruiter_id_o
354: => per_vac_shd.g_old_rec.recruiter_id
355: ,p_date_from_o
356: => per_vac_shd.g_old_rec.date_from
357: ,p_comments_o
358: => per_vac_shd.g_old_rec.comments
359: ,p_date_to_o
360: => per_vac_shd.g_old_rec.date_to

Line 358: => per_vac_shd.g_old_rec.comments

354: => per_vac_shd.g_old_rec.recruiter_id
355: ,p_date_from_o
356: => per_vac_shd.g_old_rec.date_from
357: ,p_comments_o
358: => per_vac_shd.g_old_rec.comments
359: ,p_date_to_o
360: => per_vac_shd.g_old_rec.date_to
361: ,p_description_o
362: => per_vac_shd.g_old_rec.description

Line 360: => per_vac_shd.g_old_rec.date_to

356: => per_vac_shd.g_old_rec.date_from
357: ,p_comments_o
358: => per_vac_shd.g_old_rec.comments
359: ,p_date_to_o
360: => per_vac_shd.g_old_rec.date_to
361: ,p_description_o
362: => per_vac_shd.g_old_rec.description
363: ,p_number_of_openings_o
364: => per_vac_shd.g_old_rec.number_of_openings

Line 362: => per_vac_shd.g_old_rec.description

358: => per_vac_shd.g_old_rec.comments
359: ,p_date_to_o
360: => per_vac_shd.g_old_rec.date_to
361: ,p_description_o
362: => per_vac_shd.g_old_rec.description
363: ,p_number_of_openings_o
364: => per_vac_shd.g_old_rec.number_of_openings
365: ,p_status_o
366: => per_vac_shd.g_old_rec.status

Line 364: => per_vac_shd.g_old_rec.number_of_openings

360: => per_vac_shd.g_old_rec.date_to
361: ,p_description_o
362: => per_vac_shd.g_old_rec.description
363: ,p_number_of_openings_o
364: => per_vac_shd.g_old_rec.number_of_openings
365: ,p_status_o
366: => per_vac_shd.g_old_rec.status
367: ,p_request_id_o
368: => per_vac_shd.g_old_rec.request_id

Line 366: => per_vac_shd.g_old_rec.status

362: => per_vac_shd.g_old_rec.description
363: ,p_number_of_openings_o
364: => per_vac_shd.g_old_rec.number_of_openings
365: ,p_status_o
366: => per_vac_shd.g_old_rec.status
367: ,p_request_id_o
368: => per_vac_shd.g_old_rec.request_id
369: ,p_program_application_id_o
370: => per_vac_shd.g_old_rec.program_application_id

Line 368: => per_vac_shd.g_old_rec.request_id

364: => per_vac_shd.g_old_rec.number_of_openings
365: ,p_status_o
366: => per_vac_shd.g_old_rec.status
367: ,p_request_id_o
368: => per_vac_shd.g_old_rec.request_id
369: ,p_program_application_id_o
370: => per_vac_shd.g_old_rec.program_application_id
371: ,p_program_id_o
372: => per_vac_shd.g_old_rec.program_id

Line 370: => per_vac_shd.g_old_rec.program_application_id

366: => per_vac_shd.g_old_rec.status
367: ,p_request_id_o
368: => per_vac_shd.g_old_rec.request_id
369: ,p_program_application_id_o
370: => per_vac_shd.g_old_rec.program_application_id
371: ,p_program_id_o
372: => per_vac_shd.g_old_rec.program_id
373: ,p_program_update_date_o
374: => per_vac_shd.g_old_rec.program_update_date

Line 372: => per_vac_shd.g_old_rec.program_id

368: => per_vac_shd.g_old_rec.request_id
369: ,p_program_application_id_o
370: => per_vac_shd.g_old_rec.program_application_id
371: ,p_program_id_o
372: => per_vac_shd.g_old_rec.program_id
373: ,p_program_update_date_o
374: => per_vac_shd.g_old_rec.program_update_date
375: ,p_attribute_category_o
376: => per_vac_shd.g_old_rec.attribute_category

Line 374: => per_vac_shd.g_old_rec.program_update_date

370: => per_vac_shd.g_old_rec.program_application_id
371: ,p_program_id_o
372: => per_vac_shd.g_old_rec.program_id
373: ,p_program_update_date_o
374: => per_vac_shd.g_old_rec.program_update_date
375: ,p_attribute_category_o
376: => per_vac_shd.g_old_rec.attribute_category
377: ,p_attribute1_o
378: => per_vac_shd.g_old_rec.attribute1

Line 376: => per_vac_shd.g_old_rec.attribute_category

372: => per_vac_shd.g_old_rec.program_id
373: ,p_program_update_date_o
374: => per_vac_shd.g_old_rec.program_update_date
375: ,p_attribute_category_o
376: => per_vac_shd.g_old_rec.attribute_category
377: ,p_attribute1_o
378: => per_vac_shd.g_old_rec.attribute1
379: ,p_attribute2_o
380: => per_vac_shd.g_old_rec.attribute2

Line 378: => per_vac_shd.g_old_rec.attribute1

374: => per_vac_shd.g_old_rec.program_update_date
375: ,p_attribute_category_o
376: => per_vac_shd.g_old_rec.attribute_category
377: ,p_attribute1_o
378: => per_vac_shd.g_old_rec.attribute1
379: ,p_attribute2_o
380: => per_vac_shd.g_old_rec.attribute2
381: ,p_attribute3_o
382: => per_vac_shd.g_old_rec.attribute3

Line 380: => per_vac_shd.g_old_rec.attribute2

376: => per_vac_shd.g_old_rec.attribute_category
377: ,p_attribute1_o
378: => per_vac_shd.g_old_rec.attribute1
379: ,p_attribute2_o
380: => per_vac_shd.g_old_rec.attribute2
381: ,p_attribute3_o
382: => per_vac_shd.g_old_rec.attribute3
383: ,p_attribute4_o
384: => per_vac_shd.g_old_rec.attribute4

Line 382: => per_vac_shd.g_old_rec.attribute3

378: => per_vac_shd.g_old_rec.attribute1
379: ,p_attribute2_o
380: => per_vac_shd.g_old_rec.attribute2
381: ,p_attribute3_o
382: => per_vac_shd.g_old_rec.attribute3
383: ,p_attribute4_o
384: => per_vac_shd.g_old_rec.attribute4
385: ,p_attribute5_o
386: => per_vac_shd.g_old_rec.attribute5

Line 384: => per_vac_shd.g_old_rec.attribute4

380: => per_vac_shd.g_old_rec.attribute2
381: ,p_attribute3_o
382: => per_vac_shd.g_old_rec.attribute3
383: ,p_attribute4_o
384: => per_vac_shd.g_old_rec.attribute4
385: ,p_attribute5_o
386: => per_vac_shd.g_old_rec.attribute5
387: ,p_attribute6_o
388: => per_vac_shd.g_old_rec.attribute6

Line 386: => per_vac_shd.g_old_rec.attribute5

382: => per_vac_shd.g_old_rec.attribute3
383: ,p_attribute4_o
384: => per_vac_shd.g_old_rec.attribute4
385: ,p_attribute5_o
386: => per_vac_shd.g_old_rec.attribute5
387: ,p_attribute6_o
388: => per_vac_shd.g_old_rec.attribute6
389: ,p_attribute7_o
390: => per_vac_shd.g_old_rec.attribute7

Line 388: => per_vac_shd.g_old_rec.attribute6

384: => per_vac_shd.g_old_rec.attribute4
385: ,p_attribute5_o
386: => per_vac_shd.g_old_rec.attribute5
387: ,p_attribute6_o
388: => per_vac_shd.g_old_rec.attribute6
389: ,p_attribute7_o
390: => per_vac_shd.g_old_rec.attribute7
391: ,p_attribute8_o
392: => per_vac_shd.g_old_rec.attribute8

Line 390: => per_vac_shd.g_old_rec.attribute7

386: => per_vac_shd.g_old_rec.attribute5
387: ,p_attribute6_o
388: => per_vac_shd.g_old_rec.attribute6
389: ,p_attribute7_o
390: => per_vac_shd.g_old_rec.attribute7
391: ,p_attribute8_o
392: => per_vac_shd.g_old_rec.attribute8
393: ,p_attribute9_o
394: => per_vac_shd.g_old_rec.attribute9

Line 392: => per_vac_shd.g_old_rec.attribute8

388: => per_vac_shd.g_old_rec.attribute6
389: ,p_attribute7_o
390: => per_vac_shd.g_old_rec.attribute7
391: ,p_attribute8_o
392: => per_vac_shd.g_old_rec.attribute8
393: ,p_attribute9_o
394: => per_vac_shd.g_old_rec.attribute9
395: ,p_attribute10_o
396: => per_vac_shd.g_old_rec.attribute10

Line 394: => per_vac_shd.g_old_rec.attribute9

390: => per_vac_shd.g_old_rec.attribute7
391: ,p_attribute8_o
392: => per_vac_shd.g_old_rec.attribute8
393: ,p_attribute9_o
394: => per_vac_shd.g_old_rec.attribute9
395: ,p_attribute10_o
396: => per_vac_shd.g_old_rec.attribute10
397: ,p_attribute11_o
398: => per_vac_shd.g_old_rec.attribute11

Line 396: => per_vac_shd.g_old_rec.attribute10

392: => per_vac_shd.g_old_rec.attribute8
393: ,p_attribute9_o
394: => per_vac_shd.g_old_rec.attribute9
395: ,p_attribute10_o
396: => per_vac_shd.g_old_rec.attribute10
397: ,p_attribute11_o
398: => per_vac_shd.g_old_rec.attribute11
399: ,p_attribute12_o
400: => per_vac_shd.g_old_rec.attribute12

Line 398: => per_vac_shd.g_old_rec.attribute11

394: => per_vac_shd.g_old_rec.attribute9
395: ,p_attribute10_o
396: => per_vac_shd.g_old_rec.attribute10
397: ,p_attribute11_o
398: => per_vac_shd.g_old_rec.attribute11
399: ,p_attribute12_o
400: => per_vac_shd.g_old_rec.attribute12
401: ,p_attribute13_o
402: => per_vac_shd.g_old_rec.attribute13

Line 400: => per_vac_shd.g_old_rec.attribute12

396: => per_vac_shd.g_old_rec.attribute10
397: ,p_attribute11_o
398: => per_vac_shd.g_old_rec.attribute11
399: ,p_attribute12_o
400: => per_vac_shd.g_old_rec.attribute12
401: ,p_attribute13_o
402: => per_vac_shd.g_old_rec.attribute13
403: ,p_attribute14_o
404: => per_vac_shd.g_old_rec.attribute14

Line 402: => per_vac_shd.g_old_rec.attribute13

398: => per_vac_shd.g_old_rec.attribute11
399: ,p_attribute12_o
400: => per_vac_shd.g_old_rec.attribute12
401: ,p_attribute13_o
402: => per_vac_shd.g_old_rec.attribute13
403: ,p_attribute14_o
404: => per_vac_shd.g_old_rec.attribute14
405: ,p_attribute15_o
406: => per_vac_shd.g_old_rec.attribute15

Line 404: => per_vac_shd.g_old_rec.attribute14

400: => per_vac_shd.g_old_rec.attribute12
401: ,p_attribute13_o
402: => per_vac_shd.g_old_rec.attribute13
403: ,p_attribute14_o
404: => per_vac_shd.g_old_rec.attribute14
405: ,p_attribute15_o
406: => per_vac_shd.g_old_rec.attribute15
407: ,p_attribute16_o
408: => per_vac_shd.g_old_rec.attribute16

Line 406: => per_vac_shd.g_old_rec.attribute15

402: => per_vac_shd.g_old_rec.attribute13
403: ,p_attribute14_o
404: => per_vac_shd.g_old_rec.attribute14
405: ,p_attribute15_o
406: => per_vac_shd.g_old_rec.attribute15
407: ,p_attribute16_o
408: => per_vac_shd.g_old_rec.attribute16
409: ,p_attribute17_o
410: => per_vac_shd.g_old_rec.attribute17

Line 408: => per_vac_shd.g_old_rec.attribute16

404: => per_vac_shd.g_old_rec.attribute14
405: ,p_attribute15_o
406: => per_vac_shd.g_old_rec.attribute15
407: ,p_attribute16_o
408: => per_vac_shd.g_old_rec.attribute16
409: ,p_attribute17_o
410: => per_vac_shd.g_old_rec.attribute17
411: ,p_attribute18_o
412: => per_vac_shd.g_old_rec.attribute18

Line 410: => per_vac_shd.g_old_rec.attribute17

406: => per_vac_shd.g_old_rec.attribute15
407: ,p_attribute16_o
408: => per_vac_shd.g_old_rec.attribute16
409: ,p_attribute17_o
410: => per_vac_shd.g_old_rec.attribute17
411: ,p_attribute18_o
412: => per_vac_shd.g_old_rec.attribute18
413: ,p_attribute19_o
414: => per_vac_shd.g_old_rec.attribute19

Line 412: => per_vac_shd.g_old_rec.attribute18

408: => per_vac_shd.g_old_rec.attribute16
409: ,p_attribute17_o
410: => per_vac_shd.g_old_rec.attribute17
411: ,p_attribute18_o
412: => per_vac_shd.g_old_rec.attribute18
413: ,p_attribute19_o
414: => per_vac_shd.g_old_rec.attribute19
415: ,p_attribute20_o
416: => per_vac_shd.g_old_rec.attribute20

Line 414: => per_vac_shd.g_old_rec.attribute19

410: => per_vac_shd.g_old_rec.attribute17
411: ,p_attribute18_o
412: => per_vac_shd.g_old_rec.attribute18
413: ,p_attribute19_o
414: => per_vac_shd.g_old_rec.attribute19
415: ,p_attribute20_o
416: => per_vac_shd.g_old_rec.attribute20
417: ,p_vacancy_category_o
418: => per_vac_shd.g_old_rec.vacancy_category

Line 416: => per_vac_shd.g_old_rec.attribute20

412: => per_vac_shd.g_old_rec.attribute18
413: ,p_attribute19_o
414: => per_vac_shd.g_old_rec.attribute19
415: ,p_attribute20_o
416: => per_vac_shd.g_old_rec.attribute20
417: ,p_vacancy_category_o
418: => per_vac_shd.g_old_rec.vacancy_category
419: ,p_budget_measurement_type_o
420: => per_vac_shd.g_old_rec.budget_measurement_type

Line 418: => per_vac_shd.g_old_rec.vacancy_category

414: => per_vac_shd.g_old_rec.attribute19
415: ,p_attribute20_o
416: => per_vac_shd.g_old_rec.attribute20
417: ,p_vacancy_category_o
418: => per_vac_shd.g_old_rec.vacancy_category
419: ,p_budget_measurement_type_o
420: => per_vac_shd.g_old_rec.budget_measurement_type
421: ,p_budget_measurement_value_o
422: => per_vac_shd.g_old_rec.budget_measurement_value

Line 420: => per_vac_shd.g_old_rec.budget_measurement_type

416: => per_vac_shd.g_old_rec.attribute20
417: ,p_vacancy_category_o
418: => per_vac_shd.g_old_rec.vacancy_category
419: ,p_budget_measurement_type_o
420: => per_vac_shd.g_old_rec.budget_measurement_type
421: ,p_budget_measurement_value_o
422: => per_vac_shd.g_old_rec.budget_measurement_value
423: ,p_manager_id_o
424: => per_vac_shd.g_old_rec.manager_id

Line 422: => per_vac_shd.g_old_rec.budget_measurement_value

418: => per_vac_shd.g_old_rec.vacancy_category
419: ,p_budget_measurement_type_o
420: => per_vac_shd.g_old_rec.budget_measurement_type
421: ,p_budget_measurement_value_o
422: => per_vac_shd.g_old_rec.budget_measurement_value
423: ,p_manager_id_o
424: => per_vac_shd.g_old_rec.manager_id
425: ,p_security_method_o
426: => per_vac_shd.g_old_rec.security_method

Line 424: => per_vac_shd.g_old_rec.manager_id

420: => per_vac_shd.g_old_rec.budget_measurement_type
421: ,p_budget_measurement_value_o
422: => per_vac_shd.g_old_rec.budget_measurement_value
423: ,p_manager_id_o
424: => per_vac_shd.g_old_rec.manager_id
425: ,p_security_method_o
426: => per_vac_shd.g_old_rec.security_method
427: ,p_primary_posting_id_o
428: => per_vac_shd.g_old_rec.primary_posting_id

Line 426: => per_vac_shd.g_old_rec.security_method

422: => per_vac_shd.g_old_rec.budget_measurement_value
423: ,p_manager_id_o
424: => per_vac_shd.g_old_rec.manager_id
425: ,p_security_method_o
426: => per_vac_shd.g_old_rec.security_method
427: ,p_primary_posting_id_o
428: => per_vac_shd.g_old_rec.primary_posting_id
429: ,p_assessment_id_o
430: => per_vac_shd.g_old_rec.assessment_id

Line 428: => per_vac_shd.g_old_rec.primary_posting_id

424: => per_vac_shd.g_old_rec.manager_id
425: ,p_security_method_o
426: => per_vac_shd.g_old_rec.security_method
427: ,p_primary_posting_id_o
428: => per_vac_shd.g_old_rec.primary_posting_id
429: ,p_assessment_id_o
430: => per_vac_shd.g_old_rec.assessment_id
431: ,p_object_version_number_o
432: => per_vac_shd.g_old_rec.object_version_number

Line 430: => per_vac_shd.g_old_rec.assessment_id

426: => per_vac_shd.g_old_rec.security_method
427: ,p_primary_posting_id_o
428: => per_vac_shd.g_old_rec.primary_posting_id
429: ,p_assessment_id_o
430: => per_vac_shd.g_old_rec.assessment_id
431: ,p_object_version_number_o
432: => per_vac_shd.g_old_rec.object_version_number
433: );
434: --

Line 432: => per_vac_shd.g_old_rec.object_version_number

428: => per_vac_shd.g_old_rec.primary_posting_id
429: ,p_assessment_id_o
430: => per_vac_shd.g_old_rec.assessment_id
431: ,p_object_version_number_o
432: => per_vac_shd.g_old_rec.object_version_number
433: );
434: --
435: exception
436: --

Line 492: (p_rec in out nocopy per_vac_shd.g_rec_type

488: --
489: -- {End Of Comments}
490: -- ----------------------------------------------------------------------------
491: Procedure convert_defs
492: (p_rec in out nocopy per_vac_shd.g_rec_type
493: ) is
494: --
495: Begin
496: --

Line 504: per_vac_shd.g_old_rec.business_group_id;

500: -- is being used then we must set to the 'current' argument value.
501: --
502: if (p_rec.business_group_id = hr_api.g_number) then
503: p_rec.business_group_id :=
504: per_vac_shd.g_old_rec.business_group_id;
505: end if;
506: if (p_rec.position_id = hr_api.g_number) then
507: p_rec.position_id :=
508: per_vac_shd.g_old_rec.position_id;

Line 508: per_vac_shd.g_old_rec.position_id;

504: per_vac_shd.g_old_rec.business_group_id;
505: end if;
506: if (p_rec.position_id = hr_api.g_number) then
507: p_rec.position_id :=
508: per_vac_shd.g_old_rec.position_id;
509: end if;
510: if (p_rec.job_id = hr_api.g_number) then
511: p_rec.job_id :=
512: per_vac_shd.g_old_rec.job_id;

Line 512: per_vac_shd.g_old_rec.job_id;

508: per_vac_shd.g_old_rec.position_id;
509: end if;
510: if (p_rec.job_id = hr_api.g_number) then
511: p_rec.job_id :=
512: per_vac_shd.g_old_rec.job_id;
513: end if;
514: if (p_rec.grade_id = hr_api.g_number) then
515: p_rec.grade_id :=
516: per_vac_shd.g_old_rec.grade_id;

Line 516: per_vac_shd.g_old_rec.grade_id;

512: per_vac_shd.g_old_rec.job_id;
513: end if;
514: if (p_rec.grade_id = hr_api.g_number) then
515: p_rec.grade_id :=
516: per_vac_shd.g_old_rec.grade_id;
517: end if;
518: if (p_rec.organization_id = hr_api.g_number) then
519: p_rec.organization_id :=
520: per_vac_shd.g_old_rec.organization_id;

Line 520: per_vac_shd.g_old_rec.organization_id;

516: per_vac_shd.g_old_rec.grade_id;
517: end if;
518: if (p_rec.organization_id = hr_api.g_number) then
519: p_rec.organization_id :=
520: per_vac_shd.g_old_rec.organization_id;
521: end if;
522: if (p_rec.requisition_id = hr_api.g_number) then
523: p_rec.requisition_id :=
524: per_vac_shd.g_old_rec.requisition_id;

Line 524: per_vac_shd.g_old_rec.requisition_id;

520: per_vac_shd.g_old_rec.organization_id;
521: end if;
522: if (p_rec.requisition_id = hr_api.g_number) then
523: p_rec.requisition_id :=
524: per_vac_shd.g_old_rec.requisition_id;
525: end if;
526: if (p_rec.people_group_id = hr_api.g_number) then
527: p_rec.people_group_id :=
528: per_vac_shd.g_old_rec.people_group_id;

Line 528: per_vac_shd.g_old_rec.people_group_id;

524: per_vac_shd.g_old_rec.requisition_id;
525: end if;
526: if (p_rec.people_group_id = hr_api.g_number) then
527: p_rec.people_group_id :=
528: per_vac_shd.g_old_rec.people_group_id;
529: end if;
530: if (p_rec.location_id = hr_api.g_number) then
531: p_rec.location_id :=
532: per_vac_shd.g_old_rec.location_id;

Line 532: per_vac_shd.g_old_rec.location_id;

528: per_vac_shd.g_old_rec.people_group_id;
529: end if;
530: if (p_rec.location_id = hr_api.g_number) then
531: p_rec.location_id :=
532: per_vac_shd.g_old_rec.location_id;
533: end if;
534: if (p_rec.recruiter_id = hr_api.g_number) then
535: p_rec.recruiter_id :=
536: per_vac_shd.g_old_rec.recruiter_id;

Line 536: per_vac_shd.g_old_rec.recruiter_id;

532: per_vac_shd.g_old_rec.location_id;
533: end if;
534: if (p_rec.recruiter_id = hr_api.g_number) then
535: p_rec.recruiter_id :=
536: per_vac_shd.g_old_rec.recruiter_id;
537: end if;
538: if (p_rec.date_from = hr_api.g_date) then
539: p_rec.date_from :=
540: per_vac_shd.g_old_rec.date_from;

Line 540: per_vac_shd.g_old_rec.date_from;

536: per_vac_shd.g_old_rec.recruiter_id;
537: end if;
538: if (p_rec.date_from = hr_api.g_date) then
539: p_rec.date_from :=
540: per_vac_shd.g_old_rec.date_from;
541: end if;
542: if (p_rec.name = hr_api.g_varchar2) then
543: p_rec.name :=
544: per_vac_shd.g_old_rec.name;

Line 544: per_vac_shd.g_old_rec.name;

540: per_vac_shd.g_old_rec.date_from;
541: end if;
542: if (p_rec.name = hr_api.g_varchar2) then
543: p_rec.name :=
544: per_vac_shd.g_old_rec.name;
545: end if;
546: if (p_rec.comments = hr_api.g_varchar2) then
547: p_rec.comments :=
548: per_vac_shd.g_old_rec.comments;

Line 548: per_vac_shd.g_old_rec.comments;

544: per_vac_shd.g_old_rec.name;
545: end if;
546: if (p_rec.comments = hr_api.g_varchar2) then
547: p_rec.comments :=
548: per_vac_shd.g_old_rec.comments;
549: end if;
550: if (p_rec.date_to = hr_api.g_date) then
551: p_rec.date_to :=
552: per_vac_shd.g_old_rec.date_to;

Line 552: per_vac_shd.g_old_rec.date_to;

548: per_vac_shd.g_old_rec.comments;
549: end if;
550: if (p_rec.date_to = hr_api.g_date) then
551: p_rec.date_to :=
552: per_vac_shd.g_old_rec.date_to;
553: end if;
554: if (p_rec.description = hr_api.g_varchar2) then
555: p_rec.description :=
556: per_vac_shd.g_old_rec.description;

Line 556: per_vac_shd.g_old_rec.description;

552: per_vac_shd.g_old_rec.date_to;
553: end if;
554: if (p_rec.description = hr_api.g_varchar2) then
555: p_rec.description :=
556: per_vac_shd.g_old_rec.description;
557: end if;
558: if (p_rec.number_of_openings = hr_api.g_number) then
559: p_rec.number_of_openings :=
560: per_vac_shd.g_old_rec.number_of_openings;

Line 560: per_vac_shd.g_old_rec.number_of_openings;

556: per_vac_shd.g_old_rec.description;
557: end if;
558: if (p_rec.number_of_openings = hr_api.g_number) then
559: p_rec.number_of_openings :=
560: per_vac_shd.g_old_rec.number_of_openings;
561: end if;
562: if (p_rec.status = hr_api.g_varchar2) then
563: p_rec.status :=
564: per_vac_shd.g_old_rec.status;

Line 564: per_vac_shd.g_old_rec.status;

560: per_vac_shd.g_old_rec.number_of_openings;
561: end if;
562: if (p_rec.status = hr_api.g_varchar2) then
563: p_rec.status :=
564: per_vac_shd.g_old_rec.status;
565: end if;
566: if (p_rec.request_id = hr_api.g_number) then
567: p_rec.request_id :=
568: per_vac_shd.g_old_rec.request_id;

Line 568: per_vac_shd.g_old_rec.request_id;

564: per_vac_shd.g_old_rec.status;
565: end if;
566: if (p_rec.request_id = hr_api.g_number) then
567: p_rec.request_id :=
568: per_vac_shd.g_old_rec.request_id;
569: end if;
570: if (p_rec.program_application_id = hr_api.g_number) then
571: p_rec.program_application_id :=
572: per_vac_shd.g_old_rec.program_application_id;

Line 572: per_vac_shd.g_old_rec.program_application_id;

568: per_vac_shd.g_old_rec.request_id;
569: end if;
570: if (p_rec.program_application_id = hr_api.g_number) then
571: p_rec.program_application_id :=
572: per_vac_shd.g_old_rec.program_application_id;
573: end if;
574: if (p_rec.program_id = hr_api.g_number) then
575: p_rec.program_id :=
576: per_vac_shd.g_old_rec.program_id;

Line 576: per_vac_shd.g_old_rec.program_id;

572: per_vac_shd.g_old_rec.program_application_id;
573: end if;
574: if (p_rec.program_id = hr_api.g_number) then
575: p_rec.program_id :=
576: per_vac_shd.g_old_rec.program_id;
577: end if;
578: if (p_rec.program_update_date = hr_api.g_date) then
579: p_rec.program_update_date :=
580: per_vac_shd.g_old_rec.program_update_date;

Line 580: per_vac_shd.g_old_rec.program_update_date;

576: per_vac_shd.g_old_rec.program_id;
577: end if;
578: if (p_rec.program_update_date = hr_api.g_date) then
579: p_rec.program_update_date :=
580: per_vac_shd.g_old_rec.program_update_date;
581: end if;
582: if (p_rec.attribute_category = hr_api.g_varchar2) then
583: p_rec.attribute_category :=
584: per_vac_shd.g_old_rec.attribute_category;

Line 584: per_vac_shd.g_old_rec.attribute_category;

580: per_vac_shd.g_old_rec.program_update_date;
581: end if;
582: if (p_rec.attribute_category = hr_api.g_varchar2) then
583: p_rec.attribute_category :=
584: per_vac_shd.g_old_rec.attribute_category;
585: end if;
586: if (p_rec.attribute1 = hr_api.g_varchar2) then
587: p_rec.attribute1 :=
588: per_vac_shd.g_old_rec.attribute1;

Line 588: per_vac_shd.g_old_rec.attribute1;

584: per_vac_shd.g_old_rec.attribute_category;
585: end if;
586: if (p_rec.attribute1 = hr_api.g_varchar2) then
587: p_rec.attribute1 :=
588: per_vac_shd.g_old_rec.attribute1;
589: end if;
590: if (p_rec.attribute2 = hr_api.g_varchar2) then
591: p_rec.attribute2 :=
592: per_vac_shd.g_old_rec.attribute2;

Line 592: per_vac_shd.g_old_rec.attribute2;

588: per_vac_shd.g_old_rec.attribute1;
589: end if;
590: if (p_rec.attribute2 = hr_api.g_varchar2) then
591: p_rec.attribute2 :=
592: per_vac_shd.g_old_rec.attribute2;
593: end if;
594: if (p_rec.attribute3 = hr_api.g_varchar2) then
595: p_rec.attribute3 :=
596: per_vac_shd.g_old_rec.attribute3;

Line 596: per_vac_shd.g_old_rec.attribute3;

592: per_vac_shd.g_old_rec.attribute2;
593: end if;
594: if (p_rec.attribute3 = hr_api.g_varchar2) then
595: p_rec.attribute3 :=
596: per_vac_shd.g_old_rec.attribute3;
597: end if;
598: if (p_rec.attribute4 = hr_api.g_varchar2) then
599: p_rec.attribute4 :=
600: per_vac_shd.g_old_rec.attribute4;

Line 600: per_vac_shd.g_old_rec.attribute4;

596: per_vac_shd.g_old_rec.attribute3;
597: end if;
598: if (p_rec.attribute4 = hr_api.g_varchar2) then
599: p_rec.attribute4 :=
600: per_vac_shd.g_old_rec.attribute4;
601: end if;
602: if (p_rec.attribute5 = hr_api.g_varchar2) then
603: p_rec.attribute5 :=
604: per_vac_shd.g_old_rec.attribute5;

Line 604: per_vac_shd.g_old_rec.attribute5;

600: per_vac_shd.g_old_rec.attribute4;
601: end if;
602: if (p_rec.attribute5 = hr_api.g_varchar2) then
603: p_rec.attribute5 :=
604: per_vac_shd.g_old_rec.attribute5;
605: end if;
606: if (p_rec.attribute6 = hr_api.g_varchar2) then
607: p_rec.attribute6 :=
608: per_vac_shd.g_old_rec.attribute6;

Line 608: per_vac_shd.g_old_rec.attribute6;

604: per_vac_shd.g_old_rec.attribute5;
605: end if;
606: if (p_rec.attribute6 = hr_api.g_varchar2) then
607: p_rec.attribute6 :=
608: per_vac_shd.g_old_rec.attribute6;
609: end if;
610: if (p_rec.attribute7 = hr_api.g_varchar2) then
611: p_rec.attribute7 :=
612: per_vac_shd.g_old_rec.attribute7;

Line 612: per_vac_shd.g_old_rec.attribute7;

608: per_vac_shd.g_old_rec.attribute6;
609: end if;
610: if (p_rec.attribute7 = hr_api.g_varchar2) then
611: p_rec.attribute7 :=
612: per_vac_shd.g_old_rec.attribute7;
613: end if;
614: if (p_rec.attribute8 = hr_api.g_varchar2) then
615: p_rec.attribute8 :=
616: per_vac_shd.g_old_rec.attribute8;

Line 616: per_vac_shd.g_old_rec.attribute8;

612: per_vac_shd.g_old_rec.attribute7;
613: end if;
614: if (p_rec.attribute8 = hr_api.g_varchar2) then
615: p_rec.attribute8 :=
616: per_vac_shd.g_old_rec.attribute8;
617: end if;
618: if (p_rec.attribute9 = hr_api.g_varchar2) then
619: p_rec.attribute9 :=
620: per_vac_shd.g_old_rec.attribute9;

Line 620: per_vac_shd.g_old_rec.attribute9;

616: per_vac_shd.g_old_rec.attribute8;
617: end if;
618: if (p_rec.attribute9 = hr_api.g_varchar2) then
619: p_rec.attribute9 :=
620: per_vac_shd.g_old_rec.attribute9;
621: end if;
622: if (p_rec.attribute10 = hr_api.g_varchar2) then
623: p_rec.attribute10 :=
624: per_vac_shd.g_old_rec.attribute10;

Line 624: per_vac_shd.g_old_rec.attribute10;

620: per_vac_shd.g_old_rec.attribute9;
621: end if;
622: if (p_rec.attribute10 = hr_api.g_varchar2) then
623: p_rec.attribute10 :=
624: per_vac_shd.g_old_rec.attribute10;
625: end if;
626: if (p_rec.attribute11 = hr_api.g_varchar2) then
627: p_rec.attribute11 :=
628: per_vac_shd.g_old_rec.attribute11;

Line 628: per_vac_shd.g_old_rec.attribute11;

624: per_vac_shd.g_old_rec.attribute10;
625: end if;
626: if (p_rec.attribute11 = hr_api.g_varchar2) then
627: p_rec.attribute11 :=
628: per_vac_shd.g_old_rec.attribute11;
629: end if;
630: if (p_rec.attribute12 = hr_api.g_varchar2) then
631: p_rec.attribute12 :=
632: per_vac_shd.g_old_rec.attribute12;

Line 632: per_vac_shd.g_old_rec.attribute12;

628: per_vac_shd.g_old_rec.attribute11;
629: end if;
630: if (p_rec.attribute12 = hr_api.g_varchar2) then
631: p_rec.attribute12 :=
632: per_vac_shd.g_old_rec.attribute12;
633: end if;
634: if (p_rec.attribute13 = hr_api.g_varchar2) then
635: p_rec.attribute13 :=
636: per_vac_shd.g_old_rec.attribute13;

Line 636: per_vac_shd.g_old_rec.attribute13;

632: per_vac_shd.g_old_rec.attribute12;
633: end if;
634: if (p_rec.attribute13 = hr_api.g_varchar2) then
635: p_rec.attribute13 :=
636: per_vac_shd.g_old_rec.attribute13;
637: end if;
638: if (p_rec.attribute14 = hr_api.g_varchar2) then
639: p_rec.attribute14 :=
640: per_vac_shd.g_old_rec.attribute14;

Line 640: per_vac_shd.g_old_rec.attribute14;

636: per_vac_shd.g_old_rec.attribute13;
637: end if;
638: if (p_rec.attribute14 = hr_api.g_varchar2) then
639: p_rec.attribute14 :=
640: per_vac_shd.g_old_rec.attribute14;
641: end if;
642: if (p_rec.attribute15 = hr_api.g_varchar2) then
643: p_rec.attribute15 :=
644: per_vac_shd.g_old_rec.attribute15;

Line 644: per_vac_shd.g_old_rec.attribute15;

640: per_vac_shd.g_old_rec.attribute14;
641: end if;
642: if (p_rec.attribute15 = hr_api.g_varchar2) then
643: p_rec.attribute15 :=
644: per_vac_shd.g_old_rec.attribute15;
645: end if;
646: if (p_rec.attribute16 = hr_api.g_varchar2) then
647: p_rec.attribute16 :=
648: per_vac_shd.g_old_rec.attribute16;

Line 648: per_vac_shd.g_old_rec.attribute16;

644: per_vac_shd.g_old_rec.attribute15;
645: end if;
646: if (p_rec.attribute16 = hr_api.g_varchar2) then
647: p_rec.attribute16 :=
648: per_vac_shd.g_old_rec.attribute16;
649: end if;
650: if (p_rec.attribute17 = hr_api.g_varchar2) then
651: p_rec.attribute17 :=
652: per_vac_shd.g_old_rec.attribute17;

Line 652: per_vac_shd.g_old_rec.attribute17;

648: per_vac_shd.g_old_rec.attribute16;
649: end if;
650: if (p_rec.attribute17 = hr_api.g_varchar2) then
651: p_rec.attribute17 :=
652: per_vac_shd.g_old_rec.attribute17;
653: end if;
654: if (p_rec.attribute18 = hr_api.g_varchar2) then
655: p_rec.attribute18 :=
656: per_vac_shd.g_old_rec.attribute18;

Line 656: per_vac_shd.g_old_rec.attribute18;

652: per_vac_shd.g_old_rec.attribute17;
653: end if;
654: if (p_rec.attribute18 = hr_api.g_varchar2) then
655: p_rec.attribute18 :=
656: per_vac_shd.g_old_rec.attribute18;
657: end if;
658: if (p_rec.attribute19 = hr_api.g_varchar2) then
659: p_rec.attribute19 :=
660: per_vac_shd.g_old_rec.attribute19;

Line 660: per_vac_shd.g_old_rec.attribute19;

656: per_vac_shd.g_old_rec.attribute18;
657: end if;
658: if (p_rec.attribute19 = hr_api.g_varchar2) then
659: p_rec.attribute19 :=
660: per_vac_shd.g_old_rec.attribute19;
661: end if;
662: if (p_rec.attribute20 = hr_api.g_varchar2) then
663: p_rec.attribute20 :=
664: per_vac_shd.g_old_rec.attribute20;

Line 664: per_vac_shd.g_old_rec.attribute20;

660: per_vac_shd.g_old_rec.attribute19;
661: end if;
662: if (p_rec.attribute20 = hr_api.g_varchar2) then
663: p_rec.attribute20 :=
664: per_vac_shd.g_old_rec.attribute20;
665: end if;
666: if (p_rec.vacancy_category = hr_api.g_varchar2) then
667: p_rec.vacancy_category :=
668: per_vac_shd.g_old_rec.vacancy_category;

Line 668: per_vac_shd.g_old_rec.vacancy_category;

664: per_vac_shd.g_old_rec.attribute20;
665: end if;
666: if (p_rec.vacancy_category = hr_api.g_varchar2) then
667: p_rec.vacancy_category :=
668: per_vac_shd.g_old_rec.vacancy_category;
669: end if;
670: if (p_rec.budget_measurement_type = hr_api.g_varchar2) then
671: p_rec.budget_measurement_type :=
672: per_vac_shd.g_old_rec.budget_measurement_type;

Line 672: per_vac_shd.g_old_rec.budget_measurement_type;

668: per_vac_shd.g_old_rec.vacancy_category;
669: end if;
670: if (p_rec.budget_measurement_type = hr_api.g_varchar2) then
671: p_rec.budget_measurement_type :=
672: per_vac_shd.g_old_rec.budget_measurement_type;
673: end if;
674: if (p_rec.budget_measurement_value = hr_api.g_number) then
675: p_rec.budget_measurement_value :=
676: per_vac_shd.g_old_rec.budget_measurement_value;

Line 676: per_vac_shd.g_old_rec.budget_measurement_value;

672: per_vac_shd.g_old_rec.budget_measurement_type;
673: end if;
674: if (p_rec.budget_measurement_value = hr_api.g_number) then
675: p_rec.budget_measurement_value :=
676: per_vac_shd.g_old_rec.budget_measurement_value;
677: end if;
678: if (p_rec.manager_id = hr_api.g_number) then
679: p_rec.manager_id :=
680: per_vac_shd.g_old_rec.manager_id;

Line 680: per_vac_shd.g_old_rec.manager_id;

676: per_vac_shd.g_old_rec.budget_measurement_value;
677: end if;
678: if (p_rec.manager_id = hr_api.g_number) then
679: p_rec.manager_id :=
680: per_vac_shd.g_old_rec.manager_id;
681: end if;
682: if (p_rec.security_method = hr_api.g_varchar2) then
683: p_rec.security_method :=
684: per_vac_shd.g_old_rec.security_method;

Line 684: per_vac_shd.g_old_rec.security_method;

680: per_vac_shd.g_old_rec.manager_id;
681: end if;
682: if (p_rec.security_method = hr_api.g_varchar2) then
683: p_rec.security_method :=
684: per_vac_shd.g_old_rec.security_method;
685: end if;
686: if (p_rec.primary_posting_id = hr_api.g_number) then
687: p_rec.primary_posting_id :=
688: per_vac_shd.g_old_rec.primary_posting_id;

Line 688: per_vac_shd.g_old_rec.primary_posting_id;

684: per_vac_shd.g_old_rec.security_method;
685: end if;
686: if (p_rec.primary_posting_id = hr_api.g_number) then
687: p_rec.primary_posting_id :=
688: per_vac_shd.g_old_rec.primary_posting_id;
689: end if;
690: if (p_rec.assessment_id = hr_api.g_number) then
691: p_rec.assessment_id :=
692: per_vac_shd.g_old_rec.assessment_id;

Line 692: per_vac_shd.g_old_rec.assessment_id;

688: per_vac_shd.g_old_rec.primary_posting_id;
689: end if;
690: if (p_rec.assessment_id = hr_api.g_number) then
691: p_rec.assessment_id :=
692: per_vac_shd.g_old_rec.assessment_id;
693: end if;
694: --
695: End convert_defs;
696: --

Line 701: (p_rec in out nocopy per_vac_shd.g_rec_type

697: -- ----------------------------------------------------------------------------
698: -- |---------------------------------< upd >----------------------------------|
699: -- ----------------------------------------------------------------------------
700: Procedure upd
701: (p_rec in out nocopy per_vac_shd.g_rec_type
702: ,p_effective_date in date
703: ,p_inv_pos_grade_warning out nocopy boolean
704: ,p_inv_job_grade_warning out nocopy boolean
705: ) is

Line 714: per_vac_shd.lck

710: hr_utility.set_location('Entering:'||l_proc, 5);
711: --
712: -- We must lock the row which we need to update.
713: --
714: per_vac_shd.lck
715: (p_rec.vacancy_id
716: ,p_rec.object_version_number
717: );
718: --

Line 810: l_rec per_vac_shd.g_rec_type;

806: ,p_inv_pos_grade_warning out nocopy boolean
807: ,p_inv_job_grade_warning out nocopy boolean
808: ) is
809: --
810: l_rec per_vac_shd.g_rec_type;
811: l_proc varchar2(72) := g_package||'upd';
812: --
813: Begin
814: hr_utility.set_location('Entering:'||l_proc, 5);

Line 820: per_vac_shd.convert_args

816: -- Call conversion function to turn arguments into the
817: -- l_rec structure.
818: --
819: l_rec :=
820: per_vac_shd.convert_args
821: (p_vacancy_id
822: ,p_business_group_id
823: ,p_position_id
824: ,p_job_id