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

Line 211: l_cursorID := DBMS_SQL.OPEN_CURSOR;

207:
208: l_close_string := l_order_by;
209: l_string := l_query_string1 || l_close_string;
210:
211: l_cursorID := DBMS_SQL.OPEN_CURSOR;
212: DBMS_SQL.PARSE(l_cursorID, l_string, DBMS_SQL.native);
213:
214: if (p_classification_id <> -1) then
215: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':classification_id', p_classification_id);

Line 212: DBMS_SQL.PARSE(l_cursorID, l_string, DBMS_SQL.native);

208: l_close_string := l_order_by;
209: l_string := l_query_string1 || l_close_string;
210:
211: l_cursorID := DBMS_SQL.OPEN_CURSOR;
212: DBMS_SQL.PARSE(l_cursorID, l_string, DBMS_SQL.native);
213:
214: if (p_classification_id <> -1) then
215: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':classification_id', p_classification_id);
216: end if;

Line 215: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':classification_id', p_classification_id);

211: l_cursorID := DBMS_SQL.OPEN_CURSOR;
212: DBMS_SQL.PARSE(l_cursorID, l_string, DBMS_SQL.native);
213:
214: if (p_classification_id <> -1) then
215: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':classification_id', p_classification_id);
216: end if;
217: if (p_subject is not null) then
218: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':subject', p_subject);
219: end if;

Line 218: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':subject', p_subject);

214: if (p_classification_id <> -1) then
215: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':classification_id', p_classification_id);
216: end if;
217: if (p_subject is not null) then
218: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':subject', p_subject);
219: end if;
220: if (p_sender_name is not null) then
221: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':sender_name', p_sender_name);
222: end if;

Line 221: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':sender_name', p_sender_name);

217: if (p_subject is not null) then
218: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':subject', p_subject);
219: end if;
220: if (p_sender_name is not null) then
221: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':sender_name', p_sender_name);
222: end if;
223: if (p_sent_date_to is not null) then
224: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':received_date_to', p_sent_date_to);
225: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':received_date_format', p_sent_date_format);

Line 224: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':received_date_to', p_sent_date_to);

220: if (p_sender_name is not null) then
221: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':sender_name', p_sender_name);
222: end if;
223: if (p_sent_date_to is not null) then
224: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':received_date_to', p_sent_date_to);
225: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':received_date_format', p_sent_date_format);
226: end if;
227: if (p_sent_date_from is not null) then
228: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':received_date_from', p_sent_date_from);

Line 225: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':received_date_format', p_sent_date_format);

221: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':sender_name', p_sender_name);
222: end if;
223: if (p_sent_date_to is not null) then
224: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':received_date_to', p_sent_date_to);
225: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':received_date_format', p_sent_date_format);
226: end if;
227: if (p_sent_date_from is not null) then
228: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':received_date_from', p_sent_date_from);
229: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':received_date_format', p_sent_date_format);

Line 228: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':received_date_from', p_sent_date_from);

224: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':received_date_to', p_sent_date_to);
225: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':received_date_format', p_sent_date_format);
226: end if;
227: if (p_sent_date_from is not null) then
228: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':received_date_from', p_sent_date_from);
229: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':received_date_format', p_sent_date_format);
230: end if;
231: if (p_customer_name is not null) then
232: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':customer_name', p_customer_name);

Line 229: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':received_date_format', p_sent_date_format);

225: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':received_date_format', p_sent_date_format);
226: end if;
227: if (p_sent_date_from is not null) then
228: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':received_date_from', p_sent_date_from);
229: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':received_date_format', p_sent_date_format);
230: end if;
231: if (p_customer_name is not null) then
232: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':customer_name', p_customer_name);
233: end if;

Line 232: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':customer_name', p_customer_name);

228: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':received_date_from', p_sent_date_from);
229: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':received_date_format', p_sent_date_format);
230: end if;
231: if (p_customer_name is not null) then
232: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':customer_name', p_customer_name);
233: end if;
234: if (p_group_id <> -1 and p_group_id <> 0) then
235: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':group_id', p_group_id);
236: else

Line 235: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':group_id', p_group_id);

231: if (p_customer_name is not null) then
232: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':customer_name', p_customer_name);
233: end if;
234: if (p_group_id <> -1 and p_group_id <> 0) then
235: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':group_id', p_group_id);
236: else
237: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':all_groups', l_all_groups);
238: end if;
239:

Line 237: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':all_groups', l_all_groups);

233: end if;
234: if (p_group_id <> -1 and p_group_id <> 0) then
235: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':group_id', p_group_id);
236: else
237: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':all_groups', l_all_groups);
238: end if;
239:
240: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':email_account_id', p_email_account_id);
241:

Line 240: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':email_account_id', p_email_account_id);

236: else
237: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':all_groups', l_all_groups);
238: end if;
239:
240: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':email_account_id', p_email_account_id);
241:
242: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 1, l_message_id);
243: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 2, l_email_account_id);
244: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 3, l_sender_name, 256);

Line 242: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 1, l_message_id);

238: end if;
239:
240: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':email_account_id', p_email_account_id);
241:
242: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 1, l_message_id);
243: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 2, l_email_account_id);
244: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 3, l_sender_name, 256);
245: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 4, l_subject, 2000);
246: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 5, l_classification_name, 30);

Line 243: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 2, l_email_account_id);

239:
240: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':email_account_id', p_email_account_id);
241:
242: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 1, l_message_id);
243: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 2, l_email_account_id);
244: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 3, l_sender_name, 256);
245: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 4, l_subject, 2000);
246: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 5, l_classification_name, 30);
247: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 6, l_customer_name, 360);

Line 244: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 3, l_sender_name, 256);

240: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':email_account_id', p_email_account_id);
241:
242: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 1, l_message_id);
243: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 2, l_email_account_id);
244: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 3, l_sender_name, 256);
245: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 4, l_subject, 2000);
246: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 5, l_classification_name, 30);
247: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 6, l_customer_name, 360);
248: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 7, l_received_date, 500);

Line 245: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 4, l_subject, 2000);

