88:
89: if (p_maction_def_type_flag <> 'F' and p_maction_def_type_flag <> 'N' and p_maction_def_type_flag <> 'M' ) then
90:
91: select count(b.maction_def_id) into l_act_usr_lbl_count
92: from ieu_uwq_maction_defs_b b, ieu_uwq_maction_defs_tl tl, ieu_wp_action_maps m,
93: ieu_wp_act_param_sets_b s, ieu_uwq_sel_enumerators e, ieu_wp_act_param_sets_tl stl
94: where e. sel_enum_id = rec_obj.enum_id
95: -- and e.application_id = m.application_id
96: and e.enum_type_uuid = m.action_map_code
114:
115:
116:
117: select count(b.maction_def_id) into l_set_id_count
118: from ieu_uwq_maction_defs_b b, ieu_uwq_maction_defs_tl tl, ieu_wp_action_maps m,
119: ieu_wp_act_param_sets_b s, ieu_uwq_sel_enumerators e, ieu_wp_act_param_sets_tl stl
120: where e. sel_enum_id = rec_obj.enum_id
121: --and e.application_id = m.application_id
122: and e.enum_type_uuid = m.action_map_code
134:
135: elsif (p_maction_def_type_flag = 'F') then
136:
137: select count(b.maction_def_id) into l_act_usr_lbl_count
138: from ieu_uwq_maction_defs_b b, ieu_uwq_maction_defs_tl tl, ieu_wp_action_maps m,
139: ieu_wp_act_param_sets_b s, ieu_uwq_sel_enumerators e,
140: ieu_wp_act_param_sets_tl stl, ieu_uwq_node_ds ds
141: where e. sel_enum_id = rec_obj.enum_id
142: --and e.application_id = m.application_id
155:
156:
157:
158: select count(b.maction_def_id) into l_set_id_count
159: from ieu_uwq_maction_defs_b b, ieu_uwq_maction_defs_tl tl, ieu_wp_action_maps m,
160: ieu_wp_act_param_sets_b s, ieu_uwq_sel_enumerators e,
161: ieu_wp_act_param_sets_tl stl, ieu_uwq_node_ds ds
162: where e. sel_enum_id = rec_obj.enum_id
163: --and e.application_id = m.application_id
373:
374: if(p_maction_def_type_flag <> 'F') then
375:
376: select count(b.maction_def_id) into l_act_usr_lbl_count
377: from ieu_uwq_maction_defs_b b, ieu_uwq_maction_defs_tl tl, ieu_wp_action_maps m,
378: ieu_wp_act_param_sets_b s, ieu_uwq_sel_enumerators e, ieu_wp_act_param_sets_tl stl
379: where e. sel_enum_id = p_enum_id
380: -- and e.application_id = m.application_id
381: and e.enum_type_uuid = m.action_map_code
392:
393: --DBMS_OUTPUT.PUT_LINE(' maction lable count : '||l_act_usr_lbl_count);
394:
395: select count(b.maction_def_id) into l_set_id_count
396: from ieu_uwq_maction_defs_b b, ieu_uwq_maction_defs_tl tl, ieu_wp_action_maps m,
397: ieu_wp_act_param_sets_b s, ieu_uwq_sel_enumerators e, ieu_wp_act_param_sets_tl stl
398: where e. sel_enum_id = p_enum_id
399: --and e.application_id = m.application_id
400: and e.enum_type_uuid = m.action_map_code
411:
412: elsif (p_maction_def_type_flag = 'F') then
413:
414: select count(b.maction_def_id) into l_act_usr_lbl_count
415: from ieu_uwq_maction_defs_b b, ieu_uwq_maction_defs_tl tl, ieu_wp_action_maps m,
416: ieu_wp_act_param_sets_b s, ieu_uwq_sel_enumerators e, ieu_wp_act_param_sets_tl stl,
417: IEU_UWQ_NODE_DS ds
418: where e. sel_enum_id = p_enum_id
419: --and e.application_id = m.application_id
433:
434:
435:
436: select count(b.maction_def_id) into l_set_id_count
437: from ieu_uwq_maction_defs_b b, ieu_uwq_maction_defs_tl tl, ieu_wp_action_maps m,
438: ieu_wp_act_param_sets_b s, ieu_uwq_sel_enumerators e, ieu_wp_act_param_sets_tl stl, IEU_UWQ_NODE_DS ds
439: where e. sel_enum_id = p_enum_id
440: --and e.application_id = m.application_id
441: and e.enum_type_uuid = ds.ENUM_TYPE_UUID
630:
631: l_enum_uuid IEU_UWQ_SEL_ENUMERATORS.ENUM_TYPE_UUID%type;
632:
633:
634: l_temp_map_sequence IEU_WP_ACTION_MAPS.action_map_sequence%type;
635:
636: l_map_sequence IEU_WP_ACTION_MAPS.action_map_sequence%type;
637:
638: l_wp_node_section_map_id IEU_WP_NODE_SECTION_MAPS.WP_NODE_SECTION_MAP_ID%type;
632:
633:
634: l_temp_map_sequence IEU_WP_ACTION_MAPS.action_map_sequence%type;
635:
636: l_map_sequence IEU_WP_ACTION_MAPS.action_map_sequence%type;
637:
638: l_wp_node_section_map_id IEU_WP_NODE_SECTION_MAPS.WP_NODE_SECTION_MAP_ID%type;
639:
640: act_map_obj SYSTEM.IEU_wp_action_maps_OBJ;
636: l_map_sequence IEU_WP_ACTION_MAPS.action_map_sequence%type;
637:
638: l_wp_node_section_map_id IEU_WP_NODE_SECTION_MAPS.WP_NODE_SECTION_MAP_ID%type;
639:
640: act_map_obj SYSTEM.IEU_wp_action_maps_OBJ;
641:
642: act_map_obj1 SYSTEM.IEU_wp_action_maps_OBJ;
643:
644: l_count NUMBER(5);
638: l_wp_node_section_map_id IEU_WP_NODE_SECTION_MAPS.WP_NODE_SECTION_MAP_ID%type;
639:
640: act_map_obj SYSTEM.IEU_wp_action_maps_OBJ;
641:
642: act_map_obj1 SYSTEM.IEU_wp_action_maps_OBJ;
643:
644: l_count NUMBER(5);
645:
646: l_section_id IEU_WP_NODE_SECTION_MAPS.SECTION_ID%type;
646: l_section_id IEU_WP_NODE_SECTION_MAPS.SECTION_ID%type;
647:
648: l_section_map_sequence IEU_WP_NODE_SECTION_MAPS.SECTION_MAP_SEQUENCE%type;
649:
650: l_panel_sec_cat_code IEU_WP_ACTION_MAPS.PANEL_SEC_CAT_CODE%type;
651:
652: l_action_map_type_code IEU_WP_ACTION_MAPS.ACTION_MAP_TYPE_CODE%type;
653:
654:
648: l_section_map_sequence IEU_WP_NODE_SECTION_MAPS.SECTION_MAP_SEQUENCE%type;
649:
650: l_panel_sec_cat_code IEU_WP_ACTION_MAPS.PANEL_SEC_CAT_CODE%type;
651:
652: l_action_map_type_code IEU_WP_ACTION_MAPS.ACTION_MAP_TYPE_CODE%type;
653:
654:
655:
656:
799:
800: if (p_maction_def_type_flag <> 'F') then
801:
802: select max(m.action_map_sequence) into l_temp_map_sequence
803: from ieu_wp_action_maps m, ieu_uwq_maction_defs_b db,
804: ieu_wp_act_param_sets_b sb
805: --where m.application_id = rec_obj.application_id
806: where m.action_map_type_code = 'NODE'
807: and m.action_map_code = l_enum_uuid
818: end if;
819:
820: end if;
821:
822: --DBMS_OUTPUT.PUT_LINE('calling IEU_wp_action_maps_OBJ');
823: /*
824: TYPE IEU_WP_ACTION_MAPS_OBJ AS OBJECT
825: (
826: wp_action_map_id NUMBER,
820: end if;
821:
822: --DBMS_OUTPUT.PUT_LINE('calling IEU_wp_action_maps_OBJ');
823: /*
824: TYPE IEU_WP_ACTION_MAPS_OBJ AS OBJECT
825: (
826: wp_action_map_id NUMBER,
827: ACTION_PARAM_SET_ID NUMBER,
828: APPLICATION_ID NUMBER,
859:
860:
861: if (p_maction_def_type_flag <> 'F') then
862:
863: act_map_obj := SYSTEM.IEU_wp_action_maps_OBJ(null, l_action_param_set_id,
864: rec_obj.application_id, null, l_action_map_type_code,
865: l_enum_uuid, l_map_sequence, l_panel_sec_cat_code, null, 'Y');
866:
867: IEU_WP_ACTION_PVT.CREATE_action_map(x_return_status,x_msg_count, x_msg_data, act_map_obj);
870: end if;
871:
872:
873:
874: act_map_obj1 := SYSTEM.IEU_wp_action_maps_OBJ(null, l_action_param_set_id,
875: rec_obj.application_id, -1, l_action_map_type_code,
876: l_enum_uuid, l_map_sequence, l_panel_sec_cat_code, null, 'Y');
877:
878: IEU_WP_ACTION_PVT.CREATE_action_map(x_return_status,x_msg_count, x_msg_data, act_map_obj1);
1218: if ( l_def_type_flag <> 'F') then
1219:
1220: SELECT count(unique(action_map_code))
1221: INTO l_num_map_entries
1222: FROM ieu_wp_action_maps
1223: WHERE action_map_type_code = 'NODE' AND
1224: action_param_set_id = x_param_set_id;
1225:
1226: elsif ( l_def_type_flag ='F') then
1226: elsif ( l_def_type_flag ='F') then
1227:
1228: SELECT count(unique(action_map_code))
1229: INTO l_num_map_entries
1230: FROM ieu_wp_action_maps
1231: WHERE action_map_type_code = 'NODE_DS' AND
1232: action_param_set_id = x_param_set_id;
1233:
1234:
1235: end if;
1236:
1237: --2.
1238: if ( l_def_type_flag <> 'F') then
1239: DELETE FROM ieu_wp_action_maps
1240: WHERE action_param_set_id = x_param_set_id AND
1241: action_map_type_code = 'NODE' AND
1242: action_map_code IN
1243: (SELECT enum_type_uuid FROM ieu_uwq_sel_enumerators
1252: end if;
1253:
1254: l_count_map := 0;
1255: select count(distinct action_param_set_id) into l_count_map
1256: from ieu_wp_action_maps
1257: where action_map_type_code = 'NODE'
1258: AND action_map_code IN
1259: (SELECT enum_type_uuid FROM ieu_uwq_sel_enumerators
1260: WHERE sel_enum_id = x_node_id)
1276: end if;
1277: end if;
1278: elsif ( l_def_type_flag ='F') then
1279:
1280: DELETE FROM ieu_wp_action_maps
1281: WHERE action_param_set_id = x_param_set_id AND
1282: action_map_type_code = 'NODE_DS' AND
1283: action_map_code IN
1284: (SELECT to_char(ds.NODE_DS_ID) FROM ieu_uwq_sel_enumerators e, ieu_uwq_node_ds ds
1347: COMMIT;
1348:
1349: if (l_def_type_flag <> 'F') then
1350: select count(m.WP_ACTION_MAP_ID) into l_count_map
1351: from IEU_WP_ACTION_MAPS m
1352: where m.ACTION_MAP_CODE = (select ENUM_TYPE_UUID from
1353: ieu_uwq_sel_enumerators where SEL_ENUM_ID = x_node_id)
1354: and m.ACTION_MAP_TYPE_CODE = 'NODE';
1355:
2709: l_msg_count NUMBER(2);
2710:
2711: l_msg_data VARCHAR2(2000);
2712:
2713: act_map_obj SYSTEM.IEU_wp_action_maps_OBJ;
2714:
2715: act_map_obj1 SYSTEM.IEU_wp_action_maps_OBJ;
2716:
2717: l_enum_uuid IEU_UWQ_SEL_ENUMERATORS.ENUM_TYPE_UUID%type;
2711: l_msg_data VARCHAR2(2000);
2712:
2713: act_map_obj SYSTEM.IEU_wp_action_maps_OBJ;
2714:
2715: act_map_obj1 SYSTEM.IEU_wp_action_maps_OBJ;
2716:
2717: l_enum_uuid IEU_UWQ_SEL_ENUMERATORS.ENUM_TYPE_UUID%type;
2718:
2719: l_temp_map_sequence IEU_WP_ACTION_MAPS.action_map_sequence%type;
2715: act_map_obj1 SYSTEM.IEU_wp_action_maps_OBJ;
2716:
2717: l_enum_uuid IEU_UWQ_SEL_ENUMERATORS.ENUM_TYPE_UUID%type;
2718:
2719: l_temp_map_sequence IEU_WP_ACTION_MAPS.action_map_sequence%type;
2720:
2721: l_map_sequence IEU_WP_ACTION_MAPS.action_map_sequence%type;
2722:
2723: l_panel_sec_cat_code IEU_WP_ACTION_MAPS.PANEL_SEC_CAT_CODE%type;
2717: l_enum_uuid IEU_UWQ_SEL_ENUMERATORS.ENUM_TYPE_UUID%type;
2718:
2719: l_temp_map_sequence IEU_WP_ACTION_MAPS.action_map_sequence%type;
2720:
2721: l_map_sequence IEU_WP_ACTION_MAPS.action_map_sequence%type;
2722:
2723: l_panel_sec_cat_code IEU_WP_ACTION_MAPS.PANEL_SEC_CAT_CODE%type;
2724: l_section_id IEU_WP_NODE_SECTION_MAPS.SECTION_ID%type;
2725: l_section_map_sequence IEU_WP_NODE_SECTION_MAPS.SECTION_MAP_SEQUENCE%type;
2719: l_temp_map_sequence IEU_WP_ACTION_MAPS.action_map_sequence%type;
2720:
2721: l_map_sequence IEU_WP_ACTION_MAPS.action_map_sequence%type;
2722:
2723: l_panel_sec_cat_code IEU_WP_ACTION_MAPS.PANEL_SEC_CAT_CODE%type;
2724: l_section_id IEU_WP_NODE_SECTION_MAPS.SECTION_ID%type;
2725: l_section_map_sequence IEU_WP_NODE_SECTION_MAPS.SECTION_MAP_SEQUENCE%type;
2726: --l_panel_sec_cat_code IEU_WP_ACTION_MAPS.PANEL_SEC_CAT_CODE%type;
2727: l_action_map_type_code IEU_WP_ACTION_MAPS.ACTION_MAP_TYPE_CODE%type;
2722:
2723: l_panel_sec_cat_code IEU_WP_ACTION_MAPS.PANEL_SEC_CAT_CODE%type;
2724: l_section_id IEU_WP_NODE_SECTION_MAPS.SECTION_ID%type;
2725: l_section_map_sequence IEU_WP_NODE_SECTION_MAPS.SECTION_MAP_SEQUENCE%type;
2726: --l_panel_sec_cat_code IEU_WP_ACTION_MAPS.PANEL_SEC_CAT_CODE%type;
2727: l_action_map_type_code IEU_WP_ACTION_MAPS.ACTION_MAP_TYPE_CODE%type;
2728: l_count NUMBER(2);
2729: l_wp_node_section_map_id IEU_WP_NODE_SECTION_MAPS.WP_NODE_SECTION_MAP_ID%type;
2730:
2723: l_panel_sec_cat_code IEU_WP_ACTION_MAPS.PANEL_SEC_CAT_CODE%type;
2724: l_section_id IEU_WP_NODE_SECTION_MAPS.SECTION_ID%type;
2725: l_section_map_sequence IEU_WP_NODE_SECTION_MAPS.SECTION_MAP_SEQUENCE%type;
2726: --l_panel_sec_cat_code IEU_WP_ACTION_MAPS.PANEL_SEC_CAT_CODE%type;
2727: l_action_map_type_code IEU_WP_ACTION_MAPS.ACTION_MAP_TYPE_CODE%type;
2728: l_count NUMBER(2);
2729: l_wp_node_section_map_id IEU_WP_NODE_SECTION_MAPS.WP_NODE_SECTION_MAP_ID%type;
2730:
2731:
2745: from ieu_uwq_sel_enumerators
2746: where sel_enum_id = p_enum_id;
2747:
2748: select max(m.action_map_sequence) into l_temp_map_sequence
2749: from ieu_wp_action_maps m, ieu_uwq_maction_defs_b db,
2750: ieu_wp_act_param_sets_b sb
2751: --where m.application_id = p_application
2752: where m.action_map_type_code = 'NODE'
2753: and m.action_map_code = l_enum_uuid
2794: -- l_enum_uuid := p_datasource;
2795: end if;
2796:
2797:
2798: act_map_obj := SYSTEM.IEU_wp_action_maps_OBJ(null, p_param_set_id,
2799: p_application, null, 'NODE',
2800: l_enum_uuid, l_map_sequence, l_panel_sec_cat_code,
2801: 'N', 'Y');
2802:
2802:
2803: IEU_WP_ACTION_PVT.CREATE_action_map(x_return_status,x_msg_count, x_msg_data, act_map_obj);
2804:
2805:
2806: act_map_obj1 := SYSTEM.IEU_wp_action_maps_OBJ(null, p_param_set_id,
2807: p_application, -1, 'NODE',
2808: l_enum_uuid, l_map_sequence, l_panel_sec_cat_code,
2809: 'N', 'Y');
2810: