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_IVL_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 122: When hr_api.check_integrity_violated Then

118: End If;
119: --
120: hr_utility.set_location(' Leaving:'||l_proc, 15);
121: Exception
122: When hr_api.check_integrity_violated Then
123: -- A check constraint has been violated
124: pay_ivl_shd.g_api_dml := false; -- Unset the api dml status
125: pay_ivl_shd.constraint_error
126: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

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

Line 127: When hr_api.unique_integrity_violated Then

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

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

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

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

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

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

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

Line 487: when hr_api.cannot_find_prog_unit then

483: );
484: --
485: exception
486: --
487: when hr_api.cannot_find_prog_unit then
488: --
489: hr_api.cannot_find_prog_unit_error
490: (p_module_name => 'PAY_INPUT_VALUES_F'
491: ,p_hook_type => 'AU');

Line 489: hr_api.cannot_find_prog_unit_error

485: exception
486: --
487: when hr_api.cannot_find_prog_unit then
488: --
489: hr_api.cannot_find_prog_unit_error
490: (p_module_name => 'PAY_INPUT_VALUES_F'
491: ,p_hook_type => 'AU');
492: --
493: end;

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

548: -- p_rec plsql record structure
549: -- to see if a system default is being used. If a system default
550: -- is being used then we must set to the 'current' argument value.
551: --
552: If (p_rec.element_type_id = hr_api.g_number) then
553: p_rec.element_type_id :=
554: pay_ivl_shd.g_old_rec.element_type_id;
555: End If;
556: If (p_rec.lookup_type = hr_api.g_varchar2) then

Line 556: If (p_rec.lookup_type = hr_api.g_varchar2) then

552: If (p_rec.element_type_id = hr_api.g_number) then
553: p_rec.element_type_id :=
554: pay_ivl_shd.g_old_rec.element_type_id;
555: End If;
556: If (p_rec.lookup_type = hr_api.g_varchar2) then
557: p_rec.lookup_type :=
558: pay_ivl_shd.g_old_rec.lookup_type;
559: End If;
560: If (p_rec.business_group_id = hr_api.g_number) then

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

556: If (p_rec.lookup_type = hr_api.g_varchar2) then
557: p_rec.lookup_type :=
558: pay_ivl_shd.g_old_rec.lookup_type;
559: End If;
560: If (p_rec.business_group_id = hr_api.g_number) then
561: p_rec.business_group_id :=
562: pay_ivl_shd.g_old_rec.business_group_id;
563: End If;
564: If (p_rec.legislation_code = hr_api.g_varchar2) then

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

560: If (p_rec.business_group_id = hr_api.g_number) then
561: p_rec.business_group_id :=
562: pay_ivl_shd.g_old_rec.business_group_id;
563: End If;
564: If (p_rec.legislation_code = hr_api.g_varchar2) then
565: p_rec.legislation_code :=
566: pay_ivl_shd.g_old_rec.legislation_code;
567: End If;
568: If (p_rec.formula_id = hr_api.g_number) then

Line 568: If (p_rec.formula_id = hr_api.g_number) then

564: If (p_rec.legislation_code = hr_api.g_varchar2) then
565: p_rec.legislation_code :=
566: pay_ivl_shd.g_old_rec.legislation_code;
567: End If;
568: If (p_rec.formula_id = hr_api.g_number) then
569: p_rec.formula_id :=
570: pay_ivl_shd.g_old_rec.formula_id;
571: End If;
572: If (p_rec.value_set_id = hr_api.g_number) then

Line 572: If (p_rec.value_set_id = hr_api.g_number) then

568: If (p_rec.formula_id = hr_api.g_number) then
569: p_rec.formula_id :=
570: pay_ivl_shd.g_old_rec.formula_id;
571: End If;
572: If (p_rec.value_set_id = hr_api.g_number) then
573: p_rec.value_set_id :=
574: pay_ivl_shd.g_old_rec.value_set_id;
575: End If;
576: If (p_rec.display_sequence = hr_api.g_number) then

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

572: If (p_rec.value_set_id = hr_api.g_number) then
573: p_rec.value_set_id :=
574: pay_ivl_shd.g_old_rec.value_set_id;
575: End If;
576: If (p_rec.display_sequence = hr_api.g_number) then
577: p_rec.display_sequence :=
578: pay_ivl_shd.g_old_rec.display_sequence;
579: End If;
580: If (p_rec.generate_db_items_flag = hr_api.g_varchar2) then

