[Home] [Help]
PACKAGE: APPS.AHL_MC_MASTERCONFIG_PVT
Source
1 PACKAGE AHL_MC_MasterConfig_PVT AUTHID CURRENT_USER AS
2 /* $Header: AHLVMCXS.pls 120.1.12020000.2 2012/12/10 14:01:01 shnatu ship $ */
3
4 G_PKG_NAME CONSTANT VARCHAR2(30) := 'AHL_MC_MasterConfig_PVT';
5
6 G_DML_CREATE CONSTANT VARCHAR2(1) := 'C';
7 G_DML_UPDATE CONSTANT VARCHAR2(1) := 'U';
8 G_DML_DELETE CONSTANT VARCHAR2(1) := 'D';
9 G_DML_COPY CONSTANT VARCHAR2(1) := 'X';
10
11 -------------------------------
12 -- Define records and tables --
13 -------------------------------
14 TYPE Header_Rec_Type IS RECORD
15 (
16 MC_HEADER_ID NUMBER,
17 NAME VARCHAR2(80),
18 DESCRIPTION VARCHAR2(240),
19 MC_ID NUMBER,
20 VERSION_NUMBER NUMBER := 0,
21 REVISION VARCHAR2(30),
22 MODEL_CODE VARCHAR2(30), -- SATHAPLI::Enigma code changes, 26-Aug-2008
23 MODEL_MEANING VARCHAR2(30), -- SATHAPLI::Enigma code changes, 26-Aug-2008
24 CONFIG_STATUS_CODE VARCHAR2(30) := 'DRAFT',
25 CONFIG_STATUS_MEANING VARCHAR2(80),
26 OBJECT_VERSION_NUMBER NUMBER := 1,
27 SECURITY_GROUP_ID NUMBER := NULL,
28 ATTRIBUTE_CATEGORY VARCHAR2(30),
29 ATTRIBUTE1 VARCHAR2(150),
30 ATTRIBUTE2 VARCHAR2(150),
31 ATTRIBUTE3 VARCHAR2(150),
32 ATTRIBUTE4 VARCHAR2(150),
33 ATTRIBUTE5 VARCHAR2(150),
34 ATTRIBUTE6 VARCHAR2(150),
35 ATTRIBUTE7 VARCHAR2(150),
36 ATTRIBUTE8 VARCHAR2(150),
37 ATTRIBUTE9 VARCHAR2(150),
38 ATTRIBUTE10 VARCHAR2(150),
39 ATTRIBUTE11 VARCHAR2(150),
40 ATTRIBUTE12 VARCHAR2(150),
41 ATTRIBUTE13 VARCHAR2(150),
42 ATTRIBUTE14 VARCHAR2(150),
43 ATTRIBUTE15 VARCHAR2(150),
44 OPERATION_FLAG VARCHAR2(1) := NULL
45 );
46
47 -----------------------
48 -- Define procedures --
49 -----------------------
50 -- Start of Comments --
51 --
52 -- Procedure name : Create_Master_Config
53 -- Type : Private
54 -- Function : Creates Master Configuration header and topnode
55 -- Pre-reqs :
56 --
57 -- Standard IN Parameters :
58 -- p_api_version IN NUMBER Required
59 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
60 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
61 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
62 --
63 -- Standard OUT Parameters :
64 -- x_return_status OUT VARCHAR2 Required
65 -- x_msg_count OUT NUMBER Required
66 -- x_msg_data OUT VARCHAR2 Required
67 --
68 -- Create_Master_Config Parameters :
69 -- p_x_mc_header_rec IN OUT Header_Rec_Type
70 -- p_x_node_rec IN OUT AHL_MC_Node_PVT.Node_Rec_Type
71 --
72 -- Version :
73 -- Initial Version 1.0
74 --
75 -- End of Comments --
76 PROCEDURE Create_Master_Config
77 (
78 p_api_version IN NUMBER,
79 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
80 p_commit IN VARCHAR2 := FND_API.G_FALSE,
81 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
82 x_return_status OUT NOCOPY VARCHAR2,
83 x_msg_count OUT NOCOPY NUMBER,
84 x_msg_data OUT NOCOPY VARCHAR2,
85 p_x_mc_header_rec IN OUT NOCOPY Header_Rec_Type,
86 p_x_node_rec IN OUT NOCOPY AHL_MC_Node_PVT.Node_Rec_Type
87
88 );
89
90 -- Start of Comments --
91 --
92 -- Procedure name : Modify_Master_Config
93 -- Type : Private
94 -- Function : Updates Master Configuration header and topnode
95 -- Pre-reqs :
96 --
97 -- Standard IN Parameters :
98 -- p_api_version IN NUMBER Required
99 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
100 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
101 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
102 --
103 -- Standard OUT Parameters :
104 -- x_return_status OUT VARCHAR2 Required
105 -- x_msg_count OUT NUMBER Required
106 -- x_msg_data OUT VARCHAR2 Required
107 --
108 -- Create_Master_Config Parameters :
109 -- p_x_mc_header_rec IN OUT Header_Rec_Type
110 -- p_x_node_rec IN OUT AHL_MC_Node_PVT.Node_Rec_Type
111 --
112 -- Version :
113 -- Initial Version 1.0
114 --
115 -- End of Comments --
116 PROCEDURE Modify_Master_Config
117 (
118 p_api_version IN NUMBER,
119 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
120 p_commit IN VARCHAR2 := FND_API.G_FALSE,
121 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
122 x_return_status OUT NOCOPY VARCHAR2,
123 x_msg_count OUT NOCOPY NUMBER,
124 x_msg_data OUT NOCOPY VARCHAR2,
125 p_x_mc_header_rec IN OUT NOCOPY Header_Rec_Type,
126 p_x_node_rec IN OUT NOCOPY AHL_MC_Node_PVT.Node_Rec_Type
127
128 );
129
130 -- Start of Comments --
131 --
132 -- Procedure name : Delete_Master_Config
133 -- Type : Private
134 -- Function : Deletes/Closes Master Configuration
135 -- Pre-reqs :
136 --
137 -- Standard IN Parameters :
138 -- p_api_version IN NUMBER Required
139 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
140 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
141 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
142 --
143 -- Standard OUT Parameters :
144 -- x_return_status OUT VARCHAR2 Required
145 -- x_msg_count OUT NUMBER Required
146 -- x_msg_data OUT VARCHAR2 Required
147 --
148 -- Create_Master_Config Parameters :
149 -- p_mc_header_id IN NUMBER
150 -- p_object_ver_num IN NUMBER
151 --
152 -- Version :
153 -- Initial Version 1.0
154 --
155 -- End of Comments --
156 PROCEDURE Delete_Master_Config
157 (
158 p_api_version IN NUMBER,
159 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
160 p_commit IN VARCHAR2 := FND_API.G_FALSE,
161 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
162 x_return_status OUT NOCOPY VARCHAR2,
163 x_msg_count OUT NOCOPY NUMBER,
164 x_msg_data OUT NOCOPY VARCHAR2,
165 p_mc_header_id IN NUMBER,
166 p_object_ver_num IN NUMBER
167
168 );
169
170 -- Start of Comments --
171 --
172 -- Procedure name : Copy_Master_Config
173 -- Type : Private
174 -- Function : Makes a copy of an existing Master Configuration
175 -- Pre-reqs :
176 --
177 -- Standard IN Parameters :
178 -- p_api_version IN NUMBER Required
179 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
180 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
181 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
182 --
183 -- Standard OUT Parameters :
184 -- x_return_status OUT VARCHAR2 Required
185 -- x_msg_count OUT NUMBER Required
186 -- x_msg_data OUT VARCHAR2 Required
187 --
188 -- Create_Master_Config Parameters :
189 -- p_x_mc_header_rec IN OUT Header_Rec_Type
190 -- p_x_node_rec IN OUT AHL_MC_Node_PVT.Node_Rec_Type
191 --
192 -- Version :
193 -- Initial Version 1.0
194 --
195 -- End of Comments --
196 PROCEDURE Copy_Master_Config
197 (
198 p_api_version IN NUMBER,
199 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
200 p_commit IN VARCHAR2 := FND_API.G_FALSE,
201 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
202 x_return_status OUT NOCOPY VARCHAR2,
203 x_msg_count OUT NOCOPY NUMBER,
204 x_msg_data OUT NOCOPY VARCHAR2,
205 p_x_mc_header_rec IN OUT NOCOPY Header_Rec_Type,
206 p_x_node_rec IN OUT NOCOPY AHL_MC_Node_PVT.Node_Rec_Type
207
208 );
209
210 -- Start of Comments --
211 --
212 -- Procedure name : Create_MC_Revision
213 -- Type : Private
214 -- Function : Creates a revision of an exising Master Configuration
215 -- Pre-reqs :
216 --
217 -- Standard IN Parameters :
218 -- p_api_version IN NUMBER Required
219 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
220 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
221 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
222 --
223 -- Standard OUT Parameters :
224 -- x_return_status OUT VARCHAR2 Required
225 -- x_msg_count OUT NUMBER Required
226 -- x_msg_data OUT VARCHAR2 Required
227 --
228 -- Create_Master_Config Parameters :
229 -- p_x_mc_header_id IN OUT NUMBER
230 -- p_object_ver_num IN NUMBER
231 --
232 -- Version :
233 -- Initial Version 1.0
234 --
235 -- End of Comments --
236 PROCEDURE Create_MC_Revision
237 (
238 p_api_version IN NUMBER,
239 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
240 p_commit IN VARCHAR2 := FND_API.G_FALSE,
241 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
242 x_return_status OUT NOCOPY VARCHAR2,
243 x_msg_count OUT NOCOPY NUMBER,
244 x_msg_data OUT NOCOPY VARCHAR2,
245 p_x_mc_header_id IN OUT NOCOPY NUMBER,
246 p_object_ver_num IN NUMBER
247
248 );
249
250 -- Start of Comments --
251 --
252 -- Procedure name : Reopen_Master_Config
253 -- Type : Private
254 -- Function : Reopens a closed / expired Master Configuration
255 -- Pre-reqs :
256 --
257 -- Standard IN Parameters :
258 -- p_api_version IN NUMBER Required
259 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
260 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
261 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
262 --
263 -- Standard OUT Parameters :
264 -- x_return_status OUT VARCHAR2 Required
265 -- x_msg_count OUT NUMBER Required
266 -- x_msg_data OUT VARCHAR2 Required
267 --
268 -- Create_Master_Config Parameters :
269 -- p_mc_header_id IN NUMBER
270 -- p_object_ver_num IN NUMBER
271 --
272 -- Version :
273 -- Initial Version 1.0
274 --
275 -- End of Comments --
276 PROCEDURE Reopen_Master_Config
277 (
278 p_api_version IN NUMBER,
279 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
280 p_commit IN VARCHAR2 := FND_API.G_FALSE,
281 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
282 x_return_status OUT NOCOPY VARCHAR2,
283 x_msg_count OUT NOCOPY NUMBER,
284 x_msg_data OUT NOCOPY VARCHAR2,
285 p_mc_header_id IN NUMBER,
286 p_object_ver_num IN NUMBER
287
288 );
289
290 -- Start of Comments --
291 --
292 -- Procedure name : Initiate_MC_Approval
293 -- Type : Private
294 -- Function : Submits and starts approval process for Master Configuration
295 -- Pre-reqs :
296 --
297 -- Standard IN Parameters :
298 -- p_api_version IN NUMBER Required
299 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
300 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
301 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
302 --
303 -- Standard OUT Parameters :
304 -- x_return_status OUT VARCHAR2 Required
305 -- x_msg_count OUT NUMBER Required
306 -- x_msg_data OUT VARCHAR2 Required
307 --
308 -- Create_Master_Config Parameters :
309 -- p_mc_header_id IN NUMBER
310 -- p_object_ver_num IN NUMBER
311 --
312 -- Version :
313 -- Initial Version 1.0
314 --
315 -- End of Comments --
316 PROCEDURE Initiate_MC_Approval
317 (
318 p_api_version IN NUMBER,
319 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
320 p_commit IN VARCHAR2 := FND_API.G_FALSE,
321 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
322 x_return_status OUT NOCOPY VARCHAR2,
323 x_msg_count OUT NOCOPY NUMBER,
324 x_msg_data OUT NOCOPY VARCHAR2,
325 p_mc_header_id IN NUMBER,
326 p_object_ver_num IN NUMBER
327
328 );
329
330 End AHL_MC_MasterConfig_PVT;