[Home] [Help]
PACKAGE: APPS.OKL_CREDIT_DATAPOINTS_PVT
Source
1 PACKAGE OKL_CREDIT_DATAPOINTS_PVT AS
2 /* $Header: OKLRCDPS.pls 120.4 2006/04/06 19:55:54 rravikir noship $ */
3
4 --------------------
5 -- PACKAGE CONSTANTS
6 --------------------
7 G_PKG_NAME CONSTANT VARCHAR2(30) := 'OKL_CREDIT_DATAPOINTS_PVT';
8 G_APP_NAME CONSTANT VARCHAR2(30) := OKL_API.G_APP_NAME;
9 G_API_VERSION CONSTANT NUMBER := 1;
10 G_USER_ID CONSTANT NUMBER := FND_GLOBAL.USER_ID;
11 G_LOGIN_ID CONSTANT NUMBER := FND_GLOBAL.LOGIN_ID;
12 G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
13 G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
14 G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
15 G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
16 G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
17 G_DB_ERROR CONSTANT VARCHAR2(30) := 'OKL_DB_ERROR';
18 G_PKG_NAME_TOKEN CONSTANT VARCHAR2(30) := 'PKG_NAME';
19 G_PROG_NAME_TOKEN CONSTANT VARCHAR2(30) := 'PROG_NAME';
20 G_SQLCODE_TOKEN CONSTANT VARCHAR2(30) := 'SQLCODE';
21 G_SQLERRM_TOKEN CONSTANT VARCHAR2(30) := 'SQLERRM';
22 G_API_TYPE CONSTANT VARCHAR2(4) := '_PVT';
23
24 --subtype lap_dp_tbl_type is okl_lad_pvt.lad_tbl_type;
25
26 TYPE lap_dp_rec_type IS RECORD (
27 id okl_leaseapp_datapoints.id%TYPE
28 ,object_version_number okl_leaseapp_datapoints.object_version_number%TYPE
29 ,leaseapp_id okl_leaseapp_datapoints.leaseapp_id%TYPE
30 ,data_point_id okl_leaseapp_datapoints.data_point_id%TYPE
31 ,data_point_category okl_leaseapp_datapoints.data_point_category%TYPE
32 ,data_point_value okl_leaseapp_datapoints.data_point_value%TYPE
33 ,data_point_name ar_cmgt_data_points_vl.data_point_name%TYPE
34 ,description ar_cmgt_data_points_vl.description%TYPE);
35
36 TYPE lap_dp_tbl_type IS TABLE OF lap_dp_rec_type INDEX BY PLS_INTEGER;
37
38 FUNCTION credit_line_number(x_resultout OUT NOCOPY VARCHAR2,
39 x_errormsg OUT NOCOPY VARCHAR2) RETURN VARCHAR2;
40
41 FUNCTION credit_line_expiration_date (x_resultout OUT NOCOPY VARCHAR2,
42 x_errormsg OUT NOCOPY VARCHAR2) RETURN DATE;
43
44 FUNCTION currency (x_resultout OUT NOCOPY VARCHAR2,
45 x_errormsg OUT NOCOPY VARCHAR2) RETURN VARCHAR2;
46
47 FUNCTION sales_rep (x_resultout OUT NOCOPY VARCHAR2,
48 x_errormsg OUT NOCOPY VARCHAR2) RETURN VARCHAR2;
49
50 FUNCTION program_vendor (x_resultout OUT NOCOPY VARCHAR2,
51 x_errormsg OUT NOCOPY VARCHAR2) RETURN VARCHAR2;
52
53 FUNCTION program_agreement_number (x_resultout OUT NOCOPY VARCHAR2,
54 x_errormsg OUT NOCOPY VARCHAR2) RETURN VARCHAR2;
55
56 FUNCTION expected_start_date (x_resultout OUT NOCOPY VARCHAR2,
57 x_errormsg OUT NOCOPY VARCHAR2) RETURN DATE;
58
59 FUNCTION expected_delivery_date (x_resultout OUT NOCOPY VARCHAR2,
60 x_errormsg OUT NOCOPY VARCHAR2) RETURN DATE;
61
62 FUNCTION expected_funding_date (x_resultout OUT NOCOPY VARCHAR2,
63 x_errormsg OUT NOCOPY VARCHAR2) RETURN DATE;
64
65 FUNCTION lease_application_template (x_resultout OUT NOCOPY VARCHAR2,
66 x_errormsg OUT NOCOPY VARCHAR2) RETURN VARCHAR2;
67
68 FUNCTION org_unit (x_resultout OUT NOCOPY VARCHAR2,
69 x_errormsg OUT NOCOPY VARCHAR2) RETURN VARCHAR2;
70
71 FUNCTION prospect_address (x_resultout OUT NOCOPY VARCHAR2,
72 x_errormsg OUT NOCOPY VARCHAR2) RETURN VARCHAR2;
73
74 FUNCTION term_of_deal (x_resultout OUT NOCOPY VARCHAR2,
75 x_errormsg OUT NOCOPY VARCHAR2) RETURN NUMBER;
76
77 FUNCTION financial_product (x_resultout OUT NOCOPY VARCHAR2,
78 x_errormsg OUT NOCOPY VARCHAR2) RETURN VARCHAR2;
79
80 FUNCTION item (x_resultout OUT NOCOPY VARCHAR2,
81 x_errormsg OUT NOCOPY VARCHAR2) RETURN VARCHAR2;
82
83 FUNCTION item_description (x_resultout OUT NOCOPY VARCHAR2,
84 x_errormsg OUT NOCOPY VARCHAR2) RETURN VARCHAR2;
85
86 FUNCTION item_supplier (x_resultout OUT NOCOPY VARCHAR2,
87 x_errormsg OUT NOCOPY VARCHAR2) RETURN VARCHAR2;
88
89 FUNCTION model (x_resultout OUT NOCOPY VARCHAR2,
90 x_errormsg OUT NOCOPY VARCHAR2) RETURN VARCHAR2;
91
92 FUNCTION manufacturer (x_resultout OUT NOCOPY VARCHAR2,
93 x_errormsg OUT NOCOPY VARCHAR2) RETURN VARCHAR2;
94
95 FUNCTION year_of_manufacture (x_resultout OUT NOCOPY VARCHAR2,
96 x_errormsg OUT NOCOPY VARCHAR2) RETURN VARCHAR2;
97
98 FUNCTION no_of_units (x_resultout OUT NOCOPY VARCHAR2,
99 x_errormsg OUT NOCOPY VARCHAR2) RETURN VARCHAR2;
100
101
102 FUNCTION unit_cost (x_resultout OUT NOCOPY VARCHAR2,
103 x_errormsg OUT NOCOPY VARCHAR2) RETURN VARCHAR2;
104
105 FUNCTION install_site (x_resultout OUT NOCOPY VARCHAR2,
106 x_errormsg OUT NOCOPY VARCHAR2) RETURN VARCHAR2;
107
108
109 FUNCTION usage_of_equipment (x_resultout OUT NOCOPY VARCHAR2,
110 x_errormsg OUT NOCOPY VARCHAR2) RETURN VARCHAR2;
111
112 FUNCTION usage_industry (x_resultout OUT NOCOPY VARCHAR2,
113 x_errormsg OUT NOCOPY VARCHAR2) RETURN VARCHAR2;
114
115 FUNCTION usage_category (x_resultout OUT NOCOPY VARCHAR2,
116 x_errormsg OUT NOCOPY VARCHAR2) RETURN VARCHAR2;
117
118 FUNCTION usage_amount (x_resultout OUT NOCOPY VARCHAR2,
119 x_errormsg OUT NOCOPY VARCHAR2) RETURN NUMBER;
120
121 FUNCTION add_on_item (x_resultout OUT NOCOPY VARCHAR2,
122 x_errormsg OUT NOCOPY VARCHAR2) RETURN VARCHAR2;
123
124 FUNCTION add_on_item_description (x_resultout OUT NOCOPY VARCHAR2,
125 x_errormsg OUT NOCOPY VARCHAR2) RETURN VARCHAR2;
126
127 FUNCTION add_on_item_supplier (x_resultout OUT NOCOPY VARCHAR2,
128 x_errormsg OUT NOCOPY VARCHAR2) RETURN VARCHAR2;
129
130 FUNCTION add_on_item_model (x_resultout OUT NOCOPY VARCHAR2,
131 x_errormsg OUT NOCOPY VARCHAR2) RETURN VARCHAR2;
132
133 FUNCTION add_on_item_manufacturer (x_resultout OUT NOCOPY VARCHAR2,
134 x_errormsg OUT NOCOPY VARCHAR2) RETURN VARCHAR2;
135
136 FUNCTION add_on_item_amount (x_resultout OUT NOCOPY VARCHAR2,
137 x_errormsg OUT NOCOPY VARCHAR2) RETURN VARCHAR2;
138
139 FUNCTION asset_residual_value (x_resultout OUT NOCOPY VARCHAR2,
140 x_errormsg OUT NOCOPY VARCHAR2) RETURN VARCHAR2;
141
142 FUNCTION down_payment_amount (x_resultout OUT NOCOPY VARCHAR2,
143 x_errormsg OUT NOCOPY VARCHAR2) RETURN NUMBER;
144
145 FUNCTION subsidy_amount (x_resultout OUT NOCOPY VARCHAR2,
146 x_errormsg OUT NOCOPY VARCHAR2) RETURN NUMBER;
147
148 FUNCTION trade_in_amount (x_resultout OUT NOCOPY VARCHAR2,
149 x_errormsg OUT NOCOPY VARCHAR2) RETURN NUMBER;
150
151 FUNCTION trade_in_asset_number (x_resultout OUT NOCOPY VARCHAR2,
152 x_errormsg OUT NOCOPY VARCHAR2) RETURN NUMBER;
153
154 FUNCTION pmnt_frequency (x_resultout OUT NOCOPY VARCHAR2,
155 x_errormsg OUT NOCOPY VARCHAR2) RETURN VARCHAR2;
156
157 FUNCTION pmnt_arrears_yn (x_resultout OUT NOCOPY VARCHAR2,
158 x_errormsg OUT NOCOPY VARCHAR2) RETURN VARCHAR2;
159
160 FUNCTION pmnt_periods (x_resultout OUT NOCOPY VARCHAR2,
161 x_errormsg OUT NOCOPY VARCHAR2) RETURN VARCHAR2;
162
163 FUNCTION pmnt_amounts (x_resultout OUT NOCOPY VARCHAR2,
164 x_errormsg OUT NOCOPY VARCHAR2) RETURN VARCHAR2;
165
166 FUNCTION pmnt_start_date (x_resultout OUT NOCOPY VARCHAR2,
167 x_errormsg OUT NOCOPY VARCHAR2) RETURN VARCHAR2;
168
169 FUNCTION pmnt_end_date (x_resultout OUT NOCOPY VARCHAR2,
170 x_errormsg OUT NOCOPY VARCHAR2) RETURN VARCHAR2;
171
172 FUNCTION fee_type (x_resultout OUT NOCOPY VARCHAR2,
173 x_errormsg OUT NOCOPY VARCHAR2) RETURN VARCHAR2;
174
175 FUNCTION fee_name (x_resultout OUT NOCOPY VARCHAR2,
176 x_errormsg OUT NOCOPY VARCHAR2) RETURN VARCHAR2;
177
178 FUNCTION fee_amount (x_resultout OUT NOCOPY VARCHAR2,
179 x_errormsg OUT NOCOPY VARCHAR2) RETURN VARCHAR2;
180
181 FUNCTION fee_date (x_resultout OUT NOCOPY VARCHAR2,
182 x_errormsg OUT NOCOPY VARCHAR2) RETURN VARCHAR2;
183
184 FUNCTION amount_requested(x_resultout OUT NOCOPY VARCHAR2,
185 x_errormsg OUT NOCOPY VARCHAR2) RETURN NUMBER;
186
187 FUNCTION total_subsidized_cost(x_resultout OUT NOCOPY VARCHAR2,
188 x_errormsg OUT NOCOPY VARCHAR2) RETURN NUMBER;
189
190 FUNCTION total_financed_amount(x_resultout OUT NOCOPY VARCHAR2,
191 x_errormsg OUT NOCOPY VARCHAR2) RETURN NUMBER;
192
193 FUNCTION security_deposit(x_resultout OUT NOCOPY VARCHAR2,
194 x_errormsg OUT NOCOPY VARCHAR2) RETURN VARCHAR2;
195
196 FUNCTION billed_tax(x_resultout OUT NOCOPY VARCHAR2,
197 x_errormsg OUT NOCOPY VARCHAR2) RETURN NUMBER;
198
199 FUNCTION payment_structure(x_resultout OUT NOCOPY VARCHAR2,
200 x_errormsg OUT NOCOPY VARCHAR2) RETURN VARCHAR2;
201
202 PROCEDURE fetch_leaseapp_datapoints(p_api_version IN NUMBER
203 ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
204 ,p_leaseapp_id IN NUMBER
205 ,x_lap_dp_tbl_type OUT NOCOPY lap_dp_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 PROCEDURE delete_leaseapp_datapoints(p_api_version IN NUMBER
211 ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
212 ,p_leaseapp_id IN NUMBER
213 ,x_return_status OUT NOCOPY VARCHAR2
214 ,x_msg_count OUT NOCOPY NUMBER
215 ,x_msg_data OUT NOCOPY VARCHAR2);
216
217 PROCEDURE store_leaseapp_datapoints(p_api_version IN NUMBER
218 ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
219 ,p_lap_dp_tbl IN lap_dp_tbl_type
220 ,x_return_status OUT NOCOPY VARCHAR2
221 ,x_msg_count OUT NOCOPY NUMBER
222 ,x_msg_data OUT NOCOPY VARCHAR2);
223
224 FUNCTION leaseapp_datapoints_exists(p_leaseapp_id IN NUMBER) RETURN BOOLEAN;
225
226 FUNCTION fetch_data_point_value(x_resultout OUT NOCOPY VARCHAR2,
227 x_errormsg OUT NOCOPY VARCHAR2) RETURN VARCHAR2;
228
229 END OKL_CREDIT_DATAPOINTS_PVT;