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 132: per_vac_shd.g_api_dml := false; -- Unset the dml status

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

Line 133: per_vac_shd.constraint_error

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

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

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

Line 138: per_vac_shd.constraint_error

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

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

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

Line 143: per_vac_shd.constraint_error

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

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

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

Line 183: (p_rec in per_vac_shd.g_rec_type

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

Line 227: (p_rec in per_vac_shd.g_rec_type

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

Line 343: => per_vac_shd.g_old_rec.position_id

339: => p_rec.assessment_id
340: ,p_object_version_number
341: => p_rec.object_version_number
342: ,p_position_id_o
343: => per_vac_shd.g_old_rec.position_id
344: ,p_job_id_o
345: => per_vac_shd.g_old_rec.job_id
346: ,p_grade_id_o
347: => per_vac_shd.g_old_rec.grade_id

Line 345: => per_vac_shd.g_old_rec.job_id

341: => p_rec.object_version_number
342: ,p_position_id_o
343: => per_vac_shd.g_old_rec.position_id
344: ,p_job_id_o
345: => per_vac_shd.g_old_rec.job_id
346: ,p_grade_id_o
347: => per_vac_shd.g_old_rec.grade_id
348: ,p_organization_id_o
349: => per_vac_shd.g_old_rec.organization_id

Line 347: => per_vac_shd.g_old_rec.grade_id

343: => per_vac_shd.g_old_rec.position_id
344: ,p_job_id_o
345: => per_vac_shd.g_old_rec.job_id
346: ,p_grade_id_o
347: => per_vac_shd.g_old_rec.grade_id
348: ,p_organization_id_o
349: => per_vac_shd.g_old_rec.organization_id
350: ,p_requisition_id_o
351: => per_vac_shd.g_old_rec.requisition_id

Line 349: => per_vac_shd.g_old_rec.organization_id

345: => per_vac_shd.g_old_rec.job_id
346: ,p_grade_id_o
347: => per_vac_shd.g_old_rec.grade_id
348: ,p_organization_id_o
349: => per_vac_shd.g_old_rec.organization_id
350: ,p_requisition_id_o
351: => per_vac_shd.g_old_rec.requisition_id
352: ,p_people_group_id_o
353: => per_vac_shd.g_old_rec.people_group_id

Line 351: => per_vac_shd.g_old_rec.requisition_id

347: => per_vac_shd.g_old_rec.grade_id
348: ,p_organization_id_o
349: => per_vac_shd.g_old_rec.organization_id
350: ,p_requisition_id_o
351: => per_vac_shd.g_old_rec.requisition_id
352: ,p_people_group_id_o
353: => per_vac_shd.g_old_rec.people_group_id
354: ,p_location_id_o
355: => per_vac_shd.g_old_rec.location_id

Line 353: => per_vac_shd.g_old_rec.people_group_id

349: => per_vac_shd.g_old_rec.organization_id
350: ,p_requisition_id_o
351: => per_vac_shd.g_old_rec.requisition_id
352: ,p_people_group_id_o
353: => per_vac_shd.g_old_rec.people_group_id
354: ,p_location_id_o
355: => per_vac_shd.g_old_rec.location_id
356: ,p_recruiter_id_o
357: => per_vac_shd.g_old_rec.recruiter_id

Line 355: => per_vac_shd.g_old_rec.location_id

351: => per_vac_shd.g_old_rec.requisition_id
352: ,p_people_group_id_o
353: => per_vac_shd.g_old_rec.people_group_id
354: ,p_location_id_o
355: => per_vac_shd.g_old_rec.location_id
356: ,p_recruiter_id_o
357: => per_vac_shd.g_old_rec.recruiter_id
358: ,p_date_from_o
359: => per_vac_shd.g_old_rec.date_from

Line 357: => per_vac_shd.g_old_rec.recruiter_id

353: => per_vac_shd.g_old_rec.people_group_id
354: ,p_location_id_o
355: => per_vac_shd.g_old_rec.location_id
356: ,p_recruiter_id_o
357: => per_vac_shd.g_old_rec.recruiter_id
358: ,p_date_from_o
359: => per_vac_shd.g_old_rec.date_from
360: ,p_comments_o
361: => per_vac_shd.g_old_rec.comments

Line 359: => per_vac_shd.g_old_rec.date_from

355: => per_vac_shd.g_old_rec.location_id
356: ,p_recruiter_id_o
357: => per_vac_shd.g_old_rec.recruiter_id
358: ,p_date_from_o
359: => per_vac_shd.g_old_rec.date_from
360: ,p_comments_o
361: => per_vac_shd.g_old_rec.comments
362: ,p_date_to_o
363: => per_vac_shd.g_old_rec.date_to

Line 361: => per_vac_shd.g_old_rec.comments

357: => per_vac_shd.g_old_rec.recruiter_id
358: ,p_date_from_o
359: => per_vac_shd.g_old_rec.date_from
360: ,p_comments_o
361: => per_vac_shd.g_old_rec.comments
362: ,p_date_to_o
363: => per_vac_shd.g_old_rec.date_to
364: ,p_description_o
365: => per_vac_shd.g_old_rec.description

Line 363: => per_vac_shd.g_old_rec.date_to

359: => per_vac_shd.g_old_rec.date_from
360: ,p_comments_o
361: => per_vac_shd.g_old_rec.comments
362: ,p_date_to_o
363: => per_vac_shd.g_old_rec.date_to
364: ,p_description_o
365: => per_vac_shd.g_old_rec.description
366: ,p_number_of_openings_o
367: => per_vac_shd.g_old_rec.number_of_openings

Line 365: => per_vac_shd.g_old_rec.description

361: => per_vac_shd.g_old_rec.comments
362: ,p_date_to_o
363: => per_vac_shd.g_old_rec.date_to
364: ,p_description_o
365: => per_vac_shd.g_old_rec.description
366: ,p_number_of_openings_o
367: => per_vac_shd.g_old_rec.number_of_openings
368: ,p_status_o
369: => per_vac_shd.g_old_rec.status

Line 367: => per_vac_shd.g_old_rec.number_of_openings

363: => per_vac_shd.g_old_rec.date_to
364: ,p_description_o
365: => per_vac_shd.g_old_rec.description
366: ,p_number_of_openings_o
367: => per_vac_shd.g_old_rec.number_of_openings
368: ,p_status_o
369: => per_vac_shd.g_old_rec.status
370: ,p_request_id_o
371: => per_vac_shd.g_old_rec.request_id

Line 369: => per_vac_shd.g_old_rec.status

365: => per_vac_shd.g_old_rec.description
366: ,p_number_of_openings_o
367: => per_vac_shd.g_old_rec.number_of_openings
368: ,p_status_o
369: => per_vac_shd.g_old_rec.status
370: ,p_request_id_o
371: => per_vac_shd.g_old_rec.request_id
372: ,p_program_application_id_o
373: => per_vac_shd.g_old_rec.program_application_id

Line 371: => per_vac_shd.g_old_rec.request_id

367: => per_vac_shd.g_old_rec.number_of_openings
368: ,p_status_o
369: => per_vac_shd.g_old_rec.status
370: ,p_request_id_o
371: => per_vac_shd.g_old_rec.request_id
372: ,p_program_application_id_o
373: => per_vac_shd.g_old_rec.program_application_id
374: ,p_program_id_o
375: => per_vac_shd.g_old_rec.program_id

Line 373: => per_vac_shd.g_old_rec.program_application_id

369: => per_vac_shd.g_old_rec.status
370: ,p_request_id_o
371: => per_vac_shd.g_old_rec.request_id
372: ,p_program_application_id_o
373: => per_vac_shd.g_old_rec.program_application_id
374: ,p_program_id_o
375: => per_vac_shd.g_old_rec.program_id
376: ,p_program_update_date_o
377: => per_vac_shd.g_old_rec.program_update_date

Line 375: => per_vac_shd.g_old_rec.program_id

371: => per_vac_shd.g_old_rec.request_id
372: ,p_program_application_id_o
373: => per_vac_shd.g_old_rec.program_application_id
374: ,p_program_id_o
375: => per_vac_shd.g_old_rec.program_id
376: ,p_program_update_date_o
377: => per_vac_shd.g_old_rec.program_update_date
378: ,p_attribute_category_o
379: => per_vac_shd.g_old_rec.attribute_category

Line 377: => per_vac_shd.g_old_rec.program_update_date

373: => per_vac_shd.g_old_rec.program_application_id
374: ,p_program_id_o
375: => per_vac_shd.g_old_rec.program_id
376: ,p_program_update_date_o
377: => per_vac_shd.g_old_rec.program_update_date
378: ,p_attribute_category_o
379: => per_vac_shd.g_old_rec.attribute_category
380: ,p_attribute1_o
381: => per_vac_shd.g_old_rec.attribute1

Line 379: => per_vac_shd.g_old_rec.attribute_category

375: => per_vac_shd.g_old_rec.program_id
376: ,p_program_update_date_o
377: => per_vac_shd.g_old_rec.program_update_date
378: ,p_attribute_category_o
379: => per_vac_shd.g_old_rec.attribute_category
380: ,p_attribute1_o
381: => per_vac_shd.g_old_rec.attribute1
382: ,p_attribute2_o
383: => per_vac_shd.g_old_rec.attribute2

Line 381: => per_vac_shd.g_old_rec.attribute1

377: => per_vac_shd.g_old_rec.program_update_date
378: ,p_attribute_category_o
379: => per_vac_shd.g_old_rec.attribute_category
380: ,p_attribute1_o
381: => per_vac_shd.g_old_rec.attribute1
382: ,p_attribute2_o
383: => per_vac_shd.g_old_rec.attribute2
384: ,p_attribute3_o
385: => per_vac_shd.g_old_rec.attribute3

Line 383: => per_vac_shd.g_old_rec.attribute2

379: => per_vac_shd.g_old_rec.attribute_category
380: ,p_attribute1_o
381: => per_vac_shd.g_old_rec.attribute1
382: ,p_attribute2_o
383: => per_vac_shd.g_old_rec.attribute2
384: ,p_attribute3_o
385: => per_vac_shd.g_old_rec.attribute3
386: ,p_attribute4_o
387: => per_vac_shd.g_old_rec.attribute4

Line 385: => per_vac_shd.g_old_rec.attribute3

381: => per_vac_shd.g_old_rec.attribute1
382: ,p_attribute2_o
383: => per_vac_shd.g_old_rec.attribute2
384: ,p_attribute3_o
385: => per_vac_shd.g_old_rec.attribute3
386: ,p_attribute4_o
387: => per_vac_shd.g_old_rec.attribute4
388: ,p_attribute5_o
389: => per_vac_shd.g_old_rec.attribute5

Line 387: => per_vac_shd.g_old_rec.attribute4

383: => per_vac_shd.g_old_rec.attribute2
384: ,p_attribute3_o
385: => per_vac_shd.g_old_rec.attribute3
386: ,p_attribute4_o
387: => per_vac_shd.g_old_rec.attribute4
388: ,p_attribute5_o
389: => per_vac_shd.g_old_rec.attribute5
390: ,p_attribute6_o
391: => per_vac_shd.g_old_rec.attribute6

Line 389: => per_vac_shd.g_old_rec.attribute5

385: => per_vac_shd.g_old_rec.attribute3
386: ,p_attribute4_o
387: => per_vac_shd.g_old_rec.attribute4
388: ,p_attribute5_o
389: => per_vac_shd.g_old_rec.attribute5
390: ,p_attribute6_o
391: => per_vac_shd.g_old_rec.attribute6
392: ,p_attribute7_o
393: => per_vac_shd.g_old_rec.attribute7

Line 391: => per_vac_shd.g_old_rec.attribute6

387: => per_vac_shd.g_old_rec.attribute4
388: ,p_attribute5_o
389: => per_vac_shd.g_old_rec.attribute5
390: ,p_attribute6_o
391: => per_vac_shd.g_old_rec.attribute6
392: ,p_attribute7_o
393: => per_vac_shd.g_old_rec.attribute7
394: ,p_attribute8_o
395: => per_vac_shd.g_old_rec.attribute8

Line 393: => per_vac_shd.g_old_rec.attribute7

389: => per_vac_shd.g_old_rec.attribute5
390: ,p_attribute6_o
391: => per_vac_shd.g_old_rec.attribute6
392: ,p_attribute7_o
393: => per_vac_shd.g_old_rec.attribute7
394: ,p_attribute8_o
395: => per_vac_shd.g_old_rec.attribute8
396: ,p_attribute9_o
397: => per_vac_shd.g_old_rec.attribute9

Line 395: => per_vac_shd.g_old_rec.attribute8

391: => per_vac_shd.g_old_rec.attribute6
392: ,p_attribute7_o
393: => per_vac_shd.g_old_rec.attribute7
394: ,p_attribute8_o
395: => per_vac_shd.g_old_rec.attribute8
396: ,p_attribute9_o
397: => per_vac_shd.g_old_rec.attribute9
398: ,p_attribute10_o
399: => per_vac_shd.g_old_rec.attribute10

Line 397: => per_vac_shd.g_old_rec.attribute9

393: => per_vac_shd.g_old_rec.attribute7
394: ,p_attribute8_o
395: => per_vac_shd.g_old_rec.attribute8
396: ,p_attribute9_o
397: => per_vac_shd.g_old_rec.attribute9
398: ,p_attribute10_o
399: => per_vac_shd.g_old_rec.attribute10
400: ,p_attribute11_o
401: => per_vac_shd.g_old_rec.attribute11

Line 399: => per_vac_shd.g_old_rec.attribute10

395: => per_vac_shd.g_old_rec.attribute8
396: ,p_attribute9_o
397: => per_vac_shd.g_old_rec.attribute9
398: ,p_attribute10_o
399: => per_vac_shd.g_old_rec.attribute10
400: ,p_attribute11_o
401: => per_vac_shd.g_old_rec.attribute11
402: ,p_attribute12_o
403: => per_vac_shd.g_old_rec.attribute12

Line 401: => per_vac_shd.g_old_rec.attribute11

397: => per_vac_shd.g_old_rec.attribute9
398: ,p_attribute10_o
399: => per_vac_shd.g_old_rec.attribute10
400: ,p_attribute11_o
401: => per_vac_shd.g_old_rec.attribute11
402: ,p_attribute12_o
403: => per_vac_shd.g_old_rec.attribute12
404: ,p_attribute13_o
405: => per_vac_shd.g_old_rec.attribute13

Line 403: => per_vac_shd.g_old_rec.attribute12

399: => per_vac_shd.g_old_rec.attribute10
400: ,p_attribute11_o
401: => per_vac_shd.g_old_rec.attribute11
402: ,p_attribute12_o
403: => per_vac_shd.g_old_rec.attribute12
404: ,p_attribute13_o
405: => per_vac_shd.g_old_rec.attribute13
406: ,p_attribute14_o
407: => per_vac_shd.g_old_rec.attribute14

Line 405: => per_vac_shd.g_old_rec.attribute13

401: => per_vac_shd.g_old_rec.attribute11
402: ,p_attribute12_o
403: => per_vac_shd.g_old_rec.attribute12
404: ,p_attribute13_o
405: => per_vac_shd.g_old_rec.attribute13
406: ,p_attribute14_o
407: => per_vac_shd.g_old_rec.attribute14
408: ,p_attribute15_o
409: => per_vac_shd.g_old_rec.attribute15

Line 407: => per_vac_shd.g_old_rec.attribute14

403: => per_vac_shd.g_old_rec.attribute12
404: ,p_attribute13_o
405: => per_vac_shd.g_old_rec.attribute13
406: ,p_attribute14_o
407: => per_vac_shd.g_old_rec.attribute14
408: ,p_attribute15_o
409: => per_vac_shd.g_old_rec.attribute15
410: ,p_attribute16_o
411: => per_vac_shd.g_old_rec.attribute16

Line 409: => per_vac_shd.g_old_rec.attribute15

405: => per_vac_shd.g_old_rec.attribute13
406: ,p_attribute14_o
407: => per_vac_shd.g_old_rec.attribute14
408: ,p_attribute15_o
409: => per_vac_shd.g_old_rec.attribute15
410: ,p_attribute16_o
411: => per_vac_shd.g_old_rec.attribute16
412: ,p_attribute17_o
413: => per_vac_shd.g_old_rec.attribute17

Line 411: => per_vac_shd.g_old_rec.attribute16

407: => per_vac_shd.g_old_rec.attribute14
408: ,p_attribute15_o
409: => per_vac_shd.g_old_rec.attribute15
410: ,p_attribute16_o
411: => per_vac_shd.g_old_rec.attribute16
412: ,p_attribute17_o
413: => per_vac_shd.g_old_rec.attribute17
414: ,p_attribute18_o
415: => per_vac_shd.g_old_rec.attribute18

Line 413: => per_vac_shd.g_old_rec.attribute17

409: => per_vac_shd.g_old_rec.attribute15
410: ,p_attribute16_o
411: => per_vac_shd.g_old_rec.attribute16
412: ,p_attribute17_o
413: => per_vac_shd.g_old_rec.attribute17
414: ,p_attribute18_o
415: => per_vac_shd.g_old_rec.attribute18
416: ,p_attribute19_o
417: => per_vac_shd.g_old_rec.attribute19

Line 415: => per_vac_shd.g_old_rec.attribute18

411: => per_vac_shd.g_old_rec.attribute16
412: ,p_attribute17_o
413: => per_vac_shd.g_old_rec.attribute17
414: ,p_attribute18_o
415: => per_vac_shd.g_old_rec.attribute18
416: ,p_attribute19_o
417: => per_vac_shd.g_old_rec.attribute19
418: ,p_attribute20_o
419: => per_vac_shd.g_old_rec.attribute20

Line 417: => per_vac_shd.g_old_rec.attribute19

413: => per_vac_shd.g_old_rec.attribute17
414: ,p_attribute18_o
415: => per_vac_shd.g_old_rec.attribute18
416: ,p_attribute19_o
417: => per_vac_shd.g_old_rec.attribute19
418: ,p_attribute20_o
419: => per_vac_shd.g_old_rec.attribute20
420: ,p_vacancy_category_o
421: => per_vac_shd.g_old_rec.vacancy_category

Line 419: => per_vac_shd.g_old_rec.attribute20

415: => per_vac_shd.g_old_rec.attribute18
416: ,p_attribute19_o
417: => per_vac_shd.g_old_rec.attribute19
418: ,p_attribute20_o
419: => per_vac_shd.g_old_rec.attribute20
420: ,p_vacancy_category_o
421: => per_vac_shd.g_old_rec.vacancy_category
422: ,p_vacancy_region_type_o
423: => per_vac_shd.g_old_rec.vacancy_region_type

Line 421: => per_vac_shd.g_old_rec.vacancy_category

417: => per_vac_shd.g_old_rec.attribute19
418: ,p_attribute20_o
419: => per_vac_shd.g_old_rec.attribute20
420: ,p_vacancy_category_o
421: => per_vac_shd.g_old_rec.vacancy_category
422: ,p_vacancy_region_type_o
423: => per_vac_shd.g_old_rec.vacancy_region_type
424: ,p_budget_measurement_type_o
425: => per_vac_shd.g_old_rec.budget_measurement_type

Line 423: => per_vac_shd.g_old_rec.vacancy_region_type

419: => per_vac_shd.g_old_rec.attribute20
420: ,p_vacancy_category_o
421: => per_vac_shd.g_old_rec.vacancy_category
422: ,p_vacancy_region_type_o
423: => per_vac_shd.g_old_rec.vacancy_region_type
424: ,p_budget_measurement_type_o
425: => per_vac_shd.g_old_rec.budget_measurement_type
426: ,p_budget_measurement_value_o
427: => per_vac_shd.g_old_rec.budget_measurement_value

Line 425: => per_vac_shd.g_old_rec.budget_measurement_type

421: => per_vac_shd.g_old_rec.vacancy_category
422: ,p_vacancy_region_type_o
423: => per_vac_shd.g_old_rec.vacancy_region_type
424: ,p_budget_measurement_type_o
425: => per_vac_shd.g_old_rec.budget_measurement_type
426: ,p_budget_measurement_value_o
427: => per_vac_shd.g_old_rec.budget_measurement_value
428: ,p_manager_id_o
429: => per_vac_shd.g_old_rec.manager_id

Line 427: => per_vac_shd.g_old_rec.budget_measurement_value

423: => per_vac_shd.g_old_rec.vacancy_region_type
424: ,p_budget_measurement_type_o
425: => per_vac_shd.g_old_rec.budget_measurement_type
426: ,p_budget_measurement_value_o
427: => per_vac_shd.g_old_rec.budget_measurement_value
428: ,p_manager_id_o
429: => per_vac_shd.g_old_rec.manager_id
430: ,p_security_method_o
431: => per_vac_shd.g_old_rec.security_method

Line 429: => per_vac_shd.g_old_rec.manager_id

425: => per_vac_shd.g_old_rec.budget_measurement_type
426: ,p_budget_measurement_value_o
427: => per_vac_shd.g_old_rec.budget_measurement_value
428: ,p_manager_id_o
429: => per_vac_shd.g_old_rec.manager_id
430: ,p_security_method_o
431: => per_vac_shd.g_old_rec.security_method
432: ,p_primary_posting_id_o
433: => per_vac_shd.g_old_rec.primary_posting_id

Line 431: => per_vac_shd.g_old_rec.security_method

427: => per_vac_shd.g_old_rec.budget_measurement_value
428: ,p_manager_id_o
429: => per_vac_shd.g_old_rec.manager_id
430: ,p_security_method_o
431: => per_vac_shd.g_old_rec.security_method
432: ,p_primary_posting_id_o
433: => per_vac_shd.g_old_rec.primary_posting_id
434: ,p_assessment_id_o
435: => per_vac_shd.g_old_rec.assessment_id

Line 433: => per_vac_shd.g_old_rec.primary_posting_id

429: => per_vac_shd.g_old_rec.manager_id
430: ,p_security_method_o
431: => per_vac_shd.g_old_rec.security_method
432: ,p_primary_posting_id_o
433: => per_vac_shd.g_old_rec.primary_posting_id
434: ,p_assessment_id_o
435: => per_vac_shd.g_old_rec.assessment_id
436: ,p_object_version_number_o
437: => per_vac_shd.g_old_rec.object_version_number

Line 435: => per_vac_shd.g_old_rec.assessment_id

431: => per_vac_shd.g_old_rec.security_method
432: ,p_primary_posting_id_o
433: => per_vac_shd.g_old_rec.primary_posting_id
434: ,p_assessment_id_o
435: => per_vac_shd.g_old_rec.assessment_id
436: ,p_object_version_number_o
437: => per_vac_shd.g_old_rec.object_version_number
438: );
439: --

Line 437: => per_vac_shd.g_old_rec.object_version_number

433: => per_vac_shd.g_old_rec.primary_posting_id
434: ,p_assessment_id_o
435: => per_vac_shd.g_old_rec.assessment_id
436: ,p_object_version_number_o
437: => per_vac_shd.g_old_rec.object_version_number
438: );
439: --
440: exception
441: --