241:
242: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 1, l_message_id);
243: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 2, l_email_account_id);
244: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 3, l_sender_name, 256);
245: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 4, l_subject, 2000);
246: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 5, l_classification_name, 30);
247: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 6, l_customer_name, 360);
248: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 7, l_received_date, 500);
249: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 8, l_real_received_date);

Line 246: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 5, l_classification_name, 30);

242: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 1, l_message_id);
243: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 2, l_email_account_id);
244: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 3, l_sender_name, 256);
245: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 4, l_subject, 2000);
246: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 5, l_classification_name, 30);
247: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 6, l_customer_name, 360);
248: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 7, l_received_date, 500);
249: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 8, l_real_received_date);
250: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 9, l_message_uid);

Line 247: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 6, l_customer_name, 360);

243: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 2, l_email_account_id);
244: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 3, l_sender_name, 256);
245: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 4, l_subject, 2000);
246: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 5, l_classification_name, 30);
247: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 6, l_customer_name, 360);
248: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 7, l_received_date, 500);
249: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 8, l_real_received_date);
250: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 9, l_message_uid);
251: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 10, l_group_name, 60);

Line 248: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 7, l_received_date, 500);

244: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 3, l_sender_name, 256);
245: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 4, l_subject, 2000);
246: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 5, l_classification_name, 30);
247: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 6, l_customer_name, 360);
248: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 7, l_received_date, 500);
249: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 8, l_real_received_date);
250: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 9, l_message_uid);
251: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 10, l_group_name, 60);
252:

Line 249: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 8, l_real_received_date);

245: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 4, l_subject, 2000);
246: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 5, l_classification_name, 30);
247: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 6, l_customer_name, 360);
248: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 7, l_received_date, 500);
249: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 8, l_real_received_date);
250: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 9, l_message_uid);
251: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 10, l_group_name, 60);
252:
253: l_dummy := DBMS_SQL.EXECUTE(l_cursorID);

Line 250: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 9, l_message_uid);

246: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 5, l_classification_name, 30);
247: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 6, l_customer_name, 360);
248: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 7, l_received_date, 500);
249: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 8, l_real_received_date);
250: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 9, l_message_uid);
251: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 10, l_group_name, 60);
252:
253: l_dummy := DBMS_SQL.EXECUTE(l_cursorID);
254:

Line 251: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 10, l_group_name, 60);

247: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 6, l_customer_name, 360);
248: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 7, l_received_date, 500);
249: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 8, l_real_received_date);
250: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 9, l_message_uid);
251: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 10, l_group_name, 60);
252:
253: l_dummy := DBMS_SQL.EXECUTE(l_cursorID);
254:
255:

Line 253: l_dummy := DBMS_SQL.EXECUTE(l_cursorID);

249: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 8, l_real_received_date);
250: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 9, l_message_uid);
251: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 10, l_group_name, 60);
252:
253: l_dummy := DBMS_SQL.EXECUTE(l_cursorID);
254:
255:
256: LOOP
257: -- IF (DBMS_SQL.FETCH_ROWS(l_cursorID) = 0 or l_index >500) THEN

Line 257: -- IF (DBMS_SQL.FETCH_ROWS(l_cursorID) = 0 or l_index >500) THEN

253: l_dummy := DBMS_SQL.EXECUTE(l_cursorID);
254:
255:
256: LOOP
257: -- IF (DBMS_SQL.FETCH_ROWS(l_cursorID) = 0 or l_index >500) THEN
258: IF (DBMS_SQL.FETCH_ROWS(l_cursorID) = 0) THEN
259: EXIT;
260: END IF;
261:

Line 258: IF (DBMS_SQL.FETCH_ROWS(l_cursorID) = 0) THEN

254:
255:
256: LOOP
257: -- IF (DBMS_SQL.FETCH_ROWS(l_cursorID) = 0 or l_index >500) THEN
258: IF (DBMS_SQL.FETCH_ROWS(l_cursorID) = 0) THEN
259: EXIT;
260: END IF;
261:
262: DBMS_SQL.COLUMN_VALUE(l_cursorID, 1, l_message_id);

Line 262: DBMS_SQL.COLUMN_VALUE(l_cursorID, 1, l_message_id);

258: IF (DBMS_SQL.FETCH_ROWS(l_cursorID) = 0) THEN
259: EXIT;
260: END IF;
261:
262: DBMS_SQL.COLUMN_VALUE(l_cursorID, 1, l_message_id);
263: DBMS_SQL.COLUMN_VALUE(l_cursorID, 2, l_email_account_id);
264: DBMS_SQL.COLUMN_VALUE(l_cursorID, 3, l_sender_name);
265: DBMS_SQL.COLUMN_VALUE(l_cursorID, 4, l_subject);
266: DBMS_SQL.COLUMN_VALUE(l_cursorID, 5, l_classification_name);

Line 263: DBMS_SQL.COLUMN_VALUE(l_cursorID, 2, l_email_account_id);

259: EXIT;
260: END IF;
261:
262: DBMS_SQL.COLUMN_VALUE(l_cursorID, 1, l_message_id);
263: DBMS_SQL.COLUMN_VALUE(l_cursorID, 2, l_email_account_id);
264: DBMS_SQL.COLUMN_VALUE(l_cursorID, 3, l_sender_name);
265: DBMS_SQL.COLUMN_VALUE(l_cursorID, 4, l_subject);
266: DBMS_SQL.COLUMN_VALUE(l_cursorID, 5, l_classification_name);
267: DBMS_SQL.COLUMN_VALUE(l_cursorID, 6, l_customer_name);

Line 264: DBMS_SQL.COLUMN_VALUE(l_cursorID, 3, l_sender_name);

260: END IF;
261:
262: DBMS_SQL.COLUMN_VALUE(l_cursorID, 1, l_message_id);
263: DBMS_SQL.COLUMN_VALUE(l_cursorID, 2, l_email_account_id);
264: DBMS_SQL.COLUMN_VALUE(l_cursorID, 3, l_sender_name);
265: DBMS_SQL.COLUMN_VALUE(l_cursorID, 4, l_subject);
266: DBMS_SQL.COLUMN_VALUE(l_cursorID, 5, l_classification_name);
267: DBMS_SQL.COLUMN_VALUE(l_cursorID, 6, l_customer_name);
268: DBMS_SQL.COLUMN_VALUE(l_cursorID, 7, l_received_date);

