[Home] [Help]
PACKAGE: APPS.AHL_MEL_CDL_HEADERS_PVT
Source
1 PACKAGE AHL_MEL_CDL_HEADERS_PVT AS
2 /* $Header: AHLVMEHS.pls 120.0 2005/07/04 02:58 tamdas noship $ */
3
4 G_APP_NAME CONSTANT VARCHAR2(3) := 'AHL'; -- Use for all FND_MESSAGE.SET_NAME calls
5 G_PKG_NAME CONSTANT VARCHAR2(30) := 'AHL_MEL_CDL_HEADERS_PVT'; -- Use for all debug messages, FND_API.COMPATIBLE_API_CALL, etc
6
7 -------------------------------
8 -- Define records and tables --
9 -------------------------------
10 TYPE Header_Rec_Type IS RECORD
11 (
12 MEL_CDL_HEADER_ID NUMBER,
13 OBJECT_VERSION_NUMBER NUMBER,
14 PC_NODE_ID NUMBER,
15 MEL_CDL_TYPE_CODE VARCHAR2 (30),
16 MEL_CDL_TYPE_MEANING VARCHAR2 (80),
17 STATUS_CODE VARCHAR2 (30),
18 STATUS_MEANING VARCHAR2 (80),
19 REVISION VARCHAR2 (30),
20 VERSION_NUMBER NUMBER,
21 REVISION_DATE DATE,
22 EXPIRED_DATE DATE,
23 ATTRIBUTE_CATEGORY VARCHAR2 (30),
24 ATTRIBUTE1 VARCHAR2 (150),
25 ATTRIBUTE2 VARCHAR2 (150),
26 ATTRIBUTE3 VARCHAR2 (150),
27 ATTRIBUTE4 VARCHAR2 (150),
28 ATTRIBUTE5 VARCHAR2 (150),
29 ATTRIBUTE6 VARCHAR2 (150),
30 ATTRIBUTE7 VARCHAR2 (150),
31 ATTRIBUTE8 VARCHAR2 (150),
32 ATTRIBUTE9 VARCHAR2 (150),
33 ATTRIBUTE10 VARCHAR2 (150),
34 ATTRIBUTE11 VARCHAR2 (150),
35 ATTRIBUTE12 VARCHAR2 (150),
36 ATTRIBUTE13 VARCHAR2 (150),
37 ATTRIBUTE14 VARCHAR2 (150),
38 ATTRIBUTE15 VARCHAR2 (150)
39 );
40
41 -----------------------
42 -- Define procedures --
43 -----------------------
44 -- Start of Comments --
45 --
46 -- Procedure name : Create_Mel_Cdl
47 -- Type : Private
48 -- Description : This procedure creates a MEL/CDL
49 -- Pre-reqs :
50 --
51 -- Standard IN Parameters :
52 -- p_api_version NUMBER Required
53 -- p_init_msg_list VARCHAR2 := FND_API.G_FALSE
54 -- p_commit VARCHAR2 := FND_API.G_FALSE
55 -- p_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL
56 -- p_default VARCHAR2 := FND_API.G_FALSE
57 -- p_module_type VARCHAR2 := NULL
58 --
59 -- Standard OUT Parameters :
60 -- x_return_status VARCHAR2 Required
61 -- x_msg_count NUMBER Required
62 -- x_msg_data VARCHAR2 Required
63 --
64 -- Procedure IN, OUT, IN/OUT params :
65 -- p_x_mel_cdl_header_rec Header_Rec_Type Required
66 --
67 -- Version :
68 -- Initial Version 1.0
69 --
70 -- End of Comments --
71 PROCEDURE Create_Mel_Cdl
72 (
73 -- Standard IN params
74 p_api_version IN NUMBER,
75 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
76 p_commit IN VARCHAR2 := FND_API.G_FALSE,
77 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
78 p_default IN VARCHAR2 := FND_API.G_FALSE,
79 p_module_type IN VARCHAR2 := NULL,
80 -- Standard OUT params
81 x_return_status OUT NOCOPY VARCHAR2,
82 x_msg_count OUT NOCOPY NUMBER,
83 x_msg_data OUT NOCOPY VARCHAR2,
84 -- Procedure IN, OUT, IN/OUT params
85 p_x_mel_cdl_header_rec IN OUT NOCOPY Header_Rec_Type
86 );
87
88 -- Start of Comments --
89 --
90 -- Procedure name : Update_Mel_Cdl
91 -- Type : Private
92 -- Description : This procedure updates a MEL/CDL
93 -- Pre-reqs :
94 --
95 -- Standard IN Parameters :
96 -- p_api_version NUMBER Required
97 -- p_init_msg_list VARCHAR2 := FND_API.G_FALSE
98 -- p_commit VARCHAR2 := FND_API.G_FALSE
99 -- p_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL
100 -- p_default VARCHAR2 := FND_API.G_FALSE
101 -- p_module_type VARCHAR2 := NULL
102 --
103 -- Standard OUT Parameters :
104 -- x_return_status VARCHAR2 Required
105 -- x_msg_count NUMBER Required
106 -- x_msg_data VARCHAR2 Required
107 --
108 -- Procedure IN, OUT, IN/OUT params :
109 -- p_x_mel_cdl_header_rec Header_Rec_Type Required
110 --
111 -- Version :
112 -- Initial Version 1.0
113 --
114 -- End of Comments --
115 PROCEDURE Update_Mel_Cdl
116 (
117 -- Standard IN params
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 p_default IN VARCHAR2 := FND_API.G_FALSE,
123 p_module_type IN VARCHAR2 := NULL,
124 -- Standard OUT params
125 x_return_status OUT NOCOPY VARCHAR2,
126 x_msg_count OUT NOCOPY NUMBER,
127 x_msg_data OUT NOCOPY VARCHAR2,
128 -- Procedure IN, OUT, IN/OUT params
129 p_x_mel_cdl_header_rec IN OUT NOCOPY Header_Rec_Type
130 );
131
132 -- Start of Comments --
133 --
134 -- Procedure name : Delete_Mel_Cdl
135 -- Type : Private
136 -- Description : This procedure deletes a MEL/CDL and its associations
137 -- Pre-reqs :
138 --
139 -- Standard IN Parameters :
140 -- p_api_version NUMBER Required
141 -- p_init_msg_list VARCHAR2 := FND_API.G_FALSE
142 -- p_commit VARCHAR2 := FND_API.G_FALSE
143 -- p_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL
144 -- p_default VARCHAR2 := FND_API.G_FALSE
145 -- p_module_type VARCHAR2 := NULL
146 --
147 -- Standard OUT Parameters :
148 -- x_return_status VARCHAR2 Required
149 -- x_msg_count NUMBER Required
150 -- x_msg_data VARCHAR2 Required
151 --
152 -- Procedure IN, OUT, IN/OUT params :
153 -- p_mel_cdl_header_id NUMBER Required
154 -- p_mel_cdl_object_version NUMBER Required
155 --
156 -- Version :
157 -- Initial Version 1.0
158 --
159 -- End of Comments --
160 PROCEDURE Delete_Mel_Cdl
161 (
162 -- Standard IN params
163 p_api_version IN NUMBER,
164 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
165 p_commit IN VARCHAR2 := FND_API.G_FALSE,
166 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
167 p_default IN VARCHAR2 := FND_API.G_FALSE,
168 p_module_type IN VARCHAR2 := NULL,
169 -- Standard OUT params
170 x_return_status OUT NOCOPY VARCHAR2,
171 x_msg_count OUT NOCOPY NUMBER,
172 x_msg_data OUT NOCOPY VARCHAR2,
173 -- Procedure IN, OUT, IN/OUT params
174 p_mel_cdl_header_id IN NUMBER,
175 p_mel_cdl_object_version IN NUMBER
176 );
177
178 -- Start of Comments --
179 --
180 -- Procedure name : Create_Mel_Cdl_Revision
181 -- Type : Private
182 -- Description : This procedure creates a new revision of an existing MEL/CDL and its associations
183 -- Pre-reqs :
184 --
185 -- Standard IN Parameters :
186 -- p_api_version NUMBER Required
187 -- p_init_msg_list VARCHAR2 := FND_API.G_FALSE
188 -- p_commit VARCHAR2 := FND_API.G_FALSE
189 -- p_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL
190 -- p_default VARCHAR2 := FND_API.G_FALSE
191 -- p_module_type VARCHAR2 := NULL
192 --
193 -- Standard OUT Parameters :
194 -- x_return_status VARCHAR2 Required
195 -- x_msg_count NUMBER Required
196 -- x_msg_data VARCHAR2 Required
197 --
198 -- Procedure IN, OUT, IN/OUT params :
199 -- p_mel_cdl_header_id NUMBER Required
200 -- p_mel_cdl_object_version NUMBER Required
201 -- x_new_mel_cdl_header_id NUMBER Required
202 --
203 -- Version :
204 -- Initial Version 1.0
205 --
206 -- End of Comments --
207 PROCEDURE Create_Mel_Cdl_Revision
208 (
209 -- Standard IN params
210 p_api_version IN NUMBER,
211 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
212 p_commit IN VARCHAR2 := FND_API.G_FALSE,
213 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
214 p_default IN VARCHAR2 := FND_API.G_FALSE,
215 p_module_type IN VARCHAR2 := NULL,
216 -- Standard OUT params
217 x_return_status OUT NOCOPY VARCHAR2,
218 x_msg_count OUT NOCOPY NUMBER,
219 x_msg_data OUT NOCOPY VARCHAR2,
220 -- Procedure IN, OUT, IN/OUT params
221 p_mel_cdl_header_id IN NUMBER,
222 p_mel_cdl_object_version IN NUMBER,
223 x_new_mel_cdl_header_id OUT NOCOPY NUMBER
224 );
225
226 -- Start of Comments --
227 --
228 -- Procedure name : Initiate_Mel_Cdl_Approval
229 -- Type : Private
230 -- Description : This procedure submits an existing MEL/CDL for approval
231 -- Pre-reqs :
232 --
233 -- Standard IN Parameters :
234 -- p_api_version NUMBER Required
235 -- p_init_msg_list VARCHAR2 := FND_API.G_FALSE
236 -- p_commit VARCHAR2 := FND_API.G_FALSE
237 -- p_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL
238 -- p_default VARCHAR2 := FND_API.G_FALSE
239 -- p_module_type VARCHAR2 := NULL
240 --
241 -- Standard OUT Parameters :
242 -- x_return_status VARCHAR2 Required
246 -- Procedure IN, OUT, IN/OUT params :
243 -- x_msg_count NUMBER Required
244 -- x_msg_data VARCHAR2 Required
245 --
247 -- p_mel_cdl_header_id NUMBER Required
248 -- p_mel_cdl_object_version NUMBER Required
249 --
250 -- Version :
251 -- Initial Version 1.0
252 --
253 -- End of Comments --
254 PROCEDURE Initiate_Mel_Cdl_Approval
255 (
256 -- Standard IN params
257 p_api_version IN NUMBER,
258 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
259 p_commit IN VARCHAR2 := FND_API.G_FALSE,
260 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
261 p_default IN VARCHAR2 := FND_API.G_FALSE,
262 p_module_type IN VARCHAR2 := NULL,
263 -- Standard OUT params
264 x_return_status OUT NOCOPY VARCHAR2,
265 x_msg_count OUT NOCOPY NUMBER,
266 x_msg_data OUT NOCOPY VARCHAR2,
267 -- Procedure IN, OUT, IN/OUT params
268 p_mel_cdl_header_id IN NUMBER,
269 p_mel_cdl_object_version IN NUMBER
270 );
271
272 End AHL_MEL_CDL_HEADERS_PVT;