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_RFM_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 121: When hr_api.check_integrity_violated Then

117: End If;
118: --
119: hr_utility.set_location(' Leaving:'||l_proc, 15);
120: Exception
121: When hr_api.check_integrity_violated Then
122: -- A check constraint has been violated
123: pay_rfm_shd.g_api_dml := false; -- Unset the api dml status
124: pay_rfm_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.check_integrity_violated Then
122: -- A check constraint has been violated
123: pay_rfm_shd.g_api_dml := false; -- Unset the api dml status
124: pay_rfm_shd.constraint_error
125: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
126: When hr_api.unique_integrity_violated Then
127: -- Unique integrity has been violated
128: pay_rfm_shd.g_api_dml := false; -- Unset the api dml status
129: pay_rfm_shd.constraint_error

Line 126: When hr_api.unique_integrity_violated Then

122: -- A check constraint has been violated
123: pay_rfm_shd.g_api_dml := false; -- Unset the api dml status
124: pay_rfm_shd.constraint_error
125: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
126: When hr_api.unique_integrity_violated Then
127: -- Unique integrity has been violated
128: pay_rfm_shd.g_api_dml := false; -- Unset the api dml status
129: pay_rfm_shd.constraint_error
130: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

126: When hr_api.unique_integrity_violated Then
127: -- Unique integrity has been violated
128: pay_rfm_shd.g_api_dml := false; -- Unset the api dml status
129: pay_rfm_shd.constraint_error
130: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
131: When Others Then
132: pay_rfm_shd.g_api_dml := false; -- Unset the api dml status
133: Raise;
134: End dt_update_dml;

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

243: l_dummy_version_number number;
244: --
245: Begin
246: hr_utility.set_location('Entering:'||l_proc, 5);
247: If (p_datetrack_mode <> hr_api.g_correction) then
248: --
249: -- Update the current effective end date
250: --
251: pay_rfm_shd.upd_effective_end_date

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

256: ,p_validation_end_date => p_validation_end_date
257: ,p_object_version_number => l_dummy_version_number
258: );
259: --
260: If (p_datetrack_mode = hr_api.g_update_override) then
261: --
262: -- As the datetrack mode is 'UPDATE_OVERRIDE' then we must
263: -- delete any future rows
264: --

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

443: -- p_rec plsql record structure
444: -- to see if a system default is being used. If a system default
445: -- is being used then we must set to the 'current' argument value.
446: --
447: If (p_rec.report_type = hr_api.g_varchar2) then
448: p_rec.report_type :=
449: pay_rfm_shd.g_old_rec.report_type;
450: End If;
451: If (p_rec.report_qualifier = hr_api.g_varchar2) then

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

447: If (p_rec.report_type = hr_api.g_varchar2) then
448: p_rec.report_type :=
449: pay_rfm_shd.g_old_rec.report_type;
450: End If;
451: If (p_rec.report_qualifier = hr_api.g_varchar2) then
452: p_rec.report_qualifier :=
453: pay_rfm_shd.g_old_rec.report_qualifier;
454: End If;
455: If (p_rec.report_format = hr_api.g_varchar2) then

Line 455: If (p_rec.report_format = hr_api.g_varchar2) then

451: If (p_rec.report_qualifier = hr_api.g_varchar2) then
452: p_rec.report_qualifier :=
453: pay_rfm_shd.g_old_rec.report_qualifier;
454: End If;
455: If (p_rec.report_format = hr_api.g_varchar2) then
456: p_rec.report_format :=
457: pay_rfm_shd.g_old_rec.report_format;
458: End If;
459: If (p_rec.range_code = hr_api.g_varchar2) then

Line 459: If (p_rec.range_code = hr_api.g_varchar2) then

455: If (p_rec.report_format = hr_api.g_varchar2) then
456: p_rec.report_format :=
457: pay_rfm_shd.g_old_rec.report_format;
458: End If;
459: If (p_rec.range_code = hr_api.g_varchar2) then
460: p_rec.range_code :=
461: pay_rfm_shd.g_old_rec.range_code;
462: End If;
463: If (p_rec.assignment_action_code = hr_api.g_varchar2) then

Line 463: If (p_rec.assignment_action_code = hr_api.g_varchar2) then

