1 PACKAGE OKL_SSC_WF AUTHID CURRENT_USER as
2 /* $Header: OKLSSWFS.pls 120.5.12010000.2 2009/11/23 10:37:19 rpillay ship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 -- Bug#4274575 - smadhava - 28-Sep-2005 - Modified - Start
7 procedure raise_assets_update_event ( p_event_name in varchar2 ,
8 parent_line_id in varchar2,
9 requestorId in varchar2,
10 new_site_id1 in varchar2,
11 new_site_id2 in varchar2,
12 old_site_id1 in varchar2,
13 old_site_id2 in varchar2,
14 trx_date in date);
15 -- Bug#4274575 - smadhava - 28-Sep-2005 - Modified - End
16 procedure getLocationMessage (itemtype in varchar2,
17 itemkey in varchar2,
18 actid in number,
19 funcmode in varchar2,
20 resultout out nocopy varchar2 );
21
22 procedure getSerialNumMessage (itemtype in varchar2,
23 itemkey in varchar2,
24 actid in number,
25 funcmode in varchar2,
26 resultout out nocopy varchar2 );
27 procedure getAssetReturnMessage (itemtype in varchar2,
28 itemkey in varchar2,
29 actid in number,
30 funcmode in varchar2,
31 resultout out nocopy varchar2 );
32
33 procedure update_location_fnc (itemtype in varchar2,
34 itemkey in varchar2,
35 actid in number,
36 funcmode in varchar2,
37 resultout out nocopy varchar2 );
38
39 procedure update_serial_fnc (itemtype in varchar2,
40 itemkey in varchar2,
41 actid in number,
42 funcmode in varchar2,
43 resultout out nocopy varchar2 );
44
45 PROCEDURE update_serial_number( p_api_version IN NUMBER,
46 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
47 p_tas_id IN NUMBER,
48 x_return_status OUT NOCOPY VARCHAR2,
49 x_msg_count OUT NOCOPY NUMBER,
50 x_msg_data OUT NOCOPY VARCHAR2);
51
52 PROCEDURE update_location( p_api_version IN NUMBER,
53 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
54 p_tas_id IN NUMBER,
55 x_return_status OUT NOCOPY VARCHAR2,
56 x_msg_count OUT NOCOPY NUMBER,
57 x_msg_data OUT NOCOPY VARCHAR2);
58
59 PROCEDURE getAssetReturnDocument( document_id in varchar2,
60 display_type in varchar2,
61 document in out nocopy clob,
62 document_type in out nocopy varchar2);
63
64 PROCEDURE getSerialNumDocument( document_id in varchar2,
65 display_type in varchar2,
66 document in out nocopy clob,
67 document_type in out nocopy varchar2);
68
69 PROCEDURE getLocationDocument( document_id in varchar2,
70 display_type in varchar2,
71 document in out nocopy clob,
72 document_type in out nocopy varchar2);
73
74
75 procedure accept_renewal_quote(quote_id in number,
76 contract_id in number,
77 user_id in number,
78 x_return_status OUT NOCOPY VARCHAR2,
79 x_msg_count OUT NOCOPY NUMBER,
80 x_msg_data OUT NOCOPY VARCHAR2);
81
82 procedure process_renewal_quote(quote_id in number,
83 contract_id in number,
84 user_id in number,
85 status_mode in varchar2,
86 x_return_status OUT NOCOPY VARCHAR2,
87 x_msg_count OUT NOCOPY NUMBER,
88 x_msg_data OUT NOCOPY VARCHAR2);
89
90 procedure submit_third_party_ins_wrapper(provider_id in number DEFAULT null,
91 site_id in number DEFAULT null,
92 policy_number in varchar2,
93 policy_start_date in date,
94 policy_end_date in date,
95 coverage_amount in number DEFAULT null,
96 deductible in number DEFAULT null,
97 lessor_insured in varchar2 DEFAULT 'N',
98 lessor_payee in varchar2 DEFAULT 'N',
99 contract_id in number,
100 requestor_id in number,
101 provider_name in varchar2,
102 address1 in varchar2,
103 address2 in varchar2 DEFAULT null,
104 address3 in varchar2 DEFAULT null,
105 address4 in varchar2 DEFAULT null,
106 city in varchar2,
107 state in varchar2,
108 province in varchar2 DEFAULT null,
109 county in varchar2 DEFAULT null,
110 zip in varchar2,
111 country in varchar2,
112 telephone in varchar2,
113 email in varchar2);
114
115 procedure req_renewal_quote_wf (itemtype in varchar2,
116 itemkey in varchar2,
117 actid in number,
118 funcmode in varchar2,
119 resultout out nocopy varchar2 );
120
121 procedure submit_insurance_wf (itemtype in varchar2,
122 itemkey in varchar2,
123 actid in number,
124 funcmode in varchar2,
125 resultout out nocopy varchar2 );
126
127 procedure submit_ins_set_notif_wf (itemtype in varchar2,
128 itemkey in varchar2,
129 actid in number,
130 funcmode in varchar2,
131 resultout out nocopy varchar2 );
132
133 procedure set_ins_provider_wf (itemtype in varchar2,
134 itemkey in varchar2,
135 actid in number,
136 funcmode in varchar2,
137 resultout out nocopy varchar2 );
138
139 -- The record type in used for workflows that need to call Rules API.
140
141 subtype l_rule_rec_type is OKL_RGRP_RULES_PROCESS_PVT.rgr_rec_type;
142 subtype l_rule_tbl_type is OKL_RGRP_RULES_PROCESS_PVT.rgr_tbl_type;
143
144
145 PROCEDURE invoice_format_change_wf(itemtype in varchar2,
146 itemkey in varchar2,
147 actid in number,
148 funcmode in varchar2,
149 resultout out nocopy varchar2 );
150 PROCEDURE set_invoice_format_attributes (itemtype in varchar2,
151 itemkey in varchar2,
152 actid in number,
153 funcmode in varchar2,
154 resultout out nocopy varchar2 );
155
156 -- Vishal Added on 19-Sep-2002 to handle integration from EO
157 procedure raise_inv_format_chg_event ( contract_id in varchar2 ,
158 user_id in varchar2,
159 invoice_format_id in varchar2);
160
161
162 -- Vishal Added on 19-Sep-2002 to handle Billing Information Change Workflow
163 procedure req_billinf_change_getdata_wf (itemtype in varchar2,
164 itemkey in varchar2,
165 actid in number,
166 funcmode in varchar2,
167 resultout out nocopy varchar2 );
168
169 -- Vishal Added on 19-Sep-2002 to handle Billing Information Change Workflow
170 procedure req_billinf_change_wrapper_wf (itemtype in varchar2,
171 itemkey in varchar2,
172 actid in number,
173 funcmode in varchar2,
174 resultout out nocopy varchar2 );
175
176 -- Vishal Added on 20-Sep-2002 to handle integration from EO
177 procedure raise_billinf_change_event ( contract_id in varchar2 ,
178 user_id in varchar2,
179 bill_site_id in varchar2);
180
181
182
183 -- IBYON added on 20-Sep-2002 to set attributes raised from cancelinsurance event
184 PROCEDURE cancel_ins_set_attr_wf
185 (itemtype in varchar2,
186 itemkey in varchar2,
187 actid in number,
188 funcmode in varchar2,
189 resultout out nocopy varchar2 );
190
191 -- IBYON added on 20-Sep-2002 wrapper to call cancel insurance API
192 SUBTYPE ipyv_rec_type IS Okl_Ipy_Pvt.ipyv_rec_type;
193
194 PROCEDURE cancel_ins_wrapper_wf
195 (p_api_version IN NUMBER,
196 p_init_msg_list IN VARCHAR2,
197 p_polid IN number,
198 p_cancelcomment IN varchar2,
199 p_canceldate IN date,
200 p_canrsn_code IN varchar2,
201 p_userid IN NUMBER,
202 x_return_status OUT NOCOPY VARCHAR2,
203 x_msg_count OUT NOCOPY NUMBER,
204 x_msg_data OUT NOCOPY VARCHAR2
205 );
206
207
208 -- DKHANDEL added on 20-Sep-2002 to call create claim notification
209
210
211 PROCEDURE create_claim_event
212 ( p_claim_id IN NUMBER,
213 x_retrun_status OUT NOCOPY VARCHAR2
214 );
215
216 -- DKHANDEL added on 20-Sep-2002 to populate claim notification receiver
217 PROCEDURE set_claim_receiver
218 (itemtype in varchar2,
219 itemkey in varchar2,
220 actid in number,
221 funcmode in varchar2,
222 resultout out nocopy varchar2);
223
224
225 -- VAMURU added on 25-Sep-2002 to call makepayment API
226
227 PROCEDURE make_payment_wrapper_wf
228 (p_api_version IN NUMBER,
229 p_init_msg_list IN VARCHAR2,
230 p_invid IN NUMBER DEFAULT NULL,
231 p_paymentamount IN NUMBER,
232 p_paymentcurrency IN VARCHAR2,
233 p_cctype IN VARCHAR2 DEFAULT NULL,
234 p_expdate IN DATE DEFAULT NULL,
235 p_ccnum IN VARCHAR2 DEFAULT NULL,
236 p_ccname IN VARCHAR2 DEFAULT NULL,
237 p_userid IN NUMBER,
238 p_custid IN VARCHAR2 DEFAULT NULL, -- smoduga 4055222
239 x_return_status OUT NOCOPY VARCHAR2,
240 x_payment_ref_number OUT NOCOPY VARCHAR2,
241 x_msg_count OUT NOCOPY NUMBER,
242 x_msg_data OUT NOCOPY VARCHAR2,
243 p_paymentdate IN DATE,
244 p_conInv IN VARCHAR2 DEFAULT NULL,
245 -- Begin - Make payment Uptake - Varangan
246 p_customer_trx_id IN NUMBER,
247 p_customer_id IN NUMBER,
248 p_customer_site_use_id IN NUMBER,
249 p_payment_trxn_extension_id IN NUMBER,
250 x_cash_receipt_id OUT NOCOPY NUMBER
251 -- End - Make payment Uptake - Varangan
252 );
253
254 -- VAMURU added on 30-Sep-2002 to call makepayment API
255
256 PROCEDURE make_payment_set_attr_wf
257 (itemtype in varchar2,
258 itemkey in varchar2,
259 actid in number,
260 funcmode in varchar2,
261 resultout out nocopy varchar2);
262
263 -- IBYON added on 01-OCT-2002 to call validate recipient for termination quote
264 SUBTYPE qtev_rec_type IS okl_trx_quotes_pub.qtev_rec_type;
265 SUBTYPE qpyv_tbl_type IS okl_quote_parties_pub.qpyv_tbl_type;
266 SUBTYPE qpyv_rec_type IS okl_quote_parties_pub.qpyv_rec_type;
267 SUBTYPE assn_tbl_type IS OKL_AM_CREATE_QUOTE_PVT.assn_tbl_type;
268 SUBTYPE tqlv_tbl_type IS OKL_AM_CREATE_QUOTE_PVT.tqlv_tbl_type;
269
270 SUBTYPE q_party_uv_tbl_type IS okl_AM_PARTIES_PVT.q_party_uv_tbl_type;
271
272 PROCEDURE validate_recipient_term_quote
273 (p_api_version IN NUMBER,
274 p_init_msg_list IN VARCHAR2,
275 p_khrid IN number,
276 p_qrs_code IN VARCHAR2,
277 p_qtp_code IN VARCHAR2,
278 p_comments IN VARCHAR2,
279 x_vendor_flag OUT NOCOPY VARCHAR2,
280 x_lessee_flag OUT NOCOPY VARCHAR2,
281 x_cpl_id OUT NOCOPY VARCHAR2,
282 x_email_address OUT NOCOPY VARCHAR2,
283 x_return_status OUT NOCOPY VARCHAR2,
284 x_msg_count OUT NOCOPY NUMBER,
285 x_msg_data OUT NOCOPY VARCHAR2
286 );
287
288 -- IBYON added on 01-OCT-2002 to raise event for termination quote
289 PROCEDURE create_termqt_raise_event_wf
290 (p_qte_id IN NUMBER,
291 p_user_id IN VARCHAR2,
292 x_return_status OUT NOCOPY VARCHAR2,
293 x_msg_count OUT NOCOPY NUMBER,
294 x_msg_data OUT NOCOPY VARCHAR2
295 );
296
297 -- IBYON added on 01-OCT-2002 to set attributes for termination quote notification
298 PROCEDURE create_termqt_set_attr_wf
299 (itemtype in varchar2,
300 itemkey in varchar2,
301 actid in number,
302 funcmode in varchar2,
303 resultout out nocopy varchar2
304 );
305
306 -- created by viselvar for bug 4754894 for asset return
307 procedure raise_assets_return_event ( p_event_name in varchar2 ,
308 requestId in varchar2,
309 requestorId in varchar2,
310 requestType in varchar2
311 );
312
313 FUNCTION mask_cc
314 ( cc_number IN varchar2)
315 RETURN varchar2;
316
317 --Bug 6018784 start
318 procedure raise_ser_num_update_event( p_event_name in varchar2 ,
319 requestId in varchar2,
320 requestorId in varchar2,
321 requestType in varchar2
322 );
323 --Bug 6018784 end
324
325 END okl_ssc_wf;