1 PACKAGE CCT_ICJUMPSTART_PUB as
2 /* $Header: cctjumps.pls 120.0 2005/06/02 09:34:10 appldev noship $ */
3
4 /* -----------------------------------------------------------------------
5 Activity Name : CreateICAgent
6
7 This API creates an IC Agent in HR Employee, FND USER and JTF Resource Manager
8 It configures the role and agent parameters for the new IC Agent
9 IN
10 p_Last_name - Last Name of the Agent
11 p_First_Name - First Name of the Agent(optional)
12 p_middle_name - Middle Name of the Agent(optional)
13 p_Agent_Sex - M/F
14 p_App_Username - A unique UserName for the agent
15 p_IC_ROLE - Role of the agent in IC (CALL_CENTER_Agent/CALL_CENTER_Manager/CALL_CENTER_Supervisor)
16 p_IC_SErver_Group_ID - The Server Group ID to which the agent belongs
17 p_middleware_config_id - The middleware Config in the above Server Group ID to which the agent should be set up
18 p_acd_agent_ID - ACD Agent ID for the above middleware config
19 p_acd_agent_password - ACD Agent Password for the above middleware config
20 OUT
21 x_return_status - Success/Failure
22 x_message_data - Error messages if any
23 p_Resource_ID - Resource ID for the newly created Agent
24 *-----------------------------------------------------------------------*/
25
26 Procedure CreateICAgent(
27 p_LAST_NAME IN VARCHAR2
28 ,p_FIRST_NAME IN VARCHAR2 Default NULL
29 ,p_MIDDLE_NAME IN VARCHAR2 Default NULL
30 ,p_Agent_SEX IN VARCHAR2 Default 'M'
31 ,p_APP_USERNAME IN VARCHAR2
32 ,p_IC_ROLE IN VARCHAR2 Default 'CALL_CENTER_AGENT'
33 ,p_IC_SERVER_GROUP_ID IN NUMBER
34 ,p_middleware_config_id IN NUMBER Default NULL
35 ,p_ACD_AGENT_ID IN VARCHAR2 Default NULL
36 ,p_ACD_AGENT_PASSWORD IN VARCHAR2 Default Null
37 ,p_acd_queue IN VARCHAR2 Default NULL
38 ,p_Resource_ID OUT nocopy NUMBER
39 ,x_return_status OUT nocopy VARCHAR2
40 ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
41 ,p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
42 ,x_msg_count OUT nocopy NUMBER
43 ,x_message_data OUT nocopy VARCHAR2
44 ,x_user_password OUT nocopy VARCHAR2
45 );
46
47 /* -----------------------------------------------------------------------
48 Activity Name : CreateServerGroup
49
50 This API creates a new Server Group.
51 IN
52 p_server_group_name - a unique name for the server group
53 OUT
54 x_return_status - Success/Failure
55 x_message_data - Error messages if any
56 p_server_group_ID - Server Group ID for the newly created Server Group
57 *-----------------------------------------------------------------------*/
58 Procedure CreateServerGroup(
59 p_server_Group_Name In Varchar2
60 ,x_return_status OUT nocopy VARCHAR2
61 ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
62 ,p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
63 ,x_msg_count OUT nocopy NUMBER
64 ,x_message_data OUT nocopy VARCHAR2
65 ,x_Server_group_id Out nocopy Number
66 );
67
68 Procedure CreateAllServers(
69 p_server_group_id In Number
70 ,p_call_center_type IN VARCHAR2 DEFAULT NULL
71 ,x_return_Status OUT nocopy VARCHAR2
72 ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
73 ,p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
74 ,x_msg_count OUT nocopy NUMBER
75 ,x_message_data OUT nocopy VARCHAR2
76 ,x_SERVERTYPEID_SERVERID OUT nocopy CCT_KEYVALUE_VARR
77 );
78
79
80 Procedure CreateMiddlewareConfig(
81 p_server_group_id In Number
82 ,p_middleware_type IN Varchar2
83 ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
84 ,p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
85 ,x_return_Status OUT nocopy VARCHAR2
86 ,x_msg_count OUT nocopy NUMBER
87 ,x_message_data OUT nocopy VARCHAR2
88 ,x_middleware_id OUT nocopy Number
89 );
90
91 Procedure GetMiddlewareConfigInfo(
92 p_server_group_name In VARCHAR2 Default Null
93 ,p_server_group_id In Number Default Null
94 ,p_middleware_id In OUT nocopy Number
95 ,x_return_status OUT nocopy VARCHAR2
96 ,x_msg_count OUT nocopy NUMBER
97 ,x_message_data OUT nocopy VARCHAR2
98 ,x_config_name OUT nocopy VARCHAR2
99 ,x_middleware_type OUT nocopy VARCHAR2
100 ,x_param_value OUT nocopy CCT_KEYVALUE_VARR
101 );
102
103 Procedure CreateServerParam(
104 p_server_id In Number
105 ,p_param_value IN CCT_KEYVALUE_VARR
106 ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
107 ,p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
108 ,x_return_Status OUT nocopy VARCHAR2
109 ,x_msg_count OUT nocopy NUMBER
110 ,x_message_data OUT nocopy VARCHAR2
111 );
112
113 Procedure CreateMwareParam(
114 p_middleware_id In Number
115 ,p_param_value IN CCT_KEYVALUE_VARR
116 ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
117 ,p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
118 ,x_return_Status OUT nocopy VARCHAR2
119 ,x_msg_count OUT nocopy NUMBER
120 ,x_message_data OUT nocopy VARCHAR2
121 );
122
123 Procedure CreateTelesets(
124 p_middleware_id In Number
125 ,p_teleset_type In Varchar2
126 ,p_start_teleset_number In Number
127 ,p_skip_by In Number Default 1
128 ,p_number_of_Telesets In Number
129 ,p_line1 In Number Default Null
130 ,p_line2 In Number Default Null
131 ,p_line3 In Number Default 9999
132 ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
133 ,p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
134 ,x_return_Status OUT nocopy VARCHAR2
135 ,x_msg_count OUT nocopy NUMBER
136 ,x_message_data OUT nocopy VARCHAR2
137 );
138
139 Procedure CreateRoutePoint(
140 p_middleware_id In Number
141 ,p_route_point_number IN VARCHAR2
142 ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
143 ,p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
144 ,x_return_Status OUT nocopy VARCHAR2
145 ,x_msg_count OUT nocopy NUMBER
146 ,x_message_data OUT nocopy VARCHAR2
147 ,x_route_point_id OUT nocopy NUMBER
148 );
149
150 Procedure CreateRoutePointParams(
151 p_route_point_id In Number
152 ,p_param_value CCT_KEYVALUE_VARR
153 ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
154 ,p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
155 ,x_return_Status OUT nocopy VARCHAR2
156 ,x_msg_count OUT nocopy NUMBER
157 ,x_message_data OUT nocopy VARCHAR2
158 );
159
160 End CCT_ICJUMPSTART_PUB;