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_AGENT_INBOX_MGMT_PVT dependencies on DBMS_SQL

Line 188: l_cursorID := DBMS_SQL.OPEN_CURSOR;

184: end if;
185: l_close_string := l_order_by;
186: l_string := l_query_string1 || l_close_string;
187:
188: l_cursorID := DBMS_SQL.OPEN_CURSOR;
189: DBMS_SQL.PARSE(l_cursorID, l_string, DBMS_SQL.V7);
190:
191: if (p_classification_id <> -1) then
192: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':classification_id', p_classification_id);

Line 189: DBMS_SQL.PARSE(l_cursorID, l_string, DBMS_SQL.V7);

185: l_close_string := l_order_by;
186: l_string := l_query_string1 || l_close_string;
187:
188: l_cursorID := DBMS_SQL.OPEN_CURSOR;
189: DBMS_SQL.PARSE(l_cursorID, l_string, DBMS_SQL.V7);
190:
191: if (p_classification_id <> -1) then
192: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':classification_id', p_classification_id);
193: end if;

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

188: l_cursorID := DBMS_SQL.OPEN_CURSOR;
189: DBMS_SQL.PARSE(l_cursorID, l_string, DBMS_SQL.V7);
190:
191: if (p_classification_id <> -1) then
192: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':classification_id', p_classification_id);
193: end if;
194: if (p_subject is not null) then
195: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':subject', p_subject);
196: end if;

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

191: if (p_classification_id <> -1) then
192: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':classification_id', p_classification_id);
193: end if;
194: if (p_subject is not null) then
195: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':subject', p_subject);
196: end if;
197: if (p_sender_name is not null) then
198: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':sender_name', p_sender_name);
199: end if;

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

194: if (p_subject is not null) then
195: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':subject', p_subject);
196: end if;
197: if (p_sender_name is not null) then
198: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':sender_name', p_sender_name);
199: end if;
200: if (p_resource_name is not null) then
201: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':resource_name', p_resource_name);
202: end if;

Line 201: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':resource_name', p_resource_name);

197: if (p_sender_name is not null) then
198: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':sender_name', p_sender_name);
199: end if;
200: if (p_resource_name is not null) then
201: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':resource_name', p_resource_name);
202: end if;
203: if (p_resource_id <> -1) then
204: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':resource_id', p_resource_id);
205: end if;

Line 204: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':resource_id', p_resource_id);

200: if (p_resource_name is not null) then
201: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':resource_name', p_resource_name);
202: end if;
203: if (p_resource_id <> -1) then
204: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':resource_id', p_resource_id);
205: end if;
206: if (p_sent_date_to is not null) then
207: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':received_date_to', p_sent_date_to);
208: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':received_date_format', p_sent_date_format);

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

203: if (p_resource_id <> -1) then
204: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':resource_id', p_resource_id);
205: end if;
206: if (p_sent_date_to is not null) then
207: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':received_date_to', p_sent_date_to);
208: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':received_date_format', p_sent_date_format);
209: end if;
210: if (p_sent_date_from is not null) then
211: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':received_date_from', p_sent_date_from);

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

204: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':resource_id', p_resource_id);
205: end if;
206: if (p_sent_date_to is not null) then
207: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':received_date_to', p_sent_date_to);
208: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':received_date_format', p_sent_date_format);
209: end if;
210: if (p_sent_date_from is not null) then
211: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':received_date_from', p_sent_date_from);
212: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':received_date_format', p_sent_date_format);

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

207: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':received_date_to', p_sent_date_to);
208: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':received_date_format', p_sent_date_format);
209: end if;
210: if (p_sent_date_from is not null) then
211: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':received_date_from', p_sent_date_from);
212: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':received_date_format', p_sent_date_format);
213: end if;
214: if (p_customer_name is not null) then
215: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':customer_name', p_customer_name);

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

208: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':received_date_format', p_sent_date_format);
209: end if;
210: if (p_sent_date_from is not null) then
211: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':received_date_from', p_sent_date_from);
212: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':received_date_format', p_sent_date_format);
213: end if;
214: if (p_customer_name is not null) then
215: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':customer_name', p_customer_name);
216: end if;

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

211: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':received_date_from', p_sent_date_from);
212: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':received_date_format', p_sent_date_format);
213: end if;
214: if (p_customer_name is not null) then
215: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':customer_name', p_customer_name);
216: end if;
217:
218: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':email_account_id', p_email_account_id);
219:

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

214: if (p_customer_name is not null) then
215: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':customer_name', p_customer_name);
216: end if;
217:
218: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':email_account_id', p_email_account_id);
219:
220: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 1, l_message_id);
221: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 2, l_email_account_id);
222: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 3, l_sender_name, 256);

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

216: end if;
217:
218: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':email_account_id', p_email_account_id);
219:
220: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 1, l_message_id);
221: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 2, l_email_account_id);
222: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 3, l_sender_name, 256);
223: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 4, l_subject, 240);
224: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 5, l_classification_name, 30);

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

