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_PANEL_PUB dependencies on IEU_WP_PARAM_PROPS_B

Line 30: l_property_id ieu_wp_param_props_b.property_id%type;

26: v_cursor1 NUMBER;
27: v_cursor NUMBER;
28: v_numrows1 NUMBER;
29: sql_stmt varchar2(2000);
30: l_property_id ieu_wp_param_props_b.property_id%type;
31: l_delete_param_property_id IEU_WP_PARAM_PROPS_B.param_property_id%type;
32: l_trans_flag IEU_WP_PROPERTIES_B.VALUE_TRANSLATABLE_FLAG%TYPE;
33: l_enumID ieu_uwq_sel_enumerators.sel_enum_id%type;
34: l_applId ieu_wp_action_maps.application_id%type;

Line 31: l_delete_param_property_id IEU_WP_PARAM_PROPS_B.param_property_id%type;

27: v_cursor NUMBER;
28: v_numrows1 NUMBER;
29: sql_stmt varchar2(2000);
30: l_property_id ieu_wp_param_props_b.property_id%type;
31: l_delete_param_property_id IEU_WP_PARAM_PROPS_B.param_property_id%type;
32: l_trans_flag IEU_WP_PROPERTIES_B.VALUE_TRANSLATABLE_FLAG%TYPE;
33: l_enumID ieu_uwq_sel_enumerators.sel_enum_id%type;
34: l_applId ieu_wp_action_maps.application_id%type;
35: l_panel ieu_uwq_maction_defs_b.maction_def_type_flag%type;

Line 77: ' from ieu_wp_param_props_b '||

73: LOOP
74: --DBMS_OUTPUT.Put_Line('going to delete action_param_set_id is '||cur_rec.action_param_set_id);
75: --v_cursor := DBMS_SQL.OPEN_CURSOR;
76: sql_stmt :=' select param_property_id, property_id'||
77: ' from ieu_wp_param_props_b '||
78: ' where action_param_set_id = :id';
79: Open c_ref FOR sql_stmt USING cur_rec.action_param_set_id;
80: -- DBMS_SQL.parse(v_cursor, sql_stmt, DBMS_SQL.V7);
81: -- DBMS_SQL.DEFINE_COLUMN(v_cursor, 1, l_delete_param_property_id);

Line 103: delete from ieu_wp_param_props_b where param_property_id = l_delete_param_property_id;

99: delete from ieu_wp_param_props_tl where param_property_id = l_delete_param_property_id;
100: --DBMS_OUTPUT.Put_Line(' delete ieu_wp_param_props_tl for id '|| l_delete_param_property_id);
101: end if ;
102:
103: delete from ieu_wp_param_props_b where param_property_id = l_delete_param_property_id;
104: --DBMS_OUTPUT.Put_Line(' delete ieu_wp_param_props_b for id '|| l_delete_param_property_id);
105:
106: end LOOP;
107: --DBMS_SQL.CLOSE_CURSOR(v_cursor);

Line 104: --DBMS_OUTPUT.Put_Line(' delete ieu_wp_param_props_b for id '|| l_delete_param_property_id);

100: --DBMS_OUTPUT.Put_Line(' delete ieu_wp_param_props_tl for id '|| l_delete_param_property_id);
101: end if ;
102:
103: delete from ieu_wp_param_props_b where param_property_id = l_delete_param_property_id;
104: --DBMS_OUTPUT.Put_Line(' delete ieu_wp_param_props_b for id '|| l_delete_param_property_id);
105:
106: end LOOP;
107: --DBMS_SQL.CLOSE_CURSOR(v_cursor);
108: Close c_ref;

Line 171: l_property_id ieu_wp_param_props_b.property_id%type;

167: v_cursor1 NUMBER;
168: v_cursor NUMBER;
169: v_numrows1 NUMBER;
170: sql_stmt varchar2(2000);
171: l_property_id ieu_wp_param_props_b.property_id%type;
172: l_delete_param_property_id IEU_WP_PARAM_PROPS_B.param_property_id%type;
173: l_trans_flag IEU_WP_PROPERTIES_B.VALUE_TRANSLATABLE_FLAG%TYPE;
174: l_language VARCHAR2(4);
175:

Line 172: l_delete_param_property_id IEU_WP_PARAM_PROPS_B.param_property_id%type;

168: v_cursor NUMBER;
169: v_numrows1 NUMBER;
170: sql_stmt varchar2(2000);
171: l_property_id ieu_wp_param_props_b.property_id%type;
172: l_delete_param_property_id IEU_WP_PARAM_PROPS_B.param_property_id%type;
173: l_trans_flag IEU_WP_PROPERTIES_B.VALUE_TRANSLATABLE_FLAG%TYPE;
174: l_language VARCHAR2(4);
175:
176: l_action_param_set_id IEU_WP_ACT_PARAM_SETS_B.ACTION_PARAM_SET_ID%type;

Line 229: -- ' from ieu_wp_param_props_b '||

225: FOR cur_rec IN c_cursor
226: LOOP
227: -- v_cursor := DBMS_SQL.OPEN_CURSOR;
228: -- sql_stmt :=' select param_property_id, property_id'||
229: -- ' from ieu_wp_param_props_b '||
230: -- ' where action_param_set_id = :id';
231: --DBMS_SQL.parse(v_cursor, sql_stmt, DBMS_SQL.V7);
232: --DBMS_SQL.DEFINE_COLUMN(v_cursor, 1, l_delete_param_property_id);
233: --DBMS_SQL.DEFINE_COLUMN(v_cursor, 2, l_property_id);

Line 236: --DBMS_OUTPUT.Put_Line(' delete record from ieu_wp_param_props_b for action_param_set_id '||l_temp||', property id is 10003 is '|| v_numrows1 );

232: --DBMS_SQL.DEFINE_COLUMN(v_cursor, 1, l_delete_param_property_id);
233: --DBMS_SQL.DEFINE_COLUMN(v_cursor, 2, l_property_id);
234: --v_numrows1 := DBMS_SQL.EXECUTE(v_cursor);
235: --v_numrows1 := DBMS_SQL.FETCH_ROWS(v_cursor);
236: --DBMS_OUTPUT.Put_Line(' delete record from ieu_wp_param_props_b for action_param_set_id '||l_temp||', property id is 10003 is '|| v_numrows1 );
237: -- OPEN c_ref FOR sql_stmt USING cur_rec.action_param_set_id;
238: -- LOOP
239: -- FETCH c_ref INTO l_delete_param_property_id, l_property_id;
240: -- EXIT WHEN c_ref%NOTFOUND;

Line 256: -- delete from ieu_wp_param_props_b where param_property_id = l_delete_param_property_id;

252: -- delete from ieu_wp_param_props_tl where param_property_id = l_delete_param_property_id;
253: --DBMS_OUTPUT.Put_Line(' delete ieu_wp_param_props_tl for id '|| l_delete_param_property_id);
254: -- end if ;
255:
256: -- delete from ieu_wp_param_props_b where param_property_id = l_delete_param_property_id;
257: --DBMS_OUTPUT.Put_Line(' delete ieu_wp_param_props_b for id '|| l_delete_param_property_id);
258:
259: -- end LOOP;
260: --DBMS_SQL.CLOSE_CURSOR(v_cursor);

Line 257: --DBMS_OUTPUT.Put_Line(' delete ieu_wp_param_props_b for id '|| l_delete_param_property_id);

253: --DBMS_OUTPUT.Put_Line(' delete ieu_wp_param_props_tl for id '|| l_delete_param_property_id);
254: -- end if ;
255:
256: -- delete from ieu_wp_param_props_b where param_property_id = l_delete_param_property_id;
257: --DBMS_OUTPUT.Put_Line(' delete ieu_wp_param_props_b for id '|| l_delete_param_property_id);
258:
259: -- end LOOP;
260: --DBMS_SQL.CLOSE_CURSOR(v_cursor);
261: -- Close c_ref;

