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

Line 299: l_call := dbms_sql.open_cursor;

295:
296: IF (nvl(l_apps_sso,'SSWA')='SSO_SDK') OR
297: (nvl(l_apps_sso,'SSWA')='SSWA_SSO') THEN
298:
299: l_call := dbms_sql.open_cursor;
300:
301: l_procedure_call := 'wwsec_sso_enabler.parse_url_cookie'||
302: '(p_lsnr_token => :l_listener_token'||
303: ',p_enc_url_cookie => :urlc'||

Line 312: dbms_sql.parse(l_call,'begin '||l_procedure_call||'; exception when wwsec_sso_enabler.COOKIE_EXPIRED_EXCEPTION then icx_sec.g_window_cookie_name := ''X''; raise; when others then raise; end;' ,dbms_sql.native);

308: ',p_url_requested => :l_url_requested)';
309:
310: icx_sec.g_window_cookie_name := 'Y';
311:
312: dbms_sql.parse(l_call,'begin '||l_procedure_call||'; exception when wwsec_sso_enabler.COOKIE_EXPIRED_EXCEPTION then icx_sec.g_window_cookie_name := ''X''; raise; when others then raise; end;' ,dbms_sql.native);
313:
314: l_sso_user_name := '1234567890123456789012345678901234567890';
315: l_ip_address := '123.456.678.901';
316: l_sso_time_remaining := 1234567890;

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

320: for i in 1..100 loop -- set l_url_requested to 2000 characters
321: l_url_requested := l_url_requested||'12345678901234567890';
322: end loop;
323:
324: dbms_sql.bind_variable(l_call,'l_listener_token',l_listener_token);
325: dbms_sql.bind_variable(l_call,'urlc',urlc);
326: dbms_sql.bind_variable(l_call,'l_sso_user_name',l_sso_user_name);
327: dbms_sql.bind_variable(l_call,'l_ip_address',l_ip_address);
328: dbms_sql.bind_variable(l_call,'l_sso_time_remaining',l_sso_time_remaining);

Line 325: dbms_sql.bind_variable(l_call,'urlc',urlc);

321: l_url_requested := l_url_requested||'12345678901234567890';
322: end loop;
323:
324: dbms_sql.bind_variable(l_call,'l_listener_token',l_listener_token);
325: dbms_sql.bind_variable(l_call,'urlc',urlc);
326: dbms_sql.bind_variable(l_call,'l_sso_user_name',l_sso_user_name);
327: dbms_sql.bind_variable(l_call,'l_ip_address',l_ip_address);
328: dbms_sql.bind_variable(l_call,'l_sso_time_remaining',l_sso_time_remaining);
329: dbms_sql.bind_variable(l_call,'l_site_time_stamp',l_site_time_stamp);

Line 326: dbms_sql.bind_variable(l_call,'l_sso_user_name',l_sso_user_name);

322: end loop;
323:
324: dbms_sql.bind_variable(l_call,'l_listener_token',l_listener_token);
325: dbms_sql.bind_variable(l_call,'urlc',urlc);
326: dbms_sql.bind_variable(l_call,'l_sso_user_name',l_sso_user_name);
327: dbms_sql.bind_variable(l_call,'l_ip_address',l_ip_address);
328: dbms_sql.bind_variable(l_call,'l_sso_time_remaining',l_sso_time_remaining);
329: dbms_sql.bind_variable(l_call,'l_site_time_stamp',l_site_time_stamp);
330: dbms_sql.bind_variable(l_call,'l_url_requested',l_url_requested);

Line 327: dbms_sql.bind_variable(l_call,'l_ip_address',l_ip_address);

323:
324: dbms_sql.bind_variable(l_call,'l_listener_token',l_listener_token);
325: dbms_sql.bind_variable(l_call,'urlc',urlc);
326: dbms_sql.bind_variable(l_call,'l_sso_user_name',l_sso_user_name);
327: dbms_sql.bind_variable(l_call,'l_ip_address',l_ip_address);
328: dbms_sql.bind_variable(l_call,'l_sso_time_remaining',l_sso_time_remaining);
329: dbms_sql.bind_variable(l_call,'l_site_time_stamp',l_site_time_stamp);
330: dbms_sql.bind_variable(l_call,'l_url_requested',l_url_requested);
331:

Line 328: dbms_sql.bind_variable(l_call,'l_sso_time_remaining',l_sso_time_remaining);

324: dbms_sql.bind_variable(l_call,'l_listener_token',l_listener_token);
325: dbms_sql.bind_variable(l_call,'urlc',urlc);
326: dbms_sql.bind_variable(l_call,'l_sso_user_name',l_sso_user_name);
327: dbms_sql.bind_variable(l_call,'l_ip_address',l_ip_address);
328: dbms_sql.bind_variable(l_call,'l_sso_time_remaining',l_sso_time_remaining);
329: dbms_sql.bind_variable(l_call,'l_site_time_stamp',l_site_time_stamp);
330: dbms_sql.bind_variable(l_call,'l_url_requested',l_url_requested);
331:
332: l_dummy := dbms_sql.execute(l_call);

Line 329: dbms_sql.bind_variable(l_call,'l_site_time_stamp',l_site_time_stamp);

325: dbms_sql.bind_variable(l_call,'urlc',urlc);
326: dbms_sql.bind_variable(l_call,'l_sso_user_name',l_sso_user_name);
327: dbms_sql.bind_variable(l_call,'l_ip_address',l_ip_address);
328: dbms_sql.bind_variable(l_call,'l_sso_time_remaining',l_sso_time_remaining);
329: dbms_sql.bind_variable(l_call,'l_site_time_stamp',l_site_time_stamp);
330: dbms_sql.bind_variable(l_call,'l_url_requested',l_url_requested);
331:
332: l_dummy := dbms_sql.execute(l_call);
333:

Line 330: dbms_sql.bind_variable(l_call,'l_url_requested',l_url_requested);

326: dbms_sql.bind_variable(l_call,'l_sso_user_name',l_sso_user_name);
327: dbms_sql.bind_variable(l_call,'l_ip_address',l_ip_address);
328: dbms_sql.bind_variable(l_call,'l_sso_time_remaining',l_sso_time_remaining);
329: dbms_sql.bind_variable(l_call,'l_site_time_stamp',l_site_time_stamp);
330: dbms_sql.bind_variable(l_call,'l_url_requested',l_url_requested);
331:
332: l_dummy := dbms_sql.execute(l_call);
333:
334: dbms_sql.variable_value(l_call,'l_sso_user_name',l_sso_user_name);

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

328: dbms_sql.bind_variable(l_call,'l_sso_time_remaining',l_sso_time_remaining);
329: dbms_sql.bind_variable(l_call,'l_site_time_stamp',l_site_time_stamp);
330: dbms_sql.bind_variable(l_call,'l_url_requested',l_url_requested);
331:
332: l_dummy := dbms_sql.execute(l_call);
333:
334: dbms_sql.variable_value(l_call,'l_sso_user_name',l_sso_user_name);
335: dbms_sql.variable_value(l_call,'l_url_requested',l_url_requested);
336:

Line 334: dbms_sql.variable_value(l_call,'l_sso_user_name',l_sso_user_name);

330: dbms_sql.bind_variable(l_call,'l_url_requested',l_url_requested);
331:
332: l_dummy := dbms_sql.execute(l_call);
333:
334: dbms_sql.variable_value(l_call,'l_sso_user_name',l_sso_user_name);
335: dbms_sql.variable_value(l_call,'l_url_requested',l_url_requested);
336:
337: dbms_sql.close_cursor(l_call);
338:

Line 335: dbms_sql.variable_value(l_call,'l_url_requested',l_url_requested);

331:
332: l_dummy := dbms_sql.execute(l_call);
333:
334: dbms_sql.variable_value(l_call,'l_sso_user_name',l_sso_user_name);
335: dbms_sql.variable_value(l_call,'l_url_requested',l_url_requested);
336:
337: dbms_sql.close_cursor(l_call);
338:
339: END IF;--apps_sso profile option

Line 337: dbms_sql.close_cursor(l_call);

333:
334: dbms_sql.variable_value(l_call,'l_sso_user_name',l_sso_user_name);
335: dbms_sql.variable_value(l_call,'l_url_requested',l_url_requested);
336:
337: dbms_sql.close_cursor(l_call);
338:
339: END IF;--apps_sso profile option
340:
341: portalUrl := fnd_profile.value('APPS_PORTAL');

Line 542: l_call := dbms_sql.open_cursor;

538: IF ((nvl(l_apps_sso,'SSWA')='SSO_SDK') OR (nvl(l_apps_sso,'SSWA')='SSWA_SSO')) THEN
539:
540: l_listener_token := OracleSSWA.listener_token;
541:
542: l_call := dbms_sql.open_cursor;
543: -- l_gen_redirect_url:= wwsec_sso_enabler.generate_redirect(p_lsnr_token => l_listener_token,
544: -- p_url_requested => l_urlrequested,
545: -- p_url_cancel => l_urlcancel);
546: l_procedure_call := ':l_gen_redirect_url := wwsec_sso_enabler.generate_redirect'||

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

