1 PACKAGE WIP_EAM_WORKREQUEST_PVT as
2 /* $Header: WIPVWRPS.pls 120.1 2005/06/15 17:14:29 appldev $ */
3 /* Modified by yjhabak for Work Request Enhancement Project BUG No : 2997297 */
4 -- Start of comments
5 -- API name : WIP_EAM_WORKREQUEST_PVT
6 -- Type : Public
7 -- Function :
8 -- Pre-reqs : None.
9 -- Parameters :
10 -- IN p_api_version IN NUMBER Required
11 -- p_init_msg_list IN VARCHAR2 Optional
12 -- Default = FND_API.G_FALSE
13 -- p_commit IN VARCHAR2 Optional
14 -- Default = FND_API.G_FALSE
15 -- p_validation_level IN NUMBER Optional
16 -- Default = FND_API.G_VALID_LEVEL_FULL
17 -- p_CLASSID in out NUMBER
18 -- p_CLASS_CODE in VARCHAR2
19 -- p_CLASS_NAME in VARCHAR2
20 -- p_CLASS_DESCRIPTION in VARCHAR2
21 -- p_START_DATE_ACTIVE in DATE
22 -- p_END_DATE_ACTIVE in DATE
23 -- p_CREATION_DATE in DATE
24 -- p_CREATED_BY in NUMBER
25 -- p_LAST_UPDATE_DATE in DATE
26 -- p_LAST_UPDATED_BY in NUMBER
27 -- p_LAST_UPDATE_LOGIN in NUMBER
28 -- OUT x_return_status OUT VARCHAR2(1)
29 -- x_msg_count OUT NUMBER
30 -- x_msg_data OUT VARCHAR2(2000)
31 --
32 -- Version Current version 115.0
33 --
34 -- Notes : create and update work request
35 --
36 -- End of comments
37
38 PROCEDURE create_work_request (
39 p_api_version IN NUMBER,
40 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
41 p_commit IN VARCHAR2 := FND_API.G_FALSE,
42 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
43 p_org_id IN NUMBER,
44 p_asset_group_id IN NUMBER,
45 p_asset_number IN VARCHAR2,
46 p_priority_id IN NUMBER,
47 p_request_by_date IN DATE,
48 p_request_log IN VARCHAR2,
49 p_owning_dept_id IN NUMBER,
50 p_user_id IN NUMBER,
51 p_work_request_type_id IN NUMBER,
52 p_maintenance_object_type IN NUMBER DEFAULT 3,
53 p_maintenance_object_id IN NUMBER DEFAULT NULL,
54 p_eam_linear_id IN NUMBER DEFAULT NULL,
55 p_work_request_created_by IN NUMBER DEFAULT 1,
56 p_created_for IN NUMBER DEFAULT NULL,
57 p_phone_number IN VARCHAR2 DEFAULT NULL,
58 p_email IN VARCHAR2 DEFAULT NULL,
59 p_contact_preference IN NUMBER DEFAULT NULL,
60 p_notify_originator IN NUMBER DEFAULT NULL,
61 p_attribute_category IN VARCHAR2 DEFAULT NULL,
62 p_attribute1 IN VARCHAR2 DEFAULT NULL,
63 p_attribute2 IN VARCHAR2 DEFAULT NULL,
64 p_attribute3 IN VARCHAR2 DEFAULT NULL,
65 p_attribute4 IN VARCHAR2 DEFAULT NULL,
66 p_attribute5 IN VARCHAR2 DEFAULT NULL,
67 p_attribute6 IN VARCHAR2 DEFAULT NULL,
68 p_attribute7 IN VARCHAR2 DEFAULT NULL,
69 p_attribute8 IN VARCHAR2 DEFAULT NULL,
70 p_attribute9 IN VARCHAR2 DEFAULT NULL,
71 p_attribute10 IN VARCHAR2 DEFAULT NULL,
72 p_attribute11 IN VARCHAR2 DEFAULT NULL,
73 p_attribute12 IN VARCHAR2 DEFAULT NULL,
74 p_attribute13 IN VARCHAR2 DEFAULT NULL,
75 p_attribute14 IN VARCHAR2 DEFAULT NULL,
76 p_attribute15 IN VARCHAR2 DEFAULT NULL,
77 x_request_id OUT NOCOPY NUMBER,
78 x_status_id OUT NOCOPY NUMBER,
79 x_return_status OUT NOCOPY VARCHAR2,
80 x_msg_count OUT NOCOPY NUMBER,
81 x_msg_data OUT NOCOPY VARCHAR2
82 );
83
84 FUNCTION isdifferent(a VARCHAR2, b VARCHAR2) RETURN NUMBER;
85
86 FUNCTION isdifferent_number(a NUMBER, b NUMBER) RETURN NUMBER;
87
88 FUNCTION dff_prompt_name (
89 appl_short_name IN fnd_application.application_short_name%TYPE,
90 flexfield_name IN fnd_descriptive_flexs_vl.descriptive_flexfield_name%TYPE,
91 attribute_name IN fnd_descr_flex_col_usage_vl.end_user_column_name%TYPE ,
92 attribute_category IN fnd_descr_flex_contexts.descriptive_flex_context_code%TYPE := 'Global Data Elements')
93 RETURN fnd_descr_flex_col_usage_vl.form_above_prompt%TYPE;
94
95 PROCEDURE update_work_request (
96 p_api_version IN NUMBER,
97 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
98 p_commit IN VARCHAR2 := FND_API.G_FALSE,
99 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
100 p_org_id IN NUMBER,
101 p_asset_group_id IN NUMBER,
102 p_asset_number IN VARCHAR2,
103 p_request_id IN NUMBER,
104 p_status_id IN NUMBER,
105 p_priority_id IN NUMBER,
106 p_request_by_date IN DATE,
107 p_request_log IN VARCHAR2,
108 p_work_request_type_id IN NUMBER,
109 p_eam_linear_id IN NUMBER DEFAULT NULL,
110 p_owning_dept_id IN NUMBER,
111 p_created_for IN NUMBER,
112 p_phone_number IN VARCHAR2,
113 p_email IN VARCHAR2,
114 p_contact_preference IN NUMBER,
115 p_notify_originator IN NUMBER,
116 p_attribute_category IN VARCHAR2,
117 p_attribute1 IN VARCHAR2,
118 p_attribute2 IN VARCHAR2,
119 p_attribute3 IN VARCHAR2,
120 p_attribute4 IN VARCHAR2,
121 p_attribute5 IN VARCHAR2,
122 p_attribute6 IN VARCHAR2,
123 p_attribute7 IN VARCHAR2,
124 p_attribute8 IN VARCHAR2,
125 p_attribute9 IN VARCHAR2,
126 p_attribute10 IN VARCHAR2,
127 p_attribute11 IN VARCHAR2,
128 p_attribute12 IN VARCHAR2,
129 p_attribute13 IN VARCHAR2,
130 p_attribute14 IN VARCHAR2,
131 p_attribute15 IN VARCHAR2,
132 p_from_public_api IN VARCHAR2 DEFAULT 'N',
133 x_return_status OUT NOCOPY VARCHAR2,
134 x_msg_count OUT NOCOPY NUMBER,
135 x_msg_data OUT NOCOPY VARCHAR2
136 );
137
138 PROCEDURE return_dept_id (
139 p_org_id IN NUMBER,
140 p_dept_name IN VARCHAR2,
141 x_dept_id OUT NOCOPY NUMBER,
142 x_return_status OUT NOCOPY VARCHAR2,
143 x_msg_count OUT NOCOPY NUMBER,
144 x_msg_data OUT NOCOPY VARCHAR2
145 );
146
147 PROCEDURE validate_work_request (
148 p_api_version in NUMBER,
149 p_init_msg_list in VARCHAR2:= FND_API.G_FALSE,
150 p_mode in VARCHAR2,
151 p_org_id in NUMBER,
152 p_request_id in NUMBER,
153 p_asset_group_id in NUMBER,
154 p_asset_number in VARCHAR2,
155 p_priority_id in NUMBER,
156 p_status_id in NUMBER,
157 p_request_by_date in DATE,
158 p_request_log in VARCHAR2,
159 p_owning_dept_id in NUMBER,
160 p_work_request_type_id in NUMBER,
161 p_maintenance_object_type IN NUMBER DEFAULT 3,
162 p_maintenance_object_id IN NUMBER DEFAULT NULL,
163 p_eam_linear_id in NUMBER default null,
164 p_attribute_category in VARCHAR2 default null,
165 p_attribute1 IN VARCHAR2 default null,
166 p_attribute2 IN VARCHAR2 default null,
167 p_attribute3 IN VARCHAR2 default null,
168 p_attribute4 IN VARCHAR2 default null,
169 p_attribute5 IN VARCHAR2 default null,
170 p_attribute6 IN VARCHAR2 default null,
171 p_attribute7 IN VARCHAR2 default null,
172 p_attribute8 IN VARCHAR2 default null,
173 p_attribute9 IN VARCHAR2 default null,
174 p_attribute10 IN VARCHAR2 default null,
175 p_attribute11 IN VARCHAR2 default null,
176 p_attribute12 IN VARCHAR2 default null,
177 p_attribute13 IN VARCHAR2 default null,
178 p_attribute14 IN VARCHAR2 default null,
179 p_attribute15 IN VARCHAR2 default null,
180 p_created_for IN NUMBER default null,
181 p_phone_number IN VARCHAR2 default null,
182 p_email IN VARCHAR2 default null,
183 p_contact_preference IN NUMBER default null,
184 p_notify_originator IN NUMBER default null,
185 x_return_flag OUT NOCOPY BOOLEAN,
186 x_return_status OUT NOCOPY VARCHAR2,
187 x_msg_count OUT NOCOPY NUMBER,
188 x_msg_data OUT NOCOPY VARCHAR2
189 );
190
191
192 PROCEDURE auto_approve_check (
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_validation_level in NUMBER := FND_API.G_VALID_LEVEL_FULL,
197 p_org_id in NUMBER,
198 x_return_check OUT NOCOPY VARCHAR2,
199 x_return_status OUT NOCOPY VARCHAR2,
200 x_msg_count OUT NOCOPY NUMBER,
201 x_msg_data OUT NOCOPY VARCHAR2
202 );
203
204 PROCEDURE create_and_approve(
205 p_api_version IN NUMBER,
206 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
207 p_commit IN VARCHAR2 := FND_API.G_FALSE,
208 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
209 p_org_id IN NUMBER,
210 p_asset_group_id IN NUMBER,
211 p_asset_number IN VARCHAR2,
212 p_priority_id IN NUMBER,
213 p_request_by_date IN DATE,
214 p_request_log IN VARCHAR2,
215 p_owning_dept_id IN NUMBER,
216 p_user_id IN NUMBER,
217 p_work_request_type_id IN NUMBER,
218 p_maintenance_object_type IN NUMBER DEFAULT 3,
219 p_maintenance_object_id IN NUMBER DEFAULT NULL,
220 p_eam_linear_id IN NUMBER DEFAULT NULL,
221 p_asset_location IN NUMBER DEFAULT NULL,
222 p_expected_resolution_date IN DATE DEFAULT NULL,
223 p_work_request_created_by IN NUMBER DEFAULT 1,
224 p_created_for IN NUMBER DEFAULT NULL,
225 p_phone_number IN VARCHAR2 DEFAULT NULL,
226 p_email IN VARCHAR2 DEFAULT NULL,
227 p_contact_preference IN NUMBER DEFAULT NULL,
228 p_notify_originator IN NUMBER DEFAULT NULL,
229 p_attribute_category IN VARCHAR2 DEFAULT NULL,
230 p_attribute1 IN VARCHAR2 DEFAULT NULL,
231 p_attribute2 IN VARCHAR2 DEFAULT NULL,
232 p_attribute3 IN VARCHAR2 DEFAULT NULL,
233 p_attribute4 IN VARCHAR2 DEFAULT NULL,
234 p_attribute5 IN VARCHAR2 DEFAULT NULL,
235 p_attribute6 IN VARCHAR2 DEFAULT NULL,
236 p_attribute7 IN VARCHAR2 DEFAULT NULL,
237 p_attribute8 IN VARCHAR2 DEFAULT NULL,
238 p_attribute9 IN VARCHAR2 DEFAULT NULL,
239 p_attribute10 IN VARCHAR2 DEFAULT NULL,
240 p_attribute11 IN VARCHAR2 DEFAULT NULL,
241 p_attribute12 IN VARCHAR2 DEFAULT NULL,
242 p_attribute13 IN VARCHAR2 DEFAULT NULL,
243 p_attribute14 IN VARCHAR2 DEFAULT NULL,
244 p_attribute15 IN VARCHAR2 DEFAULT NULL,
245 x_work_request_id OUT NOCOPY NUMBER,
246 x_resultout OUT NOCOPY VARCHAR2,
247 x_error_message OUT NOCOPY VARCHAR2,
248 x_return_status OUT NOCOPY VARCHAR2,
249 x_msg_count OUT NOCOPY NUMBER,
250 x_msg_data OUT NOCOPY VARCHAR2
251 ) ;
252
253
254 PROCEDURE check_product_install(
255 p_api_version IN NUMBER,
256 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
257 p_commit IN VARCHAR2 := FND_API.G_FALSE,
258 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
259 p_appl_id IN NUMBER,
260 p_dep_appl_id IN Number,
261 x_installed OUT NOCOPY NUMBER,
262 x_return_status OUT NOCOPY VARCHAR2,
263 x_msg_count OUT NOCOPY NUMBER,
264 x_msg_data OUT NOCOPY VARCHAR2
265 );
266
267 function validate_desc_flex_field
268 (
269 p_app_short_name IN VARCHAR:='EAM',
270 p_desc_flex_name IN VARCHAR,
271 p_ATTRIBUTE_CATEGORY IN VARCHAR2 default null,
272 p_ATTRIBUTE1 IN VARCHAR2 default null,
273 p_ATTRIBUTE2 IN VARCHAR2 default null,
274 p_ATTRIBUTE3 IN VARCHAR2 default null,
275 p_ATTRIBUTE4 IN VARCHAR2 default null,
276 p_ATTRIBUTE5 IN VARCHAR2 default null,
277 p_ATTRIBUTE6 IN VARCHAR2 default null,
278 p_ATTRIBUTE7 IN VARCHAR2 default null,
279 p_ATTRIBUTE8 IN VARCHAR2 default null,
280 p_ATTRIBUTE9 IN VARCHAR2 default null,
281 p_ATTRIBUTE10 IN VARCHAR2 default null,
282 p_ATTRIBUTE11 IN VARCHAR2 default null,
283 p_ATTRIBUTE12 IN VARCHAR2 default null,
284 p_ATTRIBUTE13 IN VARCHAR2 default null,
285 p_ATTRIBUTE14 IN VARCHAR2 default null,
286 p_ATTRIBUTE15 IN VARCHAR2 default null,
287 x_error_segments OUT NOCOPY NUMBER,
288 x_error_message OUT NOCOPY VARCHAR2
289 )
290 return boolean;
291
292
293
294 end WIP_EAM_WORKREQUEST_PVT;