DBA Data[Home] [Help]

APPS.CSM_HTML5_PKG dependencies on FND_USER_PKG

Line 1012: /* RETURN FND_USER_PKG.ValidateSSOLogin(p_user_name,l_password); -- Some may not have applied FND pre-req, they shd use "/local" */

1008: l_password := decrypt(p_user_name,decode(p_password));
1009:
1010: IF isOIDAuth(p_user_name) THEN
1011: --Bug 14057306
1012: /* RETURN FND_USER_PKG.ValidateSSOLogin(p_user_name,l_password); -- Some may not have applied FND pre-req, they shd use "/local" */
1013: execute immediate 'DECLARE x number:=0; BEGIN IF FND_USER_PKG.ValidateSSOLogin(:1,:2) THEN x:=1; END IF; :3:=x; END;' using p_user_name,l_password, out l_b;
1014:
1015: if l_b<>0 then
1016: RETURN TRUE;

Line 1013: execute immediate 'DECLARE x number:=0; BEGIN IF FND_USER_PKG.ValidateSSOLogin(:1,:2) THEN x:=1; END IF; :3:=x; END;' using p_user_name,l_password, out l_b;

1009:
1010: IF isOIDAuth(p_user_name) THEN
1011: --Bug 14057306
1012: /* RETURN FND_USER_PKG.ValidateSSOLogin(p_user_name,l_password); -- Some may not have applied FND pre-req, they shd use "/local" */
1013: execute immediate 'DECLARE x number:=0; BEGIN IF FND_USER_PKG.ValidateSSOLogin(:1,:2) THEN x:=1; END IF; :3:=x; END;' using p_user_name,l_password, out l_b;
1014:
1015: if l_b<>0 then
1016: RETURN TRUE;
1017: else

Line 1021: RETURN FND_USER_PKG.ValidateLogin(p_user_name,l_password);

1017: else
1018: RETURN FALSE;
1019: end if;
1020: ELSE
1021: RETURN FND_USER_PKG.ValidateLogin(p_user_name,l_password);
1022: END IF;
1023: END authenticate;
1024:
1025: procedure query_validate_user( p_user_name IN VARCHAR2,