Line 265: DBMS_SQL.COLUMN_VALUE(l_cursorID, 4, l_subject);

261:
262: DBMS_SQL.COLUMN_VALUE(l_cursorID, 1, l_message_id);
263: DBMS_SQL.COLUMN_VALUE(l_cursorID, 2, l_email_account_id);
264: DBMS_SQL.COLUMN_VALUE(l_cursorID, 3, l_sender_name);
265: DBMS_SQL.COLUMN_VALUE(l_cursorID, 4, l_subject);
266: DBMS_SQL.COLUMN_VALUE(l_cursorID, 5, l_classification_name);
267: DBMS_SQL.COLUMN_VALUE(l_cursorID, 6, l_customer_name);
268: DBMS_SQL.COLUMN_VALUE(l_cursorID, 7, l_received_date);
269: DBMS_SQL.COLUMN_VALUE(l_cursorID, 8, l_real_received_date);

Line 266: DBMS_SQL.COLUMN_VALUE(l_cursorID, 5, l_classification_name);

262: DBMS_SQL.COLUMN_VALUE(l_cursorID, 1, l_message_id);
263: DBMS_SQL.COLUMN_VALUE(l_cursorID, 2, l_email_account_id);
264: DBMS_SQL.COLUMN_VALUE(l_cursorID, 3, l_sender_name);
265: DBMS_SQL.COLUMN_VALUE(l_cursorID, 4, l_subject);
266: DBMS_SQL.COLUMN_VALUE(l_cursorID, 5, l_classification_name);
267: DBMS_SQL.COLUMN_VALUE(l_cursorID, 6, l_customer_name);
268: DBMS_SQL.COLUMN_VALUE(l_cursorID, 7, l_received_date);
269: DBMS_SQL.COLUMN_VALUE(l_cursorID, 8, l_real_received_date);
270: DBMS_SQL.COLUMN_VALUE(l_cursorID, 9, l_message_uid);

Line 267: DBMS_SQL.COLUMN_VALUE(l_cursorID, 6, l_customer_name);

263: DBMS_SQL.COLUMN_VALUE(l_cursorID, 2, l_email_account_id);
264: DBMS_SQL.COLUMN_VALUE(l_cursorID, 3, l_sender_name);
265: DBMS_SQL.COLUMN_VALUE(l_cursorID, 4, l_subject);
266: DBMS_SQL.COLUMN_VALUE(l_cursorID, 5, l_classification_name);
267: DBMS_SQL.COLUMN_VALUE(l_cursorID, 6, l_customer_name);
268: DBMS_SQL.COLUMN_VALUE(l_cursorID, 7, l_received_date);
269: DBMS_SQL.COLUMN_VALUE(l_cursorID, 8, l_real_received_date);
270: DBMS_SQL.COLUMN_VALUE(l_cursorID, 9, l_message_uid);
271: DBMS_SQL.COLUMN_VALUE(l_cursorID, 10, l_group_name);

Line 268: DBMS_SQL.COLUMN_VALUE(l_cursorID, 7, l_received_date);

264: DBMS_SQL.COLUMN_VALUE(l_cursorID, 3, l_sender_name);
265: DBMS_SQL.COLUMN_VALUE(l_cursorID, 4, l_subject);
266: DBMS_SQL.COLUMN_VALUE(l_cursorID, 5, l_classification_name);
267: DBMS_SQL.COLUMN_VALUE(l_cursorID, 6, l_customer_name);
268: DBMS_SQL.COLUMN_VALUE(l_cursorID, 7, l_received_date);
269: DBMS_SQL.COLUMN_VALUE(l_cursorID, 8, l_real_received_date);
270: DBMS_SQL.COLUMN_VALUE(l_cursorID, 9, l_message_uid);
271: DBMS_SQL.COLUMN_VALUE(l_cursorID, 10, l_group_name);
272:

Line 269: DBMS_SQL.COLUMN_VALUE(l_cursorID, 8, l_real_received_date);

265: DBMS_SQL.COLUMN_VALUE(l_cursorID, 4, l_subject);
266: DBMS_SQL.COLUMN_VALUE(l_cursorID, 5, l_classification_name);
267: DBMS_SQL.COLUMN_VALUE(l_cursorID, 6, l_customer_name);
268: DBMS_SQL.COLUMN_VALUE(l_cursorID, 7, l_received_date);
269: DBMS_SQL.COLUMN_VALUE(l_cursorID, 8, l_real_received_date);
270: DBMS_SQL.COLUMN_VALUE(l_cursorID, 9, l_message_uid);
271: DBMS_SQL.COLUMN_VALUE(l_cursorID, 10, l_group_name);
272:
273: x_message_tbl(l_index).message_id := l_message_id;

Line 270: DBMS_SQL.COLUMN_VALUE(l_cursorID, 9, l_message_uid);

266: DBMS_SQL.COLUMN_VALUE(l_cursorID, 5, l_classification_name);
267: DBMS_SQL.COLUMN_VALUE(l_cursorID, 6, l_customer_name);
268: DBMS_SQL.COLUMN_VALUE(l_cursorID, 7, l_received_date);
269: DBMS_SQL.COLUMN_VALUE(l_cursorID, 8, l_real_received_date);
270: DBMS_SQL.COLUMN_VALUE(l_cursorID, 9, l_message_uid);
271: DBMS_SQL.COLUMN_VALUE(l_cursorID, 10, l_group_name);
272:
273: x_message_tbl(l_index).message_id := l_message_id;
274: x_message_tbl(l_index).email_account_id := l_email_account_id;

Line 271: DBMS_SQL.COLUMN_VALUE(l_cursorID, 10, l_group_name);

