DBA Data[Home] [Help]

APPS.PAY_EVENT_QUALIFIERS_API dependencies on HR_API

Line 110: when hr_api.cannot_find_prog_unit then

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

Line 111: hr_api.cannot_find_prog_unit_error

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;

Line 174: when hr_api.cannot_find_prog_unit then

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

Line 175: hr_api.cannot_find_prog_unit_error

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;

Line 189: raise hr_api.validate_enabled;

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: --

Line 201: when hr_api.validate_enabled then

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: --

Line 245: ,p_legislation_code in varchar2 default hr_api.g_varchar2

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

Line 246: ,p_business_group_id in number default hr_api.g_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
250: ,p_entry_qualification in varchar2 default hr_api.g_varchar2

Line 247: ,p_comparison_column 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

Line 248: ,p_qualifier_definition 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

Line 249: ,p_qualifier_where_clause 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

Line 250: ,p_entry_qualification 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
254: ,p_effective_end_date out nocopy date

Line 251: ,p_assignment_qualification in varchar2 default hr_api.g_varchar2

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

Line 252: ,p_multi_event_sql 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
256: --

Line 308: when hr_api.cannot_find_prog_unit then

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

Line 309: hr_api.cannot_find_prog_unit_error

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;

Line 366: when hr_api.cannot_find_prog_unit then

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

Line 367: hr_api.cannot_find_prog_unit_error

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;

Line 377: raise hr_api.validate_enabled;

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: --

Line 388: when hr_api.validate_enabled then

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: --

Line 426: ,p_business_group_id in number default hr_api.g_number

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

Line 427: ,p_legislation_code in varchar2 default hr_api.g_varchar2

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: --

Line 470: when hr_api.cannot_find_prog_unit then

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

Line 471: hr_api.cannot_find_prog_unit_error

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;

Line 485: if p_datetrack_delete_mode = hr_api.g_zap then

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

Line 530: raise hr_api.validate_enabled;

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: --

Line 541: when hr_api.validate_enabled then

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: --