eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_EVQ_UPD dependencies on HR_API

Line 70: If (p_datetrack_mode = hr_api.g_correction) then

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.

Line 116: When hr_api.check_integrity_violated Then

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

Line 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

Line 121: When hr_api.unique_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
125: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 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;

Line 242: If (p_datetrack_mode <> hr_api.g_correction) then

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

Line 255: If (p_datetrack_mode = hr_api.g_update_override) then

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

Line 447: when hr_api.cannot_find_prog_unit then

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

Line 449: hr_api.cannot_find_prog_unit_error

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;

Line 512: If (p_rec.dated_table_id = hr_api.g_number) then

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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

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

Line 651: ,p_comparison_column in varchar2 default hr_api.g_varchar2

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

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

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

Line 654: ,p_entry_qualification in varchar2 default hr_api.g_varchar2

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

Line 655: ,p_assignment_qualification in varchar2 default hr_api.g_varchar2

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

Line 656: ,p_multi_event_sql 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
660: --

Line 675: ,hr_api.g_number

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

Line 676: ,hr_api.g_varchar2

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

Line 677: ,hr_api.g_varchar2

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

Line 678: ,hr_api.g_varchar2

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

Line 679: ,hr_api.g_number

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