APPS.IEU_WORK_PANEL_PUB dependencies on IEU_WP_ACTION_MAPS

Line 34: l_applId ieu_wp_action_maps.application_id%type;

30: l_property_id ieu_wp_param_props_b.property_id%type;
31: l_delete_param_property_id IEU_WP_PARAM_PROPS_B.param_property_id%type;
32: l_trans_flag IEU_WP_PROPERTIES_B.VALUE_TRANSLATABLE_FLAG%TYPE;
33: l_enumID ieu_uwq_sel_enumerators.sel_enum_id%type;
34: l_applId ieu_wp_action_maps.application_id%type;
35: l_panel ieu_uwq_maction_defs_b.maction_def_type_flag%type;
36: TYPE c_cursor5 IS REF CURSOR;
37: c_ref c_cursor5;
38: -- find enough information for reordering later after delete

Line 41: FROM ieu_uwq_sel_enumerators a, ieu_wp_action_maps b, ieu_uwq_maction_defs_b c

37: c_ref c_cursor5;
38: -- find enough information for reordering later after delete
39: CURSOR c_cursor2 is
40: SELECT DISTINCT a.sel_enum_id, b.application_id, c.maction_def_type_flag
41: FROM ieu_uwq_sel_enumerators a, ieu_wp_action_maps b, ieu_uwq_maction_defs_b c
42: WHERE a.enum_type_uuid = b.action_map_code
43: AND c.maction_def_key = LTRIM(RTRIM(r_action_key))
44: AND b.action_param_set_id IN (SELECT action_param_set_id
45: FROM ieu_wp_act_param_sets_b

Line 112: delete from ieu_wp_action_maps where action_param_set_id = cur_rec.action_param_set_id;

108: Close c_ref;
109:
110: delete from ieu_wp_act_param_sets_b where action_param_set_id = cur_rec.action_param_set_id;
111: delete from ieu_wp_act_param_sets_tl where action_param_set_id = cur_rec.action_param_set_id;
112: delete from ieu_wp_action_maps where action_param_set_id = cur_rec.action_param_set_id;
113: --DBMS_OUTPUT.Put_Line(' delete 3 tables for id '|| cur_rec.action_param_set_id);
114: end LOOP;
115:
116: FOR cur_rec IN c_cursor1

Line 190: FROM ieu_wp_action_maps

186: from ieu_wp_act_param_sets_tl
187: where LANGUAGE = r_Lang
188: AND ACTION_PARAM_SET_LABEL = LTRIM(RTRIM(r_Action_Label))
189: AND action_param_set_id IN (SELECT action_param_set_id
190: FROM ieu_wp_action_maps
191: WHERE action_map_code IN (SELECT enum_type_uuid
192: FROM ieu_uwq_sel_enumerators
193: WHERE sel_enum_id = LTRIM(RTRIM(r_node_id))
194: )

Line 200: FROM ieu_uwq_sel_enumerators a, ieu_wp_action_maps b, ieu_uwq_maction_defs_b c

196:
197: -- find enough information for reordering later after delete
198: CURSOR c_cursor2 is
199: SELECT DISTINCT b.application_id, c.maction_def_type_flag
200: FROM ieu_uwq_sel_enumerators a, ieu_wp_action_maps b, ieu_uwq_maction_defs_b c
201: WHERE a.enum_type_uuid = b.action_map_code
202: AND a.sel_enum_id = r_node_id
203: AND c.maction_def_id IN (SELECT wp_action_def_id
204: FROM ieu_wp_act_param_sets_b

Line 265: -- delete from ieu_wp_action_maps where action_param_set_id = cur_rec.action_param_set_id;

261: -- Close c_ref;
262:
263: -- delete from ieu_wp_act_param_sets_b where action_param_set_id = cur_rec.action_param_set_id;
264: -- delete from ieu_wp_act_param_sets_tl where action_param_set_id = cur_rec.action_param_set_id;
265: -- delete from ieu_wp_action_maps where action_param_set_id = cur_rec.action_param_set_id;
266: --DBMS_OUTPUT.Put_Line(' delete 3 tables for id '|| cur_rec.action_param_set_id);
267:
268: --1. determine if this action has 1:1 for action_maps to action_param_sets
269: --2. delete from maps

Line 276: FROM ieu_wp_action_maps

272:
273: --1.
274: SELECT count(unique(action_map_code))
275: INTO l_num_map_entries
276: FROM ieu_wp_action_maps
277: WHERE action_map_type_code = 'NODE' AND
278: action_param_set_id = cur_rec.action_param_set_id;
279:
280: --2.

Line 281: DELETE FROM ieu_wp_action_maps

277: WHERE action_map_type_code = 'NODE' AND
278: action_param_set_id = cur_rec.action_param_set_id;
279:
280: --2.
281: DELETE FROM ieu_wp_action_maps
282: WHERE action_param_set_id = cur_rec.action_param_set_id AND
283: action_map_type_code = 'NODE' AND
284: action_map_code IN
285: (SELECT enum_type_uuid FROM ieu_uwq_sel_enumerators