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_ETU_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 111: When hr_api.check_integrity_violated Then

107: End If;
108: --
109: hr_utility.set_location(' Leaving:'||l_proc, 15);
110: Exception
111: When hr_api.check_integrity_violated Then
112: -- A check constraint has been violated
113: --
114: pay_etu_shd.constraint_error
115: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 115: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

111: When hr_api.check_integrity_violated Then
112: -- A check constraint has been violated
113: --
114: pay_etu_shd.constraint_error
115: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
116: When hr_api.unique_integrity_violated Then
117: -- Unique integrity has been violated
118: --
119: pay_etu_shd.constraint_error

Line 116: When hr_api.unique_integrity_violated Then

112: -- A check constraint has been violated
113: --
114: pay_etu_shd.constraint_error
115: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
116: When hr_api.unique_integrity_violated Then
117: -- Unique integrity has been violated
118: --
119: pay_etu_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.unique_integrity_violated Then
117: -- Unique integrity has been violated
118: --
119: pay_etu_shd.constraint_error
120: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
121: When Others Then
122: --
123: Raise;
124: End dt_update_dml;

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

233: l_dummy_version_number number;
234: --
235: Begin
236: hr_utility.set_location('Entering:'||l_proc, 5);
237: If (p_datetrack_mode <> hr_api.g_correction) then
238: --
239: -- Update the current effective end date
240: --
241: pay_etu_shd.upd_effective_end_date

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

246: ,p_validation_end_date => p_validation_end_date
247: ,p_object_version_number => l_dummy_version_number
248: );
249: --
250: If (p_datetrack_mode = hr_api.g_update_override) then
251: --
252: -- As the datetrack mode is 'UPDATE_OVERRIDE' then we must
253: -- delete any future rows
254: --

Line 425: when hr_api.cannot_find_prog_unit then

421: );
422: --
423: exception
424: --
425: when hr_api.cannot_find_prog_unit then
426: --
427: hr_api.cannot_find_prog_unit_error
428: (p_module_name => 'PAY_ELEMENT_TYPE_USAGES_F'
429: ,p_hook_type => 'AU');

Line 427: hr_api.cannot_find_prog_unit_error

423: exception
424: --
425: when hr_api.cannot_find_prog_unit then
426: --
427: hr_api.cannot_find_prog_unit_error
428: (p_module_name => 'PAY_ELEMENT_TYPE_USAGES_F'
429: ,p_hook_type => 'AU');
430: --
431: end;

Line 490: If (p_rec.run_type_id = hr_api.g_number) then

486: -- p_rec plsql record structure
487: -- to see if a system default is being used. If a system default
488: -- is being used then we must set to the 'current' argument value.
489: --
490: If (p_rec.run_type_id = hr_api.g_number) then
491: p_rec.run_type_id :=
492: pay_etu_shd.g_old_rec.run_type_id;
493: End If;
494: If (p_rec.element_type_id = hr_api.g_number) then

Line 494: If (p_rec.element_type_id = hr_api.g_number) then

490: If (p_rec.run_type_id = hr_api.g_number) then
491: p_rec.run_type_id :=
492: pay_etu_shd.g_old_rec.run_type_id;
493: End If;
494: If (p_rec.element_type_id = hr_api.g_number) then
495: p_rec.element_type_id :=
496: pay_etu_shd.g_old_rec.element_type_id;
497: End If;
498: If (p_rec.inclusion_flag = hr_api.g_varchar2) then

Line 498: If (p_rec.inclusion_flag = hr_api.g_varchar2) then

494: If (p_rec.element_type_id = hr_api.g_number) then
495: p_rec.element_type_id :=
496: pay_etu_shd.g_old_rec.element_type_id;
497: End If;
498: If (p_rec.inclusion_flag = hr_api.g_varchar2) then
499: p_rec.inclusion_flag :=
500: pay_etu_shd.g_old_rec.inclusion_flag;
501: End If;
502: If (p_rec.business_group_id = hr_api.g_number) then

Line 502: If (p_rec.business_group_id = hr_api.g_number) then

498: If (p_rec.inclusion_flag = hr_api.g_varchar2) then
499: p_rec.inclusion_flag :=
500: pay_etu_shd.g_old_rec.inclusion_flag;
501: End If;
502: If (p_rec.business_group_id = hr_api.g_number) then
503: p_rec.business_group_id :=
504: pay_etu_shd.g_old_rec.business_group_id;
505: End If;
506: If (p_rec.legislation_code = hr_api.g_varchar2) then

Line 506: If (p_rec.legislation_code = hr_api.g_varchar2) then

502: If (p_rec.business_group_id = hr_api.g_number) then
503: p_rec.business_group_id :=
504: pay_etu_shd.g_old_rec.business_group_id;
505: End If;
506: If (p_rec.legislation_code = hr_api.g_varchar2) then
507: p_rec.legislation_code :=
508: pay_etu_shd.g_old_rec.legislation_code;
509: End If;
510: If (p_rec.usage_type = hr_api.g_varchar2) then

Line 510: If (p_rec.usage_type = hr_api.g_varchar2) then

506: If (p_rec.legislation_code = hr_api.g_varchar2) then
507: p_rec.legislation_code :=
508: pay_etu_shd.g_old_rec.legislation_code;
509: End If;
510: If (p_rec.usage_type = hr_api.g_varchar2) then
511: p_rec.usage_type :=
512: pay_etu_shd.g_old_rec.usage_type;
513: End If;
514: --

Line 601: ,p_inclusion_flag in varchar2 default hr_api.g_varchar2

597: -- ----------------------------------------------------------------------------
598: Procedure upd
599: (p_effective_date in date
600: ,p_datetrack_mode in varchar2
601: ,p_inclusion_flag in varchar2 default hr_api.g_varchar2
602: ,p_element_type_usage_id in number
603: ,p_usage_type in varchar2 default hr_api.g_varchar2
604: ,p_object_version_number in out nocopy number
605: ,p_effective_start_date out nocopy date

Line 603: ,p_usage_type in varchar2 default hr_api.g_varchar2

599: (p_effective_date in date
600: ,p_datetrack_mode in varchar2
601: ,p_inclusion_flag in varchar2 default hr_api.g_varchar2
602: ,p_element_type_usage_id in number
603: ,p_usage_type in varchar2 default hr_api.g_varchar2
604: ,p_object_version_number in out nocopy number
605: ,p_effective_start_date out nocopy date
606: ,p_effective_end_date out nocopy date
607: ) is

Line 620: (hr_api.g_number

616: -- l_rec structure.
617: --
618: l_rec :=
619: pay_etu_shd.convert_args
620: (hr_api.g_number
621: ,hr_api.g_number
622: ,p_inclusion_flag
623: ,null
624: ,null

Line 621: ,hr_api.g_number

617: --
618: l_rec :=
619: pay_etu_shd.convert_args
620: (hr_api.g_number
621: ,hr_api.g_number
622: ,p_inclusion_flag
623: ,null
624: ,null
625: ,p_object_version_number

Line 627: ,hr_api.g_number

623: ,null
624: ,null
625: ,p_object_version_number
626: ,p_element_type_usage_id
627: ,hr_api.g_number
628: ,hr_api.g_varchar2
629: ,p_usage_type
630: );
631: --

Line 628: ,hr_api.g_varchar2

624: ,null
625: ,p_object_version_number
626: ,p_element_type_usage_id
627: ,hr_api.g_number
628: ,hr_api.g_varchar2
629: ,p_usage_type
630: );
631: --
632: -- Having converted the arguments into the