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_WORK_PANEL_PUB dependencies on IEU_UWQ_MACTION_DEFS_B

Line 24: r_action_key IN ieu_uwq_maction_defs_b.maction_def_key%type)

20:
21: PROCEDURE DeleteAction(x_return_status OUT NOCOPY VARCHAR2,
22: x_msg_count OUT NOCOPY NUMBER,
23: x_msg_data OUT NOCOPY VARCHAR2,
24: r_action_key IN ieu_uwq_maction_defs_b.maction_def_key%type)
25: As
26: v_cursor1 NUMBER;
27: v_cursor NUMBER;
28: v_numrows1 NUMBER;

Line 35: l_panel ieu_uwq_maction_defs_b.maction_def_type_flag%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
39: CURSOR c_cursor2 is

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 47: FROM ieu_uwq_maction_defs_b

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: )
50: );
51:

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 62: from ieu_uwq_maction_defs_b

58: and b.maction_def_id = a.wp_action_def_id;
59:
60: cursor c_cursor1 is
61: select maction_def_id
62: from ieu_uwq_maction_defs_b
63: where MACTION_DEF_KEY = r_action_key;
64:
65: begin
66: fnd_msg_pub.delete_msg();

Line 118: delete from ieu_uwq_maction_defs_b where maction_def_id = cur_rec.maction_def_id;

114: end LOOP;
115:
116: FOR cur_rec IN c_cursor1
117: LOOP
118: delete from ieu_uwq_maction_defs_b where maction_def_id = cur_rec.maction_def_id;
119: delete from ieu_uwq_maction_defs_tl where maction_def_id = cur_rec.maction_def_id;
120: -- --DBMS_OUTPUT.Put_Line(' delete 2 tables for id '|| cur_rec.maction_def_id);
121: end loop;
122:

Line 177: l_maction_def_id IEU_UWQ_MACTION_DEFS_B.MACTION_DEF_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;
181: c_ref c_cursor5;

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 343: -- r_ACTION_KEY IN ieu_uwq_maction_defs-b.maction_def_key%type --- Requried

339: --
340: -- IN
341: --
342: -- r_PARAM_NAME IN ieu_wp_param_defs_b.param_id%type Required
343: -- r_ACTION_KEY IN ieu_uwq_maction_defs-b.maction_def_key%type --- Requried
344: -- End of Comments
345: -- ===============================================================
346:
347: PROCEDURE DeleteActionParam(x_return_status OUT NOCOPY VARCHAR2,

Line 351: r_ACTION_KEY IN ieu_uwq_maction_defs_b.maction_def_key%type)

347: PROCEDURE DeleteActionParam(x_return_status OUT NOCOPY VARCHAR2,
348: x_msg_count OUT NOCOPY NUMBER,
349: x_msg_data OUT NOCOPY VARCHAR2,
350: r_PARAM_NAME IN ieu_wp_param_defs_b.param_name%type,
351: r_ACTION_KEY IN ieu_uwq_maction_defs_b.maction_def_key%type)
352: As
353: v_cursor1 NUMBER;
354: v_cursor NUMBER;
355: v_numrows1 NUMBER;

Line 370: FROM ieu_uwq_maction_defs_b

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: );
373:
374:

Line 384: FROM ieu_uwq_maction_defs_b

380: where param_name = LTRIM(RTRIM(r_param_name))
381: AND param_id IN (SELECT param_id
382: FROM ieu_wp_action_params
383: WHERE WP_ACTION_DEF_ID IN (SELECT maction_def_id
384: FROM ieu_uwq_maction_defs_b
385: WHERE MACTION_DEF_KEY = LTRIM(RTRIM(r_ACTION_KEY))
386: )
387: );
388:

Line 397: FROM ieu_uwq_maction_defs_b

393: and b.param_name = LTRIM(RTRIM(r_param_name))
394: AND a.param_id IN (SELECT param_id
395: FROM ieu_wp_action_params
396: WHERE WP_ACTION_DEF_ID IN (SELECT maction_def_id
397: FROM ieu_uwq_maction_defs_b
398: WHERE MACTION_DEF_KEY = LTRIM(RTRIM(r_ACTION_KEY))
399: )
400: );
401:

Line 410: FROM ieu_uwq_maction_defs_b

406: and b.param_name = LTRIM(RTRIM(r_param_name))
407: AND a.param_id IN (SELECT param_id
408: FROM ieu_wp_action_params
409: WHERE WP_ACTION_DEF_ID IN (SELECT maction_def_id
410: FROM ieu_uwq_maction_defs_b
411: WHERE MACTION_DEF_KEY = LTRIM(RTRIM(r_ACTION_KEY))
412: )
413: );
414: begin