217:
218: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':email_account_id', p_email_account_id);
219:
220: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 1, l_message_id);
221: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 2, l_email_account_id);
222: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 3, l_sender_name, 256);
223: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 4, l_subject, 240);
224: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 5, l_classification_name, 30);
225: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 6, l_customer_name, 360);

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

218: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':email_account_id', p_email_account_id);
219:
220: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 1, l_message_id);
221: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 2, l_email_account_id);
222: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 3, l_sender_name, 256);
223: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 4, l_subject, 240);
224: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 5, l_classification_name, 30);
225: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 6, l_customer_name, 360);
226: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 7, l_received_date, 500);

Line 223: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 4, l_subject, 240);

219:
220: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 1, l_message_id);
221: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 2, l_email_account_id);
222: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 3, l_sender_name, 256);
223: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 4, l_subject, 240);
224: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 5, l_classification_name, 30);
225: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 6, l_customer_name, 360);
226: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 7, l_received_date, 500);
227: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 8, l_real_received_date);

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

220: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 1, l_message_id);
221: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 2, l_email_account_id);
222: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 3, l_sender_name, 256);
223: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 4, l_subject, 240);
224: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 5, l_classification_name, 30);
225: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 6, l_customer_name, 360);
226: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 7, l_received_date, 500);
227: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 8, l_real_received_date);
228: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 9, l_message_uid);

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

221: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 2, l_email_account_id);
222: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 3, l_sender_name, 256);
223: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 4, l_subject, 240);
224: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 5, l_classification_name, 30);
225: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 6, l_customer_name, 360);
226: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 7, l_received_date, 500);
227: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 8, l_real_received_date);
228: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 9, l_message_uid);
229: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 10, l_resource_name, 360);

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

222: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 3, l_sender_name, 256);
223: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 4, l_subject, 240);
224: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 5, l_classification_name, 30);
225: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 6, l_customer_name, 360);
226: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 7, l_received_date, 500);
227: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 8, l_real_received_date);
228: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 9, l_message_uid);
229: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 10, l_resource_name, 360);
230: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 11, l_rt_media_item_id);

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

223: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 4, l_subject, 240);
224: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 5, l_classification_name, 30);
225: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 6, l_customer_name, 360);
226: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 7, l_received_date, 500);
227: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 8, l_real_received_date);
228: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 9, l_message_uid);
229: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 10, l_resource_name, 360);
230: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 11, l_rt_media_item_id);
231: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 12, l_agent_id);

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

224: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 5, l_classification_name, 30);
225: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 6, l_customer_name, 360);
226: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 7, l_received_date, 500);
227: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 8, l_real_received_date);
228: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 9, l_message_uid);
229: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 10, l_resource_name, 360);
230: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 11, l_rt_media_item_id);
231: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 12, l_agent_id);
232:

Line 229: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 10, l_resource_name, 360);

225: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 6, l_customer_name, 360);
226: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 7, l_received_date, 500);
227: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 8, l_real_received_date);
228: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 9, l_message_uid);
229: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 10, l_resource_name, 360);
230: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 11, l_rt_media_item_id);
231: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 12, l_agent_id);
232:
233: l_dummy := DBMS_SQL.EXECUTE(l_cursorID);

Line 230: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 11, l_rt_media_item_id);

226: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 7, l_received_date, 500);
227: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 8, l_real_received_date);
228: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 9, l_message_uid);
229: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 10, l_resource_name, 360);
230: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 11, l_rt_media_item_id);
231: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 12, l_agent_id);
232:
233: l_dummy := DBMS_SQL.EXECUTE(l_cursorID);
234:

Line 231: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 12, l_agent_id);

227: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 8, l_real_received_date);
228: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 9, l_message_uid);
229: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 10, l_resource_name, 360);
230: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 11, l_rt_media_item_id);
231: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 12, l_agent_id);
232:
233: l_dummy := DBMS_SQL.EXECUTE(l_cursorID);
234:
235: LOOP

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

229: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 10, l_resource_name, 360);
230: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 11, l_rt_media_item_id);
231: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 12, l_agent_id);
232:
233: l_dummy := DBMS_SQL.EXECUTE(l_cursorID);
234:
235: LOOP
236: IF DBMS_SQL.FETCH_ROWS(l_cursorID) = 0 or l_index > 500 THEN
237: EXIT;

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

232:
233: l_dummy := DBMS_SQL.EXECUTE(l_cursorID);
234:
235: LOOP
236: IF DBMS_SQL.FETCH_ROWS(l_cursorID) = 0 or l_index > 500 THEN
237: EXIT;
238: END IF;
239:
240: DBMS_SQL.COLUMN_VALUE(l_cursorID, 1, l_message_id);

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

