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 DBMS_SQL

Line 75: --v_cursor := DBMS_SQL.OPEN_CURSOR;

71: -- find enumId, applicationId, and panel for
72: FOR cur_rec IN c_cursor
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;

Line 80: -- DBMS_SQL.parse(v_cursor, sql_stmt, DBMS_SQL.V7);

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);
82: -- DBMS_SQL.DEFINE_COLUMN(v_cursor, 2, l_property_id);
83: -- v_numrows1 := DBMS_SQL.EXECUTE(v_cursor);
84: --v_numrows1 := DBMS_SQL.FETCH_ROWS(v_cursor);

Line 81: -- DBMS_SQL.DEFINE_COLUMN(v_cursor, 1, l_delete_param_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);
82: -- DBMS_SQL.DEFINE_COLUMN(v_cursor, 2, l_property_id);
83: -- v_numrows1 := DBMS_SQL.EXECUTE(v_cursor);
84: --v_numrows1 := DBMS_SQL.FETCH_ROWS(v_cursor);
85: LOOP

Line 82: -- DBMS_SQL.DEFINE_COLUMN(v_cursor, 2, l_property_id);

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);
82: -- DBMS_SQL.DEFINE_COLUMN(v_cursor, 2, l_property_id);
83: -- v_numrows1 := DBMS_SQL.EXECUTE(v_cursor);
84: --v_numrows1 := DBMS_SQL.FETCH_ROWS(v_cursor);
85: LOOP
86: --if DBMS_SQL.FETCH_ROWS(v_cursor) = 0 then

Line 83: -- v_numrows1 := DBMS_SQL.EXECUTE(v_cursor);

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);
82: -- DBMS_SQL.DEFINE_COLUMN(v_cursor, 2, l_property_id);
83: -- v_numrows1 := DBMS_SQL.EXECUTE(v_cursor);
84: --v_numrows1 := DBMS_SQL.FETCH_ROWS(v_cursor);
85: LOOP
86: --if DBMS_SQL.FETCH_ROWS(v_cursor) = 0 then
87: -- exit;

Line 84: --v_numrows1 := DBMS_SQL.FETCH_ROWS(v_cursor);

80: -- DBMS_SQL.parse(v_cursor, sql_stmt, DBMS_SQL.V7);
81: -- DBMS_SQL.DEFINE_COLUMN(v_cursor, 1, l_delete_param_property_id);
82: -- DBMS_SQL.DEFINE_COLUMN(v_cursor, 2, l_property_id);
83: -- v_numrows1 := DBMS_SQL.EXECUTE(v_cursor);
84: --v_numrows1 := DBMS_SQL.FETCH_ROWS(v_cursor);
85: LOOP
86: --if DBMS_SQL.FETCH_ROWS(v_cursor) = 0 then
87: -- exit;
88: --end if;

Line 86: --if DBMS_SQL.FETCH_ROWS(v_cursor) = 0 then

82: -- DBMS_SQL.DEFINE_COLUMN(v_cursor, 2, l_property_id);
83: -- v_numrows1 := DBMS_SQL.EXECUTE(v_cursor);
84: --v_numrows1 := DBMS_SQL.FETCH_ROWS(v_cursor);
85: LOOP
86: --if DBMS_SQL.FETCH_ROWS(v_cursor) = 0 then
87: -- exit;
88: --end if;
89: --DBMS_SQL.COLUMN_VALUE(v_cursor, 1, l_delete_param_property_id);
90: --DBMS_SQL.COLUMN_VALUE(v_cursor, 2, l_property_id);

Line 89: --DBMS_SQL.COLUMN_VALUE(v_cursor, 1, l_delete_param_property_id);

85: LOOP
86: --if DBMS_SQL.FETCH_ROWS(v_cursor) = 0 then
87: -- exit;
88: --end if;
89: --DBMS_SQL.COLUMN_VALUE(v_cursor, 1, l_delete_param_property_id);
90: --DBMS_SQL.COLUMN_VALUE(v_cursor, 2, l_property_id);
91: FETCH c_ref INTO l_delete_param_property_id, l_property_id;
92: EXIT WHEN c_ref%NOTFOUND;
93:

Line 90: --DBMS_SQL.COLUMN_VALUE(v_cursor, 2, l_property_id);

86: --if DBMS_SQL.FETCH_ROWS(v_cursor) = 0 then
87: -- exit;
88: --end if;
89: --DBMS_SQL.COLUMN_VALUE(v_cursor, 1, l_delete_param_property_id);
90: --DBMS_SQL.COLUMN_VALUE(v_cursor, 2, l_property_id);
91: FETCH c_ref INTO l_delete_param_property_id, l_property_id;
92: EXIT WHEN c_ref%NOTFOUND;
93:
94: select VALUE_TRANSLATABLE_FLAG into l_trans_flag

Line 107: --DBMS_SQL.CLOSE_CURSOR(v_cursor);

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;
109:
110: delete from ieu_wp_act_param_sets_b where action_param_set_id = cur_rec.action_param_set_id;
111: delete from ieu_wp_act_param_sets_tl where action_param_set_id = cur_rec.action_param_set_id;

Line 227: -- v_cursor := DBMS_SQL.OPEN_CURSOR;

223:
224:
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);

Line 231: --DBMS_SQL.parse(v_cursor, sql_stmt, DBMS_SQL.V7);

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);
234: --v_numrows1 := DBMS_SQL.EXECUTE(v_cursor);
235: --v_numrows1 := DBMS_SQL.FETCH_ROWS(v_cursor);

Line 232: --DBMS_SQL.DEFINE_COLUMN(v_cursor, 1, l_delete_param_property_id);

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

Line 233: --DBMS_SQL.DEFINE_COLUMN(v_cursor, 2, l_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);
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;

Line 234: --v_numrows1 := DBMS_SQL.EXECUTE(v_cursor);

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

Line 235: --v_numrows1 := DBMS_SQL.FETCH_ROWS(v_cursor);

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

Line 242: --if DBMS_SQL.FETCH_ROWS(v_cursor) = 0 then

238: -- LOOP
239: -- FETCH c_ref INTO l_delete_param_property_id, l_property_id;
240: -- EXIT WHEN c_ref%NOTFOUND;
241:
242: --if DBMS_SQL.FETCH_ROWS(v_cursor) = 0 then
243: -- exit;
244: --end if;
245: --DBMS_SQL.COLUMN_VALUE(v_cursor, 1, l_delete_param_property_id);
246: --DBMS_SQL.COLUMN_VALUE(v_cursor, 2, l_property_id);

Line 245: --DBMS_SQL.COLUMN_VALUE(v_cursor, 1, l_delete_param_property_id);

241:
242: --if DBMS_SQL.FETCH_ROWS(v_cursor) = 0 then
243: -- exit;
244: --end if;
245: --DBMS_SQL.COLUMN_VALUE(v_cursor, 1, l_delete_param_property_id);
246: --DBMS_SQL.COLUMN_VALUE(v_cursor, 2, l_property_id);
247:
248: -- select VALUE_TRANSLATABLE_FLAG into l_trans_flag
249: -- from ieu_wp_properties_b

Line 246: --DBMS_SQL.COLUMN_VALUE(v_cursor, 2, l_property_id);

242: --if DBMS_SQL.FETCH_ROWS(v_cursor) = 0 then
243: -- exit;
244: --end if;
245: --DBMS_SQL.COLUMN_VALUE(v_cursor, 1, l_delete_param_property_id);
246: --DBMS_SQL.COLUMN_VALUE(v_cursor, 2, l_property_id);
247:
248: -- select VALUE_TRANSLATABLE_FLAG into l_trans_flag
249: -- from ieu_wp_properties_b
250: -- where property_id = l_property_id;

Line 260: --DBMS_SQL.CLOSE_CURSOR(v_cursor);

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;
262:
263: -- delete from ieu_wp_act_param_sets_b where action_param_set_id = cur_rec.action_param_set_id;
264: -- delete from ieu_wp_act_param_sets_tl where action_param_set_id = cur_rec.action_param_set_id;

Line 445: v_cursor1 := DBMS_SQL.OPEN_CURSOR;

441: end LOOP;
442: FOR cur_rec IN c_cursor3
443: loop
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 '||

