DBA Data[Home] [Help]

APPS.GHR_MSL_PKG dependencies on HR_API

Line 2652: IF NVL(to_number(l_per_ei_data.pei_information5),hr_api.g_number) <> NVL(p_mass_salary_id,hr_api.g_number) then

2648: ,p_date_effective => l_eff_date
2649: ,p_per_ei_data => l_per_ei_data);
2650:
2651: --Bug#3988449 Added NVL and to_number in the following condition
2652: IF NVL(to_number(l_per_ei_data.pei_information5),hr_api.g_number) <> NVL(p_mass_salary_id,hr_api.g_number) then
2653: p_sel_flag := 'Y';
2654: p_comments := null;
2655: p_increase_percent := null;
2656: p_ses_basic_pay := null;

Line 2666: NVL(to_number(l_per_ei_data.pei_information5),hr_api.g_number) <> NVL(p_mass_salary_id,hr_api.g_number) THEN

2662: end if;
2663:
2664: --Bug#3988449 Added NVL and to_number to l_per_ei_data.pei_information5, p_mass_salary_id.
2665: IF p_sel_flag IS NOT NULL and
2666: NVL(to_number(l_per_ei_data.pei_information5),hr_api.g_number) <> NVL(p_mass_salary_id,hr_api.g_number) THEN
2667: FOR chk_history_rec in chk_history(p_person_id => p_person_id,
2668: eff_date => l_eff_date) loop
2669: If chk_history_rec.info11 = p_mass_salary_id then
2670: p_sel_flag := chk_history_rec.info9;

Line 3966: ghr_api.retrieve_element_entry_value

