APPS.GHR_MRE_PKG dependencies on GHR_MASS_REALIGNMENT

Line 283: from ghr_mass_realignment

279: old_position_id,
280: old_pos_structure_version_id old_position_structure_id,
281: PA_REQUEST_ID,
282: business_group_id
283: from ghr_mass_realignment
284: WHERE mass_realignment_id = p_mass_realignment_id
285: for UPDATE of status nowait;
286:
287: -- added this for 3191704

Line 288: target_personnel_office_id ghr_mass_realignment.personnel_office_id%type;

284: WHERE mass_realignment_id = p_mass_realignment_id
285: for UPDATE of status nowait;
286:
287: -- added this for 3191704
288: target_personnel_office_id ghr_mass_realignment.personnel_office_id%type;
289:
290: -- Bug#2651909 Cursor to get OPM Organizational Component of Target Organization
291: cursor c_opm_org_component(p_organization_id IN NUMBER) is
292: Select org_information4

Line 2072: UPDATE ghr_mass_realignment

2068: */
2069: if (l_recs_failed = 0) then
2070: IF UPPER(p_action) = 'CREATE' THEN
2071: BEGIN
2072: UPDATE ghr_mass_realignment
2073: set status = 'P'
2074: WHERE mass_realignment_id = p_mass_realignment_id;
2075: EXCEPTION
2076: when others then

Line 2093: UPDATE ghr_mass_realignment

2089: if (l_recs_failed <> 0) then
2090: p_errbuf := 'Error in '||l_proc || ' Details in GHR_PROCESS_LOG';
2091: p_retcode := 2;
2092: IF UPPER(p_action) = 'CREATE' THEN
2093: UPDATE ghr_mass_realignment
2094: set status = 'E'
2095: WHERE mass_realignment_id = p_mass_realignment_id;
2096: COMMIT;
2097: END IF;

Line 2108: UPDATE ghr_mass_realignment

2104: EXCEPTION
2105: WHEN OTHERS THEN NULL;
2106: END;
2107: IF UPPER(p_action) = 'CREATE' THEN
2108: UPDATE ghr_mass_realignment
2109: set status = 'E'
2110: WHERE mass_realignment_id = p_mass_realignment_id;
2111: COMMIT;
2112: END IF;

Line 2149: UPDATE ghr_mass_realignment

2145:
2146: p_errbuf := 'Error in '||l_proc || ' Details in GHR_PROCESS_LOG';
2147: p_retcode := 2;
2148: IF UPPER(p_action) = 'CREATE' THEN
2149: UPDATE ghr_mass_realignment
2150: set status = 'E'
2151: WHERE mass_realignment_id = p_mass_realignment_id;
2152: COMMIT;
2153: END IF;

Line 2489: FROM GHR_MASS_REALIGNMENT

2485: function get_mre_name(p_mre_id in NUMBER) return VARCHAR2 is
2486:
2487: CURSOR mre_cur is
2488: SELECT NAME
2489: FROM GHR_MASS_REALIGNMENT
2490: WHERE MASS_REALIGNMENT_ID = p_mre_id;
2491:
2492: l_mre_name VARCHAR2(150);
2493: l_proc VARCHAR2(72) := g_package || '.get_mre_name';