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

Line 88: When hr_api.check_integrity_violated Then

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

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

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

Line 93: When hr_api.parent_integrity_violated Then

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

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

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

Line 98: When hr_api.unique_integrity_violated Then

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

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

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

Line 237: when hr_api.cannot_find_prog_unit then

233: );
234: --
235: exception
236: --
237: when hr_api.cannot_find_prog_unit then
238: --
239: hr_api.cannot_find_prog_unit_error
240: (p_module_name => 'PER_ORG_STRUCTURE_ELEMENTS'
241: ,p_hook_type => 'AU');

Line 239: hr_api.cannot_find_prog_unit_error

235: exception
236: --
237: when hr_api.cannot_find_prog_unit then
238: --
239: hr_api.cannot_find_prog_unit_error
240: (p_module_name => 'PER_ORG_STRUCTURE_ELEMENTS'
241: ,p_hook_type => 'AU');
242: --
243: end;

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

298: -- p_rec plsql record structure
299: -- to see if a system default is being used. If a system default
300: -- is being used then we must set to the 'current' argument value.
301: --
302: If (p_rec.business_group_id = hr_api.g_number) then
303: p_rec.business_group_id :=
304: per_ose_shd.g_old_rec.business_group_id;
305: End If;
306: If (p_rec.organization_id_parent = hr_api.g_number) then

Line 306: If (p_rec.organization_id_parent = hr_api.g_number) then

302: If (p_rec.business_group_id = hr_api.g_number) then
303: p_rec.business_group_id :=
304: per_ose_shd.g_old_rec.business_group_id;
305: End If;
306: If (p_rec.organization_id_parent = hr_api.g_number) then
307: p_rec.organization_id_parent :=
308: per_ose_shd.g_old_rec.organization_id_parent;
309: End If;
310: If (p_rec.org_structure_version_id = hr_api.g_number) then

Line 310: If (p_rec.org_structure_version_id = hr_api.g_number) then

306: If (p_rec.organization_id_parent = hr_api.g_number) then
307: p_rec.organization_id_parent :=
308: per_ose_shd.g_old_rec.organization_id_parent;
309: End If;
310: If (p_rec.org_structure_version_id = hr_api.g_number) then
311: p_rec.org_structure_version_id :=
312: per_ose_shd.g_old_rec.org_structure_version_id;
313: End If;
314: If (p_rec.organization_id_child = hr_api.g_number) then

Line 314: If (p_rec.organization_id_child = hr_api.g_number) then

310: If (p_rec.org_structure_version_id = hr_api.g_number) then
311: p_rec.org_structure_version_id :=
312: per_ose_shd.g_old_rec.org_structure_version_id;
313: End If;
314: If (p_rec.organization_id_child = hr_api.g_number) then
315: p_rec.organization_id_child :=
316: per_ose_shd.g_old_rec.organization_id_child;
317: End If;
318: If (p_rec.position_control_enabled_flag = hr_api.g_varchar2) then

Line 318: If (p_rec.position_control_enabled_flag = hr_api.g_varchar2) then

314: If (p_rec.organization_id_child = hr_api.g_number) then
315: p_rec.organization_id_child :=
316: per_ose_shd.g_old_rec.organization_id_child;
317: End If;
318: If (p_rec.position_control_enabled_flag = hr_api.g_varchar2) then
319: p_rec.position_control_enabled_flag :=
320: per_ose_shd.g_old_rec.position_control_enabled_flag;
321: End If;
322: If (p_rec.request_id = hr_api.g_number) then

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

318: If (p_rec.position_control_enabled_flag = hr_api.g_varchar2) then
319: p_rec.position_control_enabled_flag :=
320: per_ose_shd.g_old_rec.position_control_enabled_flag;
321: End If;
322: If (p_rec.request_id = hr_api.g_number) then
323: p_rec.request_id :=
324: per_ose_shd.g_old_rec.request_id;
325: End If;
326: If (p_rec.program_application_id = hr_api.g_number) then

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

322: If (p_rec.request_id = hr_api.g_number) then
323: p_rec.request_id :=
324: per_ose_shd.g_old_rec.request_id;
325: End If;
326: If (p_rec.program_application_id = hr_api.g_number) then
327: p_rec.program_application_id :=
328: per_ose_shd.g_old_rec.program_application_id;
329: End If;
330: If (p_rec.program_id = hr_api.g_number) then

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

326: If (p_rec.program_application_id = hr_api.g_number) then
327: p_rec.program_application_id :=
328: per_ose_shd.g_old_rec.program_application_id;
329: End If;
330: If (p_rec.program_id = hr_api.g_number) then
331: p_rec.program_id :=
332: per_ose_shd.g_old_rec.program_id;
333: End If;
334: If (p_rec.program_update_date = hr_api.g_date) then

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

