APPS.IEU_WORK_ACTION_PVT dependencies on IEU_UWQ_SEL_ENUMERATORS

Line 22: l_enum_uuid IEU_UWQ_SEL_ENUMERATORS.ENUM_TYPE_UUID%type;

18: l_msg_count NUMBER(2);
19: l_msg_data VARCHAR2(2000);
20: act_map_obj SYSTEM.IEU_wp_action_maps_OBJ;
21: act_map_obj1 SYSTEM.IEU_wp_action_maps_OBJ;
22: l_enum_uuid IEU_UWQ_SEL_ENUMERATORS.ENUM_TYPE_UUID%type;
23: l_temp_map_sequence IEU_WP_ACTION_MAPS.action_map_sequence%type;
24: l_map_sequence IEU_WP_ACTION_MAPS.action_map_sequence%type;
25: l_panel_sec_cat_code IEU_WP_ACTION_MAPS.PANEL_SEC_CAT_CODE%type;
26: l_section_id IEU_WP_NODE_SECTION_MAPS.SECTION_ID%type;

Line 46: from ieu_uwq_sel_enumerators

42:
43:
44:
45: select enum_type_uuid into l_enum_uuid
46: from ieu_uwq_sel_enumerators
47: where sel_enum_id = p_enum_id;
48:
49: -- check if this node already have a action with same label
50: SELECT count(*) INTO l_duplicate

Line 119: update IEU_UWQ_SEL_ENUMERATORS set

115: 'N', 'Y');
116:
117: CREATE_action_map(x_return_status,x_msg_count, x_msg_data, act_map_obj1);
118:
119: update IEU_UWQ_SEL_ENUMERATORS set
120: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
121: LAST_UPDATE_DATE = SYSDATE,
122: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
123: WORK_PANEL_REGISTERED_FLAG = 'Y'

Line 434: l_enum_uuid IEU_UWQ_SEL_ENUMERATORS.ENUM_TYPE_UUID%type;

430: l_msg_count NUMBER(2);
431: l_msg_data VARCHAR2(2000);
432: l_maction_def_id IEU_UWQ_MACTION_DEFS_B.MACTION_DEF_ID%TYPE;
433: l_action_param_set_id IEU_WP_ACT_PARAM_SETS_B.ACTION_PARAM_SET_ID%TYPE;
434: l_enum_uuid IEU_UWQ_SEL_ENUMERATORS.ENUM_TYPE_UUID%type;
435: l_temp_map_sequence IEU_WP_ACTION_MAPS.action_map_sequence%type;
436: l_map_sequence IEU_WP_ACTION_MAPS.action_map_sequence%type;
437: l_wp_node_section_map_id IEU_WP_NODE_SECTION_MAPS.WP_NODE_SECTION_MAP_ID%type;
438: act_map_obj SYSTEM.IEU_wp_action_maps_OBJ;

Line 637: update IEU_UWQ_SEL_ENUMERATORS set

633: l_panel_sec_cat_code := null;
634: end if;
635: */
636: if (p_maction_def_type_flag <> 'F') then
637: update IEU_UWQ_SEL_ENUMERATORS set
638: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
639: LAST_UPDATE_DATE = SYSDATE,
640: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
641: WORK_PANEL_REGISTERED_FLAG = 'Y'

Line 950: (SELECT enum_type_uuid FROM ieu_uwq_sel_enumerators

946: DELETE FROM ieu_wp_action_maps
947: WHERE action_param_set_id = x_param_set_id AND
948: action_map_type_code = 'NODE' AND
949: action_map_code IN
950: (SELECT enum_type_uuid FROM ieu_uwq_sel_enumerators
951: WHERE sel_enum_id = x_node_id);
952: -- algupta modified on 8/31/04, if no action/information,
953: -- delete related records in IEU_WP_NODE_SECTION_MAPS.
954: if (l_def_type_flag = 'W' or l_def_type_flag = 'I') then

Line 966: (SELECT enum_type_uuid FROM ieu_uwq_sel_enumerators

962: select count(distinct action_param_set_id) into l_count_map
963: from ieu_wp_action_maps
964: where action_map_type_code = 'NODE'
965: AND action_map_code IN
966: (SELECT enum_type_uuid FROM ieu_uwq_sel_enumerators
967: WHERE sel_enum_id = x_node_id)
968: and action_param_set_id in
969: (SELECT action_param_set_id
970: FROM ieu_wp_act_param_sets_b

Line 979: (SELECT enum_type_uuid FROM ieu_uwq_sel_enumerators

975: ));
976: if (l_count_map = 0) then
977: delete from IEU_WP_NODE_SECTION_MAPS
978: where ENUM_TYPE_UUID IN
979: (SELECT enum_type_uuid FROM ieu_uwq_sel_enumerators
980: WHERE sel_enum_id = x_node_id)
981: and SECTION_ID = l_section_id;
982: end if;
983: end if;

Line 991: (SELECT ds.NODE_DS_ID FROM ieu_uwq_sel_enumerators e, ieu_uwq_node_ds ds

987: DELETE FROM ieu_wp_action_maps
988: WHERE action_param_set_id = x_param_set_id AND
989: action_map_type_code = 'NODE_DS' AND
990: action_map_code IN
991: (SELECT ds.NODE_DS_ID FROM ieu_uwq_sel_enumerators e, ieu_uwq_node_ds ds
992: WHERE e.sel_enum_id = x_node_id
993: and e.ENUM_TYPE_UUID = ds.ENUM_TYPE_UUID);
994:
995: end if;

Line 1062: ieu_uwq_sel_enumerators where SEL_ENUM_ID = x_node_id)

1058: if (l_def_type_flag <> 'F' and l_def_type_flag <> 'N' and l_def_type_flag <> 'M') then
1059: select count(m.WP_ACTION_MAP_ID) into l_count_map
1060: from IEU_WP_ACTION_MAPS m
1061: where m.ACTION_MAP_CODE = (select ENUM_TYPE_UUID from
1062: ieu_uwq_sel_enumerators where SEL_ENUM_ID = x_node_id)
1063: and m.ACTION_MAP_TYPE_CODE = 'NODE';
1064:
1065: if (l_count_map = 0) then
1066:

Line 1067: update IEU_UWQ_SEL_ENUMERATORS set

1063: and m.ACTION_MAP_TYPE_CODE = 'NODE';
1064:
1065: if (l_count_map = 0) then
1066:
1067: update IEU_UWQ_SEL_ENUMERATORS set
1068: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1069: LAST_UPDATE_DATE = SYSDATE,
1070: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
1071: WORK_PANEL_REGISTERED_FLAG = null