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

Line 65: ieu_uwq_maction_defs_b db,

61: RAISE name_fail_exception;
62: else
63: select max(m.action_map_sequence) into l_temp_map_sequence
64: from ieu_wp_action_maps m,
65: ieu_uwq_maction_defs_b db,
66: ieu_wp_act_param_sets_b sb
67: -- where m.application_id = p_mapping_application
68: where m.action_map_type_code = 'NODE'
69: and m.action_map_code = l_enum_uuid

Line 251: from ieu_uwq_maction_defs_b b, ieu_uwq_maction_defs_tl tl,

247: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
248: l_set_id_count :=0;
249: temp_act_user_label := LTRIM(RTRIM(p_label));
250: select count(b.maction_def_id) into l_act_usr_lbl_count
251: from ieu_uwq_maction_defs_b b, ieu_uwq_maction_defs_tl tl,
252: ieu_wp_act_param_sets_b s
253: where
254: b.maction_def_id = tl.maction_def_id
255: and b.maction_def_type_flag = (select maction_def_type_flag

Line 256: from ieu_uwq_maction_defs_b

252: ieu_wp_act_param_sets_b s
253: where
254: b.maction_def_id = tl.maction_def_id
255: and b.maction_def_type_flag = (select maction_def_type_flag
256: from ieu_uwq_maction_defs_b
257: where maction_def_id = (select wp_action_def_id
258: from ieu_wp_act_param_sets_b
259: where action_param_set_id = p_param_set_id))
260: and s.wp_action_def_id = b.maction_def_id

Line 265: from ieu_uwq_maction_defs_b b,

261: and tl.language = l_language
262: and lower(tl.action_user_label) = lower(temp_act_user_label);
263:
264: select count(b.maction_def_id) into l_set_id_count
265: from ieu_uwq_maction_defs_b b,
266: ieu_wp_act_param_sets_b s,
267: ieu_wp_act_param_sets_tl stl
268: where
269: b.maction_def_type_flag = (select maction_def_type_flag

Line 270: from ieu_uwq_maction_defs_b

266: ieu_wp_act_param_sets_b s,
267: ieu_wp_act_param_sets_tl stl
268: where
269: b.maction_def_type_flag = (select maction_def_type_flag
270: from ieu_uwq_maction_defs_b
271: where maction_def_id = (select wp_action_def_id
272: from ieu_wp_act_param_sets_b
273: where action_param_set_id = p_param_set_id))
274: and s.wp_action_def_id = b.maction_def_id

Line 432: l_maction_def_id IEU_UWQ_MACTION_DEFS_B.MACTION_DEF_ID%TYPE;

428: l_source_lang VARCHAR2(4);
429: l_return_status VARCHAR2(4);
430: l_msg_count NUMBER(2);
431: l_msg_data VARCHAR2(2000);
432: l_maction_def_id IEU_UWQ_MACTION_DEFS_B.MACTION_DEF_ID%TYPE;
433: l_action_param_set_id IEU_WP_ACT_PARAM_SETS_B.ACTION_PARAM_SET_ID%TYPE;
434: l_enum_uuid IEU_UWQ_SEL_ENUMERATORS.ENUM_TYPE_UUID%type;
435: l_temp_map_sequence IEU_WP_ACTION_MAPS.action_map_sequence%type;
436: l_map_sequence IEU_WP_ACTION_MAPS.action_map_sequence%type;

Line 462: select IEU_UWQ_MACTION_DEFS_B_S1.NEXTVAL into l_maction_def_id from sys.dual;

458: l_msg_data,
459: rec_obj, 'Y', p_maction_def_type_flag, null);
460:
461: if (l_return_status = 'S') then
462: select IEU_UWQ_MACTION_DEFS_B_S1.NEXTVAL into l_maction_def_id from sys.dual;
463: if ( p_maction_def_type_flag = 'M' ) then
464: insert INTO IEU_UWQ_MACTION_DEFS_B
465: (MACTION_DEF_ID,
466: CREATED_BY,

Line 464: insert INTO IEU_UWQ_MACTION_DEFS_B

460:
461: if (l_return_status = 'S') then
462: select IEU_UWQ_MACTION_DEFS_B_S1.NEXTVAL into l_maction_def_id from sys.dual;
463: if ( p_maction_def_type_flag = 'M' ) then
464: insert INTO IEU_UWQ_MACTION_DEFS_B
465: (MACTION_DEF_ID,
466: CREATED_BY,
467: CREATION_DATE,
468: LAST_UPDATED_BY,

Line 493: insert INTO IEU_UWQ_MACTION_DEFS_B

489: 0,
490: rec_obj.multi_select_flag
491: );
492: else
493: insert INTO IEU_UWQ_MACTION_DEFS_B
494: (MACTION_DEF_ID,
495: CREATED_BY,
496: CREATION_DATE,
497: LAST_UPDATED_BY,

Line 599: from ieu_wp_action_maps m, ieu_uwq_maction_defs_b db,

595: end if;
596: if (p_maction_def_type_flag <> 'F') then
597:
598: select max(m.action_map_sequence) into l_temp_map_sequence
599: from ieu_wp_action_maps m, ieu_uwq_maction_defs_b db,
600: ieu_wp_act_param_sets_b sb
601: --where m.application_id = rec_obj.application_id
602: where m.action_map_type_code = 'NODE'
603: --and m.application_id = db.application_id

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

727: PARAM_ID, PROPERTY_ID,property_value, value_override_flag,not_valid_flag
728: FROM ieu_wp_param_props_b
729: WHERE action_param_set_id in
730: (select a.action_param_set_id
731: from ieu_wp_act_param_sets_b a, ieu_wp_act_param_sets_tl b, ieu_uwq_maction_defs_b c
732: where a.action_param_set_id = b.action_param_set_id(+)
733: and b.action_param_set_id = r_param_set_id
734: and c.maction_def_id = r_maction_def_id
735: and b.language = r_language

Line 892: l_maction_def_id IEU_UWQ_MACTION_DEFS_B.MACTION_DEF_ID%type;

888: ) is
889:
890: l_language VARCHAR2(4);
891: l_action_param_set_id IEU_WP_ACT_PARAM_SETS_B.ACTION_PARAM_SET_ID%type;
892: l_maction_def_id IEU_UWQ_MACTION_DEFS_B.MACTION_DEF_ID%type;
893: l_num_map_entries NUMBER;
894: l_num_set_entries NUMBER;
895: l_count_map NUMBER;
896: l_def_type_flag IEU_UWQ_MACTION_DEFS_B.MACTION_DEF_TYPE_FLAG%type;

Line 896: l_def_type_flag IEU_UWQ_MACTION_DEFS_B.MACTION_DEF_TYPE_FLAG%type;

892: l_maction_def_id IEU_UWQ_MACTION_DEFS_B.MACTION_DEF_ID%type;
893: l_num_map_entries NUMBER;
894: l_num_set_entries NUMBER;
895: l_count_map NUMBER;
896: l_def_type_flag IEU_UWQ_MACTION_DEFS_B.MACTION_DEF_TYPE_FLAG%type;
897: l_mact_def_id IEU_UWQ_MACTION_DEFS_B.MACTION_DEF_ID%type;
898: l_section_id number;
899:
900: BEGIN

Line 897: l_mact_def_id IEU_UWQ_MACTION_DEFS_B.MACTION_DEF_ID%type;

893: l_num_map_entries NUMBER;
894: l_num_set_entries NUMBER;
895: l_count_map NUMBER;
896: l_def_type_flag IEU_UWQ_MACTION_DEFS_B.MACTION_DEF_TYPE_FLAG%type;
897: l_mact_def_id IEU_UWQ_MACTION_DEFS_B.MACTION_DEF_ID%type;
898: l_section_id number;
899:
900: BEGIN
901: x_return_status := fnd_api.g_ret_sts_success;

Line 919: FROM ieu_uwq_maction_defs_b db,

915: if (x_maction_id <> -1) then
916: l_def_type_flag := x_maction_def_flag;
917: else
918: SELECT db.maction_def_type_flag into l_def_type_flag
919: FROM ieu_uwq_maction_defs_b db,
920: ieu_wp_act_param_sets_b sb
921: WHERE db.maction_def_id = sb.wp_action_def_id
922: AND sb.action_param_set_id = x_param_set_id;
923: end if;

Line 973: from ieu_uwq_maction_defs_b

969: (SELECT action_param_set_id
970: FROM ieu_wp_act_param_sets_b
971: WHERE wp_action_def_id in
972: (select maction_def_id
973: from ieu_uwq_maction_defs_b
974: where maction_def_type_flag = l_def_type_flag
975: ));
976: if (l_count_map = 0) then
977: delete from IEU_WP_NODE_SECTION_MAPS

Line 1043: DELETE FROM ieu_uwq_maction_defs_b

1039:
1040: DELETE FROM ieu_uwq_maction_defs_tl
1041: WHERE maction_def_id = l_maction_def_id;
1042:
1043: DELETE FROM ieu_uwq_maction_defs_b
1044: WHERE maction_def_id = l_maction_def_id;
1045: END IF;
1046: else
1047: DELETE FROM ieu_uwq_maction_defs_tl

Line 1050: DELETE FROM ieu_uwq_maction_defs_b

1046: else
1047: DELETE FROM ieu_uwq_maction_defs_tl
1048: WHERE maction_def_id = x_maction_id;
1049:
1050: DELETE FROM ieu_uwq_maction_defs_b
1051: WHERE maction_def_id = x_maction_id;
1052:
1053: end IF;
1054: END IF;