106: ,p_multi_event_sql => p_multi_event_sql
107: );
108:
109: exception
110: when hr_api.cannot_find_prog_unit then
111: hr_api.cannot_find_prog_unit_error
112: (p_module_name => 'create_event_qualifier'
113: ,p_hook_type => 'BP'
114: );
107: );
108:
109: exception
110: when hr_api.cannot_find_prog_unit then
111: hr_api.cannot_find_prog_unit_error
112: (p_module_name => 'create_event_qualifier'
113: ,p_hook_type => 'BP'
114: );
115: end;
170: ,p_effective_start_date => l_effective_start_date
171: ,p_effective_end_date => l_effective_end_date
172: );
173: exception
174: when hr_api.cannot_find_prog_unit then
175: hr_api.cannot_find_prog_unit_error
176: (p_module_name => 'create_event_qualifier'
177: ,p_hook_type => 'AP'
178: );
171: ,p_effective_end_date => l_effective_end_date
172: );
173: exception
174: when hr_api.cannot_find_prog_unit then
175: hr_api.cannot_find_prog_unit_error
176: (p_module_name => 'create_event_qualifier'
177: ,p_hook_type => 'AP'
178: );
179: end;
185: --
186: -- When in validation only mode raise the Validate_Enabled exception
187: --
188: if p_validate then
189: raise hr_api.validate_enabled;
190: end if;
191: --
192: -- Set all output arguments
193: --
197: p_object_version_number := l_object_version_number;
198: --
199: hr_utility.set_location(' Leaving:'||l_proc, 70);
200: exception
201: when hr_api.validate_enabled then
202: --
203: -- As the Validate_Enabled exception has been raised
204: -- we must rollback to the savepoint
205: --
241: ,p_dated_table_id in number
242: ,p_column_name in varchar2
243: ,p_qualifier_name in varchar2
244: ,p_object_version_number in out nocopy number
245: ,p_legislation_code in varchar2 default hr_api.g_varchar2
246: ,p_business_group_id in number default hr_api.g_number
247: ,p_comparison_column in varchar2 default hr_api.g_varchar2
248: ,p_qualifier_definition in varchar2 default hr_api.g_varchar2
249: ,p_qualifier_where_clause in varchar2 default hr_api.g_varchar2
242: ,p_column_name in varchar2
243: ,p_qualifier_name in varchar2
244: ,p_object_version_number in out nocopy number
245: ,p_legislation_code in varchar2 default hr_api.g_varchar2
246: ,p_business_group_id in number default hr_api.g_number
247: ,p_comparison_column in varchar2 default hr_api.g_varchar2
248: ,p_qualifier_definition in varchar2 default hr_api.g_varchar2
249: ,p_qualifier_where_clause in varchar2 default hr_api.g_varchar2
250: ,p_entry_qualification in varchar2 default hr_api.g_varchar2
243: ,p_qualifier_name in varchar2
244: ,p_object_version_number in out nocopy number
245: ,p_legislation_code in varchar2 default hr_api.g_varchar2
246: ,p_business_group_id in number default hr_api.g_number
247: ,p_comparison_column in varchar2 default hr_api.g_varchar2
248: ,p_qualifier_definition in varchar2 default hr_api.g_varchar2
249: ,p_qualifier_where_clause in varchar2 default hr_api.g_varchar2
250: ,p_entry_qualification in varchar2 default hr_api.g_varchar2
251: ,p_assignment_qualification in varchar2 default hr_api.g_varchar2
244: ,p_object_version_number in out nocopy number
245: ,p_legislation_code in varchar2 default hr_api.g_varchar2
246: ,p_business_group_id in number default hr_api.g_number
247: ,p_comparison_column in varchar2 default hr_api.g_varchar2
248: ,p_qualifier_definition in varchar2 default hr_api.g_varchar2
249: ,p_qualifier_where_clause in varchar2 default hr_api.g_varchar2
250: ,p_entry_qualification in varchar2 default hr_api.g_varchar2
251: ,p_assignment_qualification in varchar2 default hr_api.g_varchar2
252: ,p_multi_event_sql in varchar2 default hr_api.g_varchar2
245: ,p_legislation_code in varchar2 default hr_api.g_varchar2
246: ,p_business_group_id in number default hr_api.g_number
247: ,p_comparison_column in varchar2 default hr_api.g_varchar2
248: ,p_qualifier_definition in varchar2 default hr_api.g_varchar2
249: ,p_qualifier_where_clause in varchar2 default hr_api.g_varchar2
250: ,p_entry_qualification in varchar2 default hr_api.g_varchar2
251: ,p_assignment_qualification in varchar2 default hr_api.g_varchar2
252: ,p_multi_event_sql in varchar2 default hr_api.g_varchar2
253: ,p_effective_start_date out nocopy date
246: ,p_business_group_id in number default hr_api.g_number
247: ,p_comparison_column in varchar2 default hr_api.g_varchar2
248: ,p_qualifier_definition in varchar2 default hr_api.g_varchar2
249: ,p_qualifier_where_clause in varchar2 default hr_api.g_varchar2
250: ,p_entry_qualification in varchar2 default hr_api.g_varchar2
251: ,p_assignment_qualification in varchar2 default hr_api.g_varchar2
252: ,p_multi_event_sql in varchar2 default hr_api.g_varchar2
253: ,p_effective_start_date out nocopy date
254: ,p_effective_end_date out nocopy date
247: ,p_comparison_column in varchar2 default hr_api.g_varchar2
248: ,p_qualifier_definition in varchar2 default hr_api.g_varchar2
249: ,p_qualifier_where_clause in varchar2 default hr_api.g_varchar2
250: ,p_entry_qualification in varchar2 default hr_api.g_varchar2
251: ,p_assignment_qualification in varchar2 default hr_api.g_varchar2
252: ,p_multi_event_sql in varchar2 default hr_api.g_varchar2
253: ,p_effective_start_date out nocopy date
254: ,p_effective_end_date out nocopy date
255: ) is
248: ,p_qualifier_definition in varchar2 default hr_api.g_varchar2
249: ,p_qualifier_where_clause in varchar2 default hr_api.g_varchar2
250: ,p_entry_qualification in varchar2 default hr_api.g_varchar2
251: ,p_assignment_qualification in varchar2 default hr_api.g_varchar2
252: ,p_multi_event_sql in varchar2 default hr_api.g_varchar2
253: ,p_effective_start_date out nocopy date
254: ,p_effective_end_date out nocopy date
255: ) is
256: --
304: ,p_multi_event_sql => p_multi_event_sql
305: ,p_object_version_number => p_object_version_number
306: );
307: exception
308: when hr_api.cannot_find_prog_unit then
309: hr_api.cannot_find_prog_unit_error
310: (p_module_name => 'update_event_qualifier'
311: ,p_hook_type => 'BP'
312: );
305: ,p_object_version_number => p_object_version_number
306: );
307: exception
308: when hr_api.cannot_find_prog_unit then
309: hr_api.cannot_find_prog_unit_error
310: (p_module_name => 'update_event_qualifier'
311: ,p_hook_type => 'BP'
312: );
313: end;
362: ,p_effective_start_date => l_effective_start_date
363: ,p_effective_end_date => l_effective_end_date
364: );
365: exception
366: when hr_api.cannot_find_prog_unit then
367: hr_api.cannot_find_prog_unit_error
368: (p_module_name => 'update_event_qualifier_a'
369: ,p_hook_type => 'AP'
370: );
363: ,p_effective_end_date => l_effective_end_date
364: );
365: exception
366: when hr_api.cannot_find_prog_unit then
367: hr_api.cannot_find_prog_unit_error
368: (p_module_name => 'update_event_qualifier_a'
369: ,p_hook_type => 'AP'
370: );
371: end;
373: --
374: -- When in validation only mode raise the Validate_Enabled exception
375: --
376: if p_validate then
377: raise hr_api.validate_enabled;
378: end if;
379: --
380: -- Set all output arguments
381: --
384: p_object_version_number := p_object_version_number;
385: --
386: hr_utility.set_location(' Leaving:'||l_proc, 70);
387: exception
388: when hr_api.validate_enabled then
389: --
390: -- As the Validate_Enabled exception has been raised
391: -- we must rollback to the savepoint
392: --
422: ,p_effective_date in date
423: ,p_datetrack_delete_mode in varchar2
424: ,p_event_qualifier_id in number
425: ,p_object_version_number in out nocopy number
426: ,p_business_group_id in number default hr_api.g_number
427: ,p_legislation_code in varchar2 default hr_api.g_varchar2
428: ,p_effective_start_date out nocopy date
429: ,p_effective_end_date out nocopy date
430: ) is
423: ,p_datetrack_delete_mode in varchar2
424: ,p_event_qualifier_id in number
425: ,p_object_version_number in out nocopy number
426: ,p_business_group_id in number default hr_api.g_number
427: ,p_legislation_code in varchar2 default hr_api.g_varchar2
428: ,p_effective_start_date out nocopy date
429: ,p_effective_end_date out nocopy date
430: ) is
431: --
466: ,p_legislation_code => p_legislation_code
467: );
468:
469: exception
470: when hr_api.cannot_find_prog_unit then
471: hr_api.cannot_find_prog_unit_error
472: (p_module_name => 'delete_event_qualifier'
473: ,p_hook_type => 'BP'
474: );
467: );
468:
469: exception
470: when hr_api.cannot_find_prog_unit then
471: hr_api.cannot_find_prog_unit_error
472: (p_module_name => 'delete_event_qualifier'
473: ,p_hook_type => 'BP'
474: );
475: end;
481: hr_utility.set_location(l_proc, 30);
482: --
483: -- Lock the non-translated table row handler for ZAP datetrack delete mode
484: --
485: if p_datetrack_delete_mode = hr_api.g_zap then
486: --
487: pay_evq_shd.lck(p_effective_date => l_effective_date
488: ,p_datetrack_mode => p_datetrack_delete_mode
489: ,p_event_qualifier_id => p_event_qualifier_id
526: --
527: -- When in validation only mode raise the Validate_Enabled exception
528: --
529: if p_validate then
530: raise hr_api.validate_enabled;
531: end if;
532: --
533: -- Set out parameters
534: --
537: p_effective_end_date := l_effective_end_date;
538: --
539: hr_utility.set_location(l_proc, 70);
540: exception
541: when hr_api.validate_enabled then
542: --
543: -- As the Validate_Enabled exception has been raised
544: -- we must rollback to the savepoint
545: --