DBA Data[Home] [Help]

APPS.GHR_MLC_PKG dependencies on GHR_API

Line 2432: l_position_title := ghr_api.get_position_title_pos

2428:
2429: l_personnel_office_id := l_pos_grp1_rec.poei_information3;
2430: l_org_structure_id := l_pos_grp1_rec.poei_information5;
2431:
2432: l_position_title := ghr_api.get_position_title_pos
2433: (p_position_id => l_position_id
2434: ,p_business_group_id => l_business_group_id ) ;
2435:
2436: l_sub_element_code := ghr_api.get_position_agency_code_pos

Line 2436: l_sub_element_code := ghr_api.get_position_agency_code_pos

2432: l_position_title := ghr_api.get_position_title_pos
2433: (p_position_id => l_position_id
2434: ,p_business_group_id => l_business_group_id ) ;
2435:
2436: l_sub_element_code := ghr_api.get_position_agency_code_pos
2437: (l_position_id,l_business_group_id);
2438:
2439: l_occ_series := ghr_api.get_job_occ_series_job
2440: (p_job_id => un_per.job_id

Line 2439: l_occ_series := ghr_api.get_job_occ_series_job

2435:
2436: l_sub_element_code := ghr_api.get_position_agency_code_pos
2437: (l_position_id,l_business_group_id);
2438:
2439: l_occ_series := ghr_api.get_job_occ_series_job
2440: (p_job_id => un_per.job_id
2441: ,p_business_group_id => un_per.business_group_id);
2442:
2443: l_position_NUMBER := ghr_api.get_position_desc_no_pos

Line 2443: l_position_NUMBER := ghr_api.get_position_desc_no_pos

2439: l_occ_series := ghr_api.get_job_occ_series_job
2440: (p_job_id => un_per.job_id
2441: ,p_business_group_id => un_per.business_group_id);
2442:
2443: l_position_NUMBER := ghr_api.get_position_desc_no_pos
2444: (p_position_id => l_position_id
2445: ,p_business_group_id => un_per.business_group_id);
2446:
2447: l_position_seq_no := ghr_api.get_position_sequence_no_pos

Line 2447: l_position_seq_no := ghr_api.get_position_sequence_no_pos

2443: l_position_NUMBER := ghr_api.get_position_desc_no_pos
2444: (p_position_id => l_position_id
2445: ,p_business_group_id => un_per.business_group_id);
2446:
2447: l_position_seq_no := ghr_api.get_position_sequence_no_pos
2448: (p_position_id => l_position_id
2449: ,p_business_group_id => un_per.business_group_id);
2450:
2451: -- Check Locality Area Code

Line 2614: ghr_api.g_api_dml := TRUE;

2610: END LOOP;
2611: --Bug 4699955
2612: if l_sel_flg = 'Y' then
2613: begin
2614: ghr_api.g_api_dml := TRUE;
2615: ghr_position_extra_info_api.update_position_extra_info
2616: ( p_position_extra_info_id => l_pos_valid_grade_ei_data.position_extra_info_id
2617: , p_effective_date => l_effective_date
2618: , p_object_version_number => l_pos_valid_grade_ei_data.object_version_number

Line 2620: ghr_api.g_api_dml := FALSE;

2616: ( p_position_extra_info_id => l_pos_valid_grade_ei_data.position_extra_info_id
2617: , p_effective_date => l_effective_date
2618: , p_object_version_number => l_pos_valid_grade_ei_data.object_version_number
2619: , p_poei_information5 => l_to_pay_table_id);
2620: ghr_api.g_api_dml := FALSE;
2621:
2622: ghr_validate_perwsdpo.validate_perwsdpo(l_position_id,l_effective_date);
2623: ghr_validate_perwsdpo.update_posn_status(l_position_id,l_effective_date);
2624:

Line 3964: ghr_api.retrieve_element_entry_value

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

Line 3979: ghr_api.retrieve_element_entry_value

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

Line 3994: ghr_api.retrieve_element_entry_value

3990: hr_utility.set_message(8301, 'GHR_38014_API_MULTI_ELE_ENTR');
3991: hr_utility.raise_error;
3992: end if;
3993:
3994: ghr_api.retrieve_element_entry_value
3995: (p_element_name => 'Locality Pay or SR Supplement'
3996: ,p_input_value_name => 'Rate'
3997: -- Changed by Ashu. 'Amount' to 'Rate'
3998: ,p_assignment_id => p_assignment_id

Line 4010: ghr_api.retrieve_element_entry_value

4006: hr_utility.set_message(8301, 'GHR_38014_API_MULTI_ELE_ENTR');
4007: hr_utility.raise_error;
4008: end if;
4009:
4010: ghr_api.retrieve_element_entry_value
4011: (p_element_name => 'Adjusted Basic Pay'
4012: ,p_input_value_name => 'Amount'
4013: ,p_assignment_id => p_assignment_id
4014: ,p_effective_date => p_effective_date

Line 4025: ghr_api.retrieve_element_entry_value

4021: hr_utility.set_message(8301, 'GHR_38014_API_MULTI_ELE_ENTR');
4022: hr_utility.raise_error;
4023: end if;
4024:
4025: ghr_api.retrieve_element_entry_value
4026: (p_element_name => 'Other Pay'
4027: ,p_input_value_name => 'Amount'
4028: ,p_assignment_id => p_assignment_id
4029: ,p_effective_date => p_effective_date

Line 4040: ghr_api.retrieve_element_entry_value

4036: hr_utility.set_message(8301, 'GHR_38014_API_MULTI_ELE_ENTR');
4037: hr_utility.raise_error;
4038: end if;
4039:
4040: ghr_api.retrieve_element_entry_value
4041: (p_element_name => 'AUO'
4042: ,p_input_value_name => 'Amount'
4043: ,p_assignment_id => p_assignment_id
4044: ,p_effective_date => p_effective_date

Line 4055: ghr_api.retrieve_element_entry_value

4051: hr_utility.set_message(8301, 'GHR_38014_API_MULTI_ELE_ENTR');
4052: hr_utility.raise_error;
4053: end if;
4054:
4055: ghr_api.retrieve_element_entry_value
4056: (p_element_name => 'AUO'
4057: ,p_input_value_name => 'Premium Pay Ind'
4058: ,p_assignment_id => p_assignment_id
4059: ,p_effective_date => p_effective_date

Line 4068: ghr_api.retrieve_element_entry_value

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

Line 4083: ghr_api.retrieve_element_entry_value

4079: hr_utility.set_message(8301, 'GHR_38014_API_MULTI_ELE_ENTR');
4080: hr_utility.raise_error;
4081: end if;
4082:
4083: ghr_api.retrieve_element_entry_value
4084: (p_element_name => 'Availability Pay'
4085: ,p_input_value_name => 'Premium Pay Ind'
4086: ,p_assignment_id => p_assignment_id
4087: ,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 => 'Retention Allowance'
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 => 'Retention Allowance'
4113: ,p_input_value_name => 'Percentage'
4114: ,p_assignment_id => p_assignment_id
4115: ,p_effective_date => p_effective_date

Line 4126: ghr_api.retrieve_element_entry_value

4122: hr_utility.set_message(8301, 'GHR_38014_API_MULTI_ELE_ENTR');
4123: hr_utility.raise_error;
4124: end if;
4125:
4126: ghr_api.retrieve_element_entry_value
4127: (p_element_name => 'Supervisory Differential'
4128: ,p_input_value_name => 'Amount'
4129: ,p_assignment_id => p_assignment_id
4130: ,p_effective_date => p_effective_date

Line 4141: ghr_api.retrieve_element_entry_value

4137: hr_utility.set_message(8301, 'GHR_38014_API_MULTI_ELE_ENTR');
4138: hr_utility.raise_error;
4139: end if;
4140:
4141: ghr_api.retrieve_element_entry_value
4142: (p_element_name => 'Supervisory Differential'
4143: ,p_input_value_name => 'Percentage'
4144: ,p_assignment_id => p_assignment_id
4145: ,p_effective_date => p_effective_date

Line 4158: ghr_api.retrieve_element_entry_value

4154: end if;
4155:
4156: --
4157: --
4158: ghr_api.retrieve_element_entry_value
4159: (p_element_name => 'Staffing Differential'
4160: ,p_input_value_name => 'Amount'
4161: ,p_assignment_id => p_assignment_id
4162: ,p_effective_date => p_effective_date

Line 4216: p_sub_element_code := ghr_api.get_position_agency_code_pos

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

Line 4219: p_position_title := ghr_api.get_position_title_pos

4215: hr_utility.set_location('Entering ' || l_proc,5);
4216: p_sub_element_code := ghr_api.get_position_agency_code_pos
4217: (p_position_id,p_business_group_id,p_effective_date);
4218:
4219: p_position_title := ghr_api.get_position_title_pos
4220: (p_position_id => p_position_id
4221: ,p_business_group_id => p_business_group_id
4222: ,p_effective_date => p_effective_date ) ;
4223:

Line 4225: p_position_number := ghr_api.get_position_description_no

4221: ,p_business_group_id => p_business_group_id
4222: ,p_effective_date => p_effective_date ) ;
4223:
4224: -- if p_person_id is not null then
4225: p_position_number := ghr_api.get_position_description_no
4226: (p_person_id => p_person_id
4227: ,p_assignment_id => p_assignment_id
4228: ,p_effective_date => p_effective_date
4229: );

Line 4231: p_position_seq_no := ghr_api.get_position_sequence_no

4227: ,p_assignment_id => p_assignment_id
4228: ,p_effective_date => p_effective_date
4229: );
4230:
4231: p_position_seq_no := ghr_api.get_position_sequence_no
4232: (p_person_id => p_person_id
4233: ,p_assignment_id => p_assignment_id
4234: ,p_effective_date => p_effective_date
4235: );

Line 5063: ghr_api.g_api_dml := TRUE;

5059:
5060: if l_position_extra_info_id is not null then
5061:
5062: ----- Set the global variable not to fire the trigger
5063: ghr_api.g_api_dml := TRUE;
5064:
5065: BEGIN
5066:
5067: ghr_position_extra_info_api.UPDATE_position_extra_info

Line 5082: ghr_api.g_api_dml := FALSE;

5078: hr_utility.set_location('Error in '||l_proc||' Err is '||sqlerrm(sqlcode),20);
5079: END;
5080:
5081: ----- Reset the global variable
5082: ghr_api.g_api_dml := FALSE;
5083:
5084: END IF;
5085: END;
5086: --

Line 5264: ghr_api.g_api_dml := TRUE;

5260:
5261: if l_position_extra_info_id is not null then
5262:
5263: ----- Set the global variable not to fire the trigger
5264: ghr_api.g_api_dml := TRUE;
5265:
5266: BEGIN
5267: ghr_position_extra_info_api.UPDATE_position_extra_info
5268: (P_POSITION_EXTRA_INFO_ID => l_position_extra_info_id

Line 5280: ghr_api.g_api_dml := FALSE;

5276: hr_utility.set_location('UPDATE posei error 1' || l_proc,10);
5277: hr_utility.set_location('Error in '||l_proc||' Err is '||sqlerrm(sqlcode),20);
5278: END;
5279: ----- Reset the global variable
5280: ghr_api.g_api_dml := FALSE;
5281:
5282: ELSE
5283: ghr_position_extra_info_api.create_position_extra_info
5284: (P_POSITION_ID => p_position_id