DBA Data[Home] [Help]

PACKAGE: APPS.DOM_WS_INTERFACE_PUB

Source


1 package DOM_WS_INTERFACE_PUB AUTHID CURRENT_USER AS
2 /*$Header: DOMPITFS.pls 120.7 2010/06/14 09:47:04 yjain ship $ */
3 
4 ----------------------------------------------------------------------------
5 -- 1. Add_OFO_Group_Member
6 ----------------------------------------------------------------------------
7 PROCEDURE Add_OFO_Group_Member (
8    p_api_version  IN  NUMBER,
9    p_init_msg_list  IN  VARCHAR2,
10    p_commit   IN  VARCHAR2,
11    p_group_id       IN  NUMBER,
12    p_member_id        IN  NUMBER,
13    x_return_status  OUT NOCOPY VARCHAR2,
14    x_msg_count    OUT NOCOPY NUMBER,
15    x_msg_data   OUT NOCOPY VARCHAR2
16    );
17    ------------------------------------------------------------------------
18     -- Start OF comments
19     -- API name  : Add_OFO_Group_Member
20     -- TYPE      : Public
21     -- Pre-reqs  : None
22     -- FUNCTION  : Add a member to the corresponding OFO Group.
23     --
24     --
25     -- Parameters:
26     --     IN    : p_api_version    IN  NUMBER  (required)
27     --      API Version of this procedure
28     --             p_init_msg_level IN  VARCHAR2  (optional)
29     --                  DEFAULT = FND_API.G_FALSE
30     --                  Indicates whether the message stack needs to be cleared
31     --             p_commit   IN  VARCHAR2  (optional)
32     --                  DEFAULT = FND_API.G_FALSE
33     --                  Indicates whether the data should be committed
34     --             p_group_id   IN  NUMBER  (required)
35     --      Group to which the member is being added
36     --      Eg., A Group
37     --             p_member_id  IN  VARCHAR2  (required)
38     --      Member which is to be added
39     --      Eg., PERSON
40     --
41     --     OUT   : x_return_status  OUT  NUMBER
42     --      Result of all the operations
43     --                    FND_API.G_RET_STS_SUCCESS if success
44     --                    FND_API.G_RET_STS_ERROR if error
45     --                    FND_API.G_RET_STS_UNEXP_ERROR if unexpected error
46     --             x_msg_count    OUT  NUMBER
47     --      number of messages in the message list
48     --             x_msg_data   OUT  VARCHAR2
49     --        if number of messages is 1, then this parameter
50     --      contains the message itself
51     --
52     -- Called From:
53     --    ego_party_pub.add_group_member
54     --
55     -- Version: Current Version 1.0
56     -- Previous Version :  None
57     -- Notes  :
58     --
59     -- END OF comments
60    ------------------------------------------------------------------------
61 
62 
63 
64 procedure Update_Files_Document_Status (
65    p_api_version        IN  NUMBER,
66    p_service_url        IN  VARCHAR2,
67    p_document_id        IN  NUMBER,
68    p_status             IN  VARCHAR2,
69    p_login_user_name    IN  VARCHAR2,
70    x_return_status      OUT NOCOPY VARCHAR2,
71    x_msg_count          OUT NOCOPY NUMBER,
72    x_msg_data           OUT NOCOPY VARCHAR2
73    );
74     ------------------------------------------------------------------------
75     -- Start OF comments
76     -- API name  : Update_Files_Document_Status
77     -- TYPE      : Public
78     -- Pre-reqs  : None
79     -- FUNCTION  : Update_Files_Document_Status
80     --
81     --
82     -- Parameters:
83     --     IN    : p_api_version    IN  NUMBER  (required)
84     --      API Version of this procedure
85     --      p_service_url   IN  VARCHAR2  (required)
86     --        Service url of the repository
87     --        Eg., 'http://stadm65.us.oracle.com/content/ws'
88     --      p_document_id IN  NUMBER  (required)
89     --        document id of the reposotiry. It is the dm_document_id from fnd_documents table.
90     --      p_status
91     --        the lookup code for the Approval/Reject status
92     --        Eg., APPROVED, REJECTED
93     --      p_login_user_name
94     --        Login user to connect to files repository
95     --
96     --     OUT   : x_return_status  OUT  NUMBER
97     --      Result of all the operations
98     --                    FND_API.G_RET_STS_SUCCESS if success
99     --                    FND_API.G_RET_STS_ERROR if error
100     --                    FND_API.G_RET_STS_UNEXP_ERROR if unexpected error
101     --             x_msg_count    OUT  NUMBER
102     --      number of messages in the message list
103     --             x_msg_data   OUT  VARCHAR2
104     --        if number of messages is 1, then this parameter
105     --      contains the message itself
106     --
107     -- Called From:
108     --    DOM_ATTACHMENT_UTIL_PKG.Change_Status
109     --
110     -- Version: Current Version 1.0
111     -- Previous Version :  None
112     -- Notes  :
113     --
114     -- END OF comments
115     ------------------------------------------------------------------------
116 
117 procedure Grant_Attachments_OCSRole (
118    p_api_version      IN  NUMBER,
119    p_service_url        IN  VARCHAR2,
120    p_family_id        IN  NUMBER,
121    p_role             IN  VARCHAR2,
122    p_user_name          IN  VARCHAR2,
123    p_user_login         IN  VARCHAR2,
124    x_return_status      OUT NOCOPY VARCHAR2,
125    x_msg_count          OUT NOCOPY NUMBER,
126    x_msg_data           OUT NOCOPY VARCHAR2
127    ) ;
128 
129 procedure Remove_Attachments_OCSRole (
130    p_api_version      IN  NUMBER,
131    p_service_url        IN  VARCHAR2,
132    p_family_id        IN  NUMBER,
133    p_role             IN  VARCHAR2,
134    p_user_name          IN  VARCHAR2,
135    p_user_login         IN  VARCHAR2,
136    x_return_status      OUT NOCOPY VARCHAR2,
137    x_msg_count          OUT NOCOPY NUMBER,
138    x_msg_data           OUT NOCOPY VARCHAR2
139    ) ;
140 
141 
142 --Bug 9697013
143 FUNCTION Get_WebService_Repositories
144   RETURN BOOLEAN;
145 
146 
147 END DOM_WS_INTERFACE_PUB;