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

Line 247: ghr_api.get_position_agency_code_pos(paf.position_id,paf.business_group_id) like p_agency

243: and ppt.system_person_type IN ('EMP','EMP_APL')
244: and paf.organization_id = punits.organization_id
245: and paf.position_id is not null
246: and (p_agency is not null and
247: ghr_api.get_position_agency_code_pos(paf.position_id,paf.business_group_id) like p_agency
248: OR
249: p_agency is null)
250: union
251: select ppf.person_id PERSON_ID,

Line 288: ghr_api.get_position_agency_code_pos(paf.position_id,paf.business_group_id) like p_agency

284: and ppt.system_person_type IN ('EMP','EMP_APL')
285: and paf.organization_id = punits.organization_id
286: and paf.position_id is not null
287: and (p_agency is not null and
288: ghr_api.get_position_agency_code_pos(paf.position_id,paf.business_group_id) like p_agency
289: OR
290: p_agency is null);
291:
292: cursor unassigned_pos (p_org_id number,

Line 326: ghr_api.get_position_agency_code_pos(position_id,business_group_id) like p_agency

322: or position_id = nvl(p_org_id,position_id) and org_pos_fl = 'P')
323: and trunc(effective_date) between
324: effective_start_date and effective_end_date
325: and (p_agency is not null and
326: ghr_api.get_position_agency_code_pos(position_id,business_group_id) like p_agency
327: OR
328: p_agency is null)
329: MINUS
330: select a.position_id

Line 344: ghr_api.get_position_agency_code_pos(a.position_id,a.business_group_id) like p_agency

340: and a.position_id = pop.position_id
341: and trunc(effective_date) between p.effective_start_date
342: and p.effective_end_date
343: and (p_agency is not null and
344: ghr_api.get_position_agency_code_pos(a.position_id,a.business_group_id) like p_agency
345: OR
346: p_agency is null)
347: )
348: and trunc(effective_date)

Line 819: l_occ_series := ghr_api.get_job_occ_series_job

815: l_office_symbol,
816: l_position_organization,
817: l_pos_grp1_rec);
818:
819: l_occ_series := ghr_api.get_job_occ_series_job
820: (p_job_id => per.job_id
821: ,p_business_group_id => per.business_group_id
822: );
823:

Line 1295: l_position_title := ghr_api.get_position_title_pos

1291: pr('After check sel flg value is ',l_sel_flg,l_sel_status);
1292: null;
1293: end if;
1294:
1295: l_position_title := ghr_api.get_position_title_pos
1296: (p_position_id => l_position_id
1297: ,p_business_group_id => l_business_group_id ) ;
1298:
1299: l_sub_element_code := ghr_api.get_position_agency_code_pos

Line 1299: l_sub_element_code := ghr_api.get_position_agency_code_pos

