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;
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;
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
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
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
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
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
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
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
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
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
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
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:
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:
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
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