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_PSV_UPD dependencies on HR_API

Line 91: When hr_api.check_integrity_violated Then

87: --
88: hr_utility.set_location(' Leaving:'||l_proc, 10);
89: --
90: Exception
91: When hr_api.check_integrity_violated Then
92: -- A check constraint has been violated
93: per_psv_shd.g_api_dml := false; -- Unset the api dml status
94: per_psv_shd.constraint_error
95: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 95: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

91: When hr_api.check_integrity_violated Then
92: -- A check constraint has been violated
93: per_psv_shd.g_api_dml := false; -- Unset the api dml status
94: per_psv_shd.constraint_error
95: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
96: When hr_api.parent_integrity_violated Then
97: -- Parent integrity has been violated
98: per_psv_shd.g_api_dml := false; -- Unset the api dml status
99: per_psv_shd.constraint_error

Line 96: When hr_api.parent_integrity_violated Then

92: -- A check constraint has been violated
93: per_psv_shd.g_api_dml := false; -- Unset the api dml status
94: per_psv_shd.constraint_error
95: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
96: When hr_api.parent_integrity_violated Then
97: -- Parent integrity has been violated
98: per_psv_shd.g_api_dml := false; -- Unset the api dml status
99: per_psv_shd.constraint_error
100: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 100: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

96: When hr_api.parent_integrity_violated Then
97: -- Parent integrity has been violated
98: per_psv_shd.g_api_dml := false; -- Unset the api dml status
99: per_psv_shd.constraint_error
100: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
101: When hr_api.unique_integrity_violated Then
102: -- Unique integrity has been violated
103: per_psv_shd.g_api_dml := false; -- Unset the api dml status
104: per_psv_shd.constraint_error

Line 101: When hr_api.unique_integrity_violated Then

97: -- Parent integrity has been violated
98: per_psv_shd.g_api_dml := false; -- Unset the api dml status
99: per_psv_shd.constraint_error
100: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
101: When hr_api.unique_integrity_violated Then
102: -- Unique integrity has been violated
103: per_psv_shd.g_api_dml := false; -- Unset the api dml status
104: per_psv_shd.constraint_error
105: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 105: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

101: When hr_api.unique_integrity_violated Then
102: -- Unique integrity has been violated
103: per_psv_shd.g_api_dml := false; -- Unset the api dml status
104: per_psv_shd.constraint_error
105: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
106: When Others Then
107: per_psv_shd.g_api_dml := false; -- Unset the api dml status
108: Raise;
109: End update_dml;

Line 250: when hr_api.cannot_find_prog_unit then

246: );
247: --
248: exception
249: --
250: when hr_api.cannot_find_prog_unit then
251: --
252: hr_api.cannot_find_prog_unit_error
253: (p_module_name => 'PER_POS_STRUCTURE_VERSIONS'
254: ,p_hook_type => 'AU');

Line 252: hr_api.cannot_find_prog_unit_error

248: exception
249: --
250: when hr_api.cannot_find_prog_unit then
251: --
252: hr_api.cannot_find_prog_unit_error
253: (p_module_name => 'PER_POS_STRUCTURE_VERSIONS'
254: ,p_hook_type => 'AU');
255: --
256: end;

Line 315: If (p_rec.business_group_id = hr_api.g_number) then

311: -- p_rec plsql record structure
312: -- to see if a system default is being used. If a system default
313: -- is being used then we must set to the 'current' argument value.
314: --
315: If (p_rec.business_group_id = hr_api.g_number) then
316: p_rec.business_group_id :=
317: per_psv_shd.g_old_rec.business_group_id;
318: End If;
319: If (p_rec.position_structure_id = hr_api.g_number) then

Line 319: If (p_rec.position_structure_id = hr_api.g_number) then

315: If (p_rec.business_group_id = hr_api.g_number) then
316: p_rec.business_group_id :=
317: per_psv_shd.g_old_rec.business_group_id;
318: End If;
319: If (p_rec.position_structure_id = hr_api.g_number) then
320: p_rec.position_structure_id :=
321: per_psv_shd.g_old_rec.position_structure_id;
322: End If;
323: If (p_rec.date_from = hr_api.g_date) then

Line 323: If (p_rec.date_from = hr_api.g_date) then

