APPS.GHR_MRE_PKG dependencies on GHR_MASS_REALIGNMENT

Line 277: from ghr_mass_realignment

273: old_position_id,
274: old_pos_structure_version_id old_position_structure_id,
275: PA_REQUEST_ID,
276: business_group_id
277: from ghr_mass_realignment
278: WHERE mass_realignment_id = p_mass_realignment_id
279: for UPDATE of status nowait;
280:
281: -- added this for 3191704

Line 282: target_personnel_office_id ghr_mass_realignment.personnel_office_id%type;

278: WHERE mass_realignment_id = p_mass_realignment_id
279: for UPDATE of status nowait;
280:
281: -- added this for 3191704
282: target_personnel_office_id ghr_mass_realignment.personnel_office_id%type;
283:
284: -- Bug#2651909 Cursor to get OPM Organizational Component of Target Organization
285: cursor c_opm_org_component(p_organization_id IN NUMBER) is
286: Select org_information4

Line 1926: UPDATE ghr_mass_realignment

1922: */
1923: if (l_recs_failed = 0) then
1924: IF UPPER(p_action) = 'CREATE' THEN
1925: BEGIN
1926: UPDATE ghr_mass_realignment
1927: set status = 'P'
1928: WHERE mass_realignment_id = p_mass_realignment_id;
1929: EXCEPTION
1930: when others then

Line 1947: UPDATE ghr_mass_realignment

1943: if (l_recs_failed <> 0) then
1944: p_errbuf := 'Error in '||l_proc || ' Details in GHR_PROCESS_LOG';
1945: p_retcode := 2;
1946: IF UPPER(p_action) = 'CREATE' THEN
1947: UPDATE ghr_mass_realignment
1948: set status = 'E'
1949: WHERE mass_realignment_id = p_mass_realignment_id;
1950: COMMIT;
1951: END IF;

Line 1962: UPDATE ghr_mass_realignment

1958: EXCEPTION
1959: WHEN OTHERS THEN NULL;
1960: END;
1961: IF UPPER(p_action) = 'CREATE' THEN
1962: UPDATE ghr_mass_realignment
1963: set status = 'E'
1964: WHERE mass_realignment_id = p_mass_realignment_id;
1965: COMMIT;
1966: END IF;

Line 2002: UPDATE ghr_mass_realignment

1998:
1999: p_errbuf := 'Error in '||l_proc || ' Details in GHR_PROCESS_LOG';
2000: p_retcode := 2;
2001: IF UPPER(p_action) = 'CREATE' THEN
2002: UPDATE ghr_mass_realignment
2003: set status = 'E'
2004: WHERE mass_realignment_id = p_mass_realignment_id;
2005: COMMIT;
2006: END IF;

Line 2339: FROM GHR_MASS_REALIGNMENT

2335: function get_mre_name(p_mre_id in NUMBER) return VARCHAR2 is
2336:
2337: CURSOR mre_cur is
2338: SELECT NAME
2339: FROM GHR_MASS_REALIGNMENT
2340: WHERE MASS_REALIGNMENT_ID = p_mre_id;
2341:
2342: l_mre_name VARCHAR2(150);
2343: l_proc VARCHAR2(72) := g_package || '.get_mre_name';