DBA Data[Home] [Help]

APPS.FND_ORACLE_USER_PKG dependencies on FND_ORACLE_USERID

Line 45: update fnd_oracle_userid set

41: ouser_id);
42: if (ret = 'Y') then
43:
44: -- update the rest of the data except password
45: update fnd_oracle_userid set
46: last_update_date = sysdate,
47: last_updated_by = owner_id,
48: last_update_login = 0,
49: description = nvl(x_description, description),

Line 121: from fnd_oracle_userid

117:
118: begin
119: select LAST_UPDATED_BY, LAST_UPDATE_DATE
120: into db_luby, db_ludate
121: from fnd_oracle_userid
122: where oracle_username = x_oracle_username;
123:
124: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
125: db_ludate, X_CUSTOM_MODE)) then

Line 139: update fnd_oracle_userid set

135: if(enc_pwd is NULL) then
136: enc_pwd := 'INVALID';
137: end if;
138:
139: update fnd_oracle_userid set
140: last_update_date = f_ludate,
141: last_updated_by = f_luby,
142: last_update_login = 0,
143: description = nvl(x_description, description),

Line 167: -- FND_ORACLE_USERID table.

163: --
164: -- GetReEncryptedPassword (PUBLIC)
165: -- Return user password encrypted with new key. This just returns the
166: -- newly encrypted password. It does not set the password in
167: -- FND_ORACLE_USERID table.
168: --
169: -- Usage example in pl/sql
170: -- declare
171: -- newpass varchar2(100);