267: DBMS_SQL.COLUMN_VALUE(l_cursorID, 6, l_customer_name);
268: DBMS_SQL.COLUMN_VALUE(l_cursorID, 7, l_received_date);
269: DBMS_SQL.COLUMN_VALUE(l_cursorID, 8, l_real_received_date);
270: DBMS_SQL.COLUMN_VALUE(l_cursorID, 9, l_message_uid);
271: DBMS_SQL.COLUMN_VALUE(l_cursorID, 10, l_group_name);
272:
273: x_message_tbl(l_index).message_id := l_message_id;
274: x_message_tbl(l_index).email_account_id := l_email_account_id;
275: x_message_tbl(l_index).sender_name := l_sender_name;

Line 301: DBMS_SQL.CLOSE_CURSOR(l_cursorID);

297:
298:
299: END LOOP;
300:
301: DBMS_SQL.CLOSE_CURSOR(l_cursorID);
302:
303: -- Standard Check Of p_commit.
304: IF FND_API.To_Boolean(p_commit) THEN
305: COMMIT WORK;

Line 470: l_cursorID := DBMS_SQL.OPEN_CURSOR;

466: end if;
467:
468: l_string := l_query_string1;
469:
470: l_cursorID := DBMS_SQL.OPEN_CURSOR;
471: DBMS_SQL.PARSE(l_cursorID, l_string, DBMS_SQL.native);
472:
473: if (p_classification_id <> -1) then
474: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':classification_id', p_classification_id);

Line 471: DBMS_SQL.PARSE(l_cursorID, l_string, DBMS_SQL.native);

467:
468: l_string := l_query_string1;
469:
470: l_cursorID := DBMS_SQL.OPEN_CURSOR;
471: DBMS_SQL.PARSE(l_cursorID, l_string, DBMS_SQL.native);
472:
473: if (p_classification_id <> -1) then
474: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':classification_id', p_classification_id);
475: end if;

Line 474: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':classification_id', p_classification_id);

470: l_cursorID := DBMS_SQL.OPEN_CURSOR;
471: DBMS_SQL.PARSE(l_cursorID, l_string, DBMS_SQL.native);
472:
473: if (p_classification_id <> -1) then
474: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':classification_id', p_classification_id);
475: end if;
476: if (p_subject is not null) then
477: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':subject', p_subject);
478: end if;

Line 477: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':subject', p_subject);

473: if (p_classification_id <> -1) then
474: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':classification_id', p_classification_id);
475: end if;
476: if (p_subject is not null) then
477: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':subject', p_subject);
478: end if;
479: if (p_sender_name is not null) then
480: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':sender_name', p_sender_name);
481: end if;

Line 480: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':sender_name', p_sender_name);

476: if (p_subject is not null) then
477: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':subject', p_subject);
478: end if;
479: if (p_sender_name is not null) then
480: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':sender_name', p_sender_name);
481: end if;
482: if (p_sent_date_to is not null) then
483: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':received_date_to', p_sent_date_to);
484: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':received_date_format', p_sent_date_format);

Line 483: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':received_date_to', p_sent_date_to);

479: if (p_sender_name is not null) then
480: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':sender_name', p_sender_name);
481: end if;
482: if (p_sent_date_to is not null) then
483: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':received_date_to', p_sent_date_to);
484: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':received_date_format', p_sent_date_format);
485: end if;
486: if (p_sent_date_from is not null) then
487: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':received_date_from', p_sent_date_from);

Line 484: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':received_date_format', p_sent_date_format);

480: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':sender_name', p_sender_name);
481: end if;
482: if (p_sent_date_to is not null) then
483: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':received_date_to', p_sent_date_to);
484: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':received_date_format', p_sent_date_format);
485: end if;
486: if (p_sent_date_from is not null) then
487: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':received_date_from', p_sent_date_from);
488: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':received_date_format', p_sent_date_format);

Line 487: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':received_date_from', p_sent_date_from);

483: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':received_date_to', p_sent_date_to);
484: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':received_date_format', p_sent_date_format);
485: end if;
486: if (p_sent_date_from is not null) then
487: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':received_date_from', p_sent_date_from);
488: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':received_date_format', p_sent_date_format);
489: end if;
490: if (p_customer_name is not null) then
491: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':customer_name', p_customer_name);

Line 488: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':received_date_format', p_sent_date_format);

484: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':received_date_format', p_sent_date_format);
485: end if;
486: if (p_sent_date_from is not null) then
487: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':received_date_from', p_sent_date_from);
488: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':received_date_format', p_sent_date_format);
489: end if;
490: if (p_customer_name is not null) then
491: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':customer_name', p_customer_name);
492: end if;

Line 491: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':customer_name', p_customer_name);

487: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':received_date_from', p_sent_date_from);
488: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':received_date_format', p_sent_date_format);
489: end if;
490: if (p_customer_name is not null) then
491: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':customer_name', p_customer_name);
492: end if;
493: if (p_group_id <> -1) then
494: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':group_id', p_group_id);
495: end if;

Line 494: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':group_id', p_group_id);

490: if (p_customer_name is not null) then
491: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':customer_name', p_customer_name);
492: end if;
493: if (p_group_id <> -1) then
494: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':group_id', p_group_id);
495: end if;
496:
497: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':email_account_id', p_email_account_id);
498:

Line 497: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':email_account_id', p_email_account_id);

493: if (p_group_id <> -1) then
494: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':group_id', p_group_id);
495: end if;
496:
497: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':email_account_id', p_email_account_id);
498:
499: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 1, l_message_count);
500:
501: l_dummy := DBMS_SQL.EXECUTE(l_cursorID);

Line 499: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 1, l_message_count);

495: end if;
496:
497: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':email_account_id', p_email_account_id);
498:
499: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 1, l_message_count);
500:
501: l_dummy := DBMS_SQL.EXECUTE(l_cursorID);
502:
503: IF DBMS_SQL.FETCH_ROWS(l_cursorID) <> 0 THEN

Line 501: l_dummy := DBMS_SQL.EXECUTE(l_cursorID);

497: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':email_account_id', p_email_account_id);
498:
499: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 1, l_message_count);
500:
501: l_dummy := DBMS_SQL.EXECUTE(l_cursorID);
502:
503: IF DBMS_SQL.FETCH_ROWS(l_cursorID) <> 0 THEN
504: DBMS_SQL.COLUMN_VALUE(l_cursorID, 1, l_message_count);
505: x_message_count := l_message_count;

