[Home] [Help]
PACKAGE: APPS.AHL_MEL_CDL_ATA_SEQS_PVT
Source
1 PACKAGE AHL_MEL_CDL_ATA_SEQS_PVT AS
2 /* $Header: AHLVATAS.pls 120.2 2005/09/12 04:07 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_ATA_SEQS_PVT'; -- Use for all debug messages, FND_API.COMPATIBLE_API_CALL, etc
6
7 -------------------------------
8 -- Define records and tables --
9 -------------------------------
10 TYPE Ata_Sequence_Rec_Type IS RECORD
11 (
12 MEL_CDL_ATA_SEQUENCE_ID NUMBER,
13 OBJECT_VERSION_NUMBER NUMBER,
14 MEL_CDL_HEADER_ID NUMBER,
15 REPAIR_CATEGORY_ID NUMBER,
16 REPAIR_CATEGORY_NAME VARCHAR2 (30),
17 ATA_CODE VARCHAR2 (30),
18 INSTALLED_NUMBER NUMBER,
19 DISPATCH_NUMBER NUMBER,
20 ATTRIBUTE_CATEGORY VARCHAR2 (30),
21 ATTRIBUTE1 VARCHAR2 (150),
22 ATTRIBUTE2 VARCHAR2 (150),
23 ATTRIBUTE3 VARCHAR2 (150),
24 ATTRIBUTE4 VARCHAR2 (150),
25 ATTRIBUTE5 VARCHAR2 (150),
26 ATTRIBUTE6 VARCHAR2 (150),
27 ATTRIBUTE7 VARCHAR2 (150),
28 ATTRIBUTE8 VARCHAR2 (150),
29 ATTRIBUTE9 VARCHAR2 (150),
30 ATTRIBUTE10 VARCHAR2 (150),
31 ATTRIBUTE11 VARCHAR2 (150),
32 ATTRIBUTE12 VARCHAR2 (150),
33 ATTRIBUTE13 VARCHAR2 (150),
34 ATTRIBUTE14 VARCHAR2 (150),
35 ATTRIBUTE15 VARCHAR2 (150),
36 REMARKS_NOTE VARCHAR2 (32767),
37 DML_OPERATION VARCHAR2 (1)
38 );
39
40 TYPE Ata_Sequence_Tbl_Type IS TABLE OF Ata_Sequence_Rec_Type INDEX BY BINARY_INTEGER;
41
42 TYPE Mo_Procedure_Rec_Type IS RECORD
43 (
44 MEL_CDL_MO_PROCEDURE_ID NUMBER,
45 OBJECT_VERSION_NUMBER NUMBER,
46 ATA_SEQUENCE_ID NUMBER,
47 MR_HEADER_ID NUMBER,
48 MR_TITLE VARCHAR2(80),
49 MR_VERSION_NUMBER NUMBER,
50 ATTRIBUTE_CATEGORY VARCHAR2 (30),
51 ATTRIBUTE1 VARCHAR2 (150),
52 ATTRIBUTE2 VARCHAR2 (150),
53 ATTRIBUTE3 VARCHAR2 (150),
54 ATTRIBUTE4 VARCHAR2 (150),
55 ATTRIBUTE5 VARCHAR2 (150),
56 ATTRIBUTE6 VARCHAR2 (150),
57 ATTRIBUTE7 VARCHAR2 (150),
58 ATTRIBUTE8 VARCHAR2 (150),
59 ATTRIBUTE9 VARCHAR2 (150),
60 ATTRIBUTE10 VARCHAR2 (150),
61 ATTRIBUTE11 VARCHAR2 (150),
62 ATTRIBUTE12 VARCHAR2 (150),
63 ATTRIBUTE13 VARCHAR2 (150),
64 ATTRIBUTE14 VARCHAR2 (150),
65 ATTRIBUTE15 VARCHAR2 (150),
66 DML_OPERATION VARCHAR2 (1)
67 );
68
69 TYPE Mo_Procedure_Tbl_Type IS TABLE OF Mo_Procedure_Rec_Type INDEX BY BINARY_INTEGER;
70
71 TYPE Relationship_Rec_Type IS RECORD
72 (
73 MEL_CDL_RELATIONSHIP_ID NUMBER,
74 OBJECT_VERSION_NUMBER NUMBER,
75 ATA_SEQUENCE_ID NUMBER,
76 RELATED_ATA_SEQUENCE_ID NUMBER,
77 ATTRIBUTE_CATEGORY VARCHAR2 (30),
78 ATTRIBUTE1 VARCHAR2 (150),
79 ATTRIBUTE2 VARCHAR2 (150),
80 ATTRIBUTE3 VARCHAR2 (150),
81 ATTRIBUTE4 VARCHAR2 (150),
82 ATTRIBUTE5 VARCHAR2 (150),
83 ATTRIBUTE6 VARCHAR2 (150),
84 ATTRIBUTE7 VARCHAR2 (150),
85 ATTRIBUTE8 VARCHAR2 (150),
86 ATTRIBUTE9 VARCHAR2 (150),
87 ATTRIBUTE10 VARCHAR2 (150),
88 ATTRIBUTE11 VARCHAR2 (150),
89 ATTRIBUTE12 VARCHAR2 (150),
90 ATTRIBUTE13 VARCHAR2 (150),
91 ATTRIBUTE14 VARCHAR2 (150),
92 ATTRIBUTE15 VARCHAR2 (150),
93 DML_OPERATION VARCHAR2 (1)
94 );
95
96 TYPE Relationship_Tbl_Type IS TABLE OF Relationship_Rec_Type INDEX BY BINARY_INTEGER;
97
98 -----------------------
99 -- Define procedures --
100 -----------------------
101 -- Start of Comments --
102 --
103 -- Procedure name : Process_Ata_Sequences
104 -- Type : Private
105 -- Description : This procedure creates, updates and deletes Ata Sequences attached with MELs/CDLs.
106 -- Pre-reqs :
107 --
108 -- Standard IN Parameters :
109 -- p_api_version NUMBER Required
110 -- p_init_msg_list VARCHAR2 := FND_API.G_FALSE
111 -- p_commit VARCHAR2 := FND_API.G_FALSE
112 -- p_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL
113 -- p_default VARCHAR2 := FND_API.G_FALSE
114 -- p_module_type VARCHAR2 := NULL
115 --
116 -- Standard OUT Parameters :
117 -- x_return_status VARCHAR2 Required
118 -- x_msg_count NUMBER Required
119 -- x_msg_data VARCHAR2 Required
120 --
121 -- Procedure IN, OUT, IN/OUT params :
122 -- p_x_ata_sequences_tbl Ata_Sequence_Tbl_Type Required
123 --
124 -- Version :
125 -- Initial Version 1.0
126 --
127 -- End of Comments --
128 PROCEDURE Process_Ata_Sequences
129 (
130 -- Standard IN params
131 p_api_version IN NUMBER,
132 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
133 p_commit IN VARCHAR2 := FND_API.G_FALSE,
134 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
135 p_default IN VARCHAR2 := FND_API.G_FALSE,
136 p_module_type IN VARCHAR2 := NULL,
137 -- Standard OUT params
138 x_return_status OUT NOCOPY VARCHAR2,
139 x_msg_count OUT NOCOPY NUMBER,
140 x_msg_data OUT NOCOPY VARCHAR2,
141 -- Procedure IN, OUT, IN/OUT params
142 p_x_ata_sequences_tbl IN OUT NOCOPY Ata_Sequence_Tbl_Type
143 );
144
145 -- Start of Comments --
146 --
147 -- Procedure name : Process_Mo_Procedures
148 -- Type : Private
149 -- Description : This procedure creates and deletes association of M&O procedures with Ata Sequence.
150 -- Pre-reqs :
151 --
152 -- Standard IN Parameters :
153 -- p_api_version NUMBER Required
154 -- p_init_msg_list VARCHAR2 := FND_API.G_FALSE
155 -- p_commit VARCHAR2 := FND_API.G_FALSE
156 -- p_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL
157 -- p_default VARCHAR2 := FND_API.G_FALSE
158 -- p_module_type VARCHAR2 := NULL
159 --
160 -- Standard OUT Parameters :
161 -- x_return_status VARCHAR2 Required
162 -- x_msg_count NUMBER Required
163 -- x_msg_data VARCHAR2 Required
164 --
165 -- Procedure IN, OUT, IN/OUT params :
166 -- p_x_mo_procedures_tbl Mo_Procedure_Tbl_Type Required
167 --
168 -- Version :
169 -- Initial Version 1.0
170 --
171 -- End of Comments --
172 PROCEDURE Process_Mo_Procedures
173 (
174 -- Standard IN params
175 p_api_version IN NUMBER,
176 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
177 p_commit IN VARCHAR2 := FND_API.G_TRUE,
178 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
179 p_default IN VARCHAR2 := FND_API.G_FALSE,
180 p_module_type IN VARCHAR2 := NULL,
181 -- Standard OUT params
182 x_return_status OUT NOCOPY VARCHAR2,
183 x_msg_count OUT NOCOPY NUMBER,
184 x_msg_data OUT NOCOPY VARCHAR2,
185 -- Procedure IN, OUT, IN/OUT params
186 p_x_mo_procedures_tbl IN OUT NOCOPY Mo_Procedure_Tbl_Type
187 );
188
189 -- Start of Comments --
190 --
191 -- Procedure name : Process_Ata_Relations
192 -- Type : Private
193 -- Description : This procedures creates and deletes association of Ata Sequences from other MELs/CDLs with Ata Sequence.
194 -- Pre-reqs :
195 --
196 -- Standard IN Parameters :
197 -- p_api_version NUMBER Required
198 -- p_init_msg_list VARCHAR2 := FND_API.G_FALSE
199 -- p_commit VARCHAR2 := FND_API.G_FALSE
200 -- p_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL
201 -- p_default VARCHAR2 := FND_API.G_FALSE
202 -- p_module_type VARCHAR2 := NULL
203 --
204 -- Standard OUT Parameters :
205 -- x_return_status VARCHAR2 Required
206 -- x_msg_count NUMBER Required
207 -- x_msg_data VARCHAR2 Required
208 --
209 -- Procedure IN, OUT, IN/OUT params :
210 -- p_x_ata_relations_tbl Relationship_Tbl_Type Required
211 --
212 -- Version :
213 -- Initial Version 1.0
214 --
215 -- End of Comments --
216 PROCEDURE Process_Ata_Relations
217 (
218 -- Standard IN params
219 p_api_version IN NUMBER,
220 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
221 p_commit IN VARCHAR2 := FND_API.G_TRUE,
222 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
223 p_default IN VARCHAR2 := FND_API.G_FALSE,
224 p_module_type IN VARCHAR2 := NULL,
225 -- Standard OUT params
226 x_return_status OUT NOCOPY VARCHAR2,
227 x_msg_count OUT NOCOPY NUMBER,
228 x_msg_data OUT NOCOPY VARCHAR2,
229 -- Procedure IN, OUT, IN/OUT params
230 p_x_ata_relations_tbl IN OUT NOCOPY Relationship_Tbl_Type
231 );
232
233 --
234 -- Procedure name : Copy_MO_Proc_Revision
235 -- Type : Private
236 -- Description : This procedures copies new revision of M & O Procedures to the ATA Sequences to which the old revision is also associated
237 -- Pre-reqs :
238 --
239 -- Standard IN Parameters :
240 -- p_api_version NUMBER Required
241 -- p_init_msg_list VARCHAR2 := FND_API.G_FALSE
242 -- p_commit VARCHAR2 := FND_API.G_FALSE
243 -- p_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL
244 -- p_default VARCHAR2 := FND_API.G_FALSE
245 -- p_module_type VARCHAR2 := NULL
246 --
247 -- Standard OUT Parameters :
248 -- x_return_status VARCHAR2 Required
249 -- x_msg_count NUMBER Required
250 -- x_msg_data VARCHAR2 Required
251 --
252 -- Procedure IN, OUT, IN/OUT params :
253 -- p_old_mr_header_id NUMBER Required
254 -- p_new_mr_header_id NUMBER Required
255 --
256 -- Version :
257 -- Initial Version 1.0
258 --
259 -- End of Comments --
260 PROCEDURE Copy_MO_Proc_Revision
261 (
262 -- Standard IN params
263 p_api_version IN NUMBER,
264 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
265 p_commit IN VARCHAR2 := FND_API.G_TRUE,
266 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
270 x_return_status OUT NOCOPY VARCHAR2,
267 p_default IN VARCHAR2 := FND_API.G_FALSE,
268 p_module_type IN VARCHAR2 := NULL,
269 -- Standard OUT params
271 x_msg_count OUT NOCOPY NUMBER,
272 x_msg_data OUT NOCOPY VARCHAR2,
273 -- Procedure IN, OUT, IN/OUT params
274 p_old_mr_header_id IN NUMBER,
275 p_new_mr_header_id IN NUMBER
276 );
277
278 End AHL_MEL_CDL_ATA_SEQS_PVT;