1 PACKAGE EAM_FailureCodes_PVT AUTHID CURRENT_USER AS
2 /* $Header: EAMVFCPS.pls 120.0 2006/03/08 07:09:45 sshahid noship $ */
3
4 /**************************************************************************
5 -- Start of comments
6 -- API name : Setup_Code
7 -- Type : Private.
8 -- Function : Create or Update or Delete Failure/Cause/Resolution Code
9 -- Pre-reqs : None.
10 -- Parameters :
11 -- IN : p_api_version IN NUMBER Required
12 -- p_init_msg_list IN VARCHAR2 Optional
13 -- Default = FND_API.G_FALSE
14 -- p_commit IN VARCHAR2 Optional
15 -- Default = FND_API.G_FALSE
16 -- p_validation_level IN NUMBER
17 -- Default = FND_API.G_VALID_LEVEL_FULL
18 -- p_mode IN VARCHAR2 Required
19 -- Possible Values for p_mode
20 -- 'C' for create
21 -- 'U' for update
22 -- 'D' for delete
23 -- p_failurecode_rec IN
24 -- EAM_FailureCodes_PUB.eam_failurecode_rec_type
25 -- Within p_failurecode_rec, code_type and code are
26 -- 'Required'. code_type should be one of the lookup
27 -- code values seeded for EAM_FAILURE_CODE_TYPE.
28 -- OUT : x_return_status OUT VARCHAR2(1)
29 -- x_msg_count OUT NUMBER
30 -- x_msg_data OUT VARCHAR2(2000)
31 -- Version : Current version 1.0.
32 -- Initial version 1.0
33 -- End of comments
34 ***************************************************************************/
35 PROCEDURE Setup_Code
36 (p_api_version IN NUMBER ,
37 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
38 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
39 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
40 p_mode IN VARCHAR2 ,
41 p_failurecode_rec IN EAM_FailureCodes_PUB.eam_failurecode_rec_type,
42 x_return_status OUT NOCOPY VARCHAR2 ,
43 x_msg_count OUT NOCOPY NUMBER ,
44 x_msg_data OUT NOCOPY VARCHAR2
45 );
46
47 /**************************************************************************
48 -- Start of comments
49 -- API name : Setup_Combination
50 -- Type : Private.
51 -- Function : Create or update or delete a
52 -- Failure - Cause -Resolution Combination
53 -- in the context of a failure set.
54 -- Pre-reqs : None.
55 -- Parameters :
56 -- IN : p_api_version IN NUMBER Required
57 -- p_init_msg_list IN VARCHAR2 Optional
58 -- Default = FND_API.G_FALSE
59 -- p_commit IN VARCHAR2 Optional
60 -- Default = FND_API.G_FALSE
61 -- p_validation_level IN NUMBER
62 -- Default = FND_API.G_VALID_LEVEL_FULL
63 -- p_mode IN VARCHAR2 Required
64 -- Possible Values for p_mode
65 -- 'C' for create
66 -- 'U' for update
67 -- 'D' for delete
68 -- p_combination_rec IN
69 -- EAM_FailureCodes_PUB.eam_combination_rec_type
70 -- Within p_combination_rec, failure_code, cause_code
71 -- and resolution_code are 'Required' and either
72 -- set_id or set_name is 'Required'.
73 -- OUT : x_return_status OUT VARCHAR2(1)
74 -- x_msg_count OUT NUMBER
75 -- x_msg_data OUT VARCHAR2(2000)
76 -- x_combination_id OUT NUMBER
77 -- Version : Current version 1.0.
78 -- Initial version 1.0
79 -- End of comments
80 ***************************************************************************/
81 PROCEDURE Setup_Combination
82 (p_api_version IN NUMBER ,
83 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
84 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
85 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
86 p_mode IN VARCHAR2 ,
87 p_combination_rec IN EAM_FailureCodes_PUB.eam_combination_rec_type,
88 x_return_status OUT NOCOPY VARCHAR2 ,
89 x_msg_count OUT NOCOPY NUMBER ,
90 x_msg_data OUT NOCOPY VARCHAR2 ,
91 x_combination_id OUT NOCOPY NUMBER
92 );
93 /**************************************************************************
94 -- Start of comments
95 -- API name : Copy_FailureSet
96 -- Type : Private.
97 -- Function : Copy
98 -- Failure - Cause -Resolution Combinations
99 -- from a source failure set to destination
100 -- failure set.
101 -- Pre-reqs : None.
102 -- Parameters :
103 -- IN : p_api_version IN NUMBER Required
104 -- p_init_msg_list IN VARCHAR2 Optional
105 -- Default = FND_API.G_FALSE
106 -- p_commit IN VARCHAR2 Optional
107 -- Default = FND_API.G_FALSE
108 -- p_validation_level IN NUMBER
109 -- Default = FND_API.G_VALID_LEVEL_FULL
110 -- p_source_set_id IN NUMBER
111 -- p_destination_set_id IN NUMBER
112 -- OUT : x_return_status OUT VARCHAR2(1)
113 -- x_msg_count OUT NUMBER
114 -- x_msg_data OUT VARCHAR2(2000)
115 -- Version : Current version 1.0.
116 -- Initial version 1.0
117 -- End of comments
118 ***************************************************************************/
119 PROCEDURE Copy_FailureSet
120 (p_api_version IN NUMBER ,
121 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
122 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
123 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
124 p_source_set_id IN NUMBER ,
125 p_destination_set_id IN NUMBER ,
126 x_return_status OUT NOCOPY VARCHAR2 ,
127 x_msg_count OUT NOCOPY NUMBER ,
128 x_msg_data OUT NOCOPY VARCHAR2
129 );
130 /**************************************************************************
131 -- Start of comments
132 -- API name : Setup_Code_JSP
133 -- Type : Private.
134 -- Function : Wrapper call to Setup_Code_JSP from OA Fwk
135 -- Pre-reqs : None.
136 -- Parameters :
137 -- IN : p_mode IN VARCHAR2 Required
138 -- Possible Values for p_mode
139 -- 'C' for create
140 -- 'U' for update
141 -- 'D' for delete
142 -- code_type IN NUMBER
143 -- code IN VARCHAR2
144 -- description IN VARCHAR2
145 -- effective_end_date IN DATE
146 -- stored_last_upd_date IN DATE
147 -- OUT : x_return_status OUT VARCHAR2(1)
148 -- x_msg_count OUT NUMBER
149 -- x_msg_data OUT VARCHAR2(2000)
150 -- Version : Current version 1.0.
151 -- Initial version 1.0
152 -- End of comments
153 ***************************************************************************/
154 PROCEDURE Setup_Code_JSP
155 (p_mode IN VARCHAR2,
156 p_code_type IN NUMBER ,
157 p_code IN VARCHAR2,
158 p_description IN VARCHAR2,
159 p_effective_end_date IN DATE ,
160 p_stored_last_upd_date IN DATE ,
161 x_return_status OUT NOCOPY VARCHAR2,
162 x_msg_count OUT NOCOPY NUMBER ,
163 x_msg_data OUT NOCOPY VARCHAR2
164 );
165 /**************************************************************************
166 -- Start of comments
167 -- API name : Setup_Combination_JSP
168 -- Type : Private.
169 -- Function : Wrapper call to Setup_Combination from OA Fwk
170 -- Pre-reqs : None.
171 -- Parameters :
172 -- IN : p_mode IN VARCHAR2 Required
173 -- Possible Values for p_mode
174 -- 'C' for create
175 -- 'U' for update
176 -- 'D' for delete
177 -- set_name IN VARCHAR2
178 -- failure_code IN VARCHAR2
179 -- failure_description IN VARCHAR2
180 -- cause_code IN VARCHAR2
181 -- cause_description IN VARCHAR2
182 -- resolution_code IN VARCHAR2
183 -- resolution_description IN VARCHAR2
184 -- effective_end_date IN DATE
185 -- combination_id IN NUMBER
186 -- stored_last_upd_date IN DATE
187 -- OUT : x_return_status OUT VARCHAR2(1)
188 -- x_msg_count OUT NUMBER
189 -- x_msg_data OUT VARCHAR2(2000)
190 -- x_combination_id OUT NUMBER
191 -- Version : Current version 1.0.
192 -- Initial version 1.0
193 -- End of comments
194 ***************************************************************************/
195 PROCEDURE Setup_Combination_JSP
196 (p_mode IN VARCHAR2 ,
197 p_set_id IN NUMBER ,
198 p_set_name IN VARCHAR2 ,
199 p_failure_code IN VARCHAR2 ,
200 p_failure_description IN VARCHAR2 ,
201 p_cause_code IN VARCHAR2 ,
202 p_cause_description IN VARCHAR2 ,
203 p_resolution_code IN VARCHAR2 ,
204 p_resolution_description IN VARCHAR2 ,
205 p_effective_end_date IN DATE ,
206 p_combination_id IN NUMBER ,
207 p_stored_last_upd_date IN DATE ,
208 p_created_by IN NUMBER ,
209 p_creation_date IN DATE ,
210 p_last_update_date IN DATE ,
211 p_last_updated_by IN NUMBER ,
212 p_last_update_login IN NUMBER ,
213 x_return_status OUT NOCOPY VARCHAR2,
214 x_msg_count OUT NOCOPY NUMBER ,
215 x_msg_data OUT NOCOPY VARCHAR2,
216 x_combination_id OUT NOCOPY NUMBER
217 );
218 /**************************************************************************
219 -- Start of comments
220 -- API name : Lock_Code_JSP
221 -- Type : Private.
222 -- Function : To lock a failure code row - called from OA Fwk
223 -- Pre-reqs : None.
224 -- Parameters :
225 -- IN : p_mode IN VARCHAR2 Required
226 -- Possible Values for p_mode
227 -- 'C' for create
228 -- 'U' for update
229 -- 'D' for delete
230 -- code_type IN NUMBER
231 -- code IN VARCHAR2
232 -- description IN VARCHAR2
233 -- effective_end_date IN DATE
234 -- stored_last_upd_date IN DATE
235 -- OUT : x_return_status OUT VARCHAR2(1)
236 -- x_msg_count OUT NUMBER
237 -- x_msg_data OUT VARCHAR2(2000)
238 -- Version : Current version 1.0.
239 -- Initial version 1.0
240 -- End of comments
241 ***************************************************************************/
242 PROCEDURE Lock_Code_JSP
243 (p_code_type IN NUMBER ,
244 p_code IN VARCHAR2,
245 p_last_update_date IN DATE ,
246 x_return_status OUT NOCOPY VARCHAR2,
247 x_msg_count OUT NOCOPY NUMBER ,
248 x_msg_data OUT NOCOPY VARCHAR2
249 );
250 /**************************************************************************
251 -- Start of comments
252 -- API name : Lock_Combination_JSP
253 -- Type : Private.
254 -- Function : To lock a failure code combinations row - called from
255 -- OA Fwk
256 -- Pre-reqs : None.
257 -- Parameters :
258 -- IN : p_combination_id IN NUMBER
259 -- p_last_upd_date IN DATE
260 -- OUT : x_return_status OUT VARCHAR2(1)
261 -- x_msg_count OUT NUMBER
262 -- x_msg_data OUT VARCHAR2(2000)
263 -- Version : Current version 1.0.
264 -- Initial version 1.0
265 -- End of comments
266 ***************************************************************************/
267 PROCEDURE Lock_Combination_JSP
268 (p_combination_id IN NUMBER ,
269 p_last_update_date IN DATE ,
270 x_return_status OUT NOCOPY VARCHAR2,
271 x_msg_count OUT NOCOPY NUMBER ,
272 x_msg_data OUT NOCOPY VARCHAR2
273 );
274 END EAM_FailureCodes_PVT;