APPS.IEU_WORK_PANEL_PUB dependencies on IEU_WP_ACT_PARAM_SETS_TL

Line 111: delete from ieu_wp_act_param_sets_tl where action_param_set_id = cur_rec.action_param_set_id;

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;
115:

Line 155: -- r_Lang IN ieu_wp_act_param_sets_tl.language%type Required,

151: -- Parameters
152: --
153: -- IN
154: --
155: -- r_Lang IN ieu_wp_act_param_sets_tl.language%type Required,
156: -- r_Action_LABEL IN ieu_wp_act_param_sets_tl.ACTION_PARAM_SET_LABEL%type Required
157: -- End of Comments
158: -- ===============================================================
159:

Line 156: -- r_Action_LABEL IN ieu_wp_act_param_sets_tl.ACTION_PARAM_SET_LABEL%type Required

152: --
153: -- IN
154: --
155: -- r_Lang IN ieu_wp_act_param_sets_tl.language%type Required,
156: -- r_Action_LABEL IN ieu_wp_act_param_sets_tl.ACTION_PARAM_SET_LABEL%type Required
157: -- End of Comments
158: -- ===============================================================
159:
160: PROCEDURE DeleteCloneAction (x_return_status OUT NOCOPY VARCHAR2,

Line 163: r_Lang IN ieu_wp_act_param_sets_tl.language%type,

159:
160: PROCEDURE DeleteCloneAction (x_return_status OUT NOCOPY VARCHAR2,
161: x_msg_count OUT NOCOPY NUMBER,
162: x_msg_data OUT NOCOPY VARCHAR2,
163: r_Lang IN ieu_wp_act_param_sets_tl.language%type,
164: r_Action_Label IN ieu_wp_act_param_sets_tl.ACTION_PARAM_SET_LABEL%type,
165: r_node_id IN ieu_uwq_sel_enumerators.sel_enum_id%type)
166: As
167: v_cursor1 NUMBER;

Line 164: r_Action_Label IN ieu_wp_act_param_sets_tl.ACTION_PARAM_SET_LABEL%type,

160: PROCEDURE DeleteCloneAction (x_return_status OUT NOCOPY VARCHAR2,
161: x_msg_count OUT NOCOPY NUMBER,
162: x_msg_data OUT NOCOPY VARCHAR2,
163: r_Lang IN ieu_wp_act_param_sets_tl.language%type,
164: r_Action_Label IN ieu_wp_act_param_sets_tl.ACTION_PARAM_SET_LABEL%type,
165: r_node_id IN ieu_uwq_sel_enumerators.sel_enum_id%type)
166: As
167: v_cursor1 NUMBER;
168: v_cursor NUMBER;

Line 186: from ieu_wp_act_param_sets_tl

182: -- this cursor is to find outall action_param_set_id
183: --which wp_action_def_id is related to x_action_key
184: cursor c_cursor is
185: select action_param_set_id
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

Line 206: FROM ieu_wp_act_param_sets_tl

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
209: )
210: )

Line 212: FROM ieu_wp_act_param_sets_tl

208: AND LANGUAGE = r_Lang
209: )
210: )
211: AND b.action_param_set_id IN (SELECT action_param_set_id
212: FROM ieu_wp_act_param_sets_tl
213: WHERE action_param_set_label = LTRIM(RTRIM(r_Action_Label))
214: );
215:
216: begin

Line 264: -- delete from ieu_wp_act_param_sets_tl where action_param_set_id = cur_rec.action_param_set_id;

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:
268: --1. determine if this action has 1:1 for action_maps to action_param_sets

Line 300: DELETE FROM ieu_wp_act_param_sets_tl

296:
297: DELETE FROM ieu_wp_param_props_b
298: WHERE action_param_set_id = cur_rec.action_param_set_id;
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;