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 276: l_CursorID := DBMS_SQL.OPEN_CURSOR;

272: end if;
273:
274: l_Select := l_Select || ' for update nowait ';
275:
276: l_CursorID := DBMS_SQL.OPEN_CURSOR;
277: DBMS_SQL.parse(l_CursorID, l_Select, DBMS_SQL.V7);
278:
279: DBMS_SQL.define_column_raw(l_CursorID, 1, l_msgId , 16);
280: DBMS_SQL.define_column(l_CursorID, 2, l_item_type, 8);

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

273:
274: l_Select := l_Select || ' for update nowait ';
275:
276: l_CursorID := DBMS_SQL.OPEN_CURSOR;
277: DBMS_SQL.parse(l_CursorID, l_Select, DBMS_SQL.V7);
278:
279: DBMS_SQL.define_column_raw(l_CursorID, 1, l_msgId , 16);
280: DBMS_SQL.define_column(l_CursorID, 2, l_item_type, 8);
281: DBMS_SQL.define_column(l_CursorID, 3, l_item_key , 240);

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

275:
276: l_CursorID := DBMS_SQL.OPEN_CURSOR;
277: DBMS_SQL.parse(l_CursorID, l_Select, DBMS_SQL.V7);
278:
279: DBMS_SQL.define_column_raw(l_CursorID, 1, l_msgId , 16);
280: DBMS_SQL.define_column(l_CursorID, 2, l_item_type, 8);
281: DBMS_SQL.define_column(l_CursorID, 3, l_item_key , 240);
282:
283: if item_type is not null then

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

276: l_CursorID := DBMS_SQL.OPEN_CURSOR;
277: DBMS_SQL.parse(l_CursorID, l_Select, DBMS_SQL.V7);
278:
279: DBMS_SQL.define_column_raw(l_CursorID, 1, l_msgId , 16);
280: DBMS_SQL.define_column(l_CursorID, 2, l_item_type, 8);
281: DBMS_SQL.define_column(l_CursorID, 3, l_item_key , 240);
282:
283: if item_type is not null then
284: DBMS_SQL.bind_variable(l_CursorID , ':item_type' , item_type);

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

277: DBMS_SQL.parse(l_CursorID, l_Select, DBMS_SQL.V7);
278:
279: DBMS_SQL.define_column_raw(l_CursorID, 1, l_msgId , 16);
280: DBMS_SQL.define_column(l_CursorID, 2, l_item_type, 8);
281: DBMS_SQL.define_column(l_CursorID, 3, l_item_key , 240);
282:
283: if item_type is not null then
284: DBMS_SQL.bind_variable(l_CursorID , ':item_type' , item_type);
285: end if;

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

280: DBMS_SQL.define_column(l_CursorID, 2, l_item_type, 8);
281: DBMS_SQL.define_column(l_CursorID, 3, l_item_key , 240);
282:
283: if item_type is not null then
284: DBMS_SQL.bind_variable(l_CursorID , ':item_type' , item_type);
285: end if;
286: if item_key is not null then
287: DBMS_SQL.bind_variable(l_CursorID , ':item_key' , item_key);
288: end if;

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

283: if item_type is not null then
284: DBMS_SQL.bind_variable(l_CursorID , ':item_type' , item_type);
285: end if;
286: if item_key is not null then
287: DBMS_SQL.bind_variable(l_CursorID , ':item_key' , item_key);
288: end if;
289: if transaction_type is not null then
290: DBMS_SQL.bind_variable(l_CursorID , ':transaction_type' , transaction_type);
291: end if;

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

286: if item_key is not null then
287: DBMS_SQL.bind_variable(l_CursorID , ':item_key' , item_key);
288: end if;
289: if transaction_type is not null then
290: DBMS_SQL.bind_variable(l_CursorID , ':transaction_type' , transaction_type);
291: end if;
292: if transaction_subtype is not null then
293: DBMS_SQL.bind_variable(l_CursorID , ':transaction_subtype' , transaction_subtype);
294: end if;

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

