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_WP_ACTION_PVT dependencies on IEU_WP_ACT_PARAM_SETS_TL

Line 166: EXECUTE IMMEDIATE 'delete from IEU_WP_ACT_PARAM_SETS_TL where action_param_set_id = :1 '

162: ' delete from IEU_WP_ACT_PARAM_SETS_B '||
163: ' where action_param_set_id = :1 '
164: USING r_param_set_id;
165:
166: EXECUTE IMMEDIATE 'delete from IEU_WP_ACT_PARAM_SETS_TL where action_param_set_id = :1 '
167: USING r_param_set_id;
168:
169: EXECUTE IMMEDIATE ' delete from IEU_wp_action_mapS where action_param_set_id = :1 '
170: USING r_param_set_id;

Line 236: execute immediate ' update IEU_WP_ACT_PARAM_SETS_TL ' ||

232: FND_MSG_PUB.initialize;
233: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
234: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;
235: x_msg_data := '';
236: execute immediate ' update IEU_WP_ACT_PARAM_SETS_TL ' ||
237: ' set ' ||
238: ' LAST_UPDATED_BY = FND_GLOBAL.USER_ID, ' ||
239: ' LAST_UPDATE_DATE = SYSDATE, '||
240: ' LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID, '||

Line 753: from ieu_wp_act_param_sets_b a, ieu_wp_act_param_sets_tl b, ieu_uwq_maction_defs_b c

749: , value_override_flag,not_valid_flag
750: FROM ieu_wp_param_props_b
751: WHERE action_param_set_id in
752: (select a.action_param_set_id
753: from ieu_wp_act_param_sets_b a, ieu_wp_act_param_sets_tl b, ieu_uwq_maction_defs_b c
754: where a.action_param_set_id = b.action_param_set_id(+)
755: and b.action_param_set_id = v_param_set_id
756: and c.maction_def_key = LTRIM(RTRIM(v_wp_action_key))
757: and b.language = v_language

Line 775: from ieu_wp_act_param_sets_b a, ieu_wp_act_param_sets_tl b, ieu_uwq_maction_defs_b c

771: FROM ieu_wp_action_maps
772: WHERE responsibility_id = v_responsibility_id
773: AND action_param_set_id in
774: (select a.action_param_set_id
775: from ieu_wp_act_param_sets_b a, ieu_wp_act_param_sets_tl b, ieu_uwq_maction_defs_b c
776: where a.action_param_set_id = b.action_param_set_id(+)
777: and b.action_param_set_id = v_param_set_id
778: and c.maction_def_key = LTRIM(RTRIM(v_wp_action_key))
779: and b.language = v_language

Line 1303: ieu_wp_act_param_sets_b c, ieu_wp_act_param_sets_tl d,

1299: cursor c_cur is
1300: select d.action_param_set_label, b.action_map_sequence,
1301: d.action_param_set_desc , e.action_user_label, b.not_valid_flag,c.action_param_set_id
1302: from ieu_uwq_Sel_enumerators a, ieu_wp_action_maps b,
1303: ieu_wp_act_param_sets_b c, ieu_wp_act_param_sets_tl d,
1304: ieu_uwq_maction_defs_tl e , ieu_uwq_maction_defs_b f
1305: where a.sel_enum_id =v_enumId
1306: and f.maction_def_type_flag = v_panel
1307: and e.language = FND_GLOBAL.CURRENT_LANGUAGE

Line 1326: ieu_wp_act_param_sets_b c, ieu_wp_act_param_sets_tl d,

1322: cursor c_cur2 is
1323: select d.action_param_set_label, b.action_map_sequence,
1324: d.action_param_set_desc , e.action_user_label, b.not_valid_flag,c.action_param_set_id
1325: from ieu_uwq_Sel_enumerators a, ieu_wp_action_maps b,
1326: ieu_wp_act_param_sets_b c, ieu_wp_act_param_sets_tl d,
1327: ieu_uwq_maction_defs_tl e , ieu_uwq_maction_defs_b f, ieu_uwq_node_ds ds
1328: where a.sel_enum_id =v_enumId
1329: and f.maction_def_type_flag = v_panel
1330: and e.language = FND_GLOBAL.CURRENT_LANGUAGE

Line 1499: v_param_set_id ieu_wp_act_param_sets_tl.action_param_set_id%type;

1495: param_props_rec IEU_WP_PARAM_PROPS_SEED_PKG.wp_param_props_rec_type;
1496: v_SelectStmt Varchar2(500);
1497: v_CursorID INTEGER;
1498: v_Dummy INTEGER;
1499: v_param_set_id ieu_wp_act_param_sets_tl.action_param_set_id%type;
1500: v_language ieu_wp_act_param_sets_tl.language%type;
1501: v_enumId ieu_uwq_sel_enumerators.sel_enum_id%type;
1502: l_security_group_id NUMBER(15);
1503:

Line 1500: v_language ieu_wp_act_param_sets_tl.language%type;

1496: v_SelectStmt Varchar2(500);
1497: v_CursorID INTEGER;
1498: v_Dummy INTEGER;
1499: v_param_set_id ieu_wp_act_param_sets_tl.action_param_set_id%type;
1500: v_language ieu_wp_act_param_sets_tl.language%type;
1501: v_enumId ieu_uwq_sel_enumerators.sel_enum_id%type;
1502: l_security_group_id NUMBER(15);
1503:
1504: cursor c_cur is

Line 1511: from ieu_wp_act_param_sets_b a, ieu_wp_act_param_sets_tl b, ieu_uwq_maction_defs_b c

1507: , value_override_flag,not_valid_flag
1508: FROM ieu_wp_param_props_b
1509: WHERE action_param_set_id in
1510: (select a.action_param_set_id
1511: from ieu_wp_act_param_sets_b a, ieu_wp_act_param_sets_tl b, ieu_uwq_maction_defs_b c
1512: where a.action_param_set_id = b.action_param_set_id(+)
1513: and b.action_param_set_id = v_param_set_id
1514: and c.maction_def_key = LTRIM(RTRIM(v_wp_action_key))
1515: and b.language = v_language

Line 1537: from ieu_wp_act_param_sets_b a, ieu_wp_act_param_sets_tl b, ieu_uwq_maction_defs_b c

1533: FROM ieu_wp_action_maps
1534: WHERE responsibility_id = -1
1535: AND action_param_set_id in
1536: (select a.action_param_set_id
1537: from ieu_wp_act_param_sets_b a, ieu_wp_act_param_sets_tl b, ieu_uwq_maction_defs_b c
1538: where a.action_param_set_id = b.action_param_set_id(+)
1539: and b.action_param_set_id = v_param_set_id
1540: and c.maction_def_key = LTRIM(RTRIM(v_wp_action_key))
1541: and b.language = v_language