[Home] [Help]
PACKAGE: APPS.OKL_CREDIT_CHECKLIST_PVT
Source
1 PACKAGE OKL_CREDIT_CHECKLIST_PVT AS
2 /* $Header: OKLRCLCS.pls 120.1 2005/05/27 17:06:11 cklee noship $ */
3 ----------------------------------------------------------------------------
4 -- GLOBAL VARIABLES
5 ----------------------------------------------------------------------------
6 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_CREDIT_CHECKLIST_PVT';
7 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
8
9 G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
10 G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_UNEXP_ERROR;
11 G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_ERROR;
12 G_EXCEPTION_ERROR EXCEPTION;
13 G_EXCEPTION_UNEXPECTED_ERROR EXCEPTION;
14
15 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(30) := 'OKL_UNEXPECTED_ERROR';
16 G_SQLERRM_TOKEN CONSTANT VARCHAR2(30) := 'OKL_SQLERRM';
17 G_SQLCODE_TOKEN CONSTANT VARCHAR2(30) := 'OKL_SQLCODE';
18
19 G_EXC_NAME_OTHERS CONSTANT VARCHAR2(6) := 'OTHERS';
20 G_API_TYPE CONSTANT VARCHAR(4) := '_PVT';
21
22 G_UI_DATE_MASK VARCHAR2(15) := fnd_profile.value('ICX_DATE_FORMAT_MASK');
23 G_OKL_LLA_INVALID_DATE_FORMAT CONSTANT VARCHAR2(30) := 'OKL_LLA_INVALID_DATE_FORMAT';
24 G_NOT_UNIQUE CONSTANT VARCHAR2(30) := 'OKL_LLA_NOT_UNIQUE';
25 G_REQUIRED_VALUE CONSTANT VARCHAR2(30) := 'OKL_REQUIRED_VALUE';
26 G_LLA_RANGE_CHECK CONSTANT VARCHAR2(30) := 'OKL_LLA_RANGE_CHECK';
27 G_INVALID_VALUE CONSTANT VARCHAR2(30) := OKL_API.G_INVALID_VALUE;
28 G_COL_NAME_TOKEN CONSTANT VARCHAR2(30) := OKL_API.G_COL_NAME_TOKEN;
29
30 ----------------------------------------------------------------------------
31 -- Data Structures
32 ----------------------------------------------------------------------------
33
34 TYPE rulv_rec_type IS RECORD (
35 id NUMBER := OKC_API.G_MISS_NUM,
36 -- object_version_number NUMBER := OKC_API.G_MISS_NUM,
37 -- sfwt_flag OKC_RULES_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
38 object1_id1 OKC_RULES_V.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
39 -- object2_id1 OKC_RULES_V.OBJECT2_ID1%TYPE := OKC_API.G_MISS_CHAR,
40 -- object3_id1 OKC_RULES_V.OBJECT3_ID1%TYPE := OKC_API.G_MISS_CHAR,
41 object1_id2 OKC_RULES_V.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
42 -- object2_id2 OKC_RULES_V.OBJECT2_ID2%TYPE := OKC_API.G_MISS_CHAR,
43 -- object3_id2 OKC_RULES_V.OBJECT3_ID2%TYPE := OKC_API.G_MISS_CHAR,
44 -- jtot_object1_code OKC_RULES_V.JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR,
45 -- jtot_object2_code OKC_RULES_V.JTOT_OBJECT2_CODE%TYPE := OKC_API.G_MISS_CHAR,
46 -- jtot_object3_code OKC_RULES_V.JTOT_OBJECT3_CODE%TYPE := OKC_API.G_MISS_CHAR,
47 dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
48 rgp_id NUMBER := OKC_API.G_MISS_NUM,
49 -- priority NUMBER := OKC_API.G_MISS_NUM,
50 -- std_template_yn OKC_RULES_V.STD_TEMPLATE_YN%TYPE := OKC_API.G_MISS_CHAR,
51 -- comments OKC_RULES_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
52 -- warn_yn OKC_RULES_V.WARN_YN%TYPE := OKC_API.G_MISS_CHAR,
53 -- attribute_category OKC_RULES_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
54 -- attribute1 OKC_RULES_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
55 -- attribute2 OKC_RULES_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
56 -- attribute3 OKC_RULES_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
57 -- attribute4 OKC_RULES_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
58 -- attribute5 OKC_RULES_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
59 -- attribute6 OKC_RULES_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
60 -- attribute7 OKC_RULES_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
61 -- attribute8 OKC_RULES_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
62 -- attribute9 OKC_RULES_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
63 -- attribute10 OKC_RULES_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
64 -- attribute11 OKC_RULES_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
65 -- attribute12 OKC_RULES_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
66 -- attribute13 OKC_RULES_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
67 -- attribute14 OKC_RULES_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
68 -- attribute15 OKC_RULES_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
69 -- created_by NUMBER := OKC_API.G_MISS_NUM,
70 -- creation_date OKC_RULES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
71 -- last_updated_by NUMBER := OKC_API.G_MISS_NUM,
72 -- last_update_date OKC_RULES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
73 -- last_update_login NUMBER := OKC_API.G_MISS_NUM,
74 --text OKC_RULES_V.TEXT%TYPE := NULL,
75 rule_information_category OKC_RULES_V.RULE_INFORMATION_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
76 rule_information1 OKC_RULES_V.RULE_INFORMATION1%TYPE := OKC_API.G_MISS_CHAR,
77 rule_information2 OKC_RULES_V.RULE_INFORMATION2%TYPE := OKC_API.G_MISS_CHAR,
78 rule_information3 OKC_RULES_V.RULE_INFORMATION3%TYPE := OKC_API.G_MISS_CHAR,
79 rule_information4 OKC_RULES_V.RULE_INFORMATION4%TYPE := OKC_API.G_MISS_CHAR,
80 rule_information5 OKC_RULES_V.RULE_INFORMATION5%TYPE := OKC_API.G_MISS_CHAR,
81 rule_information6 OKC_RULES_V.RULE_INFORMATION6%TYPE := OKC_API.G_MISS_CHAR,
82 rule_information7 OKC_RULES_V.RULE_INFORMATION7%TYPE := OKC_API.G_MISS_CHAR,
83 rule_information8 OKC_RULES_V.RULE_INFORMATION8%TYPE := OKC_API.G_MISS_CHAR,
84 rule_information9 OKC_RULES_V.RULE_INFORMATION9%TYPE := OKC_API.G_MISS_CHAR,
85 rule_information10 OKC_RULES_V.RULE_INFORMATION10%TYPE := OKC_API.G_MISS_CHAR,
86 rule_information11 OKC_RULES_V.RULE_INFORMATION11%TYPE := OKC_API.G_MISS_CHAR,
87 rule_information12 OKC_RULES_V.RULE_INFORMATION12%TYPE := OKC_API.G_MISS_CHAR,
88 rule_information13 OKC_RULES_V.RULE_INFORMATION13%TYPE := OKC_API.G_MISS_CHAR,
89 rule_information14 OKC_RULES_V.RULE_INFORMATION14%TYPE := OKC_API.G_MISS_CHAR,
90 rule_information15 OKC_RULES_V.RULE_INFORMATION15%TYPE := OKC_API.G_MISS_CHAR,
91 -- template_yn OKC_RULES_B.TEMPLATE_YN%TYPE := OKC_API.G_MISS_CHAR,
92 -- ans_set_jtot_object_code OKC_RULES_B.ans_set_jtot_object_code%TYPE := OKC_API.G_MISS_CHAR,
93 -- ans_set_jtot_object_id1 OKC_RULES_B.ans_set_jtot_object_id1%TYPE := OKC_API.G_MISS_CHAR,
94 -- ans_set_jtot_object_id2 OKC_RULES_B.ans_set_jtot_object_id2%TYPE := OKC_API.G_MISS_CHAR,
95 display_sequence NUMBER:= OKC_API.G_MISS_NUM
96 );
97
98 g_miss_rulv_rec rulv_rec_type;
99
100 TYPE rulv_tbl_type IS TABLE OF rulv_rec_type INDEX BY BINARY_INTEGER;
101
102 ----------------------------------------------------------------------------
103 -- Global Exception
104 ----------------------------------------------------------------------------
105 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
106
107 ----------------------------------------------------------------------------
108 -- Procedures and Functions
109 ------------------------------------------------------------------------------
110 ----------------------------------------------------------------------------------
111 -- Start of comments
112 --
113 -- Procedure Name : create_credit_chklst
114 -- Description : wrapper api for create credit checklists associated
115 -- with credit line contract ID
116 -- Business Rules :
117 -- Parameters :
118 -- Version : 1.0
119 -- End of comments
120 ----------------------------------------------------------------------------------
121 PROCEDURE create_credit_chklst(
122 p_api_version IN NUMBER
123 ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
124 ,x_return_status OUT NOCOPY VARCHAR2
125 ,x_msg_count OUT NOCOPY NUMBER
126 ,x_msg_data OUT NOCOPY VARCHAR2
127 ,p_rulv_tbl IN rulv_tbl_type
128 ,x_rulv_tbl OUT NOCOPY rulv_tbl_type
129 );
130
131 ----------------------------------------------------------------------------------
132 -- Start of comments
133 --
134 -- Procedure Name : update_credit_chklst
135 -- Description : wrapper api for update credit checklists associated
136 -- with credit line contract ID
137 -- Business Rules :
138 -- Parameters :
139 -- Version : 1.0
140 -- End of comments
141 ----------------------------------------------------------------------------------
142 PROCEDURE update_credit_chklst(
143 p_api_version IN NUMBER
144 ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
145 ,x_return_status OUT NOCOPY VARCHAR2
146 ,x_msg_count OUT NOCOPY NUMBER
147 ,x_msg_data OUT NOCOPY VARCHAR2
148 ,p_rulv_tbl IN rulv_tbl_type
149 ,x_rulv_tbl OUT NOCOPY rulv_tbl_type
150 );
151
152 ----------------------------------------------------------------------------------
153 -- Start of comments
154 --
155 -- Procedure Name : delete_credit_chklst
156 -- Description : wrapper api for delete credit checklists associated
157 -- with credit line contract ID
158 -- Business Rules :
159 -- Parameters :
160 -- Version : 1.0
161 -- End of comments
162 ----------------------------------------------------------------------------------
163 PROCEDURE delete_credit_chklst(
164 p_api_version IN NUMBER
165 ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
166 ,x_return_status OUT NOCOPY VARCHAR2
167 ,x_msg_count OUT NOCOPY NUMBER
168 ,x_msg_data OUT NOCOPY VARCHAR2
169 ,p_rulv_tbl IN rulv_tbl_type
170 );
171
172 ----------------------------------------------------------------------------------
173 -- Start of comments
174 --
175 -- Procedure Name : approve_credit_chklst
176 -- Description : set credit line checklist sttaus to "Active".
177 -- Business Rules :
178 -- Parameters :
179 -- Version : 1.0
180 -- End of comments
181 ----------------------------------------------------------------------------------
182 PROCEDURE approve_credit_chklst(
183 p_api_version IN NUMBER
184 ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
185 ,x_return_status OUT NOCOPY VARCHAR2
186 ,x_msg_count OUT NOCOPY NUMBER
187 ,x_msg_data OUT NOCOPY VARCHAR2
188 ,p_rulv_rec IN rulv_rec_type
189 );
190 ----------------------------------------------------------------------------------
191 -- Start of comments
192 --
193 -- Procedure Name : update_fund_chklst_tpl_hdr
194 -- Description : wrapper api for update funding checklists template header associated
195 -- with credit line contract ID
196 -- Business Rules :
197 -- Parameters :
198 -- Version : 1.0
199 -- End of comments
200 ----------------------------------------------------------------------------------
201 PROCEDURE update_fund_chklst_tpl_hdr(
202 p_api_version IN NUMBER
203 ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
204 ,x_return_status OUT NOCOPY VARCHAR2
205 ,x_msg_count OUT NOCOPY NUMBER
206 ,x_msg_data OUT NOCOPY VARCHAR2
207 ,p_rulv_tbl IN rulv_tbl_type
208 ,x_rulv_tbl OUT NOCOPY rulv_tbl_type
209 );
210
211 ----------------------------------------------------------------------------------
212 -- Start of comments
213 --
214 -- Procedure Name : update_fund_chklst_tpl_hdr
215 -- Description : wrapper api for update funding checklists template header associated
216 -- with credit line contract ID
217 -- Business Rules :
218 -- Parameters :
219 -- Version : 1.0
220 -- End of comments
221 ----------------------------------------------------------------------------------
222 PROCEDURE update_fund_chklst_tpl_hdr(
223 p_api_version IN NUMBER
224 ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
225 ,x_return_status OUT NOCOPY VARCHAR2
226 ,x_msg_count OUT NOCOPY NUMBER
227 ,x_msg_data OUT NOCOPY VARCHAR2
228 ,p_rulv_rec IN rulv_rec_type
229 ,x_rulv_rec OUT NOCOPY rulv_rec_type
230 );
231
232 ----------------------------------------------------------------------------------
233 -- Start of comments
234 --
235 -- Procedure Name : update_funding_chklst_tpl
236 -- Description : wrapper api for update funding checklists template associated
237 -- with credit line contract ID
238 -- Business Rules :
239 -- Parameters :
240 -- Version : 1.0
241 -- End of comments
242 ----------------------------------------------------------------------------------
243 PROCEDURE update_funding_chklst_tpl(
244 p_api_version IN NUMBER
245 ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
246 ,x_return_status OUT NOCOPY VARCHAR2
247 ,x_msg_count OUT NOCOPY NUMBER
248 ,x_msg_data OUT NOCOPY VARCHAR2
249 ,p_rulv_tbl IN rulv_tbl_type
250 ,x_rulv_tbl OUT NOCOPY rulv_tbl_type
251 );
252
253 ----------------------------------------------------------------------------------
254 -- Start of comments
255 --
256 -- Procedure Name : approve_funding_chklst_tpl
257 -- Description : set funding checklists template status to "Active"
258 -- Business Rules :
259 -- Parameters :
260 -- Version : 1.0
261 -- End of comments
262 ----------------------------------------------------------------------------------
263 PROCEDURE approve_funding_chklst_tpl(
264 p_api_version IN NUMBER
265 ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
266 ,x_return_status OUT NOCOPY VARCHAR2
267 ,x_msg_count OUT NOCOPY NUMBER
268 ,x_msg_data OUT NOCOPY VARCHAR2
269 ,p_rulv_rec IN rulv_rec_type
270 );
271
272 -- start: Apr 25, 2005 cklee: Modification for okl.h lease app enhancement for Authoring - Checklist
273 ----------------------------------------------------------------------------------
274 -- Start of comments
275 --
276 -- Procedure Name : create_funding_chklst_tpl
277 -- Description : wrapper api for create funding checklists template associated
278 -- with credit line contract ID
279 -- Business Rules :
280 -- Parameters :
281 -- Version : 1.0
282 -- End of comments
283 ----------------------------------------------------------------------------------
284 PROCEDURE create_funding_chklst_tpl(
285 p_api_version IN NUMBER
286 ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
287 ,x_return_status OUT NOCOPY VARCHAR2
288 ,x_msg_count OUT NOCOPY NUMBER
289 ,x_msg_data OUT NOCOPY VARCHAR2
290 ,p_rulv_tbl IN rulv_tbl_type
291 ,x_rulv_tbl OUT NOCOPY rulv_tbl_type
292 );
293
294 ---------------------------------------------------------------------------------
295 -- Start of comments
296 --
297 -- Procedure Name : delete_credit_funding_chklst
298 -- Description : wrapper api for delete credit funding checklists associated
299 -- with credit line contract ID
300 -- Business Rules :
301 -- Parameters :
302 -- Version : 1.0
303 -- End of comments
304 ----------------------------------------------------------------------------------
305 PROCEDURE delete_funding_chklst_tpl(
306 p_api_version IN NUMBER
307 ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
308 ,x_return_status OUT NOCOPY VARCHAR2
309 ,x_msg_count OUT NOCOPY NUMBER
310 ,x_msg_data OUT NOCOPY VARCHAR2
311 ,p_rulv_tbl IN rulv_tbl_type
312 );
313 -- end: Apr 25, 2005 cklee: Modification for okl.h lease app enhancement for Authoring - Checklist
314
315 END OKL_CREDIT_CHECKLIST_PVT;