[Home] [Help]
PACKAGE: APPS.OKL_EC_UPTAKE_PVT
Source
1 PACKAGE OKL_EC_UPTAKE_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLRECXS.pls 120.12 2006/03/08 10:20:13 ssdeshpa noship $ */
3 --------------------------------------------------------------------------
4 --Added by ssdeshpa for EC uptakes on LRS,STR,Products on Lease Quote
5 -------------------------------------------------------------------------
6 --------------------
7 -- PACKAGE CONSTANTS
8 --------------------
9 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_EC_UPTAKE_PVT';
10 G_APP_NAME CONSTANT VARCHAR2(200) := OKL_API.G_APP_NAME;
11 G_API_VERSION CONSTANT NUMBER := 1;
12 G_USER_ID CONSTANT NUMBER := FND_GLOBAL.USER_ID;
13 G_LOGIN_ID CONSTANT NUMBER := FND_GLOBAL.LOGIN_ID;
14 G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
15 G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
16 G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
17 G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
18 G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
19 G_DB_ERROR CONSTANT VARCHAR2(30) := 'OKL_DB_ERROR';
20 G_PKG_NAME_TOKEN CONSTANT VARCHAR2(30) := 'PKG_NAME';
21 G_PROG_NAME_TOKEN CONSTANT VARCHAR2(30) := 'PROG_NAME';
22 G_SQLCODE_TOKEN CONSTANT VARCHAR2(30) := 'SQLCODE';
23 G_SQLERRM_TOKEN CONSTANT VARCHAR2(30) := 'SQLERRM';
24
25 ---------------------------------------------------------------------------
26 -- GLOBAL VARIABLES
27 ---------------------------------------------------------------------------
28 --G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_VALIDATION_SET_PVT';
29 G_API_TYPE CONSTANT varchar2(4) := '_PVT';
30 G_QA_CHECKER_ERROR CONSTANT VARCHAR2(30):= 'OKL_EC_CRITERIA_ERROR';
31 QA_CHECKER_UNEXP_ERROR EXCEPTION;
32 --G_APP_NAME CONSTANT VARCHAR2(3) := Okl_Api.G_APP_NAME;
33
34 --SUBTYPE okl_ec_rec_type IS okl_ec_evaluate_pvt.okl_ec_rec_type;
35
36 TYPE okl_number_table_type IS TABLE OF number INDEX BY BINARY_INTEGER;
37
38 TYPE okl_varchar2_table_type IS TABLE OF varchar2(240)
39 INDEX BY BINARY_INTEGER;
40
41 TYPE okl_date_tabe_type IS TABLE OF date INDEX BY BINARY_INTEGER;
42
43 TYPE okl_qa_result_rec_type IS RECORD (
44 message varchar2(240),
45 status varchar2(30)
46 );
47
48 TYPE okl_qa_result_tbl_type IS TABLE OF okl_qa_result_rec_type
49 INDEX BY BINARY_INTEGER;
50
51 TYPE okl_lease_rate_set_rec_type IS RECORD (
52 id number,
53 rate_set_version_id number,
54 version_number number,
55 name okl_ls_rt_fctr_sets_v.name%TYPE,
56 description okl_ls_rt_fctr_sets_v.description%TYPE,
57 effective_from DATE,
58 effective_to DATE,
59 lrs_rate okl_fe_rate_set_versions_v.lrs_rate%TYPE,
60 sts_code okl_fe_rate_set_versions_v.sts_code%TYPE,
61 frq_code VARCHAR2(15),
62 frq_meaning VARCHAR2(240)
63 );
64
65 TYPE okl_lease_rate_set_tbl_type IS TABLE OF okl_lease_rate_set_rec_type
66 INDEX BY BINARY_INTEGER;
67
68 TYPE okl_std_rate_tmpl_rec_type IS RECORD (
69 id number,
70 std_rate_tmpl_ver_id number,
71 version_number number,
72 name okl_fe_std_rt_tmp_v.template_name%TYPE,
73 description okl_fe_std_rt_tmp_v.TEMPLATE_DESC%TYPE,
74 frq_code VARCHAR2(15),
75 effective_from DATE,
76 effective_to DATE,
77 srt_rate okl_fe_std_rt_tmp_vers.srt_rate%TYPE,
78 sts_code okl_fe_std_rt_tmp_vers.sts_code%TYPE,
79 day_convention_code okl_fe_std_rt_tmp_vers.day_convention_code%TYPE,
80 frq_meaning VARCHAR2(240)
81 );
82
83 TYPE okl_std_rate_tmpl_tbl_type IS TABLE OF okl_std_rate_tmpl_rec_type
84 INDEX BY BINARY_INTEGER;
85
86
87 TYPE okl_prod_rec_type IS RECORD (
88 id number,
89 name okl_product_parameters_v.name%TYPE,
90 product_subclass okl_product_parameters_v.product_subclass%TYPE,
91 version number,
92 description okl_product_parameters_v.description%TYPE,
93 product_status_code okl_product_parameters_v.product_status_code%TYPE,
94 deal_type okl_product_parameters_v.deal_type%TYPE,
95 deal_type_meaning okl_product_parameters_v.deal_type_meaning%TYPE
96 );
97
98 TYPE okl_prod_tbl_type IS TABLE OF okl_prod_rec_type
99 INDEX BY BINARY_INTEGER;
100
101 TYPE okl_vp_rec_type IS RECORD (
102 id number,
103 contract_number okc_k_headers_b.contract_number%TYPE,
104 start_date DATE,
105 end_date DATE
106 );
107
108 TYPE okl_vp_tbl_type IS TABLE OF okl_vp_rec_type
109 INDEX BY BINARY_INTEGER;
110
111
112 -----------------------------------------------------------------------------------------------------
113 --Populate Lease Rate Set For Lease Quote
114
115 PROCEDURE populate_lease_rate_set(p_api_version IN NUMBER,
116 p_init_msg_list IN VARCHAR2,
117 p_target_id number,
118 p_target_type IN varchar2,
119 x_okl_lrs_table OUT NOCOPY okl_lease_rate_set_tbl_type,
120 x_return_status OUT NOCOPY VARCHAR2,
121 x_msg_count OUT NOCOPY NUMBER,
122 x_msg_data OUT NOCOPY VARCHAR2);
123 ------------------------------------------------------------------------------------
124
125 PROCEDURE populate_std_rate_tmpl(p_api_version IN NUMBER,
126 p_init_msg_list IN VARCHAR2,
127 p_target_id number,
128 p_target_type IN varchar2,
129 x_okl_srt_table OUT NOCOPY okl_std_rate_tmpl_tbl_type,
130 x_return_status OUT NOCOPY VARCHAR2,
131 x_msg_count OUT NOCOPY NUMBER,
132 x_msg_data OUT NOCOPY VARCHAR2);
133 -------------------------------------------------------------------------------------------
134 --Populate Lease Rate Set For Quick Quote
135
136 PROCEDURE populate_lease_rate_set(p_api_version IN NUMBER,
137 p_init_msg_list IN VARCHAR2,
138 p_target_id number,
139 p_target_type IN varchar2,
140 p_target_eff_from date,
141 p_term NUMBER,
142 p_territory VARCHAR2,
143 p_deal_size number,
144 p_customer_credit_class VARCHAR2,
145 p_down_payment number,
146 p_advance_rent number,
147 p_trade_in_value number,
148 --Bug # 5045505 ssdeshpa start
149 p_currency_code VARCHAR2,
150 --Bug # 5045505 ssdeshpa End
151 p_item_table okl_number_table_type,
152 p_item_categories_table okl_number_table_type,
153 x_okl_lrs_table OUT NOCOPY okl_lease_rate_set_tbl_type,
154 x_return_status OUT NOCOPY VARCHAR2,
155 x_msg_count OUT NOCOPY NUMBER,
156 x_msg_data OUT NOCOPY VARCHAR2);
157 --------------------------------------------------------------------------------------------
158 PROCEDURE populate_std_rate_tmpl(p_api_version IN NUMBER,
159 p_init_msg_list IN VARCHAR2,
160 p_target_id number,
161 p_target_type IN varchar2,
162 p_target_eff_from date,
163 p_term NUMBER,
164 p_territory VARCHAR2,
165 p_deal_size number,
166 p_customer_credit_class VARCHAR2,
167 p_down_payment number,
168 p_advance_rent number,
169 p_trade_in_value number,
170 --Bug # 5045505 ssdeshpa start
171 p_currency_code VARCHAR2,
172 --Bug # 5045505 ssdeshpa End
173 p_item_table okl_number_table_type,
174 p_item_categories_table okl_number_table_type,
175 x_okl_srt_table OUT NOCOPY okl_std_rate_tmpl_tbl_type,
176 x_return_status OUT NOCOPY VARCHAR2,
177 x_msg_count OUT NOCOPY NUMBER,
178 x_msg_data OUT NOCOPY VARCHAR2);
179 --------------------------------------------------------------------------------------------
180
181 PROCEDURE populate_product(p_api_version IN NUMBER,
182 p_init_msg_list IN VARCHAR2,
183 p_target_id number,
184 p_target_type IN varchar2,
185 x_okl_prod_table OUT NOCOPY okl_prod_tbl_type,
186 x_return_status OUT NOCOPY VARCHAR2,
187 x_msg_count OUT NOCOPY NUMBER,
188 x_msg_data OUT NOCOPY VARCHAR2);
189 -------------------------------------------------------------------------------
190
191 PROCEDURE populate_vendor_program(p_api_version IN NUMBER,
192 p_init_msg_list IN VARCHAR2,
193 p_target_id number,
194 p_target_type IN varchar2,
195 p_target_eff_from date,
196 p_term NUMBER,
197 p_territory VARCHAR2,
198 p_deal_size number,
199 p_customer_credit_class VARCHAR2,
200 p_down_payment number,
201 p_advance_rent number,
202 p_trade_in_value number,
203 p_item_table okl_number_table_type,
204 p_item_categories_table okl_number_table_type,
205 x_okl_vp_table OUT NOCOPY okl_vp_tbl_type,
206 x_return_status OUT NOCOPY VARCHAR2,
207 x_msg_count OUT NOCOPY NUMBER,
208 x_msg_data OUT NOCOPY VARCHAR2);
209 ----------------------------------------------------------------------------------------
210 function get_vp_id(p_target_id number) RETURN NUMBER;
211
212
213
214 END OKL_EC_UPTAKE_PVT; -- Package spec