DBA Data[Home] [Help]

APPS.PAY_ITR_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: --
115: pay_itr_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: --
115: pay_itr_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: --
120: pay_itr_shd.constraint_error

Line 117: When hr_api.unique_integrity_violated Then

113: -- A check constraint has been violated
114: --
115: pay_itr_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: --
120: pay_itr_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: --
120: pay_itr_shd.constraint_error
121: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
122: When Others Then
123: --
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_itr_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: when hr_api.cannot_find_prog_unit then

434: );
435: --
436: exception
437: --
438: when hr_api.cannot_find_prog_unit then
439: --
440: hr_api.cannot_find_prog_unit_error
441: (p_module_name => 'PAY_ITERATIVE_RULES_F'
442: ,p_hook_type => 'AU');

Line 440: hr_api.cannot_find_prog_unit_error

436: exception
437: --
438: when hr_api.cannot_find_prog_unit then
439: --
440: hr_api.cannot_find_prog_unit_error
441: (p_module_name => 'PAY_ITERATIVE_RULES_F'
442: ,p_hook_type => 'AU');
443: --
444: end;

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

499: -- p_rec plsql record structure
500: -- to see if a system default is being used. If a system default
501: -- is being used then we must set to the 'current' argument value.
502: --
503: If (p_rec.element_type_id = hr_api.g_number) then
504: p_rec.element_type_id :=
505: pay_itr_shd.g_old_rec.element_type_id;
506: End If;
507: If (p_rec.result_name = hr_api.g_varchar2) then

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

503: If (p_rec.element_type_id = hr_api.g_number) then
504: p_rec.element_type_id :=
505: pay_itr_shd.g_old_rec.element_type_id;
506: End If;
507: If (p_rec.result_name = hr_api.g_varchar2) then
508: p_rec.result_name :=
509: pay_itr_shd.g_old_rec.result_name;
510: End If;
511: If (p_rec.iterative_rule_type = hr_api.g_varchar2) then

Line 511: If (p_rec.iterative_rule_type = hr_api.g_varchar2) then

507: If (p_rec.result_name = hr_api.g_varchar2) then
508: p_rec.result_name :=
509: pay_itr_shd.g_old_rec.result_name;
510: End If;
511: If (p_rec.iterative_rule_type = hr_api.g_varchar2) then
512: p_rec.iterative_rule_type :=
513: pay_itr_shd.g_old_rec.iterative_rule_type;
514: End If;
515: If (p_rec.input_value_id = hr_api.g_number) then

Line 515: If (p_rec.input_value_id = hr_api.g_number) then

511: If (p_rec.iterative_rule_type = hr_api.g_varchar2) then
512: p_rec.iterative_rule_type :=
513: pay_itr_shd.g_old_rec.iterative_rule_type;
514: End If;
515: If (p_rec.input_value_id = hr_api.g_number) then
516: p_rec.input_value_id :=
517: pay_itr_shd.g_old_rec.input_value_id;
518: End If;
519: If (p_rec.severity_level = hr_api.g_varchar2) then

Line 519: If (p_rec.severity_level = hr_api.g_varchar2) then

515: If (p_rec.input_value_id = hr_api.g_number) then
516: p_rec.input_value_id :=
517: pay_itr_shd.g_old_rec.input_value_id;
518: End If;
519: If (p_rec.severity_level = hr_api.g_varchar2) then
520: p_rec.severity_level :=
521: pay_itr_shd.g_old_rec.severity_level;
522: End If;
523: If (p_rec.business_group_id = hr_api.g_number) then

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

519: If (p_rec.severity_level = hr_api.g_varchar2) then
520: p_rec.severity_level :=
521: pay_itr_shd.g_old_rec.severity_level;
522: End If;
523: If (p_rec.business_group_id = hr_api.g_number) then
524: p_rec.business_group_id :=
525: pay_itr_shd.g_old_rec.business_group_id;
526: End If;
527: If (p_rec.legislation_code = hr_api.g_varchar2) then

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

523: If (p_rec.business_group_id = hr_api.g_number) then
524: p_rec.business_group_id :=
525: pay_itr_shd.g_old_rec.business_group_id;
526: End If;
527: If (p_rec.legislation_code = hr_api.g_varchar2) then
528: p_rec.legislation_code :=
529: pay_itr_shd.g_old_rec.legislation_code;
530: End If;
531: --

