[Home] [Help]
PACKAGE: APPS.OKL_KHR_PVT
Source
1 Package OKL_KHR_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLSKHRS.pls 120.4 2006/11/10 06:17:02 dpsingh noship $ */
3
4 ---------------------------------------------------------------------------
5 -- GLOBAL DATASTRUCTURES
6 ---------------------------------------------------------------------------
7
8 TYPE khr_rec_type IS RECORD (
9 ID NUMBER := OKL_API.G_MISS_NUM,
10 ISG_ID NUMBER := OKL_API.G_MISS_NUM,
11 KHR_ID NUMBER := OKL_API.G_MISS_NUM,
12 PDT_ID NUMBER := OKL_API.G_MISS_NUM,
13 OBJECT_VERSION_NUMBER NUMBER := OKL_API.G_MISS_NUM,
14 DATE_FIRST_ACTIVITY OKL_K_HEADERS.DATE_FIRST_ACTIVITY%TYPE := OKL_API.G_MISS_DATE,
15 SYNDICATABLE_YN OKL_K_HEADERS.SYNDICATABLE_YN%TYPE := OKL_API.G_MISS_CHAR,
16 SALESTYPE_YN OKL_K_HEADERS.SALESTYPE_YN%TYPE := OKL_API.G_MISS_CHAR,
17 DATE_REFINANCED OKL_K_HEADERS.DATE_REFINANCED%TYPE := OKL_API.G_MISS_DATE,
18 DATE_CONVERSION_EFFECTIVE OKL_K_HEADERS.DATE_CONVERSION_EFFECTIVE%TYPE := OKL_API.G_MISS_DATE,
19 DATE_DEAL_TRANSFERRED OKL_K_HEADERS.DATE_DEAL_TRANSFERRED%TYPE := OKL_API.G_MISS_DATE,
20 TERM_DURATION NUMBER := OKL_API.G_MISS_NUM,
21 DATETIME_PROPOSAL_EFFECTIVE OKL_K_HEADERS.DATETIME_PROPOSAL_EFFECTIVE%TYPE := OKL_API.G_MISS_DATE,
22 DATETIME_PROPOSAL_INEFFECTIVE OKL_K_HEADERS.DATETIME_PROPOSAL_INEFFECTIVE%TYPE := OKL_API.G_MISS_DATE,
23 DATE_PROPOSAL_ACCEPTED OKL_K_HEADERS.DATE_PROPOSAL_ACCEPTED%TYPE := OKL_API.G_MISS_DATE,
24 ATTRIBUTE_CATEGORY OKL_K_HEADERS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR,
25 ATTRIBUTE1 OKL_K_HEADERS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR,
26 ATTRIBUTE2 OKL_K_HEADERS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR,
27 ATTRIBUTE3 OKL_K_HEADERS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR,
28 ATTRIBUTE4 OKL_K_HEADERS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR,
29 ATTRIBUTE5 OKL_K_HEADERS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR,
30 ATTRIBUTE6 OKL_K_HEADERS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR,
31 ATTRIBUTE7 OKL_K_HEADERS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR,
32 ATTRIBUTE8 OKL_K_HEADERS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR,
33 ATTRIBUTE9 OKL_K_HEADERS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR,
34 ATTRIBUTE10 OKL_K_HEADERS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR,
35 ATTRIBUTE11 OKL_K_HEADERS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR,
36 ATTRIBUTE12 OKL_K_HEADERS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR,
37 ATTRIBUTE13 OKL_K_HEADERS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR,
38 ATTRIBUTE14 OKL_K_HEADERS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR,
39 ATTRIBUTE15 OKL_K_HEADERS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR,
40 CREATED_BY NUMBER := OKL_API.G_MISS_NUM,
41 CREATION_DATE OKL_K_HEADERS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE,
42 LAST_UPDATED_BY NUMBER := OKL_API.G_MISS_NUM,
43 LAST_UPDATE_DATE OKL_K_HEADERS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE,
44 LAST_UPDATE_LOGIN NUMBER := OKL_API.G_MISS_NUM,
45 AMD_CODE OKL_K_HEADERS.AMD_CODE%TYPE := OKL_API.G_MISS_CHAR,
46 GENERATE_ACCRUAL_YN OKL_K_HEADERS.GENERATE_ACCRUAL_YN%TYPE := OKL_API.G_MISS_CHAR,
47 GENERATE_ACCRUAL_OVERRIDE_YN OKL_K_HEADERS.GENERATE_ACCRUAL_OVERRIDE_YN%TYPE := OKL_API.G_MISS_CHAR,
48 CREDIT_ACT_YN OKL_K_HEADERS.CREDIT_ACT_YN%TYPE := OKL_API.G_MISS_CHAR,
49 CONVERTED_ACCOUNT_YN OKL_K_HEADERS.CONVERTED_ACCOUNT_YN%TYPE := OKL_API.G_MISS_CHAR,
50 PRE_TAX_YIELD NUMBER := OKL_API.G_MISS_NUM,
51 AFTER_TAX_YIELD NUMBER := OKL_API.G_MISS_NUM,
52 IMPLICIT_INTEREST_RATE NUMBER := OKL_API.G_MISS_NUM,
53 IMPLICIT_NON_IDC_INTEREST_RATE NUMBER := OKL_API.G_MISS_NUM,
54 TARGET_PRE_TAX_YIELD NUMBER := OKL_API.G_MISS_NUM,
55 TARGET_AFTER_TAX_YIELD NUMBER := OKL_API.G_MISS_NUM,
56 TARGET_IMPLICIT_INTEREST_RATE NUMBER := OKL_API.G_MISS_NUM,
57 TARGET_IMPLICIT_NONIDC_INTRATE NUMBER := OKL_API.G_MISS_NUM,
58 DATE_LAST_INTERIM_INTEREST_CAL OKL_K_HEADERS.DATE_LAST_INTERIM_INTEREST_CAL%TYPE := OKL_API.G_MISS_DATE,
59 DEAL_TYPE OKL_K_HEADERS.DEAL_TYPE%TYPE := OKL_API.G_MISS_CHAR,
60 PRE_TAX_IRR NUMBER := OKL_API.G_MISS_NUM,
61 AFTER_TAX_IRR NUMBER := OKL_API.G_MISS_NUM,
62 EXPECTED_DELIVERY_DATE OKL_K_HEADERS.EXPECTED_DELIVERY_DATE%TYPE := OKL_API.G_MISS_DATE,
63 ACCEPTED_DATE OKL_K_HEADERS.ACCEPTED_DATE%TYPE := OKL_API.G_MISS_DATE,
64 PREFUNDING_ELIGIBLE_YN OKL_K_HEADERS.PREFUNDING_ELIGIBLE_YN%TYPE := OKL_API.G_MISS_CHAR,
65 REVOLVING_CREDIT_YN OKL_K_HEADERS.REVOLVING_CREDIT_YN%TYPE := OKL_API.G_MISS_CHAR,
66 -- Bug# 2697681 11.5.9 enhancements
67 CURRENCY_CONVERSION_TYPE OKL_K_HEADERS.CURRENCY_CONVERSION_TYPE%TYPE := OKL_API.G_MISS_CHAR,
68 CURRENCY_CONVERSION_RATE NUMBER := OKL_API.G_MISS_NUM,
69 CURRENCY_CONVERSION_DATE OKL_K_HEADERS.CURRENCY_CONVERSION_DATE%TYPE := OKL_API.G_MISS_DATE,
70 MULTI_GAAP_YN OKL_K_HEADERS.MULTI_GAAP_YN%TYPE := OKL_API.G_MISS_CHAR,
71 RECOURSE_CODE OKL_K_HEADERS.RECOURSE_CODE%TYPE := OKL_API.G_MISS_CHAR,
72 LESSOR_SERV_ORG_CODE OKL_K_HEADERS.LESSOR_SERV_ORG_CODE%TYPE := OKL_API.G_MISS_CHAR,
73 ASSIGNABLE_YN OKL_K_HEADERS.ASSIGNABLE_YN%TYPE := OKL_API.G_MISS_CHAR,
74 SECURITIZED_CODE OKL_K_HEADERS.SECURITIZED_CODE%TYPE := OKL_API.G_MISS_CHAR,
75 SECURITIZATION_TYPE OKL_K_HEADERS.SECURITIZATION_TYPE%TYPE := OKL_API.G_MISS_CHAR,
76 -- Bug# 3143522 : 11.5.10
77 --subsidy
78 SUB_PRE_TAX_YIELD NUMBER := OKL_API.G_MISS_NUM,
79 SUB_AFTER_TAX_YIELD NUMBER := OKL_API.G_MISS_NUM,
80 SUB_IMPL_INTEREST_RATE NUMBER := OKL_API.G_MISS_NUM,
81 SUB_IMPL_NON_IDC_INT_RATE NUMBER := OKL_API.G_MISS_NUM,
82 SUB_PRE_TAX_IRR NUMBER := OKL_API.G_MISS_NUM,
83 SUB_AFTER_TAX_IRR NUMBER := OKL_API.G_MISS_NUM,
84 -- Bug# Rollover fix
85 -- Rollover
86 TOT_CL_TRANSFER_AMT NUMBER := OKL_API.G_MISS_NUM,
87 TOT_CL_NET_TRANSFER_AMT NUMBER := OKL_API.G_MISS_NUM,
88 TOT_CL_LIMIT NUMBER := OKL_API.G_MISS_NUM,
89 TOT_CL_FUNDING_AMT NUMBER := OKL_API.G_MISS_NUM,
90 -- Added by Manu
91 CRS_ID NUMBER := OKL_API.G_MISS_NUM,
92 TEMPLATE_TYPE_CODE OKL_K_HEADERS.TEMPLATE_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR,
93 --Bug# 4419339 OKLH Schema Sales Quote
94 DATE_FUNDING_EXPECTED DATE := OKL_API.G_MISS_DATE,
95 DATE_TRADEIN DATE := OKL_API.G_MISS_DATE,
96 TRADEIN_AMOUNT NUMBER := OKL_API.G_MISS_NUM,
97 TRADEIN_DESCRIPTION OKL_K_HEADERS.TRADEIN_DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR,
98 --Added by dpsingh for LE uptake
99 LEGAL_ENTITY_ID NUMBER := Okl_Api.G_MISS_NUM
100 );
101
102 g_miss_khr_rec khr_rec_type;
103
104 TYPE khr_tbl_type IS TABLE OF khr_rec_type INDEX BY BINARY_INTEGER;
105
106 TYPE okl_k_headers_h_rec_type IS RECORD (
107 ID NUMBER := OKL_API.G_MISS_NUM,
108 MAJOR_VERSION NUMBER := OKL_API.G_MISS_NUM,
109 ISG_ID NUMBER := OKL_API.G_MISS_NUM,
110 KHR_ID NUMBER := OKL_API.G_MISS_NUM,
111 PDT_ID NUMBER := OKL_API.G_MISS_NUM,
112 OBJECT_VERSION_NUMBER NUMBER := OKL_API.G_MISS_NUM,
113 DATE_FIRST_ACTIVITY OKL_K_HEADERS_H.DATE_FIRST_ACTIVITY%TYPE := OKL_API.G_MISS_DATE,
114 SYNDICATABLE_YN OKL_K_HEADERS_H.SYNDICATABLE_YN%TYPE := OKL_API.G_MISS_CHAR,
115 SALESTYPE_YN OKL_K_HEADERS_H.SALESTYPE_YN%TYPE := OKL_API.G_MISS_CHAR,
116 DATE_REFINANCED OKL_K_HEADERS_H.DATE_REFINANCED%TYPE := OKL_API.G_MISS_DATE,
117 DATE_CONVERSION_EFFECTIVE OKL_K_HEADERS_H.DATE_CONVERSION_EFFECTIVE%TYPE := OKL_API.G_MISS_DATE,
118 DATE_DEAL_TRANSFERRED OKL_K_HEADERS_H.DATE_DEAL_TRANSFERRED%TYPE := OKL_API.G_MISS_DATE,
119 TERM_DURATION NUMBER := OKL_API.G_MISS_NUM,
120 DATETIME_PROPOSAL_EFFECTIVE OKL_K_HEADERS_H.DATETIME_PROPOSAL_EFFECTIVE%TYPE := OKL_API.G_MISS_DATE,
121 DATETIME_PROPOSAL_INEFFECTIVE OKL_K_HEADERS_H.DATETIME_PROPOSAL_INEFFECTIVE%TYPE := OKL_API.G_MISS_DATE,
122 DATE_PROPOSAL_ACCEPTED OKL_K_HEADERS_H.DATE_PROPOSAL_ACCEPTED%TYPE := OKL_API.G_MISS_DATE,
123 ATTRIBUTE_CATEGORY OKL_K_HEADERS_H.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR,
124 ATTRIBUTE1 OKL_K_HEADERS_H.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR,
125 ATTRIBUTE2 OKL_K_HEADERS_H.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR,
126 ATTRIBUTE3 OKL_K_HEADERS_H.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR,
127 ATTRIBUTE4 OKL_K_HEADERS_H.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR,
128 ATTRIBUTE5 OKL_K_HEADERS_H.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR,
129 ATTRIBUTE6 OKL_K_HEADERS_H.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR,
130 ATTRIBUTE7 OKL_K_HEADERS_H.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR,
131 ATTRIBUTE8 OKL_K_HEADERS_H.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR,
132 ATTRIBUTE9 OKL_K_HEADERS_H.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR,
133 ATTRIBUTE10 OKL_K_HEADERS_H.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR,
134 ATTRIBUTE11 OKL_K_HEADERS_H.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR,
135 ATTRIBUTE12 OKL_K_HEADERS_H.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR,
136 ATTRIBUTE13 OKL_K_HEADERS_H.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR,
137 ATTRIBUTE14 OKL_K_HEADERS_H.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR,
138 ATTRIBUTE15 OKL_K_HEADERS_H.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR,
139 CREATED_BY NUMBER := OKL_API.G_MISS_NUM,
140 CREATION_DATE OKL_K_HEADERS_H.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE,
141 LAST_UPDATED_BY NUMBER := OKL_API.G_MISS_NUM,
142 LAST_UPDATE_DATE OKL_K_HEADERS_H.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE,
143 LAST_UPDATE_LOGIN NUMBER := OKL_API.G_MISS_NUM,
144 AMD_CODE OKL_K_HEADERS_H.AMD_CODE%TYPE := OKL_API.G_MISS_CHAR,
145 GENERATE_ACCRUAL_YN OKL_K_HEADERS_H.GENERATE_ACCRUAL_YN%TYPE := OKL_API.G_MISS_CHAR,
146 GENERATE_ACCRUAL_OVERRIDE_YN OKL_K_HEADERS_H.GENERATE_ACCRUAL_OVERRIDE_YN%TYPE := OKL_API.G_MISS_CHAR,
147 CREDIT_ACT_YN OKL_K_HEADERS_H.CREDIT_ACT_YN%TYPE := OKL_API.G_MISS_CHAR,
148 CONVERTED_ACCOUNT_YN OKL_K_HEADERS_H.CONVERTED_ACCOUNT_YN%TYPE := OKL_API.G_MISS_CHAR,
149 PRE_TAX_YIELD NUMBER := OKL_API.G_MISS_NUM,
150 AFTER_TAX_YIELD NUMBER := OKL_API.G_MISS_NUM,
151 IMPLICIT_INTEREST_RATE NUMBER := OKL_API.G_MISS_NUM,
152 IMPLICIT_NON_IDC_INTEREST_RATE NUMBER := OKL_API.G_MISS_NUM,
153 TARGET_PRE_TAX_YIELD NUMBER := OKL_API.G_MISS_NUM,
154 TARGET_AFTER_TAX_YIELD NUMBER := OKL_API.G_MISS_NUM,
155 TARGET_IMPLICIT_INTEREST_RATE NUMBER := OKL_API.G_MISS_NUM,
156 TARGET_IMPLICIT_NONIDC_INTRATE NUMBER := OKL_API.G_MISS_NUM,
157 DATE_LAST_INTERIM_INTEREST_CAL OKL_K_HEADERS_H.DATE_LAST_INTERIM_INTEREST_CAL%TYPE := OKL_API.G_MISS_DATE,
158 DEAL_TYPE OKL_K_HEADERS_H.DEAL_TYPE%TYPE := OKL_API.G_MISS_CHAR,
159 PRE_TAX_IRR NUMBER := OKL_API.G_MISS_NUM,
160 AFTER_TAX_IRR NUMBER := OKL_API.G_MISS_NUM,
161 EXPECTED_DELIVERY_DATE OKL_K_HEADERS_H.EXPECTED_DELIVERY_DATE%TYPE := OKL_API.G_MISS_DATE,
162 ACCEPTED_DATE OKL_K_HEADERS_H.ACCEPTED_DATE%TYPE := OKL_API.G_MISS_DATE,
163 PREFUNDING_ELIGIBLE_YN OKL_K_HEADERS_H.PREFUNDING_ELIGIBLE_YN%TYPE := OKL_API.G_MISS_CHAR,
164 REVOLVING_CREDIT_YN OKL_K_HEADERS_H.REVOLVING_CREDIT_YN%TYPE := OKL_API.G_MISS_CHAR,
165 -- Bug# 2697681 schema changes 11.5.9 enhancements
166 CURRENCY_CONVERSION_TYPE OKL_K_HEADERS_H.CURRENCY_CONVERSION_TYPE%TYPE := OKL_API.G_MISS_CHAR,
167 CURRENCY_CONVERSION_RATE NUMBER := OKL_API.G_MISS_NUM,
168 CURRENCY_CONVERSION_DATE OKL_K_HEADERS_H.CURRENCY_CONVERSION_DATE%TYPE := OKL_API.G_MISS_DATE,
169 MULTI_GAAP_YN OKL_K_HEADERS_H.MULTI_GAAP_YN%TYPE := OKL_API.G_MISS_CHAR,
170 RECOURSE_CODE OKL_K_HEADERS_H.RECOURSE_CODE%TYPE := OKL_API.G_MISS_CHAR,
171 LESSOR_SERV_ORG_CODE OKL_K_HEADERS_H.LESSOR_SERV_ORG_CODE%TYPE := OKL_API.G_MISS_CHAR,
172 ASSIGNABLE_YN OKL_K_HEADERS_H.ASSIGNABLE_YN%TYPE := OKL_API.G_MISS_CHAR,
173 SECURITIZED_CODE OKL_K_HEADERS_H.SECURITIZED_CODE%TYPE := OKL_API.G_MISS_CHAR,
174 SECURITIZATION_TYPE OKL_K_HEADERS_H.SECURITIZATION_TYPE%TYPE := OKL_API.G_MISS_CHAR,
175 -- Bug#3143522 : 11.5.10
176 --subsidy
177 SUB_PRE_TAX_YIELD NUMBER := OKL_API.G_MISS_NUM,
178 SUB_AFTER_TAX_YIELD NUMBER := OKL_API.G_MISS_NUM,
179 SUB_IMPL_INTEREST_RATE NUMBER := OKL_API.G_MISS_NUM,
180 SUB_IMPL_NON_IDC_INT_RATE NUMBER := OKL_API.G_MISS_NUM,
181 SUB_PRE_TAX_IRR NUMBER := OKL_API.G_MISS_NUM,
182 SUB_AFTER_TAX_IRR NUMBER := OKL_API.G_MISS_NUM,
183 -- Bug# Rollover fix
184 -- Rollover
185 TOT_CL_TRANSFER_AMT NUMBER := OKL_API.G_MISS_NUM,
186 TOT_CL_NET_TRANSFER_AMT NUMBER := OKL_API.G_MISS_NUM,
187 TOT_CL_LIMIT NUMBER := OKL_API.G_MISS_NUM,
188 TOT_CL_FUNDING_AMT NUMBER := OKL_API.G_MISS_NUM,
189 -- Added by Manu
190 CRS_ID NUMBER := OKL_API.G_MISS_NUM,
191 TEMPLATE_TYPE_CODE OKL_K_HEADERS.TEMPLATE_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR,
192 --Bug# 4419339 OKLH Schema Sales Quote
193 DATE_FUNDING_EXPECTED DATE := OKL_API.G_MISS_DATE,
194 DATE_TRADEIN DATE := OKL_API.G_MISS_DATE,
195 TRADEIN_AMOUNT NUMBER := OKL_API.G_MISS_NUM,
196 TRADEIN_DESCRIPTION OKL_K_HEADERS.TRADEIN_DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR,
197 --Added by dpsingh for LE uptake
198 LEGAL_ENTITY_ID NUMBER := Okl_Api.G_MISS_NUM
199 );
200
201 g_miss_okl_k_headers_h_rec okl_k_headers_h_rec_type;
202
203 TYPE okl_k_headers_h_tbl_type IS TABLE OF okl_k_headers_h_rec_type INDEX BY BINARY_INTEGER;
204
205 TYPE khrv_rec_type IS RECORD (
206 ID NUMBER := OKL_API.G_MISS_NUM,
207 OBJECT_VERSION_NUMBER NUMBER := OKL_API.G_MISS_NUM,
208 ISG_ID NUMBER := OKL_API.G_MISS_NUM,
209 KHR_ID NUMBER := OKL_API.G_MISS_NUM,
210 PDT_ID NUMBER := OKL_API.G_MISS_NUM,
211 AMD_CODE OKL_K_HEADERS_V.AMD_CODE%TYPE := OKL_API.G_MISS_CHAR,
212 DATE_FIRST_ACTIVITY OKL_K_HEADERS_V.DATE_FIRST_ACTIVITY%TYPE := OKL_API.G_MISS_DATE,
213 GENERATE_ACCRUAL_YN OKL_K_HEADERS_V.GENERATE_ACCRUAL_YN%TYPE := OKL_API.G_MISS_CHAR,
214 GENERATE_ACCRUAL_OVERRIDE_YN OKL_K_HEADERS_V.GENERATE_ACCRUAL_OVERRIDE_YN%TYPE := OKL_API.G_MISS_CHAR,
215 DATE_REFINANCED OKL_K_HEADERS_V.DATE_REFINANCED%TYPE := OKL_API.G_MISS_DATE,
216 CREDIT_ACT_YN OKL_K_HEADERS_V.CREDIT_ACT_YN%TYPE := OKL_API.G_MISS_CHAR,
217 TERM_DURATION NUMBER := OKL_API.G_MISS_NUM,
218 CONVERTED_ACCOUNT_YN OKL_K_HEADERS_V.CONVERTED_ACCOUNT_YN%TYPE := OKL_API.G_MISS_CHAR,
219 DATE_CONVERSION_EFFECTIVE OKL_K_HEADERS_V.DATE_CONVERSION_EFFECTIVE%TYPE := OKL_API.G_MISS_DATE,
220 SYNDICATABLE_YN OKL_K_HEADERS_V.SYNDICATABLE_YN%TYPE := OKL_API.G_MISS_CHAR,
221 SALESTYPE_YN OKL_K_HEADERS_V.SALESTYPE_YN%TYPE := OKL_API.G_MISS_CHAR,
222 DATE_DEAL_TRANSFERRED OKL_K_HEADERS_V.DATE_DEAL_TRANSFERRED%TYPE := OKL_API.G_MISS_DATE,
223 DATETIME_PROPOSAL_EFFECTIVE OKL_K_HEADERS_V.DATETIME_PROPOSAL_EFFECTIVE%TYPE := OKL_API.G_MISS_DATE,
224 DATETIME_PROPOSAL_INEFFECTIVE OKL_K_HEADERS_V.DATETIME_PROPOSAL_INEFFECTIVE%TYPE := OKL_API.G_MISS_DATE,
225 DATE_PROPOSAL_ACCEPTED OKL_K_HEADERS_V.DATE_PROPOSAL_ACCEPTED%TYPE := OKL_API.G_MISS_DATE,
226 ATTRIBUTE_CATEGORY OKL_K_HEADERS_V.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR,
227 ATTRIBUTE1 OKL_K_HEADERS_V.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR,
228 ATTRIBUTE2 OKL_K_HEADERS_V.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR,
229 ATTRIBUTE3 OKL_K_HEADERS_V.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR,
230 ATTRIBUTE4 OKL_K_HEADERS_V.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR,
231 ATTRIBUTE5 OKL_K_HEADERS_V.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR,
232 ATTRIBUTE6 OKL_K_HEADERS_V.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR,
233 ATTRIBUTE7 OKL_K_HEADERS_V.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR,
234 ATTRIBUTE8 OKL_K_HEADERS_V.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR,
235 ATTRIBUTE9 OKL_K_HEADERS_V.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR,
236 ATTRIBUTE10 OKL_K_HEADERS_V.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR,
237 ATTRIBUTE11 OKL_K_HEADERS_V.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR,
238 ATTRIBUTE12 OKL_K_HEADERS_V.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR,
239 ATTRIBUTE13 OKL_K_HEADERS_V.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR,
240 ATTRIBUTE14 OKL_K_HEADERS_V.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR,
241 ATTRIBUTE15 OKL_K_HEADERS_V.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR,
242 CREATED_BY NUMBER := OKL_API.G_MISS_NUM,
243 CREATION_DATE OKL_K_HEADERS_V.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE,
244 LAST_UPDATED_BY NUMBER := OKL_API.G_MISS_NUM,
245 LAST_UPDATE_DATE OKL_K_HEADERS_V.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE,
246 LAST_UPDATE_LOGIN NUMBER := OKL_API.G_MISS_NUM,
247 PRE_TAX_YIELD NUMBER := OKL_API.G_MISS_NUM,
248 AFTER_TAX_YIELD NUMBER := OKL_API.G_MISS_NUM,
249 IMPLICIT_INTEREST_RATE NUMBER := OKL_API.G_MISS_NUM,
250 IMPLICIT_NON_IDC_INTEREST_RATE NUMBER := OKL_API.G_MISS_NUM,
251 TARGET_PRE_TAX_YIELD NUMBER := OKL_API.G_MISS_NUM,
252 TARGET_AFTER_TAX_YIELD NUMBER := OKL_API.G_MISS_NUM,
253 TARGET_IMPLICIT_INTEREST_RATE NUMBER := OKL_API.G_MISS_NUM,
254 TARGET_IMPLICIT_NONIDC_INTRATE NUMBER := OKL_API.G_MISS_NUM,
255 DATE_LAST_INTERIM_INTEREST_CAL OKL_K_HEADERS_V.DATE_LAST_INTERIM_INTEREST_CAL%TYPE := OKL_API.G_MISS_DATE,
256 DEAL_TYPE OKL_K_HEADERS_V.DEAL_TYPE%TYPE := OKL_API.G_MISS_CHAR,
257 PRE_TAX_IRR NUMBER := OKL_API.G_MISS_NUM,
258 AFTER_TAX_IRR NUMBER := OKL_API.G_MISS_NUM,
259 EXPECTED_DELIVERY_DATE OKL_K_HEADERS_V.EXPECTED_DELIVERY_DATE%TYPE := OKL_API.G_MISS_DATE,
260 ACCEPTED_DATE OKL_K_HEADERS_V.ACCEPTED_DATE%TYPE := OKL_API.G_MISS_DATE,
261 PREFUNDING_ELIGIBLE_YN OKL_K_HEADERS_V.PREFUNDING_ELIGIBLE_YN%TYPE := OKL_API.G_MISS_CHAR,
262 REVOLVING_CREDIT_YN OKL_K_HEADERS_V.REVOLVING_CREDIT_YN%TYPE := OKL_API.G_MISS_CHAR,
263 ---- Bug# 2697681 schema changes 11.5.9 enhancements
264 CURRENCY_CONVERSION_TYPE OKL_K_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE := OKL_API.G_MISS_CHAR,
265 CURRENCY_CONVERSION_RATE NUMBER := OKL_API.G_MISS_NUM,
266 CURRENCY_CONVERSION_DATE OKL_K_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE := OKL_API.G_MISS_DATE,
267 MULTI_GAAP_YN OKL_K_HEADERS_V.MULTI_GAAP_YN%TYPE := OKL_API.G_MISS_CHAR,
268 RECOURSE_CODE OKL_K_HEADERS_V.RECOURSE_CODE%TYPE := OKL_API.G_MISS_CHAR,
269 LESSOR_SERV_ORG_CODE OKL_K_HEADERS_V.LESSOR_SERV_ORG_CODE%TYPE := OKL_API.G_MISS_CHAR,
270 ASSIGNABLE_YN OKL_K_HEADERS_V.ASSIGNABLE_YN%TYPE := OKL_API.G_MISS_CHAR,
271 SECURITIZED_CODE OKL_K_HEADERS_V.SECURITIZED_CODE%TYPE := OKL_API.G_MISS_CHAR,
272 SECURITIZATION_TYPE OKL_K_HEADERS_V.SECURITIZATION_TYPE%TYPE := OKL_API.G_MISS_CHAR,
273 -- Bug#3143522 : 11.5.10
274 --subsidy
275 SUB_PRE_TAX_YIELD NUMBER := OKL_API.G_MISS_NUM,
276 SUB_AFTER_TAX_YIELD NUMBER := OKL_API.G_MISS_NUM,
277 SUB_IMPL_INTEREST_RATE NUMBER := OKL_API.G_MISS_NUM,
278 SUB_IMPL_NON_IDC_INT_RATE NUMBER := OKL_API.G_MISS_NUM,
279 SUB_PRE_TAX_IRR NUMBER := OKL_API.G_MISS_NUM,
280 SUB_AFTER_TAX_IRR NUMBER := OKL_API.G_MISS_NUM,
281 -- Bug# Rollover fix
282 -- Rollover
283 TOT_CL_TRANSFER_AMT NUMBER := OKL_API.G_MISS_NUM,
284 TOT_CL_NET_TRANSFER_AMT NUMBER := OKL_API.G_MISS_NUM,
285 TOT_CL_LIMIT NUMBER := OKL_API.G_MISS_NUM,
286 TOT_CL_FUNDING_AMT NUMBER := OKL_API.G_MISS_NUM,
287 -- Added by Manu
288 CRS_ID NUMBER := OKL_API.G_MISS_NUM,
289 TEMPLATE_TYPE_CODE OKL_K_HEADERS.TEMPLATE_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR,
290 --Bug# 4419339 OKLH Schema Sales Quote
291 DATE_FUNDING_EXPECTED DATE := OKL_API.G_MISS_DATE,
292 DATE_TRADEIN DATE := OKL_API.G_MISS_DATE,
293 TRADEIN_AMOUNT NUMBER := OKL_API.G_MISS_NUM,
294 TRADEIN_DESCRIPTION OKL_K_HEADERS.TRADEIN_DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR,
295 --Bug# 4558486
296 VALIDATE_DFF_YN VARCHAR(3) := OKL_API.G_MISS_CHAR,
297
298 --Added by dpsingh for LE uptake
299 LEGAL_ENTITY_ID NUMBER := Okl_Api.G_MISS_NUM
300 );
301
302 g_miss_khrv_rec khrv_rec_type;
303
304 TYPE khrv_tbl_type IS TABLE OF khrv_rec_type INDEX BY BINARY_INTEGER;
305
306 ---------------------------------------------------------------------------
307 -- GLOBAL MESSAGE CONSTANTS
308 ---------------------------------------------------------------------------
309 G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
310 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
311 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
312 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
313 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
314 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
315 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
316 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
317 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
318 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
319
320 ---------------------------------------------------------------------------
321 -- GLOBAL VARIABLES
322 ---------------------------------------------------------------------------
323 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_KHR_PVT';
324 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
325
326 ---------------------------------------------------------------------------
327 -- Procedures and Functions
328 ---------------------------------------------------------------------------
329
330 PROCEDURE qc;
331 PROCEDURE change_version;
332 PROCEDURE api_copy;
333
334
335 PROCEDURE insert_row(
336
337 p_api_version IN NUMBER,
338 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
339 x_return_status OUT NOCOPY VARCHAR2,
340 x_msg_count OUT NOCOPY NUMBER,
341 x_msg_data OUT NOCOPY VARCHAR2,
342 p_khrv_rec IN khrv_rec_type,
343 x_khrv_rec OUT NOCOPY khrv_rec_type);
344
345 PROCEDURE insert_row(
346
347 p_api_version IN NUMBER,
348 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
349 x_return_status OUT NOCOPY VARCHAR2,
350 x_msg_count OUT NOCOPY NUMBER,
351 x_msg_data OUT NOCOPY VARCHAR2,
352 p_khrv_tbl IN khrv_tbl_type,
353 x_khrv_tbl OUT NOCOPY khrv_tbl_type);
354
355 PROCEDURE update_row(
356
357 p_api_version IN NUMBER,
358 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
359 x_return_status OUT NOCOPY VARCHAR2,
360 x_msg_count OUT NOCOPY NUMBER,
361 x_msg_data OUT NOCOPY VARCHAR2,
362 p_khrv_rec IN khrv_rec_type,
363 x_khrv_rec OUT NOCOPY khrv_rec_type);
364
365 PROCEDURE update_row(
366
367 p_api_version IN NUMBER,
368 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
369 x_return_status OUT NOCOPY VARCHAR2,
370 x_msg_count OUT NOCOPY NUMBER,
371 x_msg_data OUT NOCOPY VARCHAR2,
372 p_khrv_tbl IN khrv_tbl_type,
373 x_khrv_tbl OUT NOCOPY khrv_tbl_type);
374
375 PROCEDURE delete_row(
376
377 p_api_version IN NUMBER,
378 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
379 x_return_status OUT NOCOPY VARCHAR2,
380 x_msg_count OUT NOCOPY NUMBER,
381 x_msg_data OUT NOCOPY VARCHAR2,
382 p_khrv_rec IN khrv_rec_type);
383
384 PROCEDURE delete_row(
385
386 p_api_version IN NUMBER,
387 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
388 x_return_status OUT NOCOPY VARCHAR2,
389 x_msg_count OUT NOCOPY NUMBER,
390 x_msg_data OUT NOCOPY VARCHAR2,
391 p_khrv_tbl IN khrv_tbl_type);
392
393 PROCEDURE validate_row(
394
395 p_api_version IN NUMBER,
396 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
397 x_return_status OUT NOCOPY VARCHAR2,
398 x_msg_count OUT NOCOPY NUMBER,
399 x_msg_data OUT NOCOPY VARCHAR2,
400 p_khrv_rec IN khrv_rec_type);
401
402 PROCEDURE validate_row(
403
404 p_api_version IN NUMBER,
405 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
406 x_return_status OUT NOCOPY VARCHAR2,
407 x_msg_count OUT NOCOPY NUMBER,
408 x_msg_data OUT NOCOPY VARCHAR2,
409 p_khrv_tbl IN khrv_tbl_type);
410
411 PROCEDURE lock_row(
412
413 p_api_version IN NUMBER,
414 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
415 x_return_status OUT NOCOPY VARCHAR2,
416 x_msg_count OUT NOCOPY NUMBER,
417 x_msg_data OUT NOCOPY VARCHAR2,
418 p_khrv_rec IN khrv_rec_type);
419
420 PROCEDURE lock_row(
421
422 p_api_version IN NUMBER,
423 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
424 x_return_status OUT NOCOPY VARCHAR2,
425 x_msg_count OUT NOCOPY NUMBER,
426 x_msg_data OUT NOCOPY VARCHAR2,
427 p_khrv_tbl IN khrv_tbl_type);
428
429 FUNCTION create_version(
430 p_khr_id IN NUMBER,
431 p_major_version IN NUMBER) RETURN VARCHAR2;
432
433 FUNCTION restore_version(
434 p_khr_id IN NUMBER,
435 p_major_version IN NUMBER) RETURN VARCHAR2;
436
437
438 END OKL_KHR_PVT;