APPS.FLM_KANBAN_CONFIG_PARAMS dependencies on FLM_EKB_PREFERENCE_DEFINITIONS

Line 15: from FLM_EKB_PREFERENCE_definitions fepd

11: begin
12: /* get the module id from preference */
13: select fepd.module_id
14: into l_module_id
15: from FLM_EKB_PREFERENCE_definitions fepd
16: where fepd.preference_id = p_pref_id;
17:
18: /* get the level code */
19: /* 0 - site, 1 - org*/

Line 404: from flm_ekb_preference_definitions

400: l_multi_val_cnt_cp NUMBER := 0;
401:
402: cursor pref_type(cl_pref_id NUMBER) is
403: select preference_type
404: from flm_ekb_preference_definitions
405: where preference_id = cl_pref_id;
406:
407: cursor single_value (cl_org_id NUMBER) is
408: select decode( (select count(v.attribute_value_code)

Line 502: from flm_ekb_preference_definitions wp

498: where ml.lookup_code = to_number(cl_value_code) and
499: ml.lookup_type = c1_lookup_type;
500:
501: /* (select wp.preference_value_lookup_type
502: from flm_ekb_preference_definitions wp
503: where wp.preference_id = p_preference_id);*/
504: begin
505:
506: l_value_code := get_preference_value_code (p_preference_id, p_org_id);

Line 519: from flm_ekb_preference_definitions wp

515: else
516: /*value*/
517: select wp.preference_value_lookup_type
518: into l_lookup_type
519: from flm_ekb_preference_definitions wp
520: where wp.preference_id = p_preference_id;
521:
522: /*code*/
523: open lookup_meaning (l_value_code, l_lookup_type);

Line 721: from FLM_EKB_PREFERENCE_definitions fepd

717:
718: /*get the module id from preference*/
719: select fepd.module_id
720: into l_module_id
721: from FLM_EKB_PREFERENCE_definitions fepd
722: where fepd.preference_id = p_preference_id;
723:
724: flm_ekanban_logger.log(flm_ekanban_logger.FULL_LOGGING, 'l_module_id: ' || l_module_id, l_retstatus);
725: /*get level for the org. if level_id not found, then insert into levels table*/

Line 906: select preference_name_lookup_type from flm_ekb_preference_definitions

902: from mfg_lookups ml
903: where lookup_code = p_label_code and
904: lookup_type in
905: (
906: select preference_name_lookup_type from flm_ekb_preference_definitions
907: where preference_id = p_preference_id
908: );
909: return l_label_meaning;
910: end;

Line 933: from flm_ekb_preference_definitions fepd

929:
930: function get_lookup_type(p_preference_id number) return varchar2 is
931: cursor lookup_type (p_preference_id number) is
932: select fepd.PREFERENCE_NAME_LOOKUP_TYPE
933: from flm_ekb_preference_definitions fepd
934: where fepd.preference_id = p_preference_id;
935: l_ret_val varchar2(30);
936: begin
937: open lookup_type (p_preference_id);