1 package DOM_WS_INTERFACE_PUB AS
2 /*$Header: DOMPITFS.pls 120.6 2006/07/03 16:07:06 ysireesh noship $ */
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 END DOM_WS_INTERFACE_PUB;