236: IF DBMS_SQL.FETCH_ROWS(l_cursorID) = 0 or l_index > 500 THEN
237: EXIT;
238: END IF;
239:
240: DBMS_SQL.COLUMN_VALUE(l_cursorID, 1, l_message_id);
241: DBMS_SQL.COLUMN_VALUE(l_cursorID, 2, l_email_account_id);
242: DBMS_SQL.COLUMN_VALUE(l_cursorID, 3, l_sender_name);
243: DBMS_SQL.COLUMN_VALUE(l_cursorID, 4, l_subject);
244: DBMS_SQL.COLUMN_VALUE(l_cursorID, 5, l_classification_name);

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

237: EXIT;
238: END IF;
239:
240: DBMS_SQL.COLUMN_VALUE(l_cursorID, 1, l_message_id);
241: DBMS_SQL.COLUMN_VALUE(l_cursorID, 2, l_email_account_id);
242: DBMS_SQL.COLUMN_VALUE(l_cursorID, 3, l_sender_name);
243: DBMS_SQL.COLUMN_VALUE(l_cursorID, 4, l_subject);
244: DBMS_SQL.COLUMN_VALUE(l_cursorID, 5, l_classification_name);
245: DBMS_SQL.COLUMN_VALUE(l_cursorID, 6, l_customer_name);

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

238: END IF;
239:
240: DBMS_SQL.COLUMN_VALUE(l_cursorID, 1, l_message_id);
241: DBMS_SQL.COLUMN_VALUE(l_cursorID, 2, l_email_account_id);
242: DBMS_SQL.COLUMN_VALUE(l_cursorID, 3, l_sender_name);
243: DBMS_SQL.COLUMN_VALUE(l_cursorID, 4, l_subject);
244: DBMS_SQL.COLUMN_VALUE(l_cursorID, 5, l_classification_name);
245: DBMS_SQL.COLUMN_VALUE(l_cursorID, 6, l_customer_name);
246: DBMS_SQL.COLUMN_VALUE(l_cursorID, 7, l_received_date);

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

239:
240: DBMS_SQL.COLUMN_VALUE(l_cursorID, 1, l_message_id);
241: DBMS_SQL.COLUMN_VALUE(l_cursorID, 2, l_email_account_id);
242: DBMS_SQL.COLUMN_VALUE(l_cursorID, 3, l_sender_name);
243: DBMS_SQL.COLUMN_VALUE(l_cursorID, 4, l_subject);
244: DBMS_SQL.COLUMN_VALUE(l_cursorID, 5, l_classification_name);
245: DBMS_SQL.COLUMN_VALUE(l_cursorID, 6, l_customer_name);
246: DBMS_SQL.COLUMN_VALUE(l_cursorID, 7, l_received_date);
247: DBMS_SQL.COLUMN_VALUE(l_cursorID, 8, l_real_received_date);

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

240: DBMS_SQL.COLUMN_VALUE(l_cursorID, 1, l_message_id);
241: DBMS_SQL.COLUMN_VALUE(l_cursorID, 2, l_email_account_id);
242: DBMS_SQL.COLUMN_VALUE(l_cursorID, 3, l_sender_name);
243: DBMS_SQL.COLUMN_VALUE(l_cursorID, 4, l_subject);
244: DBMS_SQL.COLUMN_VALUE(l_cursorID, 5, l_classification_name);
245: DBMS_SQL.COLUMN_VALUE(l_cursorID, 6, l_customer_name);
246: DBMS_SQL.COLUMN_VALUE(l_cursorID, 7, l_received_date);
247: DBMS_SQL.COLUMN_VALUE(l_cursorID, 8, l_real_received_date);
248: DBMS_SQL.COLUMN_VALUE(l_cursorID, 9, l_message_uid);

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

241: DBMS_SQL.COLUMN_VALUE(l_cursorID, 2, l_email_account_id);
242: DBMS_SQL.COLUMN_VALUE(l_cursorID, 3, l_sender_name);
243: DBMS_SQL.COLUMN_VALUE(l_cursorID, 4, l_subject);
244: DBMS_SQL.COLUMN_VALUE(l_cursorID, 5, l_classification_name);
245: DBMS_SQL.COLUMN_VALUE(l_cursorID, 6, l_customer_name);
246: DBMS_SQL.COLUMN_VALUE(l_cursorID, 7, l_received_date);
247: DBMS_SQL.COLUMN_VALUE(l_cursorID, 8, l_real_received_date);
248: DBMS_SQL.COLUMN_VALUE(l_cursorID, 9, l_message_uid);
249: DBMS_SQL.COLUMN_VALUE(l_cursorID, 10, l_resource_name);

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

242: DBMS_SQL.COLUMN_VALUE(l_cursorID, 3, l_sender_name);
243: DBMS_SQL.COLUMN_VALUE(l_cursorID, 4, l_subject);
244: DBMS_SQL.COLUMN_VALUE(l_cursorID, 5, l_classification_name);
245: DBMS_SQL.COLUMN_VALUE(l_cursorID, 6, l_customer_name);
246: DBMS_SQL.COLUMN_VALUE(l_cursorID, 7, l_received_date);
247: DBMS_SQL.COLUMN_VALUE(l_cursorID, 8, l_real_received_date);
248: DBMS_SQL.COLUMN_VALUE(l_cursorID, 9, l_message_uid);
249: DBMS_SQL.COLUMN_VALUE(l_cursorID, 10, l_resource_name);
250: DBMS_SQL.COLUMN_VALUE(l_cursorID, 11, l_rt_media_item_id);

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

