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_RFI_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 112: When hr_api.check_integrity_violated Then

108: End If;
109: --
110: hr_utility.set_location(' Leaving:'||l_proc, 15);
111: Exception
112: When hr_api.check_integrity_violated Then
113: -- A check constraint has been violated
114: pay_rfi_shd.g_api_dml := false; -- Unset the api dml status
115: pay_rfi_shd.constraint_error
116: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

112: When hr_api.check_integrity_violated Then
113: -- A check constraint has been violated
114: pay_rfi_shd.g_api_dml := false; -- Unset the api dml status
115: pay_rfi_shd.constraint_error
116: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
117: When hr_api.unique_integrity_violated Then
118: -- Unique integrity has been violated
119: pay_rfi_shd.g_api_dml := false; -- Unset the api dml status
120: pay_rfi_shd.constraint_error

Line 117: When hr_api.unique_integrity_violated Then

113: -- A check constraint has been violated
114: pay_rfi_shd.g_api_dml := false; -- Unset the api dml status
115: pay_rfi_shd.constraint_error
116: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
117: When hr_api.unique_integrity_violated Then
118: -- Unique integrity has been violated
119: pay_rfi_shd.g_api_dml := false; -- Unset the api dml status
120: pay_rfi_shd.constraint_error
121: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

117: When hr_api.unique_integrity_violated Then
118: -- Unique integrity has been violated
119: pay_rfi_shd.g_api_dml := false; -- Unset the api dml status
120: pay_rfi_shd.constraint_error
121: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
122: When Others Then
123: pay_rfi_shd.g_api_dml := false; -- Unset the api dml status
124: Raise;
125: End dt_update_dml;

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

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

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

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

Line 438: If (p_rec.report_type = hr_api.g_varchar2) then

434: -- p_rec plsql record structure
435: -- to see if a system default is being used. If a system default
436: -- is being used then we must set to the 'current' argument value.
437: --
438: If (p_rec.report_type = hr_api.g_varchar2) then
439: p_rec.report_type :=
440: pay_rfi_shd.g_old_rec.report_type;
441: End If;
442: If (p_rec.report_qualifier = hr_api.g_varchar2) then

Line 442: If (p_rec.report_qualifier = hr_api.g_varchar2) then

438: If (p_rec.report_type = hr_api.g_varchar2) then
439: p_rec.report_type :=
440: pay_rfi_shd.g_old_rec.report_type;
441: End If;
442: If (p_rec.report_qualifier = hr_api.g_varchar2) then
443: p_rec.report_qualifier :=
444: pay_rfi_shd.g_old_rec.report_qualifier;
445: End If;
446: If (p_rec.report_category = hr_api.g_varchar2) then

Line 446: If (p_rec.report_category = hr_api.g_varchar2) then

442: If (p_rec.report_qualifier = hr_api.g_varchar2) then
443: p_rec.report_qualifier :=
444: pay_rfi_shd.g_old_rec.report_qualifier;
445: End If;
446: If (p_rec.report_category = hr_api.g_varchar2) then
447: p_rec.report_category :=
448: pay_rfi_shd.g_old_rec.report_category;
449: End If;
450: If (p_rec.user_entity_id = hr_api.g_number) then

Line 450: If (p_rec.user_entity_id = hr_api.g_number) then

446: If (p_rec.report_category = hr_api.g_varchar2) then
447: p_rec.report_category :=
448: pay_rfi_shd.g_old_rec.report_category;
449: End If;
450: If (p_rec.user_entity_id = hr_api.g_number) then
451: p_rec.user_entity_id :=
452: pay_rfi_shd.g_old_rec.user_entity_id;
453: End If;
454: If (p_rec.archive_type = hr_api.g_varchar2) then

Line 454: If (p_rec.archive_type = hr_api.g_varchar2) then

450: If (p_rec.user_entity_id = hr_api.g_number) then
451: p_rec.user_entity_id :=
452: pay_rfi_shd.g_old_rec.user_entity_id;
453: End If;
454: If (p_rec.archive_type = hr_api.g_varchar2) then
455: p_rec.archive_type :=
456: pay_rfi_shd.g_old_rec.archive_type;
457: End If;
458: If (p_rec.updatable_flag = hr_api.g_varchar2) then

Line 458: If (p_rec.updatable_flag = hr_api.g_varchar2) then

454: If (p_rec.archive_type = hr_api.g_varchar2) then
455: p_rec.archive_type :=
456: pay_rfi_shd.g_old_rec.archive_type;
457: End If;
458: If (p_rec.updatable_flag = hr_api.g_varchar2) then
459: p_rec.updatable_flag :=
460: pay_rfi_shd.g_old_rec.updatable_flag;
461: End If;
462: If (p_rec.display_sequence = hr_api.g_number) then

