1 PACKAGE WIP_EAM_WORKREQUEST_PVT AUTHID CURRENT_USER as
2 /* $Header: WIPVWRPS.pls 120.1.12020000.2 2012/07/18 07:49:06 ankohli ship $ */
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_user_id IN NUMBER,
112 p_created_for IN NUMBER,
113 p_phone_number IN VARCHAR2,
114 p_email IN VARCHAR2,
115 p_contact_preference IN NUMBER,
116 p_notify_originator IN NUMBER,
117 p_attribute_category IN VARCHAR2,
118 p_attribute1 IN VARCHAR2,
119 p_attribute2 IN VARCHAR2,
120 p_attribute3 IN VARCHAR2,
121 p_attribute4 IN VARCHAR2,
122 p_attribute5 IN VARCHAR2,
123 p_attribute6 IN VARCHAR2,
124 p_attribute7 IN VARCHAR2,
125 p_attribute8 IN VARCHAR2,
126 p_attribute9 IN VARCHAR2,
127 p_attribute10 IN VARCHAR2,
128 p_attribute11 IN VARCHAR2,
129 p_attribute12 IN VARCHAR2,
130 p_attribute13 IN VARCHAR2,
131 p_attribute14 IN VARCHAR2,
132 p_attribute15 IN VARCHAR2,
133 p_from_public_api IN VARCHAR2 DEFAULT 'N',
134 x_return_status OUT NOCOPY VARCHAR2,
135 x_msg_count OUT NOCOPY NUMBER,
136 x_msg_data OUT NOCOPY VARCHAR2
137 );
138
139 PROCEDURE return_dept_id (
140 p_org_id IN NUMBER,
141 p_dept_name IN VARCHAR2,
142 x_dept_id OUT NOCOPY NUMBER,
143 x_return_status OUT NOCOPY VARCHAR2,
144 x_msg_count OUT NOCOPY NUMBER,
145 x_msg_data OUT NOCOPY VARCHAR2
146 );
147
148 PROCEDURE validate_work_request (
149 p_api_version in NUMBER,
150 p_init_msg_list in VARCHAR2:= FND_API.G_FALSE,
151 p_mode in VARCHAR2,
152 p_org_id in NUMBER,
153 p_request_id in NUMBER,
154 p_asset_group_id in NUMBER,
155 p_asset_number in VARCHAR2,
156 p_priority_id in NUMBER,
157 p_status_id in NUMBER,
158 p_request_by_date in DATE,
159 p_request_log in VARCHAR2,
160 p_owning_dept_id in NUMBER,
161 p_user_id IN NUMBER,
162 p_work_request_type_id in NUMBER,
163 p_maintenance_object_type IN NUMBER DEFAULT 3,
164 p_maintenance_object_id IN NUMBER DEFAULT NULL,
165 p_eam_linear_id in NUMBER default null,
166 p_attribute_category in VARCHAR2 default null,
167 p_attribute1 IN VARCHAR2 default null,
168 p_attribute2 IN VARCHAR2 default null,
169 p_attribute3 IN VARCHAR2 default null,
170 p_attribute4 IN VARCHAR2 default null,
171 p_attribute5 IN VARCHAR2 default null,
172 p_attribute6 IN VARCHAR2 default null,
173 p_attribute7 IN VARCHAR2 default null,
174 p_attribute8 IN VARCHAR2 default null,
175 p_attribute9 IN VARCHAR2 default null,
176 p_attribute10 IN VARCHAR2 default null,
177 p_attribute11 IN VARCHAR2 default null,
178 p_attribute12 IN VARCHAR2 default null,
179 p_attribute13 IN VARCHAR2 default null,
180 p_attribute14 IN VARCHAR2 default null,
181 p_attribute15 IN VARCHAR2 default null,
182 p_created_for IN NUMBER default null,
183 p_phone_number IN VARCHAR2 default null,
184 p_email IN VARCHAR2 default null,
185 p_contact_preference IN NUMBER default null,
186 p_notify_originator IN NUMBER default null,
187 x_return_flag OUT NOCOPY BOOLEAN,
188 x_return_status OUT NOCOPY VARCHAR2,
189 x_msg_count OUT NOCOPY NUMBER,
190 x_msg_data OUT NOCOPY VARCHAR2
191 );
192
193
194 PROCEDURE auto_approve_check (
195 p_api_version in NUMBER,
196 p_init_msg_list in VARCHAR2 := FND_API.G_FALSE,
197 p_commit in VARCHAR2 := FND_API.G_FALSE,
198 p_validation_level in NUMBER := FND_API.G_VALID_LEVEL_FULL,
199 p_org_id in NUMBER,
200 x_return_check OUT NOCOPY VARCHAR2,
201 x_return_status OUT NOCOPY VARCHAR2,
202 x_msg_count OUT NOCOPY NUMBER,
203 x_msg_data OUT NOCOPY VARCHAR2
204 );
205
206 PROCEDURE create_and_approve(
207 p_api_version IN NUMBER,
208 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
209 p_commit IN VARCHAR2 := FND_API.G_FALSE,
210 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
211 p_org_id IN NUMBER,
212 p_asset_group_id IN NUMBER,
213 p_asset_number IN VARCHAR2,
214 p_priority_id IN NUMBER,
215 p_request_by_date IN DATE,
216 p_request_log IN VARCHAR2,
217 p_owning_dept_id IN NUMBER,
218 p_user_id IN NUMBER,
219 p_work_request_type_id IN NUMBER,
220 p_maintenance_object_type IN NUMBER DEFAULT 3,
221 p_maintenance_object_id IN NUMBER DEFAULT NULL,
222 p_eam_linear_id IN NUMBER DEFAULT NULL,
223 p_asset_location IN NUMBER DEFAULT NULL,
224 p_expected_resolution_date IN DATE DEFAULT NULL,
225 p_work_request_created_by IN NUMBER DEFAULT 1,
226 p_created_for IN NUMBER DEFAULT NULL,
227 p_phone_number IN VARCHAR2 DEFAULT NULL,
228 p_email IN VARCHAR2 DEFAULT NULL,
229 p_contact_preference IN NUMBER DEFAULT NULL,
230 p_notify_originator IN NUMBER DEFAULT NULL,
231 p_attribute_category IN VARCHAR2 DEFAULT NULL,
232 p_attribute1 IN VARCHAR2 DEFAULT NULL,
233 p_attribute2 IN VARCHAR2 DEFAULT NULL,
234 p_attribute3 IN VARCHAR2 DEFAULT NULL,
235 p_attribute4 IN VARCHAR2 DEFAULT NULL,
236 p_attribute5 IN VARCHAR2 DEFAULT NULL,
237 p_attribute6 IN VARCHAR2 DEFAULT NULL,
238 p_attribute7 IN VARCHAR2 DEFAULT NULL,
239 p_attribute8 IN VARCHAR2 DEFAULT NULL,
240 p_attribute9 IN VARCHAR2 DEFAULT NULL,
241 p_attribute10 IN VARCHAR2 DEFAULT NULL,
242 p_attribute11 IN VARCHAR2 DEFAULT NULL,
243 p_attribute12 IN VARCHAR2 DEFAULT NULL,
244 p_attribute13 IN VARCHAR2 DEFAULT NULL,
245 p_attribute14 IN VARCHAR2 DEFAULT NULL,
246 p_attribute15 IN VARCHAR2 DEFAULT NULL,
247 x_work_request_id OUT NOCOPY NUMBER,
248 x_resultout OUT NOCOPY VARCHAR2,
249 x_error_message OUT NOCOPY VARCHAR2,
250 x_return_status OUT NOCOPY VARCHAR2,
251 x_msg_count OUT NOCOPY NUMBER,
252 x_msg_data OUT NOCOPY VARCHAR2
253 ) ;
254
255
256 PROCEDURE check_product_install(
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_appl_id IN NUMBER,
262 p_dep_appl_id IN Number,
263 x_installed OUT NOCOPY NUMBER,
264 x_return_status OUT NOCOPY VARCHAR2,
265 x_msg_count OUT NOCOPY NUMBER,
266 x_msg_data OUT NOCOPY VARCHAR2
267 );
268
269 function validate_desc_flex_field
270 (
271 p_app_short_name IN VARCHAR:='EAM',
272 p_desc_flex_name IN VARCHAR,
273 p_ATTRIBUTE_CATEGORY IN VARCHAR2 default null,
274 p_ATTRIBUTE1 IN VARCHAR2 default null,
275 p_ATTRIBUTE2 IN VARCHAR2 default null,
276 p_ATTRIBUTE3 IN VARCHAR2 default null,
277 p_ATTRIBUTE4 IN VARCHAR2 default null,
278 p_ATTRIBUTE5 IN VARCHAR2 default null,
279 p_ATTRIBUTE6 IN VARCHAR2 default null,
280 p_ATTRIBUTE7 IN VARCHAR2 default null,
281 p_ATTRIBUTE8 IN VARCHAR2 default null,
282 p_ATTRIBUTE9 IN VARCHAR2 default null,
283 p_ATTRIBUTE10 IN VARCHAR2 default null,
284 p_ATTRIBUTE11 IN VARCHAR2 default null,
285 p_ATTRIBUTE12 IN VARCHAR2 default null,
286 p_ATTRIBUTE13 IN VARCHAR2 default null,
287 p_ATTRIBUTE14 IN VARCHAR2 default null,
288 p_ATTRIBUTE15 IN VARCHAR2 default null,
289 x_error_segments OUT NOCOPY NUMBER,
290 x_error_message OUT NOCOPY VARCHAR2
291 )
292 return boolean;
293
294
295
296 end WIP_EAM_WORKREQUEST_PVT;
[Home] [Help]