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_MRE_PKG dependencies on HR_API

Line 681: l_occ_series := ghr_api.get_job_occ_series_job

677: per.person_id,
678: l_effective_DATE,
679: UPPER(p_action)) THEN
680:
681: l_occ_series := ghr_api.get_job_occ_series_job
682: (p_job_id => per.job_id
683: ,p_business_group_id => per.business_group_id
684: );
685: l_ind := 60;

Line 1495: l_position_title := ghr_api.get_position_title_pos

1491: l_sel_flg) then
1492: pr('After check sel flg value is ',l_sel_flg,l_sel_status);
1493: null;
1494: END IF;
1495: l_position_title := ghr_api.get_position_title_pos
1496: (p_position_id => l_position_id
1497: ,p_business_group_id => l_business_group_id ) ;
1498:
1499: l_sub_element_code := ghr_api.get_position_agency_code_pos

Line 1499: l_sub_element_code := ghr_api.get_position_agency_code_pos

1495: l_position_title := ghr_api.get_position_title_pos
1496: (p_position_id => l_position_id
1497: ,p_business_group_id => l_business_group_id ) ;
1498:
1499: l_sub_element_code := ghr_api.get_position_agency_code_pos
1500: (l_position_id,l_business_group_id);
1501:
1502: l_occ_series := ghr_api.get_job_occ_series_job
1503: (p_job_id => per.job_id

Line 1502: l_occ_series := ghr_api.get_job_occ_series_job

1498:
1499: l_sub_element_code := ghr_api.get_position_agency_code_pos
1500: (l_position_id,l_business_group_id);
1501:
1502: l_occ_series := ghr_api.get_job_occ_series_job
1503: (p_job_id => per.job_id
1504: ,p_business_group_id => per.business_group_id
1505: );
1506:

Line 1507: l_position_NUMBER := ghr_api.get_position_desc_no_pos

1503: (p_job_id => per.job_id
1504: ,p_business_group_id => per.business_group_id
1505: );
1506:
1507: l_position_NUMBER := ghr_api.get_position_desc_no_pos
1508: (p_position_id => l_position_id
1509: ,p_business_group_id => per.business_group_id
1510: );
1511:

Line 1512: l_position_seq_no := ghr_api.get_position_sequence_no_pos

1508: (p_position_id => l_position_id
1509: ,p_business_group_id => per.business_group_id
1510: );
1511:
1512: l_position_seq_no := ghr_api.get_position_sequence_no_pos
1513: (p_position_id => l_position_id
1514: ,p_business_group_id => per.business_group_id
1515: );
1516:

Line 1727: l_target_agency_code := ghr_api.get_position_agency_code_pos(l_new_position_id,l_pos_business_group_id);

1723: l_position_data_rec.position_id := l_new_position_id;
1724: l_position_data_rec.effective_DATE := l_effective_DATE;
1725: l_position_data_rec.organization_id := p_new_organization_id;
1726: l_pos_business_group_id := per_vacant.business_group_id;
1727: l_target_agency_code := ghr_api.get_position_agency_code_pos(l_new_position_id,l_pos_business_group_id);
1728: l_position_title := ghr_api.get_position_title_pos(p_position_id => l_new_position_id
1729: ,p_business_group_id => l_pos_business_group_id ) ;
1730:
1731: -----Added by AVR for checking the eligibility of Vacant Position

Line 1728: l_position_title := ghr_api.get_position_title_pos(p_position_id => l_new_position_id

1724: l_position_data_rec.effective_DATE := l_effective_DATE;
1725: l_position_data_rec.organization_id := p_new_organization_id;
1726: l_pos_business_group_id := per_vacant.business_group_id;
1727: l_target_agency_code := ghr_api.get_position_agency_code_pos(l_new_position_id,l_pos_business_group_id);
1728: l_position_title := ghr_api.get_position_title_pos(p_position_id => l_new_position_id
1729: ,p_business_group_id => l_pos_business_group_id ) ;
1730:
1731: -----Added by AVR for checking the eligibility of Vacant Position
1732: get_pos_grp1_ddf(l_new_position_id,

Line 1740: l_sub_element_code := ghr_api.get_position_agency_code_pos

1736: l_office_symbol,
1737: l_position_organization,
1738: l_pos_grp1_rec);
1739:
1740: l_sub_element_code := ghr_api.get_position_agency_code_pos
1741: (l_new_position_id,l_pos_business_group_id);
1742:
1743: -- Bug#4388288 Added the following..
1744: l_position_NUMBER := ghr_api.get_position_desc_no_pos

Line 1744: l_position_NUMBER := ghr_api.get_position_desc_no_pos

1740: l_sub_element_code := ghr_api.get_position_agency_code_pos
1741: (l_new_position_id,l_pos_business_group_id);
1742:
1743: -- Bug#4388288 Added the following..
1744: l_position_NUMBER := ghr_api.get_position_desc_no_pos
1745: (p_position_id => l_new_position_id
1746: ,p_business_group_id => l_pos_business_group_id);
1747:
1748: l_position_seq_no := ghr_api.get_position_sequence_no_pos

Line 1748: l_position_seq_no := ghr_api.get_position_sequence_no_pos

1744: l_position_NUMBER := ghr_api.get_position_desc_no_pos
1745: (p_position_id => l_new_position_id
1746: ,p_business_group_id => l_pos_business_group_id);
1747:
1748: l_position_seq_no := ghr_api.get_position_sequence_no_pos
1749: (p_position_id => l_new_position_id
1750: ,p_business_group_id => l_pos_business_group_id
1751: );
1752:

Line 1902: ghr_api.g_api_dml := TRUE;

1898: -- Updating Position Extra Information for Position GRP1
1899: g_proc := 'UpDATE Vacant Position';
1900: if l_new_pos_grp1_rec.position_extra_info_id is Not NULL THEN
1901: ----- Set the global variable not to fire the trigger
1902: ghr_api.g_api_dml := TRUE;
1903: --BUG #13872029 Added Exception procedure wise
1904: BEGIN
1905: ghr_position_extra_info_api.UPDATE_position_extra_info
1906: (p_position_extra_info_id => l_new_pos_grp1_rec.position_extra_info_id

Line 1925: ghr_api.g_api_dml := FALSE;

1921: raise mass_error;
1922: END;
1923:
1924: ----- Reset the global variable
1925: ghr_api.g_api_dml := FALSE;
1926: END IF;
1927:
1928: if l_pos_ei_data_rec.position_extra_info_id is Not NULL THEN
1929: ----- Set the global variable not to fire the trigger

Line 1930: ghr_api.g_api_dml := TRUE;

1926: END IF;
1927:
1928: if l_pos_ei_data_rec.position_extra_info_id is Not NULL THEN
1929: ----- Set the global variable not to fire the trigger
1930: ghr_api.g_api_dml := TRUE;
1931: --BUG #13872029 Added Exception procedure wise
1932: BEGIN
1933: ghr_position_extra_info_api.UPDATE_position_extra_info
1934: (p_position_extra_info_id => l_pos_ei_data_rec.position_extra_info_id

Line 1942: ghr_api.g_api_dml := FALSE;

1938: ,p_poei_information13 => l_target_appropriation_code1
1939: ,p_poei_information14 => l_target_appropriation_code2
1940: ,p_poei_information_category => 'GHR_US_POS_GRP2');
1941: ---- Reset the global variable
1942: ghr_api.g_api_dml := FALSE;
1943: EXCEPTION
1944: WHEN OTHERS THEN
1945: pr('Error in UPDATE_position_extra_info is '||
1946: l_errbuf||' '||to_char(l_retcode));

Line 2423: ghr_api.g_api_dml := TRUE;

2419:
2420: if l_position_extra_info_id is not null then
2421:
2422: ----- Set the global variable not to fire the trigger
2423: ghr_api.g_api_dml := TRUE;
2424:
2425: BEGIN
2426: ghr_position_extra_info_api.UPDATE_position_extra_info
2427: (P_POSITION_EXTRA_INFO_ID => l_position_extra_info_id

Line 2439: ghr_api.g_api_dml := FALSE;

2435: hr_utility.set_location('UPDATE posei error 1' || l_proc,10);
2436: hr_utility.set_location('Error in '||l_proc||' Err is '||sqlerrm(sqlcode),20);
2437: END;
2438: ----- Reset the global variable
2439: ghr_api.g_api_dml := FALSE;
2440:
2441: ELSE
2442: -- Bug#4215231 Set the global variable not to fire the trigger
2443: ghr_api.g_api_dml := TRUE;

Line 2443: ghr_api.g_api_dml := TRUE;

2439: ghr_api.g_api_dml := FALSE;
2440:
2441: ELSE
2442: -- Bug#4215231 Set the global variable not to fire the trigger
2443: ghr_api.g_api_dml := TRUE;
2444: ghr_position_extra_info_api.create_position_extra_info
2445: (P_POSITION_ID => p_position_id
2446: ,P_INFORMATION_TYPE => 'GHR_US_POS_MASS_ACTIONS'
2447: ,P_EFFECTIVE_DATE => trunc(l_eff_DATE)

Line 2456: ghr_api.g_api_dml := FALSE;

2452: ,P_POSITION_EXTRA_INFO_ID => l_position_extra_info_id
2453: ,P_OBJECT_VERSION_NUMBER => l_object_version_NUMBER);
2454:
2455: --Bug#4215231 Reset the global variable
2456: ghr_api.g_api_dml := FALSE;
2457:
2458: END IF;
2459: hr_utility.set_location('Exiting ' || l_proc,30);
2460:

Line 2563: ghr_api.g_api_dml := TRUE;

2559:
2560: if l_position_extra_info_id is not null then
2561:
2562: ----- Set the global variable not to fire the trigger
2563: ghr_api.g_api_dml := TRUE;
2564:
2565: BEGIN
2566: ghr_position_extra_info_api.UPDATE_position_extra_info
2567: (P_POSITION_EXTRA_INFO_ID => l_position_extra_info_id

Line 2579: ghr_api.g_api_dml := FALSE;

2575: hr_utility.set_location('Error in '||l_proc||' Err is '||sqlerrm(sqlcode),20);
2576: END;
2577:
2578: ----- Reset the global variable
2579: ghr_api.g_api_dml := FALSE;
2580:
2581:
2582: --- Commented the following two lines to remove Validation functionality on Position.
2583: ---- ghr_valiDATE_perwsdpo.valiDATE_perwsdpo(p_position_id);

Line 3919: ghr_api.g_api_dml := TRUE;

3915:
3916: if l_position_extra_info_id is not null then
3917:
3918: ----- Set the global variable not to fire the trigger
3919: ghr_api.g_api_dml := TRUE;
3920:
3921: BEGIN
3922:
3923: -- Bug#2944091 Instead of trunc(sysDATE) , l_eff_DATE is passed.

Line 3948: ghr_api.g_api_dml := FALSE;

3944: hr_utility.set_location('Error in '||l_proc||' Err is '||sqlerrm(sqlcode),20);
3945: END;
3946:
3947: ----- Reset the global variable
3948: ghr_api.g_api_dml := FALSE;
3949:
3950:
3951: --- Commented the following two lines to remove Validation functionality on Position.
3952: ---- ghr_valiDATE_perwsdpo.valiDATE_perwsdpo(p_position_id);

Line 4031: ghr_api.g_api_dml := TRUE;

4027: ,P_OBJECT_VERSION_NUMBER => L_OBJECT_VERSION_NUMBER);
4028: ELSE
4029:
4030: ----- Set the global variable not to fire the trigger
4031: ghr_api.g_api_dml := TRUE;
4032:
4033: BEGIN
4034: ghr_position_extra_info_api.UPDATE_position_extra_info
4035: (P_POSITION_EXTRA_INFO_ID => l_position_extra_info_id

Line 4055: ghr_api.g_api_dml := FALSE;

4051: hr_utility.set_location('Error in '||l_proc||' Err is '||sqlerrm(sqlcode),20);
4052: END;
4053:
4054: ----- Reset the global variable
4055: ghr_api.g_api_dml := FALSE;
4056:
4057: END IF;
4058:
4059: --- Commented the following two lines to remove Validation functionality on Position.