147: p_effective_date);
148: END IF;
149: IF p_segment8 <> hr_api.g_varchar2 THEN
150: BEGIN
151: SELECT '1' INTO l_lookup_exists FROM hr_lookups WHERE lookup_type='RU_SPECIAL_WORK_CONDITIONS'
152: AND lookup_code=p_segment8 AND enabled_flag='Y';
153: EXCEPTION
154: WHEN NO_DATA_FOUND THEN
155: hr_utility.set_message (800, 'HR_7209_API_LOOK_INVALID');
158: END;
159: END IF;
160: IF p_segment12 <> hr_api.g_varchar2 THEN
161: BEGIN
162: SELECT '1' INTO l_lookup_exists FROM hr_lookups WHERE lookup_type='RU_LONG_SERVICE'
163: AND lookup_code=p_segment12 AND enabled_flag='Y';
164: EXCEPTION
165: WHEN NO_DATA_FOUND THEN
166: hr_utility.set_message (800, 'HR_7209_API_LOOK_INVALID');
318: p_effective_date);
319: END IF;
320: IF p_scl_segment8 <> hr_api.g_varchar2 THEN
321: BEGIN
322: SELECT '1' INTO l_lookup_exists FROM hr_lookups WHERE lookup_type='RU_SPECIAL_WORK_CONDITIONS'
323: AND lookup_code=p_scl_segment8 AND enabled_flag='Y';
324: EXCEPTION
325: WHEN NO_DATA_FOUND THEN
326: hr_utility.set_message (800, 'HR_7209_API_LOOK_INVALID');
329: END;
330: END IF;
331: IF p_scl_segment12 <> hr_api.g_varchar2 THEN
332: BEGIN
333: SELECT '1' INTO l_lookup_exists FROM hr_lookups WHERE lookup_type='RU_LONG_SERVICE'
334: AND lookup_code=p_scl_segment12 AND enabled_flag='Y';
335: EXCEPTION
336: WHEN NO_DATA_FOUND THEN
337: hr_utility.set_message (800, 'HR_7209_API_LOOK_INVALID');