Line 580: If (p_rec.generate_db_items_flag = hr_api.g_varchar2) then

576: If (p_rec.display_sequence = hr_api.g_number) then
577: p_rec.display_sequence :=
578: pay_ivl_shd.g_old_rec.display_sequence;
579: End If;
580: If (p_rec.generate_db_items_flag = hr_api.g_varchar2) then
581: p_rec.generate_db_items_flag :=
582: pay_ivl_shd.g_old_rec.generate_db_items_flag;
583: End If;
584: If (p_rec.hot_default_flag = hr_api.g_varchar2) then

Line 584: If (p_rec.hot_default_flag = hr_api.g_varchar2) then

580: If (p_rec.generate_db_items_flag = hr_api.g_varchar2) then
581: p_rec.generate_db_items_flag :=
582: pay_ivl_shd.g_old_rec.generate_db_items_flag;
583: End If;
584: If (p_rec.hot_default_flag = hr_api.g_varchar2) then
585: p_rec.hot_default_flag :=
586: pay_ivl_shd.g_old_rec.hot_default_flag;
587: End If;
588: If (p_rec.mandatory_flag = hr_api.g_varchar2) then

Line 588: If (p_rec.mandatory_flag = hr_api.g_varchar2) then

584: If (p_rec.hot_default_flag = hr_api.g_varchar2) then
585: p_rec.hot_default_flag :=
586: pay_ivl_shd.g_old_rec.hot_default_flag;
587: End If;
588: If (p_rec.mandatory_flag = hr_api.g_varchar2) then
589: p_rec.mandatory_flag :=
590: pay_ivl_shd.g_old_rec.mandatory_flag;
591: End If;
592: If (p_rec.name = hr_api.g_varchar2) then

Line 592: If (p_rec.name = hr_api.g_varchar2) then

588: If (p_rec.mandatory_flag = hr_api.g_varchar2) then
589: p_rec.mandatory_flag :=
590: pay_ivl_shd.g_old_rec.mandatory_flag;
591: End If;
592: If (p_rec.name = hr_api.g_varchar2) then
593: p_rec.name :=
594: pay_ivl_shd.g_old_rec.name;
595: End If;
596: If (p_rec.uom = hr_api.g_varchar2) then

Line 596: If (p_rec.uom = hr_api.g_varchar2) then

592: If (p_rec.name = hr_api.g_varchar2) then
593: p_rec.name :=
594: pay_ivl_shd.g_old_rec.name;
595: End If;
596: If (p_rec.uom = hr_api.g_varchar2) then
597: p_rec.uom :=
598: pay_ivl_shd.g_old_rec.uom;
599: End If;
600: If (p_rec.default_value = hr_api.g_varchar2) then

Line 600: If (p_rec.default_value = hr_api.g_varchar2) then

596: If (p_rec.uom = hr_api.g_varchar2) then
597: p_rec.uom :=
598: pay_ivl_shd.g_old_rec.uom;
599: End If;
600: If (p_rec.default_value = hr_api.g_varchar2) then
601: p_rec.default_value :=
602: pay_ivl_shd.g_old_rec.default_value;
603: End If;
604: If (p_rec.legislation_subgroup = hr_api.g_varchar2) then

Line 604: If (p_rec.legislation_subgroup = hr_api.g_varchar2) then

600: If (p_rec.default_value = hr_api.g_varchar2) then
601: p_rec.default_value :=
602: pay_ivl_shd.g_old_rec.default_value;
603: End If;
604: If (p_rec.legislation_subgroup = hr_api.g_varchar2) then
605: p_rec.legislation_subgroup :=
606: pay_ivl_shd.g_old_rec.legislation_subgroup;
607: End If;
608: If (p_rec.max_value = hr_api.g_varchar2) then

Line 608: If (p_rec.max_value = hr_api.g_varchar2) then

