DBA Data[Home] [Help]

APPS.XNP_WSGL dependencies on OWA_UTIL

Line 140: LayoutData(owa_util.get_cgi_env('SERVER_SOFTWARE'));

136: end loop;
137: if not p_full then
138: LayoutRowStart;
139: LayoutData(MsgGetText(105,XNP_WSGLM.DSP105_WEB_SERVER));
140: LayoutData(owa_util.get_cgi_env('SERVER_SOFTWARE'));
141: LayoutRowEnd;
142: LayoutRowStart;
143: LayoutData(MsgGetText(106,XNP_WSGLM.DSP106_WEB_BROWSER));
144: LayoutData(owa_util.get_cgi_env('HTTP_USER_AGENT'));

Line 144: LayoutData(owa_util.get_cgi_env('HTTP_USER_AGENT'));

140: LayoutData(owa_util.get_cgi_env('SERVER_SOFTWARE'));
141: LayoutRowEnd;
142: LayoutRowStart;
143: LayoutData(MsgGetText(106,XNP_WSGLM.DSP106_WEB_BROWSER));
144: LayoutData(owa_util.get_cgi_env('HTTP_USER_AGENT'));
145: LayoutRowEnd;
146: LayoutRowStart;
147: LayoutData(MsgGetText(125,XNP_WSGLM.DSP125_REPOS_APPSYS));
148: LayoutData(p_app);

Line 158: owa_util.print_cgi_env;

154: end if;
155: LayoutClose;
156: if p_full then
157: htp.header(LayNumberOfPages, MsgGetText(104,XNP_WSGLM.DSP104_ENVIRONMENT));
158: owa_util.print_cgi_env;
159: ClosePageBody;
160: end if;
161: exception
162: when others then

Line 178: browser varchar2(2000) := owa_util.get_cgi_env ('HTTP_USER_AGENT');

174: --------------------------------------------------------------------------------
175:
176: function IsSupported (feature in varchar2) return boolean is
177:
178: browser varchar2(2000) := owa_util.get_cgi_env ('HTTP_USER_AGENT');
179: featureSupport boolean := True;
180:
181: begin
182:

Line 1295: -- Use owa_util.get_cgi_env('http_user_agent') to get the

1291: function TablesSupported return boolean is
1292: begin
1293: -- This function can be modified if it is anticipated that
1294: -- the server/browser combination does not support tables
1295: -- Use owa_util.get_cgi_env('http_user_agent') to get the
1296: -- the name of the browser being used, and construct a test
1297: -- based on that. Default behaviour is just to return true
1298: -- as all common browsers support HTML tables.
1299: return true;

Line 2265: remote_user := upper(owa_util.get_cgi_env('REMOTE_USER'));

2261: function GetUser return varchar2 is
2262: remote_user varchar2(30);
2263: begin
2264: begin
2265: remote_user := upper(owa_util.get_cgi_env('REMOTE_USER'));
2266: exception
2267: when others then
2268: remote_user := null;
2269: end;

Line 2282: port_number varchar2(10) := ltrim(rtrim(owa_util.get_cgi_env('SERVER_PORT')));

2278: -- Parameters:
2279: --
2280: --------------------------------------------------------------------------------
2281: procedure RegisterURL(p_url in varchar2) is
2282: port_number varchar2(10) := ltrim(rtrim(owa_util.get_cgi_env('SERVER_PORT')));
2283: begin
2284: if p_url is null then
2285: URLComplete := true;
2286: elsif not URLComplete then

Line 2287: CurrentURL := 'http://'||owa_util.get_cgi_env('SERVER_NAME');

2283: begin
2284: if p_url is null then
2285: URLComplete := true;
2286: elsif not URLComplete then
2287: CurrentURL := 'http://'||owa_util.get_cgi_env('SERVER_NAME');
2288: if port_number is not null then
2289: CurrentURL := CurrentURL||':'||port_number;
2290: end if;
2291: CurrentURL := CurrentURL||owa_util.get_cgi_env('SCRIPT_NAME')||'/'||p_url;

Line 2291: CurrentURL := CurrentURL||owa_util.get_cgi_env('SCRIPT_NAME')||'/'||p_url;

