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_B

Line 124: r_param_set_id IN ieu_wp_act_param_sets_b.action_param_set_id%type

120: END CREATE_action_map;
121: PROCEDURE DELETE_Actions (x_return_status OUT NOCOPY VARCHAR2,
122: x_msg_count OUT NOCOPY NUMBER,
123: x_msg_data OUT NOCOPY VARCHAR2,
124: r_param_set_id IN ieu_wp_act_param_sets_b.action_param_set_id%type
125: ) is
126:
127: media_count NUMBER(15);
128: temp_svr_type_id NUMBER(15);

Line 134: v_param_set_id ieu_wp_act_param_sets_b.action_param_set_id%type;

130: v_label VARCHAR2(500);
131: v_SelectStmt Varchar2(500);
132: v_CursorID INTEGER;
133: v_Dummy INTEGER;
134: v_param_set_id ieu_wp_act_param_sets_b.action_param_set_id%type;
135:
136: CURSOR c_cursor IS
137: SELECT param_property_id
138: FROM ieu_wp_param_props_b

Line 162: ' delete from IEU_WP_ACT_PARAM_SETS_B '||

158: CLOSE c_cursor;
159:
160:
161: EXECUTE IMMEDIATE
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 '

Line 378: ieu_wp_act_param_sets_b sb

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
382: and db.maction_def_id = sb.wp_action_def_id

Line 393: ieu_wp_act_param_sets_b sb, ieu_uwq_node_ds ds

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'
397: and db.maction_def_id = sb.wp_action_def_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 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 808: select IEU_wp_act_param_sets_b_S1.NEXTVAL into l_new_param_set_id from sys.dual;

