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_PARAM_PROPS_B

Line 138: FROM ieu_wp_param_props_b

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
139: WHERE action_param_set_id = v_param_set_id;
140: cur_rec c_cursor%ROWTYPE;
141: begin
142: fnd_msg_pub.delete_msg();

Line 152: delete from IEU_WP_PARAM_PROPS_B

148: OPEN c_cursor;
149: Loop
150: FETCH c_cursor INTO cur_rec;
151: EXIT WHEN c_cursor%NOTFOUND;
152: delete from IEU_WP_PARAM_PROPS_B
153: where param_property_id = cur_rec.param_property_id;
154:
155: delete from IEU_WP_PARAM_PROPS_TL
156: where param_property_id = cur_rec.param_property_id;

Line 633: l_param_property_id IEU_WP_PARAM_PROPS_B.PARAM_PROPERTY_ID%TYPE;

629: l_msg_count NUMBER(2);
630:
631: l_msg_data VARCHAR2(2000);
632:
633: l_param_property_id IEU_WP_PARAM_PROPS_B.PARAM_PROPERTY_ID%TYPE;
634:
635: l_trans_flag IEU_WP_PROPERTIES_B.VALUE_TRANSLATABLE_FLAG%TYPE;
636:
637: v_cursor1 NUMBER;

Line 721: l_param_property_id IEU_WP_PARAM_PROPS_B.PARAM_PROPERTY_ID%TYPE;

717: l_msg_count NUMBER(2);
718: v_wp_action_key varchar2(500);
719: l_msg_data VARCHAR2(2000);
720:
721: l_param_property_id IEU_WP_PARAM_PROPS_B.PARAM_PROPERTY_ID%TYPE;
722:
723: l_trans_flag IEU_WP_PROPERTIES_B.VALUE_TRANSLATABLE_FLAG%TYPE;
724:
725: v_cursor1 NUMBER;

Line 742: v_param_set_id ieu_wp_param_props_b.action_param_set_id%type;

738: param_props_rec IEU_WP_PARAM_PROPS_SEED_PKG.wp_param_props_rec_type;
739: v_SelectStmt Varchar2(500);
740: v_CursorID INTEGER;
741: v_Dummy INTEGER;
742: v_param_set_id ieu_wp_param_props_b.action_param_set_id%type;
743: v_language ieu_wp_param_props_tl.language%type;
744: v_enumId ieu_uwq_sel_enumerators.sel_enum_id%type;
745: v_responsibility_id ieu_wp_action_maps.responsibility_id%type;
746: cursor c_cur is

Line 750: FROM ieu_wp_param_props_b

746: cursor c_cur is
747: SELECT
748: PARAM_ID, PROPERTY_ID,property_value
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(+)

Line 844: select IEU_WP_PARAM_PROPS_B_S1.NEXTVAL into l_param_property_id from sys.dual;