459: If (p_rec.range_code = hr_api.g_varchar2) then
460: p_rec.range_code :=
461: pay_rfm_shd.g_old_rec.range_code;
462: End If;
463: If (p_rec.assignment_action_code = hr_api.g_varchar2) then
464: p_rec.assignment_action_code :=
465: pay_rfm_shd.g_old_rec.assignment_action_code;
466: End If;
467: If (p_rec.initialization_code = hr_api.g_varchar2) then

Line 467: If (p_rec.initialization_code = hr_api.g_varchar2) then

463: If (p_rec.assignment_action_code = hr_api.g_varchar2) then
464: p_rec.assignment_action_code :=
465: pay_rfm_shd.g_old_rec.assignment_action_code;
466: End If;
467: If (p_rec.initialization_code = hr_api.g_varchar2) then
468: p_rec.initialization_code :=
469: pay_rfm_shd.g_old_rec.initialization_code;
470: End If;
471: If (p_rec.archive_code = hr_api.g_varchar2) then

Line 471: If (p_rec.archive_code = hr_api.g_varchar2) then

467: If (p_rec.initialization_code = hr_api.g_varchar2) then
468: p_rec.initialization_code :=
469: pay_rfm_shd.g_old_rec.initialization_code;
470: End If;
471: If (p_rec.archive_code = hr_api.g_varchar2) then
472: p_rec.archive_code :=
473: pay_rfm_shd.g_old_rec.archive_code;
474: End If;
475: If (p_rec.magnetic_code = hr_api.g_varchar2) then

Line 475: If (p_rec.magnetic_code = hr_api.g_varchar2) then

471: If (p_rec.archive_code = hr_api.g_varchar2) then
472: p_rec.archive_code :=
473: pay_rfm_shd.g_old_rec.archive_code;
474: End If;
475: If (p_rec.magnetic_code = hr_api.g_varchar2) then
476: p_rec.magnetic_code :=
477: pay_rfm_shd.g_old_rec.magnetic_code;
478: End If;
479: If (p_rec.report_category = hr_api.g_varchar2) then

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

475: If (p_rec.magnetic_code = hr_api.g_varchar2) then
476: p_rec.magnetic_code :=
477: pay_rfm_shd.g_old_rec.magnetic_code;
478: End If;
479: If (p_rec.report_category = hr_api.g_varchar2) then
480: p_rec.report_category :=
481: pay_rfm_shd.g_old_rec.report_category;
482: End If;
483: If (p_rec.report_name = hr_api.g_varchar2) then

Line 483: If (p_rec.report_name = hr_api.g_varchar2) then

479: If (p_rec.report_category = hr_api.g_varchar2) then
480: p_rec.report_category :=
481: pay_rfm_shd.g_old_rec.report_category;
482: End If;
483: If (p_rec.report_name = hr_api.g_varchar2) then
484: p_rec.report_name :=
485: pay_rfm_shd.g_old_rec.report_name;
486: End If;
487: If (p_rec.sort_code = hr_api.g_varchar2) then

Line 487: If (p_rec.sort_code = hr_api.g_varchar2) then

483: If (p_rec.report_name = hr_api.g_varchar2) then
484: p_rec.report_name :=
485: pay_rfm_shd.g_old_rec.report_name;
486: End If;
487: If (p_rec.sort_code = hr_api.g_varchar2) then
488: p_rec.sort_code :=
489: pay_rfm_shd.g_old_rec.sort_code;
490: End If;
491: If (p_rec.updatable_flag = hr_api.g_varchar2) then

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

487: If (p_rec.sort_code = hr_api.g_varchar2) then
488: p_rec.sort_code :=
489: pay_rfm_shd.g_old_rec.sort_code;
490: End If;
491: If (p_rec.updatable_flag = hr_api.g_varchar2) then
492: p_rec.updatable_flag :=
493: pay_rfm_shd.g_old_rec.updatable_flag;
494: End If;
495: If (p_rec.deinitialization_code = hr_api.g_varchar2) then

Line 495: If (p_rec.deinitialization_code = hr_api.g_varchar2) then