604: If (p_rec.legislation_subgroup = hr_api.g_varchar2) then
605: p_rec.legislation_subgroup :=
606: pay_ivl_shd.g_old_rec.legislation_subgroup;
607: End If;
608: If (p_rec.max_value = hr_api.g_varchar2) then
609: p_rec.max_value :=
610: pay_ivl_shd.g_old_rec.max_value;
611: End If;
612: If (p_rec.min_value = hr_api.g_varchar2) then

Line 612: If (p_rec.min_value = hr_api.g_varchar2) then

608: If (p_rec.max_value = hr_api.g_varchar2) then
609: p_rec.max_value :=
610: pay_ivl_shd.g_old_rec.max_value;
611: End If;
612: If (p_rec.min_value = hr_api.g_varchar2) then
613: p_rec.min_value :=
614: pay_ivl_shd.g_old_rec.min_value;
615: End If;
616: If (p_rec.warning_or_error = hr_api.g_varchar2) then

Line 616: If (p_rec.warning_or_error = hr_api.g_varchar2) then

612: If (p_rec.min_value = hr_api.g_varchar2) then
613: p_rec.min_value :=
614: pay_ivl_shd.g_old_rec.min_value;
615: End If;
616: If (p_rec.warning_or_error = hr_api.g_varchar2) then
617: p_rec.warning_or_error :=
618: pay_ivl_shd.g_old_rec.warning_or_error;
619: End If;
620: --

Line 732: ,p_element_type_id in number default hr_api.g_number

