DBA Data[Home] [Help]

APPS.FND_ORACLE_USER_PKG dependencies on FND_ORACLE_USER_PKG

Line 1: package body FND_ORACLE_USER_PKG as

1: package body FND_ORACLE_USER_PKG as
2: /* $Header: AFSCOUSB.pls 120.1 2005/07/02 03:08:50 appldev ship $ */
3:
4: ----------------------------------------------------------------------------
5: /* PRIVATE */

Line 80: fnd_oracle_user_pkg.load_row(

76: x_enabled_flag in VARCHAR2,
77: x_read_only_flag in VARCHAR2) IS
78: begin
79:
80: fnd_oracle_user_pkg.load_row(
81: x_oracle_username => x_oracle_username,
82: x_owner => x_owner,
83: x_encrypted_oracle_password => x_encrypted_oracle_password,
84: x_description => x_description,

Line 152: fnd_oracle_user_pkg.createoracleuser(

148: end if;
149: exception
150: when no_data_found then
151:
152: fnd_oracle_user_pkg.createoracleuser(
153: x_oracle_username,
154: x_owner,
155: x_encrypted_oracle_password,
156: x_description,

Line 173: -- newpass := fnd_oracle_user_pkg.getreencryptedpassword('SCOTT','NEWKEY');

169: -- Usage example in pl/sql
170: -- declare
171: -- newpass varchar2(100);
172: -- begin
173: -- newpass := fnd_oracle_user_pkg.getreencryptedpassword('SCOTT','NEWKEY');
174: -- end;
175: --
176: -- Input (Mandatory)
177: -- username: User Name

Line 186: end FND_ORACLE_USER_PKG;

182: begin
183: return (fnd_web_sec.get_reencrypted_oracle_pwd(username, newkey));
184: end;
185:
186: end FND_ORACLE_USER_PKG;