2287: CurrentURL := 'http://'||owa_util.get_cgi_env('SERVER_NAME');
2288: if port_number is not null then
2289: CurrentURL := CurrentURL||':'||port_number;
2290: end if;
2291: CurrentURL := CurrentURL||owa_util.get_cgi_env('SCRIPT_NAME')||'/'||p_url;
2292: end if;
2293: exception
2294: when others then
2295: raise_application_error(-20000, 'XNP_WSGL.RegisterURL
'||SQLERRM);

Line 2310: if (owa_util.get_cgi_env('PATH_INFO') <> lower(owa_util.get_cgi_env('PATH_INFO')))then

2306: --------------------------------------------------------------------------------
2307: function NotLowerCase return boolean is
2308: begin
2309: URLComplete := true;
2310: if (owa_util.get_cgi_env('PATH_INFO') <> lower(owa_util.get_cgi_env('PATH_INFO')))then
2311: htp.htmlOpen;
2312: htp.headOpen;
2313: RefreshURL;
2314: htp.headClose;

Line 2351: path_info varchar2(1000):= substr(owa_util.get_cgi_env('PATH_INFO'),2);

2347: -- Parameters:
2348: --
2349: --------------------------------------------------------------------------------
2350: function ExternalCall(p_proc in varchar2) return boolean is
2351: path_info varchar2(1000):= substr(owa_util.get_cgi_env('PATH_INFO'),2);
2352: http_referrer varchar2(1000);
2353: pos_host number;
2354: pos_script number;
2355: pos_modname number;

Line 2361: if (lower(p_proc) <> lower(substr(owa_util.get_cgi_env('PATH_INFO'),2))) then

2357: begin
2358: URLComplete := true;
2359: -- if this procedue is not the one in URL, then it must have been called
2360: -- directly as a procedure call, so just return false
2361: if (lower(p_proc) <> lower(substr(owa_util.get_cgi_env('PATH_INFO'),2))) then
2362: return false;
2363: end if;
2364: http_referrer := owa_util.get_cgi_env('HTTP_REFERER');
2365: if http_referrer is null then

Line 2364: http_referrer := owa_util.get_cgi_env('HTTP_REFERER');

2360: -- directly as a procedure call, so just return false
2361: if (lower(p_proc) <> lower(substr(owa_util.get_cgi_env('PATH_INFO'),2))) then
2362: return false;
2363: end if;
2364: http_referrer := owa_util.get_cgi_env('HTTP_REFERER');
2365: if http_referrer is null then
2366: http_referrer := owa_util.get_cgi_env('HTTP_REFERRER');
2367: end if;
2368: -- some browsers store octal values for non alphanumerics in env vars

Line 2366: http_referrer := owa_util.get_cgi_env('HTTP_REFERRER');

2362: return false;
2363: end if;
2364: http_referrer := owa_util.get_cgi_env('HTTP_REFERER');
2365: if http_referrer is null then
2366: http_referrer := owa_util.get_cgi_env('HTTP_REFERRER');
2367: end if;
2368: -- some browsers store octal values for non alphanumerics in env vars
2369: http_referrer := replace(http_referrer,'%24','$');
2370:

Line 2371: pos_host := instr(http_referrer, '//'||owa_util.get_cgi_env('SERVER_NAME'));

2367: end if;
2368: -- some browsers store octal values for non alphanumerics in env vars
2369: http_referrer := replace(http_referrer,'%24','$');
2370:
2371: pos_host := instr(http_referrer, '//'||owa_util.get_cgi_env('SERVER_NAME'));
2372: pos_script := instr(http_referrer, owa_util.get_cgi_env('SCRIPT_NAME'));
2373: pos_dollar := instr(path_info,'$');
2374: pos_modname := instr(lower(http_referrer), lower(substr(path_info, 1, pos_dollar)));
2375: if (pos_host <> 0 and pos_script > pos_host and pos_modname > pos_script) then

Line 2372: pos_script := instr(http_referrer, owa_util.get_cgi_env('SCRIPT_NAME'));

2368: -- some browsers store octal values for non alphanumerics in env vars
2369: http_referrer := replace(http_referrer,'%24','$');
2370:
2371: pos_host := instr(http_referrer, '//'||owa_util.get_cgi_env('SERVER_NAME'));
2372: pos_script := instr(http_referrer, owa_util.get_cgi_env('SCRIPT_NAME'));
2373: pos_dollar := instr(path_info,'$');
2374: pos_modname := instr(lower(http_referrer), lower(substr(path_info, 1, pos_dollar)));
2375: if (pos_host <> 0 and pos_script > pos_host and pos_modname > pos_script) then
2376: return false;

Line 2398: if (lower(p_proc) = lower(substr(owa_util.get_cgi_env('PATH_INFO'),2))) then

2394: --------------------------------------------------------------------------------
2395: function CalledDirect(p_proc in varchar2) return boolean is
2396: begin
2397: URLComplete := true;
2398: if (lower(p_proc) = lower(substr(owa_util.get_cgi_env('PATH_INFO'),2))) then
2399: DisplayMessage(MESS_ERROR, MsgGetText(231,XNP_WSGLM.MSG231_ACCESS_DENIED));
2400: return true;
2401: else
2402: return false;

Line 2472: modname := substr(owa_util.get_cgi_env('PATH_INFO'),2,30);

2468: p_close in boolean) is
2469: thisCookie owa_cookie.cookie;
2470: modname varchar2(30);
2471: begin
2472: modname := substr(owa_util.get_cgi_env('PATH_INFO'),2,30);
2473: modname := upper( substr(modname, 1, instr(modname,'$')) );
2474: if not URLCookieSet and LayNumberOfPages = 0 then
2475: if p_open then
2476: owa_util.mime_header('text/html',FALSE);