Line 497: (p_rec in out nocopy per_vac_shd.g_rec_type

493: --
494: -- {End Of Comments}
495: -- ----------------------------------------------------------------------------
496: Procedure convert_defs
497: (p_rec in out nocopy per_vac_shd.g_rec_type
498: ) is
499: --
500: Begin
501: --

Line 509: per_vac_shd.g_old_rec.business_group_id;

505: -- is being used then we must set to the 'current' argument value.
506: --
507: if (p_rec.business_group_id = hr_api.g_number) then
508: p_rec.business_group_id :=
509: per_vac_shd.g_old_rec.business_group_id;
510: end if;
511: if (p_rec.position_id = hr_api.g_number) then
512: p_rec.position_id :=
513: per_vac_shd.g_old_rec.position_id;

Line 513: per_vac_shd.g_old_rec.position_id;

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

Line 517: per_vac_shd.g_old_rec.job_id;

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

Line 521: per_vac_shd.g_old_rec.grade_id;

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

Line 525: per_vac_shd.g_old_rec.organization_id;

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

Line 529: per_vac_shd.g_old_rec.requisition_id;

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

Line 533: per_vac_shd.g_old_rec.people_group_id;

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

Line 537: per_vac_shd.g_old_rec.location_id;

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

Line 541: per_vac_shd.g_old_rec.recruiter_id;

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

Line 545: per_vac_shd.g_old_rec.date_from;

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

Line 549: per_vac_shd.g_old_rec.name;

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

Line 553: per_vac_shd.g_old_rec.comments;

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

Line 557: per_vac_shd.g_old_rec.date_to;

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

Line 561: per_vac_shd.g_old_rec.description;

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

Line 565: per_vac_shd.g_old_rec.number_of_openings;

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

Line 569: per_vac_shd.g_old_rec.status;

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

Line 573: per_vac_shd.g_old_rec.request_id;

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

Line 577: per_vac_shd.g_old_rec.program_application_id;

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

Line 581: per_vac_shd.g_old_rec.program_id;

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

Line 585: per_vac_shd.g_old_rec.program_update_date;

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

Line 589: per_vac_shd.g_old_rec.attribute_category;

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

Line 593: per_vac_shd.g_old_rec.attribute1;

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

Line 597: per_vac_shd.g_old_rec.attribute2;

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

Line 601: per_vac_shd.g_old_rec.attribute3;

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

Line 605: per_vac_shd.g_old_rec.attribute4;

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

Line 609: per_vac_shd.g_old_rec.attribute5;

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

Line 613: per_vac_shd.g_old_rec.attribute6;

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

Line 617: per_vac_shd.g_old_rec.attribute7;

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

Line 621: per_vac_shd.g_old_rec.attribute8;

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

Line 625: per_vac_shd.g_old_rec.attribute9;

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

Line 629: per_vac_shd.g_old_rec.attribute10;

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

Line 633: per_vac_shd.g_old_rec.attribute11;

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

Line 637: per_vac_shd.g_old_rec.attribute12;

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

Line 641: per_vac_shd.g_old_rec.attribute13;

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

Line 645: per_vac_shd.g_old_rec.attribute14;

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

Line 649: per_vac_shd.g_old_rec.attribute15;

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

Line 653: per_vac_shd.g_old_rec.attribute16;

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

Line 657: per_vac_shd.g_old_rec.attribute17;

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

Line 661: per_vac_shd.g_old_rec.attribute18;

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

Line 665: per_vac_shd.g_old_rec.attribute19;

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

Line 669: per_vac_shd.g_old_rec.attribute20;

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

Line 673: per_vac_shd.g_old_rec.vacancy_category;

669: per_vac_shd.g_old_rec.attribute20;
670: end if;
671: if (p_rec.vacancy_category = hr_api.g_varchar2) then
672: p_rec.vacancy_category :=
673: per_vac_shd.g_old_rec.vacancy_category;
674: end if;
675: if (p_rec.vacancy_region_type = hr_api.g_varchar2) then
676: p_rec.vacancy_region_type :=
677: per_vac_shd.g_old_rec.vacancy_region_type;

Line 677: per_vac_shd.g_old_rec.vacancy_region_type;

673: per_vac_shd.g_old_rec.vacancy_category;
674: end if;
675: if (p_rec.vacancy_region_type = hr_api.g_varchar2) then
676: p_rec.vacancy_region_type :=
677: per_vac_shd.g_old_rec.vacancy_region_type;
678: end if;
679: if (p_rec.budget_measurement_type = hr_api.g_varchar2) then
680: p_rec.budget_measurement_type :=
681: per_vac_shd.g_old_rec.budget_measurement_type;

Line 681: per_vac_shd.g_old_rec.budget_measurement_type;

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

Line 685: per_vac_shd.g_old_rec.budget_measurement_value;

681: per_vac_shd.g_old_rec.budget_measurement_type;
682: end if;
683: if (p_rec.budget_measurement_value = hr_api.g_number) then
684: p_rec.budget_measurement_value :=
685: per_vac_shd.g_old_rec.budget_measurement_value;
686: end if;
687: if (p_rec.manager_id = hr_api.g_number) then
688: p_rec.manager_id :=
689: per_vac_shd.g_old_rec.manager_id;

Line 689: per_vac_shd.g_old_rec.manager_id;

685: per_vac_shd.g_old_rec.budget_measurement_value;
686: end if;
687: if (p_rec.manager_id = hr_api.g_number) then
688: p_rec.manager_id :=
689: per_vac_shd.g_old_rec.manager_id;
690: end if;
691: if (p_rec.security_method = hr_api.g_varchar2) then
692: p_rec.security_method :=
693: per_vac_shd.g_old_rec.security_method;

Line 693: per_vac_shd.g_old_rec.security_method;

689: per_vac_shd.g_old_rec.manager_id;
690: end if;
691: if (p_rec.security_method = hr_api.g_varchar2) then
692: p_rec.security_method :=
693: per_vac_shd.g_old_rec.security_method;
694: end if;
695: if (p_rec.primary_posting_id = hr_api.g_number) then
696: p_rec.primary_posting_id :=
697: per_vac_shd.g_old_rec.primary_posting_id;

Line 697: per_vac_shd.g_old_rec.primary_posting_id;

693: per_vac_shd.g_old_rec.security_method;
694: end if;
695: if (p_rec.primary_posting_id = hr_api.g_number) then
696: p_rec.primary_posting_id :=
697: per_vac_shd.g_old_rec.primary_posting_id;
698: end if;
699: if (p_rec.assessment_id = hr_api.g_number) then
700: p_rec.assessment_id :=
701: per_vac_shd.g_old_rec.assessment_id;

Line 701: per_vac_shd.g_old_rec.assessment_id;

697: per_vac_shd.g_old_rec.primary_posting_id;
698: end if;
699: if (p_rec.assessment_id = hr_api.g_number) then
700: p_rec.assessment_id :=
701: per_vac_shd.g_old_rec.assessment_id;
702: end if;
703: --
704: End convert_defs;
705: --

Line 710: (p_rec in out nocopy per_vac_shd.g_rec_type

706: -- ----------------------------------------------------------------------------
707: -- |---------------------------------< upd >----------------------------------|
708: -- ----------------------------------------------------------------------------
709: Procedure upd
710: (p_rec in out nocopy per_vac_shd.g_rec_type
711: ,p_effective_date in date
712: ,p_inv_pos_grade_warning out nocopy boolean
713: ,p_inv_job_grade_warning out nocopy boolean
714: ) is

Line 723: per_vac_shd.lck

719: hr_utility.set_location('Entering:'||l_proc, 5);
720: --
721: -- We must lock the row which we need to update.
722: --
723: per_vac_shd.lck
724: (p_rec.vacancy_id
725: ,p_rec.object_version_number
726: );
727: --

Line 820: l_rec per_vac_shd.g_rec_type;

816: ,p_inv_pos_grade_warning out nocopy boolean
817: ,p_inv_job_grade_warning out nocopy boolean
818: ) is
819: --
820: l_rec per_vac_shd.g_rec_type;
821: l_proc varchar2(72) := g_package||'upd';
822: --
823: Begin
824: hr_utility.set_location('Entering:'||l_proc, 5);

Line 830: per_vac_shd.convert_args

826: -- Call conversion function to turn arguments into the
827: -- l_rec structure.
828: --
829: l_rec :=
830: per_vac_shd.convert_args
831: (p_vacancy_id
832: ,p_business_group_id
833: ,p_position_id
834: ,p_job_id