216: /* Trap NO_DATA_FOUND exceptions when accessing global table */
217: BEGIN
218: /* Re-use cached segment format if possible */
219: IF (g_bg_segment_value(p_business_group_id) IS NOT NULL) THEN
220: l_return_value := hr_misc_web.get_user_defined_job_segments
221: (p_job_segments => g_bg_segment_value(p_business_group_id)
222: ,p_job_name => p_job_name
223: ,p_job_id => p_job_id);
224: END IF;
224: END IF;
225: EXCEPTION WHEN OTHERS THEN
226: /* Calculate segment format for business group */
227: g_bg_segment_value(p_business_group_id) :=
228: hr_misc_web.get_sshr_segment_value
229: (p_bg_id => p_business_group_id,
230: p_user_column_name => 'Display MEE Job Segments');
231: /* If a value is found use it */
232: IF (g_bg_segment_value(p_business_group_id) IS NOT NULL) THEN
229: (p_bg_id => p_business_group_id,
230: p_user_column_name => 'Display MEE Job Segments');
231: /* If a value is found use it */
232: IF (g_bg_segment_value(p_business_group_id) IS NOT NULL) THEN
233: l_return_value := hr_misc_web.get_user_defined_job_segments
234: (p_job_segments => g_bg_segment_value(p_business_group_id)
235: ,p_job_name => p_job_name
236: ,p_job_id => p_job_id);
237: END IF;