319: If (p_rec.position_structure_id = hr_api.g_number) then
320: p_rec.position_structure_id :=
321: per_psv_shd.g_old_rec.position_structure_id;
322: End If;
323: If (p_rec.date_from = hr_api.g_date) then
324: p_rec.date_from :=
325: per_psv_shd.g_old_rec.date_from;
326: End If;
327: If (p_rec.version_number = hr_api.g_number) then

Line 327: If (p_rec.version_number = hr_api.g_number) then

323: If (p_rec.date_from = hr_api.g_date) then
324: p_rec.date_from :=
325: per_psv_shd.g_old_rec.date_from;
326: End If;
327: If (p_rec.version_number = hr_api.g_number) then
328: p_rec.version_number :=
329: per_psv_shd.g_old_rec.version_number;
330: End If;
331: If (p_rec.copy_structure_version_id = hr_api.g_number) then

Line 331: If (p_rec.copy_structure_version_id = hr_api.g_number) then

327: If (p_rec.version_number = hr_api.g_number) then
328: p_rec.version_number :=
329: per_psv_shd.g_old_rec.version_number;
330: End If;
331: If (p_rec.copy_structure_version_id = hr_api.g_number) then
332: p_rec.copy_structure_version_id :=
333: per_psv_shd.g_old_rec.copy_structure_version_id;
334: End If;
335: If (p_rec.date_to = hr_api.g_date) then

Line 335: If (p_rec.date_to = hr_api.g_date) then

331: If (p_rec.copy_structure_version_id = hr_api.g_number) then
332: p_rec.copy_structure_version_id :=
333: per_psv_shd.g_old_rec.copy_structure_version_id;
334: End If;
335: If (p_rec.date_to = hr_api.g_date) then
336: p_rec.date_to :=
337: per_psv_shd.g_old_rec.date_to;
338: End If;
339: If (p_rec.request_id = hr_api.g_number) then

Line 339: If (p_rec.request_id = hr_api.g_number) then

335: If (p_rec.date_to = hr_api.g_date) then
336: p_rec.date_to :=
337: per_psv_shd.g_old_rec.date_to;
338: End If;
339: If (p_rec.request_id = hr_api.g_number) then
340: p_rec.request_id :=
341: per_psv_shd.g_old_rec.request_id;
342: End If;
343: If (p_rec.program_application_id = hr_api.g_number) then

Line 343: If (p_rec.program_application_id = hr_api.g_number) then

339: If (p_rec.request_id = hr_api.g_number) then
340: p_rec.request_id :=
341: per_psv_shd.g_old_rec.request_id;
342: End If;
343: If (p_rec.program_application_id = hr_api.g_number) then
344: p_rec.program_application_id :=
345: per_psv_shd.g_old_rec.program_application_id;
346: End If;
347: If (p_rec.program_id = hr_api.g_number) then

Line 347: If (p_rec.program_id = hr_api.g_number) then

343: If (p_rec.program_application_id = hr_api.g_number) then
344: p_rec.program_application_id :=
345: per_psv_shd.g_old_rec.program_application_id;
346: End If;
347: If (p_rec.program_id = hr_api.g_number) then
348: p_rec.program_id :=
349: per_psv_shd.g_old_rec.program_id;
350: End If;
351: If (p_rec.program_update_date = hr_api.g_date) then

Line 351: If (p_rec.program_update_date = hr_api.g_date) then

347: If (p_rec.program_id = hr_api.g_number) then
348: p_rec.program_id :=
349: per_psv_shd.g_old_rec.program_id;
350: End If;
351: If (p_rec.program_update_date = hr_api.g_date) then
352: p_rec.program_update_date :=
353: per_psv_shd.g_old_rec.program_update_date;
354: End If;
355: --

Line 414: ,p_position_structure_id in number default hr_api.g_number

