[Home] [Help]
PACKAGE: APPS.OKL_CS_WF
Source
1 PACKAGE OKL_CS_WF AUTHID CURRENT_USER AS
2 /* $Header: OKLRCSWS.pls 120.3 2005/10/30 04:33:08 appldev noship $ */
3
4 TYPE inv_days_rec_type IS RECORD (
5 consolidated_invoice_number okl_cnsld_ar_hdrs_b.consolidated_invoice_number%TYPE,
6 days NUMBER,
7 amount_due_remaining ar_payment_schedules_all.amount_due_remaining%TYPE,
8 khr_id okc_k_headers_b.id%TYPE);
9
10
11 TYPE inv_days_tbl_type IS TABLE OF inv_days_rec_type INDEX BY BINARY_INTEGER;
12
13 TYPE product_rec_type IS RECORD (
14 product_id okl_products.id%TYPE,
15 product_name okl_products.name%TYPE,
16 product_description okl_products.description%TYPE);
17
18 TYPE address_rec_type IS RECORD (
19 address1 okx_cust_site_uses_v.address1%TYPE,
20 address2 okx_cust_site_uses_v.address2%TYPE,
21 address3 okx_cust_site_uses_v.address3%TYPE,
22 address4 okx_cust_site_uses_v.address4%TYPE,
23 city okx_cust_site_uses_v.city%TYPE,
24 postal_code okx_cust_site_uses_v.postal_code%TYPE,
25 state okx_cust_site_uses_v.state%TYPE,
26 province okx_cust_site_uses_v.province%TYPE,
27 county okx_cust_site_uses_v.county%TYPE,
28 country okx_cust_site_uses_v.country%TYPE,
29 description okx_cust_site_uses_v.description%TYPE);
30
31 ---------------------------------------------------------------------------
32 -- GLOBAL MESSAGE CONSTANTS
33 ---------------------------------------------------------------------------
34 G_FND_APP CONSTANT VARCHAR2(200) := okl_api.G_FND_APP;
35 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := 'OKL_REQUIRED_VALUE';
36 G_INVALID_VALUE CONSTANT VARCHAR2(200) := okl_api.G_INVALID_VALUE;
37 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := 'COL_NAME';
38 G_COL_NAME1_TOKEN CONSTANT VARCHAR2(200) := 'COL_NAME1';
39 G_COL_NAME2_TOKEN CONSTANT VARCHAR2(200) := 'COL_NAME2';
40 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := 'PARENT_TABLE';
41 G_ERROR CONSTANT VARCHAR2(200) := 'OKL_ERROR';
42 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_UNEXPECTED_ERROR';
43 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLERRM';
44 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLCODE';
45 ---------------------------------------------------------------------------
46 -- GLOBAL VARIABLES
47 ---------------------------------------------------------------------------
48 G_PKG_NAME CONSTANT VARCHAR2(200) := 'call_center_integration';
49 G_APP_NAME CONSTANT VARCHAR2(3) := 'OKL';
50
51 ---------------------------------------------------------------------------
52 -- GLOBAL EXCEPTION
53 ---------------------------------------------------------------------------
54 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
55 G_EXCEPTION EXCEPTION;
56
57
58 PROCEDURE raise_equipment_exchange_event ( p_tas_id IN NUMBER);
59
60 procedure exchange_equipment (itemtype in varchar2,
61 itemkey in varchar2,
62 actid in number,
63 funcmode in varchar2,
64 resultout out nocopy varchar2 );
65 procedure check_for_request ( itemtype in varchar2,
66 itemkey in varchar2,
67 actid in number,
68 funcmode in varchar2,
69 resultout out nocopy varchar2 );
70 PROCEDURE check_exchange_type ( itemtype in varchar2,
71 itemkey in varchar2,
72 actid in number,
73 funcmode in varchar2,
74 resultout out nocopy varchar2);
75 PROCEDURE check_temp_exchange ( itemtype in varchar2,
76 itemkey in varchar2,
77 actid in number,
78 funcmode in varchar2,
79 resultout out nocopy varchar2);
80
81
82 --Transfer and Assumption WF Subprograms
83
84 PROCEDURE Raise_TransferAsu_Event(p_trx_id IN NUMBER);
85 PROCEDURE Populate_TandA_attributes(itemtype in varchar2,
86 itemkey in varchar2,
87 actid in number,
88 funcmode in varchar2,
89 resultout out nocopy varchar2);
90
91 Procedure Send_Cust_Fulfill(itemtype in varchar2,
92 itemkey in varchar2,
93 actid in number,
94 funcmode in varchar2,
95 resultout out nocopy varchar2);
96
97 Procedure Send_Vendor_Fulfill(itemtype in varchar2,
98 itemkey in varchar2,
99 actid in number,
100 funcmode in varchar2,
101 resultout out nocopy varchar2);
102
103 Procedure Approve_Request(itemtype in varchar2,
104 itemkey in varchar2,
105 actid in number,
106 funcmode in varchar2,
107 resultout out nocopy varchar2);
108 PROCEDURE Update_Request_Internal( itemtype in varchar2,
109 itemkey in varchar2,
110 actid in number,
111 funcmode in varchar2,
112 resultout out nocopy varchar2);
113 PROCEDURE Customer_Post( itemtype in varchar2,
114 itemkey in varchar2,
115 actid in number,
116 funcmode in varchar2,
117 resultout out nocopy varchar2);
118 PROCEDURE Vendor_Post( itemtype in varchar2,
119 itemkey in varchar2,
120 actid in number,
121 funcmode in varchar2,
122 resultout out nocopy varchar2);
123
124 Procedure Check_Vendor_Pgm(itemtype in varchar2,
125 itemkey in varchar2,
126 actid in number,
127 funcmode in varchar2,
128 resultout out nocopy varchar2);
129
130 Procedure Check_Cust_Delinquency(itemtype in varchar2,
131 itemkey in varchar2,
132 actid in number,
133 funcmode in varchar2,
134 resultout out nocopy varchar2);
135
136 Procedure Apply_Service_Fees(itemtype in varchar2,
137 itemkey in varchar2,
138 actid in number,
139 funcmode in varchar2,
140 resultout out nocopy varchar2);
141
142
143 Procedure Credit_post(itemtype in varchar2,
144 itemkey in varchar2,
145 actid in number,
146 funcmode in varchar2,
147 resultout out nocopy varchar2);
148
149 Procedure Collections_post(itemtype in varchar2,
150 itemkey in varchar2,
151 actid in number,
152 funcmode in varchar2,
153 resultout out nocopy varchar2);
154
155 --Call Center integration utility APIs
156
157 PROCEDURE days_cust_balance_overdue ( itemtype in varchar2,
158 itemkey in varchar2,
159 actid in number,
160 funcmode in varchar2,
161 resultout out nocopy varchar2);
162
163 PROCEDURE get_contract_balance ( itemtype in varchar2,
164 itemkey in varchar2,
165 actid in number,
166 funcmode in varchar2,
167 resultout out nocopy varchar2);
168
169 PROCEDURE get_customer_balance ( itemtype in varchar2,
170 itemkey in varchar2,
171 actid in number,
172 funcmode in varchar2,
173 resultout out nocopy varchar2);
174 PROCEDURE get_product ( itemtype in varchar2,
175 itemkey in varchar2,
176 actid in number,
177 funcmode in varchar2,
178 resultout out nocopy varchar2);
179
180 PROCEDURE get_bill_to_address ( itemtype in varchar2,
181 itemkey in varchar2,
182 actid in number,
183 funcmode in varchar2,
184 resultout out nocopy varchar2);
185
186 ---------------------------------------------------------------
187 -- The following APIS are utility APIs for getting information
188 -- for a contract.
189 ---------------------------------------------------------------
190
191 PROCEDURE days_cust_balance_overdue
192 (p_contract_id IN NUMBER
193 ,x_inv_days_tbl OUT NOCOPY inv_days_tbl_type
194 ,x_return_status OUT NOCOPY VARCHAR2);
195
196 PROCEDURE get_contract_balance (
197 p_contract_id IN NUMBER,
198 x_outstanding_balance OUT NOCOPY NUMBER,
199 x_return_status OUT NOCOPY VARCHAR2);
200
201 PROCEDURE get_customer_balance (
202 p_cust_account_id IN NUMBER,
203 x_outstanding_balance OUT NOCOPY NUMBER,
204 x_return_status OUT NOCOPY VARCHAR2);
205
206 PROCEDURE get_product (
207 p_contract_id IN NUMBER,
208 x_product_rec OUT NOCOPY product_rec_type,
209 x_return_status OUT NOCOPY VARCHAR2);
210
211 PROCEDURE get_bill_to_address (
212 p_contract_id IN NUMBER,
213 x_address_rec OUT NOCOPY address_rec_type,
214 x_return_status OUT NOCOPY VARCHAR2);
215
216
217
218 --Lease Renewal Work flow APIs
219
220 PROCEDURE raise_lease_renewal_event(p_request_id IN NUMBER);
221
222 PROCEDURE populate_lease_renew_attrib(itemtype in varchar2,
223 itemkey in varchar2,
224 actid in number,
225 funcmode in varchar2,
226 resultout out nocopy varchar2);
227
228 PROCEDURE approve_lease_renewal ( itemtype in varchar2,
229 itemkey in varchar2,
230 actid in number,
231 funcmode in varchar2,
232 resultout out nocopy varchar2);
233
234 PROCEDURE post_notify_lease_renewal(itemtype in varchar2,
235 itemkey in varchar2,
236 actid in number,
237 funcmode in varchar2,
238 resultout out nocopy varchar2);
239
240 PROCEDURE post_reject_lease_renewal(itemtype in varchar2,
241 itemkey in varchar2,
242 actid in number,
243 funcmode in varchar2,
244 resultout out nocopy varchar2);
245 --Principal Paydown Work flow APIs
246
247 PROCEDURE raise_principal_paydown_event(p_request_id IN NUMBER);
248
249 PROCEDURE populate_ppd_attrib(itemtype in varchar2,
250 itemkey in varchar2,
251 actid in number,
252 funcmode in varchar2,
253 resultout out nocopy varchar2);
254
255 PROCEDURE post_notify_ppd(itemtype in varchar2,
256 itemkey in varchar2,
257 actid in number,
258 funcmode in varchar2,
259 resultout out nocopy varchar2);
260
261 --Added the following APIs as part of 11.5.10+
262 PROCEDURE invoice_bill_apply(itemtype in varchar2,
263 itemkey in varchar2,
264 actid in number,
265 funcmode in varchar2,
266 resultout out nocopy varchar2);
267
268 PROCEDURE update_ppd_processed_status(itemtype in varchar2,
269 itemkey in varchar2,
270 actid in number,
271 funcmode in varchar2,
272 resultout out nocopy varchar2);
273
274
275 --Issue Credit Memo Work flow APIs
276
277 PROCEDURE raise_credit_memo_event(p_request_id IN NUMBER);
278
279 PROCEDURE populate_credit_memo_attribs(itemtype in varchar2,
280 itemkey in varchar2,
281 actid in number,
282 funcmode in varchar2,
283 resultout out nocopy varchar2);
284
285 PROCEDURE create_credit_memo_invoice(itemtype in varchar2,
286 itemkey in varchar2,
287 actid in number,
288 funcmode in varchar2,
289 resultout out nocopy varchar2);
290
291 PROCEDURE update_crm_approved_status(itemtype in varchar2,
292 itemkey in varchar2,
293 actid in number,
294 funcmode in varchar2,
295 resultout out nocopy varchar2);
296
297 PROCEDURE update_crm_rejected_status(itemtype in varchar2,
298 itemkey in varchar2,
299 actid in number,
300 funcmode in varchar2,
301 resultout out nocopy varchar2);
302
303 PROCEDURE update_crm_success_status(itemtype in varchar2,
304 itemkey in varchar2,
305 actid in number,
306 funcmode in varchar2,
307 resultout out nocopy varchar2);
308
309 PROCEDURE update_crm_error_status(itemtype in varchar2,
310 itemkey in varchar2,
311 actid in number,
312 funcmode in varchar2,
313 resultout out nocopy varchar2);
314
315
316 END OKL_CS_WF;