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.ECX_PURGE dependencies on DBMS_SQL

Line 67: l_CursorID := DBMS_SQL.OPEN_CURSOR;

63: end if;
64:
65: l_Select := l_Select || ' for update nowait ';
66:
67: l_CursorID := DBMS_SQL.OPEN_CURSOR;
68: DBMS_SQL.parse(l_CursorID, l_Select, DBMS_SQL.V7);
69:
70: DBMS_SQL.define_column(l_CursorID, 1, l_trigger_id );
71:

Line 68: DBMS_SQL.parse(l_CursorID, l_Select, DBMS_SQL.V7);

64:
65: l_Select := l_Select || ' for update nowait ';
66:
67: l_CursorID := DBMS_SQL.OPEN_CURSOR;
68: DBMS_SQL.parse(l_CursorID, l_Select, DBMS_SQL.V7);
69:
70: DBMS_SQL.define_column(l_CursorID, 1, l_trigger_id );
71:
72: if transaction_type is not null then

Line 70: DBMS_SQL.define_column(l_CursorID, 1, l_trigger_id );

66:
67: l_CursorID := DBMS_SQL.OPEN_CURSOR;
68: DBMS_SQL.parse(l_CursorID, l_Select, DBMS_SQL.V7);
69:
70: DBMS_SQL.define_column(l_CursorID, 1, l_trigger_id );
71:
72: if transaction_type is not null then
73: DBMS_SQL.bind_variable(l_CursorID , ':transaction_type' , transaction_type);
74: end if;

Line 73: DBMS_SQL.bind_variable(l_CursorID , ':transaction_type' , transaction_type);

69:
70: DBMS_SQL.define_column(l_CursorID, 1, l_trigger_id );
71:
72: if transaction_type is not null then
73: DBMS_SQL.bind_variable(l_CursorID , ':transaction_type' , transaction_type);
74: end if;
75: if transaction_subtype is not null then
76: DBMS_SQL.bind_variable(l_CursorID , ':transaction_subtype' , transaction_subtype);
77: end if;

Line 76: DBMS_SQL.bind_variable(l_CursorID , ':transaction_subtype' , transaction_subtype);

72: if transaction_type is not null then
73: DBMS_SQL.bind_variable(l_CursorID , ':transaction_type' , transaction_type);
74: end if;
75: if transaction_subtype is not null then
76: DBMS_SQL.bind_variable(l_CursorID , ':transaction_subtype' , transaction_subtype);
77: end if;
78: if party_id is not null then
79: DBMS_SQL.bind_variable(l_CursorID , ':party_id' , party_id);
80: end if;

Line 79: DBMS_SQL.bind_variable(l_CursorID , ':party_id' , party_id);

75: if transaction_subtype is not null then
76: DBMS_SQL.bind_variable(l_CursorID , ':transaction_subtype' , transaction_subtype);
77: end if;
78: if party_id is not null then
79: DBMS_SQL.bind_variable(l_CursorID , ':party_id' , party_id);
80: end if;
81: if party_site_id is not null then
82: DBMS_SQL.bind_variable(l_CursorID , ':party_site_id' , party_site_id);
83: end if;

Line 82: DBMS_SQL.bind_variable(l_CursorID , ':party_site_id' , party_site_id);

78: if party_id is not null then
79: DBMS_SQL.bind_variable(l_CursorID , ':party_id' , party_id);
80: end if;
81: if party_site_id is not null then
82: DBMS_SQL.bind_variable(l_CursorID , ':party_site_id' , party_site_id);
83: end if;
84: if fromDate is not null then
85: DBMS_SQL.bind_variable(l_CursorID , ':fromDate' , fromDate);
86: end if;

Line 85: DBMS_SQL.bind_variable(l_CursorID , ':fromDate' , fromDate);

81: if party_site_id is not null then
82: DBMS_SQL.bind_variable(l_CursorID , ':party_site_id' , party_site_id);
83: end if;
84: if fromDate is not null then
85: DBMS_SQL.bind_variable(l_CursorID , ':fromDate' , fromDate);
86: end if;
87: if toDate is not null then
88: DBMS_SQL.bind_variable(l_CursorID , ':toDate' , toDate);
89: end if;

Line 88: DBMS_SQL.bind_variable(l_CursorID , ':toDate' , toDate);

84: if fromDate is not null then
85: DBMS_SQL.bind_variable(l_CursorID , ':fromDate' , fromDate);
86: end if;
87: if toDate is not null then
88: DBMS_SQL.bind_variable(l_CursorID , ':toDate' , toDate);
89: end if;
90:
91: l_result := DBMS_SQL.EXECUTE(l_CursorID);
92:

Line 91: l_result := DBMS_SQL.EXECUTE(l_CursorID);

87: if toDate is not null then
88: DBMS_SQL.bind_variable(l_CursorID , ':toDate' , toDate);
89: end if;
90:
91: l_result := DBMS_SQL.EXECUTE(l_CursorID);
92:
93: loop
94:
95: if dbms_sql.fetch_rows( l_CursorID ) > 0 then

Line 95: if dbms_sql.fetch_rows( l_CursorID ) > 0 then

91: l_result := DBMS_SQL.EXECUTE(l_CursorID);
92:
93: loop
94:
95: if dbms_sql.fetch_rows( l_CursorID ) > 0 then
96:
97: DBMS_SQL.column_value(l_CursorID, 1, l_trigger_id );
98:
99: v_trigger_id_tl.extend;

Line 97: DBMS_SQL.column_value(l_CursorID, 1, l_trigger_id );

93: loop
94:
95: if dbms_sql.fetch_rows( l_CursorID ) > 0 then
96:
97: DBMS_SQL.column_value(l_CursorID, 1, l_trigger_id );
98:
99: v_trigger_id_tl.extend;
100:
101: v_trigger_id_tl( v_trigger_id_tl.last ) := l_trigger_id;

Line 107: DBMS_SQL.close_cursor (l_CursorID);

103: exit;
104: end if;
105: end loop;
106: /* Fix for Bug# 12860076 */
107: DBMS_SQL.close_cursor (l_CursorID);
108:
109: for i IN 1..v_trigger_id_tl.count loop
110:
111: open get_out_error_id(v_trigger_id_tl(i));

Line 160: IF DBMS_SQL.IS_OPEN(l_CursorID) THEN

156: END LOOP;
157: exception
158: WHEN others THEN
159: /* Fix for Bug# 12860076 */
160: IF DBMS_SQL.IS_OPEN(l_CursorID) THEN
161: DBMS_SQL.close_cursor (l_CursorID);
162: END IF;
163: /* Fix for Bug# 12860076 */
164: IF get_out_error_id%ISOPEN THEN

Line 161: DBMS_SQL.close_cursor (l_CursorID);

157: exception
158: WHEN others THEN
159: /* Fix for Bug# 12860076 */
160: IF DBMS_SQL.IS_OPEN(l_CursorID) THEN
161: DBMS_SQL.close_cursor (l_CursorID);
162: END IF;
163: /* Fix for Bug# 12860076 */
164: IF get_out_error_id%ISOPEN THEN
165: CLOSE get_out_error_id;

Line 286: l_CursorID := DBMS_SQL.OPEN_CURSOR;

282: end if;
283:
284: l_Select := l_Select || ' for update nowait ';
285:
286: l_CursorID := DBMS_SQL.OPEN_CURSOR;
287: DBMS_SQL.parse(l_CursorID, l_Select, DBMS_SQL.V7);
288:
289: DBMS_SQL.define_column_raw(l_CursorID, 1, l_msgId , 16);
290: DBMS_SQL.define_column(l_CursorID, 2, l_item_type, 8);

Line 287: DBMS_SQL.parse(l_CursorID, l_Select, DBMS_SQL.V7);

283:
284: l_Select := l_Select || ' for update nowait ';
285:
286: l_CursorID := DBMS_SQL.OPEN_CURSOR;
287: DBMS_SQL.parse(l_CursorID, l_Select, DBMS_SQL.V7);
288:
289: DBMS_SQL.define_column_raw(l_CursorID, 1, l_msgId , 16);
290: DBMS_SQL.define_column(l_CursorID, 2, l_item_type, 8);
291: DBMS_SQL.define_column(l_CursorID, 3, l_item_key , 240);

Line 289: DBMS_SQL.define_column_raw(l_CursorID, 1, l_msgId , 16);

285:
286: l_CursorID := DBMS_SQL.OPEN_CURSOR;
287: DBMS_SQL.parse(l_CursorID, l_Select, DBMS_SQL.V7);
288:
289: DBMS_SQL.define_column_raw(l_CursorID, 1, l_msgId , 16);
290: DBMS_SQL.define_column(l_CursorID, 2, l_item_type, 8);
291: DBMS_SQL.define_column(l_CursorID, 3, l_item_key , 240);
292:
293: if item_type is not null then

