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 670: l_occ_series := ghr_api.get_job_occ_series_job

666: per.person_id,
667: l_effective_DATE,
668: UPPER(p_action)) THEN
669:
670: l_occ_series := ghr_api.get_job_occ_series_job
671: (p_job_id => per.job_id
672: ,p_business_group_id => per.business_group_id
673: );
674: l_ind := 60;

Line 1465: l_position_title := ghr_api.get_position_title_pos

1461: l_sel_flg) then
1462: pr('After check sel flg value is ',l_sel_flg,l_sel_status);
1463: null;
1464: END IF;
1465: l_position_title := ghr_api.get_position_title_pos
1466: (p_position_id => l_position_id
1467: ,p_business_group_id => l_business_group_id ) ;
1468:
1469: l_sub_element_code := ghr_api.get_position_agency_code_pos

Line 1469: l_sub_element_code := ghr_api.get_position_agency_code_pos

1465: l_position_title := ghr_api.get_position_title_pos
1466: (p_position_id => l_position_id
1467: ,p_business_group_id => l_business_group_id ) ;
1468:
1469: l_sub_element_code := ghr_api.get_position_agency_code_pos
1470: (l_position_id,l_business_group_id);
1471:
1472: l_occ_series := ghr_api.get_job_occ_series_job
1473: (p_job_id => per.job_id

Line 1472: l_occ_series := ghr_api.get_job_occ_series_job

1468:
1469: l_sub_element_code := ghr_api.get_position_agency_code_pos
1470: (l_position_id,l_business_group_id);
1471:
1472: l_occ_series := ghr_api.get_job_occ_series_job
1473: (p_job_id => per.job_id
1474: ,p_business_group_id => per.business_group_id
1475: );
1476:

Line 1477: l_position_NUMBER := ghr_api.get_position_desc_no_pos

1473: (p_job_id => per.job_id
1474: ,p_business_group_id => per.business_group_id
1475: );
1476:
1477: l_position_NUMBER := ghr_api.get_position_desc_no_pos
1478: (p_position_id => l_position_id
1479: ,p_business_group_id => per.business_group_id
1480: );
1481:

Line 1482: l_position_seq_no := ghr_api.get_position_sequence_no_pos

1478: (p_position_id => l_position_id
1479: ,p_business_group_id => per.business_group_id
1480: );
1481:
1482: l_position_seq_no := ghr_api.get_position_sequence_no_pos
1483: (p_position_id => l_position_id
1484: ,p_business_group_id => per.business_group_id
1485: );
1486:

Line 1692: l_target_agency_code := ghr_api.get_position_agency_code_pos

1688: l_position_data_rec.effective_DATE := l_effective_DATE;
1689: l_position_data_rec.organization_id := p_new_organization_id;
1690: l_pos_business_group_id := per_vacant.business_group_id;
1691:
1692: l_target_agency_code := ghr_api.get_position_agency_code_pos
1693: (l_new_position_id,l_pos_business_group_id);
1694:
1695: l_position_title := ghr_api.get_position_title_pos
1696: (p_position_id => l_new_position_id

Line 1695: l_position_title := ghr_api.get_position_title_pos

1691:
1692: l_target_agency_code := ghr_api.get_position_agency_code_pos
1693: (l_new_position_id,l_pos_business_group_id);
1694:
1695: l_position_title := ghr_api.get_position_title_pos
1696: (p_position_id => l_new_position_id
1697: ,p_business_group_id => l_pos_business_group_id ) ;
1698:
1699: -----Added by AVR for checking the eligibility of Vacant Position

Line 1708: l_sub_element_code := ghr_api.get_position_agency_code_pos

1704: l_office_symbol,
1705: l_position_organization,
1706: l_pos_grp1_rec);
1707:
1708: l_sub_element_code := ghr_api.get_position_agency_code_pos
1709: (l_new_position_id,l_pos_business_group_id);
1710:
1711: -- Bug#4388288 Added the following..
1712: l_position_NUMBER := ghr_api.get_position_desc_no_pos

Line 1712: l_position_NUMBER := ghr_api.get_position_desc_no_pos

1708: l_sub_element_code := ghr_api.get_position_agency_code_pos
1709: (l_new_position_id,l_pos_business_group_id);
1710:
1711: -- Bug#4388288 Added the following..
1712: l_position_NUMBER := ghr_api.get_position_desc_no_pos
1713: (p_position_id => l_new_position_id
1714: ,p_business_group_id => l_pos_business_group_id
1715: );
1716:

Line 1717: l_position_seq_no := ghr_api.get_position_sequence_no_pos

1713: (p_position_id => l_new_position_id
1714: ,p_business_group_id => l_pos_business_group_id
1715: );
1716:
1717: l_position_seq_no := ghr_api.get_position_sequence_no_pos
1718: (p_position_id => l_new_position_id
1719: ,p_business_group_id => l_pos_business_group_id
1720: );
1721:

Line 1840: ghr_api.g_api_dml := TRUE;

1836: g_proc := 'UpDATE Vacant Position';
1837:
1838: if l_new_pos_grp1_rec.position_extra_info_id is Not NULL THEN
1839: ----- Set the global variable not to fire the trigger
1840: ghr_api.g_api_dml := TRUE;
1841: ghr_position_extra_info_api.UPDATE_position_extra_info
1842: (p_position_extra_info_id => l_new_pos_grp1_rec.position_extra_info_id
1843: ,p_effective_DATE => l_effective_DATE
1844: ,p_object_version_NUMBER => l_new_pos_grp1_rec.object_version_NUMBER

Line 1851: ghr_api.g_api_dml := FALSE;

1847: ,p_poei_information18 => l_target_payroll_office_id
1848: ,p_poei_information21 => l_target_position_organization
1849: ,p_poei_information_category => 'GHR_US_POS_GRP1');
1850: ----- Reset the global variable
1851: ghr_api.g_api_dml := FALSE;
1852: END IF;
1853:
1854: if l_pos_ei_data_rec.position_extra_info_id is Not NULL THEN
1855: ----- Set the global variable not to fire the trigger

Line 1856: ghr_api.g_api_dml := TRUE;

1852: END IF;
1853:
1854: if l_pos_ei_data_rec.position_extra_info_id is Not NULL THEN
1855: ----- Set the global variable not to fire the trigger
1856: ghr_api.g_api_dml := TRUE;
1857: ghr_position_extra_info_api.UPDATE_position_extra_info
1858: (p_position_extra_info_id => l_pos_ei_data_rec.position_extra_info_id
1859: ,p_effective_DATE => l_effective_DATE
1860: ,p_object_version_NUMBER => l_pos_ei_data_rec.object_version_NUMBER

Line 1866: ghr_api.g_api_dml := FALSE;

1862: ,p_poei_information13 => l_target_appropriation_code1
1863: ,p_poei_information14 => l_target_appropriation_code2
1864: ,p_poei_information_category => 'GHR_US_POS_GRP2');
1865: ----- Reset the global variable
1866: ghr_api.g_api_dml := FALSE;
1867: END IF;
1868:
1869: ghr_mto_int.log_message(
1870: p_procedure => 'Successful Completion',

Line 2273: ghr_api.g_api_dml := TRUE;

2269:
2270: if l_position_extra_info_id is not null then
2271:
2272: ----- Set the global variable not to fire the trigger
2273: ghr_api.g_api_dml := TRUE;
2274:
2275: BEGIN
2276: ghr_position_extra_info_api.UPDATE_position_extra_info
2277: (P_POSITION_EXTRA_INFO_ID => l_position_extra_info_id

Line 2289: ghr_api.g_api_dml := FALSE;

2285: hr_utility.set_location('UPDATE posei error 1' || l_proc,10);
2286: hr_utility.set_location('Error in '||l_proc||' Err is '||sqlerrm(sqlcode),20);
2287: END;
2288: ----- Reset the global variable
2289: ghr_api.g_api_dml := FALSE;
2290:
2291: ELSE
2292: -- Bug#4215231 Set the global variable not to fire the trigger
2293: ghr_api.g_api_dml := TRUE;

Line 2293: ghr_api.g_api_dml := TRUE;

2289: ghr_api.g_api_dml := FALSE;
2290:
2291: ELSE
2292: -- Bug#4215231 Set the global variable not to fire the trigger
2293: ghr_api.g_api_dml := TRUE;
2294: ghr_position_extra_info_api.create_position_extra_info
2295: (P_POSITION_ID => p_position_id
2296: ,P_INFORMATION_TYPE => 'GHR_US_POS_MASS_ACTIONS'
2297: ,P_EFFECTIVE_DATE => trunc(l_eff_DATE)

Line 2306: ghr_api.g_api_dml := FALSE;

2302: ,P_POSITION_EXTRA_INFO_ID => l_position_extra_info_id
2303: ,P_OBJECT_VERSION_NUMBER => l_object_version_NUMBER);
2304:
2305: --Bug#4215231 Reset the global variable
2306: ghr_api.g_api_dml := FALSE;
2307:
2308: END IF;
2309: hr_utility.set_location('Exiting ' || l_proc,30);
2310:

Line 2413: ghr_api.g_api_dml := TRUE;

2409:
2410: if l_position_extra_info_id is not null then
2411:
2412: ----- Set the global variable not to fire the trigger
2413: ghr_api.g_api_dml := TRUE;
2414:
2415: BEGIN
2416: ghr_position_extra_info_api.UPDATE_position_extra_info
2417: (P_POSITION_EXTRA_INFO_ID => l_position_extra_info_id

Line 2429: ghr_api.g_api_dml := FALSE;

2425: hr_utility.set_location('Error in '||l_proc||' Err is '||sqlerrm(sqlcode),20);
2426: END;
2427:
2428: ----- Reset the global variable
2429: ghr_api.g_api_dml := FALSE;
2430:
2431:
2432: --- Commented the following two lines to remove Validation functionality on Position.
2433: ---- ghr_valiDATE_perwsdpo.valiDATE_perwsdpo(p_position_id);

Line 3752: ghr_api.g_api_dml := TRUE;

3748:
3749: if l_position_extra_info_id is not null then
3750:
3751: ----- Set the global variable not to fire the trigger
3752: ghr_api.g_api_dml := TRUE;
3753:
3754: BEGIN
3755:
3756: -- Bug#2944091 Instead of trunc(sysDATE) , l_eff_DATE is passed.

Line 3781: ghr_api.g_api_dml := FALSE;

3777: hr_utility.set_location('Error in '||l_proc||' Err is '||sqlerrm(sqlcode),20);
3778: END;
3779:
3780: ----- Reset the global variable
3781: ghr_api.g_api_dml := FALSE;
3782:
3783:
3784: --- Commented the following two lines to remove Validation functionality on Position.
3785: ---- ghr_valiDATE_perwsdpo.valiDATE_perwsdpo(p_position_id);

Line 3864: ghr_api.g_api_dml := TRUE;

3860: ,P_OBJECT_VERSION_NUMBER => L_OBJECT_VERSION_NUMBER);
3861: ELSE
3862:
3863: ----- Set the global variable not to fire the trigger
3864: ghr_api.g_api_dml := TRUE;
3865:
3866: BEGIN
3867: ghr_position_extra_info_api.UPDATE_position_extra_info
3868: (P_POSITION_EXTRA_INFO_ID => l_position_extra_info_id

Line 3888: ghr_api.g_api_dml := FALSE;

3884: hr_utility.set_location('Error in '||l_proc||' Err is '||sqlerrm(sqlcode),20);
3885: END;
3886:
3887: ----- Reset the global variable
3888: ghr_api.g_api_dml := FALSE;
3889:
3890: END IF;
3891:
3892: --- Commented the following two lines to remove Validation functionality on Position.