APPS.ORACLESSWA dependencies on FND_WEB_SEC

Line 382: l_anon_name := fnd_web_sec.get_guest_username_pwd;

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

Line 756: l_guest_profile_value := fnd_web_sec.get_guest_username_pwd;

752: --get anonymous user info
753: -- fnd_profile.get(name => 'GUEST_USER_PWD',
754: -- val => l_guest_profile_value);
755: -- Using new api to retrieve GUEST credentials.
756: l_guest_profile_value := fnd_web_sec.get_guest_username_pwd;
757: l_guest_name := SUBSTR(l_guest_profile_value, 1, INSTR(l_guest_profile_value, '/') -1);
758: --l_guest_pwd := SUBSTR(l_guest_profile_value, INSTR(l_guest_profile_value, '/') + 1);
759: l_guest_name := upper(l_guest_name);
760: SELECT user_id

Line 915: l_guest_profile_value := fnd_web_sec.get_guest_username_pwd;

911: --get anonymous user info
912: -- fnd_profile.get(name => 'GUEST_USER_PWD',
913: -- val => l_guest_profile_value);
914: -- Using new api to retrieve GUEST credentials.
915: l_guest_profile_value := fnd_web_sec.get_guest_username_pwd;
916: l_guest_name := SUBSTR(l_guest_profile_value, 1, INSTR(l_guest_profile_value, '/') -1);
917: --l_guest_pwd := SUBSTR(l_guest_profile_value, INSTR(l_guest_profile_value, '/') + 1);
918: l_guest_name := upper(l_guest_name);
919: SELECT user_id

Line 987: l_guest_profile_value := fnd_web_sec.get_guest_username_pwd;

983: --get anonymous user info
984: -- fnd_profile.get(name => 'GUEST_USER_PWD',
985: -- val => l_guest_profile_value);
986: -- Using new api to retrieve GUEST credentials.
987: l_guest_profile_value := fnd_web_sec.get_guest_username_pwd;
988: l_guest_name := SUBSTR(l_guest_profile_value, 1, INSTR(l_guest_profile_value, '/') -1);
989: --l_guest_pwd := SUBSTR(l_guest_profile_value, INSTR(l_guest_profile_value, '/') + 1);
990: l_guest_name := upper(l_guest_name);
991: SELECT user_id