1 package FND_ORACLE_USER_PKG as
2 /* $Header: AFSCOUSS.pls 120.1 2005/07/02 03:08:54 appldev ship $ */
3
4 ----------------------------------------------------------------------------
5 --
6 -- LOAD_ROW (PUBLIC): used by the FNDLOAD not meant for public use
7 --
8 --
9 procedure LOAD_ROW (
10 x_oracle_username in VARCHAR2,
11 x_owner in VARCHAR2,
12 x_encrypted_oracle_password in VARCHAR2,
13 x_description in VARCHAR2,
14 x_enabled_flag in VARCHAR2,
15 x_read_only_flag in VARCHAR2);
16
17 --
18 -- GetReEncryptedPassword (PUBLIC)
19 -- Return oracle user password encrypted with new key. This just returns the
20 -- newly encrypted password. It does not set the password in
21 -- FND_ORACLE_USERID table.
22 --
23 -- Usage example in pl/sql
24 -- declare
25 -- newpass varchar2(100);
26 -- begin
27 -- newpass := fnd_oracle_user_pkg.getreencryptedpassword('SCOTT', 'NEWKEY');
28 -- end;
29 --
30 -- Input (Mandatory)
31 -- username: User Name
32 -- newkey New Key
33 --
34 function GetReEncryptedPassword(username varchar2,
35 newkey varchar2) return varchar2;
36
37 -- Overloaded!!
38
39 procedure LOAD_ROW (
40 x_oracle_username in VARCHAR2,
41 x_owner in VARCHAR2,
42 x_encrypted_oracle_password in VARCHAR2,
43 x_description in VARCHAR2,
44 x_enabled_flag in VARCHAR2,
45 x_read_only_flag in VARCHAR2,
46 x_custom_mode in VARCHAR2,
47 x_last_update_date in VARCHAR2);
48
49 end FND_ORACLE_USER_PKG;