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 483: l_cursorID := DBMS_SQL.OPEN_CURSOR;

479: and rel.role_resource_type = ''RS_INDIVIDUAL''
480: and trunc(sysdate) between trunc(nvl(rel.start_date_active, sysdate))
481: and trunc(nvl(rel.end_date_active, sysdate)) ) ';
482: l_string := l_string ||l_where||l_order_by;
483: l_cursorID := DBMS_SQL.OPEN_CURSOR;
484: DBMS_SQL.PARSE(l_cursorID, l_string, DBMS_SQL.native);
485:
486: IF p_search_criteria is not null THEN
487: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':search_criteria', p_search_criteria);

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

480: and trunc(sysdate) between trunc(nvl(rel.start_date_active, sysdate))
481: and trunc(nvl(rel.end_date_active, sysdate)) ) ';
482: l_string := l_string ||l_where||l_order_by;
483: l_cursorID := DBMS_SQL.OPEN_CURSOR;
484: DBMS_SQL.PARSE(l_cursorID, l_string, DBMS_SQL.native);
485:
486: IF p_search_criteria is not null THEN
487: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':search_criteria', p_search_criteria);
488: end if;

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

483: l_cursorID := DBMS_SQL.OPEN_CURSOR;
484: DBMS_SQL.PARSE(l_cursorID, l_string, DBMS_SQL.native);
485:
486: IF p_search_criteria is not null THEN
487: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':search_criteria', p_search_criteria);
488: end if;
489: /*
490: IF p_roleid <> -1 THEN
491: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':roleid', l_roleid);

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

487: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':search_criteria', p_search_criteria);
488: end if;
489: /*
490: IF p_roleid <> -1 THEN
491: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':roleid', l_roleid);
492: END IF;
493: */
494: IF p_resource_id <> -1 THEN
495: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':resource_id', p_resource_id);

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

491: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':roleid', l_roleid);
492: END IF;
493: */
494: IF p_resource_id <> -1 THEN
495: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':resource_id', p_resource_id);
496: END IF;
497:
498: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':email_account_id', p_email_account_id);
499:

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

494: IF p_resource_id <> -1 THEN
495: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':resource_id', p_resource_id);
496: END IF;
497:
498: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':email_account_id', p_email_account_id);
499:
500: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 1, l_resource_id);
501: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 2, l_resource_name, 360);
502: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 3, l_user_name, 256);

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

496: END IF;
497:
498: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':email_account_id', p_email_account_id);
499:
500: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 1, l_resource_id);
501: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 2, l_resource_name, 360);
502: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 3, l_user_name, 256);
503: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 4, l_responsibility_name, 100);
504:

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

497:
498: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':email_account_id', p_email_account_id);
499:
500: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 1, l_resource_id);
501: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 2, l_resource_name, 360);
502: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 3, l_user_name, 256);
503: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 4, l_responsibility_name, 100);
504:
505: l_dummy := DBMS_SQL.EXECUTE(l_cursorID);

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

498: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':email_account_id', p_email_account_id);
499:
500: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 1, l_resource_id);
501: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 2, l_resource_name, 360);
502: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 3, l_user_name, 256);
503: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 4, l_responsibility_name, 100);
504:
505: l_dummy := DBMS_SQL.EXECUTE(l_cursorID);
506: l_temp_tbl.delete;

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

499:
500: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 1, l_resource_id);
501: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 2, l_resource_name, 360);
502: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 3, l_user_name, 256);
503: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 4, l_responsibility_name, 100);
504:
505: l_dummy := DBMS_SQL.EXECUTE(l_cursorID);
506: l_temp_tbl.delete;
507: l_counter:=1;

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

501: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 2, l_resource_name, 360);
502: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 3, l_user_name, 256);
503: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 4, l_responsibility_name, 100);
504:
505: l_dummy := DBMS_SQL.EXECUTE(l_cursorID);
506: l_temp_tbl.delete;
507: l_counter:=1;
508:
509: LOOP

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

506: l_temp_tbl.delete;
507: l_counter:=1;
508:
509: LOOP
510: IF (DBMS_SQL.FETCH_ROWS(l_cursorID) = 0) THEN
511: EXIT;
512: END IF;
513:
514: DBMS_SQL.COLUMN_VALUE(l_cursorID, 1, l_resource_id);

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

510: IF (DBMS_SQL.FETCH_ROWS(l_cursorID) = 0) THEN
511: EXIT;
512: END IF;
513:
514: DBMS_SQL.COLUMN_VALUE(l_cursorID, 1, l_resource_id);
515: DBMS_SQL.COLUMN_VALUE(l_cursorID, 2, l_resource_name);
516: DBMS_SQL.COLUMN_VALUE(l_cursorID, 3, l_user_name);
517: DBMS_SQL.COLUMN_VALUE(l_cursorID, 4, l_responsibility_name);
518:

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

511: EXIT;
512: END IF;
513:
514: DBMS_SQL.COLUMN_VALUE(l_cursorID, 1, l_resource_id);
515: DBMS_SQL.COLUMN_VALUE(l_cursorID, 2, l_resource_name);
516: DBMS_SQL.COLUMN_VALUE(l_cursorID, 3, l_user_name);
517: DBMS_SQL.COLUMN_VALUE(l_cursorID, 4, l_responsibility_name);
518:
519: select to_char(max(begin_date_time), 'MM/DD/RRRR HH24:MI:SS') into l_last_login_time

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

512: END IF;
513:
514: DBMS_SQL.COLUMN_VALUE(l_cursorID, 1, l_resource_id);
515: DBMS_SQL.COLUMN_VALUE(l_cursorID, 2, l_resource_name);
516: DBMS_SQL.COLUMN_VALUE(l_cursorID, 3, l_user_name);
517: DBMS_SQL.COLUMN_VALUE(l_cursorID, 4, l_responsibility_name);
518:
519: select to_char(max(begin_date_time), 'MM/DD/RRRR HH24:MI:SS') into l_last_login_time
520: from ieu_sh_sessions where application_id=680 and resource_id=l_resource_id;

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

513:
514: DBMS_SQL.COLUMN_VALUE(l_cursorID, 1, l_resource_id);
515: DBMS_SQL.COLUMN_VALUE(l_cursorID, 2, l_resource_name);
516: DBMS_SQL.COLUMN_VALUE(l_cursorID, 3, l_user_name);
517: DBMS_SQL.COLUMN_VALUE(l_cursorID, 4, l_responsibility_name);
518:
519: select to_char(max(begin_date_time), 'MM/DD/RRRR HH24:MI:SS') into l_last_login_time
520: from ieu_sh_sessions where application_id=680 and resource_id=l_resource_id;
521:

Line 532: DBMS_SQL.CLOSE_CURSOR(l_cursorID);

528: l_counter:=l_counter+1;
529:
530: END LOOP;
531:
532: DBMS_SQL.CLOSE_CURSOR(l_cursorID);
533:
534: x_search_count:=0;
535: x_search_count:=l_temp_tbl.count;
536: IF l_temp_tbl.count>0 THEN