491: If (p_rec.updatable_flag = hr_api.g_varchar2) then
492: p_rec.updatable_flag :=
493: pay_rfm_shd.g_old_rec.updatable_flag;
494: End If;
495: If (p_rec.deinitialization_code = hr_api.g_varchar2) then
496: p_rec.deinitialization_code :=
497: pay_rfm_shd.g_old_rec.deinitialization_code;
498: End If;
499: If (p_rec.business_group_id = hr_api.g_number) then

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

495: If (p_rec.deinitialization_code = hr_api.g_varchar2) then
496: p_rec.deinitialization_code :=
497: pay_rfm_shd.g_old_rec.deinitialization_code;
498: End If;
499: If (p_rec.business_group_id = hr_api.g_number) then
500: p_rec.business_group_id :=
501: pay_rfm_shd.g_old_rec.business_group_id;
502: End If;
503: If (p_rec.legislation_code = hr_api.g_varchar2) then

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

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

Line 507: If (p_rec.temporary_action_flag = hr_api.g_varchar2) then

503: If (p_rec.legislation_code = hr_api.g_varchar2) then
504: p_rec.legislation_code :=
505: pay_rfm_shd.g_old_rec.legislation_code;
506: End If;
507: If (p_rec.temporary_action_flag = hr_api.g_varchar2) then
508: p_rec.temporary_action_flag :=
509: pay_rfm_shd.g_old_rec.temporary_action_flag;
510: End If;
511: --

Line 606: ,p_report_type in varchar2 default hr_api.g_varchar2

