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

Line 365: l_cursorID := DBMS_SQL.OPEN_CURSOR;

361: and rel.role_resource_type = ''RS_INDIVIDUAL''
362: and trunc(sysdate) between trunc(nvl(rel.start_date_active, sysdate))
363: and trunc(nvl(rel.end_date_active, sysdate)) ) ';
364: l_string := l_string ||l_where||l_order_by;
365: l_cursorID := DBMS_SQL.OPEN_CURSOR;
366: DBMS_SQL.PARSE(l_cursorID, l_string, DBMS_SQL.native);
367:
368: IF p_search_criteria is not null THEN
369: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':search_criteria', p_search_criteria);

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

362: and trunc(sysdate) between trunc(nvl(rel.start_date_active, sysdate))
363: and trunc(nvl(rel.end_date_active, sysdate)) ) ';
364: l_string := l_string ||l_where||l_order_by;
365: l_cursorID := DBMS_SQL.OPEN_CURSOR;
366: DBMS_SQL.PARSE(l_cursorID, l_string, DBMS_SQL.native);
367:
368: IF p_search_criteria is not null THEN
369: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':search_criteria', p_search_criteria);
370: end if;

Line 369: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':search_criteria', p_search_criteria);

365: l_cursorID := DBMS_SQL.OPEN_CURSOR;
366: DBMS_SQL.PARSE(l_cursorID, l_string, DBMS_SQL.native);
367:
368: IF p_search_criteria is not null THEN
369: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':search_criteria', p_search_criteria);
370: end if;
371: /*
372: IF p_roleid <> -1 THEN
373: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':roleid', l_roleid);

Line 373: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':roleid', l_roleid);

369: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':search_criteria', p_search_criteria);
370: end if;
371: /*
372: IF p_roleid <> -1 THEN
373: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':roleid', l_roleid);
374: END IF;
375: */
376: IF p_resource_id <> -1 THEN
377: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':resource_id', p_resource_id);

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

373: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':roleid', l_roleid);
374: END IF;
375: */
376: IF p_resource_id <> -1 THEN
377: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':resource_id', p_resource_id);
378: END IF;
379:
380: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':email_account_id', p_email_account_id);
381:

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

376: IF p_resource_id <> -1 THEN
377: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':resource_id', p_resource_id);
378: END IF;
379:
380: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':email_account_id', p_email_account_id);
381:
382: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 1, l_resource_id);
383: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 2, l_resource_name, 360);
384: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 3, l_user_name, 256);

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

378: END IF;
379:
380: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':email_account_id', p_email_account_id);
381:
382: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 1, l_resource_id);
383: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 2, l_resource_name, 360);
384: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 3, l_user_name, 256);
385: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 4, l_responsibility_name, 100);
386:

Line 383: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 2, l_resource_name, 360);

379:
380: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':email_account_id', p_email_account_id);
381:
382: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 1, l_resource_id);
383: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 2, l_resource_name, 360);
384: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 3, l_user_name, 256);
385: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 4, l_responsibility_name, 100);
386:
387: l_dummy := DBMS_SQL.EXECUTE(l_cursorID);

Line 384: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 3, l_user_name, 256);

380: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':email_account_id', p_email_account_id);
381:
382: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 1, l_resource_id);
383: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 2, l_resource_name, 360);
384: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 3, l_user_name, 256);
385: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 4, l_responsibility_name, 100);
386:
387: l_dummy := DBMS_SQL.EXECUTE(l_cursorID);
388: l_temp_tbl.delete;

Line 385: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 4, l_responsibility_name, 100);

381:
382: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 1, l_resource_id);
383: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 2, l_resource_name, 360);
384: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 3, l_user_name, 256);
385: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 4, l_responsibility_name, 100);
386:
387: l_dummy := DBMS_SQL.EXECUTE(l_cursorID);
388: l_temp_tbl.delete;
389: l_counter:=1;

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

383: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 2, l_resource_name, 360);
384: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 3, l_user_name, 256);
385: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 4, l_responsibility_name, 100);
386:
387: l_dummy := DBMS_SQL.EXECUTE(l_cursorID);
388: l_temp_tbl.delete;
389: l_counter:=1;
390:
391: LOOP

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

388: l_temp_tbl.delete;
389: l_counter:=1;
390:
391: LOOP
392: IF (DBMS_SQL.FETCH_ROWS(l_cursorID) = 0) THEN
393: EXIT;
394: END IF;
395:
396: DBMS_SQL.COLUMN_VALUE(l_cursorID, 1, l_resource_id);

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

392: IF (DBMS_SQL.FETCH_ROWS(l_cursorID) = 0) THEN
393: EXIT;
394: END IF;
395:
396: DBMS_SQL.COLUMN_VALUE(l_cursorID, 1, l_resource_id);
397: DBMS_SQL.COLUMN_VALUE(l_cursorID, 2, l_resource_name);
398: DBMS_SQL.COLUMN_VALUE(l_cursorID, 3, l_user_name);
399: DBMS_SQL.COLUMN_VALUE(l_cursorID, 4, l_responsibility_name);
400:

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

393: EXIT;
394: END IF;
395:
396: DBMS_SQL.COLUMN_VALUE(l_cursorID, 1, l_resource_id);
397: DBMS_SQL.COLUMN_VALUE(l_cursorID, 2, l_resource_name);
398: DBMS_SQL.COLUMN_VALUE(l_cursorID, 3, l_user_name);
399: DBMS_SQL.COLUMN_VALUE(l_cursorID, 4, l_responsibility_name);
400:
401: select to_char(max(begin_date_time), 'MM/DD/RRRR HH24:MI:SS') into l_last_login_time

Line 398: DBMS_SQL.COLUMN_VALUE(l_cursorID, 3, l_user_name);

394: END IF;
395:
396: DBMS_SQL.COLUMN_VALUE(l_cursorID, 1, l_resource_id);
397: DBMS_SQL.COLUMN_VALUE(l_cursorID, 2, l_resource_name);
398: DBMS_SQL.COLUMN_VALUE(l_cursorID, 3, l_user_name);
399: DBMS_SQL.COLUMN_VALUE(l_cursorID, 4, l_responsibility_name);
400:
401: select to_char(max(begin_date_time), 'MM/DD/RRRR HH24:MI:SS') into l_last_login_time
402: from ieu_sh_sessions where application_id=680 and resource_id=l_resource_id;

Line 399: DBMS_SQL.COLUMN_VALUE(l_cursorID, 4, l_responsibility_name);

395:
396: DBMS_SQL.COLUMN_VALUE(l_cursorID, 1, l_resource_id);
397: DBMS_SQL.COLUMN_VALUE(l_cursorID, 2, l_resource_name);
398: DBMS_SQL.COLUMN_VALUE(l_cursorID, 3, l_user_name);
399: DBMS_SQL.COLUMN_VALUE(l_cursorID, 4, l_responsibility_name);
400:
401: select to_char(max(begin_date_time), 'MM/DD/RRRR HH24:MI:SS') into l_last_login_time
402: from ieu_sh_sessions where application_id=680 and resource_id=l_resource_id;
403:

Line 414: DBMS_SQL.CLOSE_CURSOR(l_cursorID);

410: l_counter:=l_counter+1;
411:
412: END LOOP;
413:
414: DBMS_SQL.CLOSE_CURSOR(l_cursorID);
415:
416: x_search_count:=0;
417: x_search_count:=l_temp_tbl.count;
418: IF l_temp_tbl.count>0 THEN