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

Line 611: l_call := dbms_sql.open_cursor;

607: l_urlcancel:=p_cancel_url;
608: END IF;
609:
610: l_listener_token := ICX_PORTLET.listener_token;
611: l_call := dbms_sql.open_cursor;
612:
613: l_procedure_call := ':l_gen_redirect_url := wwsec_sso_enabler.generate_redirect'||
614: '(p_lsnr_token => :l_listener_token'||
615: ',p_url_requested => :l_urlrequested'||

Line 618: dbms_sql.parse(l_call,'declare l_gen_redirect_url varchar2(32000); begin '||l_procedure_call||'; end;',dbms_sql.native);

614: '(p_lsnr_token => :l_listener_token'||
615: ',p_url_requested => :l_urlrequested'||
616: ',p_url_cancel => :l_urlcancel)';
617:
618: dbms_sql.parse(l_call,'declare l_gen_redirect_url varchar2(32000); begin '||l_procedure_call||'; end;',dbms_sql.native);
619:
620: l_gen_redirect_url := '';
621: for i in 1..100 loop -- set l_gen_redirect_url to 2000 characters
622: l_gen_redirect_url := l_gen_redirect_url||'12345678901234567890';

Line 625: dbms_sql.bind_variable(l_call,'l_gen_redirect_url',l_gen_redirect_url);

621: for i in 1..100 loop -- set l_gen_redirect_url to 2000 characters
622: l_gen_redirect_url := l_gen_redirect_url||'12345678901234567890';
623: end loop;
624:
625: dbms_sql.bind_variable(l_call,'l_gen_redirect_url',l_gen_redirect_url);
626: dbms_sql.bind_variable(l_call,'l_listener_token',l_listener_token);
627: dbms_sql.bind_variable(l_call,'l_urlrequested',l_urlrequested);
628: dbms_sql.bind_variable(l_call,'l_urlcancel',l_urlcancel);
629: l_dummy := dbms_sql.execute(l_call);

Line 626: dbms_sql.bind_variable(l_call,'l_listener_token',l_listener_token);

622: l_gen_redirect_url := l_gen_redirect_url||'12345678901234567890';
623: end loop;
624:
625: dbms_sql.bind_variable(l_call,'l_gen_redirect_url',l_gen_redirect_url);
626: dbms_sql.bind_variable(l_call,'l_listener_token',l_listener_token);
627: dbms_sql.bind_variable(l_call,'l_urlrequested',l_urlrequested);
628: dbms_sql.bind_variable(l_call,'l_urlcancel',l_urlcancel);
629: l_dummy := dbms_sql.execute(l_call);
630: dbms_sql.variable_value(l_call,'l_gen_redirect_url',l_gen_redirect_url);

Line 627: dbms_sql.bind_variable(l_call,'l_urlrequested',l_urlrequested);

623: end loop;
624:
625: dbms_sql.bind_variable(l_call,'l_gen_redirect_url',l_gen_redirect_url);
626: dbms_sql.bind_variable(l_call,'l_listener_token',l_listener_token);
627: dbms_sql.bind_variable(l_call,'l_urlrequested',l_urlrequested);
628: dbms_sql.bind_variable(l_call,'l_urlcancel',l_urlcancel);
629: l_dummy := dbms_sql.execute(l_call);
630: dbms_sql.variable_value(l_call,'l_gen_redirect_url',l_gen_redirect_url);
631:

Line 628: dbms_sql.bind_variable(l_call,'l_urlcancel',l_urlcancel);

624:
625: dbms_sql.bind_variable(l_call,'l_gen_redirect_url',l_gen_redirect_url);
626: dbms_sql.bind_variable(l_call,'l_listener_token',l_listener_token);
627: dbms_sql.bind_variable(l_call,'l_urlrequested',l_urlrequested);
628: dbms_sql.bind_variable(l_call,'l_urlcancel',l_urlcancel);
629: l_dummy := dbms_sql.execute(l_call);
630: dbms_sql.variable_value(l_call,'l_gen_redirect_url',l_gen_redirect_url);
631:
632: dbms_sql.close_cursor(l_call);

Line 629: l_dummy := dbms_sql.execute(l_call);

625: dbms_sql.bind_variable(l_call,'l_gen_redirect_url',l_gen_redirect_url);
626: dbms_sql.bind_variable(l_call,'l_listener_token',l_listener_token);
627: dbms_sql.bind_variable(l_call,'l_urlrequested',l_urlrequested);
628: dbms_sql.bind_variable(l_call,'l_urlcancel',l_urlcancel);
629: l_dummy := dbms_sql.execute(l_call);
630: dbms_sql.variable_value(l_call,'l_gen_redirect_url',l_gen_redirect_url);
631:
632: dbms_sql.close_cursor(l_call);
633:

Line 630: dbms_sql.variable_value(l_call,'l_gen_redirect_url',l_gen_redirect_url);

626: dbms_sql.bind_variable(l_call,'l_listener_token',l_listener_token);
627: dbms_sql.bind_variable(l_call,'l_urlrequested',l_urlrequested);
628: dbms_sql.bind_variable(l_call,'l_urlcancel',l_urlcancel);
629: l_dummy := dbms_sql.execute(l_call);
630: dbms_sql.variable_value(l_call,'l_gen_redirect_url',l_gen_redirect_url);
631:
632: dbms_sql.close_cursor(l_call);
633:
634: RETURN l_gen_redirect_url;

Line 632: dbms_sql.close_cursor(l_call);

628: dbms_sql.bind_variable(l_call,'l_urlcancel',l_urlcancel);
629: l_dummy := dbms_sql.execute(l_call);
630: dbms_sql.variable_value(l_call,'l_gen_redirect_url',l_gen_redirect_url);
631:
632: dbms_sql.close_cursor(l_call);
633:
634: RETURN l_gen_redirect_url;
635: END;
636: