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 301: l_call := dbms_sql.open_cursor;

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

Line 314: 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);

310: ',p_url_requested => :l_url_requested)';
311:
312: icx_sec.g_window_cookie_name := 'Y';
313:
314: 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);
315:
316: l_sso_user_name := '1234567890123456789012345678901234567890';
317: l_ip_address := '123.456.678.901';
318: l_sso_time_remaining := 1234567890;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 339: dbms_sql.close_cursor(l_call);

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

Line 554: l_call := dbms_sql.open_cursor;

550: IF ((nvl(l_apps_sso,'SSWA')='SSO_SDK') OR (nvl(l_apps_sso,'SSWA')='SSWA_SSO')) THEN
551:
552: l_listener_token := OracleSSWA.listener_token;
553:
554: l_call := dbms_sql.open_cursor;
555: -- l_gen_redirect_url:= wwsec_sso_enabler.generate_redirect(p_lsnr_token => l_listener_token,
556: -- p_url_requested => l_urlrequested,
557: -- p_url_cancel => l_urlcancel);
558: l_procedure_call := ':l_gen_redirect_url := wwsec_sso_enabler.generate_redirect'||

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

559: '(p_lsnr_token => :l_listener_token'||
560: ',p_url_requested => :l_urlrequested'||
561: ',p_url_cancel => :l_urlcancel)';
562:
563: dbms_sql.parse(l_call,'declare l_gen_redirect_url varchar2(32000); begin '||l_procedure_call||'; end;',dbms_sql.native);
564:
565: l_gen_redirect_url := '';
566: for i in 1..100 loop -- set l_gen_redirect_url to 2000 characters
567: l_gen_redirect_url := l_gen_redirect_url||'12345678901234567890';

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

566: for i in 1..100 loop -- set l_gen_redirect_url to 2000 characters
567: l_gen_redirect_url := l_gen_redirect_url||'12345678901234567890';
568: end loop;
569:
570: dbms_sql.bind_variable(l_call,'l_gen_redirect_url',l_gen_redirect_url);
571: dbms_sql.bind_variable(l_call,'l_listener_token',l_listener_token);
572: dbms_sql.bind_variable(l_call,'l_urlrequested',l_urlrequested);
573: dbms_sql.bind_variable(l_call,'l_urlcancel',l_urlcancel);
574:

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

567: l_gen_redirect_url := l_gen_redirect_url||'12345678901234567890';
568: end loop;
569:
570: dbms_sql.bind_variable(l_call,'l_gen_redirect_url',l_gen_redirect_url);
571: dbms_sql.bind_variable(l_call,'l_listener_token',l_listener_token);
572: dbms_sql.bind_variable(l_call,'l_urlrequested',l_urlrequested);
573: dbms_sql.bind_variable(l_call,'l_urlcancel',l_urlcancel);
574:
575: l_dummy := dbms_sql.execute(l_call);

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

568: end loop;
569:
570: dbms_sql.bind_variable(l_call,'l_gen_redirect_url',l_gen_redirect_url);
571: dbms_sql.bind_variable(l_call,'l_listener_token',l_listener_token);
572: dbms_sql.bind_variable(l_call,'l_urlrequested',l_urlrequested);
573: dbms_sql.bind_variable(l_call,'l_urlcancel',l_urlcancel);
574:
575: l_dummy := dbms_sql.execute(l_call);
576:

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

569:
570: dbms_sql.bind_variable(l_call,'l_gen_redirect_url',l_gen_redirect_url);
571: dbms_sql.bind_variable(l_call,'l_listener_token',l_listener_token);
572: dbms_sql.bind_variable(l_call,'l_urlrequested',l_urlrequested);
573: dbms_sql.bind_variable(l_call,'l_urlcancel',l_urlcancel);
574:
575: l_dummy := dbms_sql.execute(l_call);
576:
577: dbms_sql.variable_value(l_call,'l_gen_redirect_url',l_gen_redirect_url);

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

571: dbms_sql.bind_variable(l_call,'l_listener_token',l_listener_token);
572: dbms_sql.bind_variable(l_call,'l_urlrequested',l_urlrequested);
573: dbms_sql.bind_variable(l_call,'l_urlcancel',l_urlcancel);
574:
575: l_dummy := dbms_sql.execute(l_call);
576:
577: dbms_sql.variable_value(l_call,'l_gen_redirect_url',l_gen_redirect_url);
578:
579: dbms_sql.close_cursor(l_call);

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

573: dbms_sql.bind_variable(l_call,'l_urlcancel',l_urlcancel);
574:
575: l_dummy := dbms_sql.execute(l_call);
576:
577: dbms_sql.variable_value(l_call,'l_gen_redirect_url',l_gen_redirect_url);
578:
579: dbms_sql.close_cursor(l_call);
580:
581: END IF;--apps_sso profile

Line 579: dbms_sql.close_cursor(l_call);

575: l_dummy := dbms_sql.execute(l_call);
576:
577: dbms_sql.variable_value(l_call,'l_gen_redirect_url',l_gen_redirect_url);
578:
579: dbms_sql.close_cursor(l_call);
580:
581: END IF;--apps_sso profile
582: owa_util.redirect_url(l_gen_redirect_url);
583:

Line 1121: l_call := dbms_sql.open_cursor;

