DBA Data[Home] [Help]

APPS.GHR_MSL_PKG dependencies on HR_API

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

2676: ,p_date_effective => l_eff_date
2677: ,p_per_ei_data => l_per_ei_data);
2678:
2679: --Bug#3988449 Added NVL and to_number in the following condition
2680: IF NVL(to_number(l_per_ei_data.pei_information5),hr_api.g_number) <> NVL(p_mass_salary_id,hr_api.g_number) then
2681: p_sel_flag := 'Y';
2682: p_comments := null;
2683: p_increase_percent := null;
2684: p_ses_basic_pay := null;

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

2690: end if;
2691:
2692: --Bug#3988449 Added NVL and to_number to l_per_ei_data.pei_information5, p_mass_salary_id.
2693: IF p_sel_flag IS NOT NULL and
2694: NVL(to_number(l_per_ei_data.pei_information5),hr_api.g_number) <> NVL(p_mass_salary_id,hr_api.g_number) THEN
2695: FOR chk_history_rec in chk_history(p_person_id => p_person_id,
2696: eff_date => l_eff_date) loop
2697: If chk_history_rec.info11 = p_mass_salary_id then
2698: p_sel_flag := chk_history_rec.info9;

Line 4018: ghr_api.retrieve_element_entry_value

4014: -- Ashley 17-JUL-03 Payroll Intg Modified the Input Value name
4015: -- Changes from Total Salary -> Amount
4016: -- Adjusted Pay -> Amount
4017:
4018: ghr_api.retrieve_element_entry_value
4019: (p_element_name => 'Total Pay'
4020: ,p_input_value_name => 'Amount'
4021: ,p_assignment_id => p_assignment_id
4022: ,p_effective_date => p_effective_date

Line 4033: ghr_api.retrieve_element_entry_value

4029: hr_utility.set_message(8301, 'GHR_38014_API_MULTI_ELE_ENTR');
4030: hr_utility.raise_error;
4031: end if;
4032:
4033: ghr_api.retrieve_element_entry_value
4034: (p_element_name => 'Basic Salary Rate'
4035: ,p_input_value_name => 'Rate'
4036: ,p_assignment_id => p_assignment_id
4037: ,p_effective_date => p_effective_date

Line 4048: ghr_api.retrieve_element_entry_value

4044: hr_utility.set_message(8301, 'GHR_38014_API_MULTI_ELE_ENTR');
4045: hr_utility.raise_error;
4046: end if;
4047:
4048: ghr_api.retrieve_element_entry_value
4049: -- FWFA Changes Bug#4444609
4050: (p_element_name => 'Locality Pay or SR Supplement'
4051: -- FWFA Changes Modify 'Locality Pay' to 'Locality Pay or SR Supplement'
4052: ,p_input_value_name => 'Rate'

Line 4066: ghr_api.retrieve_element_entry_value

4062: hr_utility.set_message(8301, 'GHR_38014_API_MULTI_ELE_ENTR');
4063: hr_utility.raise_error;
4064: end if;
4065:
4066: ghr_api.retrieve_element_entry_value
4067: (p_element_name => 'Adjusted Basic Pay'
4068: ,p_input_value_name => 'Amount'
4069: ,p_assignment_id => p_assignment_id
4070: ,p_effective_date => p_effective_date

Line 4081: ghr_api.retrieve_element_entry_value

4077: hr_utility.set_message(8301, 'GHR_38014_API_MULTI_ELE_ENTR');
4078: hr_utility.raise_error;
4079: end if;
4080:
4081: ghr_api.retrieve_element_entry_value
4082: (p_element_name => 'Other Pay'
4083: ,p_input_value_name => 'Amount'
4084: ,p_assignment_id => p_assignment_id
4085: ,p_effective_date => p_effective_date

Line 4096: ghr_api.retrieve_element_entry_value

4092: hr_utility.set_message(8301, 'GHR_38014_API_MULTI_ELE_ENTR');
4093: hr_utility.raise_error;
4094: end if;
4095:
4096: ghr_api.retrieve_element_entry_value
4097: (p_element_name => 'AUO'
4098: ,p_input_value_name => 'Amount'
4099: ,p_assignment_id => p_assignment_id
4100: ,p_effective_date => p_effective_date

Line 4111: ghr_api.retrieve_element_entry_value

4107: hr_utility.set_message(8301, 'GHR_38014_API_MULTI_ELE_ENTR');
4108: hr_utility.raise_error;
4109: end if;
4110:
4111: ghr_api.retrieve_element_entry_value
4112: (p_element_name => 'AUO'
4113: ,p_input_value_name => 'Premium Pay Ind'
4114: ,p_assignment_id => p_assignment_id
4115: ,p_effective_date => p_effective_date

Line 4124: ghr_api.retrieve_element_entry_value

4120: hr_utility.set_message(8301, 'GHR_38014_API_MULTI_ELE_ENTR');
4121: hr_utility.raise_error;
4122: end if;
4123:
4124: ghr_api.retrieve_element_entry_value
4125: (p_element_name => 'Availability Pay'
4126: ,p_input_value_name => 'Amount'
4127: ,p_assignment_id => p_assignment_id
4128: ,p_effective_date => p_effective_date

Line 4139: ghr_api.retrieve_element_entry_value

4135: hr_utility.set_message(8301, 'GHR_38014_API_MULTI_ELE_ENTR');
4136: hr_utility.raise_error;
4137: end if;
4138:
4139: ghr_api.retrieve_element_entry_value
4140: (p_element_name => 'Availability Pay'
4141: ,p_input_value_name => 'Premium Pay Ind'
4142: ,p_assignment_id => p_assignment_id
4143: ,p_effective_date => p_effective_date

Line 4152: ghr_api.retrieve_element_entry_value

4148: hr_utility.set_message(8301, 'GHR_38014_API_MULTI_ELE_ENTR');
4149: hr_utility.raise_error;
4150: end if;
4151: --
4152: ghr_api.retrieve_element_entry_value
4153: (p_element_name => 'Retention Allowance'
4154: ,p_input_value_name => 'Amount'
4155: ,p_assignment_id => p_assignment_id
4156: ,p_effective_date => p_effective_date

Line 4167: ghr_api.retrieve_element_entry_value

4163: hr_utility.set_message(8301, 'GHR_38014_API_MULTI_ELE_ENTR');
4164: hr_utility.raise_error;
4165: end if;
4166:
4167: ghr_api.retrieve_element_entry_value
4168: (p_element_name => 'Retention Allowance'
4169: ,p_input_value_name => 'Percentage'
4170: ,p_assignment_id => p_assignment_id
4171: ,p_effective_date => p_effective_date

Line 4182: ghr_api.retrieve_element_entry_value

4178: hr_utility.set_message(8301, 'GHR_38014_API_MULTI_ELE_ENTR');
4179: hr_utility.raise_error;
4180: end if;
4181:
4182: ghr_api.retrieve_element_entry_value
4183: (p_element_name => 'Supervisory Differential'
4184: ,p_input_value_name => 'Amount'
4185: ,p_assignment_id => p_assignment_id
4186: ,p_effective_date => p_effective_date

Line 4197: ghr_api.retrieve_element_entry_value

4193: hr_utility.set_message(8301, 'GHR_38014_API_MULTI_ELE_ENTR');
4194: hr_utility.raise_error;
4195: end if;
4196:
4197: ghr_api.retrieve_element_entry_value
4198: (p_element_name => 'Supervisory Differential'
4199: ,p_input_value_name => 'Percentage'
4200: ,p_assignment_id => p_assignment_id
4201: ,p_effective_date => p_effective_date

Line 4214: ghr_api.retrieve_element_entry_value

4210: end if;
4211:
4212: --
4213: --
4214: ghr_api.retrieve_element_entry_value
4215: (p_element_name => 'Staffing Differential'
4216: ,p_input_value_name => 'Amount'
4217: ,p_assignment_id => p_assignment_id
4218: ,p_effective_date => p_effective_date

Line 4272: p_sub_element_code := ghr_api.get_position_agency_code_pos

4268: l_proc varchar2(72) := g_package || '.get_sub_element_code_pos_title';
4269: begin
4270: g_proc := 'get_sub_element_code_pos_title';
4271: hr_utility.set_location('Entering ' || l_proc,5);
4272: p_sub_element_code := ghr_api.get_position_agency_code_pos
4273: (p_position_id,p_business_group_id,p_effective_date);
4274:
4275: p_position_title := ghr_api.get_position_title_pos
4276: (p_position_id => p_position_id

Line 4275: p_position_title := ghr_api.get_position_title_pos

4271: hr_utility.set_location('Entering ' || l_proc,5);
4272: p_sub_element_code := ghr_api.get_position_agency_code_pos
4273: (p_position_id,p_business_group_id,p_effective_date);
4274:
4275: p_position_title := ghr_api.get_position_title_pos
4276: (p_position_id => p_position_id
4277: ,p_business_group_id => p_business_group_id
4278: ,p_effective_date => p_effective_date ) ;
4279:

Line 4281: p_position_number := ghr_api.get_position_description_no

4277: ,p_business_group_id => p_business_group_id
4278: ,p_effective_date => p_effective_date ) ;
4279:
4280: if p_person_id is not null then
4281: p_position_number := ghr_api.get_position_description_no
4282: (p_person_id => p_person_id
4283: ,p_assignment_id => p_assignment_id
4284: ,p_effective_date => p_effective_date
4285: );

Line 4287: p_position_seq_no := ghr_api.get_position_sequence_no

4283: ,p_assignment_id => p_assignment_id
4284: ,p_effective_date => p_effective_date
4285: );
4286:
4287: p_position_seq_no := ghr_api.get_position_sequence_no
4288: (p_person_id => p_person_id
4289: ,p_assignment_id => p_assignment_id
4290: ,p_effective_date => p_effective_date
4291: );

Line 5430: ghr_api.retrieve_element_entry_value

5426: -- If l_pay_plan in ('SL', 'ST', 'IP') then
5427: If l_effective_date = to_date('2009/04/12','YYYY/MM/DD') then
5428: --Fetching the locality adjustment as this conversion
5429: -- is applicable only if locality is available
5430: ghr_api.retrieve_element_entry_value
5431: (p_element_name => 'Locality Pay or SR Supplement'
5432: ,p_input_value_name => 'Rate'
5433: ,p_assignment_id => l_assignment_id
5434: ,p_effective_date => l_effective_date

Line 6808: l_special_info_type ghr_api.special_information_type;

6804: l_rat_matched BOOLEAN := FALSE;
6805:
6806:
6807: --5470182
6808: l_special_info_type ghr_api.special_information_type;
6809:
6810:
6811:
6812: l_proc varchar2(72) := g_package || '.fetch_and_validate_emp_ses';