APPS.ORACLESSWA dependencies on FND_WEB_SEC

Line 380: l_anon_name := fnd_web_sec.get_guest_username_pwd;

376: END;
377: -- fnd_profile.get(name => 'GUEST_USER_PWD',
378: -- val => l_anon_name);
379: -- Using new api to retrieve GUEST credentials.
380: l_anon_name := fnd_web_sec.get_guest_username_pwd;
381:
382: IF l_anon_name IS NOT NULL THEN
383: l_anon_name := SUBSTR(l_anon_name, 1, INSTR(l_anon_name, '/') -1); -- profile is stored as user/passwd
384: BEGIN

Line 744: l_guest_profile_value := fnd_web_sec.get_guest_username_pwd;

740: --get anonymous user info
741: -- fnd_profile.get(name => 'GUEST_USER_PWD',
742: -- val => l_guest_profile_value);
743: -- Using new api to retrieve GUEST credentials.
744: l_guest_profile_value := fnd_web_sec.get_guest_username_pwd;
745: l_guest_name := SUBSTR(l_guest_profile_value, 1, INSTR(l_guest_profile_value, '/') -1);
746: --l_guest_pwd := SUBSTR(l_guest_profile_value, INSTR(l_guest_profile_value, '/') + 1);
747: l_guest_name := upper(l_guest_name);
748: SELECT user_id

Line 903: l_guest_profile_value := fnd_web_sec.get_guest_username_pwd;

899: --get anonymous user info
900: -- fnd_profile.get(name => 'GUEST_USER_PWD',
901: -- val => l_guest_profile_value);
902: -- Using new api to retrieve GUEST credentials.
903: l_guest_profile_value := fnd_web_sec.get_guest_username_pwd;
904: l_guest_name := SUBSTR(l_guest_profile_value, 1, INSTR(l_guest_profile_value, '/') -1);
905: --l_guest_pwd := SUBSTR(l_guest_profile_value, INSTR(l_guest_profile_value, '/') + 1);
906: l_guest_name := upper(l_guest_name);
907: SELECT user_id

Line 975: l_guest_profile_value := fnd_web_sec.get_guest_username_pwd;

971: --get anonymous user info
972: -- fnd_profile.get(name => 'GUEST_USER_PWD',
973: -- val => l_guest_profile_value);
974: -- Using new api to retrieve GUEST credentials.
975: l_guest_profile_value := fnd_web_sec.get_guest_username_pwd;
976: l_guest_name := SUBSTR(l_guest_profile_value, 1, INSTR(l_guest_profile_value, '/') -1);
977: --l_guest_pwd := SUBSTR(l_guest_profile_value, INSTR(l_guest_profile_value, '/') + 1);
978: l_guest_name := upper(l_guest_name);
979: SELECT user_id