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));
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
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));
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
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));
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;
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');
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;
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
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
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
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
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
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
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
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
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
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
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: --
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
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
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
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
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
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
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
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: --
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;
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';
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