1 PACKAGE CS_ASSIGN_RESOURCE_PKG AUTHID CURRENT_USER as
2 /* $Header: csvasrss.pls 120.2 2006/04/05 01:31:24 brajasek noship $ */
3
4 /* Record and Tables used in proc */
5 TYPE LoadBalance_rec_type IS RECORD
6 (resource_id NUMBER DEFAULT NULL,
7 resource_type VARCHAR2(30) DEFAULT NULL,
8 support_site_id NUMBER DEFAULT NULL,
9 product_skill_level NUMBER DEFAULT NULL,
10 platform_skill_level NUMBER DEFAULT NULL,
11 pbm_code_skill_level NUMBER DEFAULT NULL,
12 category_skill_level NUMBER DEFAULT NULL,
13 time_since_last_login NUMBER DEFAULT NULL,
14 backlog_sev1 NUMBER DEFAULT NULL,
15 backlog_sev2 NUMBER DEFAULT NULL,
16 backlog_sev3 NUMBER DEFAULT NULL,
17 backlog_sev4 NUMBER DEFAULT NULL,
18 time_zone_lag NUMBER DEFAULT NULL,
19 total_load NUMBER DEFAULT NULL,
20 territory_id NUMBER DEFAULT NULL
21 );
22
23 TYPE LoadBalance_tbl_type IS TABLE OF LoadBalance_rec_type
24 INDEX BY BINARY_INTEGER;
25 PROCEDURE Get_Sup_Usage_Group
26 (p_assign_resources_tbl IN JTF_ASSIGN_PUB.AssignResources_tbl_type,
27 x_resource_id OUT NOCOPY NUMBER,
28 x_territory_id OUT NOCOPY NUMBER
29 );
30
31 --Added x_owner_group_id for ER# 2616902
32 PROCEDURE Assign_ServiceRequest_Main
33 (p_api_name IN VARCHAR2,
34 p_api_version IN NUMBER,
35 p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
36 p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
37 p_incident_id IN NUMBER,
38 p_object_version_number IN NUMBER,
39 p_last_updated_by IN VARCHAR2,
40 p_service_request_rec IN CS_ServiceRequest_PVT.service_request_rec_type,
41 x_owner_group_id OUT NOCOPY NUMBER,
42 x_owner_id OUT NOCOPY NUMBER,
43 x_owner_type OUT NOCOPY VARCHAR2,
44 x_territory_id OUT NOCOPY NUMBER,
45 x_return_status OUT NOCOPY VARCHAR2,
46 x_msg_count OUT NOCOPY NUMBER,
47 x_msg_data OUT NOCOPY VARCHAR2
48 );
49
50 PROCEDURE Assign_Resources
51 (p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
52 p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
53 p_incident_id IN NUMBER,
54 p_object_version_number IN NUMBER,
55 p_last_updated_by IN VARCHAR2,
56 p_service_request_rec IN CS_ServiceRequest_PVT.service_request_rec_type,
57 x_owner_group_id OUT NOCOPY NUMBER,
58 x_owner_type OUT NOCOPY VARCHAR2,
59 x_owner_id OUT NOCOPY NUMBER,
60 x_territory_id OUT NOCOPY NUMBER,
61 x_return_status OUT NOCOPY VARCHAR2,
62 x_msg_count OUT NOCOPY NUMBER,
63 x_msg_data OUT NOCOPY VARCHAR2
64 );
65
66 PROCEDURE Assign_Group
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_group_type IN VARCHAR2,
71 p_service_request_rec IN CS_ServiceRequest_PVT.service_request_rec_type,
72 x_return_status OUT NOCOPY VARCHAR2,
73 x_resource_id OUT NOCOPY NUMBER,
74 x_territory_id OUT NOCOPY NUMBER,
75 x_msg_count OUT NOCOPY NUMBER,
76 x_msg_data OUT NOCOPY VARCHAR2
77 );
78
79 PROCEDURE Assign_Owner
80 (p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
81 p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
82 p_incident_id IN NUMBER,
83 p_param_resource_type IN VARCHAR2,
84 p_group_id IN NUMBER,
85 p_service_request_rec IN CS_ServiceRequest_PVT.service_request_rec_type,
86 x_return_status OUT NOCOPY VARCHAR2,
87 x_resource_id OUT NOCOPY NUMBER,
88 x_resource_type OUT NOCOPY VARCHAR2,
89 x_territory_id OUT NOCOPY NUMBER,
90 x_msg_count OUT NOCOPY NUMBER,
91 x_msg_data OUT NOCOPY VARCHAR2
92 );
93
94 -- Added p_inv_cat_id as parameter by pnkalari on 06/07/2002.
95 PROCEDURE Calculate_Load
96 (p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
97 p_incident_id IN NUMBER,
98 p_incident_type_id IN NUMBER,
99 p_incident_severity_id IN NUMBER,
100 p_inv_item_id IN NUMBER,
101 p_inv_org_id IN NUMBER,
102 p_inv_cat_id IN NUMBER,
103 p_platform_org_id IN NUMBER,
104 p_platform_id IN NUMBER,
105 p_problem_code IN VARCHAR2,
106 p_contact_timezone_id IN NUMBER,
107 p_res_load_table IN OUT NOCOPY CS_ASSIGN_RESOURCE_PKG.LoadBalance_tbl_type,
108 x_return_status OUT NOCOPY VARCHAR2,
109 x_resource_id OUT NOCOPY NUMBER,
110 x_resource_type OUT NOCOPY VARCHAR2,
111 x_msg_count OUT NOCOPY NUMBER,
112 x_msg_data OUT NOCOPY VARCHAR2,
113 x_territory_id OUT NOCOPY NUMBER
114 );
115
116 END CS_ASSIGN_RESOURCE_PKG;