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_UWQ_MACTION_DEFS_B

Line 361: r_MACTION_DEF_TYPE_FLAG IN IEU_UWQ_MACTION_DEFS_B.MACTION_DEF_TYPE_FLAG %type,

357: PROCEDURE UPDATE_action_map_sequence (x_return_status OUT NOCOPY VARCHAR2,
358: x_msg_count OUT NOCOPY NUMBER,
359: x_msg_data OUT NOCOPY VARCHAR2,
360: r_action_param_set_id IN IEU_WP_ACTION_MAPS.action_param_set_id%type,
361: r_MACTION_DEF_TYPE_FLAG IN IEU_UWQ_MACTION_DEFS_B.MACTION_DEF_TYPE_FLAG %type,
362: r_application_id IN IEU_WP_ACTION_MAPS.application_id%type,
363: r_sel_enum_id IN IEU_UWQ_SEL_ENUMERATORS.sel_enum_id%type,
364: r_action_map_sequence IN IEU_WP_ACTION_MAPS.action_map_sequence%type,
365: r_not_valid_flag IN IEU_WP_ACTION_MAPS.not_valid_flag%type

Line 371: v_MACTION_DEF_TYPE_FLAG ieu_uwq_maction_defs_b.MACTION_DEF_TYPE_FLAG%type;

367:
368: l_cur_obj_versn NUMBER;
369: v_type_code varchar2(100);
370: v_ver_number ieu_wp_action_maps.object_version_number%type;
371: v_MACTION_DEF_TYPE_FLAG ieu_uwq_maction_defs_b.MACTION_DEF_TYPE_FLAG%type;
372: v_action_param_set_id ieu_wp_action_maps.action_param_set_id%type;
373: v_application_id ieu_wp_action_maps.application_id%type;
374: v_sel_enum_id ieu_uwq_sel_enumerators.sel_enum_id%type;
375: CURSOR c_cursor is

Line 377: from ieu_wp_action_maps m, ieu_uwq_maction_defs_b db,

373: v_application_id ieu_wp_action_maps.application_id%type;
374: v_sel_enum_id ieu_uwq_sel_enumerators.sel_enum_id%type;
375: CURSOR c_cursor is
376: select m.WP_ACTION_MAP_ID, m.object_version_number
377: from ieu_wp_action_maps m, ieu_uwq_maction_defs_b db,
378: ieu_wp_act_param_sets_b sb
379: where m.action_map_type_code = v_type_code
380: --and m.application_id = db.application_id
381: and db.maction_def_type_flag= v_MACTION_DEF_TYPE_FLAG

Line 392: from ieu_wp_action_maps m, ieu_uwq_maction_defs_b db,

388: where sel_enum_id = v_sel_enum_id);
389: c_rec c_cursor%ROWTYPE;
390: CURSOR c_cursor2 is
391: select m.WP_ACTION_MAP_ID, m.object_version_number
392: from ieu_wp_action_maps m, ieu_uwq_maction_defs_b db,
393: ieu_wp_act_param_sets_b sb, ieu_uwq_node_ds ds
394: where m.action_map_type_code = v_type_code
395: --and m.application_id = db.application_id
396: and db.maction_def_type_flag= 'F'

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 799: ' from ieu_wp_act_param_sets_b a, ieu_uwq_maction_defs_b c ' ||

795: x_msg_data := '';
796:
797:
798: execute immediate ' select a.wp_action_def_id ' ||
799: ' from ieu_wp_act_param_sets_b a, ieu_uwq_maction_defs_b c ' ||
800: ' where a.action_param_set_id = :1 ' ||
801: ' and c.maction_def_key = :2 ' ||
802: ' and c.maction_def_id = a.wp_action_def_id '
803: into l_wp_maction_def_id using r_param_set_id, r_wp_action_key;

Line 889: ' from ieu_wp_action_maps m, ieu_uwq_maction_defs_b db, '||

885: EXIT WHEN c_cur2%NOTFOUND;
886: ReOrdering(x_return_status,x_msg_count,x_msg_data,r_enumId ,c_rec2.application_id ,'W');
887: EXECUTE immediate
888: ' select max(m.action_map_sequence) '||
889: ' from ieu_wp_action_maps m, ieu_uwq_maction_defs_b db, '||
890: ' ieu_wp_act_param_sets_b sb '||
891: -- ' where m.application_id = :1 '||
892: ' where m.action_map_type_code = :1 '||
893: ' and m.action_map_code = :2 '||

Line 1297: v_panel ieu_uwq_maction_defs_b.maction_def_type_flag%type;

1293: As
1294:
1295: v_enumId ieu_uwq_Sel_enumerators.sel_enum_id%type;
1296: v_applId ieu_wp_action_maps.application_id%type;
1297: v_panel ieu_uwq_maction_defs_b.maction_def_type_flag%type;
1298:
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

Line 1304: ieu_uwq_maction_defs_tl e , ieu_uwq_maction_defs_b f

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
1308: and a.enum_type_uuid = b.action_map_code

Line 1327: ieu_uwq_maction_defs_tl e , ieu_uwq_maction_defs_b f, ieu_uwq_node_ds ds

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
1331: AND d.language=FND_GLOBAL.CURRENT_LANGUAGE

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

Line 1559: ' from ieu_wp_act_param_sets_b a, ieu_uwq_maction_defs_b c ' ||

1555: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;
1556: x_msg_data := '';
1557:
1558: execute immediate ' select a.wp_action_def_id ' ||
1559: ' from ieu_wp_act_param_sets_b a, ieu_uwq_maction_defs_b c ' ||
1560: ' where a.action_param_set_id = :1 ' ||
1561: ' and c.maction_def_key = :2 ' ||
1562: ' and c.maction_def_id = a.wp_action_def_id '
1563: into l_wp_maction_def_id using r_param_set_id, r_wp_action_key;