[Home] [Help]
PACKAGE: APPS.FND_OAM_METALINK_CREDS
Source
1 PACKAGE fnd_oam_metalink_creds AUTHID CURRENT_USER AS
2 /* $Header: AFOAMMCS.pls 120.2 2005/10/19 11:25:23 ilawler noship $ */
3
4 --
5 -- Name
6 -- put_credentials
7 --
8 -- Purpose
9 -- Stores the given metalink credentials for the given user in
10 -- fnd_oam_metalink_cred. If a row already exists for given username
11 -- it will update, otherwise it will insert a new row
12 --
13 -- Input Arguments
14 -- p_username - Applications username
15 -- p_metalink_userid - Metalink User id
16 -- p_metalink_password - Metalink password
17 -- p_email_address - Email address
18 -- Output Arguments
19 -- p_errmsg - Error message if any error occurs
20 -- p_retcode - Return code. 0 if success otherwise error.
21 -- Notes:
22 --
23 --
24 PROCEDURE put_credentials(
25 p_username varchar2,
26 p_metalink_userid varchar2,
27 p_metalink_password varchar2,
28 p_email_address varchar2,
29 p_errmsg OUT NOCOPY varchar2,
30 p_retcode OUT NOCOPY number);
31
32
33 --
34 -- Name
35 -- get_credentials
36 --
37 -- Purpose
38 -- Retrieves the given metalink credentials for the given user
39 --
40 -- Input Arguments
41 -- p_username - Applications username
42 --
43 -- Output Arguments
44 -- p_metalink_userid - Metalink User id
45 -- p_metalink_password - Metalink password
46 -- p_email_address - Email address
47 -- p_errmsg - Error message if any error occurs
48 -- p_retcode - Return code. 0 if success otherwise error.
49 -- Notes:
50 --
51 PROCEDURE get_credentials(
52 p_username varchar2,
53 p_metalink_userid OUT NOCOPY varchar2,
54 p_metalink_password OUT NOCOPY varchar2,
55 p_email_address OUT NOCOPY varchar2,
56 p_errmsg OUT NOCOPY varchar2,
57 p_retcode OUT NOCOPY number);
58
59 PROCEDURE test;
60
61 END fnd_oam_metalink_creds;