547: '(p_lsnr_token => :l_listener_token'||
548: ',p_url_requested => :l_urlrequested'||
549: ',p_url_cancel => :l_urlcancel)';
550:
551: dbms_sql.parse(l_call,'declare l_gen_redirect_url varchar2(32000); begin '||l_procedure_call||'; end;',dbms_sql.native);
552:
553: l_gen_redirect_url := '';
554: for i in 1..100 loop -- set l_gen_redirect_url to 2000 characters
555: l_gen_redirect_url := l_gen_redirect_url||'12345678901234567890';

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

554: for i in 1..100 loop -- set l_gen_redirect_url to 2000 characters
555: l_gen_redirect_url := l_gen_redirect_url||'12345678901234567890';
556: end loop;
557:
558: dbms_sql.bind_variable(l_call,'l_gen_redirect_url',l_gen_redirect_url);
559: dbms_sql.bind_variable(l_call,'l_listener_token',l_listener_token);
560: dbms_sql.bind_variable(l_call,'l_urlrequested',l_urlrequested);
561: dbms_sql.bind_variable(l_call,'l_urlcancel',l_urlcancel);
562:

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

555: l_gen_redirect_url := l_gen_redirect_url||'12345678901234567890';
556: end loop;
557:
558: dbms_sql.bind_variable(l_call,'l_gen_redirect_url',l_gen_redirect_url);
559: dbms_sql.bind_variable(l_call,'l_listener_token',l_listener_token);
560: dbms_sql.bind_variable(l_call,'l_urlrequested',l_urlrequested);
561: dbms_sql.bind_variable(l_call,'l_urlcancel',l_urlcancel);
562:
563: l_dummy := dbms_sql.execute(l_call);

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

556: end loop;
557:
558: dbms_sql.bind_variable(l_call,'l_gen_redirect_url',l_gen_redirect_url);
559: dbms_sql.bind_variable(l_call,'l_listener_token',l_listener_token);
560: dbms_sql.bind_variable(l_call,'l_urlrequested',l_urlrequested);
561: dbms_sql.bind_variable(l_call,'l_urlcancel',l_urlcancel);
562:
563: l_dummy := dbms_sql.execute(l_call);
564:

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

557:
558: dbms_sql.bind_variable(l_call,'l_gen_redirect_url',l_gen_redirect_url);
559: dbms_sql.bind_variable(l_call,'l_listener_token',l_listener_token);
560: dbms_sql.bind_variable(l_call,'l_urlrequested',l_urlrequested);
561: dbms_sql.bind_variable(l_call,'l_urlcancel',l_urlcancel);
562:
563: l_dummy := dbms_sql.execute(l_call);
564:
565: dbms_sql.variable_value(l_call,'l_gen_redirect_url',l_gen_redirect_url);

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

559: dbms_sql.bind_variable(l_call,'l_listener_token',l_listener_token);
560: dbms_sql.bind_variable(l_call,'l_urlrequested',l_urlrequested);
561: dbms_sql.bind_variable(l_call,'l_urlcancel',l_urlcancel);
562:
563: l_dummy := dbms_sql.execute(l_call);
564:
565: dbms_sql.variable_value(l_call,'l_gen_redirect_url',l_gen_redirect_url);
566:
567: dbms_sql.close_cursor(l_call);

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

561: dbms_sql.bind_variable(l_call,'l_urlcancel',l_urlcancel);
562:
563: l_dummy := dbms_sql.execute(l_call);
564:
565: dbms_sql.variable_value(l_call,'l_gen_redirect_url',l_gen_redirect_url);
566:
567: dbms_sql.close_cursor(l_call);
568:
569: END IF;--apps_sso profile

Line 567: dbms_sql.close_cursor(l_call);

563: l_dummy := dbms_sql.execute(l_call);
564:
565: dbms_sql.variable_value(l_call,'l_gen_redirect_url',l_gen_redirect_url);
566:
567: dbms_sql.close_cursor(l_call);
568:
569: END IF;--apps_sso profile
570: owa_util.redirect_url(l_gen_redirect_url);
571:

Line 1109: l_call := dbms_sql.open_cursor;

1105: -- p_url_requested => l_urlrequested,
1106: -- p_url_cancel => l_urlcancel);
1107:
1108:
1109: l_call := dbms_sql.open_cursor;
1110:
1111: l_procedure_call := ':l_gen_redirect_url := wwsec_sso_enabler.generate_redirect'||
1112: '(p_lsnr_token => :l_listener_token'||
1113: ',p_url_requested => :l_urlrequested'||

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

