eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FLM_KANBAN_CONFIG_PARAMS dependencies on FLM_EKB_PREFERENCE_VALUES

Line 39: from flm_ekb_preference_values v1

35: ( v.organization_id is null or v.organization_id = p_org_id) and
36: exists
37: (
38: select 1
39: from flm_ekb_preference_values v1
40: where v1.preference_id = p_pref_id and
41: v1.level_id = v.level_id
42: )
43: order by v.level_code desc

Line 63: from FLM_EKB_PREFERENCE_VALUES

59: into l_attr_val_code
60: from
61: (
62: select attribute_value_code
63: from FLM_EKB_PREFERENCE_VALUES
64: where (level_id = p_level_id or level_id = 1)
65: and preference_id = p_pref_id
66: order by level_id desc
67: )

Line 75: from FLM_EKB_PREFERENCE_VALUES

71: into l_attr_val_code
72: from
73: (
74: select attribute_value_code
75: from FLM_EKB_PREFERENCE_VALUES
76: where (level_id = p_level_id or level_id = 1)
77: and preference_id = p_pref_id
78: and attribute_name = p_attr_name
79: order by level_id desc

Line 325: from FLM_EKB_PREFERENCE_VALUES

321: l_level_id_site number;
322:
323: cursor c_unmovedcard_leadtime(p_level_id number) IS
324: select attribute_name, attribute_value_code
325: from FLM_EKB_PREFERENCE_VALUES
326: where level_id = p_level_id
327: and preference_id = FLM_KANBAN_CONSTANTS.UNMOVED_CARD_LEADTIME_PER
328: and attribute_value_code is NOT NULL;
329:

Line 367: from FLM_EKB_PREFERENCE_VALUES

363: l_level_id_site number;
364:
365: cursor c_unmovedcard_enb_status(p_level_id number) IS
366: select attribute_name
367: from FLM_EKB_PREFERENCE_VALUES
368: where level_id = p_level_id
369: and preference_id = FLM_KANBAN_CONSTANTS.UNMOVED_CARD_LEADTIME_PER
370: and nvl(attribute_enable_flag,1) = 1;
371:

Line 409: from flm_ekb_preference_values v,

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)
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)

Line 417: from flm_ekb_preference_values v,

413: and nvl(l.organization_id, -99) = nvl(cl_org_id, -99)
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)),

Line 427: from flm_ekb_preference_values v,

423: from dual;
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);

Line 435: from flm_ekb_preference_values v,

431: and nvl(l.organization_id, -99) = nvl(cl_org_id, -99);
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);

Line 586: /Start: functions to add rows to flm_ekb_preference_values/

