APPS.IEU_WORK_PANEL_PUB dependencies on IEU_WP_ACT_PARAM_SETS_B

Line 45: FROM ieu_wp_act_param_sets_b

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
46: WHERE wp_action_def_id IN (SELECT maction_def_id
47: FROM ieu_uwq_maction_defs_b
48: WHERE maction_def_key = LTRIM(RTRIM(r_action_key))
49: )

Line 56: from ieu_wp_act_param_sets_b a, ieu_uwq_maction_defs_b b

52: -- this cursor is to find outall action_param_set_id
53: --which wp_action_def_id is related to x_action_key
54: cursor c_cursor is
55: select distinct a.action_param_set_id
56: from ieu_wp_act_param_sets_b a, ieu_uwq_maction_defs_b b
57: where b.MACTION_DEF_KEY = LTRIM(RTRIM(r_action_key))
58: and b.maction_def_id = a.wp_action_def_id;
59:
60: cursor c_cursor1 is

Line 110: delete from ieu_wp_act_param_sets_b where action_param_set_id = cur_rec.action_param_set_id;

106: end LOOP;
107: --DBMS_SQL.CLOSE_CURSOR(v_cursor);
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;

Line 176: l_action_param_set_id IEU_WP_ACT_PARAM_SETS_B.ACTION_PARAM_SET_ID%type;

172: l_delete_param_property_id IEU_WP_PARAM_PROPS_B.param_property_id%type;
173: l_trans_flag IEU_WP_PROPERTIES_B.VALUE_TRANSLATABLE_FLAG%TYPE;
174: l_language VARCHAR2(4);
175:
176: l_action_param_set_id IEU_WP_ACT_PARAM_SETS_B.ACTION_PARAM_SET_ID%type;
177: l_maction_def_id IEU_UWQ_MACTION_DEFS_B.MACTION_DEF_ID%type;
178: l_num_map_entries NUMBER;
179: l_num_set_entries NUMBER;
180: TYPE c_cursor5 IS REF CURSOR;

Line 204: FROM ieu_wp_act_param_sets_b

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
205: WHERE action_param_set_id IN (SELECT action_param_set_id
206: FROM ieu_wp_act_param_sets_tl
207: WHERE action_param_set_label = LTRIM(RTRIM(r_Action_Label))
208: AND LANGUAGE = r_Lang

Line 263: -- delete from ieu_wp_act_param_sets_b where action_param_set_id = cur_rec.action_param_set_id;

259: -- end LOOP;
260: --DBMS_SQL.CLOSE_CURSOR(v_cursor);
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:

Line 303: DELETE FROM ieu_wp_act_param_sets_b

299:
300: DELETE FROM ieu_wp_act_param_sets_tl
301: WHERE action_param_set_id = cur_rec.action_param_set_id;
302:
303: DELETE FROM ieu_wp_act_param_sets_b
304: WHERE action_param_set_id = cur_rec.action_param_set_id;
305: END if;
306: end LOOP;
307: FOR cur_rec IN c_cursor2

Line 368: FROM ieu_wp_act_param_sets_b

364: c_ref c_cursor5;
365: --this cursor is used for parameter reording
366: CURSOR c_cursor3 is
367: SELECT action_param_set_id
368: FROM ieu_wp_act_param_sets_b
369: WHERE wp_action_def_id IN (SELECT maction_def_id
370: FROM ieu_uwq_maction_defs_b
371: WHERE maction_def_key = LTRIM(RTRIM(r_action_key))
372: );