602: (p_effective_date in date
603: ,p_datetrack_mode in varchar2
604: ,p_report_format_mapping_id in number
605: ,p_object_version_number in out nocopy number
606: ,p_report_type in varchar2 default hr_api.g_varchar2
607: ,p_report_qualifier in varchar2 default hr_api.g_varchar2
608: ,p_report_format in varchar2 default hr_api.g_varchar2
609: ,p_report_category in varchar2 default hr_api.g_varchar2
610: ,p_range_code in varchar2 default hr_api.g_varchar2

Line 607: ,p_report_qualifier in varchar2 default hr_api.g_varchar2

603: ,p_datetrack_mode in varchar2
604: ,p_report_format_mapping_id in number
605: ,p_object_version_number in out nocopy number
606: ,p_report_type in varchar2 default hr_api.g_varchar2
607: ,p_report_qualifier in varchar2 default hr_api.g_varchar2
608: ,p_report_format in varchar2 default hr_api.g_varchar2
609: ,p_report_category in varchar2 default hr_api.g_varchar2
610: ,p_range_code in varchar2 default hr_api.g_varchar2
611: ,p_assignment_action_code in varchar2 default hr_api.g_varchar2

Line 608: ,p_report_format in varchar2 default hr_api.g_varchar2

604: ,p_report_format_mapping_id in number
605: ,p_object_version_number in out nocopy number
606: ,p_report_type in varchar2 default hr_api.g_varchar2
607: ,p_report_qualifier in varchar2 default hr_api.g_varchar2
608: ,p_report_format in varchar2 default hr_api.g_varchar2
609: ,p_report_category in varchar2 default hr_api.g_varchar2
610: ,p_range_code in varchar2 default hr_api.g_varchar2
611: ,p_assignment_action_code in varchar2 default hr_api.g_varchar2
612: ,p_initialization_code in varchar2 default hr_api.g_varchar2

Line 609: ,p_report_category in varchar2 default hr_api.g_varchar2

605: ,p_object_version_number in out nocopy number
606: ,p_report_type in varchar2 default hr_api.g_varchar2
607: ,p_report_qualifier in varchar2 default hr_api.g_varchar2
608: ,p_report_format in varchar2 default hr_api.g_varchar2
609: ,p_report_category in varchar2 default hr_api.g_varchar2
610: ,p_range_code in varchar2 default hr_api.g_varchar2
611: ,p_assignment_action_code in varchar2 default hr_api.g_varchar2
612: ,p_initialization_code in varchar2 default hr_api.g_varchar2
613: ,p_archive_code in varchar2 default hr_api.g_varchar2

Line 610: ,p_range_code in varchar2 default hr_api.g_varchar2

606: ,p_report_type in varchar2 default hr_api.g_varchar2
607: ,p_report_qualifier in varchar2 default hr_api.g_varchar2
608: ,p_report_format in varchar2 default hr_api.g_varchar2
609: ,p_report_category in varchar2 default hr_api.g_varchar2
610: ,p_range_code in varchar2 default hr_api.g_varchar2
611: ,p_assignment_action_code in varchar2 default hr_api.g_varchar2
612: ,p_initialization_code in varchar2 default hr_api.g_varchar2
613: ,p_archive_code in varchar2 default hr_api.g_varchar2
614: ,p_magnetic_code in varchar2 default hr_api.g_varchar2

Line 611: ,p_assignment_action_code in varchar2 default hr_api.g_varchar2

607: ,p_report_qualifier in varchar2 default hr_api.g_varchar2
608: ,p_report_format in varchar2 default hr_api.g_varchar2
609: ,p_report_category in varchar2 default hr_api.g_varchar2
610: ,p_range_code in varchar2 default hr_api.g_varchar2
611: ,p_assignment_action_code in varchar2 default hr_api.g_varchar2
612: ,p_initialization_code in varchar2 default hr_api.g_varchar2
613: ,p_archive_code in varchar2 default hr_api.g_varchar2
614: ,p_magnetic_code in varchar2 default hr_api.g_varchar2
615: ,p_report_name in varchar2 default hr_api.g_varchar2

Line 612: ,p_initialization_code in varchar2 default hr_api.g_varchar2

608: ,p_report_format in varchar2 default hr_api.g_varchar2
609: ,p_report_category in varchar2 default hr_api.g_varchar2
610: ,p_range_code in varchar2 default hr_api.g_varchar2
611: ,p_assignment_action_code in varchar2 default hr_api.g_varchar2
612: ,p_initialization_code in varchar2 default hr_api.g_varchar2
613: ,p_archive_code in varchar2 default hr_api.g_varchar2
614: ,p_magnetic_code in varchar2 default hr_api.g_varchar2
615: ,p_report_name in varchar2 default hr_api.g_varchar2
616: ,p_sort_code in varchar2 default hr_api.g_varchar2

Line 613: ,p_archive_code in varchar2 default hr_api.g_varchar2

609: ,p_report_category in varchar2 default hr_api.g_varchar2
610: ,p_range_code in varchar2 default hr_api.g_varchar2
611: ,p_assignment_action_code in varchar2 default hr_api.g_varchar2
612: ,p_initialization_code in varchar2 default hr_api.g_varchar2
613: ,p_archive_code in varchar2 default hr_api.g_varchar2
614: ,p_magnetic_code in varchar2 default hr_api.g_varchar2
615: ,p_report_name in varchar2 default hr_api.g_varchar2
616: ,p_sort_code in varchar2 default hr_api.g_varchar2
617: ,p_updatable_flag in varchar2 default hr_api.g_varchar2

Line 614: ,p_magnetic_code in varchar2 default hr_api.g_varchar2

610: ,p_range_code in varchar2 default hr_api.g_varchar2
611: ,p_assignment_action_code in varchar2 default hr_api.g_varchar2
612: ,p_initialization_code in varchar2 default hr_api.g_varchar2
613: ,p_archive_code in varchar2 default hr_api.g_varchar2
614: ,p_magnetic_code in varchar2 default hr_api.g_varchar2
615: ,p_report_name in varchar2 default hr_api.g_varchar2
616: ,p_sort_code in varchar2 default hr_api.g_varchar2
617: ,p_updatable_flag in varchar2 default hr_api.g_varchar2
618: ,p_deinitialization_code in varchar2 default hr_api.g_varchar2

Line 615: ,p_report_name in varchar2 default hr_api.g_varchar2

611: ,p_assignment_action_code in varchar2 default hr_api.g_varchar2
612: ,p_initialization_code in varchar2 default hr_api.g_varchar2
613: ,p_archive_code in varchar2 default hr_api.g_varchar2
614: ,p_magnetic_code in varchar2 default hr_api.g_varchar2
615: ,p_report_name in varchar2 default hr_api.g_varchar2
616: ,p_sort_code in varchar2 default hr_api.g_varchar2
617: ,p_updatable_flag in varchar2 default hr_api.g_varchar2
618: ,p_deinitialization_code in varchar2 default hr_api.g_varchar2
619: ,p_business_group_id in number default hr_api.g_number

Line 616: ,p_sort_code in varchar2 default hr_api.g_varchar2

612: ,p_initialization_code in varchar2 default hr_api.g_varchar2
613: ,p_archive_code in varchar2 default hr_api.g_varchar2
614: ,p_magnetic_code in varchar2 default hr_api.g_varchar2
615: ,p_report_name in varchar2 default hr_api.g_varchar2
616: ,p_sort_code in varchar2 default hr_api.g_varchar2
617: ,p_updatable_flag in varchar2 default hr_api.g_varchar2
618: ,p_deinitialization_code in varchar2 default hr_api.g_varchar2
619: ,p_business_group_id in number default hr_api.g_number
620: ,p_legislation_code in varchar2 default hr_api.g_varchar2

Line 617: ,p_updatable_flag in varchar2 default hr_api.g_varchar2

613: ,p_archive_code in varchar2 default hr_api.g_varchar2
614: ,p_magnetic_code in varchar2 default hr_api.g_varchar2
615: ,p_report_name in varchar2 default hr_api.g_varchar2
616: ,p_sort_code in varchar2 default hr_api.g_varchar2
617: ,p_updatable_flag in varchar2 default hr_api.g_varchar2
618: ,p_deinitialization_code in varchar2 default hr_api.g_varchar2
619: ,p_business_group_id in number default hr_api.g_number
620: ,p_legislation_code in varchar2 default hr_api.g_varchar2
621: ,p_temporary_action_flag in varchar2 default hr_api.g_varchar2

Line 618: ,p_deinitialization_code in varchar2 default hr_api.g_varchar2

614: ,p_magnetic_code in varchar2 default hr_api.g_varchar2
615: ,p_report_name in varchar2 default hr_api.g_varchar2
616: ,p_sort_code in varchar2 default hr_api.g_varchar2
617: ,p_updatable_flag in varchar2 default hr_api.g_varchar2
618: ,p_deinitialization_code in varchar2 default hr_api.g_varchar2
619: ,p_business_group_id in number default hr_api.g_number
620: ,p_legislation_code in varchar2 default hr_api.g_varchar2
621: ,p_temporary_action_flag in varchar2 default hr_api.g_varchar2
622: ,p_effective_start_date out nocopy date

Line 619: ,p_business_group_id in number default hr_api.g_number

615: ,p_report_name in varchar2 default hr_api.g_varchar2
616: ,p_sort_code in varchar2 default hr_api.g_varchar2
617: ,p_updatable_flag in varchar2 default hr_api.g_varchar2
618: ,p_deinitialization_code in varchar2 default hr_api.g_varchar2
619: ,p_business_group_id in number default hr_api.g_number
620: ,p_legislation_code in varchar2 default hr_api.g_varchar2
621: ,p_temporary_action_flag in varchar2 default hr_api.g_varchar2
622: ,p_effective_start_date out nocopy date
623: ,p_effective_end_date out nocopy date

Line 620: ,p_legislation_code in varchar2 default hr_api.g_varchar2

616: ,p_sort_code in varchar2 default hr_api.g_varchar2
617: ,p_updatable_flag in varchar2 default hr_api.g_varchar2
618: ,p_deinitialization_code in varchar2 default hr_api.g_varchar2
619: ,p_business_group_id in number default hr_api.g_number
620: ,p_legislation_code in varchar2 default hr_api.g_varchar2
621: ,p_temporary_action_flag in varchar2 default hr_api.g_varchar2
622: ,p_effective_start_date out nocopy date
623: ,p_effective_end_date out nocopy date
624: ) is

Line 621: ,p_temporary_action_flag in varchar2 default hr_api.g_varchar2

617: ,p_updatable_flag in varchar2 default hr_api.g_varchar2
618: ,p_deinitialization_code in varchar2 default hr_api.g_varchar2
619: ,p_business_group_id in number default hr_api.g_number
620: ,p_legislation_code in varchar2 default hr_api.g_varchar2
621: ,p_temporary_action_flag in varchar2 default hr_api.g_varchar2
622: ,p_effective_start_date out nocopy date
623: ,p_effective_end_date out nocopy date
624: ) is
625: --