Line 2476: owa_util.mime_header('text/html',FALSE);

2472: modname := substr(owa_util.get_cgi_env('PATH_INFO'),2,30);
2473: modname := upper( substr(modname, 1, instr(modname,'$')) );
2474: if not URLCookieSet and LayNumberOfPages = 0 then
2475: if p_open then
2476: owa_util.mime_header('text/html',FALSE);
2477: end if;
2478: if p_level is not null then
2479: owa_cookie.send('WSG$'||modname||'URL'||to_char(p_level),
2480: CurrentURL,

Line 2482: owa_util.get_cgi_env('SCRIPT_NAME'),

2478: if p_level is not null then
2479: owa_cookie.send('WSG$'||modname||'URL'||to_char(p_level),
2480: CurrentURL,
2481: null,
2482: owa_util.get_cgi_env('SCRIPT_NAME'),
2483: owa_util.get_cgi_env('SERVER_NAME'));
2484: owa_cookie.send('WSG$'||modname||'CAP'||to_char(p_level),
2485: replace(p_caption,' ','_'),
2486: null,

Line 2483: owa_util.get_cgi_env('SERVER_NAME'));

2479: owa_cookie.send('WSG$'||modname||'URL'||to_char(p_level),
2480: CurrentURL,
2481: null,
2482: owa_util.get_cgi_env('SCRIPT_NAME'),
2483: owa_util.get_cgi_env('SERVER_NAME'));
2484: owa_cookie.send('WSG$'||modname||'CAP'||to_char(p_level),
2485: replace(p_caption,' ','_'),
2486: null,
2487: owa_util.get_cgi_env('SCRIPT_NAME'),

Line 2487: owa_util.get_cgi_env('SCRIPT_NAME'),

2483: owa_util.get_cgi_env('SERVER_NAME'));
2484: owa_cookie.send('WSG$'||modname||'CAP'||to_char(p_level),
2485: replace(p_caption,' ','_'),
2486: null,
2487: owa_util.get_cgi_env('SCRIPT_NAME'),
2488: owa_util.get_cgi_env('SERVER_NAME'));
2489: end if;
2490: if p_close then
2491: owa_util.http_header_close;

Line 2488: owa_util.get_cgi_env('SERVER_NAME'));

2484: owa_cookie.send('WSG$'||modname||'CAP'||to_char(p_level),
2485: replace(p_caption,' ','_'),
2486: null,
2487: owa_util.get_cgi_env('SCRIPT_NAME'),
2488: owa_util.get_cgi_env('SERVER_NAME'));
2489: end if;
2490: if p_close then
2491: owa_util.http_header_close;
2492: end if;

Line 2491: owa_util.http_header_close;

2487: owa_util.get_cgi_env('SCRIPT_NAME'),
2488: owa_util.get_cgi_env('SERVER_NAME'));
2489: end if;
2490: if p_close then
2491: owa_util.http_header_close;
2492: end if;
2493: end if;
2494: if p_close then
2495: URLCookieSet := true;

Line 2520: modname := substr(owa_util.get_cgi_env('PATH_INFO'),2,30);

2516: next_level varchar2(3);
2517: pos number;
2518: begin
2519: if LayNumberOfPages = 1 then
2520: modname := substr(owa_util.get_cgi_env('PATH_INFO'),2,30);
2521: modname := upper( substr(modname, 1, instr(modname,'$')) );
2522: while l_levels is not null loop
2523: pos := instr(l_levels,'.',-1);
2524: next_level := substr(l_levels, pos+1);