Line 503: IF DBMS_SQL.FETCH_ROWS(l_cursorID) <> 0 THEN

499: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 1, l_message_count);
500:
501: l_dummy := DBMS_SQL.EXECUTE(l_cursorID);
502:
503: IF DBMS_SQL.FETCH_ROWS(l_cursorID) <> 0 THEN
504: DBMS_SQL.COLUMN_VALUE(l_cursorID, 1, l_message_count);
505: x_message_count := l_message_count;
506: END IF;
507:

Line 504: DBMS_SQL.COLUMN_VALUE(l_cursorID, 1, l_message_count);

500:
501: l_dummy := DBMS_SQL.EXECUTE(l_cursorID);
502:
503: IF DBMS_SQL.FETCH_ROWS(l_cursorID) <> 0 THEN
504: DBMS_SQL.COLUMN_VALUE(l_cursorID, 1, l_message_count);
505: x_message_count := l_message_count;
506: END IF;
507:
508:

Line 509: DBMS_SQL.CLOSE_CURSOR(l_cursorID);

505: x_message_count := l_message_count;
506: END IF;
507:
508:
509: DBMS_SQL.CLOSE_CURSOR(l_cursorID);
510: -- Standard Check Of p_commit.
511: IF FND_API.To_Boolean(p_commit) THEN
512: COMMIT WORK;
513: END IF;

Line 613: l_cursorID := DBMS_SQL.OPEN_CURSOR;

609: else
610: l_sort_order := 'asc';
611: end if;
612:
613: l_cursorID := DBMS_SQL.OPEN_CURSOR;
614:
615: if (p_sort_column = 2) then
616:
617: l_string := 'select resource_id, resource_name, last_login_time, real_last_login_time from (

Line 670: DBMS_SQL.PARSE(l_cursorID, l_string, DBMS_SQL.native);

666: a.resource_id=b.resource_id and a.email_account_id =:email_account_id ) ) order by real_last_login_time ';
667:
668: l_string := l_string || l_string2 || l_sort_order;
669:
670: DBMS_SQL.PARSE(l_cursorID, l_string, DBMS_SQL.native);
671:
672: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':email_account_id', p_email_account_id);
673:
674: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 1, l_resource_id);

Line 672: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':email_account_id', p_email_account_id);

668: l_string := l_string || l_string2 || l_sort_order;
669:
670: DBMS_SQL.PARSE(l_cursorID, l_string, DBMS_SQL.native);
671:
672: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':email_account_id', p_email_account_id);
673:
674: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 1, l_resource_id);
675: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 2, l_resource_name, 722);
676: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 3, l_last_login_time, 128);

Line 674: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 1, l_resource_id);

670: DBMS_SQL.PARSE(l_cursorID, l_string, DBMS_SQL.native);
671:
672: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':email_account_id', p_email_account_id);
673:
674: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 1, l_resource_id);
675: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 2, l_resource_name, 722);
676: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 3, l_last_login_time, 128);
677: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 4, l_real_last_login_time);
678:

Line 675: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 2, l_resource_name, 722);

671:
672: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':email_account_id', p_email_account_id);
673:
674: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 1, l_resource_id);
675: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 2, l_resource_name, 722);
676: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 3, l_last_login_time, 128);
677: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 4, l_real_last_login_time);
678:
679: l_dummy := DBMS_SQL.EXECUTE(l_cursorID);

Line 676: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 3, l_last_login_time, 128);

672: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':email_account_id', p_email_account_id);
673:
674: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 1, l_resource_id);
675: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 2, l_resource_name, 722);
676: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 3, l_last_login_time, 128);
677: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 4, l_real_last_login_time);
678:
679: l_dummy := DBMS_SQL.EXECUTE(l_cursorID);
680:

Line 677: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 4, l_real_last_login_time);

673:
674: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 1, l_resource_id);
675: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 2, l_resource_name, 722);
676: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 3, l_last_login_time, 128);
677: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 4, l_real_last_login_time);
678:
679: l_dummy := DBMS_SQL.EXECUTE(l_cursorID);
680:
681: LOOP

Line 679: l_dummy := DBMS_SQL.EXECUTE(l_cursorID);

675: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 2, l_resource_name, 722);
676: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 3, l_last_login_time, 128);
677: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 4, l_real_last_login_time);
678:
679: l_dummy := DBMS_SQL.EXECUTE(l_cursorID);
680:
681: LOOP
682: IF (DBMS_SQL.FETCH_ROWS(l_cursorID) = 0) THEN
683: EXIT;

Line 682: IF (DBMS_SQL.FETCH_ROWS(l_cursorID) = 0) THEN

678:
679: l_dummy := DBMS_SQL.EXECUTE(l_cursorID);
680:
681: LOOP
682: IF (DBMS_SQL.FETCH_ROWS(l_cursorID) = 0) THEN
683: EXIT;
684: END IF;
685:
686: DBMS_SQL.COLUMN_VALUE(l_cursorID, 1, l_resource_id);

Line 686: DBMS_SQL.COLUMN_VALUE(l_cursorID, 1, l_resource_id);

682: IF (DBMS_SQL.FETCH_ROWS(l_cursorID) = 0) THEN
683: EXIT;
684: END IF;
685:
686: DBMS_SQL.COLUMN_VALUE(l_cursorID, 1, l_resource_id);
687: DBMS_SQL.COLUMN_VALUE(l_cursorID, 2, l_resource_name);
688: DBMS_SQL.COLUMN_VALUE(l_cursorID, 3, l_last_login_time);
689: DBMS_SQL.COLUMN_VALUE(l_cursorID, 4, l_real_last_login_time);
690:

Line 687: DBMS_SQL.COLUMN_VALUE(l_cursorID, 2, l_resource_name);

683: EXIT;
684: END IF;
685:
686: DBMS_SQL.COLUMN_VALUE(l_cursorID, 1, l_resource_id);
687: DBMS_SQL.COLUMN_VALUE(l_cursorID, 2, l_resource_name);
688: DBMS_SQL.COLUMN_VALUE(l_cursorID, 3, l_last_login_time);
689: DBMS_SQL.COLUMN_VALUE(l_cursorID, 4, l_real_last_login_time);
690:
691: select count(*) into l_fetched_emails from iem_rt_proc_emails a