Line 462: If (p_rec.display_sequence = hr_api.g_number) then

458: If (p_rec.updatable_flag = hr_api.g_varchar2) then
459: p_rec.updatable_flag :=
460: pay_rfi_shd.g_old_rec.updatable_flag;
461: End If;
462: If (p_rec.display_sequence = hr_api.g_number) then
463: p_rec.display_sequence :=
464: pay_rfi_shd.g_old_rec.display_sequence;
465: End If;
466: --

Line 561: ,p_report_type in varchar2 default hr_api.g_varchar2

557: (p_effective_date in date
558: ,p_datetrack_mode in varchar2
559: ,p_report_format_item_id in number
560: ,p_object_version_number in out nocopy number
561: ,p_report_type in varchar2 default hr_api.g_varchar2
562: ,p_report_qualifier in varchar2 default hr_api.g_varchar2
563: ,p_report_category in varchar2 default hr_api.g_varchar2
564: ,p_user_entity_id in number default hr_api.g_number
565: ,p_archive_type in varchar2 default hr_api.g_varchar2

Line 562: ,p_report_qualifier in varchar2 default hr_api.g_varchar2

558: ,p_datetrack_mode in varchar2
559: ,p_report_format_item_id in number
560: ,p_object_version_number in out nocopy number
561: ,p_report_type in varchar2 default hr_api.g_varchar2
562: ,p_report_qualifier in varchar2 default hr_api.g_varchar2
563: ,p_report_category in varchar2 default hr_api.g_varchar2
564: ,p_user_entity_id in number default hr_api.g_number
565: ,p_archive_type in varchar2 default hr_api.g_varchar2
566: ,p_updatable_flag in varchar2 default hr_api.g_varchar2

Line 563: ,p_report_category in varchar2 default hr_api.g_varchar2

559: ,p_report_format_item_id in number
560: ,p_object_version_number in out nocopy number
561: ,p_report_type in varchar2 default hr_api.g_varchar2
562: ,p_report_qualifier in varchar2 default hr_api.g_varchar2
563: ,p_report_category in varchar2 default hr_api.g_varchar2
564: ,p_user_entity_id in number default hr_api.g_number
565: ,p_archive_type in varchar2 default hr_api.g_varchar2
566: ,p_updatable_flag in varchar2 default hr_api.g_varchar2
567: ,p_display_sequence in number default hr_api.g_number

Line 564: ,p_user_entity_id in number default hr_api.g_number

560: ,p_object_version_number in out nocopy number
561: ,p_report_type in varchar2 default hr_api.g_varchar2
562: ,p_report_qualifier in varchar2 default hr_api.g_varchar2
563: ,p_report_category in varchar2 default hr_api.g_varchar2
564: ,p_user_entity_id in number default hr_api.g_number
565: ,p_archive_type in varchar2 default hr_api.g_varchar2
566: ,p_updatable_flag in varchar2 default hr_api.g_varchar2
567: ,p_display_sequence in number default hr_api.g_number
568: ,p_effective_start_date out nocopy date

Line 565: ,p_archive_type in varchar2 default hr_api.g_varchar2

561: ,p_report_type in varchar2 default hr_api.g_varchar2
562: ,p_report_qualifier in varchar2 default hr_api.g_varchar2
563: ,p_report_category in varchar2 default hr_api.g_varchar2
564: ,p_user_entity_id in number default hr_api.g_number
565: ,p_archive_type in varchar2 default hr_api.g_varchar2
566: ,p_updatable_flag in varchar2 default hr_api.g_varchar2
567: ,p_display_sequence in number default hr_api.g_number
568: ,p_effective_start_date out nocopy date
569: ,p_effective_end_date out nocopy date

Line 566: ,p_updatable_flag in varchar2 default hr_api.g_varchar2

562: ,p_report_qualifier in varchar2 default hr_api.g_varchar2
563: ,p_report_category in varchar2 default hr_api.g_varchar2
564: ,p_user_entity_id in number default hr_api.g_number
565: ,p_archive_type in varchar2 default hr_api.g_varchar2
566: ,p_updatable_flag in varchar2 default hr_api.g_varchar2
567: ,p_display_sequence in number default hr_api.g_number
568: ,p_effective_start_date out nocopy date
569: ,p_effective_end_date out nocopy date
570: ) is

Line 567: ,p_display_sequence in number default hr_api.g_number

563: ,p_report_category in varchar2 default hr_api.g_varchar2
564: ,p_user_entity_id in number default hr_api.g_number
565: ,p_archive_type in varchar2 default hr_api.g_varchar2
566: ,p_updatable_flag in varchar2 default hr_api.g_varchar2
567: ,p_display_sequence in number default hr_api.g_number
568: ,p_effective_start_date out nocopy date
569: ,p_effective_end_date out nocopy date
570: ) is
571: --