1295: l_position_title := ghr_api.get_position_title_pos
1296: (p_position_id => l_position_id
1297: ,p_business_group_id => l_business_group_id ) ;
1298:
1299: l_sub_element_code := ghr_api.get_position_agency_code_pos
1300: (l_position_id,l_business_group_id);
1301:
1302: l_occ_series := ghr_api.get_job_occ_series_job
1303: (p_job_id => per.job_id

Line 1302: l_occ_series := ghr_api.get_job_occ_series_job

1298:
1299: l_sub_element_code := ghr_api.get_position_agency_code_pos
1300: (l_position_id,l_business_group_id);
1301:
1302: l_occ_series := ghr_api.get_job_occ_series_job
1303: (p_job_id => per.job_id
1304: ,p_business_group_id => per.business_group_id
1305: );
1306:

Line 1307: l_position_number := ghr_api.get_position_desc_no_pos

1303: (p_job_id => per.job_id
1304: ,p_business_group_id => per.business_group_id
1305: );
1306:
1307: l_position_number := ghr_api.get_position_desc_no_pos
1308: (p_position_id => l_position_id
1309: ,p_business_group_id => per.business_group_id
1310: );
1311:

Line 1312: l_position_seq_no := ghr_api.get_position_sequence_no_pos

1308: (p_position_id => l_position_id
1309: ,p_business_group_id => per.business_group_id
1310: );
1311:
1312: l_position_seq_no := ghr_api.get_position_sequence_no_pos
1313: (p_position_id => l_position_id
1314: ,p_business_group_id => per.business_group_id
1315: );
1316:

Line 1479: l_position_title := ghr_api.get_position_title_pos

1475: := l_effective_date + 1;
1476: -- End Bug 3531540
1477: l_business_group_id := per_vacant.business_group_iD;
1478:
1479: l_position_title := ghr_api.get_position_title_pos
1480: (p_position_id => l_position_id
1481: ,p_business_group_id => l_business_group_id ) ;
1482:
1483: ---Added by AVR Check eligibility is missing 03/30/00

Line 1484: l_sub_element_code := ghr_api.get_position_agency_code_pos

1480: (p_position_id => l_position_id
1481: ,p_business_group_id => l_business_group_id ) ;
1482:
1483: ---Added by AVR Check eligibility is missing 03/30/00
1484: l_sub_element_code := ghr_api.get_position_agency_code_pos
1485: (l_position_id,l_business_group_id);
1486:
1487: get_pos_grp1_ddf(l_position_id,
1488: l_effective_date,

Line 1912: ghr_api.g_api_dml := TRUE;

1908: end if;
1909:
1910: if l_position_extra_info_id is not null then
1911: ----- Set the global variable not to fire the trigger
1912: ghr_api.g_api_dml := TRUE;
1913: ghr_position_extra_info_api.update_position_extra_info
1914: (P_POSITION_EXTRA_INFO_ID => l_position_extra_info_id
1915: ,P_EFFECTIVE_DATE => trunc(l_eff_date)
1916: ,P_OBJECT_VERSION_NUMBER => l_object_version_number

Line 1922: ghr_api.g_api_dml := FALSE;

1918: ,p_poei_INFORMATION16 => p_comment
1919: ,p_poei_INFORMATION17 => to_char(p_mtfr_id)
1920: ,P_POEI_INFORMATION_CATEGORY => 'GHR_US_POS_MASS_ACTIONS');
1921: ----- Reset the global variable
1922: ghr_api.g_api_dml := FALSE;
1923: else
1924: -- Bug#4125231 Set the global variable not to fire the trigger
1925: ghr_api.g_api_dml := TRUE;
1926: ghr_position_extra_info_api.create_position_extra_info

Line 1925: ghr_api.g_api_dml := TRUE;

1921: ----- Reset the global variable
1922: ghr_api.g_api_dml := FALSE;
1923: else
1924: -- Bug#4125231 Set the global variable not to fire the trigger
1925: ghr_api.g_api_dml := TRUE;
1926: ghr_position_extra_info_api.create_position_extra_info
1927: (P_POSITION_ID => p_position_id
1928: ,P_INFORMATION_TYPE => 'GHR_US_POS_MASS_ACTIONS'
1929: ,P_EFFECTIVE_DATE => trunc(l_eff_date)

Line 1937: ghr_api.g_api_dml := FALSE;

1933: ,P_POEI_INFORMATION_CATEGORY => 'GHR_US_POS_MASS_ACTIONS'
1934: ,P_POSITION_EXTRA_INFO_ID => l_position_extra_info_id
1935: ,P_OBJECT_VERSION_NUMBER => l_object_version_number);
1936: --Bug#4215231 Reset the global variable
1937: ghr_api.g_api_dml := FALSE;
1938: end if;
1939: hr_utility.set_location('Exiting ' || l_proc,10);
1940:
1941: -- There is a trigger on Position extra Info. Whenever updated/created the

Line 1993: ghr_api.g_api_dml := TRUE;

1989: l_object_version_number := l_pos_ei_data.object_version_number;
1990:
1991: if l_position_extra_info_id is not null then
1992: ----- Set the global variable not to fire the trigger
1993: ghr_api.g_api_dml := TRUE;
1994: ghr_position_extra_info_api.update_position_extra_info
1995: (P_POSITION_EXTRA_INFO_ID => l_position_extra_info_id
1996: ,P_EFFECTIVE_DATE => trunc(l_eff_date)
1997: ,P_OBJECT_VERSION_NUMBER => l_object_version_number

Line 2002: ghr_api.g_api_dml := FALSE;

1998: ,p_poei_INFORMATION15 => NULL
1999: ,p_poei_INFORMATION16 => NULL
2000: ,P_POEI_INFORMATION_CATEGORY => 'GHR_US_POS_MASS_ACTIONS');
2001: ----- Reset the global variable
2002: ghr_api.g_api_dml := FALSE;
2003:
2004:
2005: --- Commented the following two lines to remove Validation functionality on Position.
2006: -- ghr_validate_perwsdpo.validate_perwsdpo(p_position_id);

Line 2836: ghr_api.g_api_dml := TRUE;

2832: l_object_version_number := l_pos_ei_data.object_version_number;
2833:
2834: if l_position_extra_info_id is not null then
2835: ----- Set the global variable not to fire the trigger
2836: ghr_api.g_api_dml := TRUE;
2837: ghr_position_extra_info_api.update_position_extra_info
2838: (P_POSITION_EXTRA_INFO_ID => l_position_extra_info_id
2839: ,P_OBJECT_VERSION_NUMBER => l_object_version_number
2840: ,P_POEI_INFORMATION_CATEGORY => 'GHR_US_POS_MASS_ACTIONS'

Line 2846: ghr_api.g_api_dml := FALSE;

2842: ,P_POEI_INFORMATION15 => null
2843: ,P_POEI_INFORMATION16 => null
2844: ,P_POEI_INFORMATION17 => null);
2845: ----- Reset the global variable
2846: ghr_api.g_api_dml := FALSE;
2847:
2848:
2849: --- Commented the following two lines to remove Validation functionality on Position.
2850: -- ghr_validate_perwsdpo.validate_perwsdpo(p_position_id);

Line 3045: ghr_api.g_api_dml := TRUE;

3041: l_object_version_number := l_per_ei_data.object_version_number;
3042:
3043: if l_person_extra_info_id is not null then
3044: ----- Set the global variable not to fire the trigger
3045: ghr_api.g_api_dml := TRUE;
3046: ghr_person_extra_info_api.update_person_extra_info
3047: (P_PERSON_EXTRA_INFO_ID => l_PERSON_extra_info_id
3048: ,P_OBJECT_VERSION_NUMBER => l_object_version_number
3049: ,P_PEI_INFORMATION_CATEGORY => 'GHR_US_PER_MASS_ACTIONS'

Line 3056: ghr_api.g_api_dml := FALSE;

3052: );
3053: -- ,P_PEI_INFORMATION16 => null
3054: -- ,P_PEI_INFORMATION17 => null);
3055: ----- Reset the global variable
3056: ghr_api.g_api_dml := FALSE;
3057: end if;
3058:
3059: End;
3060: END GHR_MTO_PKG;