165: --------------------------------------------------------------------------
166: -- Use the old location and old SCL GRE values, if the parameters are
167: -- system defaulted. (Bug 3777663)
168: --------------------------------------------------------------------------
169: SELECT decode(p_scl_segment1, hr_api.g_varchar2, l_scl_gre, p_scl_segment1),
170: decode(p_location_id, hr_api.g_number, l_location_old, p_location_id)
171: INTO l_segment1,
172: l_location_id
173: FROM DUAL;
166: -- Use the old location and old SCL GRE values, if the parameters are
167: -- system defaulted. (Bug 3777663)
168: --------------------------------------------------------------------------
169: SELECT decode(p_scl_segment1, hr_api.g_varchar2, l_scl_gre, p_scl_segment1),
170: decode(p_location_id, hr_api.g_number, l_location_old, p_location_id)
171: INTO l_segment1,
172: l_location_id
173: FROM DUAL;
174:
351: --------------------------------------------------------------------------
352: -- Use the old SCL GRE value, if the value of p_segment1 is system
353: -- defaulted. (Bug 3777663)
354: --------------------------------------------------------------------------
355: SELECT decode(p_segment1, hr_api.g_varchar2, l_scl_gre, p_segment1)
356: INTO l_segment1
357: FROM DUAL;
358:
359: IF g_debug THEN