243: DBMS_SQL.COLUMN_VALUE(l_cursorID, 4, l_subject);
244: DBMS_SQL.COLUMN_VALUE(l_cursorID, 5, l_classification_name);
245: DBMS_SQL.COLUMN_VALUE(l_cursorID, 6, l_customer_name);
246: DBMS_SQL.COLUMN_VALUE(l_cursorID, 7, l_received_date);
247: DBMS_SQL.COLUMN_VALUE(l_cursorID, 8, l_real_received_date);
248: DBMS_SQL.COLUMN_VALUE(l_cursorID, 9, l_message_uid);
249: DBMS_SQL.COLUMN_VALUE(l_cursorID, 10, l_resource_name);
250: DBMS_SQL.COLUMN_VALUE(l_cursorID, 11, l_rt_media_item_id);
251: DBMS_SQL.COLUMN_VALUE(l_cursorID, 12, l_agent_id);

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

244: DBMS_SQL.COLUMN_VALUE(l_cursorID, 5, l_classification_name);
245: DBMS_SQL.COLUMN_VALUE(l_cursorID, 6, l_customer_name);
246: DBMS_SQL.COLUMN_VALUE(l_cursorID, 7, l_received_date);
247: DBMS_SQL.COLUMN_VALUE(l_cursorID, 8, l_real_received_date);
248: DBMS_SQL.COLUMN_VALUE(l_cursorID, 9, l_message_uid);
249: DBMS_SQL.COLUMN_VALUE(l_cursorID, 10, l_resource_name);
250: DBMS_SQL.COLUMN_VALUE(l_cursorID, 11, l_rt_media_item_id);
251: DBMS_SQL.COLUMN_VALUE(l_cursorID, 12, l_agent_id);
252:

Line 249: DBMS_SQL.COLUMN_VALUE(l_cursorID, 10, l_resource_name);

245: DBMS_SQL.COLUMN_VALUE(l_cursorID, 6, l_customer_name);
246: DBMS_SQL.COLUMN_VALUE(l_cursorID, 7, l_received_date);
247: DBMS_SQL.COLUMN_VALUE(l_cursorID, 8, l_real_received_date);
248: DBMS_SQL.COLUMN_VALUE(l_cursorID, 9, l_message_uid);
249: DBMS_SQL.COLUMN_VALUE(l_cursorID, 10, l_resource_name);
250: DBMS_SQL.COLUMN_VALUE(l_cursorID, 11, l_rt_media_item_id);
251: DBMS_SQL.COLUMN_VALUE(l_cursorID, 12, l_agent_id);
252:
253: x_message_tbl(l_index).message_id := l_message_id;

Line 250: DBMS_SQL.COLUMN_VALUE(l_cursorID, 11, l_rt_media_item_id);

246: DBMS_SQL.COLUMN_VALUE(l_cursorID, 7, l_received_date);
247: DBMS_SQL.COLUMN_VALUE(l_cursorID, 8, l_real_received_date);
248: DBMS_SQL.COLUMN_VALUE(l_cursorID, 9, l_message_uid);
249: DBMS_SQL.COLUMN_VALUE(l_cursorID, 10, l_resource_name);
250: DBMS_SQL.COLUMN_VALUE(l_cursorID, 11, l_rt_media_item_id);
251: DBMS_SQL.COLUMN_VALUE(l_cursorID, 12, l_agent_id);
252:
253: x_message_tbl(l_index).message_id := l_message_id;
254: x_message_tbl(l_index).email_account_id := l_email_account_id;

Line 251: DBMS_SQL.COLUMN_VALUE(l_cursorID, 12, l_agent_id);

247: DBMS_SQL.COLUMN_VALUE(l_cursorID, 8, l_real_received_date);
248: DBMS_SQL.COLUMN_VALUE(l_cursorID, 9, l_message_uid);
249: DBMS_SQL.COLUMN_VALUE(l_cursorID, 10, l_resource_name);
250: DBMS_SQL.COLUMN_VALUE(l_cursorID, 11, l_rt_media_item_id);
251: DBMS_SQL.COLUMN_VALUE(l_cursorID, 12, l_agent_id);
252:
253: x_message_tbl(l_index).message_id := l_message_id;
254: x_message_tbl(l_index).email_account_id := l_email_account_id;
255: x_message_tbl(l_index).sender_name := l_sender_name;

Line 283: DBMS_SQL.CLOSE_CURSOR(l_cursorID);

279: l_index := l_index + 1;
280:
281: END LOOP;
282:
283: DBMS_SQL.CLOSE_CURSOR(l_cursorID);
284:
285: -- Standard Check Of p_commit.
286: IF FND_API.To_Boolean(p_commit) THEN
287: COMMIT WORK;

