DBA Data[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;