728: (p_effective_date in date
729: ,p_datetrack_mode in varchar2
730: ,p_input_value_id in number
731: ,p_object_version_number in out nocopy number
732: ,p_element_type_id in number default hr_api.g_number
733: ,p_display_sequence in number default hr_api.g_number
734: ,p_generate_db_items_flag in varchar2 default hr_api.g_varchar2
735: ,p_hot_default_flag in varchar2 default hr_api.g_varchar2
736: ,p_mandatory_flag in varchar2 default hr_api.g_varchar2

Line 733: ,p_display_sequence in number default hr_api.g_number

729: ,p_datetrack_mode in varchar2
730: ,p_input_value_id in number
731: ,p_object_version_number in out nocopy number
732: ,p_element_type_id in number default hr_api.g_number
733: ,p_display_sequence in number default hr_api.g_number
734: ,p_generate_db_items_flag in varchar2 default hr_api.g_varchar2
735: ,p_hot_default_flag in varchar2 default hr_api.g_varchar2
736: ,p_mandatory_flag in varchar2 default hr_api.g_varchar2
737: ,p_name in varchar2 default hr_api.g_varchar2

Line 734: ,p_generate_db_items_flag in varchar2 default hr_api.g_varchar2

730: ,p_input_value_id in number
731: ,p_object_version_number in out nocopy number
732: ,p_element_type_id in number default hr_api.g_number
733: ,p_display_sequence in number default hr_api.g_number
734: ,p_generate_db_items_flag in varchar2 default hr_api.g_varchar2
735: ,p_hot_default_flag in varchar2 default hr_api.g_varchar2
736: ,p_mandatory_flag in varchar2 default hr_api.g_varchar2
737: ,p_name in varchar2 default hr_api.g_varchar2
738: ,p_uom in varchar2 default hr_api.g_varchar2

Line 735: ,p_hot_default_flag in varchar2 default hr_api.g_varchar2

731: ,p_object_version_number in out nocopy number
732: ,p_element_type_id in number default hr_api.g_number
733: ,p_display_sequence in number default hr_api.g_number
734: ,p_generate_db_items_flag in varchar2 default hr_api.g_varchar2
735: ,p_hot_default_flag in varchar2 default hr_api.g_varchar2
736: ,p_mandatory_flag in varchar2 default hr_api.g_varchar2
737: ,p_name in varchar2 default hr_api.g_varchar2
738: ,p_uom in varchar2 default hr_api.g_varchar2
739: ,p_lookup_type in varchar2 default hr_api.g_varchar2

Line 736: ,p_mandatory_flag in varchar2 default hr_api.g_varchar2

732: ,p_element_type_id in number default hr_api.g_number
733: ,p_display_sequence in number default hr_api.g_number
734: ,p_generate_db_items_flag in varchar2 default hr_api.g_varchar2
735: ,p_hot_default_flag in varchar2 default hr_api.g_varchar2
736: ,p_mandatory_flag in varchar2 default hr_api.g_varchar2
737: ,p_name in varchar2 default hr_api.g_varchar2
738: ,p_uom in varchar2 default hr_api.g_varchar2
739: ,p_lookup_type in varchar2 default hr_api.g_varchar2
740: ,p_business_group_id in number default hr_api.g_number

Line 737: ,p_name in varchar2 default hr_api.g_varchar2

733: ,p_display_sequence in number default hr_api.g_number
734: ,p_generate_db_items_flag in varchar2 default hr_api.g_varchar2
735: ,p_hot_default_flag in varchar2 default hr_api.g_varchar2
736: ,p_mandatory_flag in varchar2 default hr_api.g_varchar2
737: ,p_name in varchar2 default hr_api.g_varchar2
738: ,p_uom in varchar2 default hr_api.g_varchar2
739: ,p_lookup_type in varchar2 default hr_api.g_varchar2
740: ,p_business_group_id in number default hr_api.g_number
741: ,p_legislation_code in varchar2 default hr_api.g_varchar2

Line 738: ,p_uom in varchar2 default hr_api.g_varchar2

734: ,p_generate_db_items_flag in varchar2 default hr_api.g_varchar2
735: ,p_hot_default_flag in varchar2 default hr_api.g_varchar2
736: ,p_mandatory_flag in varchar2 default hr_api.g_varchar2
737: ,p_name in varchar2 default hr_api.g_varchar2
738: ,p_uom in varchar2 default hr_api.g_varchar2
739: ,p_lookup_type in varchar2 default hr_api.g_varchar2
740: ,p_business_group_id in number default hr_api.g_number
741: ,p_legislation_code in varchar2 default hr_api.g_varchar2
742: ,p_formula_id in number default hr_api.g_number

Line 739: ,p_lookup_type in varchar2 default hr_api.g_varchar2

735: ,p_hot_default_flag in varchar2 default hr_api.g_varchar2
736: ,p_mandatory_flag in varchar2 default hr_api.g_varchar2
737: ,p_name in varchar2 default hr_api.g_varchar2
738: ,p_uom in varchar2 default hr_api.g_varchar2
739: ,p_lookup_type in varchar2 default hr_api.g_varchar2
740: ,p_business_group_id in number default hr_api.g_number
741: ,p_legislation_code in varchar2 default hr_api.g_varchar2
742: ,p_formula_id in number default hr_api.g_number
743: ,p_value_set_id in number default hr_api.g_number

Line 740: ,p_business_group_id in number default hr_api.g_number

736: ,p_mandatory_flag in varchar2 default hr_api.g_varchar2
737: ,p_name in varchar2 default hr_api.g_varchar2
738: ,p_uom in varchar2 default hr_api.g_varchar2
739: ,p_lookup_type in varchar2 default hr_api.g_varchar2
740: ,p_business_group_id in number default hr_api.g_number
741: ,p_legislation_code in varchar2 default hr_api.g_varchar2
742: ,p_formula_id in number default hr_api.g_number
743: ,p_value_set_id in number default hr_api.g_number
744: ,p_default_value in varchar2 default hr_api.g_varchar2

Line 741: ,p_legislation_code in varchar2 default hr_api.g_varchar2

737: ,p_name in varchar2 default hr_api.g_varchar2
738: ,p_uom in varchar2 default hr_api.g_varchar2
739: ,p_lookup_type in varchar2 default hr_api.g_varchar2
740: ,p_business_group_id in number default hr_api.g_number
741: ,p_legislation_code in varchar2 default hr_api.g_varchar2
742: ,p_formula_id in number default hr_api.g_number
743: ,p_value_set_id in number default hr_api.g_number
744: ,p_default_value in varchar2 default hr_api.g_varchar2
745: ,p_legislation_subgroup in varchar2 default hr_api.g_varchar2

Line 742: ,p_formula_id in number default hr_api.g_number

738: ,p_uom in varchar2 default hr_api.g_varchar2
739: ,p_lookup_type in varchar2 default hr_api.g_varchar2
740: ,p_business_group_id in number default hr_api.g_number
741: ,p_legislation_code in varchar2 default hr_api.g_varchar2
742: ,p_formula_id in number default hr_api.g_number
743: ,p_value_set_id in number default hr_api.g_number
744: ,p_default_value in varchar2 default hr_api.g_varchar2
745: ,p_legislation_subgroup in varchar2 default hr_api.g_varchar2
746: ,p_max_value in varchar2 default hr_api.g_varchar2

Line 743: ,p_value_set_id in number default hr_api.g_number

739: ,p_lookup_type in varchar2 default hr_api.g_varchar2
740: ,p_business_group_id in number default hr_api.g_number
741: ,p_legislation_code in varchar2 default hr_api.g_varchar2
742: ,p_formula_id in number default hr_api.g_number
743: ,p_value_set_id in number default hr_api.g_number
744: ,p_default_value in varchar2 default hr_api.g_varchar2
745: ,p_legislation_subgroup in varchar2 default hr_api.g_varchar2
746: ,p_max_value in varchar2 default hr_api.g_varchar2
747: ,p_min_value in varchar2 default hr_api.g_varchar2

Line 744: ,p_default_value in varchar2 default hr_api.g_varchar2

740: ,p_business_group_id in number default hr_api.g_number
741: ,p_legislation_code in varchar2 default hr_api.g_varchar2
742: ,p_formula_id in number default hr_api.g_number
743: ,p_value_set_id in number default hr_api.g_number
744: ,p_default_value in varchar2 default hr_api.g_varchar2
745: ,p_legislation_subgroup in varchar2 default hr_api.g_varchar2
746: ,p_max_value in varchar2 default hr_api.g_varchar2
747: ,p_min_value in varchar2 default hr_api.g_varchar2
748: ,p_warning_or_error in varchar2 default hr_api.g_varchar2

Line 745: ,p_legislation_subgroup in varchar2 default hr_api.g_varchar2

741: ,p_legislation_code in varchar2 default hr_api.g_varchar2
742: ,p_formula_id in number default hr_api.g_number
743: ,p_value_set_id in number default hr_api.g_number
744: ,p_default_value in varchar2 default hr_api.g_varchar2
745: ,p_legislation_subgroup in varchar2 default hr_api.g_varchar2
746: ,p_max_value in varchar2 default hr_api.g_varchar2
747: ,p_min_value in varchar2 default hr_api.g_varchar2
748: ,p_warning_or_error in varchar2 default hr_api.g_varchar2
749: ,p_effective_start_date out nocopy date

Line 746: ,p_max_value in varchar2 default hr_api.g_varchar2

742: ,p_formula_id in number default hr_api.g_number
743: ,p_value_set_id in number default hr_api.g_number
744: ,p_default_value in varchar2 default hr_api.g_varchar2
745: ,p_legislation_subgroup in varchar2 default hr_api.g_varchar2
746: ,p_max_value in varchar2 default hr_api.g_varchar2
747: ,p_min_value in varchar2 default hr_api.g_varchar2
748: ,p_warning_or_error in varchar2 default hr_api.g_varchar2
749: ,p_effective_start_date out nocopy date
750: ,p_effective_end_date out nocopy date

Line 747: ,p_min_value in varchar2 default hr_api.g_varchar2

743: ,p_value_set_id in number default hr_api.g_number
744: ,p_default_value in varchar2 default hr_api.g_varchar2
745: ,p_legislation_subgroup in varchar2 default hr_api.g_varchar2
746: ,p_max_value in varchar2 default hr_api.g_varchar2
747: ,p_min_value in varchar2 default hr_api.g_varchar2
748: ,p_warning_or_error in varchar2 default hr_api.g_varchar2
749: ,p_effective_start_date out nocopy date
750: ,p_effective_end_date out nocopy date
751: ,p_default_val_warning out nocopy boolean

Line 748: ,p_warning_or_error in varchar2 default hr_api.g_varchar2

744: ,p_default_value in varchar2 default hr_api.g_varchar2
745: ,p_legislation_subgroup in varchar2 default hr_api.g_varchar2
746: ,p_max_value in varchar2 default hr_api.g_varchar2
747: ,p_min_value in varchar2 default hr_api.g_varchar2
748: ,p_warning_or_error in varchar2 default hr_api.g_varchar2
749: ,p_effective_start_date out nocopy date
750: ,p_effective_end_date out nocopy date
751: ,p_default_val_warning out nocopy boolean
752: ,p_min_max_warning out nocopy boolean