[Home] [Help]
PACKAGE: APPS.OKL_TCN_PVT
Source
1 PACKAGE Okl_Tcn_Pvt AUTHID CURRENT_USER AS
2 /* $Header: OKLSTCNS.pls 120.10.12010000.4 2008/10/24 08:26:51 sosharma ship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 TYPE tcn_rec_type IS RECORD (
7 id NUMBER := Okc_Api.G_MISS_NUM,
8 khr_id_new NUMBER := Okc_Api.G_MISS_NUM,
9 pvn_id NUMBER := Okc_Api.G_MISS_NUM,
10 pdt_id NUMBER := Okc_Api.G_MISS_NUM,
11 rbr_code OKL_TRX_CONTRACTS.RBR_CODE%TYPE := Okc_Api.G_MISS_CHAR,
12 rpy_code OKL_TRX_CONTRACTS.RPY_CODE%TYPE := Okc_Api.G_MISS_CHAR,
13 rvn_code OKL_TRX_CONTRACTS.RVN_CODE%TYPE := Okc_Api.G_MISS_CHAR,
14 trn_code OKL_TRX_CONTRACTS.TRN_CODE%TYPE := Okc_Api.G_MISS_CHAR,
15 qte_id NUMBER := Okc_Api.G_MISS_NUM,
16 aes_id NUMBER := Okc_Api.G_MISS_NUM,
17 code_combination_id NUMBER := Okc_Api.G_MISS_NUM,
18 tcn_type OKL_TRX_CONTRACTS.TCN_TYPE%TYPE := Okc_Api.G_MISS_CHAR,
19 rjn_code OKL_TRX_CONTRACTS.RJN_CODE%TYPE := Okc_Api.G_MISS_CHAR,
20 party_rel_id1_old NUMBER := Okc_Api.G_MISS_NUM,
21 party_rel_id2_old OKL_TRX_CONTRACTS.party_rel_id2_old%TYPE := Okc_Api.G_MISS_CHAR,
22 party_rel_id1_new NUMBER := Okc_Api.G_MISS_NUM,
23 party_rel_id2_new OKL_TRX_CONTRACTS.party_rel_id2_new%TYPE := Okc_Api.G_MISS_CHAR,
24 complete_transfer_yn OKL_TRX_CONTRACTS.complete_transfer_yn%TYPE := Okc_Api.G_MISS_CHAR,
25 object_version_number NUMBER := Okc_Api.G_MISS_NUM,
26 created_by NUMBER := Okc_Api.G_MISS_NUM,
27 creation_date OKL_TRX_CONTRACTS.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
28 last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
29 last_update_date OKL_TRX_CONTRACTS.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
30 date_accrual OKL_TRX_CONTRACTS.DATE_ACCRUAL%TYPE := Okc_Api.G_MISS_DATE,
31 accrual_status_yn OKL_TRX_CONTRACTS.ACCRUAL_STATUS_YN%TYPE := Okc_Api.G_MISS_CHAR,
32 update_status_yn OKL_TRX_CONTRACTS.UPDATE_STATUS_YN%TYPE := Okc_Api.G_MISS_CHAR,
33 org_id NUMBER := Okc_Api.G_MISS_NUM,
34 khr_id NUMBER := Okc_Api.G_MISS_NUM,
35 tax_deductible_local OKL_TRX_CONTRACTS.TAX_DEDUCTIBLE_LOCAL%TYPE
36 := Okc_Api.G_MISS_CHAR,
37 tax_deductible_corporate OKL_TRX_CONTRACTS.tax_deductible_corporate%TYPE
38 := Okc_Api.G_MISS_CHAR,
39 amount NUMBER := Okc_Api.G_MISS_NUM,
40 request_id NUMBER := Okc_Api.G_MISS_NUM,
41 currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE := Okc_Api.G_MISS_CHAR,
42 program_application_id NUMBER := Okc_Api.G_MISS_NUM,
43 khr_id_old NUMBER := Okc_Api.G_MISS_NUM,
44 program_id NUMBER := Okc_Api.G_MISS_NUM,
45 program_update_date OKL_TRX_CONTRACTS.PROGRAM_update_DATE%TYPE
46 := Okc_Api.G_MISS_DATE,
47 attribute_category OKL_TRX_CONTRACTS.ATTRIBUTE_CATEGORY%TYPE := Okc_Api.G_MISS_CHAR,
48 attribute1 OKL_TRX_CONTRACTS.ATTRIBUTE1%TYPE := Okc_Api.G_MISS_CHAR,
49 attribute2 OKL_TRX_CONTRACTS.ATTRIBUTE2%TYPE := Okc_Api.G_MISS_CHAR,
50 attribute3 OKL_TRX_CONTRACTS.ATTRIBUTE3%TYPE := Okc_Api.G_MISS_CHAR,
51 attribute4 OKL_TRX_CONTRACTS.ATTRIBUTE4%TYPE := Okc_Api.G_MISS_CHAR,
52 attribute5 OKL_TRX_CONTRACTS.ATTRIBUTE5%TYPE := Okc_Api.G_MISS_CHAR,
53 attribute6 OKL_TRX_CONTRACTS.ATTRIBUTE6%TYPE := Okc_Api.G_MISS_CHAR,
54 attribute7 OKL_TRX_CONTRACTS.ATTRIBUTE7%TYPE := Okc_Api.G_MISS_CHAR,
55 attribute8 OKL_TRX_CONTRACTS.ATTRIBUTE8%TYPE := Okc_Api.G_MISS_CHAR,
56 attribute9 OKL_TRX_CONTRACTS.ATTRIBUTE9%TYPE := Okc_Api.G_MISS_CHAR,
57 attribute10 OKL_TRX_CONTRACTS.ATTRIBUTE10%TYPE := Okc_Api.G_MISS_CHAR,
58 attribute11 OKL_TRX_CONTRACTS.ATTRIBUTE11%TYPE := Okc_Api.G_MISS_CHAR,
59 attribute12 OKL_TRX_CONTRACTS.ATTRIBUTE12%TYPE := Okc_Api.G_MISS_CHAR,
60 attribute13 OKL_TRX_CONTRACTS.ATTRIBUTE13%TYPE := Okc_Api.G_MISS_CHAR,
61 attribute14 OKL_TRX_CONTRACTS.ATTRIBUTE14%TYPE := Okc_Api.G_MISS_CHAR,
62 attribute15 OKL_TRX_CONTRACTS.ATTRIBUTE15%TYPE := Okc_Api.G_MISS_CHAR,
63 last_update_login NUMBER := Okc_Api.G_MISS_NUM,
64 try_id NUMBER := Okc_Api.G_MISS_NUM,
65 tsu_code OKL_TRX_CONTRACTS.TSU_CODE%TYPE := Okc_Api.G_MISS_CHAR,
66 set_of_books_id NUMBER := Okc_Api.G_MISS_NUM,
67 description OKL_TRX_CONTRACTS.DESCRIPTION%TYPE := Okc_Api.G_MISS_CHAR,
68 date_transaction_occurred OKL_TRX_CONTRACTS.DATE_TRANSACTION_OCCURRED%TYPE
69 := Okc_Api.G_MISS_DATE,
70 trx_number OKL_TRX_CONTRACTS.TRX_NUMBER%TYPE := Okc_Api.G_MISS_CHAR,
71 tmt_evergreen_yn OKL_TRX_CONTRACTS.TMT_EVERGREEN_YN%TYPE := Okc_Api.G_MISS_CHAR,
72 tmt_close_balances_yn OKL_TRX_CONTRACTS.TMT_CLOSE_BALANCES_YN%TYPE
73 := Okc_Api.G_MISS_CHAR,
74 tmt_accounting_entries_yn OKL_TRX_CONTRACTS.TMT_ACCOUNTING_ENTRIES_YN%TYPE
75 := Okc_Api.G_MISS_CHAR,
76 tmt_cancel_insurance_yn OKL_TRX_CONTRACTS.TMT_CANCEL_INSURANCE_YN%TYPE
77 := Okc_Api.G_MISS_CHAR,
78 tmt_asset_disposition_yn OKL_TRX_CONTRACTS.TMT_ASSET_DISPOSITION_YN%TYPE
79 := Okc_Api.G_MISS_CHAR,
80 tmt_amortization_yn OKL_TRX_CONTRACTS.TMT_AMORTIZATION_YN%TYPE := Okc_Api.G_MISS_CHAR,
81 tmt_asset_return_yn OKL_TRX_CONTRACTS.TMT_ASSET_RETURN_YN%TYPE := Okc_Api.G_MISS_CHAR,
82 tmt_contract_updated_yn OKL_TRX_CONTRACTS.TMT_CONTRACT_UPDATED_YN%TYPE := Okc_Api.G_MISS_CHAR,
83 tmt_recycle_yn OKL_TRX_CONTRACTS.TMT_RECYCLE_YN%TYPE := Okc_Api.G_MISS_CHAR,
84 tmt_validated_yn OKL_TRX_CONTRACTS.TMT_VALIDATED_YN%TYPE := Okc_Api.G_MISS_CHAR,
85 tmt_streams_updated_yn OKL_TRX_CONTRACTS.TMT_STREAMS_UPDATED_YN%TYPE := Okc_Api.G_MISS_CHAR,
86 accrual_activity OKL_TRX_CONTRACTS.accrual_activity%TYPE := okc_api.g_miss_char ,
87
88 -- Added by Santonyr 11-NOV-2002. Fixed bug 2660517
89
90 tmt_split_asset_yn OKL_TRX_CONTRACTS.tmt_split_asset_yn%TYPE := okc_api.g_miss_char ,
91 tmt_generic_flag1_yn OKL_TRX_CONTRACTS.tmt_generic_flag1_yn%TYPE := okc_api.g_miss_char ,
92 tmt_generic_flag2_yn OKL_TRX_CONTRACTS.tmt_generic_flag2_yn%TYPE := okc_api.g_miss_char ,
93 tmt_generic_flag3_yn OKL_TRX_CONTRACTS.tmt_generic_flag3_yn%TYPE := okc_api.g_miss_char ,
94
95 -- Added by HKPATEL 14-NOV-2002. Multi-Currency Changes
96
97 currency_conversion_type OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_TYPE%TYPE := okc_api.g_miss_char ,
98 currency_conversion_rate OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_RATE%TYPE := okc_api.g_miss_num ,
99 currency_conversion_date OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_DATE%TYPE := okc_api.g_miss_date ,
100
101 -- Added by Keerthi
102 chr_id NUMBER := Okc_Api.G_MISS_NUM ,
103
104 -- Added by Keerthi
105 source_trx_id NUMBER := Okc_Api.G_MISS_NUM ,
106 source_trx_type OKL_TRX_CONTRACTS.SOURCE_TRX_TYPE%TYPE := okc_api.g_miss_char,
107
108 -- Added by kmotepal
109 canceled_date OKL_TRX_CONTRACTS.CANCELED_DATE%TYPE := okc_api.g_miss_date,
110 --Added by dpsingh for LE Uptake
111 legal_entity_id NUMBER := Okl_Api.G_MISS_NUM,
112 --Added by dpsingh for SLA Uptake (Bug 5707866)
113 accrual_reversal_date OKL_TRX_CONTRACTS.ACCRUAL_REVERSAL_DATE%TYPE := Okl_Api.G_MISS_DATE,
114 -- Added by DJANASWA for SLA project
115 accounting_reversal_yn OKL_TRX_CONTRACTS.ACCOUNTING_REVERSAL_YN%TYPE := Okc_Api.G_MISS_CHAR,
116 -- Added by zrehman for SLA project (Bug 5707866) 8-Feb-2007
117 product_name OKL_TRX_CONTRACTS.product_name%TYPE := Okc_Api.G_MISS_CHAR,
118 book_classification_code OKL_TRX_CONTRACTS.BOOK_CLASSIFICATION_CODE%TYPE := Okc_Api.G_MISS_CHAR,
119 tax_owner_code OKL_TRX_CONTRACTS.TAX_OWNER_CODE%TYPE := Okc_Api.G_MISS_CHAR,
120 tmt_status_code OKL_TRX_CONTRACTS.TMT_STATUS_CODE%TYPE := Okc_Api.G_MISS_CHAR,
121 representation_name OKL_TRX_CONTRACTS.REPRESENTATION_NAME%TYPE := Okc_Api.G_MISS_CHAR,
122 representation_code OKL_TRX_CONTRACTS.REPRESENTATION_CODE%TYPE := Okc_Api.G_MISS_CHAR,
123 -- Added by nikshah for SLA project (Bug 5707866) 13-Apr-2007
124 UPGRADE_STATUS_FLAG OKL_TRX_CONTRACTS.UPGRADE_STATUS_FLAG%TYPE := Okc_Api.G_MISS_CHAR,
125 -- Added by dcshanmu for Transaction Date Stamping 02-Nov-2007
126 TRANSACTION_DATE OKL_TRX_CONTRACTS.TRANSACTION_DATE%TYPE := Okl_Api.G_MISS_DATE,
127 -- Added by smereddy for Multi-GAAP project (Bug 7263041) 04-Aug-2007
128 primary_rep_trx_id OKL_TRX_CONTRACTS.primary_rep_trx_id%TYPE := Okc_Api.G_MISS_NUM,
129 REPRESENTATION_TYPE OKL_TRX_CONTRACTS.REPRESENTATION_TYPE%TYPE := Okc_Api.G_MISS_CHAR,
130 -- sosharma added column for Income accrual recon-report
131 TRANSACTION_REVERSAL_DATE OKL_TRX_CONTRACTS.TRANSACTION_REVERSAL_DATE%TYPE := Okl_Api.G_MISS_DATE
132 );
133
134
135 g_miss_tcn_rec tcn_rec_type;
136 TYPE tcn_tbl_type IS TABLE OF tcn_rec_type
137 INDEX BY BINARY_INTEGER;
138 TYPE tcnv_rec_type IS RECORD (
139 id NUMBER := Okc_Api.G_MISS_NUM,
140 object_version_number NUMBER := Okc_Api.G_MISS_NUM,
141 rbr_code OKL_TRX_CONTRACTS.RBR_CODE%TYPE := Okc_Api.G_MISS_CHAR,
142 rpy_code OKL_TRX_CONTRACTS.RPY_CODE%TYPE := Okc_Api.G_MISS_CHAR,
143 rvn_code OKL_TRX_CONTRACTS.RVN_CODE%TYPE := Okc_Api.G_MISS_CHAR,
144 trn_code OKL_TRX_CONTRACTS.TRN_CODE%TYPE := Okc_Api.G_MISS_CHAR,
145 khr_id_new NUMBER := Okc_Api.G_MISS_NUM,
146 pvn_id NUMBER := Okc_Api.G_MISS_NUM,
147 pdt_id NUMBER := Okc_Api.G_MISS_NUM,
148 qte_id NUMBER := Okc_Api.G_MISS_NUM,
149 aes_id NUMBER := Okc_Api.G_MISS_NUM,
150 code_combination_id NUMBER := Okc_Api.G_MISS_NUM,
151 tax_deductible_local OKL_TRX_CONTRACTS.TAX_DEDUCTIBLE_LOCAL%TYPE
152 := Okc_Api.G_MISS_CHAR,
153 tax_deductible_corporate OKL_TRX_CONTRACTS.tax_deductible_corporate%TYPE
154 := Okc_Api.G_MISS_CHAR,
155 date_accrual OKL_TRX_CONTRACTS.DATE_ACCRUAL%TYPE := Okc_Api.G_MISS_DATE,
156 accrual_status_yn OKL_TRX_CONTRACTS.ACCRUAL_STATUS_YN%TYPE
157 := Okc_Api.G_MISS_CHAR,
158 update_status_yn OKL_TRX_CONTRACTS.UPDATE_STATUS_YN%TYPE := Okc_Api.G_MISS_CHAR,
159 amount NUMBER := Okc_Api.G_MISS_NUM,
160 currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE := Okc_Api.G_MISS_CHAR,
161 attribute_category OKL_TRX_CONTRACTS.ATTRIBUTE_CATEGORY%TYPE
162 := Okc_Api.G_MISS_CHAR,
163 attribute1 OKL_TRX_CONTRACTS.ATTRIBUTE1%TYPE := Okc_Api.G_MISS_CHAR,
164 attribute2 OKL_TRX_CONTRACTS.ATTRIBUTE2%TYPE := Okc_Api.G_MISS_CHAR,
165 attribute3 OKL_TRX_CONTRACTS.ATTRIBUTE3%TYPE := Okc_Api.G_MISS_CHAR,
166 attribute4 OKL_TRX_CONTRACTS.ATTRIBUTE4%TYPE := Okc_Api.G_MISS_CHAR,
167 attribute5 OKL_TRX_CONTRACTS.ATTRIBUTE5%TYPE := Okc_Api.G_MISS_CHAR,
168 attribute6 OKL_TRX_CONTRACTS.ATTRIBUTE6%TYPE := Okc_Api.G_MISS_CHAR,
169 attribute7 OKL_TRX_CONTRACTS.ATTRIBUTE7%TYPE := Okc_Api.G_MISS_CHAR,
170 attribute8 OKL_TRX_CONTRACTS.ATTRIBUTE8%TYPE := Okc_Api.G_MISS_CHAR,
171 attribute9 OKL_TRX_CONTRACTS.ATTRIBUTE9%TYPE := Okc_Api.G_MISS_CHAR,
172 attribute10 OKL_TRX_CONTRACTS.ATTRIBUTE10%TYPE := Okc_Api.G_MISS_CHAR,
173 attribute11 OKL_TRX_CONTRACTS.ATTRIBUTE11%TYPE := Okc_Api.G_MISS_CHAR,
174 attribute12 OKL_TRX_CONTRACTS.ATTRIBUTE12%TYPE := Okc_Api.G_MISS_CHAR,
175 attribute13 OKL_TRX_CONTRACTS.ATTRIBUTE13%TYPE := Okc_Api.G_MISS_CHAR,
176 attribute14 OKL_TRX_CONTRACTS.ATTRIBUTE14%TYPE := Okc_Api.G_MISS_CHAR,
177 attribute15 OKL_TRX_CONTRACTS.ATTRIBUTE15%TYPE := Okc_Api.G_MISS_CHAR,
178 tcn_type OKL_TRX_CONTRACTS.TCN_TYPE%TYPE := Okc_Api.G_MISS_CHAR,
179 rjn_code OKL_TRX_CONTRACTS.RJN_CODE%TYPE := Okc_Api.G_MISS_CHAR,
180 party_rel_id1_old NUMBER := Okc_Api.G_MISS_NUM,
181 party_rel_id2_old OKL_TRX_CONTRACTS.party_rel_id2_old%TYPE := Okc_Api.G_MISS_CHAR,
182 party_rel_id1_new NUMBER := Okc_Api.G_MISS_NUM,
183 party_rel_id2_new OKL_TRX_CONTRACTS.party_rel_id2_new%TYPE := Okc_Api.G_MISS_CHAR,
184 complete_transfer_yn OKL_TRX_CONTRACTS.complete_transfer_yn%TYPE := Okc_Api.G_MISS_CHAR,
185 org_id NUMBER := Okc_Api.G_MISS_NUM,
186 khr_id NUMBER := Okc_Api.G_MISS_NUM,
187 request_id NUMBER := Okc_Api.G_MISS_NUM,
188 program_application_id NUMBER := Okc_Api.G_MISS_NUM,
189 khr_id_old NUMBER := Okc_Api.G_MISS_NUM,
190 program_id NUMBER := Okc_Api.G_MISS_NUM,
191 program_update_date OKL_TRX_CONTRACTS.PROGRAM_update_DATE%TYPE
192 := Okc_Api.G_MISS_DATE,
193 created_by NUMBER := Okc_Api.G_MISS_NUM,
194 creation_date OKL_TRX_CONTRACTS.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
195 last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
196 last_update_date OKL_TRX_CONTRACTS.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
197 last_update_login NUMBER := Okc_Api.G_MISS_NUM,
198 try_id NUMBER := Okc_Api.G_MISS_NUM,
199 tsu_code OKL_TRX_CONTRACTS.TSU_CODE%TYPE := Okc_Api.G_MISS_CHAR,
200 set_of_books_id NUMBER := Okc_Api.G_MISS_NUM,
201 description OKL_TRX_CONTRACTS.DESCRIPTION%TYPE := Okc_Api.G_MISS_CHAR,
202 date_transaction_occurred OKL_TRX_CONTRACTS.DATE_TRANSACTION_OCCURRED%TYPE
203 := Okc_Api.G_MISS_DATE,
204 trx_number OKL_TRX_CONTRACTS.TRX_NUMBER%TYPE := Okc_Api.G_MISS_CHAR,
205 tmt_evergreen_yn OKL_TRX_CONTRACTS.TMT_EVERGREEN_YN%TYPE := Okc_Api.G_MISS_CHAR,
206 tmt_close_balances_yn OKL_TRX_CONTRACTS.TMT_CLOSE_BALANCES_YN%TYPE
207 := Okc_Api.G_MISS_CHAR,
208 tmt_accounting_entries_yn OKL_TRX_CONTRACTS.TMT_ACCOUNTING_ENTRIES_YN%TYPE
209 := Okc_Api.G_MISS_CHAR,
210 tmt_cancel_insurance_yn OKL_TRX_CONTRACTS.TMT_CANCEL_INSURANCE_YN%TYPE
211 := Okc_Api.G_MISS_CHAR,
212 tmt_asset_disposition_yn OKL_TRX_CONTRACTS.TMT_ASSET_DISPOSITION_YN%TYPE
213 := Okc_Api.G_MISS_CHAR,
214 tmt_amortization_yn OKL_TRX_CONTRACTS.TMT_AMORTIZATION_YN%TYPE := Okc_Api.G_MISS_CHAR,
215 tmt_asset_return_yn OKL_TRX_CONTRACTS.TMT_ASSET_RETURN_YN%TYPE := Okc_Api.G_MISS_CHAR,
216 tmt_contract_updated_yn OKL_TRX_CONTRACTS.TMT_CONTRACT_UPDATED_YN%TYPE
217 := Okc_Api.G_MISS_CHAR,
218 tmt_recycle_yn OKL_TRX_CONTRACTS.TMT_RECYCLE_YN%TYPE := Okc_Api.G_MISS_CHAR,
219 tmt_validated_yn OKL_TRX_CONTRACTS.TMT_VALIDATED_YN%TYPE := Okc_Api.G_MISS_CHAR,
220 tmt_streams_updated_yn OKL_TRX_CONTRACTS.TMT_STREAMS_UPDATED_YN%TYPE
221 := Okc_Api.G_MISS_CHAR,
222 accrual_activity OKL_TRX_CONTRACTS.accrual_activity%TYPE := okc_api.g_miss_char,
223
224 -- Added by Santonyr 11-NOV-2002. Fixed bug 2660517
225
226 tmt_split_asset_yn OKL_TRX_CONTRACTS.tmt_split_asset_yn%TYPE := okc_api.g_miss_char ,
227 tmt_generic_flag1_yn OKL_TRX_CONTRACTS.tmt_generic_flag1_yn%TYPE := okc_api.g_miss_char ,
228 tmt_generic_flag2_yn OKL_TRX_CONTRACTS.tmt_generic_flag2_yn%TYPE := okc_api.g_miss_char ,
229 tmt_generic_flag3_yn OKL_TRX_CONTRACTS.tmt_generic_flag3_yn%TYPE := okc_api.g_miss_char ,
230
231 -- Added by HKPATEL 14-NOV-2002. Multi-Currency Changes
232
233 currency_conversion_type OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_TYPE%TYPE := okc_api.g_miss_char ,
234 currency_conversion_rate OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_RATE%TYPE := okc_api.g_miss_num ,
235 currency_conversion_date OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_DATE%TYPE := okc_api.g_miss_date ,
236
237 -- Added by Keerthi
238
239 chr_id NUMBER := Okc_Api.G_MISS_NUM ,
240
241 -- Added by Keerthi
242 source_trx_id NUMBER := Okc_Api.G_MISS_NUM ,
243 source_trx_type OKL_TRX_CONTRACTS.SOURCE_TRX_TYPE%TYPE := okc_api.g_miss_char,
244
245 -- Added by kmotepal
246 canceled_date OKL_TRX_CONTRACTS.CANCELED_DATE%TYPE := okc_api.g_miss_date,
247
248 --Added by dpsingh for LE Uptake
249 legal_entity_id NUMBER := Okl_Api.G_MISS_NUM,
250
251 --Added by dpsingh for SLA Uptake (Bug 5707866)
252 accrual_reversal_date OKL_TRX_CONTRACTS.ACCRUAL_REVERSAL_DATE%TYPE := Okl_Api.G_MISS_DATE,
253
254 -- Added by DJANASWA for SLA project
255 accounting_reversal_yn OKL_TRX_CONTRACTS.ACCOUNTING_REVERSAL_YN%TYPE := Okc_Api.G_MISS_CHAR,
256 -- Added by zrehman for SLA project (Bug 5707866) 8-Feb-2007
257 product_name OKL_TRX_CONTRACTS.product_name%TYPE := Okc_Api.G_MISS_CHAR,
258 book_classification_code OKL_TRX_CONTRACTS.BOOK_CLASSIFICATION_CODE%TYPE := Okc_Api.G_MISS_CHAR,
259 tax_owner_code OKL_TRX_CONTRACTS.TAX_OWNER_CODE%TYPE := Okc_Api.G_MISS_CHAR,
260 tmt_status_code OKL_TRX_CONTRACTS.TMT_STATUS_CODE%TYPE := Okc_Api.G_MISS_CHAR,
261 representation_name OKL_TRX_CONTRACTS.REPRESENTATION_NAME%TYPE := Okc_Api.G_MISS_CHAR,
262 representation_code OKL_TRX_CONTRACTS.REPRESENTATION_CODE%TYPE := Okc_Api.G_MISS_CHAR,
263 -- Added by nikshah for SLA project (Bug 5707866) 13-Apr-2007
264 UPGRADE_STATUS_FLAG OKL_TRX_CONTRACTS.UPGRADE_STATUS_FLAG%TYPE := Okc_Api.G_MISS_CHAR,
265 -- Added by dcshanmu for Transaction Date Stamping 02-Nov-2007
266 TRANSACTION_DATE OKL_TRX_CONTRACTS.TRANSACTION_DATE%TYPE := Okl_Api.G_MISS_DATE,
267 -- Added by smereddy for Multi-GAAP project (Bug 7263041) 04-Aug-2007
268 primary_rep_trx_id OKL_TRX_CONTRACTS.primary_rep_trx_id%TYPE := Okc_Api.G_MISS_NUM,
269 REPRESENTATION_TYPE OKL_TRX_CONTRACTS.REPRESENTATION_TYPE%TYPE := Okc_Api.G_MISS_CHAR,
270 -- sosharma added column for Income accrual recon-report
271 TRANSACTION_REVERSAL_DATE OKL_TRX_CONTRACTS.TRANSACTION_REVERSAL_DATE%TYPE := Okl_Api.G_MISS_DATE
272 );
273
274
275 g_miss_tcnv_rec tcnv_rec_type;
276 TYPE tcnv_tbl_type IS TABLE OF tcnv_rec_type
277 INDEX BY BINARY_INTEGER;
278 ---------------------------------------------------------------------------
279 -- GLOBAL MESSAGE CONSTANTS
280 ---------------------------------------------------------------------------
281 G_FND_APP CONSTANT VARCHAR2(200) := Okc_Api.G_FND_APP;
282 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_UNABLE_TO_RESERVE_REC;
283 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_DELETED;
284 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_CHANGED;
285 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_RECORD_LOGICALLY_DELETED;
286 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_REQUIRED_VALUE;
287 G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_INVALID_VALUE;
288 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_COL_NAME_TOKEN;
289 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_PARENT_TABLE_TOKEN;
290 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_CHILD_TABLE_TOKEN;
291 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLerrm';
292 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLcode';
293 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
294 G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_NO_PARENT_RECORD';
295 G_UPPERCASE_REQUIRED CONSTANT VARCHAR2(200) := 'OKL_UPPER_CASE_REQUIRED';
296 G_UNQS CONSTANT VARCHAR2(200) := 'OKL_UNIQUE_KEY_VALIDATION_FAILED';
297
298 ---------------------------------------------------------------------------
299 -- GLOBAL VARIABLES
300 ---------------------------------------------------------------------------
301 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
302 ---------------------------------------------------------------------------
303 -- GLOBAL VARIABLES
304 ---------------------------------------------------------------------------
305 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_TCN_PVT';
306 G_APP_NAME CONSTANT VARCHAR2(3) := Okc_Api.G_APP_NAME;
307 ---------------------------------------------------------------------------
308 -- Procedures and Functions
309 ---------------------------------------------------------------------------
310
311 PROCEDURE qc;
312 PROCEDURE change_version;
313 PROCEDURE api_copy;
314 PROCEDURE insert_row(
315 p_api_version IN NUMBER,
316 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
317 x_return_status OUT NOCOPY VARCHAR2,
318 x_msg_count OUT NOCOPY NUMBER,
319 x_msg_data OUT NOCOPY VARCHAR2,
320 p_tcnv_rec IN tcnv_rec_type,
321 x_tcnv_rec OUT NOCOPY tcnv_rec_type);
322
323 PROCEDURE insert_row(
324 p_api_version IN NUMBER,
325 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
326 x_return_status OUT NOCOPY VARCHAR2,
327 x_msg_count OUT NOCOPY NUMBER,
328 x_msg_data OUT NOCOPY VARCHAR2,
329 p_tcnv_tbl IN tcnv_tbl_type,
330 x_tcnv_tbl OUT NOCOPY tcnv_tbl_type);
331
332 PROCEDURE lock_row(
333 p_api_version IN NUMBER,
334 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
335 x_return_status OUT NOCOPY VARCHAR2,
336 x_msg_count OUT NOCOPY NUMBER,
337 x_msg_data OUT NOCOPY VARCHAR2,
338 p_tcnv_rec IN tcnv_rec_type);
339
340 PROCEDURE lock_row(
341 p_api_version IN NUMBER,
342 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
343 x_return_status OUT NOCOPY VARCHAR2,
344 x_msg_count OUT NOCOPY NUMBER,
345 x_msg_data OUT NOCOPY VARCHAR2,
346 p_tcnv_tbl IN tcnv_tbl_type);
347
348 PROCEDURE update_row(
349 p_api_version IN NUMBER,
350 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
351 x_return_status OUT NOCOPY VARCHAR2,
352 x_msg_count OUT NOCOPY NUMBER,
353 x_msg_data OUT NOCOPY VARCHAR2,
354 p_tcnv_rec IN tcnv_rec_type,
355 x_tcnv_rec OUT NOCOPY tcnv_rec_type);
356
357 PROCEDURE update_row(
358 p_api_version IN NUMBER,
359 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
360 x_return_status OUT NOCOPY VARCHAR2,
361 x_msg_count OUT NOCOPY NUMBER,
362 x_msg_data OUT NOCOPY VARCHAR2,
363 p_tcnv_tbl IN tcnv_tbl_type,
364 x_tcnv_tbl OUT NOCOPY tcnv_tbl_type);
365
366 PROCEDURE delete_row(
367 p_api_version IN NUMBER,
368 p_init_msg_list IN VARCHAR2 DEFAULT Okc_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_tcnv_rec IN tcnv_rec_type);
373
374 PROCEDURE delete_row(
375 p_api_version IN NUMBER,
376 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
377 x_return_status OUT NOCOPY VARCHAR2,
378 x_msg_count OUT NOCOPY NUMBER,
379 x_msg_data OUT NOCOPY VARCHAR2,
380 p_tcnv_tbl IN tcnv_tbl_type);
381
382 PROCEDURE validate_row(
383 p_api_version IN NUMBER,
384 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
385 x_return_status OUT NOCOPY VARCHAR2,
386 x_msg_count OUT NOCOPY NUMBER,
387 x_msg_data OUT NOCOPY VARCHAR2,
388 p_tcnv_rec IN tcnv_rec_type);
389
390 PROCEDURE validate_row(
391 p_api_version IN NUMBER,
392 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
393 x_return_status OUT NOCOPY VARCHAR2,
394 x_msg_count OUT NOCOPY NUMBER,
395 x_msg_data OUT NOCOPY VARCHAR2,
396 p_tcnv_tbl IN tcnv_tbl_type);
397
398 END Okl_Tcn_Pvt;