1112: '(p_lsnr_token => :l_listener_token'||
1113: ',p_url_requested => :l_urlrequested'||
1114: ',p_url_cancel => :l_urlcancel)';
1115:
1116: dbms_sql.parse(l_call,'declare l_gen_redirect_url varchar2(32000); begin '||l_procedure_call||'; end;',dbms_sql.native);
1117:
1118: l_gen_redirect_url := '';
1119: for i in 1..100 loop -- set l_gen_redirect_url to 2000 characters
1120: l_gen_redirect_url := l_gen_redirect_url||'12345678901234567890';

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

1119: for i in 1..100 loop -- set l_gen_redirect_url to 2000 characters
1120: l_gen_redirect_url := l_gen_redirect_url||'12345678901234567890';
1121: end loop;
1122:
1123: dbms_sql.bind_variable(l_call,'l_gen_redirect_url',l_gen_redirect_url);
1124: dbms_sql.bind_variable(l_call,'l_listener_token',l_listener_token);
1125: dbms_sql.bind_variable(l_call,'l_urlrequested',l_urlrequested);
1126: dbms_sql.bind_variable(l_call,'l_urlcancel',l_urlcancel);
1127: l_dummy := dbms_sql.execute(l_call);

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

1120: l_gen_redirect_url := l_gen_redirect_url||'12345678901234567890';
1121: end loop;
1122:
1123: dbms_sql.bind_variable(l_call,'l_gen_redirect_url',l_gen_redirect_url);
1124: dbms_sql.bind_variable(l_call,'l_listener_token',l_listener_token);
1125: dbms_sql.bind_variable(l_call,'l_urlrequested',l_urlrequested);
1126: dbms_sql.bind_variable(l_call,'l_urlcancel',l_urlcancel);
1127: l_dummy := dbms_sql.execute(l_call);
1128: dbms_sql.variable_value(l_call,'l_gen_redirect_url',l_gen_redirect_url);

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

1121: end loop;
1122:
1123: dbms_sql.bind_variable(l_call,'l_gen_redirect_url',l_gen_redirect_url);
1124: dbms_sql.bind_variable(l_call,'l_listener_token',l_listener_token);
1125: dbms_sql.bind_variable(l_call,'l_urlrequested',l_urlrequested);
1126: dbms_sql.bind_variable(l_call,'l_urlcancel',l_urlcancel);
1127: l_dummy := dbms_sql.execute(l_call);
1128: dbms_sql.variable_value(l_call,'l_gen_redirect_url',l_gen_redirect_url);
1129:

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

1122:
1123: dbms_sql.bind_variable(l_call,'l_gen_redirect_url',l_gen_redirect_url);
1124: dbms_sql.bind_variable(l_call,'l_listener_token',l_listener_token);
1125: dbms_sql.bind_variable(l_call,'l_urlrequested',l_urlrequested);
1126: dbms_sql.bind_variable(l_call,'l_urlcancel',l_urlcancel);
1127: l_dummy := dbms_sql.execute(l_call);
1128: dbms_sql.variable_value(l_call,'l_gen_redirect_url',l_gen_redirect_url);
1129:
1130: dbms_sql.close_cursor(l_call);

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

1123: dbms_sql.bind_variable(l_call,'l_gen_redirect_url',l_gen_redirect_url);
1124: dbms_sql.bind_variable(l_call,'l_listener_token',l_listener_token);
1125: dbms_sql.bind_variable(l_call,'l_urlrequested',l_urlrequested);
1126: dbms_sql.bind_variable(l_call,'l_urlcancel',l_urlcancel);
1127: l_dummy := dbms_sql.execute(l_call);
1128: dbms_sql.variable_value(l_call,'l_gen_redirect_url',l_gen_redirect_url);
1129:
1130: dbms_sql.close_cursor(l_call);
1131:

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

1124: dbms_sql.bind_variable(l_call,'l_listener_token',l_listener_token);
1125: dbms_sql.bind_variable(l_call,'l_urlrequested',l_urlrequested);
1126: dbms_sql.bind_variable(l_call,'l_urlcancel',l_urlcancel);
1127: l_dummy := dbms_sql.execute(l_call);
1128: dbms_sql.variable_value(l_call,'l_gen_redirect_url',l_gen_redirect_url);
1129:
1130: dbms_sql.close_cursor(l_call);
1131:
1132: RETURN l_gen_redirect_url;

Line 1130: dbms_sql.close_cursor(l_call);

1126: dbms_sql.bind_variable(l_call,'l_urlcancel',l_urlcancel);
1127: l_dummy := dbms_sql.execute(l_call);
1128: dbms_sql.variable_value(l_call,'l_gen_redirect_url',l_gen_redirect_url);
1129:
1130: dbms_sql.close_cursor(l_call);
1131:
1132: RETURN l_gen_redirect_url;
1133: END;
1134: