DBA Data[Home] [Help]

APPS.HR_MX_EXTRA_ASG_RULES dependencies on HR_API

Line 169: SELECT decode(p_scl_segment1, hr_api.g_varchar2, l_scl_gre, p_scl_segment1),

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;

Line 170: decode(p_location_id, hr_api.g_number, l_location_old, p_location_id)

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:

Line 355: SELECT decode(p_segment1, hr_api.g_varchar2, l_scl_gre, p_segment1)

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