1 PACKAGE CS_ASSIGN_RESOURCE_CON_PKG as
2 /* $Header: csvconas.pls 120.2 2006/04/05 01:33:03 brajasek noship $ */
3
4 /* Record and Tables used in proc */
5
6 -- All the parameters are initialized to null for Bug# 2657149
7 TYPE LoadBalance_rec_type IS RECORD
8 (
9 resource_id NUMBER DEFAULT NULL,
10 resource_type VARCHAR2(30) DEFAULT NULL,
11 support_site_id NUMBER DEFAULT NULL,
12 product_skill_level NUMBER DEFAULT NULL,
13 platform_skill_level NUMBER DEFAULT NULL,
14 pbm_code_skill_level NUMBER DEFAULT NULL,
15 category_skill_level NUMBER DEFAULT NULL,
16 time_since_last_login NUMBER DEFAULT NULL,
17 backlog_sev1 NUMBER DEFAULT NULL,
18 backlog_sev2 NUMBER DEFAULT NULL,
19 backlog_sev3 NUMBER DEFAULT NULL,
20 backlog_sev4 NUMBER DEFAULT NULL,
21 time_zone_lag NUMBER DEFAULT NULL,
22 total_load NUMBER DEFAULT NULL,
23 territory_id NUMBER DEFAULT NULL
24 );
25
26 TYPE LoadBalance_tbl_type IS TABLE OF LoadBalance_rec_type
27 INDEX BY BINARY_INTEGER;
28 PROCEDURE MAIN_PROCEDURE
29 (X_ERRBUF OUT NOCOPY VARCHAR2,
30 X_RETCODE OUT NOCOPY NUMBER,
31 P_GROUP1_ID IN NUMBER,
32 P_GROUP2_ID IN NUMBER,
33 P_GROUP3_ID IN NUMBER,
34 P_GROUP4_ID IN NUMBER,
35 P_GROUP5_ID IN NUMBER,
36 P_INCIDENT_TYPE1_ID IN NUMBER,
37 P_INCIDENT_TYPE2_ID IN NUMBER,
38 P_INCIDENT_TYPE3_ID IN NUMBER,
39 P_INCIDENT_TYPE4_ID IN NUMBER,
40 P_INCIDENT_TYPE5_ID IN NUMBER,
41 P_INCIDENT_SEVERITY1_ID IN NUMBER,
42 P_INCIDENT_SEVERITY2_ID IN NUMBER,
43 P_INCIDENT_SEVERITY3_ID IN NUMBER,
44 P_INCIDENT_SEVERITY4_ID IN NUMBER,
45 P_INCIDENT_SEVERITY5_ID IN NUMBER
46 );
47
48
49 PROCEDURE Assign_ServiceRequest_Main
50 (p_api_name IN VARCHAR2,
51 p_api_version IN NUMBER,
52 p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
53 p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
54 p_incident_id IN NUMBER,
55 p_object_version_number IN NUMBER,
56 p_last_updated_by IN VARCHAR2,
57 p_service_request_rec IN CS_ServiceRequest_PVT.service_request_rec_type,
58 x_owner_group_id OUT NOCOPY NUMBER,
59 x_owner_id OUT NOCOPY NUMBER,
60 x_owner_type OUT NOCOPY VARCHAR2,
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_Resources
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_object_version_number IN NUMBER,
71 p_last_updated_by IN VARCHAR2,
72 p_service_request_rec IN CS_ServiceRequest_PVT.service_request_rec_type,
73 x_owner_group_id OUT NOCOPY NUMBER,
74 x_owner_type OUT NOCOPY VARCHAR2,
75 x_owner_id OUT NOCOPY NUMBER,
76 x_return_status OUT NOCOPY VARCHAR2,
77 x_msg_count OUT NOCOPY NUMBER,
78 x_msg_data OUT NOCOPY VARCHAR2
79 );
80
81 PROCEDURE Assign_Group
82 (p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
83 p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
84 p_incident_id IN NUMBER,
85 p_group_type IN VARCHAR2,
86 p_service_request_rec IN CS_ServiceRequest_PVT.service_request_rec_type,
87 x_return_status OUT NOCOPY VARCHAR2,
88 x_resource_id OUT NOCOPY NUMBER,
89 x_territory_id OUT NOCOPY NUMBER,
90 x_msg_count OUT NOCOPY NUMBER,
91 x_msg_data OUT NOCOPY VARCHAR2
92 );
93
94 PROCEDURE Assign_Owner
95 (p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
96 p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
97 p_incident_id IN NUMBER,
98 p_param_resource_type IN VARCHAR2,
99 p_group_id IN NUMBER,
100 p_service_request_rec IN CS_ServiceRequest_PVT.service_request_rec_type,
101 x_return_status OUT NOCOPY VARCHAR2,
102 x_resource_id OUT NOCOPY NUMBER,
103 x_resource_type OUT NOCOPY VARCHAR2,
104 x_territory_id OUT NOCOPY NUMBER,
105 x_msg_count OUT NOCOPY NUMBER,
106 x_msg_data OUT NOCOPY VARCHAR2
107 );
108
109 -- Added parameter p_inv_cat_id by pnkalari on 06/11/2002.
110 PROCEDURE Calculate_Load
111 (p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
112 p_incident_id IN NUMBER,
113 p_incident_type_id IN NUMBER,
114 p_incident_severity_id IN NUMBER,
115 p_inv_item_id IN NUMBER,
116 p_inv_org_id IN NUMBER,
117 p_inv_cat_id IN NUMBER,
118 p_platform_org_id IN NUMBER,
119 p_platform_id IN NUMBER,
120 p_problem_code IN VARCHAR2,
121 p_contact_timezone_id IN NUMBER,
122 p_res_load_table IN OUT NOCOPY CS_ASSIGN_RESOURCE_CON_PKG.LoadBalance_tbl_type,
123 x_return_status OUT NOCOPY VARCHAR2,
124 x_resource_id OUT NOCOPY NUMBER,
125 x_resource_type OUT NOCOPY VARCHAR2,
126 x_msg_count OUT NOCOPY NUMBER,
127 x_msg_data OUT NOCOPY VARCHAR2,
128 x_territory_id OUT NOCOPY NUMBER
129 );
130
131 END CS_ASSIGN_RESOURCE_CON_PKG;