[Home] [Help]
PACKAGE: APPS.OKS_COVERAGE_MIGRATION
Source
1 PACKAGE OKS_COVERAGE_MIGRATION AS
2 /* $Header: OKSCOVMS.pls 120.0 2005/05/25 18:30:50 appldev noship $ */
3
4
5
6
7 G_APP_NAME_OKS CONSTANT VARCHAR2(3) := 'OKS';
8 G_APP_NAME VARCHAR2(200);
9 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXP_ERROR';
10 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
11 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
12
13 x_ctzv_tbl_in oks_ctz_pvt.OksCoverageTimezonesVTblType;
14 l_ctzv_tbl_in oks_ctz_pvt.OksCoverageTimezonesVTblType;
15
16 x_cvtv_tbl_in OKS_CVT_PVT.oks_coverage_times_v_tbl_type;
17 l_cvtv_tbl_in OKS_CVT_PVT.oks_coverage_times_v_tbl_type;
18
19
20 x_acmv_tbl_in OKS_ACM_PVT.oks_action_times_v_tbl_type;
21 l_acmv_tbl_in OKS_ACM_PVT.oks_action_times_v_tbl_type;
22
23 l_ctz_rec NUMBER :=0;
24 l_cvt_rec NUMBER :=0;
25 l_act_ctr NUMBER :=0;
26 l_acm_ctr NUMBER :=0;
27
28 G_PKG_NAME VARCHAR2(200):= 'OKS_COVERAGE_MIGRATION';
29
30
31 PROCEDURE Coverage_migration( p_start_rowid IN ROWID,p_end_rowid IN ROWID,x_return_status OUT NOCOPY VARCHAR2,x_message_data OUT NOCOPY VARCHAR2); -- Migrate the Coverage Header From Rules Architecture To New Architecture.
32
33 PROCEDURE BILL_TYPES_MIGRATION( p_start_rowid IN ROWID,p_end_rowid IN ROWID,x_return_status OUT NOCOPY VARCHAR2,x_message_data OUT NOCOPY VARCHAR2); --Migrate the Billing Types From Rules Architecture To New Architecture.
34
35 PROCEDURE Business_Process_migration(p_start_rowid IN ROWID,p_end_rowid IN ROWID,x_return_status OUT NOCOPY VARCHAR2,x_message_data OUT NOCOPY VARCHAR2); -- Migrate the Business Process From Rules Architecture To New Architecture.
36
37 PROCEDURE COVERAGE_TIMES_MIGRATION ( p_start_rowid IN ROWID,p_end_rowid IN ROWID,x_return_status OUT NOCOPY VARCHAR2,x_message_data OUT NOCOPY VARCHAR2); -- Migrate the Coverage Times From Rules Architecture To New Architecture.
38
39 PROCEDURE Reaction_Time_migration( p_start_rowid IN ROWID,p_end_rowid IN ROWID,x_return_status OUT NOCOPY VARCHAR2,x_message_data OUT NOCOPY VARCHAR2); -- Migrate the Reaction Times From Rules Architecture To New Architecture.
40
41 PROCEDURE Reaction_TimeValues_Migration ( x_return_status OUT NOCOPY VARCHAR2,x_message_data OUT NOCOPY VARCHAR2);
42 -- Migrate the reaction Time Values From Rules Architecture To New Architecture.
43
44 /***************************** HISTORY ***************************************/
45 In_ID OKC_DATATYPES.NumberTabTyp;
46 In_MAJOR_VERSION OKC_DATATYPES.NumberTabTyp;
47 In_CLE_ID OKC_DATATYPES.NumberTabTyp;
48 In_DNZ_CHR_ID OKC_DATATYPES.NumberTabTyp;
49 In_DISCOUNT_LIST OKC_DATATYPES.NumberTabTyp;
50 In_ACCT_RULE_ID OKC_DATATYPES.NumberTabTyp;
51 In_PAYMENT_TYPE OKC_DATATYPES.VAR30TabTyp;
52 In_CC_NO OKC_DATATYPES.VAR120TabTyp;
53 In_CC_EXPIRY_DATE OKC_DATATYPES.DateTabTyp;
54 In_CC_BANK_ACCT_ID OKC_DATATYPES.NumberTabTyp;
55 In_CC_AUTH_CODE OKC_DATATYPES.VAR150TabTyp;
56 In_LOCKED_PRICE_LIST_ID OKC_DATATYPES.NumberTabTyp;
57 In_USAGE_EST_YN OKC_DATATYPES.VAR3TabTyp;
58 In_USAGE_EST_METHOD OKC_DATATYPES.VAR30TabTyp;
59 In_USAGE_EST_START_DATE OKC_DATATYPES.DateTabTyp;
60 In_TERMN_METHOD OKC_DATATYPES.VAR30TabTyp;
61 In_UBT_AMOUNT OKC_DATATYPES.NumberTabTyp;
62 In_CREDIT_AMOUNT OKC_DATATYPES.NumberTabTyp;
63 In_SUPPRESSED_CREDIT OKC_DATATYPES.NumberTabTyp;
64 In_OVERRIDE_AMOUNT OKC_DATATYPES.NumberTabTyp;
65 In_CUST_PO_NUMBER_REQ_YN OKC_DATATYPES.VAR3TabTyp;
66 In_CUST_PO_NUMBER OKC_DATATYPES.VAR150TabTyp;
67 In_GRACE_DURATION OKC_DATATYPES.NumberTabTyp;
68 In_GRACE_PERIOD OKC_DATATYPES.VAR30TabTyp;
69 In_INV_PRINT_FLAG OKC_DATATYPES.VAR3TabTyp;
70 In_PRICE_UOM OKC_DATATYPES.VAR30TabTyp;
71 In_TAX_AMOUNT OKC_DATATYPES.NumberTabTyp;
72 In_TAX_INCLUSIVE_YN OKC_DATATYPES.VAR3TabTyp;
73 In_TAX_STATUS OKC_DATATYPES.VAR30TabTyp;
74 In_TAX_CODE OKC_DATATYPES.NumberTabTyp;
75 In_TAX_EXEMPTION_ID OKC_DATATYPES.NumberTabTyp;
76 In_IB_TRANS_TYPE OKC_DATATYPES.VAR10TabTyp;
77 In_IB_TRANS_DATE OKC_DATATYPES.DateTabTyp;
78 In_PROD_PRICE OKC_DATATYPES.NumberTabTyp;
79 In_SERVICE_PRICE OKC_DATATYPES.NumberTabTyp;
80 In_CLVL_LIST_PRICE OKC_DATATYPES.NumberTabTyp;
81 In_CLVL_QUANTITY OKC_DATATYPES.NumberTabTyp;
82 In_CLVL_EXTENDED_AMT OKC_DATATYPES.NumberTabTyp;
83 In_CLVL_UOM_CODE OKC_DATATYPES.VAR3TabTyp;
84 In_TOPLVL_OPERAND_CODE OKC_DATATYPES.VAR30TabTyp;
85 In_TOPLVL_OPERAND_VAL OKC_DATATYPES.NumberTabTyp;
86 In_TOPLVL_QUANTITY OKC_DATATYPES.NumberTabTyp;
87 In_TOPLVL_UOM_CODE OKC_DATATYPES.VAR3TabTyp;
88 In_TOPLVL_ADJ_PRICE OKC_DATATYPES.NumberTabTyp;
89 In_TOPLVL_PRICE_QTY OKC_DATATYPES.NumberTabTyp;
90 In_AVERAGING_INTERVAL OKC_DATATYPES.NumberTabTyp;
91 In_SETTLEMENT_INTERVAL OKC_DATATYPES.VAR30TabTyp;
92 In_MINIMUM_QUANTITY OKC_DATATYPES.NumberTabTyp;
93 In_DEFAULT_QUANTITY OKC_DATATYPES.NumberTabTyp;
94 In_AMCV_FLAG OKC_DATATYPES.VAR3TabTyp;
95 In_FIXED_QUANTITY OKC_DATATYPES.NumberTabTyp;
96 In_USAGE_DURATION OKC_DATATYPES.NumberTabTyp;
97 In_USAGE_PERIOD OKC_DATATYPES.VAR3TabTyp;
98 In_LEVEL_YN OKC_DATATYPES.VAR3TabTyp;
99 In_USAGE_TYPE OKC_DATATYPES.VAR10TabTyp;
100 In_UOM_QUANTIFIED OKC_DATATYPES.VAR3TabTyp;
101 In_BASE_READING OKC_DATATYPES.NumberTabTyp;
102 In_BILLING_SCHEDULE_TYPE OKC_DATATYPES.VAR10TabTyp;
103 In_COVERAGE_TYPE OKC_DATATYPES.VAR3TabTyp;
104 In_EXCEPTION_COV_ID OKC_DATATYPES.NumberTabTyp;
105 In_LIMIT_UOM_QUANTIFIED OKC_DATATYPES.VAR3TabTyp;
106 In_DISCOUNT_AMOUNT OKC_DATATYPES.NumberTabTyp;
107 In_DISCOUNT_PERCENT OKC_DATATYPES.NumberTabTyp;
108 In_OFFSET_DURATION OKC_DATATYPES.NumberTabTyp;
109 In_OFFSET_PERIOD OKC_DATATYPES.VAR3TabTyp;
110 In_INCIDENT_SEVERITY_ID OKC_DATATYPES.NumberTabTyp;
111 In_PDF_ID OKC_DATATYPES.NumberTabTyp;
112 In_WORK_THRU_YN OKC_DATATYPES.VAR3TabTyp;
113 In_REACT_ACTIVE_YN OKC_DATATYPES.VAR3TabTyp;
114 In_TRANSFER_OPTION OKC_DATATYPES.VAR30TabTyp;
115 In_PROD_UPGRADE_YN OKC_DATATYPES.VAR3TabTyp;
116 In_INHERITANCE_TYPE OKC_DATATYPES.VAR30TabTyp;
117 In_PM_PROGRAM_ID OKC_DATATYPES.NumberTabTyp;
118 In_PM_CONF_REQ_YN OKC_DATATYPES.VAR3TabTyp;
119 In_PM_SCH_EXISTS_YN OKC_DATATYPES.VAR3TabTyp;
120 In_ALLOW_BT_DISCOUNT OKC_DATATYPES.VAR3TabTyp;
121 In_APPLY_DEFAULT_TIMEZONE OKC_DATATYPES.VAR3TabTyp;
122 In_SYNC_DATE_INSTALL OKC_DATATYPES.VAR3TabTyp;
123 In_OBJECT_VERSION_NUMBER OKC_DATATYPES.NumberTabTyp;
124 In_SECURITY_GROUP_ID OKC_DATATYPES.NumberTabTyp;
125 In_REQUEST_ID OKC_DATATYPES.NumberTabTyp;
126 In_CREATED_BY OKC_DATATYPES.NumberTabTyp;
127 In_CREATION_DATE OKC_DATATYPES.DateTabTyp;
128 In_LAST_UPDATED_BY OKC_DATATYPES.NumberTabTyp;
129 In_LAST_UPDATE_DATE OKC_DATATYPES.DateTabTyp;
130 In_LAST_UPDATE_LOGIN OKC_DATATYPES.NumberTabTyp;
131 In_COMMITMENT_ID OKC_DATATYPES.NumberTabTyp;
132 In_FULL_CREDIT OKC_DATATYPES.VAR3TabTyp;
133
134 IN_ACTION_TYPE_CODE OKC_DATATYPES.VAR30TabTyp;
135 IN_PROGRAM_APPLICATION_ID OKC_DATATYPES.NumberTabTyp;
136 IN_PROGRAM_ID OKC_DATATYPES.NumberTabTyp;
137 IN_PROGRAM_UPDATE_DATE OKC_DATATYPES.DateTabTyp;
138 IN_COV_ACTION_TYPE_ID OKC_DATATYPES.NumberTabTyp;
139 IN_UOM_CODE OKC_DATATYPES.VAR3TabTyp;
140 IN_SUN_DURATION OKC_DATATYPES.NumberTabTyp;
141 IN_MON_DURATION OKC_DATATYPES.NumberTabTyp;
142 IN_TUE_DURATION OKC_DATATYPES.NumberTabTyp;
143 IN_WED_DURATION OKC_DATATYPES.NumberTabTyp;
144 IN_THU_DURATION OKC_DATATYPES.NumberTabTyp;
145 IN_FRI_DURATION OKC_DATATYPES.NumberTabTyp;
146 IN_SAT_DURATION OKC_DATATYPES.NumberTabTyp;
147 IN_DEFAULT_YN OKC_DATATYPES.VAR3TabTyp;
148 IN_TIMEZONE_ID OKC_DATATYPES.NumberTabTyp;
149 /*****************************************************/
150 TLn_ID OKC_DATATYPES.NumberTabTyp;
151 tln_major_version OKC_DATATYPES.NumberTabTyp;
152 tln_language OKC_DATATYPES.VAR30TabTyp;
153 tln_source_lang OKC_DATATYPES.VAR30TabTyp;
154 tln_sfwt_flag OKC_DATATYPES.VAR30TabTyp;
155 tln_invoice_text OKC_DATATYPES.VAR1995TabTyp;
156 tln_CREATED_BY OKC_DATATYPES.NumberTabTyp;
157 tln_CREATION_DATE OKC_DATATYPES.DateTabTyp;
158 tln_LAST_UPDATED_BY OKC_DATATYPES.NumberTabTyp;
159 tln_LAST_UPDATE_DATE OKC_DATATYPES.DateTabTyp;
160 tln_LAST_UPDATE_LOGIN OKC_DATATYPES.NumberTabTyp;
161
162 I NUMBER;
163 J NUMBER;
164 K NUMBER;
165 l_tabsize NUMBER;
166 l_tabsize2 NUMBER;
167
168 TYPE OksCoverageTimezonesVRecType IS RECORD (
169 id NUMBER := OKC_API.G_MISS_NUM
170 ,cle_id NUMBER := OKC_API.G_MISS_NUM
171 ,default_yn OKS_COVERAGE_TIMEZONES_V.DEFAULT_YN%TYPE := OKC_API.G_MISS_CHAR
172 ,timezone_id NUMBER := OKC_API.G_MISS_NUM
173 ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
174 ,security_group_id NUMBER := OKC_API.G_MISS_NUM
175 ,program_application_id NUMBER := OKC_API.G_MISS_NUM
176 ,program_id NUMBER := OKC_API.G_MISS_NUM
177 ,program_update_date OKS_COVERAGE_TIMEZONES_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
178 ,request_id NUMBER := OKC_API.G_MISS_NUM
179 ,created_by NUMBER := OKC_API.G_MISS_NUM
180 ,creation_date OKS_COVERAGE_TIMEZONES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
181 ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
182 ,last_update_date OKS_COVERAGE_TIMEZONES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
183 ,last_update_login NUMBER := OKC_API.G_MISS_NUM
184 ,object_version_number NUMBER := OKC_API.G_MISS_NUM
185 ,Major_Version NUMBER := OKC_API.G_MISS_NUM);
186
187 GMissOksCoverageTimezonesVRec OksCoverageTimezonesVRecType;
188 TYPE OksCoverageTimezonesVTblType IS TABLE OF OksCoverageTimezonesVRecType
189 INDEX BY BINARY_INTEGER;
190 h_ctzv_tbl_in OksCoverageTimezonesVTblType;
191 i_ctzv_tbl_in OksCoverageTimezonesVTblType;
192
193
194
195 TYPE oks_action_times_v_rec_type IS RECORD (
196 id NUMBER := OKC_API.G_MISS_NUM
197 ,cov_action_type_id NUMBER := OKC_API.G_MISS_NUM
198 ,cle_id NUMBER := OKC_API.G_MISS_NUM
199 ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
200 ,uom_code OKS_ACTION_TIMES_V.UOM_CODE%TYPE := OKC_API.G_MISS_CHAR
201 ,sun_duration NUMBER := OKC_API.G_MISS_NUM
202 ,mon_duration NUMBER := OKC_API.G_MISS_NUM
203 ,tue_duration NUMBER := OKC_API.G_MISS_NUM
204 ,wed_duration NUMBER := OKC_API.G_MISS_NUM
205 ,thu_duration NUMBER := OKC_API.G_MISS_NUM
206 ,fri_duration NUMBER := OKC_API.G_MISS_NUM
207 ,sat_duration NUMBER := OKC_API.G_MISS_NUM
208 ,security_group_id NUMBER := OKC_API.G_MISS_NUM
209 ,program_application_id NUMBER := OKC_API.G_MISS_NUM
210 ,program_id NUMBER := OKC_API.G_MISS_NUM
211 ,program_update_date OKS_ACTION_TIMES_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
212 ,request_id NUMBER := OKC_API.G_MISS_NUM
213 ,created_by NUMBER := OKC_API.G_MISS_NUM
214 ,creation_date OKS_ACTION_TIMES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
215 ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
216 ,last_update_date OKS_ACTION_TIMES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
217 ,last_update_login NUMBER := OKC_API.G_MISS_NUM
218 ,object_version_number NUMBER := OKC_API.G_MISS_NUM
219 ,major_version NUMBER := OKC_API.G_MISS_NUM);
220
221 TYPE oks_action_times_v_tbl_type IS TABLE OF oks_action_times_v_rec_type INDEX BY BINARY_INTEGER;
222
223 h_acmv_tbl_in oks_action_times_v_tbl_type;
224 i_acmv_tbl_in oks_action_times_v_tbl_type;
225
226
227
228 TYPE klnv_rec_type IS RECORD (
229 id NUMBER := OKC_API.G_MISS_NUM
230 ,cle_id NUMBER := OKC_API.G_MISS_NUM
231 ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
232 ,discount_list NUMBER := OKC_API.G_MISS_NUM
233 ,acct_rule_id NUMBER := OKC_API.G_MISS_NUM
234 ,payment_type OKS_K_LINES_V.PAYMENT_TYPE%TYPE := OKC_API.G_MISS_CHAR
235 ,cc_no OKS_K_LINES_V.CC_NO%TYPE := OKC_API.G_MISS_CHAR
236 ,cc_expiry_date OKS_K_LINES_V.CC_EXPIRY_DATE%TYPE := OKC_API.G_MISS_DATE
237 ,cc_bank_acct_id NUMBER := OKC_API.G_MISS_NUM
238 ,cc_auth_code OKS_K_LINES_V.CC_AUTH_CODE%TYPE := OKC_API.G_MISS_CHAR
239 ,commitment_id NUMBER := OKC_API.G_MISS_NUM
240 ,locked_price_list_id NUMBER := OKC_API.G_MISS_NUM
241 ,usage_est_yn OKS_K_LINES_V.USAGE_EST_YN%TYPE := OKC_API.G_MISS_CHAR
242 ,usage_est_method OKS_K_LINES_V.USAGE_EST_METHOD%TYPE := OKC_API.G_MISS_CHAR
243 ,usage_est_start_date OKS_K_LINES_V.USAGE_EST_START_DATE%TYPE := OKC_API.G_MISS_DATE
244 ,termn_method OKS_K_LINES_V.TERMN_METHOD%TYPE := OKC_API.G_MISS_CHAR
245 ,ubt_amount NUMBER := OKC_API.G_MISS_NUM
246 ,credit_amount NUMBER := OKC_API.G_MISS_NUM
247 ,suppressed_credit NUMBER := OKC_API.G_MISS_NUM
248 ,override_amount NUMBER := OKC_API.G_MISS_NUM
249 ,cust_po_number_req_yn OKS_K_LINES_V.CUST_PO_NUMBER_REQ_YN%TYPE := OKC_API.G_MISS_CHAR
250 ,cust_po_number OKS_K_LINES_V.CUST_PO_NUMBER%TYPE := OKC_API.G_MISS_CHAR
251 ,grace_duration NUMBER := OKC_API.G_MISS_NUM
252 ,grace_period OKS_K_LINES_V.GRACE_PERIOD%TYPE := OKC_API.G_MISS_CHAR
253 ,inv_print_flag OKS_K_LINES_V.INV_PRINT_FLAG%TYPE := OKC_API.G_MISS_CHAR
254 ,price_uom OKS_K_LINES_V.PRICE_UOM%TYPE := OKC_API.G_MISS_CHAR
255 ,tax_amount NUMBER := OKC_API.G_MISS_NUM
256 ,tax_inclusive_yn OKS_K_LINES_V.TAX_INCLUSIVE_YN%TYPE := OKC_API.G_MISS_CHAR
257 ,tax_status OKS_K_LINES_V.TAX_STATUS%TYPE := OKC_API.G_MISS_CHAR
258 ,tax_code NUMBER := OKC_API.G_MISS_NUM
259 ,tax_exemption_id NUMBER := OKC_API.G_MISS_NUM
260 ,ib_trans_type OKS_K_LINES_V.IB_TRANS_TYPE%TYPE := OKC_API.G_MISS_CHAR
261 ,ib_trans_date OKS_K_LINES_V.IB_TRANS_DATE%TYPE := OKC_API.G_MISS_DATE
262 ,prod_price NUMBER := OKC_API.G_MISS_NUM
263 ,service_price NUMBER := OKC_API.G_MISS_NUM
264 ,clvl_list_price NUMBER := OKC_API.G_MISS_NUM
265 ,clvl_quantity NUMBER := OKC_API.G_MISS_NUM
266 ,clvl_extended_amt NUMBER := OKC_API.G_MISS_NUM
267 ,clvl_uom_code OKS_K_LINES_V.CLVL_UOM_CODE%TYPE := OKC_API.G_MISS_CHAR
268 ,toplvl_operand_code OKS_K_LINES_V.TOPLVL_OPERAND_CODE%TYPE := OKC_API.G_MISS_CHAR
269 ,toplvl_operand_val NUMBER := OKC_API.G_MISS_NUM
270 ,toplvl_quantity NUMBER := OKC_API.G_MISS_NUM
271 ,toplvl_uom_code OKS_K_LINES_V.TOPLVL_UOM_CODE%TYPE := OKC_API.G_MISS_CHAR
272 ,toplvl_adj_price NUMBER := OKC_API.G_MISS_NUM
273 ,toplvl_price_qty NUMBER := OKC_API.G_MISS_NUM
274 ,averaging_interval NUMBER := OKC_API.G_MISS_NUM
275 ,settlement_interval OKS_K_LINES_V.SETTLEMENT_INTERVAL%TYPE := OKC_API.G_MISS_CHAR
276 ,minimum_quantity NUMBER := OKC_API.G_MISS_NUM
277 ,default_quantity NUMBER := OKC_API.G_MISS_NUM
278 ,amcv_flag OKS_K_LINES_V.AMCV_FLAG%TYPE := OKC_API.G_MISS_CHAR
279 ,fixed_quantity NUMBER := OKC_API.G_MISS_NUM
280 ,usage_duration NUMBER := OKC_API.G_MISS_NUM
281 ,usage_period OKS_K_LINES_V.USAGE_PERIOD%TYPE := OKC_API.G_MISS_CHAR
282 ,level_yn OKS_K_LINES_V.LEVEL_YN%TYPE := OKC_API.G_MISS_CHAR
286 ,billing_schedule_type OKS_K_LINES_V.BILLING_SCHEDULE_TYPE%TYPE := OKC_API.G_MISS_CHAR
283 ,usage_type OKS_K_LINES_V.USAGE_TYPE%TYPE := OKC_API.G_MISS_CHAR
284 ,uom_quantified OKS_K_LINES_V.UOM_QUANTIFIED%TYPE := OKC_API.G_MISS_CHAR
285 ,base_reading NUMBER := OKC_API.G_MISS_NUM
287 ,full_credit OKS_K_LINES_V.FULL_CREDIT%TYPE := OKC_API.G_MISS_CHAR
288 ,locked_price_list_line_id NUMBER := OKC_API.G_MISS_NUM
289 ,break_uom OKS_K_LINES_V.BREAK_UOM%TYPE := OKC_API.G_MISS_CHAR
290 ,prorate OKS_K_LINES_V.PRORATE%TYPE := OKC_API.G_MISS_CHAR
291 ,coverage_type OKS_K_LINES_V.COVERAGE_TYPE%TYPE := OKC_API.G_MISS_CHAR
292 ,exception_cov_id NUMBER := OKC_API.G_MISS_NUM
293 ,limit_uom_quantified OKS_K_LINES_V.LIMIT_UOM_QUANTIFIED%TYPE := OKC_API.G_MISS_CHAR
294 ,discount_amount NUMBER := OKC_API.G_MISS_NUM
295 ,discount_percent NUMBER := OKC_API.G_MISS_NUM
296 ,offset_duration NUMBER := OKC_API.G_MISS_NUM
297 ,offset_period OKS_K_LINES_V.OFFSET_PERIOD%TYPE := OKC_API.G_MISS_CHAR
298 ,incident_severity_id NUMBER := OKC_API.G_MISS_NUM
299 ,pdf_id NUMBER := OKC_API.G_MISS_NUM
300 ,work_thru_yn OKS_K_LINES_V.WORK_THRU_YN%TYPE := OKC_API.G_MISS_CHAR
301 ,react_active_yn OKS_K_LINES_V.REACT_ACTIVE_YN%TYPE := OKC_API.G_MISS_CHAR
302 ,transfer_option OKS_K_LINES_V.TRANSFER_OPTION%TYPE := OKC_API.G_MISS_CHAR
303 ,prod_upgrade_yn OKS_K_LINES_V.PROD_UPGRADE_YN%TYPE := OKC_API.G_MISS_CHAR
304 ,inheritance_type OKS_K_LINES_V.INHERITANCE_TYPE%TYPE := OKC_API.G_MISS_CHAR
305 ,pm_program_id NUMBER := OKC_API.G_MISS_NUM
306 ,pm_conf_req_yn OKS_K_LINES_V.PM_CONF_REQ_YN%TYPE := OKC_API.G_MISS_CHAR
307 ,pm_sch_exists_yn OKS_K_LINES_V.PM_SCH_EXISTS_YN%TYPE := OKC_API.G_MISS_CHAR
308 ,allow_bt_discount OKS_K_LINES_V.ALLOW_BT_DISCOUNT%TYPE := OKC_API.G_MISS_CHAR
309 ,apply_default_timezone OKS_K_LINES_V.APPLY_DEFAULT_TIMEZONE%TYPE := OKC_API.G_MISS_CHAR
310 ,sync_date_install OKS_K_LINES_V.SYNC_DATE_INSTALL%TYPE := OKC_API.G_MISS_CHAR
311 ,sfwt_flag OKS_K_LINES_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR
312 ,invoice_text OKS_K_LINES_V.INVOICE_TEXT%TYPE := OKC_API.G_MISS_CHAR
313 ,ib_trx_details OKS_K_LINES_V.IB_TRX_DETAILS%TYPE := OKC_API.G_MISS_CHAR
314 ,status_text OKS_K_LINES_V.STATUS_TEXT%TYPE := OKC_API.G_MISS_CHAR
315 ,react_time_name OKS_K_LINES_V.REACT_TIME_NAME%TYPE := OKC_API.G_MISS_CHAR
316 ,object_version_number NUMBER := OKC_API.G_MISS_NUM
317 ,security_group_id NUMBER := OKC_API.G_MISS_NUM
318 ,request_id NUMBER := OKC_API.G_MISS_NUM
319 ,created_by NUMBER := OKC_API.G_MISS_NUM
320 ,creation_date OKS_K_LINES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
321 ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
322 ,last_update_date OKS_K_LINES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
323 ,last_update_login NUMBER := OKC_API.G_MISS_NUM
324 ,major_version NUMBER := OKC_API.G_MISS_NUM);
325
326 TYPE klnv_tbl_type IS TABLE OF klnv_rec_type INDEX BY BINARY_INTEGER;
327
328 h_clev_tbl_in klnv_tbl_type;
329 i_clev_tbl_in klnv_tbl_type;
330
331 TYPE klt_rec_type is RECORD
332 (
333 ID OKS_K_LINES_TLH.ID%TYPE,
334 MAJOR_VERSION OKS_K_LINES_TLH.MAJOR_VERSION%TYPE,
335 LANGUAGE OKS_K_LINES_TLH.LANGUAGE%TYPE,
336 SOURCE_LANG OKS_K_LINES_TLH.SOURCE_LANG%TYPE,
337 SFWT_FLAG OKS_K_LINES_TLH.SFWT_FLAG%TYPE,
338 INVOICE_TEXT OKS_K_LINES_TLH.INVOICE_TEXT%TYPE,
339 IB_TRX_DETAILS OKS_K_LINES_TLH.IB_TRX_DETAILS%TYPE,
340 STATUS_TEXT OKS_K_LINES_TLH.STATUS_TEXT%TYPE,
341 REACT_TIME_NAME OKS_K_LINES_TLH.REACT_TIME_NAME%TYPE,
342 SECURITY_GROUP_ID OKS_K_LINES_TLH.SECURITY_GROUP_ID%TYPE,
343 CREATED_BY OKS_K_LINES_TLH.CREATED_BY%TYPE,
344 CREATION_DATE OKS_K_LINES_TLH.CREATION_DATE%TYPE,
345 LAST_UPDATED_BY OKS_K_LINES_TLH.LAST_UPDATED_BY%TYPE,
346 LAST_UPDATE_DATE OKS_K_LINES_TLH.LAST_UPDATE_DATE%TYPE,
347 LAST_UPDATE_LOGIN OKS_K_LINES_TLH.LAST_UPDATE_LOGIN%TYPE);
348
349 TYPE klt_tbl_type IS TABLE OF klt_rec_type INDEX BY BINARY_INTEGER;
350
351 x_clet_tbl_in klt_tbl_type;
352 l_clet_tbl_in klt_tbl_type;
353
354
355 TYPE oks_coverage_times_v_rec_type IS RECORD (
356 id NUMBER := OKC_API.G_MISS_NUM
357 ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
358 ,cov_tze_line_id NUMBER := OKC_API.G_MISS_NUM
359 ,start_hour NUMBER := OKC_API.G_MISS_NUM
360 ,start_minute NUMBER := OKC_API.G_MISS_NUM
361 ,end_hour NUMBER := OKC_API.G_MISS_NUM
362 ,end_minute NUMBER := OKC_API.G_MISS_NUM
363 ,monday_yn VARCHAR2(3) := NULL--OKS_COVERAGE_TIMES_V.MONDAY_YN%TYPE := OKC_API.G_MISS_CHAR
364 ,tuesday_yn VARCHAR2(3) := NULL--OKS_COVERAGE_TIMES_V.TUESDAY_YN%TYPE := OKC_API.G_MISS_CHAR
365 ,wednesday_yn VARCHAR2(3) := NULL--OKS_COVERAGE_TIMES_V.WEDNESDAY_YN%TYPE := OKC_API.G_MISS_CHAR
366 ,thursday_yn VARCHAR2(3) := NULL--OKS_COVERAGE_TIMES_V.THURSDAY_YN%TYPE := OKC_API.G_MISS_CHAR
367 ,friday_yn VARCHAR2(3) := NULL--OKS_COVERAGE_TIMES_V.FRIDAY_YN%TYPE := OKC_API.G_MISS_CHAR
368 ,saturday_yn VARCHAR2(3) := NULL--OKS_COVERAGE_TIMES_V.SATURDAY_YN%TYPE := OKC_API.G_MISS_CHAR
369 ,sunday_yn VARCHAR2(3) := NULL--OKS_COVERAGE_TIMES_V.SUNDAY_YN%TYPE := OKC_API.G_MISS_CHAR
370 ,security_group_id NUMBER := OKC_API.G_MISS_NUM
371 ,program_application_id NUMBER := OKC_API.G_MISS_NUM
372 ,program_id NUMBER := OKC_API.G_MISS_NUM
373 ,program_update_date OKS_COVERAGE_TIMES_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
374 ,request_id NUMBER := OKC_API.G_MISS_NUM
375 ,created_by NUMBER := OKC_API.G_MISS_NUM
376 ,creation_date OKS_COVERAGE_TIMES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
377 ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
378 ,last_update_date OKS_COVERAGE_TIMES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
379 ,last_update_login NUMBER := OKC_API.G_MISS_NUM
380 ,object_version_number NUMBER := OKC_API.G_MISS_NUM
381 ,major_version NUMBER := OKC_API.G_MISS_NUM);
382
383 TYPE oks_coverage_times_v_tbl_type IS TABLE OF oks_coverage_times_v_rec_type INDEX BY BINARY_INTEGER;
384
385 h_cvtv_tbl_in oks_coverage_times_v_tbl_type;
386 i_cvtv_tbl_in oks_coverage_times_v_tbl_type;
387
388 TYPE OksActionTimeTypesVRecType IS RECORD (
389 id NUMBER := OKC_API.G_MISS_NUM
390 ,cle_id NUMBER := OKC_API.G_MISS_NUM
391 ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
392 ,action_type_code OKS_ACTION_TIME_TYPES_V.ACTION_TYPE_CODE%TYPE := OKC_API.G_MISS_CHAR
393 ,security_group_id NUMBER := OKC_API.G_MISS_NUM
394 ,program_application_id NUMBER := OKC_API.G_MISS_NUM
395 ,program_id NUMBER := OKC_API.G_MISS_NUM
396 ,program_update_date OKS_ACTION_TIME_TYPES_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
397 ,request_id NUMBER := OKC_API.G_MISS_NUM
398 ,created_by NUMBER := OKC_API.G_MISS_NUM
399 ,creation_date OKS_ACTION_TIME_TYPES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
400 ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
401 ,last_update_date OKS_ACTION_TIME_TYPES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
402 ,last_update_login NUMBER := OKC_API.G_MISS_NUM
403 ,object_version_number NUMBER := OKC_API.G_MISS_NUM
404 ,major_version NUMBER := OKC_API.G_MISS_NUM);
405
406 TYPE OksActionTimeTypesVTblType IS TABLE OF OksActionTimeTypesVRecType INDEX BY BINARY_INTEGER;
407
408 h_actv_tbl_in OksActionTimeTypesVTblType;
409 i_actv_tbl_in OksActionTimeTypesVTblType;
410
411
412 l_clt_ctr NUMBER :=0;
413
414 PROCEDURE COVERAGE_HISTORY_MIGRATION ( p_start_rowid IN ROWID,
415 p_end_rowid IN ROWID,
416 x_return_status OUT NOCOPY VARCHAR2,
417 x_message_data OUT NOCOPY VARCHAR2);
418 -- Migrate the History For Coverage Header From Rules Architecture To New Architecture.
419
420
421 PROCEDURE Buss_Proc_History_migration( p_start_rowid IN ROWID,
422 p_end_rowid IN ROWID,
423 x_return_status OUT NOCOPY VARCHAR2,
424 x_message_data OUT NOCOPY VARCHAR2);
425
426 -- Migrate the History For Business Process From Rules Architecture To New Architecture.
427
428 PROCEDURE COV_TIMES_History_MIGRATION( p_start_rowid IN ROWID,
429 p_end_rowid IN ROWID,
430 x_return_status OUT NOCOPY VARCHAR2,
431 x_message_data OUT NOCOPY VARCHAR2);
432
433 -- Migrate the History For Coverage Times From Rules Architecture To New Architecture.
434
435 PROCEDURE Reaction_Time_Hist_migration( p_start_rowid IN ROWID,
436 p_end_rowid IN ROWID,
437 x_return_status OUT NOCOPY VARCHAR2,
438 x_message_data OUT NOCOPY VARCHAR2);
439 -- Migrate the History For Reaction Times From Rules Architecture To New Architecture.
440
441 PROCEDURE React_TimeVal_Hist_Migration( x_return_status OUT NOCOPY VARCHAR2,
442 x_message_data OUT NOCOPY VARCHAR2);
443 -- Migrate the History For Reaction Time Values From Rules Architecture To New Architecture.
444
445 PROCEDURE BILL_TYPE_HIST_MIGRATION( p_start_rowid IN ROWID,
446 p_end_rowid IN ROWID,
447 x_return_status OUT NOCOPY VARCHAR2,
448 x_message_data OUT NOCOPY VARCHAR2);
449
450
451 -- Migrate the History For Bill Types From Rules Architecture To New Architecture.
452
453 /******************************************HISTORY*************************************************************/
454
455 END OKS_COVERAGE_MIGRATION; -- Package Specification OKS_COVERAGE_MIGRATION
456