[Home] [Help]
PACKAGE: APPS.OKL_INS_QUOTE_PUB
Source
1 PACKAGE OKL_INS_QUOTE_PUB AUTHID CURRENT_USER AS
2 /* $Header: OKLPINQS.pls 120.8 2008/02/29 10:49:58 nikshah ship $ */
3 /*#
4 * Insurance Quote API creates insurance quotes and policies for a contract.
5 * @rep:scope public
6 * @rep:product OKL
7 * @rep:displayname Insurance Quote
8 * @rep:category BUSINESS_ENTITY OKL_RISK_MANAGEMENT
9 * @rep:lifecycle active
10 * @rep:compatibility S
11 */
12
13 SUBTYPE ipyv_rec_type IS Okl_Ipy_Pvt.ipyv_rec_type;
14 SUBTYPE iasset_tbl_type IS Okl_Ins_Quote_Pvt.iasset_tbl_type;
15
16 ---------------------------------------------------------------------------
17 -- GLOBAL VARIABLES
18 ---------------------------------------------------------------------------
19 G_PKG_NAME CONSTANT VARCHAR2(200) := 'Okl_Ins_Quote_Pub';
20 G_APP_NAME CONSTANT VARCHAR2(3) := 'OKL';
21 G_API_TYPE CONSTANT VARCHAR2(30) := '_PUB';
22
23 ---------------------------------------------------------------------------
24 -- GLOBAL EXCEPTION
25 ---------------------------------------------------------------------------
26 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
27 ---------------------------------------------------------------------------
28
29 /*#
30 * Insurance Quote API creates an optional or lease insurance for a contract.
31 * @param p_api_version API version
32 * @param p_init_msg_list Initialize message stack
33 * @param x_return_status Return status from the API
34 * @param x_msg_count Message count if error messages are encountered
35 * @param x_msg_data Message data error message
36 * @param px_ipyv_rec Record type of quote details
37 * @param x_message Stage of process
38 * @rep:displayname Create Insurance Quote
39 * @rep:scope public
40 * @rep:lifecycle active
41 */
42 PROCEDURE save_quote(
43 p_api_version IN NUMBER,
44 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
45 x_return_status OUT NOCOPY VARCHAR2,
46 x_msg_count OUT NOCOPY NUMBER,
47 x_msg_data OUT NOCOPY VARCHAR2,
48 px_ipyv_rec IN OUT NOCOPY ipyv_rec_type,
49 x_message OUT NOCOPY VARCHAR2 );
50 -- Need to have second procedure
51 -- so that we don't need to recalculate
52
53 PROCEDURE save_accept_quote(
54 p_api_version IN NUMBER,
55 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
56 x_return_status OUT NOCOPY VARCHAR2,
57 x_msg_count OUT NOCOPY NUMBER,
58 x_msg_data OUT NOCOPY VARCHAR2,
59 p_ipyv_rec IN ipyv_rec_type,
60 x_message OUT NOCOPY VARCHAR2 );
61
62 -- Need to have second procedure
63 -- so that we don't need to recalculate
64
65 /*#
66 * Insurance Quote API accepts lease or optional quote and creates policy.
67 * @param p_api_version API version
68 * @param p_init_msg_list Initialize message stack
69 * @param x_return_status Return status from the API
70 * @param x_msg_count Message count if error messages are encountered
71 * @param x_msg_data Message data error message
72 * @param p_quote_id Insurance quote identifier
73 * @rep:displayname Accept Insurance Quote
74 * @rep:scope public
75 * @rep:lifecycle active
76 */
77 PROCEDURE accept_quote(
78 p_api_version IN NUMBER,
79 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
80 x_return_status OUT NOCOPY VARCHAR2,
81 x_msg_count OUT NOCOPY NUMBER,
82 x_msg_data OUT NOCOPY VARCHAR2,
83 p_quote_id IN NUMBER );
84
85
86 PROCEDURE create_ins_streams(
87 p_api_version IN NUMBER,
88 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
89 x_return_status OUT NOCOPY VARCHAR2,
90 x_msg_count OUT NOCOPY NUMBER,
91 x_msg_data OUT NOCOPY VARCHAR2,
92 p_ipyv_rec IN ipyv_rec_type
93 );
94
95 /*#
96 * Insurance Quote API calculates the premium for lease insurance.
97 * @param p_api_version API version
98 * @param p_init_msg_list Initialize message stack
99 * @param x_return_status Return status from the API
100 * @param x_msg_count Message count if error messages are encountered
101 * @param x_msg_data Message data error message
102 * @param px_ipyv_rec Record type of quote details
103 * @param x_message Stage of process
104 * @param x_iasset_tbl Premium for each contract financial line
105 * @rep:displayname Calculate Lease Insurance Premium
106 * @rep:scope public
107 * @rep:lifecycle active
108 */
109 PROCEDURE calc_lease_premium(
110 p_api_version IN NUMBER,
111 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
112 x_return_status OUT NOCOPY VARCHAR2,
113 x_msg_count OUT NOCOPY NUMBER,
114 x_msg_data OUT NOCOPY VARCHAR2,
115 px_ipyv_rec IN OUT NOCOPY ipyv_rec_type,
116 x_message OUT NOCOPY VARCHAR2,
117 x_iasset_tbl OUT NOCOPY iasset_tbl_type
118 );
119 /*#
120 * Insurance Quote API calculates the premium for optional insurance.
121 * @param p_api_version API version
122 * @param p_init_msg_list Initialize message stack
123 * @param x_return_status Return status from the API
124 * @param x_msg_count Message count if error messages are encountered
125 * @param x_msg_data Message data error message
126 * @param p_ipyv_rec Record type of quote details
127 * @param x_message Stage of process.
128 * @param x_ipyv_rec Record type of quote details with calculated premium
129 * @rep:displayname Calculate Optional Insurance Premium
130 * @rep:scope public
131 * @rep:lifecycle active
132 */
133 PROCEDURE calc_optional_premium(
134 p_api_version IN NUMBER,
135 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
136 x_return_status OUT NOCOPY VARCHAR2,
137 x_msg_count OUT NOCOPY NUMBER,
138 x_msg_data OUT NOCOPY VARCHAR2,
139 p_ipyv_rec IN ipyv_rec_type,
140 x_message OUT NOCOPY VARCHAR2,
141 x_ipyv_rec OUT NOCOPY ipyv_rec_type
142 );
143 --Skgautam Bug 3967640
144 PROCEDURE calc_total_premium(p_api_version IN NUMBER,
145 p_init_msg_list IN VARCHAR2 ,
146 x_return_status OUT NOCOPY VARCHAR2,
147 x_msg_count OUT NOCOPY NUMBER,
148 x_msg_data OUT NOCOPY VARCHAR2,
149 p_pol_qte_id IN VARCHAR2,
150 x_total_premium OUT NOCOPY NUMBER);
151
152 PROCEDURE activate_ins_stream(
153 p_api_version IN NUMBER,
154 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
155 x_return_status OUT NOCOPY VARCHAR2,
156 x_msg_count OUT NOCOPY NUMBER,
157 x_msg_data OUT NOCOPY VARCHAR2,
158 p_ipyv_rec IN ipyv_rec_type
159 );
160
161 PROCEDURE activate_ins_streams(
162 errbuf OUT NOCOPY VARCHAR2,
163 retcode OUT NOCOPY NUMBER
164 );
165
166 PROCEDURE activate_ins_streams(
167 p_api_version IN NUMBER,
168 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
169 x_return_status OUT NOCOPY VARCHAR2,
170 x_msg_count OUT NOCOPY NUMBER,
171 x_msg_data OUT NOCOPY VARCHAR2,
172 p_contract_id IN NUMBER
173 );
174
175 /*#
176 * Insurance Quote API activates lease insurance policy.
177 * @param p_api_version API version
178 * @param p_init_msg_list Initialize message stack
179 * @param x_return_status Return status from the API
180 * @param x_msg_count Message count if error messages are encountered
181 * @param x_msg_data Message data error message
182 * @param p_ins_policy_id Insurance policy identifier
183 * @rep:displayname Activate Insurance Policy
184 * @rep:scope public
185 * @rep:lifecycle active
186 */
187 PROCEDURE activate_ins_policy(
188 p_api_version IN NUMBER,
189 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
190 x_return_status OUT NOCOPY VARCHAR2,
191 x_msg_count OUT NOCOPY NUMBER,
192 x_msg_data OUT NOCOPY VARCHAR2,
193 p_ins_policy_id IN NUMBER
194 );
195
196 PROCEDURE create_third_prt_ins(
197 p_api_version IN NUMBER,
198 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
199 x_return_status OUT NOCOPY VARCHAR2,
200 x_msg_count OUT NOCOPY NUMBER,
201 x_msg_data OUT NOCOPY VARCHAR2,
202 p_ipyv_rec IN ipyv_rec_type,
203 x_ipyv_rec OUT NOCOPY ipyv_rec_type
204 );
205 -- Bug: 4567777 PAGARG new procedures for Lease Application Functionality.
206 PROCEDURE crt_lseapp_thrdprt_ins(
207 p_api_version IN NUMBER,
208 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
209 x_return_status OUT NOCOPY VARCHAR2,
210 x_msg_count OUT NOCOPY NUMBER,
211 x_msg_data OUT NOCOPY VARCHAR2,
212 p_ipyv_rec IN ipyv_rec_type,
213 x_ipyv_rec OUT NOCOPY ipyv_rec_type);
214
215 PROCEDURE lseapp_thrdprty_to_ctrct(
216 p_api_version IN NUMBER,
217 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
218 x_return_status OUT NOCOPY VARCHAR2,
219 x_msg_count OUT NOCOPY NUMBER,
220 x_msg_data OUT NOCOPY VARCHAR2,
221 p_lakhr_id IN NUMBER,
222 x_ipyv_rec OUT NOCOPY ipyv_rec_type);
223
224 END Okl_Ins_Quote_Pub;