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

Line 93: ieu_wp_act_param_sets_b s, ieu_uwq_sel_enumerators e, ieu_wp_act_param_sets_tl stl

89: if (p_maction_def_type_flag <> 'F' and p_maction_def_type_flag <> 'N' and p_maction_def_type_flag <> 'M' ) then
90:
91: select count(b.maction_def_id) into l_act_usr_lbl_count
92: from ieu_uwq_maction_defs_b b, ieu_uwq_maction_defs_tl tl, ieu_wp_action_maps m,
93: ieu_wp_act_param_sets_b s, ieu_uwq_sel_enumerators e, ieu_wp_act_param_sets_tl stl
94: where e. sel_enum_id = rec_obj.enum_id
95: -- and e.application_id = m.application_id
96: and e.enum_type_uuid = m.action_map_code
97: and b.maction_def_id = tl.maction_def_id

Line 110: --from IEU_WP_ACT_PARAM_SETS_B sb, IEU_WP_ACT_PARAM_SETS_TL stl

106: and lower(tl.action_user_label) = lower(temp_act_user_label);
107:
108:
109: --select count(sb.action_param_set_id) into l_set_id_count
110: --from IEU_WP_ACT_PARAM_SETS_B sb, IEU_WP_ACT_PARAM_SETS_TL stl
111: --where sb.action_param_set_id = stl.action_param_set_id
112: --and stl.language = l_language
113: --and lower(stl.action_param_set_label) = lower(temp_act_user_label);
114:

Line 119: ieu_wp_act_param_sets_b s, ieu_uwq_sel_enumerators e, ieu_wp_act_param_sets_tl stl

115:
116:
117: select count(b.maction_def_id) into l_set_id_count
118: from ieu_uwq_maction_defs_b b, ieu_uwq_maction_defs_tl tl, ieu_wp_action_maps m,
119: ieu_wp_act_param_sets_b s, ieu_uwq_sel_enumerators e, ieu_wp_act_param_sets_tl stl
120: where e. sel_enum_id = rec_obj.enum_id
121: --and e.application_id = m.application_id
122: and e.enum_type_uuid = m.action_map_code
123: and b.maction_def_id = tl.maction_def_id

Line 140: ieu_wp_act_param_sets_tl stl, ieu_uwq_node_ds ds

136:
137: select count(b.maction_def_id) into l_act_usr_lbl_count
138: from ieu_uwq_maction_defs_b b, ieu_uwq_maction_defs_tl tl, ieu_wp_action_maps m,
139: ieu_wp_act_param_sets_b s, ieu_uwq_sel_enumerators e,
140: ieu_wp_act_param_sets_tl stl, ieu_uwq_node_ds ds
141: where e. sel_enum_id = rec_obj.enum_id
142: --and e.application_id = m.application_id
143: and e.enum_type_uuid = ds.ENUM_TYPE_UUID
144: and b.maction_def_id = tl.maction_def_id

Line 161: ieu_wp_act_param_sets_tl stl, ieu_uwq_node_ds ds

157:
158: select count(b.maction_def_id) into l_set_id_count
159: from ieu_uwq_maction_defs_b b, ieu_uwq_maction_defs_tl tl, ieu_wp_action_maps m,
160: ieu_wp_act_param_sets_b s, ieu_uwq_sel_enumerators e,
161: ieu_wp_act_param_sets_tl stl, ieu_uwq_node_ds ds
162: where e. sel_enum_id = rec_obj.enum_id
163: --and e.application_id = m.application_id
164: and e.enum_type_uuid = ds.ENUM_TYPE_UUID
165: and b.maction_def_id = tl.maction_def_id

Line 183: from ieu_wp_act_param_sets_tl stl, ieu_wp_act_param_sets_b s

179: end if;
180:
181: if (is_create = 'N' and p_maction_def_type_flag <> 'M' and p_maction_def_type_flag <> 'N') then
182: select action_param_set_label into l_temp_act_label
183: from ieu_wp_act_param_sets_tl stl, ieu_wp_act_param_sets_b s
184: where s.action_param_set_id = stl.action_param_set_id
185: and s.wp_action_def_id = rec_obj.maction_def_id
186: and stl.language = l_language
187: and stl.action_param_set_id = p_param_set_id;

Line 367: -- from IEU_WP_ACT_PARAM_SETS_B sb, IEU_WP_ACT_PARAM_SETS_TL stl

363: temp_act_user_label := LTRIM(RTRIM(p_label));
364:
365:
366: -- select count(sb.action_param_set_id) into l_set_id_count
367: -- from IEU_WP_ACT_PARAM_SETS_B sb, IEU_WP_ACT_PARAM_SETS_TL stl
368: -- where sb.action_param_set_id = stl.action_param_set_id
369: -- and stl.language = l_language
370: --and lower(stl.action_param_set_label) = lower(temp_act_user_label);
371:

Line 378: ieu_wp_act_param_sets_b s, ieu_uwq_sel_enumerators e, ieu_wp_act_param_sets_tl stl

374: if(p_maction_def_type_flag <> 'F') then
375:
376: select count(b.maction_def_id) into l_act_usr_lbl_count
377: from ieu_uwq_maction_defs_b b, ieu_uwq_maction_defs_tl tl, ieu_wp_action_maps m,
378: ieu_wp_act_param_sets_b s, ieu_uwq_sel_enumerators e, ieu_wp_act_param_sets_tl stl
379: where e. sel_enum_id = p_enum_id
380: -- and e.application_id = m.application_id
381: and e.enum_type_uuid = m.action_map_code
382: and b.maction_def_id = tl.maction_def_id

Line 397: ieu_wp_act_param_sets_b s, ieu_uwq_sel_enumerators e, ieu_wp_act_param_sets_tl stl

393: --DBMS_OUTPUT.PUT_LINE(' maction lable count : '||l_act_usr_lbl_count);
394:
395: select count(b.maction_def_id) into l_set_id_count
396: from ieu_uwq_maction_defs_b b, ieu_uwq_maction_defs_tl tl, ieu_wp_action_maps m,
397: ieu_wp_act_param_sets_b s, ieu_uwq_sel_enumerators e, ieu_wp_act_param_sets_tl stl
398: where e. sel_enum_id = p_enum_id
399: --and e.application_id = m.application_id
400: and e.enum_type_uuid = m.action_map_code
401: and b.maction_def_id = tl.maction_def_id

Line 416: ieu_wp_act_param_sets_b s, ieu_uwq_sel_enumerators e, ieu_wp_act_param_sets_tl stl,

412: elsif (p_maction_def_type_flag = 'F') then
413:
414: select count(b.maction_def_id) into l_act_usr_lbl_count
415: from ieu_uwq_maction_defs_b b, ieu_uwq_maction_defs_tl tl, ieu_wp_action_maps m,
416: ieu_wp_act_param_sets_b s, ieu_uwq_sel_enumerators e, ieu_wp_act_param_sets_tl stl,
417: IEU_UWQ_NODE_DS ds
418: where e. sel_enum_id = p_enum_id
419: --and e.application_id = m.application_id
420: and e.enum_type_uuid = ds.ENUM_TYPE_UUID

Line 438: ieu_wp_act_param_sets_b s, ieu_uwq_sel_enumerators e, ieu_wp_act_param_sets_tl stl, IEU_UWQ_NODE_DS ds

434:
435:
436: select count(b.maction_def_id) into l_set_id_count
437: from ieu_uwq_maction_defs_b b, ieu_uwq_maction_defs_tl tl, ieu_wp_action_maps m,
438: ieu_wp_act_param_sets_b s, ieu_uwq_sel_enumerators e, ieu_wp_act_param_sets_tl stl, IEU_UWQ_NODE_DS ds
439: where e. sel_enum_id = p_enum_id
440: --and e.application_id = m.application_id
441: and e.enum_type_uuid = ds.ENUM_TYPE_UUID
442: and b.maction_def_id = tl.maction_def_id

Line 767: insert INTO IEU_WP_ACT_PARAM_SETS_TL

763: 0
764: );
765: --DBMS_OUTPUT.PUT_LINE('inserted in param sets b: ');
766:
767: insert INTO IEU_WP_ACT_PARAM_SETS_TL
768: (ACTION_PARAM_SET_ID,
769: CREATED_BY,
770: CREATION_DATE,
771: LAST_UPDATED_BY,

Line 1064: update IEU_WP_ACT_PARAM_SETS_TL set

1060: where MACTION_DEF_ID = rec_obj.maction_def_id
1061: and MACTION_DEF_TYPE_FLAG = p_maction_def_type_flag;
1062:
1063:
1064: update IEU_WP_ACT_PARAM_SETS_TL set
1065: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1066: LAST_UPDATE_DATE = SYSDATE,
1067: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
1068: ACTION_PARAM_SET_LABEL = LTRIM(RTRIM(rec_obj.action_user_label)),

Line 1146: delete from IEU_WP_ACT_PARAM_SETS_TL

1142: null;
1143: end if;
1144:
1145:
1146: delete from IEU_WP_ACT_PARAM_SETS_TL
1147: where ACTION_PARAM_SET_ID = l_action_param_set_id and language= l_language;
1148:
1149: if (sql%notfound) then
1150: null;

Line 1317: DELETE FROM ieu_wp_act_param_sets_tl

1313:
1314: DELETE FROM ieu_wp_param_props_b
1315: WHERE action_param_set_id = x_param_set_id;
1316:
1317: DELETE FROM ieu_wp_act_param_sets_tl
1318: WHERE action_param_set_id = x_param_set_id;
1319:
1320: DELETE FROM ieu_wp_act_param_sets_b
1321: WHERE action_param_set_id = x_param_set_id;