3962: -- Ashley 17-JUL-03 Payroll Intg Modified the Input Value name
3963: -- Changes from Total Salary -> Amount
3964: -- Adjusted Pay -> Amount
3965:
3966: ghr_api.retrieve_element_entry_value
3967: (p_element_name => 'Total Pay'
3968: ,p_input_value_name => 'Amount'
3969: ,p_assignment_id => p_assignment_id
3970: ,p_effective_date => p_effective_date

Line 3981: ghr_api.retrieve_element_entry_value

3977: hr_utility.set_message(8301, 'GHR_38014_API_MULTI_ELE_ENTR');
3978: hr_utility.raise_error;
3979: end if;
3980:
3981: ghr_api.retrieve_element_entry_value
3982: (p_element_name => 'Basic Salary Rate'
3983: ,p_input_value_name => 'Rate'
3984: ,p_assignment_id => p_assignment_id
3985: ,p_effective_date => p_effective_date

Line 3996: ghr_api.retrieve_element_entry_value

3992: hr_utility.set_message(8301, 'GHR_38014_API_MULTI_ELE_ENTR');
3993: hr_utility.raise_error;
3994: end if;
3995:
3996: ghr_api.retrieve_element_entry_value
3997: -- FWFA Changes Bug#4444609
3998: (p_element_name => 'Locality Pay or SR Supplement'
3999: -- FWFA Changes Modify 'Locality Pay' to 'Locality Pay or SR Supplement'
4000: ,p_input_value_name => 'Rate'

Line 4014: ghr_api.retrieve_element_entry_value

4010: hr_utility.set_message(8301, 'GHR_38014_API_MULTI_ELE_ENTR');
4011: hr_utility.raise_error;
4012: end if;
4013:
4014: ghr_api.retrieve_element_entry_value
4015: (p_element_name => 'Adjusted Basic Pay'
4016: ,p_input_value_name => 'Amount'
4017: ,p_assignment_id => p_assignment_id
4018: ,p_effective_date => p_effective_date

Line 4029: ghr_api.retrieve_element_entry_value

4025: hr_utility.set_message(8301, 'GHR_38014_API_MULTI_ELE_ENTR');
4026: hr_utility.raise_error;
4027: end if;
4028:
4029: ghr_api.retrieve_element_entry_value
4030: (p_element_name => 'Other Pay'
4031: ,p_input_value_name => 'Amount'
4032: ,p_assignment_id => p_assignment_id
4033: ,p_effective_date => p_effective_date

Line 4044: ghr_api.retrieve_element_entry_value

4040: hr_utility.set_message(8301, 'GHR_38014_API_MULTI_ELE_ENTR');
4041: hr_utility.raise_error;
4042: end if;
4043:
4044: ghr_api.retrieve_element_entry_value
4045: (p_element_name => 'AUO'
4046: ,p_input_value_name => 'Amount'
4047: ,p_assignment_id => p_assignment_id
4048: ,p_effective_date => p_effective_date

Line 4059: ghr_api.retrieve_element_entry_value

4055: hr_utility.set_message(8301, 'GHR_38014_API_MULTI_ELE_ENTR');
4056: hr_utility.raise_error;
4057: end if;
4058:
4059: ghr_api.retrieve_element_entry_value
4060: (p_element_name => 'AUO'
4061: ,p_input_value_name => 'Premium Pay Ind'
4062: ,p_assignment_id => p_assignment_id
4063: ,p_effective_date => p_effective_date

Line 4072: ghr_api.retrieve_element_entry_value

4068: hr_utility.set_message(8301, 'GHR_38014_API_MULTI_ELE_ENTR');
4069: hr_utility.raise_error;
4070: end if;
4071:
4072: ghr_api.retrieve_element_entry_value
4073: (p_element_name => 'Availability Pay'
4074: ,p_input_value_name => 'Amount'
4075: ,p_assignment_id => p_assignment_id
4076: ,p_effective_date => p_effective_date

Line 4087: ghr_api.retrieve_element_entry_value

4083: hr_utility.set_message(8301, 'GHR_38014_API_MULTI_ELE_ENTR');
4084: hr_utility.raise_error;
4085: end if;
4086:
4087: ghr_api.retrieve_element_entry_value
4088: (p_element_name => 'Availability Pay'
4089: ,p_input_value_name => 'Premium Pay Ind'
4090: ,p_assignment_id => p_assignment_id
4091: ,p_effective_date => p_effective_date

Line 4100: ghr_api.retrieve_element_entry_value

4096: hr_utility.set_message(8301, 'GHR_38014_API_MULTI_ELE_ENTR');
4097: hr_utility.raise_error;
4098: end if;
4099: --
4100: ghr_api.retrieve_element_entry_value
4101: (p_element_name => 'Retention Allowance'
4102: ,p_input_value_name => 'Amount'
4103: ,p_assignment_id => p_assignment_id
4104: ,p_effective_date => p_effective_date

Line 4115: ghr_api.retrieve_element_entry_value

4111: hr_utility.set_message(8301, 'GHR_38014_API_MULTI_ELE_ENTR');
4112: hr_utility.raise_error;
4113: end if;
4114:
4115: ghr_api.retrieve_element_entry_value
4116: (p_element_name => 'Retention Allowance'
4117: ,p_input_value_name => 'Percentage'
4118: ,p_assignment_id => p_assignment_id
4119: ,p_effective_date => p_effective_date

Line 4130: ghr_api.retrieve_element_entry_value

4126: hr_utility.set_message(8301, 'GHR_38014_API_MULTI_ELE_ENTR');
4127: hr_utility.raise_error;
4128: end if;
4129:
4130: ghr_api.retrieve_element_entry_value
4131: (p_element_name => 'Supervisory Differential'
4132: ,p_input_value_name => 'Amount'
4133: ,p_assignment_id => p_assignment_id
4134: ,p_effective_date => p_effective_date

Line 4145: ghr_api.retrieve_element_entry_value

4141: hr_utility.set_message(8301, 'GHR_38014_API_MULTI_ELE_ENTR');
4142: hr_utility.raise_error;
4143: end if;
4144:
4145: ghr_api.retrieve_element_entry_value
4146: (p_element_name => 'Supervisory Differential'
4147: ,p_input_value_name => 'Percentage'
4148: ,p_assignment_id => p_assignment_id
4149: ,p_effective_date => p_effective_date

Line 4162: ghr_api.retrieve_element_entry_value

4158: end if;
4159:
4160: --
4161: --
4162: ghr_api.retrieve_element_entry_value
4163: (p_element_name => 'Staffing Differential'
4164: ,p_input_value_name => 'Amount'
4165: ,p_assignment_id => p_assignment_id
4166: ,p_effective_date => p_effective_date

Line 4220: p_sub_element_code := ghr_api.get_position_agency_code_pos

4216: l_proc varchar2(72) := g_package || '.get_sub_element_code_pos_title';
4217: begin
4218: g_proc := 'get_sub_element_code_pos_title';
4219: hr_utility.set_location('Entering ' || l_proc,5);
4220: p_sub_element_code := ghr_api.get_position_agency_code_pos
4221: (p_position_id,p_business_group_id,p_effective_date);
4222:
4223: p_position_title := ghr_api.get_position_title_pos
4224: (p_position_id => p_position_id

Line 4223: p_position_title := ghr_api.get_position_title_pos

4219: hr_utility.set_location('Entering ' || l_proc,5);
4220: p_sub_element_code := ghr_api.get_position_agency_code_pos
4221: (p_position_id,p_business_group_id,p_effective_date);
4222:
4223: p_position_title := ghr_api.get_position_title_pos
4224: (p_position_id => p_position_id
4225: ,p_business_group_id => p_business_group_id
4226: ,p_effective_date => p_effective_date ) ;
4227:

Line 4229: p_position_number := ghr_api.get_position_description_no

4225: ,p_business_group_id => p_business_group_id
4226: ,p_effective_date => p_effective_date ) ;
4227:
4228: if p_person_id is not null then
4229: p_position_number := ghr_api.get_position_description_no
4230: (p_person_id => p_person_id
4231: ,p_assignment_id => p_assignment_id
4232: ,p_effective_date => p_effective_date
4233: );

Line 4235: p_position_seq_no := ghr_api.get_position_sequence_no

4231: ,p_assignment_id => p_assignment_id
4232: ,p_effective_date => p_effective_date
4233: );
4234:
4235: p_position_seq_no := ghr_api.get_position_sequence_no
4236: (p_person_id => p_person_id
4237: ,p_assignment_id => p_assignment_id
4238: ,p_effective_date => p_effective_date
4239: );

Line 6667: l_special_info_type ghr_api.special_information_type;

6663: l_rat_matched BOOLEAN := FALSE;
6664:
6665:
6666: --5470182
6667: l_special_info_type ghr_api.special_information_type;
6668:
6669:
6670:
6671: l_proc varchar2(72) := g_package || '.fetch_and_validate_emp_ses';