804:
805:
806:
807: if l_wp_maction_def_id is not null then
808: select IEU_wp_act_param_sets_b_S1.NEXTVAL into l_new_param_set_id from sys.dual;
809: /* TYPE IEU_WP_ACT_PARAM_SETS_SEED_PKG.WP_ACT_PARAM_SETS_rec_type IS RECORD (
810: ACTION_PARAM_SET_ID NUMBER(15),
811: WP_ACTION_DEF_ID NUMBER(15),
812: ACTION_PARAM_SET_LABEL VARCHAR2(128),

Line 890: ' ieu_wp_act_param_sets_b sb '||

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 '||
894: ' and db.maction_def_type_flag = :3 '||

Line 1039: l_user_param_set_id IEU_WP_ACT_PARAM_SETS_B.action_param_set_id%type;

1035: x_msg_data OUT NOCOPY VARCHAR2,
1036: r_applId IN NUMBER)
1037:
1038: AS
1039: l_user_param_set_id IEU_WP_ACT_PARAM_SETS_B.action_param_set_id%type;
1040: l_original_param_set_id IEU_WP_ACT_PARAM_SETS_B.action_param_set_id%type;
1041: v_cursor1 NUMBER;
1042: v_cursor2 NUMBER;
1043: v_cursor NUMBER;

Line 1040: l_original_param_set_id IEU_WP_ACT_PARAM_SETS_B.action_param_set_id%type;

1036: r_applId IN NUMBER)
1037:
1038: AS
1039: l_user_param_set_id IEU_WP_ACT_PARAM_SETS_B.action_param_set_id%type;
1040: l_original_param_set_id IEU_WP_ACT_PARAM_SETS_B.action_param_set_id%type;
1041: v_cursor1 NUMBER;
1042: v_cursor2 NUMBER;
1043: v_cursor NUMBER;
1044: l_param_property_id NUMBER;

Line 1063: l_action_param_set_id IEU_WP_ACT_PARAM_SETS_B.action_param_set_id%type;

1059: l_trans_flag IEU_WP_PROPERTIES_B.VALUE_TRANSLATABLE_FLAG%TYPE;
1060: l_temp IEU_WP_PARAM_PROPS_B.action_param_set_id%type;
1061: l_ptemp IEU_WP_PARAM_PROPS_B.param_id%type;
1062:
1063: l_action_param_set_id IEU_WP_ACT_PARAM_SETS_B.action_param_set_id%type;
1064: l_action_temp_id IEU_WP_ACT_PARAM_SETS_B.action_param_set_id%type;
1065: l_index NUMBER:=0;
1066: l_my_count NUMBER:=0;
1067: l_max_property NUMBER :=0;

Line 1064: l_action_temp_id IEU_WP_ACT_PARAM_SETS_B.action_param_set_id%type;

1060: l_temp IEU_WP_PARAM_PROPS_B.action_param_set_id%type;
1061: l_ptemp IEU_WP_PARAM_PROPS_B.param_id%type;
1062:
1063: l_action_param_set_id IEU_WP_ACT_PARAM_SETS_B.action_param_set_id%type;
1064: l_action_temp_id IEU_WP_ACT_PARAM_SETS_B.action_param_set_id%type;
1065: l_index NUMBER:=0;
1066: l_my_count NUMBER:=0;
1067: l_max_property NUMBER :=0;
1068: l_max_action_param_set_id IEU_WP_ACT_PARAM_SETS_B.action_param_set_id%type;

Line 1068: l_max_action_param_set_id IEU_WP_ACT_PARAM_SETS_B.action_param_set_id%type;

1064: l_action_temp_id IEU_WP_ACT_PARAM_SETS_B.action_param_set_id%type;
1065: l_index NUMBER:=0;
1066: l_my_count NUMBER:=0;
1067: l_max_property NUMBER :=0;
1068: l_max_action_param_set_id IEU_WP_ACT_PARAM_SETS_B.action_param_set_id%type;
1069: l_param_property_key ieu_wp_param_props_b.param_property_id%type;
1070: param_props_rec IEU_WP_PARAM_PROPS_SEED_PKG.wp_param_props_rec_type;
1071: param_sets_rec IEU_WP_PARAM_PROPS_SEED_PKG.wp_param_props_rec_type;
1072: v_applId ieu_wp_param_defs_b.application_id%type;

Line 1128: ' from ieu_wp_act_param_sets_b '||

1124: LOOP
1125: FETCH c_cur INTO c_rec;
1126: EXIT WHEN c_cur%NOTFOUND;
1127: sql_stmt1 := 'select action_param_set_id '||
1128: ' from ieu_wp_act_param_sets_b '||
1129: ' where action_param_set_id in (select distinct action_param_set_id '||
1130: ' from ieu_wp_act_param_sets_b '||
1131: ' where wp_action_def_id = :action_id '||
1132: ' ) '||

Line 1130: ' from ieu_wp_act_param_sets_b '||

1126: EXIT WHEN c_cur%NOTFOUND;
1127: sql_stmt1 := 'select action_param_set_id '||
1128: ' from ieu_wp_act_param_sets_b '||
1129: ' where action_param_set_id in (select distinct action_param_set_id '||
1130: ' from ieu_wp_act_param_sets_b '||
1131: ' where wp_action_def_id = :action_id '||
1132: ' ) '||
1133: ' and action_param_set_id not IN '||
1134: ' (select distinct action_param_set_id '||

Line 1145: ' from ieu_wp_act_param_sets_b '||

1141: FETCH c_ref INTO l_action_param_set_id;
1142: EXIT WHEN c_ref%NOTFOUND;
1143: l_index :=0; --initialize
1144: sql_stmt := 'select action_param_set_id '||
1145: ' from ieu_wp_act_param_sets_b '||
1146: ' where action_param_set_id in (select distinct action_param_set_id '||
1147: ' from ieu_wp_act_param_sets_b '||
1148: ' where wp_action_def_id = :action_id '||
1149: ') '||

Line 1147: ' from ieu_wp_act_param_sets_b '||

1143: l_index :=0; --initialize
1144: sql_stmt := 'select action_param_set_id '||
1145: ' from ieu_wp_act_param_sets_b '||
1146: ' where action_param_set_id in (select distinct action_param_set_id '||
1147: ' from ieu_wp_act_param_sets_b '||
1148: ' where wp_action_def_id = :action_id '||
1149: ') '||
1150: ' and action_param_set_id IN '||
1151: ' (select distinct action_param_set_id '||

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 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;

Line 1567: select IEU_wp_act_param_sets_b_S1.NEXTVAL into l_new_param_set_id from sys.dual;

1563: into l_wp_maction_def_id using r_param_set_id, r_wp_action_key;
1564:
1565:
1566: if l_wp_maction_def_id is not null then
1567: select IEU_wp_act_param_sets_b_S1.NEXTVAL into l_new_param_set_id from sys.dual;
1568: /* TYPE IEU_WP_ACT_PARAM_SETS_SEED_PKG.WP_ACT_PARAM_SETS_rec_type IS RECORD (
1569: ACTION_PARAM_SET_ID NUMBER(15),
1570: WP_ACTION_DEF_ID NUMBER(15),
1571: ACTION_PARAM_SET_LABEL VARCHAR2(128),