Line 447: l_cursorID := DBMS_SQL.OPEN_CURSOR;

443: end if;
444:
445: l_string := l_query_string1;
446:
447: l_cursorID := DBMS_SQL.OPEN_CURSOR;
448: DBMS_SQL.PARSE(l_cursorID, l_string, DBMS_SQL.V7);
449:
450: if (p_classification_id <> -1) then
451: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':classification_id', p_classification_id);

Line 448: DBMS_SQL.PARSE(l_cursorID, l_string, DBMS_SQL.V7);

444:
445: l_string := l_query_string1;
446:
447: l_cursorID := DBMS_SQL.OPEN_CURSOR;
448: DBMS_SQL.PARSE(l_cursorID, l_string, DBMS_SQL.V7);
449:
450: if (p_classification_id <> -1) then
451: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':classification_id', p_classification_id);
452: end if;

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

447: l_cursorID := DBMS_SQL.OPEN_CURSOR;
448: DBMS_SQL.PARSE(l_cursorID, l_string, DBMS_SQL.V7);
449:
450: if (p_classification_id <> -1) then
451: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':classification_id', p_classification_id);
452: end if;
453: if (p_subject is not null) then
454: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':subject', p_subject);
455: end if;

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

450: if (p_classification_id <> -1) then
451: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':classification_id', p_classification_id);
452: end if;
453: if (p_subject is not null) then
454: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':subject', p_subject);
455: end if;
456: if (p_sender_name is not null) then
457: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':sender_name', p_sender_name);
458: end if;

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

453: if (p_subject is not null) then
454: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':subject', p_subject);
455: end if;
456: if (p_sender_name is not null) then
457: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':sender_name', p_sender_name);
458: end if;
459: if (p_resource_name is not null) then
460: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':resource_name', p_resource_name);
461: end if;

Line 460: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':resource_name', p_resource_name);

456: if (p_sender_name is not null) then
457: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':sender_name', p_sender_name);
458: end if;
459: if (p_resource_name is not null) then
460: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':resource_name', p_resource_name);
461: end if;
462: if (p_resource_id <> -1) then
463: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':resource_id', p_resource_id);
464: end if;

Line 463: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':resource_id', p_resource_id);

459: if (p_resource_name is not null) then
460: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':resource_name', p_resource_name);
461: end if;
462: if (p_resource_id <> -1) then
463: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':resource_id', p_resource_id);
464: end if;
465: if (p_sent_date_to is not null) then
466: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':received_date_to', p_sent_date_to);
467: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':received_date_format', p_sent_date_format);

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

462: if (p_resource_id <> -1) then
463: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':resource_id', p_resource_id);
464: end if;
465: if (p_sent_date_to is not null) then
466: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':received_date_to', p_sent_date_to);
467: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':received_date_format', p_sent_date_format);
468: end if;
469: if (p_sent_date_from is not null) then
470: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':received_date_from', p_sent_date_from);

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

463: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':resource_id', p_resource_id);
464: end if;
465: if (p_sent_date_to is not null) then
466: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':received_date_to', p_sent_date_to);
467: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':received_date_format', p_sent_date_format);
468: end if;
469: if (p_sent_date_from is not null) then
470: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':received_date_from', p_sent_date_from);
471: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':received_date_format', p_sent_date_format);

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

466: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':received_date_to', p_sent_date_to);
467: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':received_date_format', p_sent_date_format);
468: end if;
469: if (p_sent_date_from is not null) then
470: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':received_date_from', p_sent_date_from);
471: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':received_date_format', p_sent_date_format);
472: end if;
473: if (p_customer_name is not null) then
474: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':customer_name', p_customer_name);

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

467: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':received_date_format', p_sent_date_format);
468: end if;
469: if (p_sent_date_from is not null) then
470: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':received_date_from', p_sent_date_from);
471: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':received_date_format', p_sent_date_format);
472: end if;
473: if (p_customer_name is not null) then
474: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':customer_name', p_customer_name);
475: end if;

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

470: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':received_date_from', p_sent_date_from);
471: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':received_date_format', p_sent_date_format);
472: end if;
473: if (p_customer_name is not null) then
474: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':customer_name', p_customer_name);
475: end if;
476:
477: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':email_account_id', p_email_account_id);
478:

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

473: if (p_customer_name is not null) then
474: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':customer_name', p_customer_name);
475: end if;
476:
477: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':email_account_id', p_email_account_id);
478:
479: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 1, l_message_count);
480:
481: l_dummy := DBMS_SQL.EXECUTE(l_cursorID);

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

475: end if;
476:
477: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':email_account_id', p_email_account_id);
478:
479: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 1, l_message_count);
480:
481: l_dummy := DBMS_SQL.EXECUTE(l_cursorID);
482:
483: IF DBMS_SQL.FETCH_ROWS(l_cursorID) <> 0 THEN

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

