[Home] [Help]
PACKAGE: APPS.CS_SERVICEREQUEST_PVT
Source
1 PACKAGE CS_ServiceRequest_PVT AUTHID CURRENT_USER AS
2 /* $Header: csvsrs.pls 120.9.12020000.3 2013/01/30 05:56:20 lkullamb ship $ */
3 -- -----------------------------------------------------------------------------
4 -- Structure Name : related_data_type
5 -- components :
6 -- close_flag Close flag asociated with SR status
7 -- old_close_flag Close flag asociated with new value of SR
8 -- status before update
9 -- disallow_request_update Request update indicator associated with new
10 -- value of SR status
11 -- old_disallow_request_update Request update indicator associated with SR
12 -- status before update
13 -- disallow_owner_update Request owner update ind associated with
14 -- new value of SR status
15 -- old_disallow_owner_update Request owner update ind associated with
16 -- SR status before update
17 -- disallow_product_update Request product update ind associated with
18 -- new value of SR status
19 -- old_disallow_product_update Request product update ind associated with
20 -- SR status before update
21 -- pending_approval_flag pending approval flag associated with new
22 -- value of SR status
23 -- old_pending_approval_flag pending approval flag associated with
24 -- SR status before update
25 -- intermediate_status_id intermediate status associated with new
26 -- value of SR
27 -- old_intermediate_status_id intermediate status associated with SR
28 -- before update
29 -- approval_action_status_id approval status associated with new
30 -- value of SR status
31 -- old_approval_action_status_id approval status associated with SR status
32 -- before update
33 -- rejection_action_status_id Rejection status associated with new value
34 -- SR status
35 -- old_rejection_action_status_id Rejection status associated with SR status
36 -- before update
37 -- target_status_id Same as status_id passed to SR API
38 -- autolaunch_workflow_flag Launch workflow flag associated with SR Type
39 -- abort_workflow_close_flag Abort Workflow flag associated with SR Type
40 -- workflow Workflow associated with SR Type
41 -- business_process_id Business process associated with SR Type
42 -- primary_party_id Primary contact for SR
43 -- primary_contact_point_id Contact point for Primary contact
44 -- Description : This structure holds certain attributes related following SR
45 -- attributes
46 -- 1. old value of SR status
47 -- 2. new value of SR status
48 -- 3. new value of SR type
49 -- Modification History
50 -- Date Name Description
51 -- -------- -------- -----------------------------------------------------------
52 -- 07/10/05 smisra Created
53 -- -----------------------------------------------------------------------------
54 TYPE related_data_type IS RECORD
55 ( close_flag cs_incident_statuses_b.close_flag % TYPE
56 , old_close_flag cs_incident_statuses_b.close_flag % TYPE
57 , disallow_request_update cs_incident_statuses_b.disallow_request_update % TYPE
58 , old_disallow_request_update cs_incident_statuses_b.disallow_request_update % TYPE
59 , disallow_owner_update cs_incident_statuses_b.disallow_agent_dispatch % TYPE
60 , old_disallow_owner_update cs_incident_statuses_b.disallow_agent_dispatch % TYPE
61 , disallow_product_update cs_incident_statuses_b.disallow_product_update % TYPE
62 , old_disallow_product_update cs_incident_statuses_b.disallow_product_update % TYPE
63 , pending_approval_flag cs_incident_statuses_b.pending_approval_flag % TYPE
64 , old_pending_approval_flag cs_incident_statuses_b.pending_approval_flag % TYPE
65 , intermediate_status_id cs_incident_statuses_b.intermediate_status_id % TYPE
66 , old_intermediate_status_id cs_incident_statuses_b.intermediate_status_id % TYPE
67 , approval_action_status_id cs_incident_statuses_b.approval_action_status_id % TYPE
68 , old_approval_action_status_id cs_incident_statuses_b.approval_action_status_id % TYPE
69 , rejection_action_status_id cs_incident_statuses_b.rejection_action_status_id % TYPE
70 , old_rejection_action_status_id cs_incident_statuses_b.rejection_action_status_id % TYPE
71 , target_status_id cs_incident_statuses_b.incident_status_id % TYPE
72 , autolaunch_workflow_flag cs_incident_types_b.autolaunch_workflow_flag % TYPE
73 , abort_workflow_close_flag cs_incident_types_b.abort_workflow_close_flag % TYPE
74 , workflow cs_incident_types_b.workflow % TYPE
75 , business_process_id cs_incident_types_b.business_process_id % TYPE
76 , primary_party_id cs_hz_sr_contact_points.party_id % TYPE
77 , primary_contact_point_id cs_hz_sr_contact_points.contact_point_id % TYPE
78 );
79 ------------------------------------------------------------------------
80 -- Set up record types to be used for the Validate_ServiceRequest_Record Procedure
81 ------------------------------------------------------------------------
82 TYPE Request_Validation_Rec_Type IS RECORD
83 ( type_id NUMBER := FND_API.G_MISS_NUM,
84 status_id NUMBER := FND_API.G_MISS_NUM,
85 severity_id NUMBER := FND_API.G_MISS_NUM,
86 urgency_id NUMBER := FND_API.G_MISS_NUM,
87 resource_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
88 owner_id NUMBER := FND_API.G_MISS_NUM,
89 publish_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
90 customer_id NUMBER := FND_API.G_MISS_NUM,
91 employee_id NUMBER := FND_API.G_MISS_NUM,
92 contact_id NUMBER := FND_API.G_MISS_NUM,
93 represented_by_id NUMBER := FND_API.G_MISS_NUM,
94 customer_product_id NUMBER := FND_API.G_MISS_NUM,
95 inventory_item_id NUMBER := FND_API.G_MISS_NUM,
96 inventory_org_id NUMBER := FND_API.G_MISS_NUM,
97 problem_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
98 exp_resolution_date DATE := FND_API.G_MISS_DATE,
99 rma_header_id NUMBER := FND_API.G_MISS_NUM,
100 bill_to_site_use_id NUMBER := FND_API.G_MISS_NUM,
101 bill_to_contact_id NUMBER := FND_API.G_MISS_NUM,
102 ship_to_site_use_id NUMBER := FND_API.G_MISS_NUM,
103 ship_to_contact_id NUMBER := FND_API.G_MISS_NUM,
104 -- Nullified value as thic column will no longer be used and install_site
105 -- id column will be used instead by shijain dec4th 2002
106 install_site_use_id NUMBER := FND_API.G_MISS_NUM,
107 resolution_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
108 act_resolution_date DATE := FND_API.G_MISS_DATE,
109 current_contact_time_diff NUMBER := FND_API.G_MISS_NUM,
110 rep_by_time_difference NUMBER := FND_API.G_MISS_NUM,
111 validate_type VARCHAR2(1) := FND_API.G_FALSE,
112 validate_status VARCHAR2(1) := FND_API.G_FALSE,
113 validate_customer VARCHAR2(1) := FND_API.G_FALSE,
114 validate_employee VARCHAR2(1) := FND_API.G_FALSE,
115 validate_bill_to_site VARCHAR2(1) := FND_API.G_FALSE,
116 validate_ship_to_site VARCHAR2(1) := FND_API.G_FALSE,
117 validate_install_site VARCHAR2(1) := FND_API.G_FALSE,
118 contract_service_id NUMBER := FND_API.G_MISS_NUM,
119 --04/16/01
120 contract_id NUMBER := FND_API.G_MISS_NUM,
121 project_number VARCHAR2(120):= FND_API.G_MISS_CHAR,
122 --04/16/01
123 account_id NUMBER := FND_API.G_MISS_NUM,
124 site_id NUMBER := FND_API.G_MISS_NUM,
125 territory_id NUMBER := FND_API.G_MISS_NUM,
126 platform_id NUMBER := FND_API.G_MISS_NUM,
127 platform_version VARCHAR2(250) := FND_API.G_MISS_CHAR,
128 db_version VARCHAR2(250) := FND_API.G_MISS_CHAR,
129 platform_version_id NUMBER := FND_API.G_MISS_NUM,
130 cp_component_id NUMBER := FND_API.G_MISS_NUM,
131 cp_component_version_id NUMBER := FND_API.G_MISS_NUM,
132 cp_subcomponent_id NUMBER := FND_API.G_MISS_NUM,
133 cp_subcomponent_version_id NUMBER := FND_API.G_MISS_NUM,
134 cp_revision_id NUMBER := FND_API.G_MISS_NUM,
135 language_id NUMBER := FND_API.G_MISS_NUM,
136 inv_item_revision VARCHAR2(240):= FND_API.G_MISS_CHAR,
137 inv_component_id NUMBER:= FND_API.G_MISS_NUM,
138 inv_component_version VARCHAR2(90):= FND_API.G_MISS_CHAR,
139 inv_subcomponent_id NUMBER:= FND_API.G_MISS_NUM,
140 inv_subcomponent_version VARCHAR2(90):= FND_API.G_MISS_CHAR,
141 caller_type VARCHAR2(30):= FND_API.G_MISS_CHAR,
142 primary_contact_id NUMBER:= FND_API.G_MISS_NUM,
143 validate_updated_status VARCHAR2(1) := FND_API.G_FALSE,
144 updated_status_id NUMBER := FND_API.G_MISS_NUM,
145 status_id_change VARCHAR2(1) := FND_API.G_FALSE,
146 current_serial_number VARCHAR2(30) := FND_API.G_MISS_CHAR,
147 -----jngeorge-----enhancements-----11.5.6 ------07/20/01
148 tier VARCHAR2(250) :=FND_API.G_MISS_CHAR,
149 tier_version VARCHAR2(250) := FND_API.G_MISS_CHAR,
150 operating_system VARCHAR2(250) := FND_API.G_MISS_CHAR,
151 operating_system_version VARCHAR2(250) := FND_API.G_MISS_CHAR,
152 database VARCHAR2(250) :=FND_API.G_MISS_CHAR,
153 cust_pref_lang_id NUMBER := FND_API.G_MISS_NUM,
154 category_id NUMBER := FND_API.G_MISS_NUM,
155 owner_group_id NUMBER := FND_API.G_MISS_NUM,
156 group_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
157 group_territory_id NUMBER := FND_API.G_MISS_NUM,
158 inv_platform_org_id NUMBER := FND_API.G_MISS_NUM,
159 product_revision VARCHAR2(240) := FND_API.G_MISS_CHAR,
160 component_version VARCHAR2(3) := FND_API.G_MISS_CHAR,
161 subcomponent_version VARCHAR2(3) := FND_API.G_MISS_CHAR,
162 comm_pref_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
163 cust_pref_lang_code VARCHAR2(4) := FND_API.G_MISS_CHAR,
164 category_set_id NUMBER := FND_API.G_MISS_NUM,
165 external_reference VARCHAR2(30) := FND_API.G_MISS_CHAR,
166 system_id NUMBER := FND_API.G_MISS_NUM,
167 ---- Added for Enh# 1830701
168 request_date DATE := FND_API.G_MISS_DATE,
169 incident_occurred_date DATE := FND_API.G_MISS_DATE,
170 incident_resolved_date DATE := FND_API.G_MISS_DATE,
171 inc_responded_by_date DATE := FND_API.G_MISS_DATE,
172 ---- Added for Enh# 222054
173 incident_location_id NUMBER := FND_API.G_MISS_NUM,
174 incident_country VARCHAR2(60) := FND_API.G_MISS_CHAR,
175 --- Added for ER# 2433831
176 bill_to_account_id NUMBER := FND_API.G_MISS_NUM ,
177 ship_to_account_id NUMBER := FND_API.G_MISS_NUM ,
178 --- Added for ER# 2463321
179 customer_phone_id NUMBER := FND_API.G_MISS_NUM ,
180 customer_email_id NUMBER := FND_API.G_MISS_NUM ,
181 bill_to_party_id NUMBER := FND_API.G_MISS_NUM ,
182 ship_to_party_id NUMBER := FND_API.G_MISS_NUM ,
183 bill_to_site_id NUMBER := FND_API.G_MISS_NUM ,
184 ship_to_site_id NUMBER := FND_API.G_MISS_NUM ,
185
186 -- Added address related columns by shijain 4th dec 2002
187 incident_point_of_interest Varchar2(240):=FND_API.G_MISS_CHAR ,
188 incident_cross_street Varchar2(240):=FND_API.G_MISS_CHAR ,
189 incident_direction_qualifier Varchar2(30):=FND_API.G_MISS_CHAR,
190 incident_distance_qualifier Varchar2(240):=FND_API.G_MISS_CHAR ,
191 incident_distance_qual_uom Varchar2(30):=FND_API.G_MISS_CHAR,
192 incident_address2 Varchar2(240):=FND_API.G_MISS_CHAR ,
193 incident_address3 Varchar2(240):=FND_API.G_MISS_CHAR,
194 incident_address4 Varchar2(240):=FND_API.G_MISS_CHAR ,
195 incident_address_style Varchar2(30):=FND_API.G_MISS_CHAR,
196 incident_addr_lines_phonetic Varchar2(560):=FND_API.G_MISS_CHAR ,
197 incident_po_box_number Varchar2(50):=FND_API.G_MISS_CHAR ,
198 incident_house_number Varchar2(50):=FND_API.G_MISS_CHAR,
199 incident_street_suffix Varchar2(50):=FND_API.G_MISS_CHAR ,
200 incident_street Varchar2(150):=FND_API.G_MISS_CHAR,
201 incident_street_number Varchar2(50):=FND_API.G_MISS_CHAR ,
202 incident_floor Varchar2(50):=FND_API.G_MISS_CHAR ,
203 incident_suite Varchar2(50):=FND_API.G_MISS_CHAR ,
204 incident_postal_plus4_code Varchar2(30):=FND_API.G_MISS_CHAR ,
205 incident_position Varchar2(50):=FND_API.G_MISS_CHAR ,
206 incident_location_directions Varchar2(640):=FND_API.G_MISS_CHAR,
207 incident_location_description Varchar2(2000):=FND_API.G_MISS_CHAR ,
208 install_site_id NUMBER := FND_API.G_MISS_NUM ,
209 group_owner Varchar2(60):=FND_API.G_MISS_CHAR,
210 owner Varchar2(360):=FND_API.G_MISS_CHAR,
211 --------------------anmukher--------------------08/01/03
212 -- Added for CMRO-EAM project of Release 11.5.10
213 item_serial_number VARCHAR2(30) := FND_API.G_MISS_CHAR,
214 owning_dept_id NUMBER := FND_API.G_MISS_NUM,
215 ---------------------anmukher--------------------08/18/03
216 incident_location_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
217 --Added for bug 3635269
218 sr_creation_channel VARCHAR2(50) := FND_API.G_MISS_CHAR,
219 maint_organization_id NUMBER := FND_API.G_MISS_NUM,
220 old_type_id NUMBER,
221 -- Credit Card 9358401
222 instrument_payment_use_id Number := FND_API.G_MISS_NUM,
223 --12.2 + project siahmed added for integration with Oracle Projects
224 project_id Number := FND_API.G_MISS_NUM,
225 project_task_id Number := FND_API.G_MISS_NUM,
226 expenditure_org_id Number := FND_API.G_MISS_NUM,
227 --14004721 . Additional SLA dates
228 sla_date_1 DATE := FND_API.G_MISS_DATE,
229 sla_date_2 DATE := FND_API.G_MISS_DATE,
230 sla_date_3 DATE := FND_API.G_MISS_DATE,
231 sla_date_4 DATE := FND_API.G_MISS_DATE,
232 sla_date_5 DATE := FND_API.G_MISS_DATE,
233 sla_date_6 DATE := FND_API.G_MISS_DATE,
234 sla_duration_1 NUMBER := FND_API.G_MISS_NUM,
235 sla_duration_2 NUMBER := FND_API.G_MISS_NUM,
236 --15995804. Add price_list_header_id
237 price_list_header_id NUMBER := FND_API.G_MISS_NUM
238 );
239 --------------------------------------------------------------------------
240 -- Start of comments
241 -- Record Type : Request_Validation_Rec_Type
242 -- Description : Holds the Service Request attribute Ids for validation.
243 -- type_id NUMBER Optional
244 -- Service request type identifier
245 -- status_id NUMBER Optional
246 -- Service request status identifier
247 -- severity_id NUMBER Optional
248 -- Service request severity identifier
249 -- urgency_id NUMBER Optional
250 -- Service request urgency identifier
251 -----------------------------------------------------
252 -- This field is no longer there in the Request_Validation_Rec_Type
253 -- closed_date DATE Optional
254 -- Closed Date
255 ------------------------------------------------------
256 -- resource_type VARCHAR2 Optional
257
258 -- owner_id NUMBER Optional
259 -- Service request owner identifier
260 --
261 -- publish_flag VARCHAR2(1) Optional
262
263 -- customer_id NUMBER Optional
264 -- Service request customer identifier
265
266 -- employee_id NUMBER Optional
267
268 -- contact_id NUMBER Optional
269 -- Customer contact identifier
270
271 -- represented_by_id NUMBER Optional
272 -- Represented By identifier
273
274 -- customer_product_id NUMBER Optional
275 -- Unique identifier for a customer product in the Installed Base
276
277 -- inventory_item_id NUMBER Optional
278 -- Inventory item identifier
279
280 -- problem_code VARCHAR2(30) Optional
281 -- Service request problem code
282
283 -- exp_resolution_date DATE Optional
284 -- Expected resolution date
285
286 -- rma_header_id NUMBER Optional
287 -- Sales order header identifier of the RMA
288
289 -- bill_to_site_use_id NUMBER Optional
290 -- Bill To site use identifier
291
292 -- bill_to_contact_id NUMBER Optional
293 -- Bill To contact identifier
294
295 -- ship_to_site_use_id NUMBER Optional
296 -- Ship To site use identifier
297
298 -- ship_to_contact_id NUMBER Optional
299 -- Ship To contact identifier
300
301 -- install_site_use_id NUMBER Optional
302 -- Install site use identifier
303
304 -- resolution_code VARCHAR2(30) Optional
305 -- Service request resolution code
306
307 -- act_resolution_date DATE Optional
308 -- Actual resolution date
309
310 -- current_contact_time_diff NUMBER Optional
311 -- Current Contact Time Diff
312
313 -- rep_by_time_difference NUMBER Optional
314 -- Represented By Time Diff
315
316 -- validate_type VARCHAR2(1) Optional
317 -- Whether or not to validate type_id
318
319 -- validate_status VARCHAR2(1) Optional
320 -- Whether or not to validate status_id
321
322 -- validate_customer VARCHAR2(1) Optional
323 -- Whether or not to validate customer_id
324
325 -- validate_employee VARCHAR2(1) Optional
326 -- Whether or not to validate employee_id
327
328 -- validate_bill_to_site VARCHAR2(1) Optional
329 -- Whether or not to validate bill_to_site_use_id
330
331 -- validate_ship_to_site VARCHAR2(1) Optional
332 -- Whether or not to validate ship_to_site_use_id
333
334 -- validate_install_site VARCHAR2(1) Optional
335 -- Whether or not to validate install_site_use_id
336
337 -- coverage_type VARCHAR2(30) Optional
338 -- Service Request Coverage Type
339
340 -- bill_to_account_id NUMBER Optional
341 -- Service Request Bill To Account Identifier
342
343 -- ship_to_account_id NUMBER Optional
344 -- Service Request Ship To Account Identifier
345
346 -- customer_phone_id NUMBER Optional
347 -- SR Customer's non-primary phone Id
348
349 -- customer_email_id NUMBER Optional
350 -- SR Customer's non-primary Email Id
351 -- End of comments
352
353 --------------------------------------------------------------------------
354 -- Start of comments
355 -- Procedure : Validate_ServiceRequest_Record
356 -- Description : Validate all non-missing record fields.
357 -- Parameters :
358 -- IN :
359 -- p_api_name IN VARCHAR2 Required
360 -- Name of the calling procedure.
361 -- p_service_request_rec IN Request_Validation_Rec_Type Required
362 -- Record which holds all the non-missing record fields to be
363 -- validated.
364 -- p_request_date IN DATE Optional
365 -- Service request date; required for closed date, expected
366 -- resolution date, and actual resolution date validation.
367 -- p_org_id IN NUMBER Optional
368 -- Operating unit identifier; required for owner, customer
369 -- contact, customer product, sales order (RMA), Bill To site,
370 -- Bill To contact, Ship To site, Ship To contact validation.
371 -- p_resp_appl_id IN NUMBER Optional
372 -- p_resp_id IN NUMBER Optional
373 -- p_user_id IN NUMBER Optional
374 -- p_inventory_org_id IN NUMBER Optional
375 -- Organization identifier; required for inventory item
376 -- validation.
377 -- OUT :
378 -- p_close_flag OUT VARCHAR2(1)
379 -- Returned iff status_id is passed
380 -- 'Y' => the given status is a "closed" status
381 -- p_employee_name OUT VARCHAR2(240)
382 -- Returned iff employee_id is passed
383
384 -- The following 3 fields are returned iff type_id is passed.
385 -- p_autolaunch_workflow_flag OUT VARCHAR2,
386 -- p_abort_workflow_close_flag OUT VARCHAR2,
387 -- p_workflow_process_name OUT VARCHAR2,
388 -- p_inventory_item_id OUT NUMBER
389 -- Returned iff customer_product_id is passed
390 -- Identifies an item for a customer product
391 -- p_return_status OUT VARCHAR2(1)
392 -- FND_API.G_RET_STS_SUCCESS => all non-missing fields are valid
393 -- FND_API.G_RET_STS_ERROR => one or more non-missing fields
394 -- are invalid
395 -- Notes :
396 -- Please take into considerations the following dependencies when
397 -- passing in parameters and record fields. For example, the status of
398 -- the service request has dependency on the type of the service request.
399 -- Therefore, the request type must be passed in for status validation.
400 -- 1. type_id requires status_id
401 -- 2. status_id requires type_id
402 -- 3. closed_date requires p_request_date
403 -- 4. owner_id requires p_org_id
404 -- 5. publish_flag requires p_resp_appl_id, p_resp_id,
405 -- p_user_id
406 -- 6. employee_id requires p_org_id
407 -- 7. contact_id requires p_org_id, customer_id or
408 -- customer_product_id
409 -- 8. customer_product_id requires p_org_id
410 -- 9. inventory_item_id requires p_inventory_org_id
411 -- 10. exp_resolution_date requires p_request_date
412 -- 11. rma_header_id requires p_org_id, customer_id or
413 -- customer_product_id
414 -- 12. bill_to_site_use_id requires p_org_id, customer_id or
415 -- customer_product_id
416 -- 13. bill_to_contact_id requires p_org_id, bill_to_site_use_id or
417 -- customer_id or customer_product_id
418 -- 14. ship_to_site_use_id requires p_org_id, customer_id or
419 -- customer_product_id
420 -- 15. ship_to_contact_id requires p_org_id, ship_to_site_use_id or
421 -- customer_id or customer_product_id
422 -- 16. act_resolution_date requires request_date
423 -- End of comments
424 --------------------------------------------------------------------------
425
426 -----------------------------------------------------------
427 -- Set up record types to be used for the audit record API
428 -----------------------------------------------------------
429 /*************** Comment out these 3 audit recs and use New Audit Rec **
430 TYPE audit_flags_rec_type IS RECORD (
431 change_status VARCHAR2(1) := FND_API.G_FALSE,
432 change_owner VARCHAR2(1) := FND_API.G_FALSE,
433 change_group VARCHAR2(1) := FND_API.G_FALSE,
434 change_group_type VARCHAR2(1) := FND_API.G_FALSE,
435 change_assigned_time VARCHAR2(1) := FND_API.G_FALSE,
436 change_platform_org_id VARCHAR2(1) := FND_API.G_FALSE,
437 change_type VARCHAR2(1) := FND_API.G_FALSE,
438 change_urgency VARCHAR2(1) := FND_API.G_FALSE,
439 change_severity VARCHAR2(1) := FND_API.G_FALSE,
440 change_exp_res_date VARCHAR2(1) := FND_API.G_FALSE,
441 new_action VARCHAR2(1) := FND_API.G_FALSE,
442 new_workflow VARCHAR2(1) := FND_API.G_FALSE,
443 change_obligation_date VARCHAR2(1) := FND_API.G_FALSE,
444 change_site_id VARCHAR2(1) := FND_API.G_FALSE,
445 change_contact_id VARCHAR2(1) := FND_API.G_FALSE,
446 change_bill_to_contact_id VARCHAR2(1) := FND_API.G_FALSE,
447 change_ship_to_contact_id VARCHAR2(1) := FND_API.G_FALSE,
448 change_incident_date VARCHAR2(1) := FND_API.G_FALSE,
449 change_close_date VARCHAR2(1) := FND_API.G_FALSE,
450 change_customer_product_id VARCHAR2(1) := FND_API.G_FALSE,
451 change_platform_id VARCHAR2(1) := FND_API.G_FALSE,
452 change_plat_ver_id VARCHAR2(1) := FND_API.G_FALSE,
453 change_cp_comp_id VARCHAR2(1) := FND_API.G_FALSE,
454 change_cp_pro_rev VARCHAR2(1) := FND_API.G_FALSE,
455 change_cp_comp_ver_id VARCHAR2(1) := FND_API.G_FALSE,
456 change_cp_comp_ver VARCHAR2(1) := FND_API.G_FALSE,
457 change_cp_subcomp_id VARCHAR2(1) := FND_API.G_FALSE,
458 change_cp_subcomp_ver VARCHAR2(1) := FND_API.G_FALSE,
459 change_cp_subcomp_ver_id VARCHAR2(1) := FND_API.G_FALSE,
460 change_language_id VARCHAR2(1) := FND_API.G_FALSE,
461 change_cp_rev_id VARCHAR2(1) := FND_API.G_FALSE,
462 change_inv_item_rev VARCHAR2(1) := FND_API.G_FALSE,
463 change_inv_comp_id VARCHAR2(1) := FND_API.G_FALSE,
464 change_inv_comp_ver VARCHAR2(1) := FND_API.G_FALSE,
465 change_inv_subcomp_id VARCHAR2(1) := FND_API.G_FALSE,
466 change_inv_subcomp_ver VARCHAR2(1) := FND_API.G_FALSE,
467 change_territory_id VARCHAR2(1) := FND_API.G_FALSE,
468 change_resource_type VARCHAR2(1) := FND_API.G_FALSE
469 );
470
471 TYPE audit_vals_rec_type IS RECORD (
472 status_id NUMBER := FND_API.G_MISS_NUM,
473 owner_id NUMBER := FND_API.G_MISS_NUM,
474 group_id NUMBER := FND_API.G_MISS_NUM,
475 group_type VARCHAR2(30) :=FND_API.G_MISS_CHAR,
476 owner_assigned_time DATE := FND_API.G_MISS_DATE,
477 inv_platform_org_id NUMBER := FND_API.G_MISS_NUM,
478 type_id NUMBER := FND_API.G_MISS_NUM,
479 urgency_id NUMBER := FND_API.G_MISS_NUM,
480 severity_id NUMBER := FND_API.G_MISS_NUM,
481 exp_res_date DATE := FND_API.G_MISS_DATE,
482 obligation_date DATE := FND_API.G_MISS_DATE,
483 site_id NUMBER := FND_API.G_MISS_NUM,
484 contact_id NUMBER := FND_API.G_MISS_NUM,
485 bill_to_contact_id NUMBER := FND_API.G_MISS_NUM,
486 ship_to_contact_id NUMBER := FND_API.G_MISS_NUM,
487 incident_date DATE := FND_API.G_MISS_DATE,
488 close_date DATE := FND_API.G_MISS_DATE,
489 customer_product_id NUMBER := FND_API.G_MISS_NUM,
490 platform_id NUMBER := FND_API.G_MISS_NUM,
491 platform_version_id NUMBER := FND_API.G_MISS_NUM,
492 cp_component_id NUMBER := FND_API.G_MISS_NUM,
493 product_revision VARCHAR2(240):= FND_API.G_MISS_CHAR,
494 cp_component_version_id NUMBER := FND_API.G_MISS_NUM,
495 component_version VARCHAR2(3):= FND_API.G_MISS_CHAR,
496 cp_subcomponent_id NUMBER := FND_API.G_MISS_NUM,
497 cp_subcomponent_version_id NUMBER := FND_API.G_MISS_NUM,
498 subcomponent_version VARCHAR2(3):= FND_API.G_MISS_CHAR,
499 language_id NUMBER := FND_API.G_MISS_NUM,
500 cp_revision_id NUMBER := FND_API.G_MISS_NUM,
501 inv_item_revision VARCHAR2(240) := FND_API.G_MISS_CHAR,
502 inv_component_id NUMBER := FND_API.G_MISS_NUM,
503 inv_component_version VARCHAR2(90) := FND_API.G_MISS_CHAR,
504 inv_subcomponent_id NUMBER := FND_API.G_MISS_NUM,
505 inv_subcomponent_version VARCHAR2(90) := FND_API.G_MISS_CHAR,
506 territory_id NUMBER := FND_API.G_MISS_NUM,
507 resource_type VARCHAR2(30) := FND_API.G_MISS_CHAR
508 );
509 G_MISS_AUDIT_VALS_REC audit_vals_rec_type;
510 ********** End of Comments - Use the Ne Audit Record ***/
511
512 TYPE sr_audit_rec_type IS RECORD (
513 INCIDENT_STATUS_ID NUMBER(15) ,
514 OLD_INCIDENT_STATUS_ID NUMBER(15) ,
515 CHANGE_INCIDENT_STATUS_FLAG VARCHAR2(1),
516 INCIDENT_TYPE_ID NUMBER(15) ,
517 OLD_INCIDENT_TYPE_ID NUMBER(15) ,
518 CHANGE_INCIDENT_TYPE_FLAG VARCHAR2(1),
519 INCIDENT_URGENCY_ID NUMBER(15) ,
520 OLD_INCIDENT_URGENCY_ID NUMBER(15) ,
521 CHANGE_INCIDENT_URGENCY_FLAG VARCHAR2(1),
522 INCIDENT_SEVERITY_ID NUMBER(15) ,
523 OLD_INCIDENT_SEVERITY_ID NUMBER(15) ,
524 CHANGE_INCIDENT_SEVERITY_FLAG VARCHAR2(1),
525 RESPONSIBLE_GROUP_ID NUMBER(15) ,
526 OLD_RESPONSIBLE_GROUP_ID NUMBER(15) ,
527 CHANGE_RESPONSIBLE_GROUP_FLAG VARCHAR2(1),
528 INCIDENT_OWNER_ID NUMBER(15) ,
529 OLD_INCIDENT_OWNER_ID NUMBER(15) ,
530 CHANGE_INCIDENT_OWNER_FLAG VARCHAR2(1),
531 CREATE_MANUAL_ACTION VARCHAR2(1),
532 ACTION_ID NUMBER(15) ,
533 EXPECTED_RESOLUTION_DATE DATE ,
534 OLD_EXPECTED_RESOLUTION_DATE DATE ,
535 CHANGE_RESOLUTION_FLAG VARCHAR2(1) ,
536 NEW_WORKFLOW_FLAG VARCHAR2(1) ,
537 WORKFLOW_PROCESS_NAME VARCHAR2(30),
538 WORKFLOW_PROCESS_ITEMKEY VARCHAR2(240),
539 GROUP_ID NUMBER ,
540 OLD_GROUP_ID NUMBER ,
541 CHANGE_GROUP_FLAG VARCHAR2(1) ,
542 OBLIGATION_DATE DATE ,
543 OLD_OBLIGATION_DATE DATE ,
544 CHANGE_OBLIGATION_FLAG VARCHAR2(1) ,
545 SITE_ID NUMBER ,
546 OLD_SITE_ID NUMBER ,
547 CHANGE_SITE_FLAG VARCHAR2(1),
548 BILL_TO_CONTACT_ID NUMBER(15) ,
549 OLD_BILL_TO_CONTACT_ID NUMBER(15) ,
550 CHANGE_BILL_TO_FLAG VARCHAR2(1),
551 SHIP_TO_CONTACT_ID NUMBER(15) ,
552 OLD_SHIP_TO_CONTACT_ID NUMBER(15) ,
553 CHANGE_SHIP_TO_FLAG VARCHAR2(1) ,
554 INCIDENT_DATE DATE ,
555 OLD_INCIDENT_DATE DATE ,
556 CHANGE_INCIDENT_DATE_FLAG VARCHAR2(1) ,
557 CLOSE_DATE DATE ,
558 OLD_CLOSE_DATE DATE ,
559 CHANGE_CLOSE_DATE_FLAG VARCHAR2(1) ,
560 CUSTOMER_PRODUCT_ID NUMBER(15) ,
561 OLD_CUSTOMER_PRODUCT_ID NUMBER(15) ,
562 CHANGE_CUSTOMER_PRODUCT_FLAG VARCHAR2(1) ,
563 PLATFORM_ID NUMBER ,
564 OLD_PLATFORM_ID NUMBER ,
565 CHANGE_PLATFORM_ID_FLAG VARCHAR2(1) ,
566 PLATFORM_VERSION_ID NUMBER ,
567 OLD_PLATFORM_VERSION_ID NUMBER ,
568 CHANGE_PLAT_VER_ID_FLAG VARCHAR2(1) ,
569 CP_COMPONENT_ID NUMBER ,
570 OLD_CP_COMPONENT_ID NUMBER ,
571 CHANGE_CP_COMPONENT_ID_FLAG VARCHAR2(1) ,
572 CP_COMPONENT_VERSION_ID NUMBER ,
573 OLD_CP_COMPONENT_VERSION_ID NUMBER ,
574 CHANGE_CP_COMP_VER_ID_FLAG VARCHAR2(1) ,
575 CP_SUBCOMPONENT_ID NUMBER ,
576 OLD_CP_SUBCOMPONENT_ID NUMBER ,
577 CHANGE_CP_SUBCOMPONENT_ID_FLAG VARCHAR2(1) ,
578 CP_SUBCOMPONENT_VERSION_ID NUMBER ,
579 OLD_CP_SUBCOMPONENT_VERSION_ID NUMBER ,
580 CHANGE_CP_SUBCOMP_VER_ID_FLAG VARCHAR2(1) ,
581 LANGUAGE_ID NUMBER ,
582 OLD_LANGUAGE_ID NUMBER ,
583 CHANGE_LANGUAGE_ID_FLAG VARCHAR2(1) ,
584 TERRITORY_ID NUMBER ,
585 OLD_TERRITORY_ID NUMBER ,
586 CHANGE_TERRITORY_ID_FLAG VARCHAR2(1) ,
587 CP_REVISION_ID NUMBER ,
588 OLD_CP_REVISION_ID NUMBER ,
589 CHANGE_CP_REVISION_ID_FLAG VARCHAR2(1) ,
590 INV_ITEM_REVISION VARCHAR2(240) ,
591 OLD_INV_ITEM_REVISION VARCHAR2(240) ,
592 CHANGE_INV_ITEM_REVISION VARCHAR2(1) ,
593 INV_COMPONENT_ID NUMBER ,
594 OLD_INV_COMPONENT_ID NUMBER ,
595 CHANGE_INV_COMPONENT_ID VARCHAR2(1) ,
596 INV_COMPONENT_VERSION VARCHAR2(90) ,
597 OLD_INV_COMPONENT_VERSION VARCHAR2(90) ,
598 CHANGE_INV_COMPONENT_VERSION VARCHAR2(1) ,
599 INV_SUBCOMPONENT_ID NUMBER ,
600 OLD_INV_SUBCOMPONENT_ID NUMBER ,
601 CHANGE_INV_SUBCOMPONENT_ID VARCHAR2(1) ,
602 INV_SUBCOMPONENT_VERSION VARCHAR2(90) ,
603 OLD_INV_SUBCOMPONENT_VERSION VARCHAR2(90) ,
604 CHANGE_INV_SUBCOMP_VERSION VARCHAR2(1) ,
605 RESOURCE_TYPE VARCHAR2(30) ,
606 OLD_RESOURCE_TYPE VARCHAR2(30) ,
607 CHANGE_RESOURCE_TYPE_FLAG VARCHAR2(1) ,
608 SECURITY_GROUP_ID NUMBER ,
609 UPGRADED_STATUS_FLAG VARCHAR2(1) ,
610 OLD_GROUP_TYPE VARCHAR2(30) ,
611 GROUP_TYPE VARCHAR2(30) ,
612 CHANGE_GROUP_TYPE_FLAG VARCHAR2(1) ,
613 OLD_OWNER_ASSIGNED_TIME DATE ,
614 OWNER_ASSIGNED_TIME DATE ,
615 CHANGE_ASSIGNED_TIME_FLAG VARCHAR2(1) ,
616 INV_PLATFORM_ORG_ID NUMBER ,
617 OLD_INV_PLATFORM_ORG_ID NUMBER ,
618 CHANGE_PLATFORM_ORG_ID_FLAG VARCHAR2(1) ,
619 COMPONENT_VERSION VARCHAR2(3) ,
620 OLD_COMPONENT_VERSION VARCHAR2(3) ,
621 CHANGE_COMP_VER_FLAG VARCHAR2(1) ,
622 SUBCOMPONENT_VERSION VARCHAR2(3) ,
623 OLD_SUBCOMPONENT_VERSION VARCHAR2(3) ,
624 CHANGE_SUBCOMP_VER_FLAG VARCHAR2(1) ,
625 PRODUCT_REVISION VARCHAR2(240) ,
626 OLD_PRODUCT_REVISION VARCHAR2(240) ,
627 CHANGE_PRODUCT_REVISION_FLAG VARCHAR2(1) ,
628 STATUS_FLAG VARCHAR2(3) ,
629 OLD_STATUS_FLAG VARCHAR2(3) ,
630 CHANGE_STATUS_FLAG VARCHAR2(3) ,
631 INVENTORY_ITEM_ID NUMBER(15),
632 OLD_INVENTORY_ITEM_ID NUMBER(15),
633 CHANGE_INVENTORY_ITEM_FLAG VARCHAR2(3),
634 INV_ORGANIZATION_ID NUMBER,
635 OLD_INV_ORGANIZATION_ID NUMBER,
636 CHANGE_INV_ORGANIZATION_FLAG VARCHAR2(3),
637 PRIMARY_CONTACT_ID NUMBER,
638 CHANGE_PRIMARY_CONTACT_FLAG VARCHAR2(3),
639 OLD_PRIMARY_CONTACT_ID NUMBER,
640 -- Added for Enhanced Auditing features in 11.5.10 --anmukher --09/02/03
641 UPGRADE_FLAG_FOR_CREATE VARCHAR2(1),
642 OLD_INCIDENT_NUMBER VARCHAR2(64),
643 INCIDENT_NUMBER VARCHAR2(64),
644 OLD_CUSTOMER_ID NUMBER(15),
645 CUSTOMER_ID NUMBER(15),
646 OLD_BILL_TO_SITE_USE_ID NUMBER(15),
647 BILL_TO_SITE_USE_ID NUMBER(15),
648 OLD_EMPLOYEE_ID NUMBER(15),
649 EMPLOYEE_ID NUMBER(15),
650 OLD_SHIP_TO_SITE_USE_ID NUMBER(15),
651 SHIP_TO_SITE_USE_ID NUMBER(15),
652 OLD_PROBLEM_CODE VARCHAR2(50),
653 PROBLEM_CODE VARCHAR2(50),
654 OLD_ACTUAL_RESOLUTION_DATE DATE,
655 ACTUAL_RESOLUTION_DATE DATE,
656 OLD_INSTALL_SITE_USE_ID NUMBER(15),
657 INSTALL_SITE_USE_ID NUMBER(15),
658 -- OLD_PRODUCT_DESCRIPTION VARCHAR2(240),
659 -- PRODUCT_DESCRIPTION VARCHAR2(240),
660 OLD_CURRENT_SERIAL_NUMBER VARCHAR2(30),
661 CURRENT_SERIAL_NUMBER VARCHAR2(30),
662 OLD_SYSTEM_ID NUMBER(15),
663 SYSTEM_ID NUMBER(15),
664 OLD_INCIDENT_ATTRIBUTE_1 VARCHAR2(150),
665 INCIDENT_ATTRIBUTE_1 VARCHAR2(150),
666 OLD_INCIDENT_ATTRIBUTE_2 VARCHAR2(150),
667 INCIDENT_ATTRIBUTE_2 VARCHAR2(150),
668 OLD_INCIDENT_ATTRIBUTE_3 VARCHAR2(150),
669 INCIDENT_ATTRIBUTE_3 VARCHAR2(150),
670 OLD_INCIDENT_ATTRIBUTE_4 VARCHAR2(150),
671 INCIDENT_ATTRIBUTE_4 VARCHAR2(150),
672 OLD_INCIDENT_ATTRIBUTE_5 VARCHAR2(150),
673 INCIDENT_ATTRIBUTE_5 VARCHAR2(150),
674 OLD_INCIDENT_ATTRIBUTE_6 VARCHAR2(150),
675 INCIDENT_ATTRIBUTE_6 VARCHAR2(150),
676 OLD_INCIDENT_ATTRIBUTE_7 VARCHAR2(150),
677 INCIDENT_ATTRIBUTE_7 VARCHAR2(150),
678 OLD_INCIDENT_ATTRIBUTE_8 VARCHAR2(150),
679 INCIDENT_ATTRIBUTE_8 VARCHAR2(150),
680 OLD_INCIDENT_ATTRIBUTE_9 VARCHAR2(150),
681 INCIDENT_ATTRIBUTE_9 VARCHAR2(150),
682 OLD_INCIDENT_ATTRIBUTE_10 VARCHAR2(150),
683 INCIDENT_ATTRIBUTE_10 VARCHAR2(150),
684 OLD_INCIDENT_ATTRIBUTE_11 VARCHAR2(150),
685 INCIDENT_ATTRIBUTE_11 VARCHAR2(150),
686 OLD_INCIDENT_ATTRIBUTE_12 VARCHAR2(150),
687 INCIDENT_ATTRIBUTE_12 VARCHAR2(150),
688 OLD_INCIDENT_ATTRIBUTE_13 VARCHAR2(150),
689 INCIDENT_ATTRIBUTE_13 VARCHAR2(150),
690 OLD_INCIDENT_ATTRIBUTE_14 VARCHAR2(150),
691 INCIDENT_ATTRIBUTE_14 VARCHAR2(150),
692 OLD_INCIDENT_ATTRIBUTE_15 VARCHAR2(150),
693 INCIDENT_ATTRIBUTE_15 VARCHAR2(150),
694 OLD_INCIDENT_CONTEXT VARCHAR2(30),
695 INCIDENT_CONTEXT VARCHAR2(30),
696 OLD_RESOLUTION_CODE VARCHAR2(50),
697 RESOLUTION_CODE VARCHAR2(50),
698 OLD_ORIGINAL_ORDER_NUMBER NUMBER,
699 ORIGINAL_ORDER_NUMBER NUMBER,
700 OLD_ORG_ID NUMBER,
701 ORG_ID NUMBER,
702 OLD_PURCHASE_ORDER_NUMBER VARCHAR2(50),
703 PURCHASE_ORDER_NUMBER VARCHAR2(50),
704 OLD_PUBLISH_FLAG VARCHAR2(1),
705 PUBLISH_FLAG VARCHAR2(1),
706 OLD_QA_COLLECTION_ID NUMBER,
707 QA_COLLECTION_ID NUMBER,
708 OLD_CONTRACT_ID NUMBER,
709 CONTRACT_ID NUMBER,
710 OLD_CONTRACT_NUMBER VARCHAR2(120),
711 CONTRACT_NUMBER VARCHAR2(120),
712 OLD_CONTRACT_SERVICE_ID NUMBER,
713 CONTRACT_SERVICE_ID NUMBER,
714 OLD_TIME_ZONE_ID NUMBER(15),
715 TIME_ZONE_ID NUMBER(15),
716 OLD_ACCOUNT_ID NUMBER,
717 ACCOUNT_ID NUMBER,
718 OLD_TIME_DIFFERENCE NUMBER,
719 TIME_DIFFERENCE NUMBER,
720 OLD_CUSTOMER_PO_NUMBER VARCHAR2(50),
721 CUSTOMER_PO_NUMBER VARCHAR2(50),
722 OLD_CUSTOMER_TICKET_NUMBER VARCHAR2(50),
723 CUSTOMER_TICKET_NUMBER VARCHAR2(50),
724 OLD_CUSTOMER_SITE_ID NUMBER,
725 CUSTOMER_SITE_ID NUMBER,
726 OLD_CALLER_TYPE VARCHAR2(30),
727 CALLER_TYPE VARCHAR2(30),
728 OLD_SECURITY_GROUP_ID NUMBER(15),
729 OLD_ORIG_SYSTEM_REFERENCE VARCHAR2(60),
730 ORIG_SYSTEM_REFERENCE VARCHAR2(60),
731 OLD_ORIG_SYSTEM_REFERENCE_ID NUMBER,
732 ORIG_SYSTEM_REFERENCE_ID NUMBER,
733 REQUEST_ID NUMBER(15),
734 PROGRAM_APPLICATION_ID NUMBER(15),
735 PROGRAM_ID NUMBER(15),
736 PROGRAM_UPDATE_DATE DATE,
737 OLD_PROJECT_NUMBER VARCHAR2(120),
738 PROJECT_NUMBER VARCHAR2(120),
739 OLD_PLATFORM_VERSION VARCHAR2(250),
740 PLATFORM_VERSION VARCHAR2(250),
741 OLD_DB_VERSION VARCHAR2(250),
742 DB_VERSION VARCHAR2(250),
743 OLD_CUST_PREF_LANG_ID NUMBER,
744 CUST_PREF_LANG_ID NUMBER,
745 OLD_TIER VARCHAR2(250),
746 TIER VARCHAR2(250),
747 OLD_CATEGORY_ID NUMBER,
748 CATEGORY_ID NUMBER,
749 OLD_OPERATING_SYSTEM VARCHAR2(250),
750 OPERATING_SYSTEM VARCHAR2(250),
751 OLD_OPERATING_SYSTEM_VERSION VARCHAR2(250),
752 OPERATING_SYSTEM_VERSION VARCHAR2(250),
753 OLD_DATABASE VARCHAR2(250),
754 DATABASE VARCHAR2(250),
755 OLD_GROUP_TERRITORY_ID NUMBER,
756 GROUP_TERRITORY_ID NUMBER,
757 OLD_COMM_PREF_CODE VARCHAR2(30),
758 COMM_PREF_CODE VARCHAR2(30),
759 OLD_LAST_UPDATE_CHANNEL VARCHAR2(10),
760 LAST_UPDATE_CHANNEL VARCHAR2(10),
761 OLD_CUST_PREF_LANG_CODE VARCHAR2(4),
762 CUST_PREF_LANG_CODE VARCHAR2(4),
763 OLD_ERROR_CODE VARCHAR2(250),
764 ERROR_CODE VARCHAR2(250),
765 OLD_CATEGORY_SET_ID NUMBER,
766 CATEGORY_SET_ID NUMBER,
767 OLD_EXTERNAL_REFERENCE VARCHAR2(30),
768 EXTERNAL_REFERENCE VARCHAR2(30),
769 OLD_INCIDENT_OCCURRED_DATE DATE,
770 INCIDENT_OCCURRED_DATE DATE,
771 OLD_INCIDENT_RESOLVED_DATE DATE,
772 INCIDENT_RESOLVED_DATE DATE,
773 OLD_INC_RESPONDED_BY_DATE DATE,
774 INC_RESPONDED_BY_DATE DATE,
775 OLD_INCIDENT_LOCATION_ID NUMBER,
776 INCIDENT_LOCATION_ID NUMBER,
777 OLD_INCIDENT_ADDRESS VARCHAR2(960),
778 INCIDENT_ADDRESS VARCHAR2(960),
779 OLD_INCIDENT_CITY VARCHAR2(60),
780 INCIDENT_CITY VARCHAR2(60),
781 OLD_INCIDENT_STATE VARCHAR2(60),
782 INCIDENT_STATE VARCHAR2(60),
783 OLD_INCIDENT_COUNTRY VARCHAR2(60),
784 INCIDENT_COUNTRY VARCHAR2(60),
785 OLD_INCIDENT_PROVINCE VARCHAR2(60),
786 INCIDENT_PROVINCE VARCHAR2(60),
787 OLD_INCIDENT_POSTAL_CODE VARCHAR2(60),
788 INCIDENT_POSTAL_CODE VARCHAR2(60),
789 OLD_INCIDENT_COUNTY VARCHAR2(60),
790 INCIDENT_COUNTY VARCHAR2(240),
791 OLD_SR_CREATION_CHANNEL VARCHAR2(50),
792 SR_CREATION_CHANNEL VARCHAR2(50),
793 OLD_DEF_DEFECT_ID NUMBER,
794 DEF_DEFECT_ID NUMBER,
795 OLD_DEF_DEFECT_ID2 NUMBER,
796 DEF_DEFECT_ID2 NUMBER,
797 OLD_EXTERNAL_ATTRIBUTE_1 VARCHAR2(150),
798 EXTERNAL_ATTRIBUTE_1 VARCHAR2(150),
799 OLD_EXTERNAL_ATTRIBUTE_2 VARCHAR2(150),
800 EXTERNAL_ATTRIBUTE_2 VARCHAR2(150),
801 OLD_EXTERNAL_ATTRIBUTE_3 VARCHAR2(150),
802 EXTERNAL_ATTRIBUTE_3 VARCHAR2(150),
803 OLD_EXTERNAL_ATTRIBUTE_4 VARCHAR2(150),
804 EXTERNAL_ATTRIBUTE_4 VARCHAR2(150),
805 OLD_EXTERNAL_ATTRIBUTE_5 VARCHAR2(150),
806 EXTERNAL_ATTRIBUTE_5 VARCHAR2(150),
807 OLD_EXTERNAL_ATTRIBUTE_6 VARCHAR2(150),
808 EXTERNAL_ATTRIBUTE_6 VARCHAR2(150),
809 OLD_EXTERNAL_ATTRIBUTE_7 VARCHAR2(150),
810 EXTERNAL_ATTRIBUTE_7 VARCHAR2(150),
811 OLD_EXTERNAL_ATTRIBUTE_8 VARCHAR2(150),
812 EXTERNAL_ATTRIBUTE_8 VARCHAR2(150),
813 OLD_EXTERNAL_ATTRIBUTE_9 VARCHAR2(150),
814 EXTERNAL_ATTRIBUTE_9 VARCHAR2(150),
815 OLD_EXTERNAL_ATTRIBUTE_10 VARCHAR2(150),
816 EXTERNAL_ATTRIBUTE_10 VARCHAR2(150),
817 OLD_EXTERNAL_ATTRIBUTE_11 VARCHAR2(150),
818 EXTERNAL_ATTRIBUTE_11 VARCHAR2(150),
819 OLD_EXTERNAL_ATTRIBUTE_12 VARCHAR2(150),
820 EXTERNAL_ATTRIBUTE_12 VARCHAR2(150),
821 OLD_EXTERNAL_ATTRIBUTE_13 VARCHAR2(150),
822 EXTERNAL_ATTRIBUTE_13 VARCHAR2(150),
823 OLD_EXTERNAL_ATTRIBUTE_14 VARCHAR2(150),
824 EXTERNAL_ATTRIBUTE_14 VARCHAR2(150),
825 OLD_EXTERNAL_ATTRIBUTE_15 VARCHAR2(150),
826 EXTERNAL_ATTRIBUTE_15 VARCHAR2(150),
827 OLD_EXTERNAL_CONTEXT VARCHAR2(30),
828 EXTERNAL_CONTEXT VARCHAR2(30),
829 OLD_LAST_UPDATE_PROGRAM_CODE VARCHAR2(30),
830 LAST_UPDATE_PROGRAM_CODE VARCHAR2(30),
831 OLD_CREATION_PROGRAM_CODE VARCHAR2(30),
832 CREATION_PROGRAM_CODE VARCHAR2(30),
833 OLD_COVERAGE_TYPE VARCHAR2(30),
834 COVERAGE_TYPE VARCHAR2(30),
835 OLD_BILL_TO_ACCOUNT_ID NUMBER(15),
836 BILL_TO_ACCOUNT_ID NUMBER(15),
837 OLD_SHIP_TO_ACCOUNT_ID NUMBER(15),
838 SHIP_TO_ACCOUNT_ID NUMBER(15),
839 OLD_CUSTOMER_EMAIL_ID NUMBER(15),
840 CUSTOMER_EMAIL_ID NUMBER(15),
841 OLD_CUSTOMER_PHONE_ID NUMBER(15),
842 CUSTOMER_PHONE_ID NUMBER(15),
843 OLD_BILL_TO_PARTY_ID NUMBER,
844 BILL_TO_PARTY_ID NUMBER,
845 OLD_SHIP_TO_PARTY_ID NUMBER,
846 SHIP_TO_PARTY_ID NUMBER,
847 OLD_BILL_TO_SITE_ID NUMBER,
848 BILL_TO_SITE_ID NUMBER,
849 OLD_SHIP_TO_SITE_ID NUMBER,
850 SHIP_TO_SITE_ID NUMBER,
851 OLD_PROGRAM_LOGIN_ID NUMBER,
852 PROGRAM_LOGIN_ID NUMBER,
853 OLD_INCIDENT_POINT_OF_INTEREST VARCHAR2(240),
854 INCIDENT_POINT_OF_INTEREST VARCHAR2(240),
855 OLD_INCIDENT_CROSS_STREET VARCHAR2(240),
856 INCIDENT_CROSS_STREET VARCHAR2(240),
857 OLD_INCIDENT_DIRECTION_QUALIF VARCHAR2(30),
858 INCIDENT_DIRECTION_QUALIF VARCHAR2(30),
859 OLD_INCIDENT_DISTANCE_QUALIF VARCHAR2(240),
860 INCIDENT_DISTANCE_QUALIF VARCHAR2(240),
861 OLD_INCIDENT_DISTANCE_QUAL_UOM VARCHAR2(30),
862 INCIDENT_DISTANCE_QUAL_UOM VARCHAR2(240),
863 OLD_INCIDENT_ADDRESS2 VARCHAR2(240),
864 INCIDENT_ADDRESS2 VARCHAR2(240),
865 OLD_INCIDENT_ADDRESS3 VARCHAR2(240),
866 INCIDENT_ADDRESS3 VARCHAR2(240),
867 OLD_INCIDENT_ADDRESS4 VARCHAR2(240),
868 INCIDENT_ADDRESS4 VARCHAR2(240),
869 OLD_INCIDENT_ADDRESS_STYLE VARCHAR2(30),
870 INCIDENT_ADDRESS_STYLE VARCHAR2(30),
871 OLD_INCIDENT_ADDR_LNS_PHONETIC VARCHAR2(560),
872 INCIDENT_ADDR_LNS_PHONETIC VARCHAR2(560),
873 OLD_INCIDENT_PO_BOX_NUMBER VARCHAR2(50),
874 INCIDENT_PO_BOX_NUMBER VARCHAR2(50),
875 OLD_INCIDENT_HOUSE_NUMBER VARCHAR2(50),
876 INCIDENT_HOUSE_NUMBER VARCHAR2(50),
877 OLD_INCIDENT_STREET_SUFFIX VARCHAR2(50),
878 INCIDENT_STREET_SUFFIX VARCHAR2(50),
879 OLD_INCIDENT_STREET VARCHAR2(150),
880 INCIDENT_STREET VARCHAR2(150),
881 OLD_INCIDENT_STREET_NUMBER VARCHAR2(50),
882 INCIDENT_STREET_NUMBER VARCHAR2(50),
883 OLD_INCIDENT_FLOOR VARCHAR2(50),
884 INCIDENT_FLOOR VARCHAR2(50),
885 OLD_INCIDENT_SUITE VARCHAR2(50),
886 INCIDENT_SUITE VARCHAR2(50),
887 OLD_INCIDENT_POSTAL_PLUS4_CODE VARCHAR2(30),
888 INCIDENT_POSTAL_PLUS4_CODE VARCHAR2(30),
889 OLD_INCIDENT_POSITION VARCHAR2(50),
890 INCIDENT_POSITION VARCHAR2(50),
891 OLD_INCIDENT_LOC_DIRECTIONS VARCHAR2(640),
892 INCIDENT_LOC_DIRECTIONS VARCHAR2(640),
893 OLD_INCIDENT_LOC_DESCRIPTION VARCHAR2(2000),
894 INCIDENT_LOC_DESCRIPTION VARCHAR2(2000),
895 OLD_INSTALL_SITE_ID NUMBER,
896 INSTALL_SITE_ID NUMBER,
897 INCIDENT_LAST_MODIFIED_DATE DATE,
898 UPDATED_ENTITY_CODE VARCHAR2(30),
899 UPDATED_ENTITY_ID NUMBER(15),
900 ENTITY_ACTIVITY_CODE VARCHAR2(30),
901 OLD_TIER_VERSION VARCHAR2(250),
902 TIER_VERSION VARCHAR2(250),
903 -- Added new audit columns --anmukher --09/11/03
904 OLD_INC_OBJECT_VERSION_NUMBER NUMBER(9),
905 INC_OBJECT_VERSION_NUMBER NUMBER(9),
906 OLD_INC_REQUEST_ID NUMBER(15),
907 INC_REQUEST_ID NUMBER(15),
908 OLD_INC_PROGRAM_APPLICATION_ID NUMBER(15),
909 INC_PROGRAM_APPLICATION_ID NUMBER(15),
910 OLD_INC_PROGRAM_ID NUMBER(15),
911 INC_PROGRAM_ID NUMBER(15),
912 OLD_INC_PROGRAM_UPDATE_DATE DATE,
913 INC_PROGRAM_UPDATE_DATE DATE,
914 OLD_OWNING_DEPARTMENT_ID NUMBER,
915 OWNING_DEPARTMENT_ID NUMBER,
916 OLD_INCIDENT_LOCATION_TYPE VARCHAR2(30),
917 INCIDENT_LOCATION_TYPE VARCHAR2(30),
918 OLD_UNASSIGNED_INDICATOR VARCHAR2(1),
919 UNASSIGNED_INDICATOR VARCHAR2(1),
920 -- audit component R12 project
921 OLD_MAINT_ORGANIZATION_ID NUMBER(15),
922 MAINT_ORGANIZATION_ID NUMBER(15),
923 --siahmed 12.2.2 project auditing project attributes
924 old_project_id NUMBER(15) ,
925 project_id NUMBER(15) ,
926 old_project_task_id NUMBER(15) ,
927 project_task_id NUMBER(15) ,
928 old_expenditure_org_id NUMBER(15) ,
929 expenditure_org_id NUMBER(15) ,
930 --end of addition siahmed auditing attributes
931 --15995804 Audit price list header id and sla info
932 OLD_PRICE_LIST_HEADER_ID NUMBER(15),
933 PRICE_LIST_HEADER_ID NUMBER(15),
934 CHANGE_SLA_DATE_1_FLAG VARCHAR2(1),
935 OLD_SLA_DATE_1 DATE,
936 SLA_DATE_1 DATE,
937 CHANGE_SLA_DATE_2_FLAG VARCHAR2(1),
938 OLD_SLA_DATE_2 DATE,
939 SLA_DATE_2 DATE,
940 CHANGE_SLA_DATE_3_FLAG VARCHAR2(1),
941 OLD_SLA_DATE_3 DATE,
942 SLA_DATE_3 DATE,
943 CHANGE_SLA_DATE_4_FLAG VARCHAR2(1),
944 OLD_SLA_DATE_4 DATE,
945 SLA_DATE_4 DATE,
946 CHANGE_SLA_DATE_5_FLAG VARCHAR2(1),
947 OLD_SLA_DATE_5 DATE,
948 SLA_DATE_5 DATE,
949 CHANGE_SLA_DATE_6_FLAG VARCHAR2(1),
950 OLD_SLA_DATE_6 DATE,
951 SLA_DATE_6 DATE,
952 CHANGE_SLA_DURATION_1_FLAG VARCHAR2(1),
953 OLD_SLA_DURATION_1 NUMBER(15),
954 SLA_DURATION_1 NUMBER(15),
955 CHANGE_SLA_DURATION_2_FLAG VARCHAR2(1),
956 OLD_SLA_DURATION_2 NUMBER(15),
957 SLA_DURATION_2 NUMBER(15)
958 );
959
960 --
961 -- RMJ:
962 -- A table within a record type is not possible. That's why I defined
963 -- three context fields in the following record type.
964 --
965 TYPE notes_rec IS RECORD (
966 NOTE_ID NUMBER := FND_API.G_MISS_NUM,
967 NOTE VARCHAR2(2000) := FND_API.G_MISS_CHAR,
968 NOTE_DETAIL VARCHAR2(32767) := FND_API.G_MISS_CHAR,
969 NOTE_TYPE VARCHAR2(240) := FND_API.G_MISS_CHAR,
970 NOTE_STATUS VARCHAR2(240) := FND_API.G_MISS_CHAR,
971 ENTERED_BY NUMBER := FND_API.G_MISS_NUM,
972 ENTERED_DATE DATE := FND_API.G_MISS_DATE,
973 SOURCE_OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
974 SOURCE_OBJECT_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
975 NOTE_CONTEXT_ID_01 NUMBER := FND_API.G_MISS_NUM,
976 NOTE_CONTEXT_TYPE_01 VARCHAR2(30) := FND_API.G_MISS_CHAR,
977 NOTE_CONTEXT_TYPE_ID_01 NUMBER := FND_API.G_MISS_NUM,
978 NOTE_CONTEXT_ID_02 NUMBER := FND_API.G_MISS_NUM,
979 NOTE_CONTEXT_TYPE_02 VARCHAR2(30) := FND_API.G_MISS_CHAR,
980 NOTE_CONTEXT_TYPE_ID_02 NUMBER := FND_API.G_MISS_NUM,
981 NOTE_CONTEXT_ID_03 NUMBER := FND_API.G_MISS_NUM,
982 NOTE_CONTEXT_TYPE_03 VARCHAR2(30) := FND_API.G_MISS_CHAR,
983 NOTE_CONTEXT_TYPE_ID_03 NUMBER := FND_API.G_MISS_NUM,
984 ATTRIBUTE_1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
985 ATTRIBUTE_2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
986 ATTRIBUTE_3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
987 ATTRIBUTE_4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
988 ATTRIBUTE_5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
989 ATTRIBUTE_6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
990 ATTRIBUTE_7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
991 ATTRIBUTE_8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
992 ATTRIBUTE_9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
993 ATTRIBUTE_10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
994 ATTRIBUTE_11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
995 ATTRIBUTE_12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
996 ATTRIBUTE_13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
997 ATTRIBUTE_14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
998 ATTRIBUTE_15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
999 CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
1000 LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
1001 CREATION_DATE DATE := FND_API.G_MISS_DATE,
1002 CREATED_BY NUMBER := FND_API.G_MISS_NUM,
1003 LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
1004 LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
1005 );
1006 TYPE notes_table IS TABLE OF notes_rec INDEX BY BINARY_INTEGER;
1007
1008 -----------------------------------------------------------------------
1009 -- Start of comments
1010 -- Record Type : notes_rec
1011 -- Description : Holds the Notes attributes for the
1012 -- Creating records in JTF_NOTES_B
1013 -- Fields :
1014 -- NOTE OPTIONAL
1015 -- NOTE_DETAIL OPTIONAL
1016 -- NOTE_TYPE OPTIONAL
1017 -- VAlid values are SR_PROBLEM and SR_RESOLUTION
1018 -- NOTE_CONTEXT_TYPE_01 OPTIONAL - VAlid value is 'SR'
1019 -- NOTE_CONTEXT_TYPE_ID_01 OPTIONAL
1020 -- VAlid incident_id from cs_incidents_all_b
1021 -- NOTE_CONTEXT_TYPE_02 - VAlid value is 'SR'
1022 -- NOTE_CONTEXT_TYPE_ID_02 - VAlid incident_id from cs_incidents_all_b
1023 -- NOTE_CONTEXT_TYPE_03 - VAlid value is 'SR'
1024 -- NOTE_CONTEXT_TYPE_ID_03 - VAlid incident_id from cs_incidents_all_b
1025 --------------------------------------------------------------------------
1026
1027 --
1028 --This table will hold the contacts and contact information
1029 --for a Service Request customer
1030 --
1031 TYPE contacts_rec IS RECORD (
1032 SR_CONTACT_POINT_ID NUMBER := FND_API.G_MISS_NUM,
1033 PARTY_ID NUMBER := FND_API.G_MISS_NUM,
1034 CONTACT_POINT_ID NUMBER := FND_API.G_MISS_NUM,
1035 PRIMARY_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
1036 CONTACT_POINT_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
1037 CONTACT_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
1038 party_role_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
1039 start_date_active DATE := FND_API.G_MISS_DATE,
1040 end_date_active DATE := FND_API.G_MISS_DATE
1041 );
1042 TYPE contacts_table IS TABLE OF contacts_rec INDEX BY BINARY_INTEGER;
1043
1044 --
1045 -----------------------------------------------------------------------
1046 -- Start of comments
1047 -- Record Type : contacts_rec
1048 -- Description : Holds the Contacts attributes for the
1049 -- Creating records in CS_HZ_SR_CONTACT_POINTS
1050 -- Fields :
1051 -- sr_contact_point_id OPTIONAL
1052 -- can be specified only if you waNt to update an existing
1053 -- record(when called from Update_ServiceRequest API)
1054 -- party_id REQUIRED
1055 -- Valid party id from HZ_PARTIES
1056 -- contact_point_id OPTIONAL
1057 -- VAlid contact_point_id from HZ_CONTACT_POINTS
1058 -- contact_point_type OPTIONAL
1059 -- From AR_LOOKUPS where lookup_type = 'COMMUNICATION_TYPE'
1060 -- and 'PHONE_LINE_TYPE'
1061 -- primary_flag REQUIRED
1062 -- At least one record in the table should have this flag set to Y
1063 -- contact_type REQUIRED
1064 -- Valid values are 'PERSON" and 'EMPLOYEE'
1065
1066 -------------------------------------------------------- pkesani
1067 -- Start of comments
1068 -- Record Type : coverage_type_rec
1069 -- Description : To Get the coverage type.
1070 --------------------------------------------------------
1071 coverage_type_rec OKS_Entitlements_Pub.CovType_Rec_Type;
1072
1073 TYPE service_request_rec_type IS RECORD (
1074 request_date DATE,
1075 type_id NUMBER,
1076 status_id NUMBER,
1077 severity_id NUMBER,
1078 urgency_id NUMBER,
1079 closed_date DATE,
1080 owner_id NUMBER,
1081 owner_group_id NUMBER,
1082 publish_flag VARCHAR2(1),
1083 summary VARCHAR2(240),
1084 caller_type VARCHAR2(30),
1085 customer_id NUMBER,
1086 customer_number VARCHAR2(30),
1087 employee_id NUMBER,
1088 verify_cp_flag VARCHAR2(1),
1089 customer_product_id NUMBER,
1090 platform_id NUMBER,
1091 platform_version VARCHAR2(250),
1092 db_version VARCHAR2(250),
1093 platform_version_id NUMBER,
1094 cp_component_id NUMBER,
1095 cp_component_version_id NUMBER,
1096 cp_subcomponent_id NUMBER,
1097 cp_subcomponent_version_id NUMBER,
1098 language_id NUMBER,
1099 language VARCHAR2(4),
1100 inventory_item_id NUMBER,
1101 inventory_org_id NUMBER,
1102 current_serial_number VARCHAR2(30),
1103 original_order_number NUMBER,
1104 purchase_order_num VARCHAR2(50),
1105 problem_code VARCHAR2(50),
1106 exp_resolution_date DATE,
1107 install_site_use_id NUMBER,
1108 request_attribute_1 VARCHAR2(150),
1109 request_attribute_2 VARCHAR2(150),
1110 request_attribute_3 VARCHAR2(150),
1111 request_attribute_4 VARCHAR2(150),
1112 request_attribute_5 VARCHAR2(150),
1113 request_attribute_6 VARCHAR2(150),
1114 request_attribute_7 VARCHAR2(150),
1115 request_attribute_8 VARCHAR2(150),
1116 request_attribute_9 VARCHAR2(150),
1117 request_attribute_10 VARCHAR2(150),
1118 request_attribute_11 VARCHAR2(150),
1119 request_attribute_12 VARCHAR2(150),
1120 request_attribute_13 VARCHAR2(150),
1121 request_attribute_14 VARCHAR2(150),
1122 request_attribute_15 VARCHAR2(150),
1123 request_context VARCHAR2(30),
1124 external_attribute_1 VARCHAR2(150),
1125 external_attribute_2 VARCHAR2(150),
1126 external_attribute_3 VARCHAR2(150),
1127 external_attribute_4 VARCHAR2(150),
1128 external_attribute_5 VARCHAR2(150),
1129 external_attribute_6 VARCHAR2(150),
1130 external_attribute_7 VARCHAR2(150),
1131 external_attribute_8 VARCHAR2(150),
1132 external_attribute_9 VARCHAR2(150),
1133 external_attribute_10 VARCHAR2(150),
1134 external_attribute_11 VARCHAR2(150),
1135 external_attribute_12 VARCHAR2(150),
1136 external_attribute_13 VARCHAR2(150),
1137 external_attribute_14 VARCHAR2(150),
1138 external_attribute_15 VARCHAR2(150),
1139 external_context VARCHAR2(30),
1140 bill_to_site_use_id NUMBER,
1141 bill_to_contact_id NUMBER,
1142 ship_to_site_use_id NUMBER,
1143 ship_to_contact_id NUMBER,
1144 resolution_code VARCHAR2(50),
1145 act_resolution_date DATE,
1146 public_comment_flag VARCHAR2(1),
1147 parent_interaction_id NUMBER,
1148 contract_service_id NUMBER,
1149 -- 04/16/01
1150 contract_id NUMBER,
1151 project_number VARCHAR2(120),
1152 -- 04/16/01
1153 qa_collection_plan_id NUMBER,
1154 account_id NUMBER,
1155 resource_type VARCHAR2(30),
1156 resource_subtype_id NUMBER,
1157 cust_po_number VARCHAR2(50),
1158 cust_ticket_number VARCHAR2(50),
1159 sr_creation_channel VARCHAR2(50),
1160 obligation_date DATE,
1161 time_zone_id NUMBER,
1162 time_difference NUMBER,
1163 site_id NUMBER,
1164 customer_site_id NUMBER,
1165 territory_id NUMBER,
1166 initialize_flag VARCHAR2(1),
1167 cp_revision_id NUMBER,
1168 inv_item_revision VARCHAR2(240),
1169 inv_component_id NUMBER,
1170 inv_component_version VARCHAR2(90),
1171 inv_subcomponent_id NUMBER,
1172 inv_subcomponent_version VARCHAR2(90),
1173 -- jngeorge---11.5.6----07/12/01
1174 tier VARCHAR2(250),
1175 tier_version VARCHAR2(250),
1176 operating_system VARCHAR2(250),
1177 operating_system_version VARCHAR2(250),
1178 database VARCHAR2(250),
1179 cust_pref_lang_id NUMBER,
1180 category_id NUMBER,
1181 group_type VARCHAR2(30),
1182 group_territory_id NUMBER,
1183 inv_platform_org_id NUMBER,
1184 product_revision VARCHAR2(240),
1185 component_version VARCHAR2(3),
1186 subcomponent_version VARCHAR2(3),
1187 comm_pref_code VARCHAR2(30),
1188 -- Added for HA
1189 last_update_date DATE,
1190 last_updated_by NUMBER,
1191 creation_date DATE,
1192 created_by NUMBER,
1193 last_update_login NUMBER,
1194 owner_assigned_time DATE,
1195 owner_assigned_flag VARCHAR2(1),
1196 -- Added for UWQ
1197 -- Changed the width from 10 to 30 shijain 3rd dec 2002
1198 last_update_channel VARCHAR2(30),
1199 cust_pref_lang_code VARCHAR2(4),
1200 --- Added for Automatic Assignments
1201 load_balance VARCHAR2(1),
1202 assign_owner VARCHAR2(1),
1203 category_set_id NUMBER,
1204 external_reference VARCHAR2(30),
1205 system_id NUMBER,
1206 -- jngeorge-----07/12/01
1207 error_code VARCHAR2(250),
1208 incident_occurred_date DATE,
1209 incident_resolved_date DATE,
1210 inc_responded_by_date DATE,
1211 resolution_summary VARCHAR2(250),
1212 incident_location_id NUMBER,
1213 incident_address VARCHAR2(960),
1214 incident_city VARCHAR2(60),
1215 incident_state VARCHAR2(60),
1216 incident_country VARCHAR2(60),
1217 incident_province VARCHAR2(60),
1218 incident_postal_code VARCHAR2(60),
1219 incident_county VARCHAR2(60),
1220 -- Added by siahmed for 12.1.2 enhancement
1221 site_number VARCHAR2(30) DEFAULT NULL,
1222 site_name VARCHAR2(240) DEFAULT NULL,
1223 addressee VARCHAR2(150) DEFAULT NULL,
1224 -- Added for Enh# 2216664
1225 owner VARCHAR2(360),
1226 group_owner VARCHAR2(60),
1227 -- Added for Credit Card ER# 2255263 (UI ER#2208078)
1228 cc_number VARCHAR2(48),
1229 cc_expiration_date DATE,
1230 cc_type_code VARCHAR(30),
1231 cc_first_name VARCHAR(250),
1232 cc_last_name VARCHAR(250),
1233 cc_middle_name VARCHAR(250),
1234 cc_id NUMBER ,
1235 ---- Added for ER# 2320056
1236 coverage_type VARCHAR2(30),
1237 --- Added for ER# 2433831
1238 bill_to_account_id NUMBER ,
1239 ship_to_account_id NUMBER ,
1240 --- Added for ER# 2463321
1241 customer_phone_id NUMBER ,
1242 customer_email_id NUMBER ,
1243 --- Added these parameters for 11.5.9 source changes
1244 creation_program_code VARCHAR2(30),
1245 last_update_program_code VARCHAR2(30),
1246 -- Bill_to_party, ship_to_party
1247 bill_to_party_id NUMBER,
1248 ship_to_party_id NUMBER,
1249 -- Conc request related fields
1250 program_id NUMBER,
1251 program_application_id NUMBER,
1252 conc_request_id NUMBER,
1253 program_login_id NUMBER,
1254 -- Bill_to_site, ship_to_site
1255 bill_to_site_id NUMBER,
1256 ship_to_site_id NUMBER,
1257 -- Added address related columns by shijain 4th dec 2002
1258 incident_point_of_interest Varchar2(240) ,
1259 incident_cross_street Varchar2(240) ,
1260 incident_direction_qualifier Varchar2(30),
1261 incident_distance_qualifier Varchar2(240) ,
1262 incident_distance_qual_uom Varchar2(30),
1263 incident_address2 Varchar2(240) ,
1264 incident_address3 Varchar2(240),
1265 incident_address4 Varchar2(240) ,
1266 incident_address_style Varchar2(30),
1267 incident_addr_lines_phonetic Varchar2(560) ,
1268 incident_po_box_number Varchar2(50) ,
1269 incident_house_number Varchar2(50),
1270 incident_street_suffix Varchar2(50) ,
1271 incident_street Varchar2(150),
1272 incident_street_number Varchar2(50) ,
1273 incident_floor Varchar2(50) ,
1274 incident_suite Varchar2(50) ,
1275 incident_postal_plus4_code Varchar2(30) ,
1276 incident_position Varchar2(50) ,
1277 incident_location_directions Varchar2(640),
1278 incident_location_description Varchar2(2000) ,
1279 install_site_id Number ,
1280 status_flag Varchar2(3) ,
1281 primary_contact_id Number,
1282 ------anmukher---------------07/31/03
1283 -- Added for CMRO-EAM project of Release 11.5.10
1284 old_type_maintenance_flag VARCHAR2(3),
1285 new_type_maintenance_flag VARCHAR2(3),
1286 old_type_CMRO_flag VARCHAR2(3),
1287 new_type_CMRO_flag VARCHAR2(3),
1288 item_serial_number VARCHAR2(30),
1289 owning_dept_id NUMBER,
1290 -- Added for Misc ERs project of Release 11.5.10
1291 incident_location_type VARCHAR2(30) Default 'HZ_LOCATION',
1292 org_id NUMBER,
1293 maint_organization_id NUMBER,
1294 /* Credit Card 9358401 */
1295 instrument_payment_use_id NUMBER,
1296 --12.2+ project siahmed why do we have the same record type defined
1297 --in two different places
1298 --create for integration with oracle projects
1299 project_id NUMBER,
1300 project_task_id NUMBER,
1301 expenditure_org_id NUMBER,
1302 /*14004721 . Additional SLA dates */
1303 sla_date_1 DATE,
1304 sla_date_2 DATE,
1305 sla_date_3 DATE,
1306 sla_date_4 DATE,
1307 sla_date_5 DATE,
1308 sla_date_6 DATE,
1309 sla_duration_1 NUMBER,
1310 sla_duration_2 NUMBER,
1311 --15995804. Add price_list_header_id
1312 price_list_header_id NUMBER
1313 );
1314
1315
1316 ----------anmukher--------------07/31/03
1317 -- Added new record type for OUT parameters of Create API
1318 -- so that future overloading of the API can be avoided
1319 TYPE sr_create_out_rec_type IS RECORD
1320 (
1321 request_id NUMBER,
1322 request_number VARCHAR2(64),
1323 interaction_id NUMBER,
1324 workflow_process_id NUMBER,
1325 individual_owner NUMBER,
1326 group_owner NUMBER,
1327 individual_type VARCHAR2(30),
1328 auto_task_gen_status VARCHAR2(3),
1329 auto_task_gen_attempted BOOLEAN Default FALSE,
1330 field_service_task_created BOOLEAN,
1331 contract_service_id NUMBER,
1332 resolve_by_date DATE,
1333 respond_by_date DATE,
1334 resolved_on_date DATE,
1335 responded_on_date DATE,
1336 -- added by siahmed for 12.1.2 project
1337 incident_location_id NUMBER
1338 );
1339
1340 -- Added new record type for OUT parameters of Update API
1341 -- so that future overloading of the API can be avoided
1342 TYPE sr_update_out_rec_type IS RECORD
1343 ( interaction_id NUMBER,
1344 workflow_process_id NUMBER,
1345 individual_owner NUMBER,
1346 group_owner NUMBER,
1347 individual_type VARCHAR2(30),
1348 resolved_on_date DATE,
1349 responded_on_date DATE
1350 , status_id NUMBER
1351 , close_date DATE
1352 -- added by siahmed for 12.1.2 project
1353 , incident_location_id NUMBER
1354 );
1355
1356 --This Global service request record type is declared
1357 --for internal hooks.
1358 TYPE internal_user_hooks_rec IS RECORD (
1359 request_id NUMBER,
1360 request_number VARCHAR2(64),
1361 request_date DATE,
1362 type_id NUMBER,
1363 status_id NUMBER,
1364 severity_id NUMBER,
1365 urgency_id NUMBER,
1366 closed_date DATE,
1367 owner_id NUMBER,
1368 owner_group_id NUMBER,
1369 publish_flag VARCHAR2(1),
1370 summary VARCHAR2(240),
1371 caller_type VARCHAR2(30),
1372 customer_id NUMBER,
1373 customer_number VARCHAR2(30),
1374 employee_id NUMBER,
1375 verify_cp_flag VARCHAR2(1),
1376 customer_product_id NUMBER,
1377 platform_id NUMBER,
1378 platform_version VARCHAR2(250),
1379 db_version VARCHAR2(250),
1380 platform_version_id NUMBER,
1381 cp_component_id NUMBER,
1382 cp_component_version_id NUMBER,
1383 cp_subcomponent_id NUMBER,
1384 cp_subcomponent_version_id NUMBER,
1385 language_id NUMBER,
1386 language VARCHAR2(4),
1387 inventory_item_id NUMBER,
1388 inventory_org_id NUMBER,
1389 current_serial_number VARCHAR2(30),
1390 original_order_number NUMBER,
1391 purchase_order_num VARCHAR2(50),
1392 problem_code VARCHAR2(50),
1393 exp_resolution_date DATE,
1394 install_site_use_id NUMBER,
1395 request_attribute_1 VARCHAR2(150),
1396 request_attribute_2 VARCHAR2(150),
1397 request_attribute_3 VARCHAR2(150),
1398 request_attribute_4 VARCHAR2(150),
1399 request_attribute_5 VARCHAR2(150),
1400 request_attribute_6 VARCHAR2(150),
1401 request_attribute_7 VARCHAR2(150),
1402 request_attribute_8 VARCHAR2(150),
1403 request_attribute_9 VARCHAR2(150),
1404 request_attribute_10 VARCHAR2(150),
1405 request_attribute_11 VARCHAR2(150),
1406 request_attribute_12 VARCHAR2(150),
1407 request_attribute_13 VARCHAR2(150),
1408 request_attribute_14 VARCHAR2(150),
1409 request_attribute_15 VARCHAR2(150),
1410 request_context VARCHAR2(30),
1411 external_attribute_1 VARCHAR2(150),
1412 external_attribute_2 VARCHAR2(150),
1413 external_attribute_3 VARCHAR2(150),
1414 external_attribute_4 VARCHAR2(150),
1415 external_attribute_5 VARCHAR2(150),
1416 external_attribute_6 VARCHAR2(150),
1417 external_attribute_7 VARCHAR2(150),
1418 external_attribute_8 VARCHAR2(150),
1419 external_attribute_9 VARCHAR2(150),
1420 external_attribute_10 VARCHAR2(150),
1421 external_attribute_11 VARCHAR2(150),
1422 external_attribute_12 VARCHAR2(150),
1423 external_attribute_13 VARCHAR2(150),
1424 external_attribute_14 VARCHAR2(150),
1425 external_attribute_15 VARCHAR2(150),
1426 external_context VARCHAR2(30),
1427 bill_to_site_use_id NUMBER,
1428 bill_to_contact_id NUMBER,
1429 ship_to_site_use_id NUMBER,
1430 ship_to_contact_id NUMBER,
1431 resolution_code VARCHAR2(50),
1432 act_resolution_date DATE,
1433 public_comment_flag VARCHAR2(1),
1434 parent_interaction_id NUMBER,
1435 contract_service_id NUMBER,
1436 --04/16/01
1437 contract_id NUMBER,
1438 project_number VARCHAR2(120),
1439 --04/16/01
1440 qa_collection_plan_id NUMBER,
1441 account_id NUMBER,
1442 resource_type VARCHAR2(30),
1443 resource_subtype_id NUMBER,
1444 cust_po_number VARCHAR2(50),
1445 cust_ticket_number VARCHAR2(50),
1446 sr_creation_channel VARCHAR2(50),
1447 obligation_date DATE,
1448 time_zone_id NUMBER,
1449 time_difference NUMBER,
1450 site_id NUMBER,
1451 customer_site_id NUMBER,
1452 territory_id NUMBER,
1453 initialize_flag VARCHAR2(1),
1454 cp_revision_id NUMBER,
1455 inv_item_revision VARCHAR2(240),
1456 inv_component_id NUMBER,
1457 inv_component_version VARCHAR2(90),
1458 inv_subcomponent_id NUMBER,
1459 inv_subcomponent_version VARCHAR2(90),
1460 ------jngeorge---11.5.6----07/12/01
1461 tier VARCHAR2(250),
1462 tier_version VARCHAR2(250),
1463 operating_system VARCHAR2(250),
1464 operating_system_version VARCHAR2(250),
1465 database VARCHAR2(250),
1466 cust_pref_lang_id NUMBER,
1467 category_id NUMBER,
1468 group_type VARCHAR2(30),
1469 group_territory_id NUMBER,
1470 inv_platform_org_id NUMBER,
1471 product_revision VARCHAR2(240),
1472 component_version VARCHAR2(3),
1473 subcomponent_version VARCHAR2(3),
1474 comm_pref_code VARCHAR2(30),
1475 cust_pref_lang_code VARCHAR2(4),
1476 error_code VARCHAR2(250),
1477 incident_occurred_date DATE,
1478 incident_resolved_date DATE,
1479 inc_responded_by_date DATE,
1480 resolution_summary VARCHAR2(250),
1481 incident_location_id NUMBER,
1482 incident_address VARCHAR2(960),
1483 incident_city VARCHAR2(60),
1484 incident_state VARCHAR2(60),
1485 incident_country VARCHAR2(60),
1486 incident_province VARCHAR2(60),
1487 incident_postal_code VARCHAR2(60),
1488 incident_county VARCHAR2(60),
1489 -- Added for Enh# 2216664
1490 owner VARCHAR2(360),
1491 group_owner VARCHAR2(60),
1492 -- Added for ER# 2320056
1493 coverage_type VARCHAR2(30),
1494 -- Added for ER# 2433831
1495 bill_to_account_id NUMBER ,
1496 ship_to_account_id NUMBER ,
1497 -- Added for ER# 2463321
1498 customer_phone_id NUMBER ,
1499 customer_email_id NUMBER ,
1500 -- for cmro_eam
1501 status_flag VARCHAR2(3),
1502 old_type_cmro_flag VARCHAR2(3),
1503 new_type_cmro_flag VARCHAR2(3)
1504 );
1505
1506 --This declaration is for the internal user hooks
1507 user_hooks_rec CS_ServiceRequest_PVT.internal_user_hooks_rec ;
1508
1509 -- This cursor is defined so that we can define a subtype
1510 -- and use it pass the old_rec values to wrokitem and API validations
1511 -- calls.This was mainly done for the Misc ER:owner auto assg changes.
1512
1513 cursor l_ServiceRequest_csr(c_incident_id number) is
1514 select *
1515 from CS_INCIDENTS_ALL_VL
1516 where incident_id = c_incident_id;
1517 -- FOR UPDATE OF incident_id NOWAIT;
1518 -- This declaration is to store the old values of SR when SR is updated.
1519
1520 SUBTYPE SR_OLDVALUES_REC_TYPE IS L_SERVICEREQUEST_CSR%ROWTYPE;
1521
1522 PROCEDURE initialize_rec(
1523 p_sr_record IN OUT NOCOPY service_request_rec_type );
1524 --------------------------------------------------------------------------
1525 -- Start of comments
1526 -- API name : Create_ServiceRequest
1527 -- Type : Private
1528 -- Function : Creates a service request in the table CS_INCIDENTS.
1529 -- Pre-reqs : None.
1530 --
1531 -- Standard IN Parameters:
1532 -- p_api_version IN NUMBER Required
1533 -- p_init_msg_list IN VARCHAR2 Optional
1534 -- Default = FND_API.G_FALSE
1535 -- p_commit IN VARCHAR2 Optional
1536 -- Default = FND_API.G_FALSE
1537 -- p_validation_level IN NUMBER Optional
1538 -- Default = FND_API.G_VALID_LEVEL_FULL
1539 --
1540 -- Standard OUT Parameters:
1541 -- x_return_status OUT VARCHAR2(1)
1542 -- x_msg_count OUT NUMBER
1543 -- x_msg_data OUT VARCHAR2(2000)
1544 --
1545 -- Service Request IN Parameters:
1546 -- p_resp_appl_id IN NUMBER Optional
1547 -- p_resp_id IN NUMBER Optional
1548 -- p_user_id IN NUMBER Required
1549 -- Application user identifier
1550 -- Valid user from fnd_user
1551
1552 -- p_login_id IN NUMBER Optional
1553 -- Identifier of login session
1554 -- p_org_id IN NUMBER Optional
1555 -- Operating unit identifier
1556 -- p_request_id IN NUMBER Optional
1557 -- Service Request Identifier
1558 -- p_request_number IN VARCHAR2(64) Optional
1559 -- p_service_request_rec IN service_request_rec_type Required
1560 -- p_notes IN notes_table Optional
1561 --
1562 -- p_contacts IN contacts_table Required if CALLER TYPE IS
1563 -- ORGANIZATION OR PERSON
1564 -- Service Request OUT parameters:
1565 -- x_request_id OUT NUMBER
1566 -- System generated ID
1567 -- x_request_number OUT VARCHAR2(64)
1568 -- User-visible number of service request
1569 -- x_interaction_id OUT NUMBER
1570 -- Workflow OUT parameters:
1571 -- x_workflow_process_id OUT NUMBER
1572 --
1573 -- Calls IN parameters:
1574 -- p_comments IN VARCHAR2(2000) Optional
1575 -- p_public_comment_flag IN VARCHAR2(1) Optional
1576 --
1577 -- Calls OUT parameters:
1578 -- p_call_id OUT NUMBER
1579 --
1580 -- Interaction IN parameters:
1581 -- p_parent_interaction_id IN NUMBER Optional
1582 -- Corresponds to the column INTERACTION_ID in the table
1583 -- CS_INTERACTIONS, and identifies the parent interaction that
1584 -- resulted in this service request
1585 -- Version : Current version 1.1
1586 -- Added IN parameter p_parent_interaction_id.
1587 -- Previous version 1.0
1588 -- Initial version 1.0
1589 -- End of comments
1590
1591 --------------------------------------------------------------------------
1592 -- Start of comments
1593 -- Record Type : Service_Request_Rec_Type
1594 -- Description : Holds the Service Request attributes
1595 -- for the Create_ServiceRequest Procedure.
1596 -- Fields :
1597 --
1598 -- Service request type identifier
1599 -- request_date DATE Required
1600 -- Service request date
1601
1602 -- type_id NUMBER Required
1603 -- Service request type identifier
1604 -- VAlid incident_type_id from cs_incident_types
1605
1606 -- status_id NUMBER Required
1607 -- Service request status identifier
1608 -- Valid incident_status_id from cs_incident_statuses
1609
1610
1611 -- severity_id NUMBER Required
1612 -- Service request severity identifier
1613 -- Valid incident_severity_id from cs_incident_severities
1614
1615
1616 -- urgency_id NUMBER Optional
1617 -- Service request urgency identifier
1618 -- Valid incident_urgency_id from cs_incident_urgencies
1619
1620
1621 -- closed_date DATE Optional
1622 -- Service request closed date
1623 -- Ignored if the status is not a "closed" status
1624
1625 -- owner_id NUMBER Required
1626 -- Service request owner identifier
1627 -- Valid resource_id from cs_sr_owners_v
1628
1629 -- owner_group_id NUMBER Optional
1630 -- Service request owner group identifier
1631 --
1632 -- resource_type VARCHAR2(30) Optional
1633 -- VAlid resource_type from cs_sr_owners_v
1634
1635 -- resource_subtype_id NUMBER Optional
1636
1637 -- publish_flag VARCHAR2(1) Optional
1638
1639 -- summary VARCHAR2(240) Required
1640 -- Service request summary
1641
1642 ---------------------------------------------------------------------------
1643 -- These fields are no longer there in the service_request_rec_type
1644
1645 -- verify_request_flag VARCHAR2(1) Required
1646 -- Corresponds to the column RECORD_IS_VALID_FLAG in the table
1647 -- CS_INCIDENTS. Allows API callers to request that the API does
1648 -- the validation of the optional fields (customer_id,
1649 -- contact_id, bill_to_site_use_id, bill_to_contact_id,
1650 -- ship_to_site_use_id, ship_to_contact_id).
1651
1652 -- filed_by_emp_flag VARCHAR2(1) Required
1653 --------------------------------------------------------------------------
1654
1655 -- caller_type VARCHAR2(30) Required
1656 -- Caller Type
1657 -- VAlid values are : ORGANIZATION, PERSON and CALLER_EMP
1658
1659
1660 -- customer_id NUMBER Optional
1661 -- Service request customer identifier
1662
1663
1664 -- customer_number VARCHAR2(30) Optional
1665 -- Service request customer number
1666
1667
1668 ------------------------------------------------------------------------
1669
1670 -- These fields are no longer there in the service_request_rec_type
1671
1672 -- customer_prefix VARCHAR2(50) Optional
1673 -- Service request customer prefix
1674
1675 -- customer_firstname VARCHAR2(150) Optional
1676 -- Service request customer first name
1677
1678 -- customer_lastname VARCHAR2(150) Optional
1679 -- Service request customer last name
1680
1681
1682 -- customer_company_name VARCHAR2(255) Optional
1683 -- Service request customer company name
1684 -------------------------------------------------------------------------------
1685
1686
1687
1688
1689 -- employee_id NUMBER Optional
1690
1691 ------------------------------------------------------------------------------
1692 ---These fileds are no longer there in the record type
1693
1694 -- contact01_id NUMBER Optional
1695 -- Service request customer contact identifier
1696
1697 -- contact01_prefix VARCHAR2(50) Optional
1698 -- Service request customer contact prefix
1699
1700 -- contact01_firstname VARCHAR2(150) Optional
1701 -- Service request customer contact firstname
1702
1703
1704
1705 -- contact01_lastname VARCHAR2(150) Optional
1706 -- Service request customer contact lastname
1707
1708 -- contact01_area_code VARCHAR2(10) Optional
1709 -- contact01_telephone VARCHAR2(40) Optional
1710 -- contact01_extension VARCHAR2(20) Optional
1711 -- contact01_fax_area_code VARCHAR2(10) Optional
1712 -- contact01_fax_number VARCHAR2(40) Optional
1713 -- contact01_email_address VARCHAR2(2000) Optional
1714
1715 ------------------------------------------------------------------------
1716 -- This field is no longer present in the record type
1717 -- contact_time_diff NUMBER Optional
1718 -------------------------------------------------------------------------
1719 ---These fileds are no longer there in the record type
1720
1721 -- contact02_id NUMBER Optional
1722 -- Service request customer represented by identifier
1723
1724
1725 -- contact02_prefix VARCHAR2(50) Optional
1726 -- Service request customer represented by prefix
1727
1728
1729 -- contact02_firstname VARCHAR2(150) Optional
1730 -- Service request customer represented by firstname
1731
1732 -- contact02_lastname VARCHAR2(150) Optional
1733 -- Service request customer represented by lastname
1734
1735 -- contact02_area_code VARCHAR2(10) Optional
1736 -- contact02_telephone VARCHAR2(40) Optional
1737 -- contact02_extension VARCHAR2(20) Optional
1738 -- contact02_fax_area_code VARCHAR2(10) Optional
1739 -- contact02_fax_number VARCHAR2(40) Optional
1740 -- contact02_email_address VARCHAR2(2000) Optional
1741 --------------------------------------------------------------------------------------------------
1742
1743 -- verify_cp_flag VARCHAR2(1) Required
1744 -- The verify_cp_flag parameter allows API callers to request
1745 -- that the API does the validation of the optional customer
1746 -- product ID.
1747
1748 -- customer_product_id NUMBER Optional
1749 -- Unique identifier for a customer product in the Installed Base.
1750 -- Required if the verify_cp_flag parameter is 'Y'.
1751 -- Ignored if the verify_cp_flag parameter is 'N'.
1752
1753 -----------------------------------------------------------
1754 -- No longer there in rec type
1755 -- lot_num VARCHAR2(30) Optional
1756 ------------------------------------------------------------
1757
1758
1759 -- Supporting platform_id again because of enh 1711552
1760 -- platform_id NUMBER Optional
1761 -- *********THE functionality for the below 2 fileds is no longer supported.
1762 -- platform_version_id NUMBER Optional
1763
1764 -- language_id NUMBER Optional
1765 -- This is the Product's language id
1766
1767 -- cp_component_id NUMBER Optional
1768 -- cp_component_version_id NUMBER Optional
1769 -- cp_subcomponent_id NUMBER Optional
1770 -- cp_subcomponent_version_id NUMBER Optional
1771
1772 -- language VARCHAR2(4) Optional
1773 -- This is used for TL tables
1774
1775 -- inventory_item_id NUMBER Optional
1776 -- Corresponds to the column INVENTORY_ITEM_ID in the table
1777 -- MTL_SYSTEM_ITEMS, and identifies the service request product.
1778 -- Ignored if the verify_cp_flag parameter is 'Y'.
1779
1780
1781 -- inventory_org_id NUMBER Optional
1782 -- Item organization ID. Part of the unique key that uniquely
1783 -- identifies an inventory item.
1784 -- Required if inventory_item_id is used.
1785
1786 -- current_serial_number VARCHAR2(30) OPTIONAL
1787 -- Serial number for serialized items.
1788 -- Ignored if the verify_cp_flag parameter is 'Y'.
1789
1790 -- original_order_number NUMBER OPTIONAL
1791 -- Sales Order information.
1792 -- Ignored if the verify_cp_flag parameter is 'Y'.
1793
1794 -- purchase_order_number VARCHAR2(50) OPTIONAL
1795 -- Sales Order information.
1796 -- Ignored if the verify_cp_flag parameter is 'Y'.
1797
1798 -----------------------------------------------------------------------
1799 -- This field is no longer present in the record type
1800 -- problem_description VARCHAR2(2000) OPTIONAL
1801 -- Service request problem description
1802 -----------------------------------------------------------------------
1803
1804 -- problem_code VARCHAR2(30) OPTIONAL
1805 -- Service request problem code
1806
1807 -- exp_resolution_date DATE OPTIONAL
1808 -- Service request expected resolution date
1809
1810 -----------------------------------------------------------------------
1811 -- This field is no longer present in the record type
1812 -- make_public_problem VARCHAR2(1) Optional
1813 -----------------------------------------------------------------------
1814
1815 -- install_site_use_id NUMBER Optional
1816
1817
1818
1819 ------------------------------------------------------------------------
1820
1821 -- These fields are no longer there in the service_request_rec_type
1822
1823 -- install_location VARCHAR2(40) Optional
1824 -- install_customer VARCHAR2(50) Optional
1825 -- install_country VARCHAR2(60) Optional
1826 -- install_address_1 VARCHAR2(240) Optional
1827 -- install_address_2 VARCHAR2(240) Optional
1828 -- install_address_3 VARCHAR2(240) Optional
1829
1830
1831
1832 -----------------------------------------------------------------------
1833 -- These fields are no longer present in the record type
1834
1835 -- rma_flag VARCHAR2(1) Required
1836 -- Corresponds to the column RMA_FLAG in the table CS_INCIDENTS.
1837 -- Allows API callers to request that the API does the validation
1838 -- of the optional RMA header ID. It can only be set when the
1839 -- verify_request_flag parameter is set to 'Y'.
1840 -- rma_header_id NUMBER Optional
1841 -- Sales order header identifier of the RMA.
1842 -- Ignored if the rma_flag parameter is 'N'.
1843 -- web_entry_flag VARCHAR2(1) Required
1844 -- Indicates whether the service request is entered via the web.
1845 -------------------------------------------------------------------------------
1846
1847
1848 -- request_segment1 VARCHAR2(150) Optional
1849 -- request_segment2 VARCHAR2(150) Optional
1850 -- request_segment3 VARCHAR2(150) Optional
1851 -- request_segment4 VARCHAR2(150) Optional
1852 -- request_segment5 VARCHAR2(150) Optional
1853 -- request_segment6 VARCHAR2(150) Optional
1854 -- request_segment7 VARCHAR2(150) Optional
1855 -- request_segment8 VARCHAR2(150) Optional
1856 -- request_segment9 VARCHAR2(150) Optional
1857 -- request_segment10 VARCHAR2(150) Optional
1858 -- request_segment11 VARCHAR2(150) Optional
1859 -- request_segment12 VARCHAR2(150) Optional
1860 -- request_segment13 VARCHAR2(150) Optional
1861 -- request_segment14 VARCHAR2(150) Optional
1862 -- request_segment15 VARCHAR2(150) Optional
1863 -- request_context VARCHAR2(30) Optional
1864
1865
1866 -- bill_to_site_use_id NUMBER Optional
1867 -- Bill To site use identifier
1868
1869 -- bill_to_contact_id NUMBER Optional
1870 -- Bill To contact identifier
1871
1872
1873
1874 ------------------------------------------------------------------------
1875
1876 -- These fields are no longer there in the service_request_rec_type
1877
1878 -- bill_to_location VARCHAR2(40) Optional
1879
1880 -- bill_to_customer VARCHAR2(50) Optional
1881
1882 -- bill_country VARCHAR2(60) Optional
1883
1884 -- bill_to_address_1 VARCHAR2(240) Optional
1885
1886 -- bill_to_address_2 VARCHAR2(240) Optional
1887
1888 -- bill_to_address_3 VARCHAR2(240) Optional
1889
1890 -- bill_to_contact VARCHAR2(100) Optional
1891 -----------------------------------------------------------------------------------------
1892
1893
1894 -- ship_to_site_use_id NUMBER Optional
1895 -- Ship To site use identifier
1896
1897 -- ship_to_contact_id NUMBER Optional
1898 -- Ship To contact identifier
1899 ------------------------------------------------------------------------
1900
1901 -- These fields are no longer there in the service_request_rec_type
1902
1903 -- ship_to_location VARCHAR2(40) Optional
1904
1905 -- ship_to_customer VARCHAR2(50) Optional
1906
1907 -- ship_country VARCHAR2(60) Optional
1908
1909 -- ship_to_address_1 VARCHAR2(240) Optional
1910
1911 -- ship_to_address_2 VARCHAR2(240) Optional
1912
1913 -- ship_to_address_3 VARCHAR2(240) Optional
1914
1915 -- ship_to_contact VARCHAR2(100) Optional
1916 -----------------------------------------------------------------------------
1917
1918 ------------------------------------------------------------------------
1919 -- This field is no longer there in the record type
1920 -- problem_resolution VARCHAR2(2000) OPTIONAL
1921 -- Service request problem resolution
1922 ---------------------------------------------------------------------
1923
1924 -- resolution_code VARCHAR2(30) OPTIONAL
1925 -- Service request resolution code
1926
1927 -- act_resolution_date DATE OPTIONAL
1928 -- Service request actual resolution date
1929
1930 ------------------------------------------------------------------------
1931 -- This field is no longer there in the record type
1932 -- make_public_resolution VARCHAR2(1) Optional
1933 -----------------------------------------------------------------------
1934
1935 -- public_comment_flag VARCHAR2(1) OPTIONAL
1936 -- parent_interaction_id NUMBER OPTIONAL
1937 -- contract_service_id NUMBER OPTIONAL
1938 -- qa_collection_plan_id NUMBER OPTIONAL
1939 -- account_id NUMBER OPTIONAL
1940 -- cust_po_number VARCHAR2(50) OPTIONAL
1941 -- cust_ticket_number VARCHAR2(50) OPTIONAL
1942 -- sr_creation_channel VARCHAR2(50) OPTIONAL
1943 -- obligation_date DATE OPTIONAL
1944 -- time_zone_id NUMBER OPTIONAL
1945 -- time_difference NUMBER OPTIONAL
1946 -- site_id NUMBER OPTIONAL
1947 -- customer_site_id NUMBER OPTIONAL
1948 -- territory_id NUMBER OPTIONAL
1949 -- initialize_flag VARCHAR2(1) OPTIONAL
1950
1951 -- cp_revision_id NUMBER OPTIONAL
1952 -- inv_item_revision VARCHAR2(3) OPTIONAL
1953 -- inv_component_id NUMBER OPTIONAL
1954 -- inv_component_version VARCHAR2(3) OPTIONAL
1955 -- inv_subcomponent_id NUMBER OPTIONAL
1956 -- inv_subcomponent_version VARCHAR2(3) OPTIONAL
1957
1958 -- coverage_type VARCHAR2(30) Optional
1959 -- Service Request Coverage Type
1960 -- bill_to_account_id NUMBER Optional
1961 -- Service Request Bill To Account Identifier
1962 -- ship_to_account_id NUMBER Optional
1963 -- Service Request Ship To Account Identifier
1964 -- customer_phone_id NUMBER Optional
1965 -- SR Customer's non-primary phone Id
1966 -- customer_email_id NUMBER Optional
1967 -- SR Customer's non-primary Email Id
1968
1969 -- End of service_request_rec_type comments
1970 --------------------------------------------------------------
1971
1972 PROCEDURE Create_ServiceRequest(
1973 p_api_version IN NUMBER,
1974 p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
1975 p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
1976 p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
1977 x_return_status OUT NOCOPY VARCHAR2,
1978 x_msg_count OUT NOCOPY NUMBER,
1979 x_msg_data OUT NOCOPY VARCHAR2,
1980 p_resp_appl_id IN NUMBER DEFAULT NULL,
1981 p_resp_id IN NUMBER DEFAULT NULL,
1982 p_user_id IN NUMBER,
1983 p_login_id IN NUMBER DEFAULT NULL,
1984 p_org_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1985 p_request_id IN NUMBER DEFAULT NULL,
1986 p_request_number IN VARCHAR2 DEFAULT NULL,
1987 p_invocation_mode IN VARCHAR2 := 'NORMAL' ,
1988 p_service_request_rec IN service_request_rec_type,
1989 p_notes IN notes_table,
1990 p_contacts IN contacts_table,
1991 -- Added for Assignment Manager 11.5.9 change
1992 p_auto_assign IN VARCHAR2 Default 'N',
1993 --------------anmukher----------------------07/31/03
1994 -- Added for 11.5.10 projects (AutoTask, Miscellaneous ERs)
1995 p_auto_generate_tasks IN VARCHAR2 Default 'N',
1996 p_default_contract_sla_ind IN VARCHAR2 Default 'N',
1997 p_default_coverage_template_id IN NUMBER Default NULL,
1998 x_sr_create_out_rec OUT NOCOPY sr_create_out_rec_type
1999 ---------------anmukher----------------------07/31/03
2000 -- The following OUT parameters have been added to the record type sr_create_out_rec_type
2001 -- and have therefore been commented out. This will allow avoidance of future overloading
2002 -- if a new OUT parameter were to be needed, since it can be added to the same record type.
2003 -- x_request_id OUT NOCOPY NUMBER,
2004 -- x_request_number OUT NOCOPY VARCHAR2,
2005 -- x_interaction_id OUT NOCOPY NUMBER,
2006 -- x_workflow_process_id OUT NOCOPY NUMBER,
2007 -- x_individual_owner OUT NOCOPY NUMBER,
2008 -- x_group_owner OUT NOCOPY NUMBER,
2009 -- x_individual_type OUT NOCOPY VARCHAR2
2010 );
2011
2012 ----------------anmukher--------------07/31/03
2013 -- Overloaded procedure added for backward compatibility in 11.5.10
2014 -- since several new OUT parameters have been added to the 11.5.9 signature
2015 -- in the form of a new record type, sr_create_out_rec_type
2016 PROCEDURE Create_ServiceRequest(
2017 p_api_version IN NUMBER,
2018 p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
2019 p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
2020 p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
2021 x_return_status OUT NOCOPY VARCHAR2,
2022 x_msg_count OUT NOCOPY NUMBER,
2023 x_msg_data OUT NOCOPY VARCHAR2,
2024 p_resp_appl_id IN NUMBER DEFAULT NULL,
2025 p_resp_id IN NUMBER DEFAULT NULL,
2026 p_user_id IN NUMBER,
2027 p_login_id IN NUMBER DEFAULT NULL,
2028 p_org_id IN NUMBER DEFAULT NULL,
2029 p_request_id IN NUMBER DEFAULT NULL,
2030 p_request_number IN VARCHAR2 DEFAULT NULL,
2031 p_invocation_mode IN VARCHAR2 := 'NORMAL' ,
2032 p_service_request_rec IN service_request_rec_type,
2033 p_notes IN notes_table,
2034 p_contacts IN contacts_table,
2035 -- Added for Assignment Manager 11.5.9 change
2036 p_auto_assign IN VARCHAR2 Default 'N',
2037 p_default_contract_sla_ind IN VARCHAR2 Default 'N',
2038 x_request_id OUT NOCOPY NUMBER,
2039 x_request_number OUT NOCOPY VARCHAR2,
2040 x_interaction_id OUT NOCOPY NUMBER,
2041 x_workflow_process_id OUT NOCOPY NUMBER,
2042 x_individual_owner OUT NOCOPY NUMBER,
2043 x_group_owner OUT NOCOPY NUMBER,
2044 x_individual_type OUT NOCOPY VARCHAR2
2045 );
2046
2047 /* This is a overloaded procedure for create service request which is mainly
2048 created for making the changes for 1159 backward compatiable. This does not
2049 contain the following parameters:-
2050 x_individual_owner, x_group_owner, x_individual_type and p_auto_assign.
2051 and will call the above procedure with all these parameters and version
2052 as 3.0*/
2053
2054 PROCEDURE Create_ServiceRequest(
2055 p_api_version IN NUMBER,
2056 p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
2057 p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
2058 p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
2059 x_return_status OUT NOCOPY VARCHAR2,
2060 x_msg_count OUT NOCOPY NUMBER,
2061 x_msg_data OUT NOCOPY VARCHAR2,
2062 p_resp_appl_id IN NUMBER DEFAULT NULL,
2063 p_resp_id IN NUMBER DEFAULT NULL,
2064 p_user_id IN NUMBER,
2065 p_login_id IN NUMBER DEFAULT NULL,
2066 p_org_id IN NUMBER DEFAULT NULL,
2067 p_request_id IN NUMBER DEFAULT NULL,
2068 p_request_number IN VARCHAR2 DEFAULT NULL,
2069 p_invocation_mode IN VARCHAR2 := 'NORMAL' ,
2070 p_service_request_rec IN service_request_rec_type,
2071 p_notes IN notes_table,
2072 p_contacts IN contacts_table,
2073 p_default_contract_sla_ind IN VARCHAR2 Default 'N',
2074 x_request_id OUT NOCOPY NUMBER,
2075 x_request_number OUT NOCOPY VARCHAR2,
2076 x_interaction_id OUT NOCOPY NUMBER,
2077 x_workflow_process_id OUT NOCOPY NUMBER
2078 );
2079
2080
2081
2082
2083
2084 --------------------------------------------------------------------------
2085 -- Start of comments
2086 -- API name : Update_ServiceRequest
2087 -- Type : Private
2088 -- Function : Updates a service request in the table CS_INCIDENTS.
2089 -- Pre-reqs : None.
2090 -- Parameters :
2091 -- IN :
2092 -- p_api_version IN NUMBER Required
2093 -- p_init_msg_list IN VARCHAR2 Optional
2094 -- Default = FND_API.G_FALSE
2095 -- p_commit IN VARCHAR2 Optional
2096 -- Default = FND_API.G_FALSE
2097 -- p_validation_level IN NUMBER Optional
2098 -- Default = FND_API.G_VALID_LEVEL_FULL
2099 -- p_request_id IN NUMBER Required
2100 -- p_object_version_number IN NUMBER Required for Web-Apps
2101 -----------------------------------------------------------------
2102 -- No longer there in the API
2103 -- p_org_id IN NUMBER Optional
2104 -- For validating the service request id
2105 -- Default = NULL
2106 ----------------------------------------------------------------------------
2107 -- p_resp_appl_id IN NUMBER Optional
2108 -- p_resp_id IN NUMBER Optional
2109 -- p_last_updated_by IN NUMBER Required
2110 -- VAlid user from fnd_user
2111
2112 -- p_last_update_login IN NUMBER Optional
2113 -- Default = NULL
2114 -- p_last_update_date IN DATE Required
2115
2116 -- p_service_request_rec IN service_request_rec_type Required
2117
2118 -- p_update_desc_flex IN VARCHAR2(1) Optional
2119 -- Indicates whether the descriptive flexfields are being updated
2120 -- Default = FND_API.G_FALSE
2121
2122 -- p_notes IN notes_table Optional
2123
2124 -- p_contacts IN contacts_table Optional
2125 --
2126 ------------------------------------------------------
2127 -- p_audit_comments IN VARCHAR2
2128 -- To be used for the audit record
2129 -- Default = NULL
2130
2131 -- p_called_by_workflow IN VARCHAR2(1)
2132 -- Indicates whether this API is being called by the active
2133 -- workflow process for the service request
2134 -- Default = FND_API.G_FALSE
2135
2136 -- p_workflow_process_id IN NUMBER
2137 -- The workflow process id of the workflow process that is
2138 -- calling this API
2139 -- Default = NULL
2140
2141 -- OUT :
2142 -- x_workflow_process_id OUT NUMBER
2143 -- x_interaction_id OUT NUMBER
2144 --
2145 -- x_return_status OUT VARCHAR2(1) Required
2146 -- x_msg_count OUT NUMBER Required
2147 -- x_msg_data OUT VARCHAR2(2000) Required
2148 -- x_call_id OUT NUMBER Required
2149 --
2150 -- Version : Current version 1.1
2151 -- Added IN parameter p_parent_interaction_id.
2152 -- Previous version 1.0
2153 -- Initial Version 1.0
2154 --
2155 -- Notes:
2156 --
2157 -- End of comments
2158 --------------------------------------------------------------------------
2159 --
2160 --
2161 -- Start of comments
2162 -- Record Type : Service_Request_Rec_Type
2163 -- Description : Holds the Service Request attributes
2164 -- for the Update_ServiceRequest Procedure.
2165 -- Fields :
2166 -- request_date DATE
2167 --
2168 -- type_id NUMBER Optional
2169 -- Cannot be NULL
2170 -- status_id NUMBER Optional
2171 -- Cannot be NULL
2172 -- severity_id NUMBER Optional
2173 -- Cannot be NULL
2174 -- urgency_id NUMBER Optional
2175 -- closed_date DATE Optional
2176 -- owner_id NUMBER Optional
2177 -- Cannot be NULL
2178 -- owner_group_id NUMBER Optional
2179 -- publish_flag VARCHAR2 Optional
2180 -- summary VARCHAR2 Optional
2181 -- Cannot be NULL
2182 ----------------------------------------------------------------------
2183 -- This field is no longer there in the record type
2184 -- verify_request_flag VARCHAR2 Optional
2185 -- Must be either 'Y' or 'N'
2186 ----------------------------------------------------------------------
2187 -- customer_id NUMBER Optional
2188 -- customer_number VARCHAR2 Optional
2189 ------------------------------------------------------------------------
2190 -- These fields are no longer there in the service_request_rec_type
2191 -- customer_prefix VARCHAR2 Optional
2192 -- customer_firstname VARCHAR2 Optional
2193 -- customer_lastname VARCHAR2 Optional
2194 -- customer_company_name VARCHAR2 Optional
2195 -----------------------------------------------------------------------------------
2196 -- employee_id NUMBER
2197 ---------------------------------------------------------------------------
2198 --- These fields are no longer there in rec type
2199 -- contact01_id NUMBER Optional
2200 -- contact01_prefix VARCHAR2 Optional
2201 -- contact01_firstname VARCHAR2 Optional
2202 -- contact01_lastname VARCHAR2 Optional
2203 -- contact01_area_code VARCHAR2 Optional
2204 -- contact01_telephone VARCHAR2 Optional
2205 -- contact01_extension VARCHAR2 Optional
2206 -- contact01_fax_area_code VARCHAR2 Optional
2207 -- contact01_fax_number VARCHAR2 Optional
2208 -- contact01_email_address VARCHAR2 Optional
2209 ------------------------------------------------------------------------
2210 -- This field is no longer in the service request record type
2211 -- contact_time_diff NUMBER Optional
2212 --------------------------------------------------------------------------
2213 --- These fields are no longer there in rec type
2214 -- contact02_id NUMBER Optional
2215 -- Service request customer represented by identifier
2216 -- contact02_prefix VARCHAR2(50) Optional
2217 -- Service request customer represented by prefix
2218 -- contact02_firstname VARCHAR2(150) Optional
2219 -- Service request customer represented by firstname
2220 -- contact02_lastname VARCHAR2(150) Optional
2221 -- Service request customer represented by lastname
2222 -- contact02_area_code VARCHAR2(10) Optional
2223 -- contact02_telephone VARCHAR2(40) Optional
2224 -- contact02_extension VARCHAR2(20) Optional
2225 -- contact02_fax_area_code VARCHAR2(10) Optional
2226 -- contact02_fax_number VARCHAR2(40) Optional
2227 -- contact02_email_address VARCHAR2(2000) Optional
2228 ---------------------------------------------------------------------------
2229 -- verify_cp_flag VARCHAR2 Optional
2230 -- Must be either 'Y' or 'N'.
2231 -- customer_product_id NUMBER Optional
2232 -- For Installed Base mode only
2233 -------------------------------------------------------------------
2234 -- no longer there
2235 -- lot_num VARCHAR2(30) Optional
2236 ----------------------------------------------------------------------
2237
2238 -- Supporting platform_id again because of enh 1711552
2239 -- platform_id NUMBER Optional
2240 -- ********THE functionality for the below 2 fileds is no longer supported.
2241 -- platform_version_id NUMBER Optional
2242 -- language_id NUMBER Optional
2243 -- This is the Product's language id
2244 -- cp_component_id NUMBER Optional
2245 -- cp_component_version_id NUMBER Optional
2246 -- cp_subcomponent_id NUMBER Optional
2247 -- cp_subcomponent_version_id NUMBER Optional
2248 -- language VARCHAR2(4) Optional
2249 -- This is used for TL tables
2250 -- If not passed to the api, the userenv('LANG') is used.
2251 -- inventory_item_id NUMBER Optional
2252 -- inventory_org_id NUMBER Optional
2253 -- current_serial_number VARCHAR2 Optional
2254 -- Used only if verify_cp_flag is 'N'
2255 -- original_order_number NUMBER Optional
2256 -- Used only if verify_cp_flag is 'N'
2257 -- purchase_order_num VARCHAR2 Optional
2258 -- Used only if verify_cp_flag is 'N'
2259 --------------------------------------------------------------------------
2260 -- This field is not there in the record type
2261 -- problem_description VARCHAR2 Optional
2262 ------------------------------------------------------------------------
2263 -- problem_code VARCHAR2 Optional
2264 -- exp_resolution_date DATE Optional
2265 -----------------------------------------------------------------------------
2266 -- This field is not there in the record type
2267 -- make_public_problem VARCHAR2 Optional
2268 ---------------------------------------------------------------------------------
2269 -- install_site_use_id NUMBER Optional
2270 ------------------------------------------------------------------------
2271 -- These fields are no longer there in the service_request_rec_type
2272 -- install_location VARCHAR2 Optional
2273 -- install_customer VARCHAR2 Optional
2274 -- install_country VARCHAR2 Optional
2275 -- install_address_1 VARCHAR2 Optional
2276 -- install_address_2 VARCHAR2 Optional
2277 -- install_address_3 VARCHAR2 Optional
2278 -----------------------------------------------------------------------
2279 -- These fields are no longer present in the record type
2280 -- rma_flag VARCHAR2 Optional
2281 -- Must be either 'Y' or 'N'. Can only be set to 'Y' for verified
2282 -- requests
2283 -- rma_header_id IN NUMBER Optional
2284 -- web_entry_flag VARCHAR2 Optional
2285 -- Indicates whether the update was done through the web
2286 -- Default = 'N'
2287 ------------------------------------------------------------------------------
2288 -- request_attribute_1 VARCHAR2 Optional
2289 -- Default = NULL
2290 -- request_attribute_2 VARCHAR2 Optional
2291 -- Default = NULL
2292 -- request_attribute_3 VARCHAR2 Optional
2293 -- Default = NULL
2294 -- request_attribute_4 VARCHAR2 Optional
2295 -- Default = NULL
2296 -- request_attribute_5 VARCHAR2 Optional
2297 -- Default = NULL
2298 -- request_attribute_6 VARCHAR2 Optional
2299 -- Default = NULL
2300 -- request_attribute_7 VARCHAR2 Optional
2301 -- Default = NULL
2302 -- request_attribute_8 VARCHAR2 Optional
2303 -- Default = NULL
2304 -- request_attribute_9 VARCHAR2 Optional
2305 -- Default = NULL
2306 -- request_attribute_10 VARCHAR2 Optional
2307 -- Default = NULL
2308 -- request_attribute_11 VARCHAR2 Optional
2309 -- Default = NULL
2310 -- request_attribute_12 VARCHAR2 Optional
2311 -- Default = NULL
2312 -- request_attribute_13 VARCHAR2 Optional
2313 -- Default = NULL
2314 -- request_attribute_14 VARCHAR2 Optional
2315 -- Default = NULL
2316 -- request_attribute_15 VARCHAR2 Optional
2317 -- Default = NULL
2318 -- request_context VARCHAR2 Optional
2319 -- Default = NULL
2320 -- bill_to_site_use_id NUMBER Optional
2321 -- bill_to_contact_id NUMBER Optional
2322 ------------------------------------------------------------------------
2323 -- These fields are no longer there in the service_request_rec_type
2324 -- bill_to_location VARCHAR2 Optional
2325 -- bill_to_customer VARCHAR2 Optional
2326 -- bill_country VARCHAR2 Optional
2327 -- bill_to_address_1 VARCHAR2 Optional
2328 -- bill_to_address_2 VARCHAR2 Optional
2329 -- bill_to_address_3 VARCHAR2 Optional
2330 -- bill_to_contact VARCHAR2 Optional
2331 ---------------------------------------------------------------------------------------
2332 -- ship_to_site_use_id NUMBER Optional
2333 -- ship_to_contact_id NUMBER Optional
2334 -----------------------------------------------------------------------
2335 -- These fields are no longer there in the service_request_rec_type
2336 -- ship_to_location VARCHAR2 Optional
2337 -- ship_to_customer VARCHAR2 Optional
2338 -- ship_country VARCHAR2 Optional
2339 -- ship_to_address_1 VARCHAR2 Optional
2340 -- ship_to_address_2 VARCHAR2 Optional
2341 -- ship_to_address_3 VARCHAR2 Optional
2342 -- ship_to_contact VARCHAR2 Optional
2343 ----------------------------------------------------------
2344 -- This field is not there in the record type
2345 -- problem_resolution VARCHAR2 Optional
2346 ------------------------------------------------------------------------
2347 -- resolution_code VARCHAR2 Optional
2348 -- act_resolution_date DATE Optional
2349 -- Must be later than the service request date
2350 ----------------------------------------------------------
2351 -- This field
2352 -- make_public_resolution VARCHAR2 Optional
2353 ------------------------------------------------------------------
2354 -- public_comment_flag VARCHAR2 Optional
2355 -- Default = 'N'
2356 -- parent_interaction_id NUMBER Optional
2357 -- Corresponds to the column INTERACTION_ID in the table
2358 -- CS_INTERACTIONS, and identifies the parent interaction that
2359 -- resulted in this service request update
2360 -- contract_service_id NUMBER Optional
2361 -- qa_collection_plan_id NUMBER Optional
2362 -- account_id NUMBER Optional
2363 -- resource_type VARCHAR2(30) Optional
2364 -- resource_subtype_id NUMBER Optional
2365 -- cust_po_number VARCHAR2(50) Optional
2366 -- cust_ticket_number VARCHAR2(50) Optional
2367 ------------------------------------------------------------------
2368 -- This cannot be updated
2369 -- sr_creation_channel VARCHAR2(50) Optional
2370 ----------------------------------------------------------------------
2371 -- obligation_date DATE Optional
2372 -- time_zone_id NUMBER Optional
2373 -- time_difference NUMBER Optional
2374 -- site_id NUMBER Optional
2375 -- customer_site_id NUMBER Optional
2376 -- territory_id NUMBER Optional
2377 -- cp_revision_id NUMBER OPTIONAL
2378 -- inv_item_revision VARCHAR2(3) OPTIONAL
2379 -- inv_component_id NUMBER OPTIONAL
2380 -- inv_component_version VARCHAR2(3) OPTIONAL
2381 -- inv_subcomponent_id NUMBER OPTIONAL
2382 -- inv_subcomponent_version VARCHAR2(3) OPTIONAL
2383 -- initialize_flag VARCHAR2(1) Optional
2384 -- coverage_type VARCHAR2(30) Optional
2385 -- Service Request Coverage Type
2386 -- bill_to_account_id NUMBER Optional
2387 -- Service Request Bill To Account Identifier
2388 -- ship_to_account_id NUMBER Optional
2389 -- Service Request Ship To Account Identifier
2390 -- customer_phone_id NUMBER Optional
2391 -- SR Customer's non-primary phone Id
2392 -- customer_email_id NUMBER Optional
2393 -- SR Customer's non-primary Email Id
2394 -- End of service_request_rec_type comments
2395 --------------------------------------------------------------
2396
2397 PROCEDURE Update_ServiceRequest
2398 ( p_api_version IN NUMBER,
2399 p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
2400 p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
2401 p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
2402 x_return_status OUT NOCOPY VARCHAR2,
2403 x_msg_count OUT NOCOPY NUMBER,
2404 x_msg_data OUT NOCOPY VARCHAR2,
2405 p_request_id IN NUMBER,
2406 p_audit_id IN NUMBER DEFAULT NULL,
2407 p_object_version_number IN NUMBER,
2408 p_resp_appl_id IN NUMBER DEFAULT NULL,
2409 p_resp_id IN NUMBER DEFAULT NULL,
2410 p_last_updated_by IN NUMBER,
2411 p_last_update_login IN NUMBER DEFAULT NULL,
2412 p_last_update_date IN DATE,
2413 p_service_request_rec IN service_request_rec_type,
2414 p_invocation_mode IN VARCHAR2 := 'NORMAL',
2415 p_update_desc_flex IN VARCHAR2 DEFAULT fnd_api.g_false,
2416 p_notes IN notes_table,
2417 p_contacts IN contacts_table,
2418 p_audit_comments IN VARCHAR2 DEFAULT NULL,
2419 p_called_by_workflow IN VARCHAR2 DEFAULT fnd_api.g_false,
2420 p_workflow_process_id IN NUMBER DEFAULT NULL,
2421 -- Commented out since these are now part of the out rec type --anmukher--08/08/03
2422 -- x_workflow_process_id OUT NOCOPY NUMBER,
2423 -- x_interaction_id OUT NOCOPY NUMBER,
2424 ----------------anmukher--------------------08/05/03
2425 -- Added for 11.5.10 projects
2426 p_auto_assign IN VARCHAR2 Default 'N',
2427 p_validate_sr_closure IN VARCHAR2 Default 'N',
2428 p_auto_close_child_entities IN VARCHAR2 Default 'N',
2429 p_default_contract_sla_ind IN VARCHAR2 Default 'N',
2430 --Add p_auto_generate_tasks for 12.2-Auto Task creation
2431 p_auto_generate_tasks IN VARCHAR2 Default 'N',
2432 x_sr_update_out_rec OUT NOCOPY sr_update_out_rec_type
2433 );
2434
2435 ----------------anmukher--------------08/11/03
2436 -- Overloaded procedure added for backward compatibility in 11.5.10
2437 -- since several new OUT parameters have been added to the 11.5.9 signature
2438 -- in the form of a new record type, sr_update_out_rec_type
2439 PROCEDURE Update_ServiceRequest
2440 ( p_api_version IN NUMBER,
2441 p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
2442 p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
2443 p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
2444 x_return_status OUT NOCOPY VARCHAR2,
2445 x_msg_count OUT NOCOPY NUMBER,
2446 x_msg_data OUT NOCOPY VARCHAR2,
2447 p_request_id IN NUMBER,
2448 p_audit_id IN NUMBER DEFAULT NULL,
2449 p_object_version_number IN NUMBER,
2450 p_resp_appl_id IN NUMBER DEFAULT NULL,
2451 p_resp_id IN NUMBER DEFAULT NULL,
2452 p_last_updated_by IN NUMBER,
2453 p_last_update_login IN NUMBER DEFAULT NULL,
2454 p_last_update_date IN DATE,
2455 p_service_request_rec IN service_request_rec_type,
2456 p_invocation_mode IN VARCHAR2 := 'NORMAL',
2457 p_update_desc_flex IN VARCHAR2 DEFAULT fnd_api.g_false,
2458 p_notes IN notes_table,
2459 p_contacts IN contacts_table,
2460 p_audit_comments IN VARCHAR2 DEFAULT NULL,
2461 p_called_by_workflow IN VARCHAR2 DEFAULT fnd_api.g_false,
2462 p_workflow_process_id IN NUMBER DEFAULT NULL,
2463 p_default_contract_sla_ind IN VARCHAR2 Default 'N',
2464 x_workflow_process_id OUT NOCOPY NUMBER,
2465 x_interaction_id OUT NOCOPY NUMBER
2466 );
2467
2468 --------------------------------------------------------------------------
2469 -- Start of comments
2470 -- API Name : Update_Status
2471 -- Type : Private
2472 -- Description : Update the status of a service request
2473 -- Pre-reqs : None
2474 -- Parameters :
2475 -- IN :
2476 -- p_api_version IN NUMBER Required
2477 -- p_init_msg_list IN VARCHAR2 Optional
2478 -- Default = FND_API.G_FALSE
2479 -- p_commit IN VARCHAR2 Optional
2480 -- Default = FND_API.G_FALSE
2481 -- p_validation_level IN NUMBER Optional
2482 -- Default = FND_API.G_VALID_LEVEL_FULL
2483 -- p_request_id IN NUMBER Required
2484 ----------------------------------------------------
2485 -- Removed from the api
2486 -- p_org_id IN NUMBER Optional
2487 -- For validating the service request ID
2488 -- Default = NULL
2489 ----------------------------------------------------------
2490
2491 -- p_status_id IN NUMBER Required
2492 -- Cannot be NULL
2493 -- p_closed_date IN DATE Optional
2494 -- The date the service request is closed
2495 -- Default = NULL
2496 -- p_last_updated_by IN VARCHAR2 Required
2497 -- p_last_update_login IN NUMBER Optional
2498 -- Default = NULL
2499 -- p_last_update_date IN DATE Required
2500 -- p_audit_comments IN VARCHAR2 Optional
2501 -- To be used for the audit record
2502 -- Default = NULL
2503 -- p_call_by_workflow IN VARCHAR2 Optional
2504 -- Indicates whether this API is being called by a workflow
2505 -- process
2506 -- Default = FND_API.G_FALSE
2507 -- p_workflow_process_id IN NUMBER Optional
2508 -- The workflow process id of the workflow process that is
2509 -- calling this API
2510 -- Default = NULL
2511 -- p_comments IN VARCHAR2 Optional
2512 -- Default = NULL
2513 -- p_public_comment_flag IN VARCHAR2 Optional
2514 -- Default = 'N'
2515 -- p_parent_interaction_id IN NUMBER Optional
2516 -- Corresponds to the column INTERACTION_ID in the table
2517 -- CS_INTERACTIONS, and identifies the parent interaction that
2518 -- resulted in this service request update
2519 --
2520 -- OUT :
2521 -- p_return_status OUT VARCHAR2(1) Required
2522 -- p_msg_count OUT NUMBER Required
2523 -- p_msg_data OUT VARCHAR2(2000) Required
2524 -- p_call_id OUT NUMBER Required
2525 --
2526 -- Version : Current version 1.1
2527 -- Added IN parameter p_parent_interaction_id.
2528 -- Previous version 1.0
2529 -- Initial Version 1.0
2530 --
2531 -- Notes: : If the old value is the same as the new value, then no
2532 -- update is performed and a warning message is appended to the
2533 -- message list.
2534 --
2535 -- If there is an active workflow process for the service
2536 -- request, its status cannot be updated to a "closed" status
2537 -- (a status with the close_flag set) unless the caller of the
2538 -- API is the workflow process itself. In that case, the caller
2539 -- must pass in the workflow_process_id of the process for
2540 -- validation.
2541 --
2542 -- The p_closed_date parameter is ignored if the new status is
2543 -- not a "closed" status. If this parameter is not passed in
2544 -- for a "closed" status, sysdate will be used as the default
2545 -- value.
2546 --
2547 -- End of comments
2548 --------------------------------------------------------------------------
2549
2550
2551 FUNCTION Get_API_Revision
2552 RETURN NUMBER;
2553
2554 PROCEDURE Update_Status
2555 ( p_api_version IN NUMBER,
2556 p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
2557 p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
2558 p_resp_id IN NUMBER,
2559 p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
2560 x_return_status OUT NOCOPY VARCHAR2,
2561 x_msg_count OUT NOCOPY NUMBER,
2562 x_msg_data OUT NOCOPY VARCHAR2,
2563 p_request_id IN NUMBER,
2564 p_object_version_number IN NUMBER,
2565 p_status_id IN NUMBER,
2566 p_closed_date IN DATE DEFAULT fnd_api.g_miss_date,
2567 p_last_updated_by IN NUMBER,
2568 p_last_update_login IN NUMBER DEFAULT NULL,
2569 p_last_update_date IN DATE,
2570 p_audit_comments IN VARCHAR2 DEFAULT NULL,
2571 p_called_by_workflow IN VARCHAR2 DEFAULT fnd_api.g_false,
2572 p_workflow_process_id IN NUMBER DEFAULT NULL,
2573 p_comments IN VARCHAR2 DEFAULT NULL,
2574 p_public_comment_flag IN VARCHAR2 DEFAULT fnd_api.g_false,
2575 p_parent_interaction_id IN NUMBER DEFAULT NULL,
2576 -- Added for 11.5.10 projects
2577 p_validate_sr_closure IN VARCHAR2 Default 'N',
2578 p_auto_close_child_entities IN VARCHAR2 Default 'N',
2579 --Add p_auto_generate_tasks for 12.2-Auto Task creation
2580 p_auto_generate_tasks IN VARCHAR2 Default 'N',
2581 x_interaction_id OUT NOCOPY NUMBER
2582 );
2583
2584 --------------------------------------------------------------------------
2585 -- Start of comments
2586 -- API Name : Update_Owner
2587 -- Type : Private
2588 -- Description : Update the owner field of a service request
2589 -- Pre-reqs : p_owner_id must be a valid employee ID for an active
2590 -- employee in HR.
2591 -- Parameters :
2592 -- IN :
2593 -- p_api_version IN NUMBER Required
2594 -- p_init_msg_list IN VARCHAR2 Optional
2595 -- Default = FND_API.G_FALSE
2596 -- p_commit IN VARCHAR2 Optional
2597 -- Default = FND_API.G_FALSE
2598 -- p_validation_level IN NUMBER Optional
2599 -- Default = FND_API.G_VALID_LEVEL_FULL
2600 -- p_request_id IN NUMBER Required
2601 -- p_resp_id IN NUMBER Optional
2602 -- Default = NULL
2603 -- p_resp_appl_id IN NUMBER Optional
2604 -- Default = NULL
2605 -- For validating the service request owner
2606
2607 ---------------------------------------------------
2608 -- Removed from API
2609 -- p_org_id IN NUMBER Optional
2610 -- For validating the service request ID
2611 -- Default = NULL
2612 -----------------------------------------------------------
2613
2614
2615 -- p_owner_id IN VARCHAR2 Required
2616 -- Cannot be NULL
2617 -- p_last_updated_by IN NUMBER Required
2618 -- p_last_update_login IN NUMBER Optional
2619 -- Default = NULL
2620 -- p_last_update_date IN DATE Required
2621 -- p_audit_comments IN VARCHAR2 Optional
2622 -- To be used for the audit record
2623 -- Default = NULL
2624 -- p_call_by_workflow IN VARCHAR2 Optional
2625 -- Indicates whether this API is being called by a workflow
2626 -- process
2627 -- Default = FND_API.G_FALSE
2628 -- p_workflow_process_id IN NUMBER Optional
2629 -- Default = NULL
2630 -- The workflow process id of the workflow process that is
2631 -- calling this API
2632 -- p_comments IN VARCHAR2 Optional
2633 -- Default = NULL
2634 -- p_public_comment_flag IN VARCHAR2 Optional
2635 -- Default = 'N'
2636 -- p_parent_interaction_id IN NUMBER Optional
2637 -- Corresponds to the column INTERACTION_ID in the table
2638 -- CS_INTERACTIONS, and identifies the parent interaction that
2639 -- resulted in this service request update
2640 --
2641 -- OUT :
2642 -- p_return_status OUT VARCHAR2(1) Required
2643 -- p_msg_count OUT NUMBER Required
2644 -- p_msg_data OUT VARCHAR2(2000) Required
2645 -- p_call_id OUT NUMBER Required
2646 --
2647 -- Version : Current version 1.1
2648 -- Added IN parameter p_parent_interaction_id.
2649 -- Previous version 1.0
2650 -- Initial Version 1.0
2651 --
2652 -- Notes: : If the old value is the same as the new value, then no
2653 -- update is performed and a warning message is appended to the
2654 -- message list.
2655 --
2656 -- If there is an active workflow process for the service
2657 -- request, its owner cannot be updated unless the caller of
2658 -- the API is the workflow process itself. In that case, the
2659 -- caller must pass in the workflow_process_id of the process
2660 -- for validation.
2661 --
2662 -- End of comments
2663 --------------------------------------------------------------------------
2664
2665 PROCEDURE Update_Owner
2666 ( p_api_version IN NUMBER,
2667 p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
2668 p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
2669 p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
2670 x_return_status OUT NOCOPY VARCHAR2,
2671 x_msg_count OUT NOCOPY NUMBER,
2672 x_msg_data OUT NOCOPY VARCHAR2,
2673 p_request_id IN NUMBER,
2674 p_object_version_number IN NUMBER,
2675 p_resp_id IN NUMBER DEFAULT NULL,
2676 p_resp_appl_id IN NUMBER DEFAULT NULL,
2677 p_owner_id IN NUMBER,
2678 p_owner_group_id IN NUMBER,
2679 p_resource_type IN VARCHAR2,
2680 p_last_updated_by IN NUMBER,
2681 p_last_update_login IN NUMBER DEFAULT NULL,
2682 p_last_update_date IN DATE,
2683 p_audit_comments IN VARCHAR2 DEFAULT NULL,
2684 p_called_by_workflow IN VARCHAR2 DEFAULT fnd_api.g_false,
2685 p_workflow_process_id IN NUMBER DEFAULT NULL,
2686 p_comments IN VARCHAR2 DEFAULT NULL,
2687 p_public_comment_flag IN VARCHAR2 DEFAULT fnd_api.g_false,
2688 p_parent_interaction_id IN NUMBER DEFAULT NULL,
2689 x_interaction_id OUT NOCOPY NUMBER
2690 );
2691
2692 -- -------------------------------------------------------------------
2693 -- Start of comments
2694 -- API Name : Create_Audit_Record
2695 -- Type : Private
2696 -- Description : Insert an audit record into CS_INCIDENTS_AUDIT for
2697 -- service request updates.
2698 -- Pre-reqs : None
2699 -- Parameters :
2700 -- IN :
2701 -- p_api_version IN NUMBER Required
2702 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
2703 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
2704 -- p_request_id IN NUMBER Required
2705 -- p_change_flags IN AUDIT_FLAGS_REC_TYPE Required
2706 -- p_old_vals_rec IN AUDIT_VALS_REC_TYPE Optional
2707 -- p_new_vals_rec IN AUDIT_VALS_REC_TYPE Optional
2708 -- p_action_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
2709 -- p_wf_process_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
2710 -- p_wf_process_itemkey IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
2711 -- p_user_id IN NUMBER Required
2712 -- p_login_id IN NUMBER Optional Default = NULL
2713 -- p_comments IN VARCHAR2 Optional Default = NULL
2714 --
2715 -- OUT :
2716 -- p_return_status OUT VARCHAR2 Required Length = 1
2717 -- p_msg_count OUT NUMBER Required
2718 -- p_msg_data OUT VARCHAR2 Required Length = 2000
2719 --
2720 -- Version : Initial Version 1.0
2721 --
2722 -- Notes: :
2723 --
2724 -- End of comments
2725 -- -------------------------------------------------------------------
2726
2727 PROCEDURE Create_Audit_Record (
2728 p_api_version IN NUMBER,
2729 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
2730 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
2731 x_return_status OUT NOCOPY VARCHAR2,
2732 x_msg_count OUT NOCOPY NUMBER,
2733 x_msg_data OUT NOCOPY VARCHAR2,
2734 p_request_id IN NUMBER,
2735 p_audit_id IN NUMBER DEFAULT NULL,
2736 --p_change_flags IN audit_flags_rec_type,
2737 --p_old_vals_rec IN audit_vals_rec_type DEFAULT G_MISS_AUDIT_VALS_REC,
2738 --p_new_vals_rec IN audit_vals_rec_type DEFAULT G_MISS_AUDIT_VALS_REC,
2739 p_audit_vals_rec IN SR_AUDIT_REC_TYPE,
2740 p_action_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
2741 p_wf_process_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
2742 p_wf_process_itemkey IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
2743 p_user_id IN NUMBER,
2744 p_login_id IN NUMBER DEFAULT NULL,
2745 p_last_update_date IN DATE,
2746 p_creation_date IN DATE,
2747 p_comments IN VARCHAR2 DEFAULT NULL,
2748 x_audit_id OUT NOCOPY NUMBER
2749 );
2750
2751 PROCEDURE Add_Language;
2752
2753 -- Lock row procedure
2754 -- This is used to lock a row in the Service Request form
2755
2756 PROCEDURE LOCK_ROW(
2757 X_INCIDENT_ID NUMBER,
2758 X_OBJECT_VERSION_NUMBER NUMBER
2759 );
2760
2761
2762 /* Added for enh. 2655115, to get the status flag based on close_flag
2763 and status_id by shijain date 27th nov 2002*/
2764
2765 FUNCTION GET_STATUS_FLAG ( p_incident_status_id IN NUMBER)
2766 RETURN VARCHAR2;
2767
2768 /* Added for enh. 2690787, to get the primary flag based on incident_id
2769 and primary_flag by shijain date 09th dec 2002
2770
2771 FUNCTION GET_PRIMARY_CONTACT ( p_incident_id IN NUMBER)
2772 RETURN NUMBER;
2773
2774 */
2775
2776 /* defined the global variable to get the profile valus for cs_sr_restrict_ib
2777 profile variable by shijain 4th dec 2002*/
2778
2779 G_RESTRICT_IB VARCHAR2(5) ;
2780
2781 -- Added for 11.5.10 Auditing project --anmukher --09/10/03
2782
2783 PROCEDURE initialize_audit_rec
2784 (
2785 p_sr_audit_record IN OUT NOCOPY sr_audit_rec_type
2786 );
2787
2788 PROCEDURE Delete_ServiceRequest
2789 (
2790 p_api_version_number IN NUMBER := 1.0
2791 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
2792 , p_commit IN VARCHAR2 := FND_API.G_FALSE
2793 , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
2794 , p_processing_set_id IN NUMBER
2795 , p_purge_set_id IN NUMBER
2796 , p_purge_source_with_open_task IN VARCHAR2
2797 , p_audit_required IN VARCHAR2
2798 , x_return_status OUT NOCOPY VARCHAR2
2799 , x_msg_count OUT NOCOPY NUMBER
2800 , x_msg_data OUT NOCOPY VARCHAR2
2801 );
2802 --------------------------------------------------------------------------------
2803 PROCEDURE process_sr_ext_attrs
2804 ( p_api_version IN NUMBER
2805 , p_init_msg_list IN VARCHAR2 DEFAULT NULL
2806 , p_commit IN VARCHAR2 DEFAULT NULL
2807 , p_incident_id IN NUMBER
2808 , p_ext_attr_grp_tbl IN CS_ServiceRequest_PUB.EXT_ATTR_GRP_TBL_TYPE
2809 , p_ext_attr_tbl IN CS_ServiceRequest_PUB.EXT_ATTR_TBL_TYPE
2810 , p_modified_by IN NUMBER DEFAULT NULL
2811 , p_modified_on IN DATE DEFAULT NULL
2812 , x_failed_row_id_list OUT NOCOPY VARCHAR2
2813 , x_return_status OUT NOCOPY VARCHAR2
2814 , x_errorcode OUT NOCOPY NUMBER
2815 , x_msg_count OUT NOCOPY NUMBER
2816 , x_msg_data OUT NOCOPY VARCHAR2
2817 );
2818 --------------------------------------------------------------------------------
2819 --created by siahmed for 12.1.2 projet for one time address creation
2820 PROCEDURE create_onetime_address
2821 ( p_service_req_rec IN service_request_rec_type,
2822 x_msg_count OUT NOCOPY NUMBER,
2823 x_msg_data OUT NOCOPY VARCHAR2,
2824 x_return_status OUT NOCOPY VARCHAR2,
2825 x_location_id OUT NOCOPY NUMBER
2826 );
2827 --end of address creation procedure siahmed
2828 --------------------------------------------------------------------------------
2829 --created by siahmed for 12.1.2 projet for one time address updation
2830 PROCEDURE update_onetime_address
2831 ( p_service_req_rec IN service_request_rec_type,
2832 x_msg_count OUT NOCOPY NUMBER,
2833 x_msg_data OUT NOCOPY VARCHAR2,
2834 x_return_status OUT NOCOPY VARCHAR2);
2835 --end of address updation procedure siahmed
2836 --------------------------------------------------------------------------------
2837 END CS_ServiceRequest_PVT;