1117: -- p_url_requested => l_urlrequested,
1118: -- p_url_cancel => l_urlcancel);
1119:
1120:
1121: l_call := dbms_sql.open_cursor;
1122:
1123: l_procedure_call := ':l_gen_redirect_url := wwsec_sso_enabler.generate_redirect'||
1124: '(p_lsnr_token => :l_listener_token'||
1125: ',p_url_requested => :l_urlrequested'||

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

1124: '(p_lsnr_token => :l_listener_token'||
1125: ',p_url_requested => :l_urlrequested'||
1126: ',p_url_cancel => :l_urlcancel)';
1127:
1128: dbms_sql.parse(l_call,'declare l_gen_redirect_url varchar2(32000); begin '||l_procedure_call||'; end;',dbms_sql.native);
1129:
1130: l_gen_redirect_url := '';
1131: for i in 1..100 loop -- set l_gen_redirect_url to 2000 characters
1132: l_gen_redirect_url := l_gen_redirect_url||'12345678901234567890';

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

1131: for i in 1..100 loop -- set l_gen_redirect_url to 2000 characters
1132: l_gen_redirect_url := l_gen_redirect_url||'12345678901234567890';
1133: end loop;
1134:
1135: dbms_sql.bind_variable(l_call,'l_gen_redirect_url',l_gen_redirect_url);
1136: dbms_sql.bind_variable(l_call,'l_listener_token',l_listener_token);
1137: dbms_sql.bind_variable(l_call,'l_urlrequested',l_urlrequested);
1138: dbms_sql.bind_variable(l_call,'l_urlcancel',l_urlcancel);
1139: l_dummy := dbms_sql.execute(l_call);

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

1132: l_gen_redirect_url := l_gen_redirect_url||'12345678901234567890';
1133: end loop;
1134:
1135: dbms_sql.bind_variable(l_call,'l_gen_redirect_url',l_gen_redirect_url);
1136: dbms_sql.bind_variable(l_call,'l_listener_token',l_listener_token);
1137: dbms_sql.bind_variable(l_call,'l_urlrequested',l_urlrequested);
1138: dbms_sql.bind_variable(l_call,'l_urlcancel',l_urlcancel);
1139: l_dummy := dbms_sql.execute(l_call);
1140: dbms_sql.variable_value(l_call,'l_gen_redirect_url',l_gen_redirect_url);

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

1133: end loop;
1134:
1135: dbms_sql.bind_variable(l_call,'l_gen_redirect_url',l_gen_redirect_url);
1136: dbms_sql.bind_variable(l_call,'l_listener_token',l_listener_token);
1137: dbms_sql.bind_variable(l_call,'l_urlrequested',l_urlrequested);
1138: dbms_sql.bind_variable(l_call,'l_urlcancel',l_urlcancel);
1139: l_dummy := dbms_sql.execute(l_call);
1140: dbms_sql.variable_value(l_call,'l_gen_redirect_url',l_gen_redirect_url);
1141:

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

1134:
1135: dbms_sql.bind_variable(l_call,'l_gen_redirect_url',l_gen_redirect_url);
1136: dbms_sql.bind_variable(l_call,'l_listener_token',l_listener_token);
1137: dbms_sql.bind_variable(l_call,'l_urlrequested',l_urlrequested);
1138: dbms_sql.bind_variable(l_call,'l_urlcancel',l_urlcancel);
1139: l_dummy := dbms_sql.execute(l_call);
1140: dbms_sql.variable_value(l_call,'l_gen_redirect_url',l_gen_redirect_url);
1141:
1142: dbms_sql.close_cursor(l_call);

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

1135: dbms_sql.bind_variable(l_call,'l_gen_redirect_url',l_gen_redirect_url);
1136: dbms_sql.bind_variable(l_call,'l_listener_token',l_listener_token);
1137: dbms_sql.bind_variable(l_call,'l_urlrequested',l_urlrequested);
1138: dbms_sql.bind_variable(l_call,'l_urlcancel',l_urlcancel);
1139: l_dummy := dbms_sql.execute(l_call);
1140: dbms_sql.variable_value(l_call,'l_gen_redirect_url',l_gen_redirect_url);
1141:
1142: dbms_sql.close_cursor(l_call);
1143:

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

1136: dbms_sql.bind_variable(l_call,'l_listener_token',l_listener_token);
1137: dbms_sql.bind_variable(l_call,'l_urlrequested',l_urlrequested);
1138: dbms_sql.bind_variable(l_call,'l_urlcancel',l_urlcancel);
1139: l_dummy := dbms_sql.execute(l_call);
1140: dbms_sql.variable_value(l_call,'l_gen_redirect_url',l_gen_redirect_url);
1141:
1142: dbms_sql.close_cursor(l_call);
1143:
1144: RETURN l_gen_redirect_url;

Line 1142: dbms_sql.close_cursor(l_call);

1138: dbms_sql.bind_variable(l_call,'l_urlcancel',l_urlcancel);
1139: l_dummy := dbms_sql.execute(l_call);
1140: dbms_sql.variable_value(l_call,'l_gen_redirect_url',l_gen_redirect_url);
1141:
1142: dbms_sql.close_cursor(l_call);
1143:
1144: RETURN l_gen_redirect_url;
1145: END;
1146: