[Home] [Help]
430: i number := 0;
431:
432: l_valid boolean;
433: l_doCheck boolean;
434: L_WORK_Q_ENABLE_PROFILE_OPTION IEU_UWQ_SEL_ENUMERATORS.WORK_Q_ENABLE_PROFILE_OPTION%TYPE;
435: l_profile_id NUMBER;
436:
437: BEGIN
438:
457:
458: BEGIN
459: SELECT WORK_Q_ENABLE_PROFILE_OPTION
460: INTO L_WORK_Q_ENABLE_PROFILE_OPTION
461: FROM IEU_UWQ_SEL_ENUMERATORS
462: WHERE media_type_id = c_rec.MEDIA_TYPE_ID
463: AND NVL(not_valid_flag, 'N') = 'N';
464: EXCEPTION
465: WHEN NO_DATA_FOUND THEN
697: nvl(IEU_UWQ_UTIL_PUB.to_number_noerr(fnd_profile.value(e.work_q_order_profile_option)), e.work_q_order_system_default) display_order,
698: e.work_q_register_type,
699: e.media_type_id
700: FROM
701: IEU_UWQ_SEL_ENUMERATORS e
702: WHERE EXISTS (select 'x' from FND_PROFILE_OPTIONS b
703: where b.PROFILE_OPTION_NAME = upper(e.work_q_enable_profile_option)
704: and (b.end_date_active is null -- Niraj, bug 4738501, Added
705: or trunc(b.end_date_active) > trunc(sysdate))) -- Niraj, Bug 5031721, Added
1257: refresh_proc
1258: into
1259: l_refresh_proc
1260: from
1261: ieu_uwq_sel_enumerators
1262: where
1263: sel_enum_id = p_sel_enum_id;
1264: EXCEPTION
1265: WHEN NO_DATA_FOUND THEN
2531: )
2532: into
2533: l_node_weight
2534: from
2535: ieu_uwq_sel_enumerators e
2536: where
2537: e.sel_enum_id = p_sel_enum_id;
2538:
2539: update
3029: WHERE
3030: (rt_nodes.resource_id = p_resource_id) AND
3031: (rt_nodes.sel_enum_id = p_sel_enum_id) AND
3032: (rt_nodes.not_valid = 'N')
3033: ) ieu_uwq_sel_enumerators
3034: -- connect by node_pid = node_id; -- Niraj: Bug 4352211, 06-May-2005: Commented this and added below 2 statements,
3035: start with node_depth = p_node_depth -- Niraj: Bug 4389449, 24-May-2005: Added p_node_depth instead of hardcoding to 1
3036: connect by prior node_id = node_pid;
3037: