1 PACKAGE SR_UWQ_INTEG AUTHID CURRENT_USER AS
2 /* $Header: cssruwqs.pls 120.3.12020000.3 2013/03/24 09:20:39 spamujul ship $ */
3
4 ------------------------------------------------------------------------------------
5 -- Procedure : SR_UWQ_INTEG
6 -- Usage : Used by UWQ to call Service Request Form
7 -- Description : This procedure takes the table of objects containing
8 -- the meta data as input and gives the following as output:
9 -- 1. Action Type - Method to be used to call the SR Form
10 -- APP_NAVIGATE.EXECUTE
11 -- 2. Action Name - Name of the function to call the SR form
12 -- 3. Action Param - Parameters to be passed to the SR form.
13 -- Parameters :
14 -- p_ieu_media_data IN SYSTEM.IEU_UWQ_MEDIA_DATA_NST Required
15 -- p_action_type OUT NUMBER
16 -- p_action_name OUT VARCHAR2
17 -- p_action_param OUT VARCHAR2
18 --
19 -- PRAYADUR 04/28/2004 Added Procedure SR_UWQ_NONMEDIA_ACTIONS for Bug 3357706
20 ---------------------------------------------------------------------------------------
21
22 procedure sr_uwq_foo_func
23 ( p_ieu_media_data in SYSTEM.IEU_UWQ_MEDIA_DATA_NST,
24 p_action_type out NOCOPY number,
25 p_action_name out NOCOPY varchar2,
26 p_action_param out NOCOPY varchar2);
27
28 procedure connect_form_to_foo
29 ( p_ieu_media_data in IEU_FRM_PVT.t_ieu_media_data,
30 p_action_type out NOCOPY number,
31 p_action_name out NOCOPY varchar2,
32 p_action_param out NOCOPY varchar2);
33
34
35 procedure enumerate_sr_nodes
36 (p_resource_id in number,
37 p_language in varchar2,
38 p_source_lang in varchar2,
39 p_sel_enum_id in number );
40
41 procedure enumerate_sr_html_nodes
42 (p_resource_id in number,
43 p_language in varchar2,
44 p_source_lang in varchar2,
45 p_sel_enum_id in number );
46
47 procedure refresh_sr_nodes
48 (p_resource_id in number,
49 p_node_id in number,
50 p_count out NOCOPY number);
51
52 procedure ENUMERATE_CASE_HTML_NODES
53 (p_resource_id in number,
54 p_language in varchar2,
55 p_source_lang in varchar2,
56 p_sel_enum_id in number );
57
58 procedure ENUMERATE_TICKET_HTML_NODES
59 (p_resource_id in number,
60 p_language in varchar2,
61 p_source_lang in varchar2,
62 p_sel_enum_id in number );
63
64 procedure insert_row(
65 p_node_id in number default -1,
66 p_node_view in varchar2,
67 p_node_label in varchar2,
68 p_data_source in varchar2,
69 p_media_type_id in number,
70 p_where_clause in varchar2,
71 p_res_cat_enum_flag in varchar2,
72 p_node_type in varchar2,
73 p_hide_if_empty in varchar2,
74 p_node_depth in number,
75 p_parent_id in number,
76 p_node_query in varchar2,
77 p_cursor_sql in varchar2,
78 p_cursor_key_col in varchar2,
79 p_enabled_flag in varchar2,
80 p_creation_date in date,
81 p_created_by in number,
82 p_last_update_date in date,
83 p_last_updated_by in number,
84 p_last_update_login in number,
85 x_node_id out NOCOPY number,
86 x_return_status out NOCOPY varchar2);
87
88 procedure update_row(
89 p_node_id in number,
90 p_object_version_number in number,
91 p_node_view in varchar2,
92 p_node_label in varchar2,
93 p_data_source in varchar2,
94 p_media_type_id in number,
95 p_where_clause in varchar2,
96 p_res_cat_enum_flag in varchar2,
97 p_node_type in varchar2,
98 p_hide_if_empty in varchar2,
99 p_node_depth in number,
100 p_parent_id in number,
101 p_node_query in varchar2,
102 p_cursor_sql in varchar2,
103 p_cursor_key_col in varchar2,
104 p_enabled_flag in varchar2,
105 p_creation_date in date,
106 p_created_by in number,
107 p_last_update_date in date,
108 p_last_updated_by in number,
109 p_last_update_login in number,
110 x_return_status out NOCOPY varchar2);
111
112 procedure validate_ivr_parameter(
113 p_parameter_code in out NOCOPY varchar2,
114 p_parameter_value in out NOCOPY varchar2,
115 p_parameter_mesg in out NOCOPY varchar2,
116 p_param_action_val in out NOCOPY varchar2,
117 x_parameter_id out NOCOPY number,
118 x_parameter_flag out NOCOPY varchar2,
119 x_customer_id out NOCOPY number,
120 x_customer_type out NOCOPY varchar2,
121 x_return_status out NOCOPY varchar2);
122
123 procedure interpret_service_keys(
124 v_service_key in varchar2,
125 v_service_key_value in out NOCOPY varchar2,
126 p_cust_id in number,
127 p_cust_account_id in number,
128 p_phone_id in number,
129 x_parameter_code out NOCOPY varchar2,
130 x_return_status out NOCOPY varchar2);
131
132
133 procedure validate_security(
134 p_ivr_data_key in varchar2,
135 p_ivr_data_value in varchar2,
136 p_table_of_agents in out NOCOPY system.CCT_AGENT_RESP_APP_ID_NST,
137 x_return_status out NOCOPY varchar2);
138
139 procedure start_media_item( p_resp_appl_id in number,
140 p_resp_id in number,
141 p_user_id in number,
142 p_login_id in number,
143 x_return_status out nocopy varchar2,
144 x_msg_count out nocopy number,
145 x_msg_data out nocopy varchar2,
146 x_media_id out nocopy number,
147 p_outbound_dnis in varchar2 DEFAULT NULL, -- Added by vpremach for Bug 9499153
148 p_outbound_ani in varchar2 DEFAULT NULL -- Added by vpremach for Bug 9499153
149 );
150
151 PROCEDURE SR_UWQ_NONMEDIA_ACTIONS(
152 p_ieu_action_data IN SYSTEM.IEU_UWQ_MEDIA_DATA_NST,
153 x_action_type OUT NOCOPY NUMBER,
154 x_action_name OUT NOCOPY varchar2,
155 x_action_param OUT NOCOPY varchar2,
156 x_msg_name OUT NOCOPY varchar2,
157 x_msg_param OUT NOCOPY varchar2,
158 x_dialog_style OUT NOCOPY number,
159 x_msg_appl_short_name OUT NOCOPY varchar2) ;
160
161 PROCEDURE SR_HTML_UWQ_NONMEDIA_ACTIONS(
162 p_ieu_action_data IN SYSTEM.IEU_UWQ_MEDIA_DATA_NST,
163 x_action_type OUT NOCOPY NUMBER,
164 x_action_name OUT NOCOPY varchar2,
165 x_action_param OUT NOCOPY varchar2,
166 x_msg_name OUT NOCOPY varchar2,
167 x_msg_param OUT NOCOPY varchar2,
168 x_dialog_style OUT NOCOPY number,
169 x_msg_appl_short_name OUT NOCOPY varchar2) ;
170
171
172 procedure create_service_request(
173 p_api_version IN NUMBER,
174 p_init_msg_list IN VARCHAR2,
175 p_commit IN VARCHAR2,
176 x_return_status OUT NOCOPY VARCHAR2,
177 x_msg_count OUT NOCOPY NUMBER,
178 x_msg_data OUT NOCOPY VARCHAR2,
179 p_resp_appl_id IN NUMBER,
180 p_resp_id IN NUMBER,
181 p_user_id IN NUMBER,
182 p_login_id IN NUMBER,
183 p_org_id IN NUMBER,
184 p_request_id IN NUMBER,
185 p_request_number IN VARCHAR2,
186 sr_type IN VARCHAR2,
187 summary IN VARCHAR2,
188 severity_id IN VARCHAR2,
189 urgency_id IN VARCHAR2,
190 customer_id IN VARCHAR2,
191 customer_type IN VARCHAR2,
192 account_id IN VARCHAR2,
193 note_type IN VARCHAR2,
194 note IN VARCHAR2,
195 -- contact_id IN VARCHAR2,
196 -- contact_point_id IN VARCHAR2,
197 -- primary_flag IN VARCHAR2,
198 -- contact_point_type IN VARCHAR2,
199 -- contact_type IN VARCHAR2,
200 p_auto_assign IN VARCHAR2,
201 p_auto_generate_tasks IN VARCHAR2,
202 x_service_request_number OUT NOCOPY NUMBER,
203 p_default_contract_sla_ind IN VARCHAR2,
204 p_default_coverage_template_id IN NUMBER);
205
206
207 PROCEDURE Build_Solution_Text_Query(
208 p_raw_text in varchar2,
209 p_solution_type_id_tbl in varchar2,
210 p_search_option in number,
211 x_solution_text out NOCOPY varchar2);
212
213
214 FUNCTION Get_KM_Params_Str(
215 solution_num in varchar2)
216 return varchar2;
217
218 FUNCTION Get_CCT_SSO_ACTIVE_FLAG
219 return varchar2;
220
221 PROCEDURE SET_CCT_SSO_ACTIVE_FLAG(v_flag VARCHAR2);
222 CCT_SSO_ACTIVE_FLAG VARCHAR2(1) := 'N';
223
224 end sr_uwq_integ;