1 PACKAGE EAM_FailureCodes_PUB AUTHID CURRENT_USER AS
2 /* $Header: EAMPFCPS.pls 120.0 2006/03/08 07:03:12 sshahid noship $ */
3 G_FAILURE_CODE CONSTANT NUMBER := 10;
4 G_CAUSE_CODE CONSTANT NUMBER := 20;
5 G_RESOLUTION_CODE CONSTANT NUMBER := 30;
6
7 TYPE eam_failurecode_rec_type IS RECORD
8 (code_type NUMBER ,
9 code VARCHAR2(80) ,
10 description VARCHAR2(2000),
11 effective_end_date DATE ,
12 stored_last_upd_date DATE);
13
14 TYPE eam_combination_rec_type IS RECORD
15 (set_id NUMBER ,
16 set_name VARCHAR2(80),
17 failure_code VARCHAR2(80),
18 failure_description VARCHAR2(2000),
19 cause_code VARCHAR2(80),
20 cause_description VARCHAR2(2000),
21 resolution_code VARCHAR2(80),
22 resolution_description VARCHAR2(2000),
23 effective_end_date DATE ,
24 combination_id NUMBER,
25 stored_last_upd_date DATE,
26 created_by NUMBER ,
27 creation_date DATE ,
28 last_update_date DATE ,
29 last_updated_by NUMBER ,
30 last_update_login NUMBER);
31
32 /**************************************************************************
33 -- Start of comments
34 -- API name : Create_Code
35 -- Type : Public.
36 -- Function : Create Failure/Cause/Resolution Code
37 -- Pre-reqs : None.
38 -- Parameters :
39 -- IN : p_api_version IN NUMBER Required
40 -- p_init_msg_list IN VARCHAR2 Optional
41 -- Default = FND_API.G_FALSE
42 -- p_commit IN VARCHAR2 Optional
43 -- Default = FND_API.G_FALSE
44 -- p_failurecode_rec IN
45 -- EAM_FailureCodes_PUB.eam_failurecode_rec_type
46 -- Within p_failurecode_rec, code_type and code are
47 -- 'Required'. code_type should be one of the lookup
48 -- code values seeded for EAM_FAILURE_CODE_TYPE.
49 -- OUT : x_return_status OUT VARCHAR2(1)
50 -- x_msg_count OUT NUMBER
51 -- x_msg_data OUT VARCHAR2(2000)
52 -- Version : Current version 1.0.
53 -- Initial version 1.0
54 -- End of comments
55 ***************************************************************************/
56 PROCEDURE Create_Code
57 (p_api_version IN NUMBER ,
58 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
59 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
60 p_failurecode_rec IN EAM_FailureCodes_PUB.eam_failurecode_rec_type,
61 x_return_status OUT NOCOPY VARCHAR2 ,
62 x_msg_count OUT NOCOPY NUMBER ,
63 x_msg_data OUT NOCOPY VARCHAR2
64 );
65 /**************************************************************************
66 -- Start of comments
67 -- API name : Update_Code
68 -- Type : Public.
69 -- Function : Update Failure/Cause/Resolution Code
70 -- Pre-reqs : None.
71 -- Parameters :
72 -- IN : p_api_version IN NUMBER Required
73 -- p_init_msg_list IN VARCHAR2 Optional
74 -- Default = FND_API.G_FALSE
75 -- p_commit IN VARCHAR2 Optional
76 -- Default = FND_API.G_FALSE
77 -- p_failurecode_rec IN
78 -- EAM_FailureCodes_PUB.eam_failurecode_rec_type
79 -- Within p_failurecode_rec, code_type and code are
80 -- 'Required'.code_type should be one of the lookup
81 -- code values seeded for EAM_FAILURE_CODE_TYPE.
82 -- OUT : x_return_status OUT VARCHAR2(1)
83 -- x_msg_count OUT NUMBER
84 -- x_msg_data OUT VARCHAR2(2000)
85 -- Version : Current version 1.0.
86 -- Initial version 1.0
87 -- End of comments
88 ***************************************************************************/
89 PROCEDURE Update_Code
90 (p_api_version IN NUMBER ,
91 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
92 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
93 p_failurecode_rec IN EAM_FailureCodes_PUB.eam_failurecode_rec_type,
94 x_return_status OUT NOCOPY VARCHAR2 ,
95 x_msg_count OUT NOCOPY NUMBER ,
96 x_msg_data OUT NOCOPY VARCHAR2
97 );
98 /**************************************************************************
99 -- Start of comments
100 -- API name : Delete_Code
101 -- Type : Public.
102 -- Function : Delete Failure/Cause/Resolution Code
103 -- Pre-reqs : None.
104 -- Parameters :
105 -- IN : p_api_version IN NUMBER Required
106 -- p_init_msg_list IN VARCHAR2 Optional
107 -- Default = FND_API.G_FALSE
108 -- p_commit IN VARCHAR2 Optional
109 -- Default = FND_API.G_FALSE
110 -- p_failurecode_rec IN
111 -- EAM_FailureCodes_PUB.eam_failurecode_rec_type
112 -- Within p_failurecode_rec, code_type and code are
113 -- 'Required'.code_type should be one of the lookup
114 -- code values seeded for EAM_FAILURE_CODE_TYPE.
115 -- OUT : x_return_status OUT VARCHAR2(1)
116 -- x_msg_count OUT NUMBER
117 -- x_msg_data OUT VARCHAR2(2000)
118 -- Version : Current version 1.0.
119 -- Initial version 1.0
120 -- End of comments
121 ***************************************************************************/
122 PROCEDURE Delete_Code
123 (p_api_version IN NUMBER ,
124 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
125 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
126 p_failurecode_rec IN EAM_FailureCodes_PUB.eam_failurecode_rec_type,
127 x_return_status OUT NOCOPY VARCHAR2 ,
128 x_msg_count OUT NOCOPY NUMBER ,
129 x_msg_data OUT NOCOPY VARCHAR2
130 );
131 /**************************************************************************
132 -- Start of comments
133 -- API name : Create_Combination
134 -- Type : Public.
135 -- Function : Create a Failure - Cause -Resolution Combination
136 -- in the context of a failure set.
137 -- Pre-reqs : None.
138 -- Parameters :
139 -- IN : p_api_version IN NUMBER Required
140 -- p_init_msg_list IN VARCHAR2 Optional
141 -- Default = FND_API.G_FALSE
142 -- p_commit IN VARCHAR2 Optional
143 -- Default = FND_API.G_FALSE
144 -- p_combination_rec IN
145 -- EAM_FailureCodes_PUB.eam_combination_rec_type
146 -- Within p_combination_rec, failure_code, cause_code
147 -- and resolution_code are 'Required' and either
148 -- set_id or set_name is 'Required'.
149 -- OUT : x_return_status OUT VARCHAR2(1)
150 -- x_msg_count OUT NUMBER
151 -- x_msg_data OUT VARCHAR2(2000)
152 -- x_combination_id OUT NUMBER
153 -- Version : Current version 1.0.
154 -- Initial version 1.0
155 -- End of comments
156 ***************************************************************************/
157 PROCEDURE Create_Combination
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_combination_rec IN EAM_FailureCodes_PUB.eam_combination_rec_type,
162 x_return_status OUT NOCOPY VARCHAR2 ,
163 x_msg_count OUT NOCOPY NUMBER ,
164 x_msg_data OUT NOCOPY VARCHAR2 ,
165 x_combination_id OUT NOCOPY NUMBER
166 );
167 /**************************************************************************
168 -- Start of comments
169 -- API name : Update_Combination
170 -- Type : Public.
171 -- Function : Update a Failure - Cause -Resolution Combination
172 -- in the context of a failure set.
173 -- Pre-reqs : None.
174 -- Parameters :
175 -- IN : p_api_version IN NUMBER Required
176 -- p_init_msg_list IN VARCHAR2 Optional
177 -- Default = FND_API.G_FALSE
178 -- p_commit IN VARCHAR2 Optional
179 -- Default = FND_API.G_FALSE
180 -- p_combination_rec IN
181 -- EAM_FailureCodes_PUB.eam_combination_rec_type
182 -- Within p_combination_rec, failure_code, cause_code
183 -- and resolution_code are 'Required' and either
184 -- set_id or set_name is 'Required'.
185 -- OUT : x_return_status OUT VARCHAR2(1)
186 -- x_msg_count OUT NUMBER
187 -- x_msg_data OUT VARCHAR2(2000)
188 -- Version : Current version 1.0.
189 -- Initial version 1.0
190 -- End of comments
191 ***************************************************************************/
192 PROCEDURE Update_Combination
193 (p_api_version IN NUMBER ,
194 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
195 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
196 p_combination_rec IN EAM_FailureCodes_PUB.eam_combination_rec_type,
197 x_return_status OUT NOCOPY VARCHAR2 ,
198 x_msg_count OUT NOCOPY NUMBER ,
199 x_msg_data OUT NOCOPY VARCHAR2 ,
200 x_combination_id OUT NOCOPY NUMBER
201 );
202 /**************************************************************************
203 -- Start of comments
204 -- API name : Delete_Combination
205 -- Type : Public.
206 -- Function : Delete a Failure - Cause -Resolution Combination
207 -- in the context of a failure set.
208 -- Pre-reqs : None.
209 -- Parameters :
210 -- IN : p_api_version IN NUMBER Required
211 -- p_init_msg_list IN VARCHAR2 Optional
212 -- Default = FND_API.G_FALSE
213 -- p_commit IN VARCHAR2 Optional
214 -- Default = FND_API.G_FALSE
215 -- p_combination_rec IN
216 -- EAM_FailureCodes_PUB.eam_combination_rec_type
217 -- Within p_combination_rec, failure_code, cause_code
218 -- and resolution_code are 'Required' and either
219 -- set_id or set_name is 'Required'.
220 -- OUT : x_return_status OUT VARCHAR2(1)
221 -- x_msg_count OUT NUMBER
222 -- x_msg_data OUT VARCHAR2(2000)
223 -- Version : Current version 1.0.
224 -- Initial version 1.0
225 -- End of comments
226 ***************************************************************************/
227 PROCEDURE Delete_Combination
228 (p_api_version IN NUMBER ,
229 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
230 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
231 p_combination_rec IN EAM_FailureCodes_PUB.eam_combination_rec_type,
232 x_return_status OUT NOCOPY VARCHAR2 ,
233 x_msg_count OUT NOCOPY NUMBER ,
234 x_msg_data OUT NOCOPY VARCHAR2
235 );
236 END EAM_FailureCodes_PUB;