410: -- ----------------------------------------------------------------------------
411: Procedure upd
412: (p_effective_date in date
413: ,p_pos_structure_version_id in number
414: ,p_position_structure_id in number default hr_api.g_number
415: ,p_date_from in date default hr_api.g_date
416: ,p_version_number in number default hr_api.g_number
417: ,p_copy_structure_version_id in number default hr_api.g_number
418: ,p_date_to in date default hr_api.g_date

Line 415: ,p_date_from in date default hr_api.g_date

411: Procedure upd
412: (p_effective_date in date
413: ,p_pos_structure_version_id in number
414: ,p_position_structure_id in number default hr_api.g_number
415: ,p_date_from in date default hr_api.g_date
416: ,p_version_number in number default hr_api.g_number
417: ,p_copy_structure_version_id in number default hr_api.g_number
418: ,p_date_to in date default hr_api.g_date
419: ,p_request_id in number default hr_api.g_number

Line 416: ,p_version_number in number default hr_api.g_number

412: (p_effective_date in date
413: ,p_pos_structure_version_id in number
414: ,p_position_structure_id in number default hr_api.g_number
415: ,p_date_from in date default hr_api.g_date
416: ,p_version_number in number default hr_api.g_number
417: ,p_copy_structure_version_id in number default hr_api.g_number
418: ,p_date_to in date default hr_api.g_date
419: ,p_request_id in number default hr_api.g_number
420: ,p_program_application_id in number default hr_api.g_number

Line 417: ,p_copy_structure_version_id in number default hr_api.g_number

413: ,p_pos_structure_version_id in number
414: ,p_position_structure_id in number default hr_api.g_number
415: ,p_date_from in date default hr_api.g_date
416: ,p_version_number in number default hr_api.g_number
417: ,p_copy_structure_version_id in number default hr_api.g_number
418: ,p_date_to in date default hr_api.g_date
419: ,p_request_id in number default hr_api.g_number
420: ,p_program_application_id in number default hr_api.g_number
421: ,p_program_id in number default hr_api.g_number

Line 418: ,p_date_to in date default hr_api.g_date

414: ,p_position_structure_id in number default hr_api.g_number
415: ,p_date_from in date default hr_api.g_date
416: ,p_version_number in number default hr_api.g_number
417: ,p_copy_structure_version_id in number default hr_api.g_number
418: ,p_date_to in date default hr_api.g_date
419: ,p_request_id in number default hr_api.g_number
420: ,p_program_application_id in number default hr_api.g_number
421: ,p_program_id in number default hr_api.g_number
422: ,p_program_update_date in date default hr_api.g_date

Line 419: ,p_request_id in number default hr_api.g_number

415: ,p_date_from in date default hr_api.g_date
416: ,p_version_number in number default hr_api.g_number
417: ,p_copy_structure_version_id in number default hr_api.g_number
418: ,p_date_to in date default hr_api.g_date
419: ,p_request_id in number default hr_api.g_number
420: ,p_program_application_id in number default hr_api.g_number
421: ,p_program_id in number default hr_api.g_number
422: ,p_program_update_date in date default hr_api.g_date
423: ,p_object_version_number in out nocopy number

Line 420: ,p_program_application_id in number default hr_api.g_number

416: ,p_version_number in number default hr_api.g_number
417: ,p_copy_structure_version_id in number default hr_api.g_number
418: ,p_date_to in date default hr_api.g_date
419: ,p_request_id in number default hr_api.g_number
420: ,p_program_application_id in number default hr_api.g_number
421: ,p_program_id in number default hr_api.g_number
422: ,p_program_update_date in date default hr_api.g_date
423: ,p_object_version_number in out nocopy number
424: ,p_gap_warning out nocopy boolean

Line 421: ,p_program_id in number default hr_api.g_number

417: ,p_copy_structure_version_id in number default hr_api.g_number
418: ,p_date_to in date default hr_api.g_date
419: ,p_request_id in number default hr_api.g_number
420: ,p_program_application_id in number default hr_api.g_number
421: ,p_program_id in number default hr_api.g_number
422: ,p_program_update_date in date default hr_api.g_date
423: ,p_object_version_number in out nocopy number
424: ,p_gap_warning out nocopy boolean
425: ) is

Line 422: ,p_program_update_date in date default hr_api.g_date

418: ,p_date_to in date default hr_api.g_date
419: ,p_request_id in number default hr_api.g_number
420: ,p_program_application_id in number default hr_api.g_number
421: ,p_program_id in number default hr_api.g_number
422: ,p_program_update_date in date default hr_api.g_date
423: ,p_object_version_number in out nocopy number
424: ,p_gap_warning out nocopy boolean
425: ) is
426: --

Line 439: ,hr_api.g_number

435: --
436: l_rec :=
437: per_psv_shd.convert_args
438: (p_pos_structure_version_id
439: ,hr_api.g_number
440: ,p_position_structure_id
441: ,p_date_from
442: ,p_version_number
443: ,p_copy_structure_version_id