Line 688: DBMS_SQL.COLUMN_VALUE(l_cursorID, 3, l_last_login_time);

684: END IF;
685:
686: DBMS_SQL.COLUMN_VALUE(l_cursorID, 1, l_resource_id);
687: DBMS_SQL.COLUMN_VALUE(l_cursorID, 2, l_resource_name);
688: DBMS_SQL.COLUMN_VALUE(l_cursorID, 3, l_last_login_time);
689: DBMS_SQL.COLUMN_VALUE(l_cursorID, 4, l_real_last_login_time);
690:
691: select count(*) into l_fetched_emails from iem_rt_proc_emails a
692: where a.email_account_id=p_email_account_id and a.queue_status is null and a.resource_id = l_resource_id;

Line 689: DBMS_SQL.COLUMN_VALUE(l_cursorID, 4, l_real_last_login_time);

685:
686: DBMS_SQL.COLUMN_VALUE(l_cursorID, 1, l_resource_id);
687: DBMS_SQL.COLUMN_VALUE(l_cursorID, 2, l_resource_name);
688: DBMS_SQL.COLUMN_VALUE(l_cursorID, 3, l_last_login_time);
689: DBMS_SQL.COLUMN_VALUE(l_cursorID, 4, l_real_last_login_time);
690:
691: select count(*) into l_fetched_emails from iem_rt_proc_emails a
692: where a.email_account_id=p_email_account_id and a.queue_status is null and a.resource_id = l_resource_id;
693:

Line 769: DBMS_SQL.PARSE(l_cursorID, l_string, DBMS_SQL.native);

765: where pm.email_account_id=:email_account_id and pm.queue_status is null) ) ';
766:
767: l_string := l_string || l_string2 || l_order_by;
768:
769: DBMS_SQL.PARSE(l_cursorID, l_string, DBMS_SQL.native);
770:
771: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':email_account_id', p_email_account_id);
772:
773: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 1, l_resource_id);

Line 771: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':email_account_id', p_email_account_id);

767: l_string := l_string || l_string2 || l_order_by;
768:
769: DBMS_SQL.PARSE(l_cursorID, l_string, DBMS_SQL.native);
770:
771: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':email_account_id', p_email_account_id);
772:
773: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 1, l_resource_id);
774: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 2, l_fetched_emails);
775: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 3, l_resource_name, 722);

Line 773: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 1, l_resource_id);

769: DBMS_SQL.PARSE(l_cursorID, l_string, DBMS_SQL.native);
770:
771: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':email_account_id', p_email_account_id);
772:
773: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 1, l_resource_id);
774: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 2, l_fetched_emails);
775: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 3, l_resource_name, 722);
776:
777: l_dummy := DBMS_SQL.EXECUTE(l_cursorID);

Line 774: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 2, l_fetched_emails);

770:
771: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':email_account_id', p_email_account_id);
772:
773: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 1, l_resource_id);
774: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 2, l_fetched_emails);
775: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 3, l_resource_name, 722);
776:
777: l_dummy := DBMS_SQL.EXECUTE(l_cursorID);
778:

Line 775: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 3, l_resource_name, 722);

771: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':email_account_id', p_email_account_id);
772:
773: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 1, l_resource_id);
774: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 2, l_fetched_emails);
775: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 3, l_resource_name, 722);
776:
777: l_dummy := DBMS_SQL.EXECUTE(l_cursorID);
778:
779: LOOP

Line 777: l_dummy := DBMS_SQL.EXECUTE(l_cursorID);

773: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 1, l_resource_id);
774: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 2, l_fetched_emails);
775: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 3, l_resource_name, 722);
776:
777: l_dummy := DBMS_SQL.EXECUTE(l_cursorID);
778:
779: LOOP
780: IF (DBMS_SQL.FETCH_ROWS(l_cursorID) = 0) THEN
781: EXIT;

Line 780: IF (DBMS_SQL.FETCH_ROWS(l_cursorID) = 0) THEN

776:
777: l_dummy := DBMS_SQL.EXECUTE(l_cursorID);
778:
779: LOOP
780: IF (DBMS_SQL.FETCH_ROWS(l_cursorID) = 0) THEN
781: EXIT;
782: END IF;
783:
784: DBMS_SQL.COLUMN_VALUE(l_cursorID, 1, l_resource_id);

Line 784: DBMS_SQL.COLUMN_VALUE(l_cursorID, 1, l_resource_id);

780: IF (DBMS_SQL.FETCH_ROWS(l_cursorID) = 0) THEN
781: EXIT;
782: END IF;
783:
784: DBMS_SQL.COLUMN_VALUE(l_cursorID, 1, l_resource_id);
785: DBMS_SQL.COLUMN_VALUE(l_cursorID, 2, l_fetched_emails);
786: DBMS_SQL.COLUMN_VALUE(l_cursorID, 3, l_resource_name);
787:
788: select to_char(max(begin_date_time), 'MM/DD/RRRR HH24:MI:SS') into l_last_login_time

Line 785: DBMS_SQL.COLUMN_VALUE(l_cursorID, 2, l_fetched_emails);

781: EXIT;
782: END IF;
783:
784: DBMS_SQL.COLUMN_VALUE(l_cursorID, 1, l_resource_id);
785: DBMS_SQL.COLUMN_VALUE(l_cursorID, 2, l_fetched_emails);
786: DBMS_SQL.COLUMN_VALUE(l_cursorID, 3, l_resource_name);
787:
788: select to_char(max(begin_date_time), 'MM/DD/RRRR HH24:MI:SS') into l_last_login_time
789: from ieu_sh_sessions where application_id=680 and resource_id=l_resource_id;

Line 786: DBMS_SQL.COLUMN_VALUE(l_cursorID, 3, l_resource_name);

