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

Line 92: When hr_api.check_integrity_violated Then

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

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

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

Line 97: When hr_api.parent_integrity_violated Then

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

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

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

Line 102: When hr_api.unique_integrity_violated Then

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

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

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

Line 255: when hr_api.cannot_find_prog_unit then

251: );
252: --
253: exception
254: --
255: when hr_api.cannot_find_prog_unit then
256: --
257: hr_api.cannot_find_prog_unit_error
258: (p_module_name => 'PER_ORG_STRUCTURE_VERSIONS'
259: ,p_hook_type => 'AU');

Line 257: hr_api.cannot_find_prog_unit_error

253: exception
254: --
255: when hr_api.cannot_find_prog_unit then
256: --
257: hr_api.cannot_find_prog_unit_error
258: (p_module_name => 'PER_ORG_STRUCTURE_VERSIONS'
259: ,p_hook_type => 'AU');
260: --
261: end;

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

316: -- p_rec plsql record structure
317: -- to see if a system default is being used. If a system default
318: -- is being used then we must set to the 'current' argument value.
319: --
320: If (p_rec.business_group_id = hr_api.g_number) then
321: p_rec.business_group_id :=
322: per_osv_shd.g_old_rec.business_group_id;
323: End If;
324: If (p_rec.organization_structure_id = hr_api.g_number) then

Line 324: If (p_rec.organization_structure_id = hr_api.g_number) then

320: If (p_rec.business_group_id = hr_api.g_number) then
321: p_rec.business_group_id :=
322: per_osv_shd.g_old_rec.business_group_id;
323: End If;
324: If (p_rec.organization_structure_id = hr_api.g_number) then
325: p_rec.organization_structure_id :=
326: per_osv_shd.g_old_rec.organization_structure_id;
327: End If;
328: If (p_rec.date_from = hr_api.g_date) then

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

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

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

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

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

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

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

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

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

340: If (p_rec.date_to = hr_api.g_date) then
341: p_rec.date_to :=
342: per_osv_shd.g_old_rec.date_to;
343: End If;
344: If (p_rec.request_id = hr_api.g_number) then
345: p_rec.request_id :=
346: per_osv_shd.g_old_rec.request_id;
347: End If;
348: If (p_rec.program_application_id = hr_api.g_number) then

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

344: If (p_rec.request_id = hr_api.g_number) then
345: p_rec.request_id :=
346: per_osv_shd.g_old_rec.request_id;
347: End If;
348: If (p_rec.program_application_id = hr_api.g_number) then
349: p_rec.program_application_id :=
350: per_osv_shd.g_old_rec.program_application_id;
351: End If;
352: If (p_rec.program_id = hr_api.g_number) then

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

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

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

352: If (p_rec.program_id = hr_api.g_number) then
353: p_rec.program_id :=
354: per_osv_shd.g_old_rec.program_id;
355: End If;
356: If (p_rec.program_update_date = hr_api.g_date) then
357: p_rec.program_update_date :=
358: per_osv_shd.g_old_rec.program_update_date;
359: End If;
360: If (p_rec.topnode_pos_ctrl_enabled_flag = hr_api.g_varchar2) then

Line 360: If (p_rec.topnode_pos_ctrl_enabled_flag = hr_api.g_varchar2) then

356: If (p_rec.program_update_date = hr_api.g_date) then
357: p_rec.program_update_date :=
358: per_osv_shd.g_old_rec.program_update_date;
359: End If;
360: If (p_rec.topnode_pos_ctrl_enabled_flag = hr_api.g_varchar2) then
361: p_rec.topnode_pos_ctrl_enabled_flag :=
362: per_osv_shd.g_old_rec.topnode_pos_ctrl_enabled_flag;
363: End If;
364: --

Line 424: ,p_organization_structure_id in number default hr_api.g_number

420: Procedure upd
421: (p_effective_date in date
422: ,p_org_structure_version_id in number
423: ,p_object_version_number in out nocopy number
424: ,p_organization_structure_id in number default hr_api.g_number
425: ,p_date_from in date default hr_api.g_date
426: ,p_version_number in number default hr_api.g_number
427: ,p_copy_structure_version_id in number default hr_api.g_number
428: ,p_date_to in date default hr_api.g_date

Line 425: ,p_date_from in date default hr_api.g_date

421: (p_effective_date in date
422: ,p_org_structure_version_id in number
423: ,p_object_version_number in out nocopy number
424: ,p_organization_structure_id in number default hr_api.g_number
425: ,p_date_from in date default hr_api.g_date
426: ,p_version_number in number default hr_api.g_number
427: ,p_copy_structure_version_id in number default hr_api.g_number
428: ,p_date_to in date default hr_api.g_date
429: ,p_request_id in number default hr_api.g_number

Line 426: ,p_version_number in number default hr_api.g_number

422: ,p_org_structure_version_id in number
423: ,p_object_version_number in out nocopy number
424: ,p_organization_structure_id in number default hr_api.g_number
425: ,p_date_from in date default hr_api.g_date
426: ,p_version_number in number default hr_api.g_number
427: ,p_copy_structure_version_id in number default hr_api.g_number
428: ,p_date_to in date default hr_api.g_date
429: ,p_request_id in number default hr_api.g_number
430: ,p_program_application_id in number default hr_api.g_number

Line 427: ,p_copy_structure_version_id in number default hr_api.g_number

423: ,p_object_version_number in out nocopy number
424: ,p_organization_structure_id in number default hr_api.g_number
425: ,p_date_from in date default hr_api.g_date
426: ,p_version_number in number default hr_api.g_number
427: ,p_copy_structure_version_id in number default hr_api.g_number
428: ,p_date_to in date default hr_api.g_date
429: ,p_request_id in number default hr_api.g_number
430: ,p_program_application_id in number default hr_api.g_number
431: ,p_program_id in number default hr_api.g_number

Line 428: ,p_date_to in date default hr_api.g_date

424: ,p_organization_structure_id in number default hr_api.g_number
425: ,p_date_from in date default hr_api.g_date
426: ,p_version_number in number default hr_api.g_number
427: ,p_copy_structure_version_id in number default hr_api.g_number
428: ,p_date_to in date default hr_api.g_date
429: ,p_request_id in number default hr_api.g_number
430: ,p_program_application_id in number default hr_api.g_number
431: ,p_program_id in number default hr_api.g_number
432: ,p_program_update_date in date default hr_api.g_date

Line 429: ,p_request_id in number default hr_api.g_number

425: ,p_date_from in date default hr_api.g_date
426: ,p_version_number in number default hr_api.g_number
427: ,p_copy_structure_version_id in number default hr_api.g_number
428: ,p_date_to in date default hr_api.g_date
429: ,p_request_id in number default hr_api.g_number
430: ,p_program_application_id in number default hr_api.g_number
431: ,p_program_id in number default hr_api.g_number
432: ,p_program_update_date in date default hr_api.g_date
433: ,p_topnode_pos_ctrl_enabled_fla in varchar2 default hr_api.g_varchar2

Line 430: ,p_program_application_id in number default hr_api.g_number

426: ,p_version_number in number default hr_api.g_number
427: ,p_copy_structure_version_id in number default hr_api.g_number
428: ,p_date_to in date default hr_api.g_date
429: ,p_request_id in number default hr_api.g_number
430: ,p_program_application_id in number default hr_api.g_number
431: ,p_program_id in number default hr_api.g_number
432: ,p_program_update_date in date default hr_api.g_date
433: ,p_topnode_pos_ctrl_enabled_fla in varchar2 default hr_api.g_varchar2
434: ,p_gap_warning out nocopy boolean) is

Line 431: ,p_program_id in number default hr_api.g_number

427: ,p_copy_structure_version_id in number default hr_api.g_number
428: ,p_date_to in date default hr_api.g_date
429: ,p_request_id in number default hr_api.g_number
430: ,p_program_application_id in number default hr_api.g_number
431: ,p_program_id in number default hr_api.g_number
432: ,p_program_update_date in date default hr_api.g_date
433: ,p_topnode_pos_ctrl_enabled_fla in varchar2 default hr_api.g_varchar2
434: ,p_gap_warning out nocopy boolean) is
435: --

Line 432: ,p_program_update_date in date default hr_api.g_date

428: ,p_date_to in date default hr_api.g_date
429: ,p_request_id in number default hr_api.g_number
430: ,p_program_application_id in number default hr_api.g_number
431: ,p_program_id in number default hr_api.g_number
432: ,p_program_update_date in date default hr_api.g_date
433: ,p_topnode_pos_ctrl_enabled_fla in varchar2 default hr_api.g_varchar2
434: ,p_gap_warning out nocopy boolean) is
435: --
436: l_rec per_osv_shd.g_rec_type;

Line 433: ,p_topnode_pos_ctrl_enabled_fla in varchar2 default hr_api.g_varchar2

429: ,p_request_id in number default hr_api.g_number
430: ,p_program_application_id in number default hr_api.g_number
431: ,p_program_id in number default hr_api.g_number
432: ,p_program_update_date in date default hr_api.g_date
433: ,p_topnode_pos_ctrl_enabled_fla in varchar2 default hr_api.g_varchar2
434: ,p_gap_warning out nocopy boolean) is
435: --
436: l_rec per_osv_shd.g_rec_type;
437: l_proc varchar2(72) := g_package||'upd';

Line 448: ,hr_api.g_number

444: --
445: l_rec :=
446: per_osv_shd.convert_args
447: (p_org_structure_version_id
448: ,hr_api.g_number
449: ,p_organization_structure_id
450: ,p_date_from
451: ,p_version_number
452: ,p_copy_structure_version_id