289: if transaction_type is not null then
290: DBMS_SQL.bind_variable(l_CursorID , ':transaction_type' , transaction_type);
291: end if;
292: if transaction_subtype is not null then
293: DBMS_SQL.bind_variable(l_CursorID , ':transaction_subtype' , transaction_subtype);
294: end if;
295: if party_id is not null then
296: DBMS_SQL.bind_variable(l_CursorID , ':party_id' , party_id);
297: end if;

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

292: if transaction_subtype is not null then
293: DBMS_SQL.bind_variable(l_CursorID , ':transaction_subtype' , transaction_subtype);
294: end if;
295: if party_id is not null then
296: DBMS_SQL.bind_variable(l_CursorID , ':party_id' , party_id);
297: end if;
298: if party_site_id is not null then
299: DBMS_SQL.bind_variable(l_CursorID , ':party_site_id' , party_site_id);
300: end if;

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

295: if party_id is not null then
296: DBMS_SQL.bind_variable(l_CursorID , ':party_id' , party_id);
297: end if;
298: if party_site_id is not null then
299: DBMS_SQL.bind_variable(l_CursorID , ':party_site_id' , party_site_id);
300: end if;
301: if fromDate is not null then
302: DBMS_SQL.bind_variable(l_CursorID , ':fromDate' , fromDate);
303: end if;

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

298: if party_site_id is not null then
299: DBMS_SQL.bind_variable(l_CursorID , ':party_site_id' , party_site_id);
300: end if;
301: if fromDate is not null then
302: DBMS_SQL.bind_variable(l_CursorID , ':fromDate' , fromDate);
303: end if;
304: if toDate is not null then
305: DBMS_SQL.bind_variable(l_CursorID , ':toDate' , toDate);
306: end if;

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

301: if fromDate is not null then
302: DBMS_SQL.bind_variable(l_CursorID , ':fromDate' , fromDate);
303: end if;
304: if toDate is not null then
305: DBMS_SQL.bind_variable(l_CursorID , ':toDate' , toDate);
306: end if;
307:
308: l_result := DBMS_SQL.EXECUTE(l_CursorID);
309:

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

304: if toDate is not null then
305: DBMS_SQL.bind_variable(l_CursorID , ':toDate' , toDate);
306: end if;
307:
308: l_result := DBMS_SQL.EXECUTE(l_CursorID);
309:
310: loop
311:
312:

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

309:
310: loop
311:
312:
313: if dbms_sql.fetch_rows( l_CursorID ) > 0 then
314:
315: DBMS_SQL.column_value_raw(l_CursorID, 1, l_msgId );
316: DBMS_SQL.column_value(l_CursorID, 2, l_item_type );
317: DBMS_SQL.column_value(l_CursorID, 3, l_item_key );

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

311:
312:
313: if dbms_sql.fetch_rows( l_CursorID ) > 0 then
314:
315: DBMS_SQL.column_value_raw(l_CursorID, 1, l_msgId );
316: DBMS_SQL.column_value(l_CursorID, 2, l_item_type );
317: DBMS_SQL.column_value(l_CursorID, 3, l_item_key );
318:
319: v_message_id_tl.extend;

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

312:
313: if dbms_sql.fetch_rows( l_CursorID ) > 0 then
314:
315: DBMS_SQL.column_value_raw(l_CursorID, 1, l_msgId );
316: DBMS_SQL.column_value(l_CursorID, 2, l_item_type );
317: DBMS_SQL.column_value(l_CursorID, 3, l_item_key );
318:
319: v_message_id_tl.extend;
320: v_itemtype_tl.extend;

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

313: if dbms_sql.fetch_rows( l_CursorID ) > 0 then
314:
315: DBMS_SQL.column_value_raw(l_CursorID, 1, l_msgId );
316: DBMS_SQL.column_value(l_CursorID, 2, l_item_type );
317: DBMS_SQL.column_value(l_CursorID, 3, l_item_key );
318:
319: v_message_id_tl.extend;
320: v_itemtype_tl.extend;
321: v_itemkey_tl.extend;