[Home] [Help]
PACKAGE: APPS.OKS_COVERAGES_PVT
Source
1 PACKAGE OKS_COVERAGES_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKSRMCVS.pls 120.5.12000000.1 2007/01/16 22:11:14 appldev ship $*/
3
4 TYPE jtf_note_rec_type IS RECORD(
5 JTF_NOTE_ID NUMBER,
6 SOURCE_OBJECT_CODE VARCHAR2(240),
7 NOTE_STATUS VARCHAR2(240),
8 NOTE_TYPE VARCHAR2(240),
9 NOTES VARCHAR2(2000),
10 NOTES_DETAIL VARCHAR2(32767),
11 -- Modified by Jvorugan for Bug:4489214 who columns not to be populated from old contract
12 /* Created_By NUMBER,
13 LAst_Updated_By Number,
14 LAst_Update_Login Number */
15 ENTERED_BY NUMBER,
16 ENTERED_DATE DATE );
17 -- End of changes for Bug:4489214
18
19 TYPE jtf_note_tbl_type IS TABLE of jtf_note_rec_type INDEX BY BINARY_INTEGER;
20 L_Notes_TBL jtf_note_tbl_type;
21
22 TYPE ac_rec_type IS RECORD(Svc_cle_Id NUMBER,
23 Tmp_cle_Id NUMBER,
24 Start_date Date,
25 End_Date Date,
26 RLE_CODE VARCHAR2(40));
27 ac_rec_in ac_rec_type;
28 ---------------------------------------------------------------------------
29 -- GLOBAL MESSAGE CONSTANTS
30 ---------------------------------------------------------------------------
31 G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
32 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
33 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
34 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
35 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
36 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
37 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
38 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
39 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
40 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
41 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_UNEXP_ERROR';
42 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
43 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
44 ------------------------------------------------------------------------------------
45 -- GLOBAL EXCEPTION
46 ---------------------------------------------------------------------------
47 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
48 G_EXCEPTION_RULE_UPDATE EXCEPTION;
49 G_EXCEPTION_BRS_UPDATE EXCEPTION;
50
51 -- GLOBAL VARIABLES
52 ---------------------------------------------------------------------------
53 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKS_COVERAGES_PVT';
54 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
55 ---------------------------------------------------------------------------
56
57 G_DEBUG_ENABLED VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
58
59 PROCEDURE Validate_svc_cle_id(
60 p_ac_rec IN ac_rec_type,
61 x_return_status OUT NOCOPY VARCHAR2);
62 PROCEDURE Validate_Tmp_cle_id(
63 p_ac_rec IN ac_rec_type,
64 x_template_yn OUT NOCOPY VARCHAR2,
65 x_return_status OUT NOCOPY VARCHAR2);
66 PROCEDURE Validate_Line_id(
67 p_line_id IN NUMBER,
68 x_return_status OUT NOCOPY VARCHAR2);
69 PROCEDURE CREATE_ACTUAL_COVERAGE(
70 p_api_version IN NUMBER,
71 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
72 x_return_status OUT NOCOPY VARCHAR2,
73 x_msg_count OUT NOCOPY NUMBER,
74 x_msg_data OUT NOCOPY VARCHAR2,
75 p_ac_rec_in IN ac_rec_type,
76 p_restricted_update IN VARCHAR2 DEFAULT 'F',
77 x_Actual_coverage_id OUT NOCOPY NUMBER);
78 PROCEDURE Undo_Header(
79 p_api_version IN NUMBER,
80 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
81 x_return_status OUT NOCOPY VARCHAR2,
82 x_msg_count OUT NOCOPY NUMBER,
83 x_msg_data OUT NOCOPY VARCHAR2,
84 P_Header_id IN NUMBER);
85 PROCEDURE Undo_Line(
86 p_api_version IN NUMBER,
87 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
88 x_return_status OUT NOCOPY VARCHAR2,
89 x_msg_count OUT NOCOPY NUMBER,
90 x_msg_data OUT NOCOPY VARCHAR2,
91 P_Line_Id IN NUMBER);
92
93 /* New one with validate status */
94 PROCEDURE Undo_Line(
95 p_api_version IN NUMBER,
96 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
97 p_validate_status IN VARCHAR2 DEFAULT 'N',
98 x_return_status OUT NOCOPY VARCHAR2,
99 x_msg_count OUT NOCOPY NUMBER,
100 x_msg_data OUT NOCOPY VARCHAR2,
101 P_Line_Id IN NUMBER);
102
103 PROCEDURE UNDO_EVENTS (P_Kline_Id IN NUMBER,
104 x_Return_Status OUT NOCOPY VARCHAR2,
105 x_msg_data OUT NOCOPY VARCHAR2);
106
107 PROCEDURE UNDO_Counters (P_Kline_Id IN NUMBER,
108 x_Return_Status OUT NOCOPY VARCHAR2,
109 x_msg_data OUT NOCOPY VARCHAR2);
110 PROCEDURE Update_COVERAGE_Effectivity(
111 p_api_version IN NUMBER,
112 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
113 x_return_status OUT NOCOPY VARCHAR2,
114 x_msg_count OUT NOCOPY NUMBER,
115 x_msg_data OUT NOCOPY VARCHAR2,
116 p_service_Line_Id IN NUMBER,
117 p_New_Start_Date IN DATE,
118 p_New_End_Date IN DATE) ;
119
120 PROCEDURE Init_CLEV(P_CLEV_tbl_in_Out IN OUT NOCOPY okc_contract_pub.Clev_tbl_type);
121 PROCEDURE Init_CTCV(P_CTCV_tbl_in_Out IN OUT NOCOPY okc_contract_party_pub.Ctcv_tbl_type);
122 PROCEDURE Init_CIMV(P_CIMV_tbl_in_Out IN OUT NOCOPY okc_contract_item_pub.Cimv_tbl_type);
123
124 /*
125 --PROCEDURE Init_RGPV(P_RGPV_tbl_in_out IN OUT NOCOPY okc_Rule_pub.Rgpv_tbl_type);
126 --PROCEDURE Init_RULV(P_RULV_tbl_in_out IN OUT NOCOPY okc_Rule_Pub.Rulv_tbl_type);
127 --PROCEDURE Init_ATEV(P_ATEV_tbl_in_Out IN OUT NOCOPY okc_article_pub.Atev_tbl_type);
128 --PROCEDURE Init_RILV(P_RILV_tbl_in_Out IN OUT NOCOPY okc_rule_pub.Rilv_tbl_type);
129 PROCEDURE Init_TGDV(P_TGDV_EXT_tbl_In_Out IN OUT NOCOPY okc_time_pub.TGDV_Ext_tbl_TYPE);
130 PROCEDURE Init_IGSV(P_IGSV_EXT_tbl_In_Out IN OUT NOCOPY okc_time_pub.Igsv_Ext_tbl_TYPE);
131 PROCEDURE Init_ISEV(P_ISEV_EXT_tbl_In_Out IN OUT NOCOPY okc_time_pub.Isev_Ext_tbl_TYPE);
132 --PROCEDURE Init_CTIV(P_CTIV_tbl_In_Out IN OUT NOCOPY okc_rule_pub.Ctiv_tbl_type);
133 */
134
135 PROCEDURE INIT_BILL_RATE_LINE(x_bill_rate_tbl OUT NOCOPY OKS_BRS_PVT.OKSBILLRATESCHEDULESVTBLTYPE);
136
137
138 PROCEDURE CREATE_ADJUSTED_COVERAGE(
139 p_api_version IN NUMBER,
140 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
141 x_return_status OUT NOCOPY VARCHAR2,
142 x_msg_count OUT NOCOPY NUMBER,
143 x_msg_data OUT NOCOPY VARCHAR2,
144 P_Source_contract_Line_Id IN NUMBER,
145 P_Target_contract_Line_Id IN NUMBER,
146 x_Actual_coverage_id OUT NOCOPY NUMBER);
147
148
149
150 TYPE res_rec_type IS RECORD
151 (bp_id OKC_K_ITEMS_V.OBJECT1_ID1%TYPE,
152 cro_code OKC_CONTACTS_V.CRO_CODE%TYPE,
153 object1_id1 OKC_CONTACTS_V.object1_id1%TYPE,
154 resource_class OKC_CONTACTS_V.RESOURCE_CLASS%TYPE);
155
156 TYPE res_tbl_type IS TABLE OF res_rec_type
157 INDEX BY BINARY_INTEGER ;
158
159 x_source_res_tbl_type res_tbl_type;
160 x_target_res_tbl_type res_tbl_type;
161
162
163
164 TYPE bp_rec_type IS RECORD
165 (object1_id1 OKC_K_ITEMS_V.OBJECT1_ID1%TYPE,
166 bp_line_id OKC_K_LINES_V.ID%TYPE,
167 start_date DATE,
168 end_date DATE);
169
170 TYPE bp_tbl_type IS TABLE OF bp_rec_type
171 INDEX BY BINARY_INTEGER;
172
173 x_source_bp_tbl_type bp_tbl_type ;
174 x_target_bp_tbl_type bp_tbl_type ;
175
176 TYPE bp_line_rec_type IS RECORD
177 (bp_id OKC_K_ITEMS_V.OBJECT1_ID1%TYPE,
178 src_bp_line_id OKC_K_LINES_V.ID%TYPE,
179 tgt_bp_line_id OKC_K_LINES_V.ID%TYPE);
180
181 TYPE bp_line_tbl_type IS TABLE OF bp_line_rec_type INDEX BY BINARY_INTEGER;
182
183 l_bp_tbl bp_line_tbl_type;
184
185
186 TYPE COVER_TIME_REC_TYPE IS RECORD
187 (OBJECT1_ID1 OKC_K_ITEMS_V.OBJECT1_ID1%TYPE,
188 START_DAY OKC_TIMEVALUES_V.DAY_OF_WEEK%TYPE,
189 START_HOUR OKC_TIMEVALUES_V.HOUR%TYPE,
190 START_MINUTE OKC_TIMEVALUES_V.MINUTE%TYPE,
191 END_DAY OKC_TIMEVALUES_V.DAY_OF_WEEK%TYPE,
192 END_HOUR OKC_TIMEVALUES_V.HOUR%TYPE,
193 END_MINUTE OKC_TIMEVALUES_V.MINUTE%TYPE);
194
195 TYPE COVER_TIME_TBL_TYPE IS TABLE OF COVER_TIME_REC_TYPE
196 INDEX BY BINARY_INTEGER;
197
198 x_source_cover_tbl cover_time_tbl_type ;
199 x_target_cover_tbl cover_time_tbl_type ;
200
201
202
203 TYPE brs_rec_type IS RECORD
204 (START_HOUR OKS_BILLRATE_SCHEDULES.START_HOUR%TYPE,
205 START_MINUTE OKS_BILLRATE_SCHEDULES.START_MINUTE%TYPE,
206 END_HOUR OKS_BILLRATE_SCHEDULES.END_MINUTE%TYPE,
207 END_MINUTE OKS_BILLRATE_SCHEDULES.END_MINUTE%TYPE,
208 MONDAY_FLAG OKS_BILLRATE_SCHEDULES.MONDAY_FLAG%TYPE,
209 TUESDAY_FLAG OKS_BILLRATE_SCHEDULES.TUESDAY_FLAG%TYPE,
210 WEDNESDAY_FLAG OKS_BILLRATE_SCHEDULES.WEDNESDAY_FLAG%TYPE,
211 THURSDAY_FLAG OKS_BILLRATE_SCHEDULES.THURSDAY_FLAG%TYPE,
212 FRIDAY_FLAG OKS_BILLRATE_SCHEDULES.FRIDAY_FLAG%TYPE,
213 SATURDAY_FLAG OKS_BILLRATE_SCHEDULES.SATURDAY_FLAG%TYPE,
214 SUNDAY_FLAG OKS_BILLRATE_SCHEDULES.SUNDAY_FLAG%TYPE,
215 OBJECT1_ID1 OKS_BILLRATE_SCHEDULES.OBJECT1_ID1%TYPE,
216 OBJECT1_ID2 OKS_BILLRATE_SCHEDULES.OBJECT1_ID2%TYPE,
217 JTOT_OBJECT1_CODE OKS_BILLRATE_SCHEDULES.JTOT_OBJECT1_CODE%TYPE,
218 BILL_RATE_CODE OKS_BILLRATE_SCHEDULES.BILL_RATE_CODE%TYPE,
219 FLAT_RATE OKS_BILLRATE_SCHEDULES.FLAT_RATE%TYPE,
220 UOM OKS_BILLRATE_SCHEDULES.UOM%TYPE,
221 HOLIDAY_YN OKS_BILLRATE_SCHEDULES.HOLIDAY_YN%TYPE,
222 PERCENT_OVER_LIST_PRICE OKS_BILLRATE_SCHEDULES.PERCENT_OVER_LIST_PRICE%TYPE);
223
224 TYPE brs_tbl_type IS TABLE OF brs_rec_type
225 INDEX BY BINARY_INTEGER;
226
227 x_source_brs_tbl brs_tbl_type;
228 x_target_brs_tbl brs_tbl_type;
229
230
231 TYPE billrate_day_overlap_type IS RECORD
232 (monday_overlap VARCHAR2(1),
233 tuesday_overlap VARCHAR2(1),
234 wednesday_overlap VARCHAR2(1),
235 thursday_overlap VARCHAR2(1),
236 friday_overlap VARCHAR2(1),
237 saturday_overlap VARCHAR2(1),
238 sunday_overlap VARCHAR2(1));
239
240
241
242 PROCEDURE Validate_billrate_schedule(p_billtype_line_id IN NUMBER,
243 p_holiday_yn IN varchar2,
244 x_days_overlap OUT NOCOPY billrate_day_overlap_type,
245 x_return_status OUT NOCOPY VARCHAR2);
246
247 PROCEDURE OKS_MIGRATE_BILLRATES(
248 p_api_version IN NUMBER,
249 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
250 x_return_status OUT NOCOPY VARCHAR2,
251 x_msg_count OUT NOCOPY NUMBER,
252 x_msg_data OUT NOCOPY VARCHAR2);
253
254 PROCEDURE INIT_CONTRACT_LINE (x_clev_tbl OUT NOCOPY OKC_CONTRACT_PUB.clev_tbl_type);
255
256
257 TYPE time_labor_rec IS RECORD
258 (
259 START_TIME DATE,
260 END_TIME DATE,
261 MONDAY_FLAG VARCHAR2(1),
262 TUESDAY_FLAG VARCHAR2(1),
263 WEDNESDAY_FLAG VARCHAR2(1),
264 THURSDAY_FLAG VARCHAR2(1),
265 FRIDAY_FLAG VARCHAR2(1),
266 SATURDAY_FLAG VARCHAR2(1),
267 SUNDAY_FLAG VARCHAR2(1),
268 HOLIDAY_FLAG VARCHAR2(1),
269 INVENTORY_ITEM_ID NUMBER,
270 LABOR_CODE VARCHAR2(30));
271
272
273 TYPE time_labor_tbl IS TABLE OF time_labor_rec
274 INDEX BY BINARY_INTEGER;
275
276
277
278 PROCEDURE OKS_BILLRATE_MAPPING(
279 p_api_version IN NUMBER ,
280 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
281 p_business_process_id IN NUMBER,
282 p_time_labor_tbl_in IN time_labor_tbl,
283 x_return_status OUT NOCOPY VARCHAR2,
284 x_msg_count OUT NOCOPY NUMBER,
285 x_msg_data OUT NOCOPY VARCHAR2);
286
287 PROCEDURE Copy_Coverage(p_api_version IN NUMBER,
288 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
289 x_return_status OUT NOCOPY VARCHAR2,
290 x_msg_count OUT NOCOPY NUMBER,
291 x_msg_data OUT NOCOPY VARCHAR2,
292 p_contract_line_id IN NUMBER);
293
294
295 PROCEDURE VALIDATE_COVERTIME(p_tze_line_id IN NUMBER,
296 x_days_overlap OUT NOCOPY oks_coverages_pvt.billrate_day_overlap_type,
297 x_return_status OUT NOCOPY VARCHAR2);
298
299
300 PROCEDURE INIT_OKS_K_LINE(x_klnv_tbl OUT NOCOPY oks_kln_pvt.klnv_tbl_type);
301 PROCEDURE INIT_OKS_TIMEZONE_LINE(x_timezone_tbl OUT NOCOPY oks_ctz_pvt.OksCoverageTimezonesVTblType);
302 PROCEDURE INIT_OKS_COVER_TIME_LINE(x_cover_time_tbl OUT NOCOPY oks_cvt_pvt.oks_coverage_times_v_tbl_type);
303 PROCEDURE INIT_OKS_ACT_TYPE(x_act_time_tbl OUT NOCOPY OKS_ACT_PVT.OksActionTimeTypesVTblType);
304 PROCEDURE INIT_OKS_ACT_TIME(x_act_type_tbl OUT NOCOPY OKS_ACM_PVT.oks_action_times_v_tbl_type);
305
306
307 PROCEDURE MIGRATE_PRIMARY_RESOURCES(p_api_version IN NUMBER,
308 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
309 x_return_status OUT NOCOPY VARCHAR2,
310 x_msg_count OUT NOCOPY NUMBER,
311 x_msg_data OUT NOCOPY VARCHAR2) ;
312
313 --------------------CHECK COVERAGE MATCH------------------------------------------
314 TYPE oks_bp_rec IS RECORD
315 (PRICE_LIST_ID OKC_K_LINES_B.PRICE_LIST_ID%TYPE,
316 OBJECT1_ID1 OKC_K_ITEMS.OBJECT1_ID1%TYPE,
317 DISCOUNT_LIST OKS_K_LINES_B.DISCOUNT_LIST%TYPE,
318 OFFSET_DURATION OKS_K_LINES_B.OFFSET_DURATION%TYPE,
319 OFFSET_PERIOD OKS_K_LINES_B.OFFSET_PERIOD%TYPE,
320 ALLOW_BT_DISCOUNT OKS_K_LINES_B.ALLOW_BT_DISCOUNT%TYPE,
321 APPLY_DEFAULT_TIMEZONE OKS_K_LINES_B.APPLY_DEFAULT_TIMEZONE%TYPE);
322
323 TYPE oks_bp_tbl IS TABLE OF oks_bp_rec
324 INDEX BY BINARY_INTEGER;
325
326 x_source_bp_tbl oks_bp_tbl;
327 x_target_bp_tbl oks_bp_tbl;
328
329 TYPE bp_cover_time_rec IS RECORD
330 (object1_id1 OKC_K_ITEMS.object1_id1%TYPE,
331 timezone_id OKS_COVERAGE_TIMEZONES.timezone_id%TYPE,
332 default_yn OKS_COVERAGE_TIMEZONES.default_yn%TYPE,
333 start_hour OKS_COVERAGE_TIMES.start_hour%TYPE,
334 start_minute OKS_COVERAGE_TIMES.start_minute%TYPE,
335 end_hour OKS_COVERAGE_TIMES.end_hour%TYPE,
336 end_minute OKS_COVERAGE_TIMES.end_minute%TYPE,
337 monday_yn OKS_COVERAGE_TIMES.monday_yn%TYPE,
338 tuesday_yn OKS_COVERAGE_TIMES.tuesday_yn%TYPE,
339 wednesday_yn OKS_COVERAGE_TIMES.wednesday_yn%TYPE,
340 thursday_yn OKS_COVERAGE_TIMES.thursday_yn%TYPE,
341 friday_yn OKS_COVERAGE_TIMES.friday_yn%TYPE,
342 saturday_yn OKS_COVERAGE_TIMES.saturday_yn%TYPE,
343 sunday_yn OKS_COVERAGE_TIMES.sunday_yn%TYPE);
344
345 TYPE bp_cover_time_tbl IS TABLE OF bp_cover_time_rec
346 INDEX BY BINARY_INTEGER;
347
348 x_source_bp_cover_time_tbl bp_cover_time_tbl;
349 x_target_bp_cover_time_tbl bp_cover_time_tbl;
350
351 TYPE react_time_rec IS RECORD
352 (incident_severity_id OKS_K_LINES_V.INCIDENT_SEVERITY_ID%TYPE,
353 pdf_id OKS_K_LINES_V.PDF_ID%TYPE,
354 work_thru_yn OKS_K_LINES_V.WORK_THRU_YN%TYPE,
355 react_active_yn OKS_K_LINES_V.REACT_ACTIVE_YN%TYPE,
356 react_time_name OKS_K_LINES_V.REACT_TIME_NAME%TYPE,
357 action_type_code OKS_ACTION_TIME_TYPES.ACTION_TYPE_CODE%TYPE,
358 uom_code OKS_ACTION_TIMES.UOM_CODE%TYPE,
359 sun_duration OKS_ACTION_TIMES.SUN_DURATION%TYPE,
360 mon_duration OKS_ACTION_TIMES.MON_DURATION%TYPE,
361 tue_duration OKS_ACTION_TIMES.TUE_DURATION%TYPE,
362 wed_duration OKS_ACTION_TIMES.WED_DURATION%TYPE,
363 thu_duration OKS_ACTION_TIMES.THU_DURATION%TYPE,
364 fri_duration OKS_ACTION_TIMES.FRI_DURATION%TYPE,
365 sat_duration OKS_ACTION_TIMES.SAT_DURATION%TYPE);
366
367 TYPE react_time_tbl IS TABLE OF react_time_rec
368 INDEX BY BINARY_INTEGER;
369
370 x_source_react_time_tbl react_time_tbl;
371 x_target_react_time_tbl react_time_tbl;
372
373 TYPE bill_type_rec IS RECORD
374 (object1_id1 OKC_K_ITEMS_V.OBJECT1_ID1%TYPE,
375 bill_type_line_id NUMBER,
376 billing_type VARCHAR2(30),
377 discount_amount OKS_K_LINES_B.DISCOUNT_AMOUNT%TYPE,
378 discount_percent OKS_K_LINES_B.DISCOUNT_PERCENT%TYPE);
379
380 TYPE bill_type_tbl IS TABLE OF bill_type_rec INDEX BY BINARY_INTEGER;
381
382 x_source_bill_tbl bill_type_tbl;
383 x_target_bill_tbl bill_type_tbl;
384
385
386 Procedure CHECK_COVERAGE_MATCH
387 ( p_api_version IN NUMBER,
388 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
389 x_return_status OUT NOCOPY VARCHAR2,
390 x_msg_count OUT NOCOPY NUMBER,
391 x_msg_data OUT NOCOPY VARCHAR2,
392 P_Source_contract_Line_Id IN NUMBER,
393 P_Target_contract_Line_Id IN NUMBER,
394 x_coverage_match OUT NOCOPY VARCHAR2);
395
396 -- The Following API checks for the Business Procees Line Id IF Time Zone Exists.Returns 'Y' If exists else 'N'
397 Procedure CHECK_TimeZone_Exists
398 ( p_api_version IN NUMBER,
399 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
400 x_return_status OUT NOCOPY VARCHAR2,
401 x_msg_count OUT NOCOPY NUMBER,
402 x_msg_data OUT NOCOPY VARCHAR2,
403 P_BP_Line_ID IN NUMBER,
404 P_TimeZone_Id IN NUMBER,
405 x_TimeZone_Exists OUT NOCOPY VARCHAR2);
406
407
408
409
410
411 PROCEDURE version_Coverage(
412 p_api_version IN NUMBER,
413 p_init_msg_list IN VARCHAR2,
414 x_return_status OUT NOCOPY VARCHAR2,
415 x_msg_count OUT NOCOPY NUMBER,
416 x_msg_data OUT NOCOPY VARCHAR2,
417 p_chr_id IN NUMBER,
418 p_major_version IN NUMBER);
419
420
421 PROCEDURE Restore_Coverage(
422 p_api_version IN NUMBER,
423 p_init_msg_list IN VARCHAR2,
424 x_return_status OUT NOCOPY VARCHAR2,
425 x_msg_count OUT NOCOPY NUMBER,
426 x_msg_data OUT NOCOPY VARCHAR2,
427 p_chr_id IN NUMBER);
428
429 PROCEDURE Delete_History(
430 p_api_version IN NUMBER,
431 p_init_msg_list IN VARCHAR2,
432 x_return_status OUT NOCOPY VARCHAR2,
433 x_msg_count OUT NOCOPY NUMBER,
434 x_msg_data OUT NOCOPY VARCHAR2,
435 p_chr_id IN NUMBER);
436
437
438 PROCEDURE Delete_Saved_Version(
439 p_api_version IN NUMBER,
440 p_init_msg_list IN VARCHAR2,
441 x_return_status OUT NOCOPY VARCHAR2,
442 x_msg_count OUT NOCOPY NUMBER,
443 x_msg_data OUT NOCOPY VARCHAR2,
444 p_chr_id IN NUMBER);
445
446 PROCEDURE COPY_K_HDR_NOTES
447 (p_api_version IN NUMBER ,
448 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
449 p_chr_id IN NUMBER,
450 x_return_status OUT NOCOPY VARCHAR2,
451 x_msg_count OUT NOCOPY NUMBER,
452 x_msg_data OUT NOCOPY VARCHAR2);
453
454
455
456 PROCEDURE Update_dnz_chr_id
457 (p_coverage_id IN NUMBER ,
458 p_dnz_chr_id IN NUMBER);
459
460
461 PROCEDURE Create_K_coverage_ext(p_api_version IN NUMBER,
462 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
463 p_src_line_id IN NUMBER,
464 p_tgt_line_id IN NUMBER,
465 x_return_status OUT NOCOPY VARCHAR2,
466 x_msg_count OUT NOCOPY NUMBER,
467 x_msg_data OUT NOCOPY VARCHAR2);
468
469 PROCEDURE COPY_NOTES
470 (p_api_version IN NUMBER ,
471 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
472 p_line_id IN NUMBER,
473 x_return_status OUT NOCOPY VARCHAR2,
474 x_msg_count OUT NOCOPY NUMBER,
475 x_msg_data OUT NOCOPY VARCHAR2);
476 --New procedure for copy coverage functionality
477 PROCEDURE COPY_STANDARD_COVERAGE(
478 p_api_version IN NUMBER,
479 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
480 x_return_status OUT NOCOPY VARCHAR2,
481 x_msg_count OUT NOCOPY NUMBER,
482 x_msg_data OUT NOCOPY VARCHAR2,
483 P_old_coverage_id IN NUMBER,
484 P_new_coverage_name IN VARCHAR2,
485 x_new_coverage_id OUT NOCOPY NUMBER);
486
487 END OKS_COVERAGES_PVT;
488