Line 290: DBMS_SQL.define_column(l_CursorID, 2, l_item_type, 8);

286: l_CursorID := DBMS_SQL.OPEN_CURSOR;
287: DBMS_SQL.parse(l_CursorID, l_Select, DBMS_SQL.V7);
288:
289: DBMS_SQL.define_column_raw(l_CursorID, 1, l_msgId , 16);
290: DBMS_SQL.define_column(l_CursorID, 2, l_item_type, 8);
291: DBMS_SQL.define_column(l_CursorID, 3, l_item_key , 240);
292:
293: if item_type is not null then
294: DBMS_SQL.bind_variable(l_CursorID , ':item_type' , item_type);

Line 291: DBMS_SQL.define_column(l_CursorID, 3, l_item_key , 240);

287: DBMS_SQL.parse(l_CursorID, l_Select, DBMS_SQL.V7);
288:
289: DBMS_SQL.define_column_raw(l_CursorID, 1, l_msgId , 16);
290: DBMS_SQL.define_column(l_CursorID, 2, l_item_type, 8);
291: DBMS_SQL.define_column(l_CursorID, 3, l_item_key , 240);
292:
293: if item_type is not null then
294: DBMS_SQL.bind_variable(l_CursorID , ':item_type' , item_type);
295: end if;

Line 294: DBMS_SQL.bind_variable(l_CursorID , ':item_type' , item_type);

290: DBMS_SQL.define_column(l_CursorID, 2, l_item_type, 8);
291: DBMS_SQL.define_column(l_CursorID, 3, l_item_key , 240);
292:
293: if item_type is not null then
294: DBMS_SQL.bind_variable(l_CursorID , ':item_type' , item_type);
295: end if;
296: if item_key is not null then
297: DBMS_SQL.bind_variable(l_CursorID , ':item_key' , item_key);
298: end if;

Line 297: DBMS_SQL.bind_variable(l_CursorID , ':item_key' , item_key);

293: if item_type is not null then
294: DBMS_SQL.bind_variable(l_CursorID , ':item_type' , item_type);
295: end if;
296: if item_key is not null then
297: DBMS_SQL.bind_variable(l_CursorID , ':item_key' , item_key);
298: end if;
299: if transaction_type is not null then
300: DBMS_SQL.bind_variable(l_CursorID , ':transaction_type' , transaction_type);
301: end if;

Line 300: DBMS_SQL.bind_variable(l_CursorID , ':transaction_type' , transaction_type);

296: if item_key is not null then
297: DBMS_SQL.bind_variable(l_CursorID , ':item_key' , item_key);
298: end if;
299: if transaction_type is not null then
300: DBMS_SQL.bind_variable(l_CursorID , ':transaction_type' , transaction_type);
301: end if;
302: if transaction_subtype is not null then
303: DBMS_SQL.bind_variable(l_CursorID , ':transaction_subtype' , transaction_subtype);
304: end if;

Line 303: DBMS_SQL.bind_variable(l_CursorID , ':transaction_subtype' , transaction_subtype);

299: if transaction_type is not null then
300: DBMS_SQL.bind_variable(l_CursorID , ':transaction_type' , transaction_type);
301: end if;
302: if transaction_subtype is not null then
303: DBMS_SQL.bind_variable(l_CursorID , ':transaction_subtype' , transaction_subtype);
304: end if;
305: if party_id is not null then
306: DBMS_SQL.bind_variable(l_CursorID , ':party_id' , party_id);
307: end if;

Line 306: DBMS_SQL.bind_variable(l_CursorID , ':party_id' , party_id);

302: if transaction_subtype is not null then
303: DBMS_SQL.bind_variable(l_CursorID , ':transaction_subtype' , transaction_subtype);
304: end if;
305: if party_id is not null then
306: DBMS_SQL.bind_variable(l_CursorID , ':party_id' , party_id);
307: end if;
308: if party_site_id is not null then
309: DBMS_SQL.bind_variable(l_CursorID , ':party_site_id' , party_site_id);
310: end if;

Line 309: DBMS_SQL.bind_variable(l_CursorID , ':party_site_id' , party_site_id);

305: if party_id is not null then
306: DBMS_SQL.bind_variable(l_CursorID , ':party_id' , party_id);
307: end if;
308: if party_site_id is not null then
309: DBMS_SQL.bind_variable(l_CursorID , ':party_site_id' , party_site_id);
310: end if;
311: if fromDate is not null then
312: DBMS_SQL.bind_variable(l_CursorID , ':fromDate' , fromDate);
313: end if;

