[Home] [Help]
PACKAGE: APPS.OKL_POL_PVT
Source
1 PACKAGE OKL_POL_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLSPOLS.pls 120.4 2006/11/20 05:42:30 abhsaxen noship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 -- OKL_POOLS_V Record Spec
7 TYPE polv_rec_type IS RECORD (
8 id NUMBER := OKL_API.G_MISS_NUM
9 ,object_version_number NUMBER := OKL_API.G_MISS_NUM
10 ,pot_id NUMBER := OKL_API.G_MISS_NUM
11 ,khr_id NUMBER := OKL_API.G_MISS_NUM
12 ,pool_number OKL_POOLS.POOL_NUMBER%TYPE := OKL_API.G_MISS_CHAR
13 ,description OKL_POOLS.DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR
14 ,short_description OKL_POOLS.SHORT_DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR
18 ,securities_credit_rating OKL_POOLS.SECURITIES_CREDIT_RATING%TYPE := OKL_API.G_MISS_CHAR
15 ,currency_code OKL_POOLS.CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
16 ,total_principal_amount NUMBER := OKL_API.G_MISS_NUM
17 ,total_receivable_amount NUMBER := OKL_API.G_MISS_NUM
19 ,date_created OKL_POOLS.DATE_CREATED%TYPE := OKL_API.G_MISS_DATE
20 ,date_last_updated OKL_POOLS.DATE_LAST_UPDATED%TYPE := OKL_API.G_MISS_DATE
21 ,date_last_reconciled OKL_POOLS.DATE_LAST_UPDATED%TYPE := OKL_API.G_MISS_DATE
22 ,date_total_principal_calc OKL_POOLS.DATE_LAST_UPDATED%TYPE := OKL_API.G_MISS_DATE
23 ,status_code OKL_POOLS.STATUS_CODE%TYPE := OKL_API.G_MISS_CHAR
24 ,display_in_lease_center OKL_POOLS.DISPLAY_IN_LEASE_CENTER%TYPE := OKL_API.G_MISS_CHAR
25 ,attribute_category OKL_POOLS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
26 ,attribute1 OKL_POOLS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
27 ,attribute2 OKL_POOLS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
28 ,attribute3 OKL_POOLS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
29 ,attribute4 OKL_POOLS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
30 ,attribute5 OKL_POOLS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
31 ,attribute6 OKL_POOLS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
32 ,attribute7 OKL_POOLS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
33 ,attribute8 OKL_POOLS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
34 ,attribute9 OKL_POOLS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
35 ,attribute10 OKL_POOLS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
36 ,attribute11 OKL_POOLS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
37 ,attribute12 OKL_POOLS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
38 ,attribute13 OKL_POOLS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
39 ,attribute14 OKL_POOLS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
40 ,attribute15 OKL_POOLS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
41 ,org_id NUMBER := OKL_API.G_MISS_NUM
42 ,request_id NUMBER := OKL_API.G_MISS_NUM
43 ,program_application_id NUMBER := OKL_API.G_MISS_NUM
44 ,program_id NUMBER := OKL_API.G_MISS_NUM
45 ,program_update_date OKL_POOLS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
46 ,created_by NUMBER := OKL_API.G_MISS_NUM
47 ,creation_date OKL_POOLS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
48 ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
49 ,last_update_date OKL_POOLS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
50 ,last_update_login NUMBER := OKL_API.G_MISS_NUM
51 --added by abshaxen for legal entity uptake
52 ,legal_entity_id OKL_POOLS.LEGAL_ENTITY_ID%TYPE :=OKL_API.G_MISS_NUM);
53 G_MISS_polv_rec polv_rec_type;
54 TYPE polv_tbl_type IS TABLE OF polv_rec_type
55 INDEX BY BINARY_INTEGER;
56 -- OKL_POOLS Record Spec
57 TYPE pol_rec_type IS RECORD (
58 id NUMBER := OKL_API.G_MISS_NUM
59 ,object_version_number NUMBER := OKL_API.G_MISS_NUM
60 ,pot_id NUMBER := OKL_API.G_MISS_NUM
61 ,khr_id NUMBER := OKL_API.G_MISS_NUM
62 ,pool_number OKL_POOLS.POOL_NUMBER%TYPE := OKL_API.G_MISS_CHAR
63 ,description OKL_POOLS.DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR
64 ,short_description OKL_POOLS.SHORT_DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR
65 ,currency_code OKL_POOLS.CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
66 ,total_principal_amount NUMBER := OKL_API.G_MISS_NUM
67 ,total_receivable_amount NUMBER := OKL_API.G_MISS_NUM
68 ,securities_credit_rating OKL_POOLS.SECURITIES_CREDIT_RATING%TYPE := OKL_API.G_MISS_CHAR
69 ,date_created OKL_POOLS.DATE_CREATED%TYPE := OKL_API.G_MISS_DATE
70 ,date_last_updated OKL_POOLS.DATE_LAST_UPDATED%TYPE := OKL_API.G_MISS_DATE
71 ,status_code OKL_POOLS.STATUS_CODE%TYPE := OKL_API.G_MISS_CHAR
72 ,date_last_reconciled OKL_POOLS.DATE_LAST_UPDATED%TYPE := OKL_API.G_MISS_DATE
73 ,date_total_principal_calc OKL_POOLS.DATE_LAST_UPDATED%TYPE := OKL_API.G_MISS_DATE
74 ,display_in_lease_center OKL_POOLS.DISPLAY_IN_LEASE_CENTER%TYPE := OKL_API.G_MISS_CHAR
75 ,attribute_category OKL_POOLS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
76 ,attribute1 OKL_POOLS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
77 ,attribute2 OKL_POOLS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
78 ,attribute3 OKL_POOLS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
79 ,attribute4 OKL_POOLS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
80 ,attribute5 OKL_POOLS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
81 ,attribute6 OKL_POOLS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
82 ,attribute7 OKL_POOLS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
83 ,attribute8 OKL_POOLS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
84 ,attribute9 OKL_POOLS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
85 ,attribute10 OKL_POOLS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
86 ,attribute11 OKL_POOLS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
87 ,attribute12 OKL_POOLS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
88 ,attribute13 OKL_POOLS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
89 ,attribute14 OKL_POOLS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
90 ,attribute15 OKL_POOLS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
94 ,program_id NUMBER := OKL_API.G_MISS_NUM
91 ,org_id NUMBER := OKL_API.G_MISS_NUM
92 ,request_id NUMBER := OKL_API.G_MISS_NUM
93 ,program_application_id NUMBER := OKL_API.G_MISS_NUM
95 ,program_update_date OKL_POOLS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
96 ,created_by NUMBER := OKL_API.G_MISS_NUM
97 ,creation_date OKL_POOLS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
98 ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
99 ,last_update_date OKL_POOLS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
100 ,last_update_login NUMBER := OKL_API.G_MISS_NUM
101 --added by abshaxen for legal entity uptake
102 ,legal_entity_id OKL_POOLS.LEGAL_ENTITY_ID%TYPE :=OKL_API.G_MISS_NUM);
103 G_MISS_pol_rec pol_rec_type;
104 TYPE pol_tbl_type IS TABLE OF pol_rec_type
105 INDEX BY BINARY_INTEGER;
106 ---------------------------------------------------------------------------
107 -- GLOBAL MESSAGE CONSTANTS
108 ---------------------------------------------------------------------------
109 G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
110 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
111 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
112 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
113 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
114 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
115 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
116 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
117 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
118 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
119 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
120 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
121 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
122
123 -- mvasudev, 11/08/2002
124 G_OKC_APP CONSTANT VARCHAR2(200) := OKL_API.G_APP_NAME;
125 G_OKL_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLerrm';
126 G_OKL_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLcode';
127 G_OKL_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
128 G_OKL_UNQS CONSTANT VARCHAR2(200) := 'OKL_POL_NOT_UNIQUE';
129 G_AK_REGION_NAME VARCHAR2(17) := 'OKL_LA_POOL_CRUPT';
130
131 -- mvasudev, 12/30/2002
132 g_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%TYPE;
133
134 ---------------------------------------------------------------------------
135 -- GLOBAL EXCEPTIONS
136 ---------------------------------------------------------------------------
137 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
138
139 ---------------------------------------------------------------------------
140 -- GLOBAL VARIABLES
141 ---------------------------------------------------------------------------
142 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_POL_PVT';
143 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
144 ---------------------------------------------------------------------------
145 -- Procedures and Functions
146 ---------------------------------------------------------------------------
147
148 PROCEDURE qc;
149 PROCEDURE change_version;
150 PROCEDURE api_copy;
151 PROCEDURE insert_row(
152 p_api_version IN NUMBER,
153 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
154 x_return_status OUT NOCOPY VARCHAR2,
155 x_msg_count OUT NOCOPY NUMBER,
156 x_msg_data OUT NOCOPY VARCHAR2,
157 p_polv_rec IN polv_rec_type,
158 x_polv_rec OUT NOCOPY polv_rec_type);
159 PROCEDURE insert_row(
160 p_api_version IN NUMBER,
161 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
162 x_return_status OUT NOCOPY VARCHAR2,
163 x_msg_count OUT NOCOPY NUMBER,
164 x_msg_data OUT NOCOPY VARCHAR2,
165 p_polv_tbl IN polv_tbl_type,
166 x_polv_tbl OUT NOCOPY polv_tbl_type,
167 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
168 PROCEDURE insert_row(
169 p_api_version IN NUMBER,
170 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
171 x_return_status OUT NOCOPY VARCHAR2,
172 x_msg_count OUT NOCOPY NUMBER,
173 x_msg_data OUT NOCOPY VARCHAR2,
174 p_polv_tbl IN polv_tbl_type,
175 x_polv_tbl OUT NOCOPY polv_tbl_type);
176 PROCEDURE lock_row(
177 p_api_version IN NUMBER,
178 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
179 x_return_status OUT NOCOPY VARCHAR2,
180 x_msg_count OUT NOCOPY NUMBER,
181 x_msg_data OUT NOCOPY VARCHAR2,
182 p_polv_rec IN polv_rec_type);
183 PROCEDURE lock_row(
184 p_api_version IN NUMBER,
185 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
186 x_return_status OUT NOCOPY VARCHAR2,
187 x_msg_count OUT NOCOPY NUMBER,
188 x_msg_data OUT NOCOPY VARCHAR2,
189 p_polv_tbl IN polv_tbl_type,
190 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
191 PROCEDURE lock_row(
192 p_api_version IN NUMBER,
193 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
194 x_return_status OUT NOCOPY VARCHAR2,
195 x_msg_count OUT NOCOPY NUMBER,
196 x_msg_data OUT NOCOPY VARCHAR2,
197 p_polv_tbl IN polv_tbl_type);
198 PROCEDURE update_row(
199 p_api_version IN NUMBER,
200 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
201 x_return_status OUT NOCOPY VARCHAR2,
202 x_msg_count OUT NOCOPY NUMBER,
203 x_msg_data OUT NOCOPY VARCHAR2,
204 p_polv_rec IN polv_rec_type,
205 x_polv_rec OUT NOCOPY polv_rec_type);
206 PROCEDURE update_row(
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_polv_tbl IN polv_tbl_type,
213 x_polv_tbl OUT NOCOPY polv_tbl_type,
214 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
215 PROCEDURE update_row(
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_polv_tbl IN polv_tbl_type,
222 x_polv_tbl OUT NOCOPY polv_tbl_type);
223 PROCEDURE delete_row(
224 p_api_version IN NUMBER,
225 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
226 x_return_status OUT NOCOPY VARCHAR2,
227 x_msg_count OUT NOCOPY NUMBER,
228 x_msg_data OUT NOCOPY VARCHAR2,
229 p_polv_rec IN polv_rec_type);
230 PROCEDURE delete_row(
231 p_api_version IN NUMBER,
232 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
233 x_return_status OUT NOCOPY VARCHAR2,
234 x_msg_count OUT NOCOPY NUMBER,
235 x_msg_data OUT NOCOPY VARCHAR2,
236 p_polv_tbl IN polv_tbl_type,
237 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
238 PROCEDURE delete_row(
239 p_api_version IN NUMBER,
240 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
241 x_return_status OUT NOCOPY VARCHAR2,
242 x_msg_count OUT NOCOPY NUMBER,
243 x_msg_data OUT NOCOPY VARCHAR2,
244 p_polv_tbl IN polv_tbl_type);
245 PROCEDURE validate_row(
246 p_api_version IN NUMBER,
247 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
248 x_return_status OUT NOCOPY VARCHAR2,
249 x_msg_count OUT NOCOPY NUMBER,
250 x_msg_data OUT NOCOPY VARCHAR2,
251 p_polv_rec IN polv_rec_type);
252 PROCEDURE validate_row(
253 p_api_version IN NUMBER,
254 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
255 x_return_status OUT NOCOPY VARCHAR2,
256 x_msg_count OUT NOCOPY NUMBER,
257 x_msg_data OUT NOCOPY VARCHAR2,
258 p_polv_tbl IN polv_tbl_type,
259 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
260 PROCEDURE validate_row(
261 p_api_version IN NUMBER,
262 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
263 x_return_status OUT NOCOPY VARCHAR2,
264 x_msg_count OUT NOCOPY NUMBER,
265 x_msg_data OUT NOCOPY VARCHAR2,
266 p_polv_tbl IN polv_tbl_type);
267 END OKL_POL_PVT;