477: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':email_account_id', p_email_account_id);
478:
479: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 1, l_message_count);
480:
481: l_dummy := DBMS_SQL.EXECUTE(l_cursorID);
482:
483: IF DBMS_SQL.FETCH_ROWS(l_cursorID) <> 0 THEN
484: DBMS_SQL.COLUMN_VALUE(l_cursorID, 1, l_message_count);
485: x_message_count := l_message_count;

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

479: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 1, l_message_count);
480:
481: l_dummy := DBMS_SQL.EXECUTE(l_cursorID);
482:
483: IF DBMS_SQL.FETCH_ROWS(l_cursorID) <> 0 THEN
484: DBMS_SQL.COLUMN_VALUE(l_cursorID, 1, l_message_count);
485: x_message_count := l_message_count;
486: END IF;
487:

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

480:
481: l_dummy := DBMS_SQL.EXECUTE(l_cursorID);
482:
483: IF DBMS_SQL.FETCH_ROWS(l_cursorID) <> 0 THEN
484: DBMS_SQL.COLUMN_VALUE(l_cursorID, 1, l_message_count);
485: x_message_count := l_message_count;
486: END IF;
487:
488: DBMS_SQL.CLOSE_CURSOR(l_cursorID);

Line 488: DBMS_SQL.CLOSE_CURSOR(l_cursorID);

484: DBMS_SQL.COLUMN_VALUE(l_cursorID, 1, l_message_count);
485: x_message_count := l_message_count;
486: END IF;
487:
488: DBMS_SQL.CLOSE_CURSOR(l_cursorID);
489:
490: -- Standard Check Of p_commit.
491: IF FND_API.To_Boolean(p_commit) THEN
492: COMMIT WORK;

Line 674: l_cursorID := DBMS_SQL.OPEN_CURSOR;

670: else
671: l_string := l_string1 || l_where_clause || l_string2 || l_where_clause || l_string3 || l_sort_order;
672: end if;
673:
674: l_cursorID := DBMS_SQL.OPEN_CURSOR;
675: DBMS_SQL.PARSE(l_cursorID, l_string, DBMS_SQL.V7);
676:
677: if (p_resource_name is not null) then
678: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':resource_name', p_resource_name);

Line 675: DBMS_SQL.PARSE(l_cursorID, l_string, DBMS_SQL.V7);

671: l_string := l_string1 || l_where_clause || l_string2 || l_where_clause || l_string3 || l_sort_order;
672: end if;
673:
674: l_cursorID := DBMS_SQL.OPEN_CURSOR;
675: DBMS_SQL.PARSE(l_cursorID, l_string, DBMS_SQL.V7);
676:
677: if (p_resource_name is not null) then
678: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':resource_name', p_resource_name);
679: end if;

Line 678: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':resource_name', p_resource_name);

674: l_cursorID := DBMS_SQL.OPEN_CURSOR;
675: DBMS_SQL.PARSE(l_cursorID, l_string, DBMS_SQL.V7);
676:
677: if (p_resource_name is not null) then
678: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':resource_name', p_resource_name);
679: end if;
680:
681: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':email_account_id', p_email_account_id);
682: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':resource_role', l_resource_role);

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

677: if (p_resource_name is not null) then
678: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':resource_name', p_resource_name);
679: end if;
680:
681: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':email_account_id', p_email_account_id);
682: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':resource_role', l_resource_role);
683:
684: if (p_transferrer_id <> -1) then
685: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':transferrer_id', p_transferrer_id);

Line 682: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':resource_role', l_resource_role);

678: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':resource_name', p_resource_name);
679: end if;
680:
681: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':email_account_id', p_email_account_id);
682: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':resource_role', l_resource_role);
683:
684: if (p_transferrer_id <> -1) then
685: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':transferrer_id', p_transferrer_id);
686: end if;

Line 685: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':transferrer_id', p_transferrer_id);

681: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':email_account_id', p_email_account_id);
682: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':resource_role', l_resource_role);
683:
684: if (p_transferrer_id <> -1) then
685: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':transferrer_id', p_transferrer_id);
686: end if;
687:
688: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 1, l_resource_id);
689: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 2, l_resource_name, 720);

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

684: if (p_transferrer_id <> -1) then
685: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':transferrer_id', p_transferrer_id);
686: end if;
687:
688: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 1, l_resource_id);
689: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 2, l_resource_name, 720);
690: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 3, l_last_login_time, 500);
691: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 4, l_real_last_login_time);
692:

Line 689: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 2, l_resource_name, 720);

685: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':transferrer_id', p_transferrer_id);
686: end if;
687:
688: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 1, l_resource_id);
689: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 2, l_resource_name, 720);
690: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 3, l_last_login_time, 500);
691: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 4, l_real_last_login_time);
692:
693:

Line 690: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 3, l_last_login_time, 500);

686: end if;
687:
688: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 1, l_resource_id);
689: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 2, l_resource_name, 720);
690: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 3, l_last_login_time, 500);
691: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 4, l_real_last_login_time);
692:
693:
694: l_dummy := DBMS_SQL.EXECUTE(l_cursorID);

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

