1 PACKAGE SR_UWQ_INTEG AS
2 /* $Header: cssruwqs.pls 120.0 2005/09/29 00:46:52 prayadur noship $ */
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 procedure enumerate_sr_nodes
35 (p_resource_id in number,
36 p_language in varchar2,
37 p_source_lang in varchar2,
38 p_sel_enum_id in number );
39
40 procedure refresh_sr_nodes
41 (p_resource_id in number,
42 p_node_id in number,
43 p_count out NOCOPY number);
44
45 procedure insert_row(
46 p_node_id in number default -1,
47 p_node_view in varchar2,
48 p_node_label in varchar2,
49 p_data_source in varchar2,
50 p_media_type_id in number,
51 p_where_clause in varchar2,
52 p_res_cat_enum_flag in varchar2,
53 p_node_type in varchar2,
54 p_hide_if_empty in varchar2,
55 p_node_depth in number,
56 p_parent_id in number,
57 p_node_query in varchar2,
58 p_cursor_sql in varchar2,
59 p_cursor_key_col in varchar2,
60 p_enabled_flag in varchar2,
61 p_creation_date in date,
62 p_created_by in number,
63 p_last_update_date in date,
64 p_last_updated_by in number,
65 p_last_update_login in number,
66 x_node_id out NOCOPY number,
67 x_return_status out NOCOPY varchar2);
68
69 procedure update_row(
70 p_node_id in number,
71 p_object_version_number in number,
72 p_node_view in varchar2,
73 p_node_label in varchar2,
74 p_data_source in varchar2,
75 p_media_type_id in number,
76 p_where_clause in varchar2,
77 p_res_cat_enum_flag in varchar2,
78 p_node_type in varchar2,
79 p_hide_if_empty in varchar2,
80 p_node_depth in number,
81 p_parent_id in number,
82 p_node_query in varchar2,
83 p_cursor_sql in varchar2,
84 p_cursor_key_col in varchar2,
85 p_enabled_flag in varchar2,
86 p_creation_date in date,
87 p_created_by in number,
88 p_last_update_date in date,
89 p_last_updated_by in number,
90 p_last_update_login in number,
91 x_return_status out NOCOPY varchar2);
92
93 procedure validate_ivr_parameter(
94 p_parameter_code in out NOCOPY varchar2,
95 p_parameter_value in out NOCOPY varchar2,
96 p_parameter_mesg in out NOCOPY varchar2,
97 p_param_action_val in out NOCOPY varchar2,
98 x_parameter_id out NOCOPY number,
99 x_parameter_flag out NOCOPY varchar2,
100 x_customer_id out NOCOPY number,
101 x_customer_type out NOCOPY varchar2,
102 x_return_status out NOCOPY varchar2);
103
104 procedure interpret_service_keys(
105 v_service_key in varchar2,
106 v_service_key_value in out NOCOPY varchar2,
107 p_cust_id in number,
108 p_cust_account_id in number,
109 p_phone_id in number,
110 x_parameter_code out NOCOPY varchar2,
111 x_return_status out NOCOPY varchar2);
112
113
114 procedure validate_security(
115 p_ivr_data_key in varchar2,
116 p_ivr_data_value in varchar2,
117 p_table_of_agents in out NOCOPY system.CCT_AGENT_RESP_APP_ID_NST,
118 x_return_status out NOCOPY varchar2);
119
120 procedure start_media_item( p_resp_appl_id in number,
121 p_resp_id in number,
122 p_user_id in number,
123 p_login_id in number,
124 x_return_status out nocopy varchar2,
125 x_msg_count out nocopy number,
126 x_msg_data out nocopy varchar2,
127 x_media_id out nocopy number);
128
129
130 PROCEDURE SR_UWQ_NONMEDIA_ACTIONS(
131 p_ieu_action_data IN SYSTEM.IEU_UWQ_MEDIA_DATA_NST,
132 x_action_type OUT NOCOPY NUMBER,
133 x_action_name OUT NOCOPY varchar2,
134 x_action_param OUT NOCOPY varchar2,
135 x_msg_name OUT NOCOPY varchar2,
136 x_msg_param OUT NOCOPY varchar2,
137 x_dialog_style OUT NOCOPY number,
138 x_msg_appl_short_name OUT NOCOPY varchar2) ;
139
140
141 procedure create_service_request(
142 p_api_version IN NUMBER,
143 p_init_msg_list IN VARCHAR2,
144 p_commit IN VARCHAR2,
145 x_return_status OUT NOCOPY VARCHAR2,
146 x_msg_count OUT NOCOPY NUMBER,
147 x_msg_data OUT NOCOPY VARCHAR2,
148 p_resp_appl_id IN NUMBER,
149 p_resp_id IN NUMBER,
150 p_user_id IN NUMBER,
151 p_login_id IN NUMBER,
152 p_org_id IN NUMBER,
153 p_request_id IN NUMBER,
154 p_request_number IN VARCHAR2,
155 sr_type IN VARCHAR2,
156 summary IN VARCHAR2,
157 severity_id IN VARCHAR2,
158 urgency_id IN VARCHAR2,
159 customer_id IN VARCHAR2,
160 customer_type IN VARCHAR2,
161 account_id IN VARCHAR2,
162 note_type IN VARCHAR2,
163 note IN VARCHAR2,
164 -- contact_id IN VARCHAR2,
165 -- contact_point_id IN VARCHAR2,
166 -- primary_flag IN VARCHAR2,
167 -- contact_point_type IN VARCHAR2,
168 -- contact_type IN VARCHAR2,
169 p_auto_assign IN VARCHAR2,
170 p_auto_generate_tasks IN VARCHAR2,
171 x_service_request_number OUT NOCOPY NUMBER,
172 p_default_contract_sla_ind IN VARCHAR2,
173 p_default_coverage_template_id IN NUMBER);
174
175
176 PROCEDURE Build_Solution_Text_Query(
177 p_raw_text in varchar2,
178 p_solution_type_id_tbl in varchar2,
179 p_search_option in number,
180 x_solution_text out NOCOPY varchar2);
181
182
183 FUNCTION Get_KM_Params_Str(
184 solution_num in varchar2)
185 return varchar2;
186
187
188 end sr_uwq_integ;