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.GHR_MLC_PKG dependencies on HR_API

Line 1600: AND l_user_table_id = nvl(l_pay_table_id,hr_api.g_number)

1596: END;
1597:
1598: --3 Pay plan and tableid check
1599: IF ( nvl(rec_pp_prd_per_gr(l_cnt).pay_plan,l_pay_plan) = l_pay_plan
1600: AND l_user_table_id = nvl(l_pay_table_id,hr_api.g_number)
1601: AND nvl(rec_pp_prd_per_gr(l_cnt).grade,l_grade_or_level)=l_grade_or_level) THEN
1602:
1603: IF check_eligibility_mtc(
1604: l_pay_plan,

Line 2392: l_position_title := ghr_api.get_position_title_pos

2388:
2389: l_personnel_office_id := l_pos_grp1_rec.poei_information3;
2390: l_org_structure_id := l_pos_grp1_rec.poei_information5;
2391:
2392: l_position_title := ghr_api.get_position_title_pos
2393: (p_position_id => l_position_id
2394: ,p_business_group_id => l_business_group_id ) ;
2395:
2396: l_sub_element_code := ghr_api.get_position_agency_code_pos

Line 2396: l_sub_element_code := ghr_api.get_position_agency_code_pos

2392: l_position_title := ghr_api.get_position_title_pos
2393: (p_position_id => l_position_id
2394: ,p_business_group_id => l_business_group_id ) ;
2395:
2396: l_sub_element_code := ghr_api.get_position_agency_code_pos
2397: (l_position_id,l_business_group_id);
2398:
2399: l_occ_series := ghr_api.get_job_occ_series_job
2400: (p_job_id => un_per.job_id

Line 2399: l_occ_series := ghr_api.get_job_occ_series_job

2395:
2396: l_sub_element_code := ghr_api.get_position_agency_code_pos
2397: (l_position_id,l_business_group_id);
2398:
2399: l_occ_series := ghr_api.get_job_occ_series_job
2400: (p_job_id => un_per.job_id
2401: ,p_business_group_id => un_per.business_group_id);
2402:
2403: l_position_NUMBER := ghr_api.get_position_desc_no_pos

Line 2403: l_position_NUMBER := ghr_api.get_position_desc_no_pos

2399: l_occ_series := ghr_api.get_job_occ_series_job
2400: (p_job_id => un_per.job_id
2401: ,p_business_group_id => un_per.business_group_id);
2402:
2403: l_position_NUMBER := ghr_api.get_position_desc_no_pos
2404: (p_position_id => l_position_id
2405: ,p_business_group_id => un_per.business_group_id);
2406:
2407: l_position_seq_no := ghr_api.get_position_sequence_no_pos

Line 2407: l_position_seq_no := ghr_api.get_position_sequence_no_pos

2403: l_position_NUMBER := ghr_api.get_position_desc_no_pos
2404: (p_position_id => l_position_id
2405: ,p_business_group_id => un_per.business_group_id);
2406:
2407: l_position_seq_no := ghr_api.get_position_sequence_no_pos
2408: (p_position_id => l_position_id
2409: ,p_business_group_id => un_per.business_group_id);
2410:
2411: -- Check Locality Area Code

Line 2435: AND l_user_table_id = nvl(l_pay_table_id,hr_api.g_number)

2431:
2432: --2 Check Duty station code,POI,agnecy and subelement.
2433:
2434: IF l_locality_check
2435: AND l_user_table_id = nvl(l_pay_table_id,hr_api.g_number)
2436: AND check_init_eligibility(l_p_duty_station_id,
2437: l_p_PERSONNEL_OFFICE_ID,
2438: l_p_AGENCY_CODE_SUBELEMENT,
2439: l_duty_station_id,

Line 2461: AND l_user_table_id = nvl(l_pay_table_id,hr_api.g_number)

2457:
2458: hr_utility.set_location('For internal loop l_cnt ' || to_char(l_cnt) || l_proc,58);
2459: --4 Pay plan , table, grade check
2460: IF ( nvl(rec_pp_prd_per_gr(l_cnt).pay_plan,l_pay_plan) = l_pay_plan
2461: AND l_user_table_id = nvl(l_pay_table_id,hr_api.g_number)
2462: AND nvl(rec_pp_prd_per_gr(l_cnt).grade,l_grade_or_level)=l_grade_or_level ) THEN
2463:
2464: hr_utility.set_location('check l_pay_plan ' || l_pay_plan || l_proc,58);
2465: hr_utility.set_location('check l_grade_or_level ' || l_grade_or_level || l_proc,58);

Line 2572: ghr_api.g_api_dml := TRUE;

2568: END LOOP;
2569: --Bug 4699955
2570: if l_sel_flg = 'Y' then
2571: begin
2572: ghr_api.g_api_dml := TRUE;
2573: ghr_position_extra_info_api.update_position_extra_info
2574: ( p_position_extra_info_id => l_pos_valid_grade_ei_data.position_extra_info_id
2575: , p_effective_date => l_effective_date
2576: , p_object_version_number => l_pos_valid_grade_ei_data.object_version_number

Line 2578: ghr_api.g_api_dml := FALSE;

2574: ( p_position_extra_info_id => l_pos_valid_grade_ei_data.position_extra_info_id
2575: , p_effective_date => l_effective_date
2576: , p_object_version_number => l_pos_valid_grade_ei_data.object_version_number
2577: , p_poei_information5 => l_to_pay_table_id);
2578: ghr_api.g_api_dml := FALSE;
2579:
2580: ghr_validate_perwsdpo.validate_perwsdpo(l_position_id,l_effective_date);
2581: ghr_validate_perwsdpo.update_posn_status(l_position_id,l_effective_date);
2582:

Line 3918: ghr_api.retrieve_element_entry_value

3914: -- Ashley 17-JUL-03 Payroll Intg Modified the Input Value name
3915: -- Changes from Total Salary -> Amount
3916: -- Adjusted Pay -> Amount
3917:
3918: ghr_api.retrieve_element_entry_value
3919: (p_element_name => 'Total Pay'
3920: ,p_input_value_name => 'Amount'
3921: ,p_assignment_id => p_assignment_id
3922: ,p_effective_date => p_effective_date

Line 3933: ghr_api.retrieve_element_entry_value

3929: hr_utility.set_message(8301, 'GHR_38014_API_MULTI_ELE_ENTR');
3930: hr_utility.raise_error;
3931: end if;
3932:
3933: ghr_api.retrieve_element_entry_value
3934: (p_element_name => 'Basic Salary Rate'
3935: ,p_input_value_name => 'Rate'
3936: ,p_assignment_id => p_assignment_id
3937: ,p_effective_date => p_effective_date

Line 3948: ghr_api.retrieve_element_entry_value

3944: hr_utility.set_message(8301, 'GHR_38014_API_MULTI_ELE_ENTR');
3945: hr_utility.raise_error;
3946: end if;
3947:
3948: ghr_api.retrieve_element_entry_value
3949: (p_element_name => 'Locality Pay or SR Supplement'
3950: ,p_input_value_name => 'Rate'
3951: -- Changed by Ashu. 'Amount' to 'Rate'
3952: ,p_assignment_id => p_assignment_id

Line 3964: ghr_api.retrieve_element_entry_value

3960: hr_utility.set_message(8301, 'GHR_38014_API_MULTI_ELE_ENTR');
3961: hr_utility.raise_error;
3962: end if;
3963:
3964: ghr_api.retrieve_element_entry_value
3965: (p_element_name => 'Adjusted Basic 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 => 'Other Pay'
3981: ,p_input_value_name => 'Amount'
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 => 'AUO'
3996: ,p_input_value_name => 'Amount'
3997: ,p_assignment_id => p_assignment_id
3998: ,p_effective_date => p_effective_date

Line 4009: ghr_api.retrieve_element_entry_value

4005: hr_utility.set_message(8301, 'GHR_38014_API_MULTI_ELE_ENTR');
4006: hr_utility.raise_error;
4007: end if;
4008:
4009: ghr_api.retrieve_element_entry_value
4010: (p_element_name => 'AUO'
4011: ,p_input_value_name => 'Premium Pay Ind'
4012: ,p_assignment_id => p_assignment_id
4013: ,p_effective_date => p_effective_date

Line 4022: ghr_api.retrieve_element_entry_value

4018: hr_utility.set_message(8301, 'GHR_38014_API_MULTI_ELE_ENTR');
4019: hr_utility.raise_error;
4020: end if;
4021:
4022: ghr_api.retrieve_element_entry_value
4023: (p_element_name => 'Availability Pay'
4024: ,p_input_value_name => 'Amount'
4025: ,p_assignment_id => p_assignment_id
4026: ,p_effective_date => p_effective_date

Line 4037: ghr_api.retrieve_element_entry_value

4033: hr_utility.set_message(8301, 'GHR_38014_API_MULTI_ELE_ENTR');
4034: hr_utility.raise_error;
4035: end if;
4036:
4037: ghr_api.retrieve_element_entry_value
4038: (p_element_name => 'Availability Pay'
4039: ,p_input_value_name => 'Premium Pay Ind'
4040: ,p_assignment_id => p_assignment_id
4041: ,p_effective_date => p_effective_date

Line 4050: ghr_api.retrieve_element_entry_value

4046: hr_utility.set_message(8301, 'GHR_38014_API_MULTI_ELE_ENTR');
4047: hr_utility.raise_error;
4048: end if;
4049: --
4050: ghr_api.retrieve_element_entry_value
4051: (p_element_name => 'Retention Allowance'
4052: ,p_input_value_name => 'Amount'
4053: ,p_assignment_id => p_assignment_id
4054: ,p_effective_date => p_effective_date

Line 4065: ghr_api.retrieve_element_entry_value

4061: hr_utility.set_message(8301, 'GHR_38014_API_MULTI_ELE_ENTR');
4062: hr_utility.raise_error;
4063: end if;
4064:
4065: ghr_api.retrieve_element_entry_value
4066: (p_element_name => 'Retention Allowance'
4067: ,p_input_value_name => 'Percentage'
4068: ,p_assignment_id => p_assignment_id
4069: ,p_effective_date => p_effective_date

Line 4080: ghr_api.retrieve_element_entry_value

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

Line 4095: ghr_api.retrieve_element_entry_value

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

Line 4112: ghr_api.retrieve_element_entry_value

4108: end if;
4109:
4110: --
4111: --
4112: ghr_api.retrieve_element_entry_value
4113: (p_element_name => 'Staffing Differential'
4114: ,p_input_value_name => 'Amount'
4115: ,p_assignment_id => p_assignment_id
4116: ,p_effective_date => p_effective_date

Line 4170: p_sub_element_code := ghr_api.get_position_agency_code_pos

4166: l_proc varchar2(72) := g_package || '.get_sub_element_code_pos_title';
4167: begin
4168: g_proc := 'get_sub_element_code_pos_title';
4169: hr_utility.set_location('Entering ' || l_proc,5);
4170: p_sub_element_code := ghr_api.get_position_agency_code_pos
4171: (p_position_id,p_business_group_id,p_effective_date);
4172:
4173: p_position_title := ghr_api.get_position_title_pos
4174: (p_position_id => p_position_id

Line 4173: p_position_title := ghr_api.get_position_title_pos

4169: hr_utility.set_location('Entering ' || l_proc,5);
4170: p_sub_element_code := ghr_api.get_position_agency_code_pos
4171: (p_position_id,p_business_group_id,p_effective_date);
4172:
4173: p_position_title := ghr_api.get_position_title_pos
4174: (p_position_id => p_position_id
4175: ,p_business_group_id => p_business_group_id
4176: ,p_effective_date => p_effective_date ) ;
4177:

Line 4179: p_position_number := ghr_api.get_position_description_no

4175: ,p_business_group_id => p_business_group_id
4176: ,p_effective_date => p_effective_date ) ;
4177:
4178: -- if p_person_id is not null then
4179: p_position_number := ghr_api.get_position_description_no
4180: (p_person_id => p_person_id
4181: ,p_assignment_id => p_assignment_id
4182: ,p_effective_date => p_effective_date
4183: );

Line 4185: p_position_seq_no := ghr_api.get_position_sequence_no

4181: ,p_assignment_id => p_assignment_id
4182: ,p_effective_date => p_effective_date
4183: );
4184:
4185: p_position_seq_no := ghr_api.get_position_sequence_no
4186: (p_person_id => p_person_id
4187: ,p_assignment_id => p_assignment_id
4188: ,p_effective_date => p_effective_date
4189: );

Line 5005: ghr_api.g_api_dml := TRUE;

5001:
5002: if l_position_extra_info_id is not null then
5003:
5004: ----- Set the global variable not to fire the trigger
5005: ghr_api.g_api_dml := TRUE;
5006:
5007: BEGIN
5008:
5009: ghr_position_extra_info_api.UPDATE_position_extra_info

Line 5024: ghr_api.g_api_dml := FALSE;

5020: hr_utility.set_location('Error in '||l_proc||' Err is '||sqlerrm(sqlcode),20);
5021: END;
5022:
5023: ----- Reset the global variable
5024: ghr_api.g_api_dml := FALSE;
5025:
5026: END IF;
5027: END;
5028: --

Line 5206: ghr_api.g_api_dml := TRUE;

5202:
5203: if l_position_extra_info_id is not null then
5204:
5205: ----- Set the global variable not to fire the trigger
5206: ghr_api.g_api_dml := TRUE;
5207:
5208: BEGIN
5209: ghr_position_extra_info_api.UPDATE_position_extra_info
5210: (P_POSITION_EXTRA_INFO_ID => l_position_extra_info_id

Line 5222: ghr_api.g_api_dml := FALSE;

5218: hr_utility.set_location('UPDATE posei error 1' || l_proc,10);
5219: hr_utility.set_location('Error in '||l_proc||' Err is '||sqlerrm(sqlcode),20);
5220: END;
5221: ----- Reset the global variable
5222: ghr_api.g_api_dml := FALSE;
5223:
5224: ELSE
5225: ghr_position_extra_info_api.create_position_extra_info
5226: (P_POSITION_ID => p_position_id