APPS.FLM_KANBAN_CONFIG_PARAMS dependencies on FLM_EKB_PREFERENCE_LEVELS

Line 31: from FLM_EKB_preference_levels v

27: into l_level_id
28: from
29: (
30: select level_id
31: from FLM_EKB_preference_levels v
32: where
33: v.module_id = l_module_id and
34: v.level_code <= l_level_code and
35: ( v.organization_id is null or v.organization_id = p_org_id) and

Line 410: flm_ekb_preference_levels l

406:
407: cursor single_value (cl_org_id NUMBER) is
408: select decode( (select count(v.attribute_value_code)
409: from flm_ekb_preference_values v,
410: flm_ekb_preference_levels l
411: where v.PREFERENCE_ID = p_preference_id
412: and v.LEVEL_ID = l.LEVEL_ID
413: and nvl(l.organization_id, -99) = nvl(cl_org_id, -99)
414: ),

Line 418: flm_ekb_preference_levels l

414: ),
415: 0, 'INHERIT',
416: 1, (select v.attribute_value_code
417: from flm_ekb_preference_values v,
418: flm_ekb_preference_levels l
419: where v.PREFERENCE_ID = p_preference_id
420: and v.LEVEL_ID = l.LEVEL_ID
421: and nvl(l.organization_id, -99) = nvl(cl_org_id, -99)),
422: 'INHERIT') AS single_value_code

Line 428: flm_ekb_preference_levels l

424:
425: cursor multi_value (cl_org_id NUMBER) is
426: select count(v.attribute_value_code) as multi_value_count
427: from flm_ekb_preference_values v,
428: flm_ekb_preference_levels l
429: where v.PREFERENCE_ID = p_preference_id
430: and v.LEVEL_ID = l.LEVEL_ID
431: and nvl(l.organization_id, -99) = nvl(cl_org_id, -99);
432:

Line 436: flm_ekb_preference_levels l

432:
433: cursor multi_value_custom_panel (cl_org_id NUMBER) is
434: select count(*) as multi_value_count
435: from flm_ekb_preference_values v,
436: flm_ekb_preference_levels l
437: where v.PREFERENCE_ID = p_preference_id
438: and v.LEVEL_ID = l.LEVEL_ID
439: and nvl(l.organization_id, -99) = nvl(cl_org_id, -99);
440:

Line 640: insert into flm_ekb_preference_levels

636: l_level_code := 0;/*Site*/
637: else l_level_code := 1;/*Org*/
638: end if;
639: l_level_id := flm_ekb_pref_level_seq.nextval; /*Need to generate by sequence*/
640: insert into flm_ekb_preference_levels
641: (
642: LEVEL_ID,
643: LEVEL_CODE,
644: ORGANIZATION_ID,

Line 673: from flm_ekb_preference_levels

669: function get_level_id(p_org_id number) return number is
670: l_level_id number;
671: begin
672: select level_id into l_level_id
673: from flm_ekb_preference_levels
674: where organization_id = p_org_id;
675: return l_level_id;
676: EXCEPTION
677: when NO_DATA_FOUND then