1 PACKAGE AHL_UC_APPROVALS_PVT AS
2 /* $Header: AHLVUAPS.pls 120.1 2005/06/29 08:18:07 sagarwal noship $ */
3
4
5 --------------------------------------------------------------------------------------------
6 -- Start of Comments --
7 -- Procedure name : INITIATE_UC_APPROVALS
8 -- Type : Private
9 -- Function : This procedure is called to initiate the approval process for a Unit
10 -- Configuration, once the user submits it for Approvals.
11 -- Pre-reqs :
12 -- Parameters :
13 --
14 -- Standard IN Parameters :
15 -- p_api_version IN NUMBER Required
16 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_TRUE
17 -- p_commit IN VARCHAR2 Default FND_API.G_TRUE
18 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
19 -- Standard OUT Parameters :
20 -- x_return_status OUT VARCHAR2 Required
21 -- x_msg_count OUT NUMBER Required
22 -- x_msg_data OUT VARCHAR2 Required
23 --
24 -- INITIATE_UC_APPROVALS Parameters :
25 -- p_uc_header_id IN NUMBER Required
26 -- The header identifier of the Unit Configuration.
27 -- p_object_version_number IN NUMBER Required
28 -- The object version number of the Unit Configuration.
29 --
30 --
31 -- History:
32 -- 06/02/03 SBethi CREATED
33 --
34 -- Version :
35 -- Initial Version 1.0
36 --
37 -- End of Comments.
38 --------------------------------------------------------------------------------------------
39
40 PROCEDURE INITIATE_UC_APPROVALS(
41 p_api_version IN NUMBER,
42 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
43 p_commit IN VARCHAR2 := FND_API.G_FALSE,
44 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
45 p_uc_header_id IN NUMBER,
46 p_object_version_number IN NUMBER,
47 x_return_status OUT NOCOPY VARCHAR2,
48 x_msg_count OUT NOCOPY NUMBER,
49 x_msg_data OUT NOCOPY VARCHAR2
50
51 );
52
53 --------------------------------------------------------------------------------------------
54 -- Start of Comments --
55 -- Procedure name : COMPLETE_UC_APPROVAL
56 -- Type : Private
57 -- Function : This procedure is called internally to complete the Approval Process.
58 --
59 -- Pre-reqs :
60 -- Parameters :
61 --
62 -- Standard IN Parameters :
63 -- p_api_version IN NUMBER Required
64 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_TRUE
65 -- p_commit IN VARCHAR2 Default FND_API.G_TRUE
66 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
67 -- Standard OUT Parameters :
68 -- x_return_status OUT VARCHAR2 Required
69 -- x_msg_count OUT NUMBER Required
70 -- x_msg_data OUT VARCHAR2 Required
71 --
72 -- INITIATE_UC_APPROVALS Parameters :
73 -- p_uc_header_id IN NUMBER Required
74 -- The header identifier of the Unit Configuration.
75 -- p_object_version_number IN NUMBER Required
76 -- The object version number of the Unit Configuration.
77 -- p_approval_status IN VARCHAR2 Required
78 -- The approval status of the Unit Configuration after the approval process
79 --
80 -- History:
81 -- 06/02/03 SBethi CREATED
82 --
83 -- Version :
84 -- Initial Version 1.0
85 --
86 -- End of Comments.
87 --------------------------------------------------------------------------------------------
88
89 PROCEDURE COMPLETE_UC_APPROVAL(
90 p_api_version IN NUMBER,
91 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
92 p_commit IN VARCHAR2 := FND_API.G_FALSE,
93 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
94 p_uc_header_id IN NUMBER,
95 p_object_version_number IN NUMBER,
96 p_approval_status IN VARCHAR2,
97 x_return_status OUT NOCOPY VARCHAR2,
98 x_msg_count OUT NOCOPY NUMBER,
99 x_msg_data OUT NOCOPY VARCHAR2
100 );
101
102
103 --------------------------------------------------------------------------------------------
104 -- Start of Comments --
105 -- Procedure name : INITIATE_QUARANTINE
106 -- Type : Private
107 -- Function : This procedure is called to initiate the approval process for a Unit
108 -- Configuration Quarantine, once the user submits it for Approvals.
109 -- Pre-reqs :
110 -- Parameters :
111 --
112 -- Standard IN Parameters :
113 -- p_api_version IN NUMBER Required
114 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_TRUE
115 -- p_commit IN VARCHAR2 Default FND_API.G_TRUE
116 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
117 -- Standard OUT Parameters :
118 -- x_return_status OUT VARCHAR2 Required
119 -- x_msg_count OUT NUMBER Required
120 -- x_msg_data OUT VARCHAR2 Required
121 --
122 -- INITIATE_QUARANTINE Parameters :
123 -- p_uc_header_id IN NUMBER Required
124 -- The header identifier of the Unit Configuration.
125 -- p_object_version_number IN NUMBER Required
126 -- The object version number of the Unit Configuration.
127 --
128 -- History:
129 --
130 -- Version :
131 -- Initial Version 1.0
132 --
133 -- End of Comments.
134 --------------------------------------------------------------------------------------------
135
136 PROCEDURE INITIATE_QUARANTINE
137 (
138 p_api_version IN NUMBER,
139 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
140 p_commit IN VARCHAR2 := FND_API.G_FALSE,
141 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
142 p_uc_header_id IN NUMBER,
143 p_object_version_number IN NUMBER,
144 x_return_status OUT NOCOPY VARCHAR2,
145 x_msg_count OUT NOCOPY NUMBER,
146 x_msg_data OUT NOCOPY VARCHAR2
147 );
148
149
150 --------------------------------------------------------------------------------------------
151 -- Start of Comments --
152 -- Procedure name : INITIATE_DEACTIVATE_QUARANTINE
153 -- Type : Private
154 -- Function : This procedure is called to initiate the approval process for a Unit
155 -- Configuration deactivate Quarantine, once the user submits it for Approvals.
156 -- Pre-reqs :
157 -- Parameters :
158 --
159 -- Standard IN Parameters :
160 -- p_api_version IN NUMBER Required
161 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_TRUE
162 -- p_commit IN VARCHAR2 Default FND_API.G_TRUE
163 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
164 -- Standard OUT Parameters :
165 -- x_return_status OUT VARCHAR2 Required
166 -- x_msg_count OUT NUMBER Required
167 -- x_msg_data OUT VARCHAR2 Required
168 --
169 -- INITIATE_DEACTIVATE_QUARANTINE Parameters :
170 -- p_uc_header_id IN NUMBER Required
171 -- The header identifier of the Unit Configuration.
172 -- p_object_version_number IN NUMBER Required
173 -- The object version number of the Unit Configuration.
174 --
175 -- History:
176 --
177 -- Version :
178 -- Initial Version 1.0
179 --
180 -- End of Comments.
181 --------------------------------------------------------------------------------------------
182
183 PROCEDURE INITIATE_DEACTIVATE_QUARANTINE
184 (
185 p_api_version IN NUMBER,
186 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
187 p_commit IN VARCHAR2 := FND_API.G_FALSE,
188 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
189 p_uc_header_id IN NUMBER,
190 p_object_version_number IN NUMBER,
191 x_return_status OUT NOCOPY VARCHAR2,
192 x_msg_count OUT NOCOPY NUMBER,
193 x_msg_data OUT NOCOPY VARCHAR2
194 );
195
196
197 --------------------------------------------------------------------------------------------
198 -- Start of Comments --
199 -- Procedure name : COMPLETE_QUARANTINE_APPROVAL
200 -- Type : Private
201 -- Function : This procedure is called internally to complete the Approval Process.
202 --
203 -- Pre-reqs :
204 -- Parameters :
205 --
206 -- Standard IN Parameters :
207 -- p_api_version IN NUMBER Required
208 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_TRUE
209 -- p_commit IN VARCHAR2 Default FND_API.G_TRUE
210 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
211 -- Standard OUT Parameters :
212 -- x_return_status OUT VARCHAR2 Required
213 -- x_msg_count OUT NUMBER Required
214 -- x_msg_data OUT VARCHAR2 Required
215 --
216 -- COMPLETE_QUARANTINE_APPROVAL Parameters :
217 -- p_uc_header_id IN NUMBER Required
218 -- The header identifier of the Unit Configuration.
219 -- p_object_version_number IN NUMBER Required
220 -- The object version number of the Unit Configuration.
221 -- p_approval_status IN VARCHAR2 Required
222 -- The approval status of the Unit Configuration after the approval process
223 --
224 -- History:
225 --
226 -- Version :
227 -- Initial Version 1.0
228 --
229 -- End of Comments.
230 --------------------------------------------------------------------------------------------
231 PROCEDURE COMPLETE_QUARANTINE_APPROVAL(
232 p_api_version IN NUMBER,
233 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
234 p_commit IN VARCHAR2 := FND_API.G_FALSE,
235 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
236 p_uc_header_id IN NUMBER,
237 p_object_version_number IN NUMBER,
238 p_approval_status IN VARCHAR2,
239 x_return_status OUT NOCOPY VARCHAR2,
240 x_msg_count OUT NOCOPY NUMBER,
241 x_msg_data OUT NOCOPY VARCHAR2
242 );
243
244
245
246 END AHL_UC_APPROVALS_PVT;