66: --
67: Begin
68: hr_utility.set_location('Entering:'||l_proc, 5);
69: --
70: If (p_datetrack_mode = hr_api.g_correction) then
71: hr_utility.set_location(l_proc, 10);
72: --
73: -- Because we are updating a row we must get the next object
74: -- version number.
112: End If;
113: --
114: hr_utility.set_location(' Leaving:'||l_proc, 15);
115: Exception
116: When hr_api.check_integrity_violated Then
117: -- A check constraint has been violated
118: --
119: pay_evq_shd.constraint_error
120: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
116: When hr_api.check_integrity_violated Then
117: -- A check constraint has been violated
118: --
119: pay_evq_shd.constraint_error
120: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
121: When hr_api.unique_integrity_violated Then
122: -- Unique integrity has been violated
123: --
124: pay_evq_shd.constraint_error
117: -- A check constraint has been violated
118: --
119: pay_evq_shd.constraint_error
120: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
121: When hr_api.unique_integrity_violated Then
122: -- Unique integrity has been violated
123: --
124: pay_evq_shd.constraint_error
125: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
121: When hr_api.unique_integrity_violated Then
122: -- Unique integrity has been violated
123: --
124: pay_evq_shd.constraint_error
125: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
126: When Others Then
127: --
128: Raise;
129: End dt_update_dml;
238: l_dummy_version_number number;
239: --
240: Begin
241: hr_utility.set_location('Entering:'||l_proc, 5);
242: If (p_datetrack_mode <> hr_api.g_correction) then
243: --
244: -- Update the current effective end date
245: --
246: pay_evq_shd.upd_effective_end_date
251: ,p_validation_end_date => p_validation_end_date
252: ,p_object_version_number => l_dummy_version_number
253: );
254: --
255: If (p_datetrack_mode = hr_api.g_update_override) then
256: --
257: -- As the datetrack mode is 'UPDATE_OVERRIDE' then we must
258: -- delete any future rows
259: --
443: );
444: --
445: exception
446: --
447: when hr_api.cannot_find_prog_unit then
448: --
449: hr_api.cannot_find_prog_unit_error
450: (p_module_name => 'PAY_EVENT_QUALIFIERS_F'
451: ,p_hook_type => 'AU');
445: exception
446: --
447: when hr_api.cannot_find_prog_unit then
448: --
449: hr_api.cannot_find_prog_unit_error
450: (p_module_name => 'PAY_EVENT_QUALIFIERS_F'
451: ,p_hook_type => 'AU');
452: --
453: end;
508: -- p_rec plsql record structure
509: -- to see if a system default is being used. If a system default
510: -- is being used then we must set to the 'current' argument value.
511: --
512: If (p_rec.dated_table_id = hr_api.g_number) then
513: p_rec.dated_table_id :=
514: pay_evq_shd.g_old_rec.dated_table_id;
515: End If;
516: If (p_rec.column_name = hr_api.g_varchar2) then
512: If (p_rec.dated_table_id = hr_api.g_number) then
513: p_rec.dated_table_id :=
514: pay_evq_shd.g_old_rec.dated_table_id;
515: End If;
516: If (p_rec.column_name = hr_api.g_varchar2) then
517: p_rec.column_name :=
518: pay_evq_shd.g_old_rec.column_name;
519: End If;
520: If (p_rec.qualifier_name = hr_api.g_varchar2) then
516: If (p_rec.column_name = hr_api.g_varchar2) then
517: p_rec.column_name :=
518: pay_evq_shd.g_old_rec.column_name;
519: End If;
520: If (p_rec.qualifier_name = hr_api.g_varchar2) then
521: p_rec.qualifier_name :=
522: pay_evq_shd.g_old_rec.qualifier_name;
523: End If;
524: If (p_rec.legislation_code = hr_api.g_varchar2) then
520: If (p_rec.qualifier_name = hr_api.g_varchar2) then
521: p_rec.qualifier_name :=
522: pay_evq_shd.g_old_rec.qualifier_name;
523: End If;
524: If (p_rec.legislation_code = hr_api.g_varchar2) then
525: p_rec.legislation_code :=
526: pay_evq_shd.g_old_rec.legislation_code;
527: End If;
528: If (p_rec.business_group_id = hr_api.g_number) then
524: If (p_rec.legislation_code = hr_api.g_varchar2) then
525: p_rec.legislation_code :=
526: pay_evq_shd.g_old_rec.legislation_code;
527: End If;
528: If (p_rec.business_group_id = hr_api.g_number) then
529: p_rec.business_group_id :=
530: pay_evq_shd.g_old_rec.business_group_id;
531: End If;
532: If (p_rec.comparison_column = hr_api.g_varchar2) then
528: If (p_rec.business_group_id = hr_api.g_number) then
529: p_rec.business_group_id :=
530: pay_evq_shd.g_old_rec.business_group_id;
531: End If;
532: If (p_rec.comparison_column = hr_api.g_varchar2) then
533: p_rec.comparison_column :=
534: pay_evq_shd.g_old_rec.comparison_column;
535: End If;
536: If (p_rec.qualifier_definition = hr_api.g_varchar2) then
532: If (p_rec.comparison_column = hr_api.g_varchar2) then
533: p_rec.comparison_column :=
534: pay_evq_shd.g_old_rec.comparison_column;
535: End If;
536: If (p_rec.qualifier_definition = hr_api.g_varchar2) then
537: p_rec.qualifier_definition :=
538: pay_evq_shd.g_old_rec.qualifier_definition;
539: End If;
540: If (p_rec.qualifier_where_clause = hr_api.g_varchar2) then
536: If (p_rec.qualifier_definition = hr_api.g_varchar2) then
537: p_rec.qualifier_definition :=
538: pay_evq_shd.g_old_rec.qualifier_definition;
539: End If;
540: If (p_rec.qualifier_where_clause = hr_api.g_varchar2) then
541: p_rec.qualifier_where_clause :=
542: pay_evq_shd.g_old_rec.qualifier_where_clause;
543: End If;
544: If (p_rec.entry_qualification = hr_api.g_varchar2) then
540: If (p_rec.qualifier_where_clause = hr_api.g_varchar2) then
541: p_rec.qualifier_where_clause :=
542: pay_evq_shd.g_old_rec.qualifier_where_clause;
543: End If;
544: If (p_rec.entry_qualification = hr_api.g_varchar2) then
545: p_rec.entry_qualification :=
546: pay_evq_shd.g_old_rec.entry_qualification;
547: End If;
548: If (p_rec.assignment_qualification = hr_api.g_varchar2) then
544: If (p_rec.entry_qualification = hr_api.g_varchar2) then
545: p_rec.entry_qualification :=
546: pay_evq_shd.g_old_rec.entry_qualification;
547: End If;
548: If (p_rec.assignment_qualification = hr_api.g_varchar2) then
549: p_rec.assignment_qualification :=
550: pay_evq_shd.g_old_rec.assignment_qualification;
551: End If;
552: If (p_rec.multi_event_sql = hr_api.g_varchar2) then
548: If (p_rec.assignment_qualification = hr_api.g_varchar2) then
549: p_rec.assignment_qualification :=
550: pay_evq_shd.g_old_rec.assignment_qualification;
551: End If;
552: If (p_rec.multi_event_sql = hr_api.g_varchar2) then
553: p_rec.multi_event_sql :=
554: pay_evq_shd.g_old_rec.multi_event_sql;
555: End If;
556: --
647: (p_effective_date in date
648: ,p_datetrack_mode in varchar2
649: ,p_event_qualifier_id in number
650: ,p_object_version_number in out nocopy number
651: ,p_comparison_column in varchar2 default hr_api.g_varchar2
652: ,p_qualifier_definition in varchar2 default hr_api.g_varchar2
653: ,p_qualifier_where_clause in varchar2 default hr_api.g_varchar2
654: ,p_entry_qualification in varchar2 default hr_api.g_varchar2
655: ,p_assignment_qualification in varchar2 default hr_api.g_varchar2
648: ,p_datetrack_mode in varchar2
649: ,p_event_qualifier_id in number
650: ,p_object_version_number in out nocopy number
651: ,p_comparison_column in varchar2 default hr_api.g_varchar2
652: ,p_qualifier_definition in varchar2 default hr_api.g_varchar2
653: ,p_qualifier_where_clause in varchar2 default hr_api.g_varchar2
654: ,p_entry_qualification in varchar2 default hr_api.g_varchar2
655: ,p_assignment_qualification in varchar2 default hr_api.g_varchar2
656: ,p_multi_event_sql in varchar2 default hr_api.g_varchar2
649: ,p_event_qualifier_id in number
650: ,p_object_version_number in out nocopy number
651: ,p_comparison_column in varchar2 default hr_api.g_varchar2
652: ,p_qualifier_definition in varchar2 default hr_api.g_varchar2
653: ,p_qualifier_where_clause in varchar2 default hr_api.g_varchar2
654: ,p_entry_qualification in varchar2 default hr_api.g_varchar2
655: ,p_assignment_qualification in varchar2 default hr_api.g_varchar2
656: ,p_multi_event_sql in varchar2 default hr_api.g_varchar2
657: ,p_effective_start_date out nocopy date
650: ,p_object_version_number in out nocopy number
651: ,p_comparison_column in varchar2 default hr_api.g_varchar2
652: ,p_qualifier_definition in varchar2 default hr_api.g_varchar2
653: ,p_qualifier_where_clause in varchar2 default hr_api.g_varchar2
654: ,p_entry_qualification in varchar2 default hr_api.g_varchar2
655: ,p_assignment_qualification in varchar2 default hr_api.g_varchar2
656: ,p_multi_event_sql in varchar2 default hr_api.g_varchar2
657: ,p_effective_start_date out nocopy date
658: ,p_effective_end_date out nocopy date
651: ,p_comparison_column in varchar2 default hr_api.g_varchar2
652: ,p_qualifier_definition in varchar2 default hr_api.g_varchar2
653: ,p_qualifier_where_clause in varchar2 default hr_api.g_varchar2
654: ,p_entry_qualification in varchar2 default hr_api.g_varchar2
655: ,p_assignment_qualification in varchar2 default hr_api.g_varchar2
656: ,p_multi_event_sql in varchar2 default hr_api.g_varchar2
657: ,p_effective_start_date out nocopy date
658: ,p_effective_end_date out nocopy date
659: ) is
652: ,p_qualifier_definition in varchar2 default hr_api.g_varchar2
653: ,p_qualifier_where_clause in varchar2 default hr_api.g_varchar2
654: ,p_entry_qualification in varchar2 default hr_api.g_varchar2
655: ,p_assignment_qualification in varchar2 default hr_api.g_varchar2
656: ,p_multi_event_sql in varchar2 default hr_api.g_varchar2
657: ,p_effective_start_date out nocopy date
658: ,p_effective_end_date out nocopy date
659: ) is
660: --
671: pay_evq_shd.convert_args
672: (p_event_qualifier_id
673: ,null
674: ,null
675: ,hr_api.g_number
676: ,hr_api.g_varchar2
677: ,hr_api.g_varchar2
678: ,hr_api.g_varchar2
679: ,hr_api.g_number
672: (p_event_qualifier_id
673: ,null
674: ,null
675: ,hr_api.g_number
676: ,hr_api.g_varchar2
677: ,hr_api.g_varchar2
678: ,hr_api.g_varchar2
679: ,hr_api.g_number
680: ,p_comparison_column
673: ,null
674: ,null
675: ,hr_api.g_number
676: ,hr_api.g_varchar2
677: ,hr_api.g_varchar2
678: ,hr_api.g_varchar2
679: ,hr_api.g_number
680: ,p_comparison_column
681: ,p_qualifier_definition
674: ,null
675: ,hr_api.g_number
676: ,hr_api.g_varchar2
677: ,hr_api.g_varchar2
678: ,hr_api.g_varchar2
679: ,hr_api.g_number
680: ,p_comparison_column
681: ,p_qualifier_definition
682: ,p_qualifier_where_clause
675: ,hr_api.g_number
676: ,hr_api.g_varchar2
677: ,hr_api.g_varchar2
678: ,hr_api.g_varchar2
679: ,hr_api.g_number
680: ,p_comparison_column
681: ,p_qualifier_definition
682: ,p_qualifier_where_clause
683: ,p_entry_qualification