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.IEU_WORKPANEL_PVT dependencies on IEU_WP_ACTION_MAPS

Line 92: from ieu_uwq_maction_defs_b b, ieu_uwq_maction_defs_tl tl, ieu_wp_action_maps m,

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

Line 118: from ieu_uwq_maction_defs_b b, ieu_uwq_maction_defs_tl tl, ieu_wp_action_maps m,

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

Line 138: from ieu_uwq_maction_defs_b b, ieu_uwq_maction_defs_tl tl, ieu_wp_action_maps m,

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

Line 159: from ieu_uwq_maction_defs_b b, ieu_uwq_maction_defs_tl tl, ieu_wp_action_maps m,

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

Line 377: from ieu_uwq_maction_defs_b b, ieu_uwq_maction_defs_tl tl, ieu_wp_action_maps m,

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

Line 396: from ieu_uwq_maction_defs_b b, ieu_uwq_maction_defs_tl tl, ieu_wp_action_maps m,

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

Line 415: from ieu_uwq_maction_defs_b b, ieu_uwq_maction_defs_tl tl, ieu_wp_action_maps m,

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

Line 437: from ieu_uwq_maction_defs_b b, ieu_uwq_maction_defs_tl tl, ieu_wp_action_maps m,

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

Line 634: l_temp_map_sequence IEU_WP_ACTION_MAPS.action_map_sequence%type;

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;

Line 636: l_map_sequence IEU_WP_ACTION_MAPS.action_map_sequence%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;

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

Line 642: act_map_obj1 SYSTEM.IEU_wp_action_maps_OBJ;

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;

Line 650: l_panel_sec_cat_code IEU_WP_ACTION_MAPS.PANEL_SEC_CAT_CODE%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:

Line 652: l_action_map_type_code IEU_WP_ACTION_MAPS.ACTION_MAP_TYPE_CODE%type;

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:

Line 803: from ieu_wp_action_maps m, ieu_uwq_maction_defs_b db,

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

Line 822: --DBMS_OUTPUT.PUT_LINE('calling IEU_wp_action_maps_OBJ');

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,

Line 824: TYPE IEU_WP_ACTION_MAPS_OBJ AS OBJECT

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,

Line 863: act_map_obj := SYSTEM.IEU_wp_action_maps_OBJ(null, l_action_param_set_id,

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

Line 874: act_map_obj1 := SYSTEM.IEU_wp_action_maps_OBJ(null, l_action_param_set_id,

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

Line 1222: FROM ieu_wp_action_maps

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

Line 1230: FROM ieu_wp_action_maps

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:

Line 1239: DELETE FROM ieu_wp_action_maps

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

Line 1256: from ieu_wp_action_maps

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)

Line 1280: DELETE FROM ieu_wp_action_maps

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

Line 1351: from IEU_WP_ACTION_MAPS m

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:

Line 2713: act_map_obj SYSTEM.IEU_wp_action_maps_OBJ;

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;

Line 2715: act_map_obj1 SYSTEM.IEU_wp_action_maps_OBJ;

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;

Line 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;

Line 2721: l_map_sequence IEU_WP_ACTION_MAPS.action_map_sequence%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;

Line 2723: l_panel_sec_cat_code IEU_WP_ACTION_MAPS.PANEL_SEC_CAT_CODE%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;

Line 2726: --l_panel_sec_cat_code IEU_WP_ACTION_MAPS.PANEL_SEC_CAT_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:

Line 2727: l_action_map_type_code IEU_WP_ACTION_MAPS.ACTION_MAP_TYPE_CODE%type;

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:

Line 2749: from ieu_wp_action_maps m, ieu_uwq_maction_defs_b db,

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

Line 2798: act_map_obj := SYSTEM.IEU_wp_action_maps_OBJ(null, p_param_set_id,

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:

Line 2806: act_map_obj1 := SYSTEM.IEU_wp_action_maps_OBJ(null, p_param_set_id,

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: