[Home] [Help]
PACKAGE: APPS.CS_SR_TASK_AUTOASSIGN_PKG
Source
1 PACKAGE CS_SR_TASK_AUTOASSIGN_PKG as
2 /* $Header: csxasrts.pls 120.2 2006/01/30 20:51:53 brajasek noship $ */
3
4 TYPE SR_Task_rec_type IS RECORD
5 ( TASK_ID NUMBER,
6 SERVICE_REQUEST_ID NUMBER,
7 PARTY_ID NUMBER,
8 COUNTRY VARCHAR2(60),
9 PARTY_SITE_ID NUMBER,
10 CITY VARCHAR2(60),
11 POSTAL_CODE VARCHAR2(60),
12 STATE VARCHAR2(60),
13 AREA_CODE VARCHAR2(10),
14 COUNTY VARCHAR2(60),
15 COMP_NAME_RANGE VARCHAR2(360),
16 PROVINCE VARCHAR2(60),
17 NUM_OF_EMPLOYEES NUMBER,
18 TASK_TYPE_ID NUMBER,
19 TASK_STATUS_ID NUMBER,
20 TASK_PRIORITY_ID NUMBER,
21 INCIDENT_TYPE_ID NUMBER,
22 INCIDENT_SEVERITY_ID NUMBER,
23 INCIDENT_URGENCY_ID NUMBER,
24 PROBLEM_CODE VARCHAR2(60),
25 INCIDENT_STATUS_ID NUMBER,
26 PLATFORM_ID NUMBER,
27 SUPPORT_SITE_ID NUMBER,
28 CUSTOMER_SITE_ID NUMBER,
29 SR_CREATION_CHANNEL VARCHAR2(150),
30 INVENTORY_ITEM_ID NUMBER,
31 ATTRIBUTE1 VARCHAR2(150),
32 ATTRIBUTE2 VARCHAR2(150),
33 ATTRIBUTE3 VARCHAR2(150),
34 ATTRIBUTE4 VARCHAR2(150),
35 ATTRIBUTE5 VARCHAR2(150),
36 ATTRIBUTE6 VARCHAR2(150),
37 ATTRIBUTE7 VARCHAR2(150),
38 ATTRIBUTE8 VARCHAR2(150),
39 ATTRIBUTE9 VARCHAR2(150),
40 ATTRIBUTE10 VARCHAR2(150),
41 ATTRIBUTE11 VARCHAR2(150),
42 ATTRIBUTE12 VARCHAR2(150),
43 ATTRIBUTE13 VARCHAR2(150),
44 ATTRIBUTE14 VARCHAR2(150),
45 ATTRIBUTE15 VARCHAR2(150),
46 ORGANIZATION_ID NUMBER,
47 SQUAL_NUM12 NUMBER, --INVENTORY ITEM ID / SR PLATFORM
48 SQUAL_NUM13 NUMBER, --ORGANIZATION ID / SR PLATFORM
49 SQUAL_NUM14 NUMBER, --CATEGORY ID / SR PRODUCT
50 SQUAL_NUM15 NUMBER, --INVENTORY ITEM ID / SR PRODUCT
51 SQUAL_NUM16 NUMBER, --ORGANIZATION ID / SR PRODUCT
52 SQUAL_NUM17 NUMBER, --SR GROUP OWNER
53 SQUAL_NUM18 NUMBER, --INVENTORY ITEM ID / CONTRACT SUPPORT SERVICE ITEM
54 SQUAL_NUM19 NUMBER, --ORGANIZATION ID / CONTRACT SUPPORT SERVICE ITEM
55 SQUAL_NUM30 NUMBER, --SR LANGUAGE ... should use squal_char20 instead
56 SQUAL_CHAR11 VARCHAR2(360), --VIP CUSTOMERS
57 SQUAL_CHAR12 VARCHAR2(360), --SR PROBLEM CODE
58 SQUAL_CHAR13 VARCHAR2(360), --SR CUSTOMER CONTACT PREFERENCE
59 SQUAL_CHAR20 VARCHAR2(360), --SR LANGUAGE ID for TERR REQ
60 SQUAL_CHAR21 VARCHAR2(360), --SR Service Contract Coverage
61 ITEM_COMPONENT NUMBER,
62 ITEM_SUBCOMPONENT NUMBER
63 );
64
65 PROCEDURE Assign_Task_Resource
66 (p_api_version IN NUMBER,
67 p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
68 p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
69 p_incident_id IN NUMBER,
70 p_service_request_rec IN CS_ServiceRequest_PUB.service_request_rec_type DEFAULT NULL,
71 p_task_attribute_rec IN SR_Task_rec_type,
72 x_owner_group_id OUT NOCOPY NUMBER,
73 x_group_type OUT NOCOPY VARCHAR2,
74 x_owner_type OUT NOCOPY VARCHAR2,
75 x_owner_id OUT NOCOPY NUMBER,
76 x_territory_id OUT NOCOPY NUMBER,
77 x_return_status OUT NOCOPY VARCHAR2,
78 x_msg_count OUT NOCOPY NUMBER,
79 x_msg_data OUT NOCOPY VARCHAR2
80 );
81
82 END CS_SR_TASK_AUTOASSIGN_PKG;