687:
688: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 1, l_resource_id);
689: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 2, l_resource_name, 720);
690: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 3, l_last_login_time, 500);
691: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 4, l_real_last_login_time);
692:
693:
694: l_dummy := DBMS_SQL.EXECUTE(l_cursorID);
695:

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

690: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 3, l_last_login_time, 500);
691: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 4, l_real_last_login_time);
692:
693:
694: l_dummy := DBMS_SQL.EXECUTE(l_cursorID);
695:
696: LOOP
697: IF DBMS_SQL.FETCH_ROWS(l_cursorID) = 0 THEN
698: EXIT;

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

693:
694: l_dummy := DBMS_SQL.EXECUTE(l_cursorID);
695:
696: LOOP
697: IF DBMS_SQL.FETCH_ROWS(l_cursorID) = 0 THEN
698: EXIT;
699: END IF;
700:
701: DBMS_SQL.COLUMN_VALUE(l_cursorID, 1, l_resource_id);

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

697: IF DBMS_SQL.FETCH_ROWS(l_cursorID) = 0 THEN
698: EXIT;
699: END IF;
700:
701: DBMS_SQL.COLUMN_VALUE(l_cursorID, 1, l_resource_id);
702: DBMS_SQL.COLUMN_VALUE(l_cursorID, 2, l_resource_name);
703: DBMS_SQL.COLUMN_VALUE(l_cursorID, 3, l_last_login_time);
704: DBMS_SQL.COLUMN_VALUE(l_cursorID, 4, l_real_last_login_time);
705:

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

698: EXIT;
699: END IF;
700:
701: DBMS_SQL.COLUMN_VALUE(l_cursorID, 1, l_resource_id);
702: DBMS_SQL.COLUMN_VALUE(l_cursorID, 2, l_resource_name);
703: DBMS_SQL.COLUMN_VALUE(l_cursorID, 3, l_last_login_time);
704: DBMS_SQL.COLUMN_VALUE(l_cursorID, 4, l_real_last_login_time);
705:
706: select count(*) into l_fetched_emails from iem_rt_proc_emails a

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

699: END IF;
700:
701: DBMS_SQL.COLUMN_VALUE(l_cursorID, 1, l_resource_id);
702: DBMS_SQL.COLUMN_VALUE(l_cursorID, 2, l_resource_name);
703: DBMS_SQL.COLUMN_VALUE(l_cursorID, 3, l_last_login_time);
704: DBMS_SQL.COLUMN_VALUE(l_cursorID, 4, l_real_last_login_time);
705:
706: select count(*) into l_fetched_emails from iem_rt_proc_emails a
707: where a.email_account_id=p_email_account_id and a.queue_status is null and resource_id = l_resource_id;

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

700:
701: DBMS_SQL.COLUMN_VALUE(l_cursorID, 1, l_resource_id);
702: DBMS_SQL.COLUMN_VALUE(l_cursorID, 2, l_resource_name);
703: DBMS_SQL.COLUMN_VALUE(l_cursorID, 3, l_last_login_time);
704: DBMS_SQL.COLUMN_VALUE(l_cursorID, 4, l_real_last_login_time);
705:
706: select count(*) into l_fetched_emails from iem_rt_proc_emails a
707: where a.email_account_id=p_email_account_id and a.queue_status is null and resource_id = l_resource_id;
708:

Line 718: DBMS_SQL.CLOSE_CURSOR(l_cursorID);

714: l_index := l_index + 1;
715:
716: END LOOP;
717:
718: DBMS_SQL.CLOSE_CURSOR(l_cursorID);
719:
720: else
721: -- p_sort_column=0 or 1
722:

Line 786: l_cursorID := DBMS_SQL.OPEN_CURSOR;

782: else
783: l_string := l_string1 || l_where_clause || l_string2 || l_where_clause || l_string3 || l_order_by;
784: end if;
785:
786: l_cursorID := DBMS_SQL.OPEN_CURSOR;
787: DBMS_SQL.PARSE(l_cursorID, l_string, DBMS_SQL.V7);
788:
789: if (p_resource_name is not null) then
790: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':resource_name', p_resource_name);

Line 787: DBMS_SQL.PARSE(l_cursorID, l_string, DBMS_SQL.V7);

783: l_string := l_string1 || l_where_clause || l_string2 || l_where_clause || l_string3 || l_order_by;
784: end if;
785:
786: l_cursorID := DBMS_SQL.OPEN_CURSOR;
787: DBMS_SQL.PARSE(l_cursorID, l_string, DBMS_SQL.V7);
788:
789: if (p_resource_name is not null) then
790: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':resource_name', p_resource_name);
791: end if;

Line 790: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':resource_name', p_resource_name);

