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_B

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 139: ieu_wp_act_param_sets_b s, ieu_uwq_sel_enumerators e,

135: elsif (p_maction_def_type_flag = 'F') then
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

Line 160: ieu_wp_act_param_sets_b s, ieu_uwq_sel_enumerators e,

156:
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

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 629: l_action_param_set_id IEU_WP_ACT_PARAM_SETS_B.ACTION_PARAM_SET_ID%TYPE;

625: l_msg_data VARCHAR2(2000);
626:
627: l_maction_def_id IEU_UWQ_MACTION_DEFS_B.MACTION_DEF_ID%TYPE;
628:
629: l_action_param_set_id IEU_WP_ACT_PARAM_SETS_B.ACTION_PARAM_SET_ID%TYPE;
630:
631: l_enum_uuid IEU_UWQ_SEL_ENUMERATORS.ENUM_TYPE_UUID%type;
632:
633:

Line 741: select IEU_WP_ACT_PARAM_SETS_B_S1.NEXTVAL into l_action_param_set_id from sys.dual;

737: );
738:
739: --DBMS_OUTPUT.PUT_LINE('inserted in maction defs tl ');
740:
741: select IEU_WP_ACT_PARAM_SETS_B_S1.NEXTVAL into l_action_param_set_id from sys.dual;
742:
743: --DBMS_OUTPUT.PUT_LINE('got next val '|| l_action_param_set_id);
744:
745:

Line 746: insert INTO IEU_WP_ACT_PARAM_SETS_B

742:
743: --DBMS_OUTPUT.PUT_LINE('got next val '|| l_action_param_set_id);
744:
745:
746: insert INTO IEU_WP_ACT_PARAM_SETS_B
747: (ACTION_PARAM_SET_ID,
748: CREATED_BY,
749: CREATION_DATE,
750: LAST_UPDATED_BY,

Line 804: ieu_wp_act_param_sets_b sb

800: if (p_maction_def_type_flag <> 'F') then
801:
802: select max(m.action_map_sequence) into l_temp_map_sequence
803: from ieu_wp_action_maps m, ieu_uwq_maction_defs_b db,
804: ieu_wp_act_param_sets_b sb
805: --where m.application_id = rec_obj.application_id
806: where m.action_map_type_code = 'NODE'
807: and m.action_map_code = l_enum_uuid
808: --and m.application_id = db.application_id

Line 1007: l_action_param_set_id IEU_WP_ACT_PARAM_SETS_B.ACTION_PARAM_SET_ID%type;

1003: l_language VARCHAR2(4);
1004:
1005: l_source_lang VARCHAR2(4);
1006:
1007: l_action_param_set_id IEU_WP_ACT_PARAM_SETS_B.ACTION_PARAM_SET_ID%type;
1008:
1009: l_return_status VARCHAR2(4);
1010:
1011: l_msg_count NUMBER(2);

Line 1109: l_action_param_set_id IEU_WP_ACT_PARAM_SETS_B.ACTION_PARAM_SET_ID%type;

1105: ) is
1106:
1107: l_language VARCHAR2(4);
1108:
1109: l_action_param_set_id IEU_WP_ACT_PARAM_SETS_B.ACTION_PARAM_SET_ID%type;
1110:
1111:
1112:
1113: BEGIN

Line 1118: from IEU_WP_ACT_PARAM_SETS_B

1114: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
1115:
1116:
1117: select ACTION_PARAM_SET_ID into l_action_param_set_id
1118: from IEU_WP_ACT_PARAM_SETS_B
1119: where WP_ACTION_DEF_ID = x_action_def_id;
1120:
1121:
1122:

Line 1138: delete from IEU_WP_ACT_PARAM_SETS_B

1134: null;
1135: end if;
1136:
1137:
1138: delete from IEU_WP_ACT_PARAM_SETS_B
1139: where WP_ACTION_DEF_ID = x_action_def_id;
1140:
1141: if (sql%notfound) then
1142: null;

Line 1185: l_action_param_set_id IEU_WP_ACT_PARAM_SETS_B.ACTION_PARAM_SET_ID%type;

1181: ) is
1182:
1183: l_language VARCHAR2(4);
1184:
1185: l_action_param_set_id IEU_WP_ACT_PARAM_SETS_B.ACTION_PARAM_SET_ID%type;
1186: l_maction_def_id IEU_UWQ_MACTION_DEFS_B.MACTION_DEF_ID%type;
1187: l_num_map_entries NUMBER;
1188: l_num_set_entries NUMBER;
1189:

Line 1213: ieu_wp_act_param_sets_b sb

1209: --I.
1210: SELECT db.maction_def_type_flag
1211: into l_def_type_flag
1212: FROM ieu_uwq_maction_defs_b db,
1213: ieu_wp_act_param_sets_b sb
1214: WHERE db.maction_def_id = sb.wp_action_def_id
1215: AND sb.action_param_set_id = x_param_set_id;
1216:
1217: --1.

Line 1263: FROM ieu_wp_act_param_sets_b

1259: (SELECT enum_type_uuid FROM ieu_uwq_sel_enumerators
1260: WHERE sel_enum_id = x_node_id)
1261: and action_param_set_id in
1262: (SELECT action_param_set_id
1263: FROM ieu_wp_act_param_sets_b
1264: WHERE wp_action_def_id in
1265: (select maction_def_id
1266: from ieu_uwq_maction_defs_b
1267: where maction_def_type_flag = l_def_type_flag

Line 1301: FROM ieu_wp_act_param_sets_b

1297:
1298: --a.
1299: SELECT wp_action_def_id, COUNT(*)
1300: INTO l_maction_def_id, l_num_set_entries
1301: FROM ieu_wp_act_param_sets_b
1302: WHERE wp_action_def_id IN
1303: (SELECT wp_action_def_id FROM ieu_wp_act_param_sets_b
1304: WHERE action_param_set_id = x_param_set_id)
1305: GROUP BY wp_action_def_id;

Line 1303: (SELECT wp_action_def_id FROM ieu_wp_act_param_sets_b

1299: SELECT wp_action_def_id, COUNT(*)
1300: INTO l_maction_def_id, l_num_set_entries
1301: FROM ieu_wp_act_param_sets_b
1302: WHERE wp_action_def_id IN
1303: (SELECT wp_action_def_id FROM ieu_wp_act_param_sets_b
1304: WHERE action_param_set_id = x_param_set_id)
1305: GROUP BY wp_action_def_id;
1306:
1307: --b.

Line 1320: DELETE FROM ieu_wp_act_param_sets_b

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;
1322:
1323: --c.
1324: IF (l_num_set_entries = 1) THEN

Line 1572: l_action_param_set_id IEU_WP_ACT_PARAM_SETS_B.ACTION_PARAM_SET_ID%TYPE;

1568: l_param_id IEU_WP_PARAM_DEFS_B.PARAM_ID%TYPE;
1569:
1570: l_action_param_map_id IEU_WP_ACTION_PARAMS.ACTION_PARAM_MAP_ID%TYPE;
1571:
1572: l_action_param_set_id IEU_WP_ACT_PARAM_SETS_B.ACTION_PARAM_SET_ID%TYPE;
1573:
1574:
1575: BEGIN
1576:

Line 1747: l_action_param_set_id IEU_WP_ACT_PARAM_SETS_B.ACTION_PARAM_SET_ID%TYPE;

1743: l_param_id IEU_WP_PARAM_DEFS_B.PARAM_ID%TYPE;
1744:
1745: l_action_param_map_id IEU_WP_ACTION_PARAMS.ACTION_PARAM_MAP_ID%TYPE;
1746:
1747: l_action_param_set_id IEU_WP_ACT_PARAM_SETS_B.ACTION_PARAM_SET_ID%TYPE;
1748:
1749: BEGIN
1750:
1751:

Line 2549: p_param_set_id IN IEU_WP_ACT_PARAM_SETS_B.ACTION_PARAM_SET_ID%type,

2545: -- r_language IN VARCHAR2,
2546: -- r_label IN VARCHAR2,
2547: -- r_desc IN VARCHAR2,
2548: rec_obj IN SYSTEM.IEU_WP_MACT_OBJ,
2549: p_param_set_id IN IEU_WP_ACT_PARAM_SETS_B.ACTION_PARAM_SET_ID%type,
2550: p_maction_def_type_flag IN VARCHAR2)
2551: AS
2552:
2553: l_wp_maction_def_id NUMBER(15);

Line 2614: p_param_set_id IN IEU_WP_ACT_PARAM_SETS_B.ACTION_PARAM_SET_ID%type,

2610: PROCEDURE Create_From_Filter( x_return_status OUT NOCOPY VARCHAR2,
2611: x_msg_count OUT NOCOPY NUMBER,
2612: x_msg_data OUT NOCOPY VARCHAR2,
2613: rec_obj IN SYSTEM.IEU_WP_MACT_OBJ,
2614: p_param_set_id IN IEU_WP_ACT_PARAM_SETS_B.ACTION_PARAM_SET_ID%type,
2615: p_maction_def_type_flag IN VARCHAR2)
2616: AS
2617:
2618: l_wp_maction_def_id NUMBER(15);

Line 2699: p_param_set_id IN IEU_WP_ACT_PARAM_SETS_B.ACTION_PARAM_SET_ID%type,

2695: x_msg_count OUT NOCOPY NUMBER,
2696: x_msg_data OUT NOCOPY VARCHAR2,
2697: p_enum_id IN NUMBER,
2698: p_application IN NUMBER,
2699: p_param_set_id IN IEU_WP_ACT_PARAM_SETS_B.ACTION_PARAM_SET_ID%type,
2700: p_maction_def_type_flag IN VARCHAR2
2701: ) as
2702:
2703: l_language VARCHAR2(4);

Line 2750: ieu_wp_act_param_sets_b sb

2746: where sel_enum_id = p_enum_id;
2747:
2748: select max(m.action_map_sequence) into l_temp_map_sequence
2749: from ieu_wp_action_maps m, ieu_uwq_maction_defs_b db,
2750: ieu_wp_act_param_sets_b sb
2751: --where m.application_id = p_application
2752: where m.action_map_type_code = 'NODE'
2753: and m.action_map_code = l_enum_uuid
2754: -- and m.application_id = db.application_id