Line 620: ,p_element_type_id in number default hr_api.g_number

616: (p_effective_date in date
617: ,p_datetrack_mode in varchar2
618: ,p_iterative_rule_id in number
619: ,p_object_version_number in out nocopy number
620: ,p_element_type_id in number default hr_api.g_number
621: ,p_result_name in varchar2 default hr_api.g_varchar2
622: ,p_iterative_rule_type in varchar2 default hr_api.g_varchar2
623: ,p_input_value_id in number default hr_api.g_number
624: ,p_severity_level in varchar2 default hr_api.g_varchar2

Line 621: ,p_result_name in varchar2 default hr_api.g_varchar2

617: ,p_datetrack_mode in varchar2
618: ,p_iterative_rule_id in number
619: ,p_object_version_number in out nocopy number
620: ,p_element_type_id in number default hr_api.g_number
621: ,p_result_name in varchar2 default hr_api.g_varchar2
622: ,p_iterative_rule_type in varchar2 default hr_api.g_varchar2
623: ,p_input_value_id in number default hr_api.g_number
624: ,p_severity_level in varchar2 default hr_api.g_varchar2
625: ,p_business_group_id in number default hr_api.g_number

Line 622: ,p_iterative_rule_type in varchar2 default hr_api.g_varchar2

618: ,p_iterative_rule_id in number
619: ,p_object_version_number in out nocopy number
620: ,p_element_type_id in number default hr_api.g_number
621: ,p_result_name in varchar2 default hr_api.g_varchar2
622: ,p_iterative_rule_type in varchar2 default hr_api.g_varchar2
623: ,p_input_value_id in number default hr_api.g_number
624: ,p_severity_level in varchar2 default hr_api.g_varchar2
625: ,p_business_group_id in number default hr_api.g_number
626: ,p_legislation_code in varchar2 default hr_api.g_varchar2

Line 623: ,p_input_value_id in number default hr_api.g_number

619: ,p_object_version_number in out nocopy number
620: ,p_element_type_id in number default hr_api.g_number
621: ,p_result_name in varchar2 default hr_api.g_varchar2
622: ,p_iterative_rule_type in varchar2 default hr_api.g_varchar2
623: ,p_input_value_id in number default hr_api.g_number
624: ,p_severity_level in varchar2 default hr_api.g_varchar2
625: ,p_business_group_id in number default hr_api.g_number
626: ,p_legislation_code in varchar2 default hr_api.g_varchar2
627: ,p_effective_start_date out nocopy date

Line 624: ,p_severity_level in varchar2 default hr_api.g_varchar2

620: ,p_element_type_id in number default hr_api.g_number
621: ,p_result_name in varchar2 default hr_api.g_varchar2
622: ,p_iterative_rule_type in varchar2 default hr_api.g_varchar2
623: ,p_input_value_id in number default hr_api.g_number
624: ,p_severity_level in varchar2 default hr_api.g_varchar2
625: ,p_business_group_id in number default hr_api.g_number
626: ,p_legislation_code in varchar2 default hr_api.g_varchar2
627: ,p_effective_start_date out nocopy date
628: ,p_effective_end_date out nocopy date

Line 625: ,p_business_group_id in number default hr_api.g_number

621: ,p_result_name in varchar2 default hr_api.g_varchar2
622: ,p_iterative_rule_type in varchar2 default hr_api.g_varchar2
623: ,p_input_value_id in number default hr_api.g_number
624: ,p_severity_level in varchar2 default hr_api.g_varchar2
625: ,p_business_group_id in number default hr_api.g_number
626: ,p_legislation_code in varchar2 default hr_api.g_varchar2
627: ,p_effective_start_date out nocopy date
628: ,p_effective_end_date out nocopy date
629: ) is

Line 626: ,p_legislation_code in varchar2 default hr_api.g_varchar2

622: ,p_iterative_rule_type in varchar2 default hr_api.g_varchar2
623: ,p_input_value_id in number default hr_api.g_number
624: ,p_severity_level in varchar2 default hr_api.g_varchar2
625: ,p_business_group_id in number default hr_api.g_number
626: ,p_legislation_code in varchar2 default hr_api.g_varchar2
627: ,p_effective_start_date out nocopy date
628: ,p_effective_end_date out nocopy date
629: ) is
630: --