786: l_cursorID := DBMS_SQL.OPEN_CURSOR;
787: DBMS_SQL.PARSE(l_cursorID, l_string, DBMS_SQL.V7);
788:
789: if (p_resource_name is not null) then
790: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':resource_name', p_resource_name);
791: end if;
792:
793: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':email_account_id', p_email_account_id);
794: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':resource_role', l_resource_role);

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

789: if (p_resource_name is not null) then
790: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':resource_name', p_resource_name);
791: end if;
792:
793: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':email_account_id', p_email_account_id);
794: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':resource_role', l_resource_role);
795:
796: if (p_transferrer_id <> -1) then
797: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':transferrer_id', p_transferrer_id);

Line 794: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':resource_role', l_resource_role);

790: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':resource_name', p_resource_name);
791: end if;
792:
793: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':email_account_id', p_email_account_id);
794: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':resource_role', l_resource_role);
795:
796: if (p_transferrer_id <> -1) then
797: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':transferrer_id', p_transferrer_id);
798: end if;

Line 797: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':transferrer_id', p_transferrer_id);

793: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':email_account_id', p_email_account_id);
794: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':resource_role', l_resource_role);
795:
796: if (p_transferrer_id <> -1) then
797: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':transferrer_id', p_transferrer_id);
798: end if;
799:
800: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 1, l_resource_id);
801: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 2, l_fetched_emails);

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

796: if (p_transferrer_id <> -1) then
797: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':transferrer_id', p_transferrer_id);
798: end if;
799:
800: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 1, l_resource_id);
801: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 2, l_fetched_emails);
802: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 3, l_resource_name, 720);
803:
804: l_dummy := DBMS_SQL.EXECUTE(l_cursorID);

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

797: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':transferrer_id', p_transferrer_id);
798: end if;
799:
800: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 1, l_resource_id);
801: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 2, l_fetched_emails);
802: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 3, l_resource_name, 720);
803:
804: l_dummy := DBMS_SQL.EXECUTE(l_cursorID);
805:

Line 802: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 3, l_resource_name, 720);

798: end if;
799:
800: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 1, l_resource_id);
801: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 2, l_fetched_emails);
802: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 3, l_resource_name, 720);
803:
804: l_dummy := DBMS_SQL.EXECUTE(l_cursorID);
805:
806: LOOP

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

800: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 1, l_resource_id);
801: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 2, l_fetched_emails);
802: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 3, l_resource_name, 720);
803:
804: l_dummy := DBMS_SQL.EXECUTE(l_cursorID);
805:
806: LOOP
807: IF DBMS_SQL.FETCH_ROWS(l_cursorID) = 0 THEN
808: EXIT;

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

803:
804: l_dummy := DBMS_SQL.EXECUTE(l_cursorID);
805:
806: LOOP
807: IF DBMS_SQL.FETCH_ROWS(l_cursorID) = 0 THEN
808: EXIT;
809: END IF;
810:
811: DBMS_SQL.COLUMN_VALUE(l_cursorID, 1, l_resource_id);

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

807: IF DBMS_SQL.FETCH_ROWS(l_cursorID) = 0 THEN
808: EXIT;
809: END IF;
810:
811: DBMS_SQL.COLUMN_VALUE(l_cursorID, 1, l_resource_id);
812: DBMS_SQL.COLUMN_VALUE(l_cursorID, 2, l_fetched_emails);
813: DBMS_SQL.COLUMN_VALUE(l_cursorID, 3, l_resource_name);
814:
815: select to_char(max(begin_date_time), 'MM/DD/RRRR HH24:MI:SS') into l_last_login_time

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

808: EXIT;
809: END IF;
810:
811: DBMS_SQL.COLUMN_VALUE(l_cursorID, 1, l_resource_id);
812: DBMS_SQL.COLUMN_VALUE(l_cursorID, 2, l_fetched_emails);
813: DBMS_SQL.COLUMN_VALUE(l_cursorID, 3, l_resource_name);
814:
815: select to_char(max(begin_date_time), 'MM/DD/RRRR HH24:MI:SS') into l_last_login_time
816: from ieu_sh_sessions where application_id=680 and resource_id=l_resource_id;

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

809: END IF;
810:
811: DBMS_SQL.COLUMN_VALUE(l_cursorID, 1, l_resource_id);
812: DBMS_SQL.COLUMN_VALUE(l_cursorID, 2, l_fetched_emails);
813: DBMS_SQL.COLUMN_VALUE(l_cursorID, 3, l_resource_name);
814:
815: select to_char(max(begin_date_time), 'MM/DD/RRRR HH24:MI:SS') into l_last_login_time
816: from ieu_sh_sessions where application_id=680 and resource_id=l_resource_id;
817:

Line 827: DBMS_SQL.CLOSE_CURSOR(l_cursorID);

823: l_index := l_index + 1;
824:
825: END LOOP;
826:
827: DBMS_SQL.CLOSE_CURSOR(l_cursorID);
828:
829: end if; -- if p_sort_column=2
830: -- Standard Check Of p_commit.
831: IF FND_API.To_Boolean(p_commit) THEN