Line 454: --DBMS_SQL.parse(v_cursor1, sql_stmt1, DBMS_SQL.V7);

450: ' AND action_param_set_id = :id ' ||
451: ' order by property_value';
452:
453: Open c_ref FOR sql_stmt1 USING cur_rec.action_param_set_id;
454: --DBMS_SQL.parse(v_cursor1, sql_stmt1, DBMS_SQL.V7);
455: --DBMS_SQL.DEFINE_COLUMN(v_cursor1, 1, l_param_property_id);
456: --DBMS_SQL.DEFINE_COLUMN(v_cursor1, 2, l_property_value,4000);
457: --v_numrows1 := DBMS_SQL.EXECUTE(v_cursor1);
458:

Line 455: --DBMS_SQL.DEFINE_COLUMN(v_cursor1, 1, l_param_property_id);

451: ' order by property_value';
452:
453: Open c_ref FOR sql_stmt1 USING cur_rec.action_param_set_id;
454: --DBMS_SQL.parse(v_cursor1, sql_stmt1, DBMS_SQL.V7);
455: --DBMS_SQL.DEFINE_COLUMN(v_cursor1, 1, l_param_property_id);
456: --DBMS_SQL.DEFINE_COLUMN(v_cursor1, 2, l_property_value,4000);
457: --v_numrows1 := DBMS_SQL.EXECUTE(v_cursor1);
458:
459: LOOP

Line 456: --DBMS_SQL.DEFINE_COLUMN(v_cursor1, 2, l_property_value,4000);

452:
453: Open c_ref FOR sql_stmt1 USING cur_rec.action_param_set_id;
454: --DBMS_SQL.parse(v_cursor1, sql_stmt1, DBMS_SQL.V7);
455: --DBMS_SQL.DEFINE_COLUMN(v_cursor1, 1, l_param_property_id);
456: --DBMS_SQL.DEFINE_COLUMN(v_cursor1, 2, l_property_value,4000);
457: --v_numrows1 := DBMS_SQL.EXECUTE(v_cursor1);
458:
459: LOOP
460: FETCH c_ref INTO l_param_property_id, l_property_value;

Line 457: --v_numrows1 := DBMS_SQL.EXECUTE(v_cursor1);

453: Open c_ref FOR sql_stmt1 USING cur_rec.action_param_set_id;
454: --DBMS_SQL.parse(v_cursor1, sql_stmt1, DBMS_SQL.V7);
455: --DBMS_SQL.DEFINE_COLUMN(v_cursor1, 1, l_param_property_id);
456: --DBMS_SQL.DEFINE_COLUMN(v_cursor1, 2, l_property_value,4000);
457: --v_numrows1 := DBMS_SQL.EXECUTE(v_cursor1);
458:
459: LOOP
460: FETCH c_ref INTO l_param_property_id, l_property_value;
461: EXIT WHEN c_ref%NOTFOUND;

Line 463: --if DBMS_SQL.FETCH_ROWS(v_cursor1) = 0 then

459: LOOP
460: FETCH c_ref INTO l_param_property_id, l_property_value;
461: EXIT WHEN c_ref%NOTFOUND;
462:
463: --if DBMS_SQL.FETCH_ROWS(v_cursor1) = 0 then
464: -- exit;
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);

Line 466: --DBMS_SQL.COLUMN_VALUE(v_cursor1, 1, l_param_property_id);

462:
463: --if DBMS_SQL.FETCH_ROWS(v_cursor1) = 0 then
464: -- exit;
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,

Line 467: --DBMS_SQL.COLUMN_VALUE(v_cursor1, 2, l_property_value);

463: --if DBMS_SQL.FETCH_ROWS(v_cursor1) = 0 then
464: -- exit;
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,

Line 480: --DBMS_SQL.CLOSE_CURSOR(v_cursor1);

476: END if;
477: l_count := l_count +1;
478:
479: end loop; --for v_cursor
480: --DBMS_SQL.CLOSE_CURSOR(v_cursor1);
481: CLOSE c_ref;
482: END loop;
483: EXCEPTION
484: WHEN fnd_api.g_exc_error THEN