71: ,p_qualifier_value => p_qualifier_value
72: );
73:
74: exception
75: when hr_api.cannot_find_prog_unit then
76: hr_api.cannot_find_prog_unit_error
77: (p_module_name => 'create_event_value_change'
78: ,p_hook_type => 'BP'
79: );
72: );
73:
74: exception
75: when hr_api.cannot_find_prog_unit then
76: hr_api.cannot_find_prog_unit_error
77: (p_module_name => 'create_event_value_change'
78: ,p_hook_type => 'BP'
79: );
80: end;
156: ,p_effective_start_date => l_effective_start_date
157: ,p_effective_end_date => l_effective_end_date
158: );
159: exception
160: when hr_api.cannot_find_prog_unit then
161: hr_api.cannot_find_prog_unit_error
162: (p_module_name => 'create_event_value_change'
163: ,p_hook_type => 'AP'
164: );
157: ,p_effective_end_date => l_effective_end_date
158: );
159: exception
160: when hr_api.cannot_find_prog_unit then
161: hr_api.cannot_find_prog_unit_error
162: (p_module_name => 'create_event_value_change'
163: ,p_hook_type => 'AP'
164: );
165: end;
169: --
170: -- When in validation only mode raise the Validate_Enabled exception
171: --
172: if p_validate then
173: raise hr_api.validate_enabled;
174: end if;
175: --
176: -- Set all output arguments
177: --
181: p_object_version_number := l_object_version_number;
182: --
183: hr_utility.set_location(' Leaving:'||l_proc, 70);
184: exception
185: when hr_api.validate_enabled then
186: --
187: -- As the Validate_Enabled exception has been raised
188: -- we must rollback to the savepoint
189: --
223: ,p_datetrack_mode in varchar2
224: ,p_event_qualifier_id in number
225: ,p_default_event in varchar2
226: ,p_valid_event in varchar2
227: ,p_datetracked_event_id in number default hr_api.g_number
228: ,p_business_group_id in number default hr_api.g_number
229: ,p_legislation_code in varchar2 default hr_api.g_varchar2
230: ,p_from_value in varchar2 default hr_api.g_varchar2
231: ,p_to_value in varchar2 default hr_api.g_varchar2
224: ,p_event_qualifier_id in number
225: ,p_default_event in varchar2
226: ,p_valid_event in varchar2
227: ,p_datetracked_event_id in number default hr_api.g_number
228: ,p_business_group_id in number default hr_api.g_number
229: ,p_legislation_code in varchar2 default hr_api.g_varchar2
230: ,p_from_value in varchar2 default hr_api.g_varchar2
231: ,p_to_value in varchar2 default hr_api.g_varchar2
232: ,p_proration_style in varchar2 default hr_api.g_varchar2
225: ,p_default_event in varchar2
226: ,p_valid_event in varchar2
227: ,p_datetracked_event_id in number default hr_api.g_number
228: ,p_business_group_id in number default hr_api.g_number
229: ,p_legislation_code in varchar2 default hr_api.g_varchar2
230: ,p_from_value in varchar2 default hr_api.g_varchar2
231: ,p_to_value in varchar2 default hr_api.g_varchar2
232: ,p_proration_style in varchar2 default hr_api.g_varchar2
233: ,p_qualifier_value in varchar2 default hr_api.g_varchar2
226: ,p_valid_event in varchar2
227: ,p_datetracked_event_id in number default hr_api.g_number
228: ,p_business_group_id in number default hr_api.g_number
229: ,p_legislation_code in varchar2 default hr_api.g_varchar2
230: ,p_from_value in varchar2 default hr_api.g_varchar2
231: ,p_to_value in varchar2 default hr_api.g_varchar2
232: ,p_proration_style in varchar2 default hr_api.g_varchar2
233: ,p_qualifier_value in varchar2 default hr_api.g_varchar2
234: ,p_event_value_change_id in number
227: ,p_datetracked_event_id in number default hr_api.g_number
228: ,p_business_group_id in number default hr_api.g_number
229: ,p_legislation_code in varchar2 default hr_api.g_varchar2
230: ,p_from_value in varchar2 default hr_api.g_varchar2
231: ,p_to_value in varchar2 default hr_api.g_varchar2
232: ,p_proration_style in varchar2 default hr_api.g_varchar2
233: ,p_qualifier_value in varchar2 default hr_api.g_varchar2
234: ,p_event_value_change_id in number
235: ,p_object_version_number in out nocopy number
228: ,p_business_group_id in number default hr_api.g_number
229: ,p_legislation_code in varchar2 default hr_api.g_varchar2
230: ,p_from_value in varchar2 default hr_api.g_varchar2
231: ,p_to_value in varchar2 default hr_api.g_varchar2
232: ,p_proration_style in varchar2 default hr_api.g_varchar2
233: ,p_qualifier_value in varchar2 default hr_api.g_varchar2
234: ,p_event_value_change_id in number
235: ,p_object_version_number in out nocopy number
236: ,p_effective_start_date out nocopy date
229: ,p_legislation_code in varchar2 default hr_api.g_varchar2
230: ,p_from_value in varchar2 default hr_api.g_varchar2
231: ,p_to_value in varchar2 default hr_api.g_varchar2
232: ,p_proration_style in varchar2 default hr_api.g_varchar2
233: ,p_qualifier_value in varchar2 default hr_api.g_varchar2
234: ,p_event_value_change_id in number
235: ,p_object_version_number in out nocopy number
236: ,p_effective_start_date out nocopy date
237: ,p_effective_end_date out nocopy date
287: ,p_object_version_number => l_object_version_number
288: );
289:
290: exception
291: when hr_api.cannot_find_prog_unit then
292: hr_api.cannot_find_prog_unit_error
293: (p_module_name => 'update_event_value_change'
294: ,p_hook_type => 'BP'
295: );
288: );
289:
290: exception
291: when hr_api.cannot_find_prog_unit then
292: hr_api.cannot_find_prog_unit_error
293: (p_module_name => 'update_event_value_change'
294: ,p_hook_type => 'BP'
295: );
296: end;
343: ,p_effective_start_date => l_effective_start_date
344: ,p_effective_end_date => l_effective_end_date
345: );
346: exception
347: when hr_api.cannot_find_prog_unit then
348: hr_api.cannot_find_prog_unit_error
349: (p_module_name => 'update_event_value_change_a'
350: ,p_hook_type => 'AP'
351: );
344: ,p_effective_end_date => l_effective_end_date
345: );
346: exception
347: when hr_api.cannot_find_prog_unit then
348: hr_api.cannot_find_prog_unit_error
349: (p_module_name => 'update_event_value_change_a'
350: ,p_hook_type => 'AP'
351: );
352: end;
354: --
355: -- When in validation only mode raise the Validate_Enabled exception
356: --
357: if p_validate then
358: raise hr_api.validate_enabled;
359: end if;
360: --
361: -- Set all output arguments
362: --
365: p_object_version_number := p_object_version_number;
366: --
367: hr_utility.set_location(' Leaving:'||l_proc, 70);
368: exception
369: when hr_api.validate_enabled then
370: --
371: -- As the Validate_Enabled exception has been raised
372: -- we must rollback to the savepoint
373: --
401: ,p_effective_date in date
402: ,p_datetrack_mode in varchar2
403: ,p_event_value_change_id in number
404: ,p_object_version_number in out nocopy number
405: ,p_business_group_id in number default hr_api.g_number
406: ,p_legislation_code in varchar2 default hr_api.g_varchar2
407: ,p_effective_start_date out nocopy date
408: ,p_effective_end_date out nocopy date
409: ) is
402: ,p_datetrack_mode in varchar2
403: ,p_event_value_change_id in number
404: ,p_object_version_number in out nocopy number
405: ,p_business_group_id in number default hr_api.g_number
406: ,p_legislation_code in varchar2 default hr_api.g_varchar2
407: ,p_effective_start_date out nocopy date
408: ,p_effective_end_date out nocopy date
409: ) is
410: --
445: ,p_legislation_code => p_legislation_code
446: );
447:
448: exception
449: when hr_api.cannot_find_prog_unit then
450: hr_api.cannot_find_prog_unit_error
451: (p_module_name => 'delete_event_value_change'
452: ,p_hook_type => 'BP'
453: );
446: );
447:
448: exception
449: when hr_api.cannot_find_prog_unit then
450: hr_api.cannot_find_prog_unit_error
451: (p_module_name => 'delete_event_value_change'
452: ,p_hook_type => 'BP'
453: );
454: end;
460: hr_utility.set_location(l_proc, 30);
461: --
462: -- Lock the non-translated table row handler for ZAP datetrack delete mode
463: --
464: if p_datetrack_mode = hr_api.g_zap then
465: --
466: pay_evc_shd.lck(p_effective_date => l_effective_date
467: ,p_datetrack_mode => p_datetrack_mode
468: ,p_event_value_change_id => p_event_value_change_id
505: --
506: -- When in validation only mode raise the Validate_Enabled exception
507: --
508: if p_validate then
509: raise hr_api.validate_enabled;
510: end if;
511: --
512: -- Set out parameters
513: --
516: p_effective_end_date := l_effective_end_date;
517: --
518: hr_utility.set_location(l_proc, 70);
519: exception
520: when hr_api.validate_enabled then
521: --
522: -- As the Validate_Enabled exception has been raised
523: -- we must rollback to the savepoint
524: --