1 PACKAGE OKL_AM_QUOTES_WF AUTHID CURRENT_USER AS
2 /* $Header: OKLRQWFS.pls 120.3 2007/11/14 23:31:45 rkuttiya ship $ */
3
4 G_EXCEPTION EXCEPTION;
5
6 --rkuttiya 16-SEP-2003 Global Variables for Bug:2974685
7 G_STOP VARCHAR2(15) := 'NONE';
8
9 PROCEDURE raise_pre_proceeds_event (
10 p_transaction_id IN VARCHAR2);
11
12 PROCEDURE raise_repurchase_quote_event (
13 p_transaction_id IN VARCHAR2);
14
15 PROCEDURE validate_quote(
16 itemtype IN VARCHAR2,
17 itemkey IN VARCHAR2,
18 actid IN NUMBER,
19 funcmode IN VARCHAR2,
20 resultout OUT NOCOPY VARCHAR2);
21
22 PROCEDURE chk_pre_proceeds_qte_partial(
23 itemtype IN VARCHAR2,
24 itemkey IN VARCHAR2,
25 actid IN NUMBER,
26 funcmode IN VARCHAR2,
27 resultout OUT NOCOPY VARCHAR2);
28
29 PROCEDURE pop_pre_proceeds_att(
30 itemtype IN VARCHAR2,
31 itemkey IN VARCHAR2,
32 actid IN NUMBER,
33 funcmode IN VARCHAR2,
34 resultout OUT NOCOPY VARCHAR2);
35
36 PROCEDURE reset_pre_proceeds_att(
37 itemtype IN VARCHAR2,
38 itemkey IN VARCHAR2,
39 actid IN NUMBER,
40 funcmode IN VARCHAR2,
41 resultout OUT NOCOPY VARCHAR2);
42
43 PROCEDURE chk_pre_proceeds_qte_approved(
44 itemtype IN VARCHAR2,
45 itemkey IN VARCHAR2,
46 actid IN NUMBER,
47 funcmode IN VARCHAR2,
48 resultout OUT NOCOPY VARCHAR2);
49
50 PROCEDURE pop_pre_proceeds_noti_att(
51 itemtype IN VARCHAR2,
52 itemkey IN VARCHAR2,
53 actid IN NUMBER,
54 funcmode IN VARCHAR2,
55 resultout OUT NOCOPY VARCHAR2);
56
57 PROCEDURE pop_pre_proceeds_app_att(
58 itemtype IN VARCHAR2,
59 itemkey IN VARCHAR2,
60 actid IN NUMBER,
61 funcmode IN VARCHAR2,
62 resultout OUT NOCOPY VARCHAR2);
63
64 PROCEDURE pop_pre_proceeds_doc_att(
65 itemtype IN VARCHAR2,
66 itemkey IN VARCHAR2,
67 actid IN NUMBER,
68 funcmode IN VARCHAR2,
69 resultout OUT NOCOPY VARCHAR2);
70
71 PROCEDURE pre_proceeds_trmnt_contract(
72 itemtype IN VARCHAR2,
73 itemkey IN VARCHAR2,
74 actid IN NUMBER,
75 funcmode IN VARCHAR2,
76 resultout OUT NOCOPY VARCHAR2);
77
78 PROCEDURE chk_pre_proceeds_serv_maint(
79 itemtype IN VARCHAR2,
80 itemkey IN VARCHAR2,
81 actid IN NUMBER,
82 funcmode IN VARCHAR2,
83 resultout OUT NOCOPY VARCHAR2);
84
85 PROCEDURE pop_pre_proceeds_serv_maint(
86 itemtype IN VARCHAR2,
87 itemkey IN VARCHAR2,
88 actid IN NUMBER,
89 funcmode IN VARCHAR2,
90 resultout OUT NOCOPY VARCHAR2);
91
92 PROCEDURE chk_pre_proceeds_serv_noti(
93 itemtype IN VARCHAR2,
94 itemkey IN VARCHAR2,
95 actid IN NUMBER,
96 funcmode IN VARCHAR2,
97 resultout OUT NOCOPY VARCHAR2);
98
99 PROCEDURE chk_pre_proceeds_bill_of_sale(
100 itemtype IN VARCHAR2,
101 itemkey IN VARCHAR2,
102 actid IN NUMBER,
103 funcmode IN VARCHAR2,
104 resultout OUT NOCOPY VARCHAR2);
105
106 PROCEDURE pop_pre_proceeds_bill_of_sale(
107 itemtype IN VARCHAR2,
108 itemkey IN VARCHAR2,
109 actid IN NUMBER,
110 funcmode IN VARCHAR2,
111 resultout OUT NOCOPY VARCHAR2);
112
113 PROCEDURE chk_pre_proceeds_bill_noti(
114 itemtype IN VARCHAR2,
115 itemkey IN VARCHAR2,
116 actid IN NUMBER,
117 funcmode IN VARCHAR2,
118 resultout OUT NOCOPY VARCHAR2);
119
120 PROCEDURE chk_pre_proceeds_title_filing(
121 itemtype IN VARCHAR2,
122 itemkey IN VARCHAR2,
123 actid IN NUMBER,
124 funcmode IN VARCHAR2,
125 resultout OUT NOCOPY VARCHAR2);
126
127 PROCEDURE pop_pre_proceeds_title_filing(
128 itemtype IN VARCHAR2,
129 itemkey IN VARCHAR2,
130 actid IN NUMBER,
131 funcmode IN VARCHAR2,
132 resultout OUT NOCOPY VARCHAR2);
133
134 PROCEDURE chk_pre_proceeds_title_noti(
135 itemtype IN VARCHAR2,
136 itemkey IN VARCHAR2,
137 actid IN NUMBER,
138 funcmode IN VARCHAR2,
139 resultout OUT NOCOPY VARCHAR2);
140
141 PROCEDURE pop_repurchase_qte_att(
142 itemtype IN VARCHAR2,
143 itemkey IN VARCHAR2,
144 actid IN NUMBER,
145 funcmode IN VARCHAR2,
146 resultout OUT NOCOPY VARCHAR2);
147
148 PROCEDURE repurchase_qte_asset_dispose(
149 itemtype IN VARCHAR2,
150 itemkey IN VARCHAR2,
151 actid IN NUMBER,
152 funcmode IN VARCHAR2,
153 resultout OUT NOCOPY VARCHAR2);
154
155 PROCEDURE update_asset_return_status(
156 itemtype IN VARCHAR2,
157 itemkey IN VARCHAR2,
158 actid IN NUMBER,
159 funcmode IN VARCHAR2,
160 resultout OUT NOCOPY VARCHAR2);
161
162 PROCEDURE create_invoice(
163 itemtype IN VARCHAR2,
164 itemkey IN VARCHAR2,
165 actid IN NUMBER,
166 funcmode IN VARCHAR2,
167 resultout OUT NOCOPY VARCHAR2);
168
169 PROCEDURE update_quote_status(
170 itemtype IN VARCHAR2,
171 itemkey IN VARCHAR2,
172 actid IN NUMBER,
173 funcmode IN VARCHAR2,
174 resultout OUT NOCOPY VARCHAR2);
175
176 PROCEDURE pop_partial_quote_att(
177 itemtype IN VARCHAR2,
178 itemkey IN VARCHAR2,
179 actid IN NUMBER,
180 funcmode IN VARCHAR2,
181 resultout OUT NOCOPY VARCHAR2);
182
183 PROCEDURE set_quote_approved_yn(
184 itemtype IN VARCHAR2,
185 itemkey IN VARCHAR2,
186 actid IN NUMBER,
187 funcmode IN VARCHAR2,
188 resultout OUT NOCOPY VARCHAR2);
189
190 PROCEDURE pop_gl_quote_att(
191 itemtype IN VARCHAR2,
192 itemkey IN VARCHAR2,
193 actid IN NUMBER,
194 funcmode IN VARCHAR2,
195 resultout OUT NOCOPY VARCHAR2);
196
197 PROCEDURE validate_quote_approval(
198 itemtype IN VARCHAR2,
199 itemkey IN VARCHAR2,
200 actid IN NUMBER,
201 funcmode IN VARCHAR2,
202 resultout OUT NOCOPY VARCHAR2);
203
204 PROCEDURE pop_cp_quote_att(
205 itemtype IN VARCHAR2,
206 itemkey IN VARCHAR2,
207 actid IN NUMBER,
208 funcmode IN VARCHAR2,
209 resultout OUT NOCOPY VARCHAR2);
210
211 PROCEDURE CHECK_IF_PARTIAL_QUOTE(
212 itemtype IN VARCHAR2,
213 itemkey IN VARCHAR2,
214 actid IN NUMBER,
215 funcmode IN VARCHAR2,
216 resultout OUT NOCOPY VARCHAR2);
217
218 PROCEDURE CHECK_IF_QUOTE_GAIN_LOSS(
219 itemtype IN VARCHAR2,
220 itemkey IN VARCHAR2,
221 actid IN NUMBER,
222 funcmode IN VARCHAR2,
223 resultout OUT NOCOPY VARCHAR2);
224
225 PROCEDURE CHECK_FOR_EXT_APPROVAL(
226 itemtype IN VARCHAR2,
227 itemkey IN VARCHAR2,
228 actid IN NUMBER,
229 funcmode IN VARCHAR2,
230 resultout OUT NOCOPY VARCHAR2);
231
232 PROCEDURE CHECK_FOR_ADVANCE_NOTICE(
233 itemtype IN VARCHAR2,
234 itemkey IN VARCHAR2,
235 actid IN NUMBER,
236 funcmode IN VARCHAR2,
237 resultout OUT NOCOPY VARCHAR2);
238
239 PROCEDURE CHECK_FOR_FYI(
240 itemtype IN VARCHAR2,
241 itemkey IN VARCHAR2,
242 actid IN NUMBER,
243 funcmode IN VARCHAR2,
244 resultout OUT NOCOPY VARCHAR2);
245
246 PROCEDURE CHECK_FOR_RECIPIENT(
247 itemtype IN VARCHAR2,
248 itemkey IN VARCHAR2,
249 actid IN NUMBER,
250 funcmode IN VARCHAR2,
251 resultout OUT NOCOPY VARCHAR2);
252
253 PROCEDURE CHECK_FOR_RECIPIENT_ADD(
254 itemtype IN VARCHAR2,
255 itemkey IN VARCHAR2,
256 actid IN NUMBER,
257 funcmode IN VARCHAR2,
258 resultout OUT NOCOPY VARCHAR2);
259
260 PROCEDURE GET_QUOTE_PARTY_DETAILS(
261 itemtype IN VARCHAR2,
262 itemkey IN VARCHAR2,
263 actid IN NUMBER,
264 funcmode IN VARCHAR2,
265 resultout OUT NOCOPY VARCHAR2);
266 /*
267
268 FUNCTION CHECK_CALC_OPTIONS(itemtype IN VARCHAR2,
269 itemkey IN VARCHAR2,
270 actid IN NUMBER,
271 funcmode IN VARCHAR2,
272 p_rgd_code IN VARCHAR2,
273 p_khr_id IN NUMBER)
274 RETURN VARCHAR2;*/
275
276 FUNCTION CHECK_CALC_OPTIONS(itemtype IN VARCHAR2,
277 itemkey IN VARCHAR2,
278 actid IN NUMBER,
279 funcmode IN VARCHAR2,
280 p_rgd_code IN VARCHAR2,
281 p_khr_id IN NUMBER,
282 p_qte_id IN NUMBER )--rkuttiya 22-SEP-2003 added for bug2794685
283 RETURN VARCHAR2;
284
285 PROCEDURE VALIDATE_MANUAL_QUOTE_REQ(
286 itemtype IN VARCHAR2,
287 itemkey IN VARCHAR2,
288 actid IN NUMBER,
289 funcmode IN VARCHAR2,
290 resultout OUT NOCOPY VARCHAR2);
291
292 PROCEDURE VALIDATE_ACCEPT_REST_QTE(
293 itemtype IN VARCHAR2,
294 itemkey IN VARCHAR2,
295 actid IN NUMBER,
296 funcmode IN VARCHAR2,
297 resultout OUT NOCOPY VARCHAR2);
298
299 PROCEDURE set_rest_qte_approved_yn(
300 itemtype IN VARCHAR2,
301 itemkey IN VARCHAR2,
302 actid IN NUMBER,
303 funcmode IN VARCHAR2,
304 resultout OUT NOCOPY VARCHAR2);
305
306 PROCEDURE check_profile_recipient(
307 itemtype IN VARCHAR2,
311 resultout OUT NOCOPY VARCHAR2);
308 itemkey IN VARCHAR2,
309 actid IN NUMBER,
310 funcmode IN VARCHAR2,
312
313 PROCEDURE pop_oklamnmq_doc (document_id in varchar2,
314 display_type in varchar2 default 'text/html',
315 document in out nocopy varchar2,
316 document_type in out nocopy varchar2);
317
318 PROCEDURE pop_oklamppt_doc (document_id in varchar2,
319 display_type in varchar2 default 'text/html',
320 document in out nocopy varchar2,
321 document_type in out nocopy varchar2);
322
323 PROCEDURE pop_external_approver_doc (document_id in varchar2,
324 display_type in varchar2 default 'text/html',
325 document in out nocopy varchar2,
326 document_type in out nocopy varchar2);
327
328 PROCEDURE update_partial_quote(
329 itemtype IN VARCHAR2,
330 itemkey IN VARCHAR2,
331 actid IN NUMBER,
332 funcmode IN VARCHAR2,
333 resultout OUT NOCOPY VARCHAR2);
334
335 PROCEDURE update_gain_loss_quote(
336 itemtype IN VARCHAR2,
337 itemkey IN VARCHAR2,
338 actid IN NUMBER,
339 funcmode IN VARCHAR2,
340 resultout OUT NOCOPY VARCHAR2);
341
342 PROCEDURE chk_securitization(
343 itemtype IN VARCHAR2,
344 itemkey IN VARCHAR2,
345 actid IN NUMBER,
346 funcmode IN VARCHAR2,
347 resultout OUT NOCOPY VARCHAR2);
348
349 --rkuttiya 22-SEP-2003 Bug:2794685
350 PROCEDURE pop_stop_notification (document_id in varchar2,
351 display_type in varchar2,
352 document in out nocopy varchar2,
353 document_type in out nocopy varchar2) ;
354
355 --rkuttiya 29-SEP-2003 Bug: 2794685
356 PROCEDURE update_quote_drafted(itemtype IN VARCHAR2,
357 itemkey IN VARCHAR2,
358 actid IN NUMBER,
359 funcmode IN VARCHAR2,
360 resultout OUT NOCOPY VARCHAR2);
361
362 -- rmunjulu 4131592 Added
363 PROCEDURE check_rollover_amount(
364 itemtype IN VARCHAR2,
365 itemkey IN VARCHAR2,
366 actid IN NUMBER,
367 funcmode IN VARCHAR2,
368 resultout OUT NOCOPY VARCHAR2);
369
370 -- rmunjulu 4131592 Added
371 PROCEDURE pop_roll_notification (document_id IN VARCHAR2,
372 display_type IN VARCHAR2,
373 document IN OUT NOCOPY VARCHAR2,
374 document_type IN OUT NOCOPY VARCHAR2) ;
375 --rkuttiya 12-Nov-2007 added for Loan Repossession Sprint 2
376 PROCEDURE check_if_repo_quote(itemtype IN VARCHAR2,
377 itemkey IN VARCHAR2,
378 actid IN NUMBER,
379 funcmode IN VARCHAR2,
380 resultout OUT NOCOPY VARCHAR2);
381
382 PROCEDURE create_repo_asset_return(itemtype IN VARCHAR2,
383 itemkey IN VARCHAR2,
384 actid IN NUMBER,
385 funcmode IN VARCHAR2,
386 resultout OUT NOCOPY VARCHAR2);
387
388
389 END OKL_AM_QUOTES_WF;