APPS.FND_OAM_METALINK_CREDS SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 52

        select user_id into v_userid
          from fnd_user where upper(user_name) = upper(p_username);

Line: 77

          select user_id into v_userid
           from fnd_oam_metalink_cred
           where user_id = v_userid;

Line: 81

          update fnd_oam_metalink_cred set
                metalink_user_id = p_metalink_userid,
                metalink_password = v_enc,
                email_address = p_email_address,
                last_updated_by = v_userid,
                last_update_date = sysdate,
                last_update_login = 0
            where user_id = v_userid;

Line: 91

            insert into fnd_oam_metalink_cred (
                user_id,
                metalink_user_id,
                metalink_password,
                email_address,
                created_by,
                creation_date,
                last_updated_by,
                last_update_date,
                last_update_login)
            values (
                v_userid,
                p_metalink_userid,
                v_enc,
                p_email_address,
                v_userid,
                sysdate,
                v_userid,
                sysdate,
                0);

Line: 155

        select  fom.metalink_user_id,
                fom.metalink_password,
                fom.email_address
         into   p_metalink_userid,
                v_enc,
                p_email_address
         from   fnd_oam_metalink_cred fom,
                fnd_user fu
         where  fu.user_id = fom.user_id
          and   upper(fu.user_name) = upper(p_username);