330: If (p_rec.program_id = hr_api.g_number) then
331: p_rec.program_id :=
332: per_ose_shd.g_old_rec.program_id;
333: End If;
334: If (p_rec.program_update_date = hr_api.g_date) then
335: p_rec.program_update_date :=
336: per_ose_shd.g_old_rec.program_update_date;
337: End If;
338: --

Line 425: ,p_organization_id_parent in number default hr_api.g_number

421: Procedure upd
422: (p_effective_date in date
423: ,p_org_structure_element_id in number
424: ,p_object_version_number in out nocopy number
425: ,p_organization_id_parent in number default hr_api.g_number
426: ,p_organization_id_child in number default hr_api.g_number
427: ,p_pos_control_enabled_flag in varchar2 default hr_api.g_varchar2
428: ,p_request_id in number default hr_api.g_number
429: ,p_program_application_id in number default hr_api.g_number

Line 426: ,p_organization_id_child in number default hr_api.g_number

422: (p_effective_date in date
423: ,p_org_structure_element_id in number
424: ,p_object_version_number in out nocopy number
425: ,p_organization_id_parent in number default hr_api.g_number
426: ,p_organization_id_child in number default hr_api.g_number
427: ,p_pos_control_enabled_flag in varchar2 default hr_api.g_varchar2
428: ,p_request_id in number default hr_api.g_number
429: ,p_program_application_id in number default hr_api.g_number
430: ,p_program_id in number default hr_api.g_number

Line 427: ,p_pos_control_enabled_flag in varchar2 default hr_api.g_varchar2

423: ,p_org_structure_element_id in number
424: ,p_object_version_number in out nocopy number
425: ,p_organization_id_parent in number default hr_api.g_number
426: ,p_organization_id_child in number default hr_api.g_number
427: ,p_pos_control_enabled_flag in varchar2 default hr_api.g_varchar2
428: ,p_request_id in number default hr_api.g_number
429: ,p_program_application_id in number default hr_api.g_number
430: ,p_program_id in number default hr_api.g_number
431: ,p_program_update_date in date default hr_api.g_date

Line 428: ,p_request_id in number default hr_api.g_number

424: ,p_object_version_number in out nocopy number
425: ,p_organization_id_parent in number default hr_api.g_number
426: ,p_organization_id_child in number default hr_api.g_number
427: ,p_pos_control_enabled_flag in varchar2 default hr_api.g_varchar2
428: ,p_request_id in number default hr_api.g_number
429: ,p_program_application_id in number default hr_api.g_number
430: ,p_program_id in number default hr_api.g_number
431: ,p_program_update_date in date default hr_api.g_date
432: ) is

Line 429: ,p_program_application_id in number default hr_api.g_number

425: ,p_organization_id_parent in number default hr_api.g_number
426: ,p_organization_id_child in number default hr_api.g_number
427: ,p_pos_control_enabled_flag in varchar2 default hr_api.g_varchar2
428: ,p_request_id in number default hr_api.g_number
429: ,p_program_application_id in number default hr_api.g_number
430: ,p_program_id in number default hr_api.g_number
431: ,p_program_update_date in date default hr_api.g_date
432: ) is
433: --

Line 430: ,p_program_id in number default hr_api.g_number

426: ,p_organization_id_child in number default hr_api.g_number
427: ,p_pos_control_enabled_flag in varchar2 default hr_api.g_varchar2
428: ,p_request_id in number default hr_api.g_number
429: ,p_program_application_id in number default hr_api.g_number
430: ,p_program_id in number default hr_api.g_number
431: ,p_program_update_date in date default hr_api.g_date
432: ) is
433: --
434: l_rec per_ose_shd.g_rec_type;

Line 431: ,p_program_update_date in date default hr_api.g_date

427: ,p_pos_control_enabled_flag in varchar2 default hr_api.g_varchar2
428: ,p_request_id in number default hr_api.g_number
429: ,p_program_application_id in number default hr_api.g_number
430: ,p_program_id in number default hr_api.g_number
431: ,p_program_update_date in date default hr_api.g_date
432: ) is
433: --
434: l_rec per_ose_shd.g_rec_type;
435: l_proc varchar2(72) := g_package||'upd';

Line 446: ,hr_api.g_number

442: --
443: l_rec :=
444: per_ose_shd.convert_args
445: (p_org_structure_element_id
446: ,hr_api.g_number
447: ,p_organization_id_parent
448: ,hr_api.g_number
449: ,p_organization_id_child
450: ,p_request_id

Line 448: ,hr_api.g_number

444: per_ose_shd.convert_args
445: (p_org_structure_element_id
446: ,hr_api.g_number
447: ,p_organization_id_parent
448: ,hr_api.g_number
449: ,p_organization_id_child
450: ,p_request_id
451: ,p_program_application_id
452: ,p_program_id