782: END IF;
783:
784: DBMS_SQL.COLUMN_VALUE(l_cursorID, 1, l_resource_id);
785: DBMS_SQL.COLUMN_VALUE(l_cursorID, 2, l_fetched_emails);
786: DBMS_SQL.COLUMN_VALUE(l_cursorID, 3, l_resource_name);
787:
788: select to_char(max(begin_date_time), 'MM/DD/RRRR HH24:MI:SS') into l_last_login_time
789: from ieu_sh_sessions where application_id=680 and resource_id=l_resource_id;
790:

Line 801: DBMS_SQL.CLOSE_CURSOR(l_cursorID);

797:
798: END LOOP;
799: end if; -- if p_sort_column=2
800:
801: DBMS_SQL.CLOSE_CURSOR(l_cursorID);
802:
803: -- Standard Check Of p_commit.
804: IF FND_API.To_Boolean(p_commit) THEN
805: COMMIT WORK;

Line 907: l_cursorID := DBMS_SQL.OPEN_CURSOR;

903: if (p_email_account_id is not null) then
904: l_email_account_id := to_char(p_email_account_id);
905: end if;
906:
907: l_cursorID := DBMS_SQL.OPEN_CURSOR;
908:
909: if (p_sort_column = 1) then
910:
911: l_string := 'select group_id, group_name, email_count from(

Line 938: DBMS_SQL.PARSE(l_cursorID, l_string, DBMS_SQL.native);

934: ) order by email_count ';
935:
936: l_string := l_string || l_sort_order;
937:
938: DBMS_SQL.PARSE(l_cursorID, l_string, DBMS_SQL.native);
939:
940: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':email_account_id', p_email_account_id);
941: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':l_email_account_id', l_email_account_id);
942: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':l_email_account_id', l_email_account_id);

Line 940: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':email_account_id', p_email_account_id);

936: l_string := l_string || l_sort_order;
937:
938: DBMS_SQL.PARSE(l_cursorID, l_string, DBMS_SQL.native);
939:
940: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':email_account_id', p_email_account_id);
941: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':l_email_account_id', l_email_account_id);
942: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':l_email_account_id', l_email_account_id);
943: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':email_account_id', p_email_account_id);
944:

Line 941: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':l_email_account_id', l_email_account_id);

937:
938: DBMS_SQL.PARSE(l_cursorID, l_string, DBMS_SQL.native);
939:
940: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':email_account_id', p_email_account_id);
941: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':l_email_account_id', l_email_account_id);
942: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':l_email_account_id', l_email_account_id);
943: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':email_account_id', p_email_account_id);
944:
945: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 1, l_group_id);

Line 942: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':l_email_account_id', l_email_account_id);

938: DBMS_SQL.PARSE(l_cursorID, l_string, DBMS_SQL.native);
939:
940: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':email_account_id', p_email_account_id);
941: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':l_email_account_id', l_email_account_id);
942: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':l_email_account_id', l_email_account_id);
943: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':email_account_id', p_email_account_id);
944:
945: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 1, l_group_id);
946: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 2, l_group_name, 60);

Line 943: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':email_account_id', p_email_account_id);

939:
940: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':email_account_id', p_email_account_id);
941: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':l_email_account_id', l_email_account_id);
942: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':l_email_account_id', l_email_account_id);
943: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':email_account_id', p_email_account_id);
944:
945: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 1, l_group_id);
946: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 2, l_group_name, 60);
947: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 3, l_email_count);

Line 945: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 1, l_group_id);

941: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':l_email_account_id', l_email_account_id);
942: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':l_email_account_id', l_email_account_id);
943: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':email_account_id', p_email_account_id);
944:
945: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 1, l_group_id);
946: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 2, l_group_name, 60);
947: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 3, l_email_count);
948:
949: l_dummy := DBMS_SQL.EXECUTE(l_cursorID);

Line 946: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 2, l_group_name, 60);

942: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':l_email_account_id', l_email_account_id);
943: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':email_account_id', p_email_account_id);
944:
945: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 1, l_group_id);
946: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 2, l_group_name, 60);
947: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 3, l_email_count);
948:
949: l_dummy := DBMS_SQL.EXECUTE(l_cursorID);
950:

Line 947: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 3, l_email_count);

943: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':email_account_id', p_email_account_id);
944:
945: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 1, l_group_id);
946: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 2, l_group_name, 60);
947: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 3, l_email_count);
948:
949: l_dummy := DBMS_SQL.EXECUTE(l_cursorID);
950:
951: LOOP

Line 949: l_dummy := DBMS_SQL.EXECUTE(l_cursorID);

945: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 1, l_group_id);
946: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 2, l_group_name, 60);
947: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 3, l_email_count);
948:
949: l_dummy := DBMS_SQL.EXECUTE(l_cursorID);
950:
951: LOOP
952:
953: IF (DBMS_SQL.FETCH_ROWS(l_cursorID) = 0) THEN

Line 953: IF (DBMS_SQL.FETCH_ROWS(l_cursorID) = 0) THEN

949: l_dummy := DBMS_SQL.EXECUTE(l_cursorID);
950:
951: LOOP
952:
953: IF (DBMS_SQL.FETCH_ROWS(l_cursorID) = 0) THEN
954: EXIT;
955: END IF;
956:
957: DBMS_SQL.COLUMN_VALUE(l_cursorID, 1, l_group_id);

Line 957: DBMS_SQL.COLUMN_VALUE(l_cursorID, 1, l_group_id);

953: IF (DBMS_SQL.FETCH_ROWS(l_cursorID) = 0) THEN
954: EXIT;
955: END IF;
956:
957: DBMS_SQL.COLUMN_VALUE(l_cursorID, 1, l_group_id);
958: DBMS_SQL.COLUMN_VALUE(l_cursorID, 2, l_group_name);
959: DBMS_SQL.COLUMN_VALUE(l_cursorID, 3, l_email_count);
960:
961: -- Start changes for bug no. 7418671

Line 958: DBMS_SQL.COLUMN_VALUE(l_cursorID, 2, l_group_name);

954: EXIT;
955: END IF;
956:
957: DBMS_SQL.COLUMN_VALUE(l_cursorID, 1, l_group_id);
958: DBMS_SQL.COLUMN_VALUE(l_cursorID, 2, l_group_name);
959: DBMS_SQL.COLUMN_VALUE(l_cursorID, 3, l_email_count);
960:
961: -- Start changes for bug no. 7418671
962: --select count(*) into l_agent_count from jtf_rs_roles_tl a, jtf_rs_role_relations b, jtf_rs_group_members c, iem_agents d