840: OPEN c_cur;
841: Loop
842: FETCH c_cur INTO c_rec;
843: EXIT WHEN c_cur%NOTFOUND;
844: select IEU_WP_PARAM_PROPS_B_S1.NEXTVAL into l_param_property_id from sys.dual;
845: /*TYPE IEU_WP_PARAM_PROPS_SEED_PKG.wp_param_props_rec_type IS RECORD (
846: PARAM_PROPERTY_ID NUMBER(15),
847: ACTION_PARAM_SET_ID NUMBER,
848: PARAM_ID NUMBER,

Line 1058: l_delete_param_property_id IEU_WP_PARAM_PROPS_B.param_property_id%type;

1054: sql_stmt2 varchar2(2000);
1055: l_count NUMBER :=0;
1056: l_language VARCHAR2(4);
1057: l_source_lang VARCHAR2(4);
1058: l_delete_param_property_id IEU_WP_PARAM_PROPS_B.param_property_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:

Line 1060: l_temp IEU_WP_PARAM_PROPS_B.action_param_set_id%type;

1056: l_language VARCHAR2(4);
1057: l_source_lang VARCHAR2(4);
1058: l_delete_param_property_id IEU_WP_PARAM_PROPS_B.param_property_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;

Line 1061: l_ptemp IEU_WP_PARAM_PROPS_B.param_id%type;

1057: l_source_lang VARCHAR2(4);
1058: l_delete_param_property_id IEU_WP_PARAM_PROPS_B.param_property_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;

Line 1069: l_param_property_key ieu_wp_param_props_b.param_property_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;
1073: TYPE c_cursor5 IS REF CURSOR;

Line 1091: from ieu_wp_param_props_b

1087: -- In that case, the default value property should not be existed if there is.
1088: v_data_type ieu_wp_param_defs_b.data_type%type;
1089: cursor c_cur2 is
1090: select distinct action_param_set_id, param_id
1091: from ieu_wp_param_props_b
1092: where param_id in (select param_id from ieu_wp_param_defs_b
1093: where DATA_TYPE = v_data_type
1094: AND application_id(+) = v_applId)
1095: order by action_param_set_id;

Line 1108: delete from ieu_wp_param_props_b where param_property_id in

1104: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;
1105: x_msg_data := '';
1106:
1107: --delete param props if param has been deleted by some actions
1108: delete from ieu_wp_param_props_b where param_property_id in
1109: ( select param_property_id
1110: from ieu_wp_param_props_b
1111: where param_id not in (select param_id from ieu_wp_param_defs_b));
1112:

Line 1110: from ieu_wp_param_props_b

1106:
1107: --delete param props if param has been deleted by some actions
1108: delete from ieu_wp_param_props_b where param_property_id in
1109: ( select param_property_id
1110: from ieu_wp_param_props_b
1111: where param_id not in (select param_id from ieu_wp_param_defs_b));
1112:
1113: delete from ieu_wp_param_props_tl where param_property_id in
1114: ( select param_property_id

Line 1115: from ieu_wp_param_props_b

1111: where param_id not in (select param_id from ieu_wp_param_defs_b));
1112:
1113: delete from ieu_wp_param_props_tl where param_property_id in
1114: ( select param_property_id
1115: from ieu_wp_param_props_b
1116: where param_id not in (select param_id from ieu_wp_param_defs_b));
1117:
1118: --DBMS_OUTPUT.Put_Line('before for loop');
1119:

Line 1135: ' from ieu_wp_param_props_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 '||
1135: ' from ieu_wp_param_props_b '||
1136: ' where param_id = :param_id)';
1137:
1138: OPEN c_ref FOR sql_stmt1 USING c_rec.wp_action_def_id, c_rec.param_id;
1139:

Line 1152: ' from ieu_wp_param_props_b '||

1148: ' where wp_action_def_id = :action_id '||
1149: ') '||
1150: ' and action_param_set_id IN '||
1151: ' (select distinct action_param_set_id '||
1152: ' from ieu_wp_param_props_b '||
1153: ' where param_id = :param_id)';
1154:
1155: OPEN c_ref2 FOR sql_stmt USING c_rec.wp_action_def_id, c_rec.param_id;
1156:

Line 1161: from ieu_wp_param_props_b

1157: LOOP
1158: FETCH c_ref2 INTO l_action_temp_id;
1159: EXIT WHEN c_ref2%NOTFOUND;
1160: select count(property_id) into l_index
1161: from ieu_wp_param_props_b
1162: where action_param_set_id = l_action_temp_id
1163: and param_id = c_rec.param_id;
1164:
1165: if l_max_property < l_index then

Line 1177: ' from ieu_wp_param_props_b '||

1173:
1174: --get property_id, property_value, VALUE_OVERRIDE_FLAG, NOT_VALID_FLAG
1175: If l_max_action_param_set_id IS NOT NULL then
1176: sql_stmt2 := 'select property_id, property_value, VALUE_OVERRIDE_FLAG, NOT_VALID_FLAG '||
1177: ' from ieu_wp_param_props_b '||
1178: ' where param_id = :param_id '||
1179: ' and action_param_set_id = :max_set_id ';
1180: OPEN c_ref2 FOR sql_stmt2 USING c_rec.param_id, l_max_action_param_set_id;
1181: LOOP

Line 1185: select IEU_WP_PARAM_PROPS_B_S1.NEXTVAL into l_param_property_id from sys.dual;

1181: LOOP
1182: FETCH c_ref2 INTO l_property_id, l_property_value,l_value_override_flag,l_not_valid_flag;
1183: EXIT WHEN c_ref2%NOTFOUND;
1184:
1185: select IEU_WP_PARAM_PROPS_B_S1.NEXTVAL into l_param_property_id from sys.dual;
1186: /*TYPE IEU_WP_PARAM_PROPS_SEED_PKG.wp_param_props_rec_type IS RECORD (
1187: PARAM_PROPERTY_ID NUMBER(15),
1188: ACTION_PARAM_SET_ID NUMBER,
1189: PARAM_ID NUMBER,

Line 1239: ' from ieu_wp_param_props_b '||

1235: l_temp := c_rec2.action_param_set_id;
1236: l_ptemp := c_rec2.param_id;
1237: --v_cursor := DBMS_SQL.OPEN_CURSOR;
1238: sql_stmt1 :=' select param_property_id '||
1239: ' from ieu_wp_param_props_b '||
1240: ' where action_param_set_id = :temp '||
1241: ' and property_id = 10003'||
1242: ' and param_id = :ptemp ';
1243: OPEN c_ref2 FOR sql_stmt1 USING l_temp, l_ptemp;

Line 1258: update ieu_wp_param_props_b set

1254: PROPERTY_VALUE = null
1255: where param_property_id = l_delete_param_property_id;
1256: end if ;
1257:
1258: update ieu_wp_param_props_b set
1259: PROPERTY_ID =10022,
1260: PROPERTY_VALUE = null
1261: where param_property_id = l_delete_param_property_id;
1262:

Line 1478: l_param_property_id IEU_WP_PARAM_PROPS_B.PARAM_PROPERTY_ID%TYPE;

1474: l_msg_count NUMBER(2);
1475:
1476: l_msg_data VARCHAR2(2000);
1477:
1478: l_param_property_id IEU_WP_PARAM_PROPS_B.PARAM_PROPERTY_ID%TYPE;
1479:
1480: l_trans_flag IEU_WP_PROPERTIES_B.VALUE_TRANSLATABLE_FLAG%TYPE;
1481:
1482: v_cursor1 NUMBER;

Line 1508: FROM ieu_wp_param_props_b

1504: cursor c_cur is
1505: SELECT
1506: PARAM_ID, PROPERTY_ID,property_value
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(+)

Line 1602: select IEU_WP_PARAM_PROPS_B_S1.NEXTVAL into l_param_property_id from sys.dual;

1598: OPEN c_cur;
1599: Loop
1600: FETCH c_cur INTO c_rec;
1601: EXIT WHEN c_cur%NOTFOUND;
1602: select IEU_WP_PARAM_PROPS_B_S1.NEXTVAL into l_param_property_id from sys.dual;
1603: /*TYPE IEU_WP_PARAM_PROPS_SEED_PKG.wp_param_props_rec_type IS RECORD (
1604: PARAM_PROPERTY_ID NUMBER(15),
1605: ACTION_PARAM_SET_ID NUMBER,
1606: PARAM_ID NUMBER,