Line 312: DBMS_SQL.bind_variable(l_CursorID , ':fromDate' , fromDate);

308: if party_site_id is not null then
309: DBMS_SQL.bind_variable(l_CursorID , ':party_site_id' , party_site_id);
310: end if;
311: if fromDate is not null then
312: DBMS_SQL.bind_variable(l_CursorID , ':fromDate' , fromDate);
313: end if;
314: if toDate is not null then
315: DBMS_SQL.bind_variable(l_CursorID , ':toDate' , toDate);
316: end if;

Line 315: DBMS_SQL.bind_variable(l_CursorID , ':toDate' , toDate);

311: if fromDate is not null then
312: DBMS_SQL.bind_variable(l_CursorID , ':fromDate' , fromDate);
313: end if;
314: if toDate is not null then
315: DBMS_SQL.bind_variable(l_CursorID , ':toDate' , toDate);
316: end if;
317:
318: l_result := DBMS_SQL.EXECUTE(l_CursorID);
319:

Line 318: l_result := DBMS_SQL.EXECUTE(l_CursorID);

314: if toDate is not null then
315: DBMS_SQL.bind_variable(l_CursorID , ':toDate' , toDate);
316: end if;
317:
318: l_result := DBMS_SQL.EXECUTE(l_CursorID);
319:
320: loop
321:
322:

Line 323: if dbms_sql.fetch_rows( l_CursorID ) > 0 then

319:
320: loop
321:
322:
323: if dbms_sql.fetch_rows( l_CursorID ) > 0 then
324:
325: DBMS_SQL.column_value_raw(l_CursorID, 1, l_msgId );
326: DBMS_SQL.column_value(l_CursorID, 2, l_item_type );
327: DBMS_SQL.column_value(l_CursorID, 3, l_item_key );

Line 325: DBMS_SQL.column_value_raw(l_CursorID, 1, l_msgId );

321:
322:
323: if dbms_sql.fetch_rows( l_CursorID ) > 0 then
324:
325: DBMS_SQL.column_value_raw(l_CursorID, 1, l_msgId );
326: DBMS_SQL.column_value(l_CursorID, 2, l_item_type );
327: DBMS_SQL.column_value(l_CursorID, 3, l_item_key );
328:
329: v_message_id_tl.extend;

Line 326: DBMS_SQL.column_value(l_CursorID, 2, l_item_type );

322:
323: if dbms_sql.fetch_rows( l_CursorID ) > 0 then
324:
325: DBMS_SQL.column_value_raw(l_CursorID, 1, l_msgId );
326: DBMS_SQL.column_value(l_CursorID, 2, l_item_type );
327: DBMS_SQL.column_value(l_CursorID, 3, l_item_key );
328:
329: v_message_id_tl.extend;
330: v_itemtype_tl.extend;

Line 327: DBMS_SQL.column_value(l_CursorID, 3, l_item_key );

323: if dbms_sql.fetch_rows( l_CursorID ) > 0 then
324:
325: DBMS_SQL.column_value_raw(l_CursorID, 1, l_msgId );
326: DBMS_SQL.column_value(l_CursorID, 2, l_item_type );
327: DBMS_SQL.column_value(l_CursorID, 3, l_item_key );
328:
329: v_message_id_tl.extend;
330: v_itemtype_tl.extend;
331: v_itemkey_tl.extend;

Line 344: DBMS_SQL.close_cursor (l_CursorID);

340: end if;
341: end loop;
342:
343: /* Fix for Bug# 12860076 */
344: DBMS_SQL.close_cursor (l_CursorID);
345:
346: for i IN 1..v_message_id_tl.count loop
347: purgable := true;
348: status := '';

Line 422: IF DBMS_SQL.IS_OPEN(l_CursorID) THEN

418: END IF;
419: exception
420: WHEN others THEN
421: /* Fix for Bug# 12860076 */
422: IF DBMS_SQL.IS_OPEN(l_CursorID) THEN
423: DBMS_SQL.close_cursor (l_CursorID);
424: END IF;
425: if(get_in_error_id%ISOPEN) then
426: close get_in_error_id;

Line 423: DBMS_SQL.close_cursor (l_CursorID);

419: exception
420: WHEN others THEN
421: /* Fix for Bug# 12860076 */
422: IF DBMS_SQL.IS_OPEN(l_CursorID) THEN
423: DBMS_SQL.close_cursor (l_CursorID);
424: END IF;
425: if(get_in_error_id%ISOPEN) then
426: close get_in_error_id;
427: end if;