582: end if;
583: end;
584: /*End: adding new functions*/
585:
586: /*Start: functions to add rows to flm_ekb_preference_values*/
587: /*function insertRowPrefValues()*/
588:
589: procedure insertRow(p_preference_id number,
590: p_level_id number,

Line 597: insert into flm_ekb_preference_values

593: p_attribute_value_code varchar2,
594: p_enable_flag number,
595: p_user_id number) is
596: begin
597: insert into flm_ekb_preference_values
598: (
599: PREFERENCE_VALUE_ID,
600: PREFERENCE_ID,
601: LEVEL_ID,

Line 743: from FLM_EKB_PREFERENCE_VALUES

739: end if;
740:
741: /*Check if for the level, preference already has rows in the table*/
742: select count(*) into l_count
743: from FLM_EKB_PREFERENCE_VALUES
744: where level_id = l_level_id
745: and preference_id = p_preference_id;
746: flm_ekanban_logger.log(flm_ekanban_logger.FULL_LOGGING, 'l_count: ' || l_count, l_retstatus);
747: flm_ekanban_logger.log(flm_ekanban_logger.FULL_LOGGING, 'preference_id : ' || p_preference_id, l_retstatus);

Line 754: from flm_ekb_preference_values

750: /*there can be 3 cases, 1. increase, 2. decrease,
751: . increase and decrease: count same. Below code take care of all*/
752: select max(sequence_number)
753: into l_seq_max
754: from flm_ekb_preference_values
755: where preference_id = 13;
756: flm_ekanban_logger.log(flm_ekanban_logger.FULL_LOGGING, 'l_seq_max : ' || l_seq_max, l_retstatus);
757: l_seq := l_seq_max;
758: for c_status in c_unmovedcard_status loop

Line 765: from flm_ekb_preference_values

761: flm_ekanban_logger.log(flm_ekanban_logger.FULL_LOGGING, 'l_seq : ' || l_seq || 'l_code: ' || l_code, l_retstatus);
762: begin
763: select attribute_value_code
764: into l_value
765: from flm_ekb_preference_values
766: where preference_id = p_preference_id
767: and attribute_name = l_code
768: and sequence_number <= l_seq_max
769: and level_id = l_level_id;

Line 773: from flm_ekb_preference_values

769: and level_id = l_level_id;
770:
771: select attribute_enable_flag
772: into l_enable_flag
773: from flm_ekb_preference_values
774: where preference_id = p_preference_id
775: and attribute_name = l_code
776: and sequence_number <= l_seq_max
777: and level_id = l_level_id;

Line 789: delete from flm_ekb_preference_values

785: insertRow(p_preference_id, l_level_id, l_seq, l_code, l_value, l_enable_flag, p_user_id);
786: end loop;
787: /*now delete the previously existing rows*/
788: flm_ekanban_logger.log(flm_ekanban_logger.FULL_LOGGING, 'deleting previously existing rows', l_retstatus);
789: delete from flm_ekb_preference_values
790: where preference_id = 13
791: and sequence_number <= l_seq_max
792: and level_id = l_level_id
793: and attribute_name in (

Line 794: select attribute_name from flm_ekb_preference_values

790: where preference_id = 13
791: and sequence_number <= l_seq_max
792: and level_id = l_level_id
793: and attribute_name in (
794: select attribute_name from flm_ekb_preference_values
795: where preference_id = 13
796: and sequence_number > l_seq_max
797: and level_id = l_level_id);
798: /*TODO: if needed we can update sequence_number for remaining rows

Line 814: from flm_ekb_preference_values

810: flm_ekanban_logger.log(flm_ekanban_logger.FULL_LOGGING, 'l_seq : ' || l_seq || 'l_code: ' || l_code, l_retstatus);
811: begin
812: select attribute_value_code
813: into l_value
814: from flm_ekb_preference_values
815: where preference_id = p_preference_id
816: and attribute_name = l_code
817: and level_id = 1;
818: flm_ekanban_logger.log(flm_ekanban_logger.FULL_LOGGING, 'l_value : ' || l_value, l_retstatus);

Line 827: flm_ekanban_logger.log(flm_ekanban_logger.FULL_LOGGING, 'inserting into flm_ekb_preference_values at Org from Site', l_retstatus);

823: l_enable_flag := 1;
824: insertRow(13, l_level_id, l_seq, l_code, l_value, l_enable_flag, p_user_id);
825: end loop;
826: else
827: flm_ekanban_logger.log(flm_ekanban_logger.FULL_LOGGING, 'inserting into flm_ekb_preference_values at Org from Site', l_retstatus);
828: insert into flm_ekb_preference_values
829: (
830: PREFERENCE_VALUE_ID,
831: PREFERENCE_ID,

Line 828: insert into flm_ekb_preference_values

824: insertRow(13, l_level_id, l_seq, l_code, l_value, l_enable_flag, p_user_id);
825: end loop;
826: else
827: flm_ekanban_logger.log(flm_ekanban_logger.FULL_LOGGING, 'inserting into flm_ekb_preference_values at Org from Site', l_retstatus);
828: insert into flm_ekb_preference_values
829: (
830: PREFERENCE_VALUE_ID,
831: PREFERENCE_ID,
832: LEVEL_ID,

Line 856: from flm_ekb_preference_values fepv

852: p_user_id, --LAST_UPDATED_BY,
853: sysdate, --LAST_UPDATE_DATE,
854: p_user_id, --LAST_UPDATE_LOGIN,
855: 1 --OBJECT_VERSION_NUMBER
856: from flm_ekb_preference_values fepv
857: where preference_id = p_preference_id
858: and level_id = 1;
859: end if;
860: end if;--l_count>0

Line 873: delete from flm_ekb_preference_values

869: l_level_id number;
870: begin
871: l_level_id := get_level_id(p_org_id);
872:
873: delete from flm_ekb_preference_values
874: where preference_id = 13
875: and level_id = l_level_id
876: and attribute_name not in (
877: select ml.lookup_code

Line 891: delete from flm_ekb_preference_values

887: l_level_id number;
888: begin
889: l_level_id := get_level_id(p_org_id);
890:
891: delete from flm_ekb_preference_values
892: where preference_id = p_preference_id
893: and level_id = l_level_id;
894:
895: return;

Line 971: from flm_ekb_preference_values v

967: where ml.lookup_type = 'MTL_KANBAN_SUPPLY_STATUS'
968: and ml.lookup_code not in
969: (
970: select attribute_name
971: from flm_ekb_preference_values v
972: where preference_id = 13
973: and level_id = p_level_id
974: )
975: and ml.enabled_flag = 'Y'

Line 1005: from flm_ekb_preference_values v

1001:
1002: function get_new_disabled_status(p_org_id number) return varchar2 is
1003: cursor new_disabled_status (p_level_id number) is
1004: select v.attribute_name
1005: from flm_ekb_preference_values v
1006: where v.attribute_name in
1007: (
1008: --list of disabled codes
1009: select to_char(ml.lookup_code)

Line 1043: /End: functions to add rows to flm_ekb_preference_values/

1039: end if;
1040: return l_ret_val;
1041: end;
1042:
1043: /*End: functions to add rows to flm_ekb_preference_values*/
1044:
1045: end flm_kanban_config_params;