Line 293: (SELECT param_property_id FROM ieu_wp_param_props_b

289: IF (l_num_map_entries = 1) THEN
290: --a.
291: DELETE FROM ieu_wp_param_props_tl
292: WHERE param_property_id IN
293: (SELECT param_property_id FROM ieu_wp_param_props_b
294: WHERE
295: action_param_set_id = cur_rec.action_param_set_id);
296:
297: DELETE FROM ieu_wp_param_props_b

Line 297: DELETE FROM ieu_wp_param_props_b

293: (SELECT param_property_id FROM ieu_wp_param_props_b
294: WHERE
295: action_param_set_id = cur_rec.action_param_set_id);
296:
297: DELETE FROM ieu_wp_param_props_b
298: WHERE action_param_set_id = cur_rec.action_param_set_id;
299:
300: DELETE FROM ieu_wp_act_param_sets_tl
301: WHERE action_param_set_id = cur_rec.action_param_set_id;

Line 357: l_property_id ieu_wp_param_props_b.property_id%type;

353: v_cursor1 NUMBER;
354: v_cursor NUMBER;
355: v_numrows1 NUMBER;
356: sql_stmt1 varchar2(2000);
357: l_property_id ieu_wp_param_props_b.property_id%type;
358: l_delete_param_property_id IEU_WP_PARAM_PROPS_B.param_property_id%type;
359: l_trans_flag IEU_WP_PROPERTIES_B.VALUE_TRANSLATABLE_FLAG%TYPE;
360: l_count NUMBER := 0;
361: l_param_property_id NUMBER;

Line 358: l_delete_param_property_id IEU_WP_PARAM_PROPS_B.param_property_id%type;

354: v_cursor NUMBER;
355: v_numrows1 NUMBER;
356: sql_stmt1 varchar2(2000);
357: l_property_id ieu_wp_param_props_b.property_id%type;
358: l_delete_param_property_id IEU_WP_PARAM_PROPS_B.param_property_id%type;
359: l_trans_flag IEU_WP_PROPERTIES_B.VALUE_TRANSLATABLE_FLAG%TYPE;
360: l_count NUMBER := 0;
361: l_param_property_id NUMBER;
362: l_property_value VARCHAR2(4000);

Line 391: from ieu_wp_param_props_b a, ieu_wp_param_defs_b b

387: );
388:
389: cursor c_cursor1 is
390: select a.param_property_id, a.property_id
391: from ieu_wp_param_props_b a, ieu_wp_param_defs_b b
392: where a.param_id = b.param_id
393: and b.param_name = LTRIM(RTRIM(r_param_name))
394: AND a.param_id IN (SELECT param_id
395: FROM ieu_wp_action_params

Line 429: delete from ieu_wp_param_props_b where param_property_id = cur_rec.param_property_id;

425: if (l_trans_flag = 'Y') then
426: delete from ieu_wp_param_props_tl where param_property_id = cur_rec.param_property_id;
427: end if ;
428:
429: delete from ieu_wp_param_props_b where param_property_id = cur_rec.param_property_id;
430:
431: end LOOP;
432: FOR cur_rec IN c_cursor2
433: LOOP

Line 448: ' FROM ieu_wp_param_props_b '||

444: l_count :=1;
445: v_cursor1 := DBMS_SQL.OPEN_CURSOR;
446: --find out the action_param_set_id which does not have param_id
447: sql_stmt1 := ' SELECT param_property_id, property_value '||
448: ' FROM ieu_wp_param_props_b '||
449: ' WHERE property_id = 10000 '||
450: ' AND action_param_set_id = :id ' ||
451: ' order by property_value';
452:

Line 469: UPDATE ieu_wp_param_props_b

465: --end if;
466: --DBMS_SQL.COLUMN_VALUE(v_cursor1, 1, l_param_property_id);
467: --DBMS_SQL.COLUMN_VALUE(v_cursor1, 2, l_property_value);
468: IF l_property_value <> l_count then
469: UPDATE ieu_wp_param_props_b
470: SET PROPERTY_VALUE = l_count,
471: last_update_date = sysdate,
472: last_update_login = 0
473: WHERE PARAM_PROPERTY_ID = l_param_property_id;