Line 959: DBMS_SQL.COLUMN_VALUE(l_cursorID, 3, l_email_count);

955: END IF;
956:
957: DBMS_SQL.COLUMN_VALUE(l_cursorID, 1, l_group_id);
958: DBMS_SQL.COLUMN_VALUE(l_cursorID, 2, l_group_name);
959: DBMS_SQL.COLUMN_VALUE(l_cursorID, 3, l_email_count);
960:
961: -- Start changes for bug no. 7418671
962: --select count(*) into l_agent_count from jtf_rs_roles_tl a, jtf_rs_role_relations b, jtf_rs_group_members c, iem_agents d
963: --where a.role_id in (28, 29, 30) and a.language = USERENV ('LANG') and a.role_id = b.role_id and b.delete_flag = 'N'

Line 1042: DBMS_SQL.PARSE(l_cursorID, l_string, DBMS_SQL.native);

1038:
1039:
1040: l_string := l_string || l_order_by;
1041:
1042: DBMS_SQL.PARSE(l_cursorID, l_string, DBMS_SQL.native);
1043:
1044: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':l_email_account_id', l_email_account_id);
1045:
1046: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 1, l_group_id);

Line 1044: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':l_email_account_id', l_email_account_id);

1040: l_string := l_string || l_order_by;
1041:
1042: DBMS_SQL.PARSE(l_cursorID, l_string, DBMS_SQL.native);
1043:
1044: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':l_email_account_id', l_email_account_id);
1045:
1046: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 1, l_group_id);
1047: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 2, l_group_name, 60);
1048: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 3, l_agent_count);

Line 1046: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 1, l_group_id);

1042: DBMS_SQL.PARSE(l_cursorID, l_string, DBMS_SQL.native);
1043:
1044: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':l_email_account_id', l_email_account_id);
1045:
1046: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 1, l_group_id);
1047: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 2, l_group_name, 60);
1048: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 3, l_agent_count);
1049:
1050: l_dummy := DBMS_SQL.EXECUTE(l_cursorID);

Line 1047: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 2, l_group_name, 60);

1043:
1044: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':l_email_account_id', l_email_account_id);
1045:
1046: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 1, l_group_id);
1047: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 2, l_group_name, 60);
1048: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 3, l_agent_count);
1049:
1050: l_dummy := DBMS_SQL.EXECUTE(l_cursorID);
1051:

Line 1048: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 3, l_agent_count);

1044: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':l_email_account_id', l_email_account_id);
1045:
1046: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 1, l_group_id);
1047: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 2, l_group_name, 60);
1048: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 3, l_agent_count);
1049:
1050: l_dummy := DBMS_SQL.EXECUTE(l_cursorID);
1051:
1052: LOOP

Line 1050: l_dummy := DBMS_SQL.EXECUTE(l_cursorID);

1046: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 1, l_group_id);
1047: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 2, l_group_name, 60);
1048: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 3, l_agent_count);
1049:
1050: l_dummy := DBMS_SQL.EXECUTE(l_cursorID);
1051:
1052: LOOP
1053: IF (DBMS_SQL.FETCH_ROWS(l_cursorID) = 0) THEN
1054: EXIT;

Line 1053: IF (DBMS_SQL.FETCH_ROWS(l_cursorID) = 0) THEN

1049:
1050: l_dummy := DBMS_SQL.EXECUTE(l_cursorID);
1051:
1052: LOOP
1053: IF (DBMS_SQL.FETCH_ROWS(l_cursorID) = 0) THEN
1054: EXIT;
1055: END IF;
1056:
1057: DBMS_SQL.COLUMN_VALUE(l_cursorID, 1, l_group_id);

Line 1057: DBMS_SQL.COLUMN_VALUE(l_cursorID, 1, l_group_id);

1053: IF (DBMS_SQL.FETCH_ROWS(l_cursorID) = 0) THEN
1054: EXIT;
1055: END IF;
1056:
1057: DBMS_SQL.COLUMN_VALUE(l_cursorID, 1, l_group_id);
1058: DBMS_SQL.COLUMN_VALUE(l_cursorID, 2, l_group_name);
1059: DBMS_SQL.COLUMN_VALUE(l_cursorID, 3, l_agent_count);
1060:
1061: select count(*) into l_email_count from iem_rt_proc_emails where resource_id=0

Line 1058: DBMS_SQL.COLUMN_VALUE(l_cursorID, 2, l_group_name);

1054: EXIT;
1055: END IF;
1056:
1057: DBMS_SQL.COLUMN_VALUE(l_cursorID, 1, l_group_id);
1058: DBMS_SQL.COLUMN_VALUE(l_cursorID, 2, l_group_name);
1059: DBMS_SQL.COLUMN_VALUE(l_cursorID, 3, l_agent_count);
1060:
1061: select count(*) into l_email_count from iem_rt_proc_emails where resource_id=0
1062: and email_account_id=p_email_account_id and group_id=l_group_id;

Line 1059: DBMS_SQL.COLUMN_VALUE(l_cursorID, 3, l_agent_count);

1055: END IF;
1056:
1057: DBMS_SQL.COLUMN_VALUE(l_cursorID, 1, l_group_id);
1058: DBMS_SQL.COLUMN_VALUE(l_cursorID, 2, l_group_name);
1059: DBMS_SQL.COLUMN_VALUE(l_cursorID, 3, l_agent_count);
1060:
1061: select count(*) into l_email_count from iem_rt_proc_emails where resource_id=0
1062: and email_account_id=p_email_account_id and group_id=l_group_id;
1063:

Line 1074: DBMS_SQL.CLOSE_CURSOR(l_cursorID);

1070:
1071: END LOOP;
1072: end if; -- if p_sort_column=1
1073:
1074: DBMS_SQL.CLOSE_CURSOR(l_cursorID);
1075:
1076:
1077: -- Standard Check Of p_commit.
1078: IF FND_API.To_Boolean(p_commit) THEN