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 1628: AND l_user_table_id = nvl(l_pay_table_id,hr_api.g_number)

1624: END;
1625:
1626: --3 Pay plan and tableid check
1627: IF ( nvl(rec_pp_prd_per_gr(l_cnt).pay_plan,l_pay_plan) = l_pay_plan
1628: AND l_user_table_id = nvl(l_pay_table_id,hr_api.g_number)
1629: AND nvl(rec_pp_prd_per_gr(l_cnt).grade,l_grade_or_level)=l_grade_or_level) THEN
1630:
1631: IF check_eligibility_mtc(
1632: l_pay_plan,

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 2475: AND l_user_table_id = nvl(l_pay_table_id,hr_api.g_number)

2471:
2472: --2 Check Duty station code,POI,agnecy and subelement.
2473:
2474: IF l_locality_check
2475: AND l_user_table_id = nvl(l_pay_table_id,hr_api.g_number)
2476: AND check_init_eligibility(l_p_duty_station_id,
2477: l_p_PERSONNEL_OFFICE_ID,
2478: l_p_AGENCY_CODE_SUBELEMENT,
2479: l_duty_station_id,

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

2497:
2498: hr_utility.set_location('For internal loop l_cnt ' || to_char(l_cnt) || l_proc,58);
2499: --4 Pay plan , table, grade check
2500: IF ( nvl(rec_pp_prd_per_gr(l_cnt).pay_plan,l_pay_plan) = l_pay_plan
2501: AND l_user_table_id = nvl(l_pay_table_id,hr_api.g_number)
2502: AND nvl(rec_pp_prd_per_gr(l_cnt).grade,l_grade_or_level)=l_grade_or_level ) THEN
2503:
2504: hr_utility.set_location('check l_pay_plan ' || l_pay_plan || l_proc,58);
2505: hr_utility.set_location('check l_grade_or_level ' || l_grade_or_level || l_proc,58);

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