4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: -- OKS_COVERAGE_TIMES_V Record Spec
7: TYPE oks_coverage_times_v_rec_type IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
10: ,cov_tze_line_id NUMBER := OKC_API.G_MISS_NUM
11: ,start_hour NUMBER := OKC_API.G_MISS_NUM
12: ,start_minute NUMBER := OKC_API.G_MISS_NUM
5: ---------------------------------------------------------------------------
6: -- OKS_COVERAGE_TIMES_V Record Spec
7: TYPE oks_coverage_times_v_rec_type IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
10: ,cov_tze_line_id NUMBER := OKC_API.G_MISS_NUM
11: ,start_hour NUMBER := OKC_API.G_MISS_NUM
12: ,start_minute NUMBER := OKC_API.G_MISS_NUM
13: ,end_hour NUMBER := OKC_API.G_MISS_NUM
6: -- OKS_COVERAGE_TIMES_V Record Spec
7: TYPE oks_coverage_times_v_rec_type IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
10: ,cov_tze_line_id NUMBER := OKC_API.G_MISS_NUM
11: ,start_hour NUMBER := OKC_API.G_MISS_NUM
12: ,start_minute NUMBER := OKC_API.G_MISS_NUM
13: ,end_hour NUMBER := OKC_API.G_MISS_NUM
14: ,end_minute NUMBER := OKC_API.G_MISS_NUM
7: TYPE oks_coverage_times_v_rec_type IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
10: ,cov_tze_line_id NUMBER := OKC_API.G_MISS_NUM
11: ,start_hour NUMBER := OKC_API.G_MISS_NUM
12: ,start_minute NUMBER := OKC_API.G_MISS_NUM
13: ,end_hour NUMBER := OKC_API.G_MISS_NUM
14: ,end_minute NUMBER := OKC_API.G_MISS_NUM
15: ,monday_yn OKS_COVERAGE_TIMES_V.MONDAY_YN%TYPE := OKC_API.G_MISS_CHAR
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
10: ,cov_tze_line_id NUMBER := OKC_API.G_MISS_NUM
11: ,start_hour NUMBER := OKC_API.G_MISS_NUM
12: ,start_minute NUMBER := OKC_API.G_MISS_NUM
13: ,end_hour NUMBER := OKC_API.G_MISS_NUM
14: ,end_minute NUMBER := OKC_API.G_MISS_NUM
15: ,monday_yn OKS_COVERAGE_TIMES_V.MONDAY_YN%TYPE := OKC_API.G_MISS_CHAR
16: ,tuesday_yn OKS_COVERAGE_TIMES_V.TUESDAY_YN%TYPE := OKC_API.G_MISS_CHAR
9: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
10: ,cov_tze_line_id NUMBER := OKC_API.G_MISS_NUM
11: ,start_hour NUMBER := OKC_API.G_MISS_NUM
12: ,start_minute NUMBER := OKC_API.G_MISS_NUM
13: ,end_hour NUMBER := OKC_API.G_MISS_NUM
14: ,end_minute NUMBER := OKC_API.G_MISS_NUM
15: ,monday_yn OKS_COVERAGE_TIMES_V.MONDAY_YN%TYPE := OKC_API.G_MISS_CHAR
16: ,tuesday_yn OKS_COVERAGE_TIMES_V.TUESDAY_YN%TYPE := OKC_API.G_MISS_CHAR
17: ,wednesday_yn OKS_COVERAGE_TIMES_V.WEDNESDAY_YN%TYPE := OKC_API.G_MISS_CHAR
10: ,cov_tze_line_id NUMBER := OKC_API.G_MISS_NUM
11: ,start_hour NUMBER := OKC_API.G_MISS_NUM
12: ,start_minute NUMBER := OKC_API.G_MISS_NUM
13: ,end_hour NUMBER := OKC_API.G_MISS_NUM
14: ,end_minute NUMBER := OKC_API.G_MISS_NUM
15: ,monday_yn OKS_COVERAGE_TIMES_V.MONDAY_YN%TYPE := OKC_API.G_MISS_CHAR
16: ,tuesday_yn OKS_COVERAGE_TIMES_V.TUESDAY_YN%TYPE := OKC_API.G_MISS_CHAR
17: ,wednesday_yn OKS_COVERAGE_TIMES_V.WEDNESDAY_YN%TYPE := OKC_API.G_MISS_CHAR
18: ,thursday_yn OKS_COVERAGE_TIMES_V.THURSDAY_YN%TYPE := OKC_API.G_MISS_CHAR
11: ,start_hour NUMBER := OKC_API.G_MISS_NUM
12: ,start_minute NUMBER := OKC_API.G_MISS_NUM
13: ,end_hour NUMBER := OKC_API.G_MISS_NUM
14: ,end_minute NUMBER := OKC_API.G_MISS_NUM
15: ,monday_yn OKS_COVERAGE_TIMES_V.MONDAY_YN%TYPE := OKC_API.G_MISS_CHAR
16: ,tuesday_yn OKS_COVERAGE_TIMES_V.TUESDAY_YN%TYPE := OKC_API.G_MISS_CHAR
17: ,wednesday_yn OKS_COVERAGE_TIMES_V.WEDNESDAY_YN%TYPE := OKC_API.G_MISS_CHAR
18: ,thursday_yn OKS_COVERAGE_TIMES_V.THURSDAY_YN%TYPE := OKC_API.G_MISS_CHAR
19: ,friday_yn OKS_COVERAGE_TIMES_V.FRIDAY_YN%TYPE := OKC_API.G_MISS_CHAR
12: ,start_minute NUMBER := OKC_API.G_MISS_NUM
13: ,end_hour NUMBER := OKC_API.G_MISS_NUM
14: ,end_minute NUMBER := OKC_API.G_MISS_NUM
15: ,monday_yn OKS_COVERAGE_TIMES_V.MONDAY_YN%TYPE := OKC_API.G_MISS_CHAR
16: ,tuesday_yn OKS_COVERAGE_TIMES_V.TUESDAY_YN%TYPE := OKC_API.G_MISS_CHAR
17: ,wednesday_yn OKS_COVERAGE_TIMES_V.WEDNESDAY_YN%TYPE := OKC_API.G_MISS_CHAR
18: ,thursday_yn OKS_COVERAGE_TIMES_V.THURSDAY_YN%TYPE := OKC_API.G_MISS_CHAR
19: ,friday_yn OKS_COVERAGE_TIMES_V.FRIDAY_YN%TYPE := OKC_API.G_MISS_CHAR
20: ,saturday_yn OKS_COVERAGE_TIMES_V.SATURDAY_YN%TYPE := OKC_API.G_MISS_CHAR
13: ,end_hour NUMBER := OKC_API.G_MISS_NUM
14: ,end_minute NUMBER := OKC_API.G_MISS_NUM
15: ,monday_yn OKS_COVERAGE_TIMES_V.MONDAY_YN%TYPE := OKC_API.G_MISS_CHAR
16: ,tuesday_yn OKS_COVERAGE_TIMES_V.TUESDAY_YN%TYPE := OKC_API.G_MISS_CHAR
17: ,wednesday_yn OKS_COVERAGE_TIMES_V.WEDNESDAY_YN%TYPE := OKC_API.G_MISS_CHAR
18: ,thursday_yn OKS_COVERAGE_TIMES_V.THURSDAY_YN%TYPE := OKC_API.G_MISS_CHAR
19: ,friday_yn OKS_COVERAGE_TIMES_V.FRIDAY_YN%TYPE := OKC_API.G_MISS_CHAR
20: ,saturday_yn OKS_COVERAGE_TIMES_V.SATURDAY_YN%TYPE := OKC_API.G_MISS_CHAR
21: ,sunday_yn OKS_COVERAGE_TIMES_V.SUNDAY_YN%TYPE := OKC_API.G_MISS_CHAR
14: ,end_minute NUMBER := OKC_API.G_MISS_NUM
15: ,monday_yn OKS_COVERAGE_TIMES_V.MONDAY_YN%TYPE := OKC_API.G_MISS_CHAR
16: ,tuesday_yn OKS_COVERAGE_TIMES_V.TUESDAY_YN%TYPE := OKC_API.G_MISS_CHAR
17: ,wednesday_yn OKS_COVERAGE_TIMES_V.WEDNESDAY_YN%TYPE := OKC_API.G_MISS_CHAR
18: ,thursday_yn OKS_COVERAGE_TIMES_V.THURSDAY_YN%TYPE := OKC_API.G_MISS_CHAR
19: ,friday_yn OKS_COVERAGE_TIMES_V.FRIDAY_YN%TYPE := OKC_API.G_MISS_CHAR
20: ,saturday_yn OKS_COVERAGE_TIMES_V.SATURDAY_YN%TYPE := OKC_API.G_MISS_CHAR
21: ,sunday_yn OKS_COVERAGE_TIMES_V.SUNDAY_YN%TYPE := OKC_API.G_MISS_CHAR
22: ,security_group_id NUMBER := OKC_API.G_MISS_NUM
15: ,monday_yn OKS_COVERAGE_TIMES_V.MONDAY_YN%TYPE := OKC_API.G_MISS_CHAR
16: ,tuesday_yn OKS_COVERAGE_TIMES_V.TUESDAY_YN%TYPE := OKC_API.G_MISS_CHAR
17: ,wednesday_yn OKS_COVERAGE_TIMES_V.WEDNESDAY_YN%TYPE := OKC_API.G_MISS_CHAR
18: ,thursday_yn OKS_COVERAGE_TIMES_V.THURSDAY_YN%TYPE := OKC_API.G_MISS_CHAR
19: ,friday_yn OKS_COVERAGE_TIMES_V.FRIDAY_YN%TYPE := OKC_API.G_MISS_CHAR
20: ,saturday_yn OKS_COVERAGE_TIMES_V.SATURDAY_YN%TYPE := OKC_API.G_MISS_CHAR
21: ,sunday_yn OKS_COVERAGE_TIMES_V.SUNDAY_YN%TYPE := OKC_API.G_MISS_CHAR
22: ,security_group_id NUMBER := OKC_API.G_MISS_NUM
23: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
16: ,tuesday_yn OKS_COVERAGE_TIMES_V.TUESDAY_YN%TYPE := OKC_API.G_MISS_CHAR
17: ,wednesday_yn OKS_COVERAGE_TIMES_V.WEDNESDAY_YN%TYPE := OKC_API.G_MISS_CHAR
18: ,thursday_yn OKS_COVERAGE_TIMES_V.THURSDAY_YN%TYPE := OKC_API.G_MISS_CHAR
19: ,friday_yn OKS_COVERAGE_TIMES_V.FRIDAY_YN%TYPE := OKC_API.G_MISS_CHAR
20: ,saturday_yn OKS_COVERAGE_TIMES_V.SATURDAY_YN%TYPE := OKC_API.G_MISS_CHAR
21: ,sunday_yn OKS_COVERAGE_TIMES_V.SUNDAY_YN%TYPE := OKC_API.G_MISS_CHAR
22: ,security_group_id NUMBER := OKC_API.G_MISS_NUM
23: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
24: ,program_id NUMBER := OKC_API.G_MISS_NUM
17: ,wednesday_yn OKS_COVERAGE_TIMES_V.WEDNESDAY_YN%TYPE := OKC_API.G_MISS_CHAR
18: ,thursday_yn OKS_COVERAGE_TIMES_V.THURSDAY_YN%TYPE := OKC_API.G_MISS_CHAR
19: ,friday_yn OKS_COVERAGE_TIMES_V.FRIDAY_YN%TYPE := OKC_API.G_MISS_CHAR
20: ,saturday_yn OKS_COVERAGE_TIMES_V.SATURDAY_YN%TYPE := OKC_API.G_MISS_CHAR
21: ,sunday_yn OKS_COVERAGE_TIMES_V.SUNDAY_YN%TYPE := OKC_API.G_MISS_CHAR
22: ,security_group_id NUMBER := OKC_API.G_MISS_NUM
23: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
24: ,program_id NUMBER := OKC_API.G_MISS_NUM
25: ,program_update_date OKS_COVERAGE_TIMES_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
18: ,thursday_yn OKS_COVERAGE_TIMES_V.THURSDAY_YN%TYPE := OKC_API.G_MISS_CHAR
19: ,friday_yn OKS_COVERAGE_TIMES_V.FRIDAY_YN%TYPE := OKC_API.G_MISS_CHAR
20: ,saturday_yn OKS_COVERAGE_TIMES_V.SATURDAY_YN%TYPE := OKC_API.G_MISS_CHAR
21: ,sunday_yn OKS_COVERAGE_TIMES_V.SUNDAY_YN%TYPE := OKC_API.G_MISS_CHAR
22: ,security_group_id NUMBER := OKC_API.G_MISS_NUM
23: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
24: ,program_id NUMBER := OKC_API.G_MISS_NUM
25: ,program_update_date OKS_COVERAGE_TIMES_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
26: ,request_id NUMBER := OKC_API.G_MISS_NUM
19: ,friday_yn OKS_COVERAGE_TIMES_V.FRIDAY_YN%TYPE := OKC_API.G_MISS_CHAR
20: ,saturday_yn OKS_COVERAGE_TIMES_V.SATURDAY_YN%TYPE := OKC_API.G_MISS_CHAR
21: ,sunday_yn OKS_COVERAGE_TIMES_V.SUNDAY_YN%TYPE := OKC_API.G_MISS_CHAR
22: ,security_group_id NUMBER := OKC_API.G_MISS_NUM
23: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
24: ,program_id NUMBER := OKC_API.G_MISS_NUM
25: ,program_update_date OKS_COVERAGE_TIMES_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
26: ,request_id NUMBER := OKC_API.G_MISS_NUM
27: ,created_by NUMBER := OKC_API.G_MISS_NUM
20: ,saturday_yn OKS_COVERAGE_TIMES_V.SATURDAY_YN%TYPE := OKC_API.G_MISS_CHAR
21: ,sunday_yn OKS_COVERAGE_TIMES_V.SUNDAY_YN%TYPE := OKC_API.G_MISS_CHAR
22: ,security_group_id NUMBER := OKC_API.G_MISS_NUM
23: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
24: ,program_id NUMBER := OKC_API.G_MISS_NUM
25: ,program_update_date OKS_COVERAGE_TIMES_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
26: ,request_id NUMBER := OKC_API.G_MISS_NUM
27: ,created_by NUMBER := OKC_API.G_MISS_NUM
28: ,creation_date OKS_COVERAGE_TIMES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
21: ,sunday_yn OKS_COVERAGE_TIMES_V.SUNDAY_YN%TYPE := OKC_API.G_MISS_CHAR
22: ,security_group_id NUMBER := OKC_API.G_MISS_NUM
23: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
24: ,program_id NUMBER := OKC_API.G_MISS_NUM
25: ,program_update_date OKS_COVERAGE_TIMES_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
26: ,request_id NUMBER := OKC_API.G_MISS_NUM
27: ,created_by NUMBER := OKC_API.G_MISS_NUM
28: ,creation_date OKS_COVERAGE_TIMES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
29: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
22: ,security_group_id NUMBER := OKC_API.G_MISS_NUM
23: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
24: ,program_id NUMBER := OKC_API.G_MISS_NUM
25: ,program_update_date OKS_COVERAGE_TIMES_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
26: ,request_id NUMBER := OKC_API.G_MISS_NUM
27: ,created_by NUMBER := OKC_API.G_MISS_NUM
28: ,creation_date OKS_COVERAGE_TIMES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
29: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
30: ,last_update_date OKS_COVERAGE_TIMES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
23: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
24: ,program_id NUMBER := OKC_API.G_MISS_NUM
25: ,program_update_date OKS_COVERAGE_TIMES_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
26: ,request_id NUMBER := OKC_API.G_MISS_NUM
27: ,created_by NUMBER := OKC_API.G_MISS_NUM
28: ,creation_date OKS_COVERAGE_TIMES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
29: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
30: ,last_update_date OKS_COVERAGE_TIMES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
31: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
24: ,program_id NUMBER := OKC_API.G_MISS_NUM
25: ,program_update_date OKS_COVERAGE_TIMES_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
26: ,request_id NUMBER := OKC_API.G_MISS_NUM
27: ,created_by NUMBER := OKC_API.G_MISS_NUM
28: ,creation_date OKS_COVERAGE_TIMES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
29: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
30: ,last_update_date OKS_COVERAGE_TIMES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
31: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
32: ,object_version_number NUMBER := OKC_API.G_MISS_NUM);
25: ,program_update_date OKS_COVERAGE_TIMES_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
26: ,request_id NUMBER := OKC_API.G_MISS_NUM
27: ,created_by NUMBER := OKC_API.G_MISS_NUM
28: ,creation_date OKS_COVERAGE_TIMES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
29: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
30: ,last_update_date OKS_COVERAGE_TIMES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
31: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
32: ,object_version_number NUMBER := OKC_API.G_MISS_NUM);
33: GMissOksCoverageTimesVRec oks_coverage_times_v_rec_type;
26: ,request_id NUMBER := OKC_API.G_MISS_NUM
27: ,created_by NUMBER := OKC_API.G_MISS_NUM
28: ,creation_date OKS_COVERAGE_TIMES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
29: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
30: ,last_update_date OKS_COVERAGE_TIMES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
31: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
32: ,object_version_number NUMBER := OKC_API.G_MISS_NUM);
33: GMissOksCoverageTimesVRec oks_coverage_times_v_rec_type;
34: TYPE oks_coverage_times_v_tbl_type IS TABLE OF oks_coverage_times_v_rec_type
27: ,created_by NUMBER := OKC_API.G_MISS_NUM
28: ,creation_date OKS_COVERAGE_TIMES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
29: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
30: ,last_update_date OKS_COVERAGE_TIMES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
31: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
32: ,object_version_number NUMBER := OKC_API.G_MISS_NUM);
33: GMissOksCoverageTimesVRec oks_coverage_times_v_rec_type;
34: TYPE oks_coverage_times_v_tbl_type IS TABLE OF oks_coverage_times_v_rec_type
35: INDEX BY BINARY_INTEGER;
28: ,creation_date OKS_COVERAGE_TIMES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
29: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
30: ,last_update_date OKS_COVERAGE_TIMES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
31: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
32: ,object_version_number NUMBER := OKC_API.G_MISS_NUM);
33: GMissOksCoverageTimesVRec oks_coverage_times_v_rec_type;
34: TYPE oks_coverage_times_v_tbl_type IS TABLE OF oks_coverage_times_v_rec_type
35: INDEX BY BINARY_INTEGER;
36: -- OKS_COVERAGE_TIMES Record Spec
34: TYPE oks_coverage_times_v_tbl_type IS TABLE OF oks_coverage_times_v_rec_type
35: INDEX BY BINARY_INTEGER;
36: -- OKS_COVERAGE_TIMES Record Spec
37: TYPE oks_coverage_times_rec_type IS RECORD (
38: id NUMBER := OKC_API.G_MISS_NUM
39: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
40: ,cov_tze_line_id NUMBER := OKC_API.G_MISS_NUM
41: ,start_hour NUMBER := OKC_API.G_MISS_NUM
42: ,start_minute NUMBER := OKC_API.G_MISS_NUM
35: INDEX BY BINARY_INTEGER;
36: -- OKS_COVERAGE_TIMES Record Spec
37: TYPE oks_coverage_times_rec_type IS RECORD (
38: id NUMBER := OKC_API.G_MISS_NUM
39: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
40: ,cov_tze_line_id NUMBER := OKC_API.G_MISS_NUM
41: ,start_hour NUMBER := OKC_API.G_MISS_NUM
42: ,start_minute NUMBER := OKC_API.G_MISS_NUM
43: ,end_hour NUMBER := OKC_API.G_MISS_NUM
36: -- OKS_COVERAGE_TIMES Record Spec
37: TYPE oks_coverage_times_rec_type IS RECORD (
38: id NUMBER := OKC_API.G_MISS_NUM
39: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
40: ,cov_tze_line_id NUMBER := OKC_API.G_MISS_NUM
41: ,start_hour NUMBER := OKC_API.G_MISS_NUM
42: ,start_minute NUMBER := OKC_API.G_MISS_NUM
43: ,end_hour NUMBER := OKC_API.G_MISS_NUM
44: ,end_minute NUMBER := OKC_API.G_MISS_NUM
37: TYPE oks_coverage_times_rec_type IS RECORD (
38: id NUMBER := OKC_API.G_MISS_NUM
39: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
40: ,cov_tze_line_id NUMBER := OKC_API.G_MISS_NUM
41: ,start_hour NUMBER := OKC_API.G_MISS_NUM
42: ,start_minute NUMBER := OKC_API.G_MISS_NUM
43: ,end_hour NUMBER := OKC_API.G_MISS_NUM
44: ,end_minute NUMBER := OKC_API.G_MISS_NUM
45: ,monday_yn OKS_COVERAGE_TIMES.MONDAY_YN%TYPE := OKC_API.G_MISS_CHAR
38: id NUMBER := OKC_API.G_MISS_NUM
39: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
40: ,cov_tze_line_id NUMBER := OKC_API.G_MISS_NUM
41: ,start_hour NUMBER := OKC_API.G_MISS_NUM
42: ,start_minute NUMBER := OKC_API.G_MISS_NUM
43: ,end_hour NUMBER := OKC_API.G_MISS_NUM
44: ,end_minute NUMBER := OKC_API.G_MISS_NUM
45: ,monday_yn OKS_COVERAGE_TIMES.MONDAY_YN%TYPE := OKC_API.G_MISS_CHAR
46: ,tuesday_yn OKS_COVERAGE_TIMES.TUESDAY_YN%TYPE := OKC_API.G_MISS_CHAR
39: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
40: ,cov_tze_line_id NUMBER := OKC_API.G_MISS_NUM
41: ,start_hour NUMBER := OKC_API.G_MISS_NUM
42: ,start_minute NUMBER := OKC_API.G_MISS_NUM
43: ,end_hour NUMBER := OKC_API.G_MISS_NUM
44: ,end_minute NUMBER := OKC_API.G_MISS_NUM
45: ,monday_yn OKS_COVERAGE_TIMES.MONDAY_YN%TYPE := OKC_API.G_MISS_CHAR
46: ,tuesday_yn OKS_COVERAGE_TIMES.TUESDAY_YN%TYPE := OKC_API.G_MISS_CHAR
47: ,wednesday_yn OKS_COVERAGE_TIMES.WEDNESDAY_YN%TYPE := OKC_API.G_MISS_CHAR
40: ,cov_tze_line_id NUMBER := OKC_API.G_MISS_NUM
41: ,start_hour NUMBER := OKC_API.G_MISS_NUM
42: ,start_minute NUMBER := OKC_API.G_MISS_NUM
43: ,end_hour NUMBER := OKC_API.G_MISS_NUM
44: ,end_minute NUMBER := OKC_API.G_MISS_NUM
45: ,monday_yn OKS_COVERAGE_TIMES.MONDAY_YN%TYPE := OKC_API.G_MISS_CHAR
46: ,tuesday_yn OKS_COVERAGE_TIMES.TUESDAY_YN%TYPE := OKC_API.G_MISS_CHAR
47: ,wednesday_yn OKS_COVERAGE_TIMES.WEDNESDAY_YN%TYPE := OKC_API.G_MISS_CHAR
48: ,thursday_yn OKS_COVERAGE_TIMES.THURSDAY_YN%TYPE := OKC_API.G_MISS_CHAR
41: ,start_hour NUMBER := OKC_API.G_MISS_NUM
42: ,start_minute NUMBER := OKC_API.G_MISS_NUM
43: ,end_hour NUMBER := OKC_API.G_MISS_NUM
44: ,end_minute NUMBER := OKC_API.G_MISS_NUM
45: ,monday_yn OKS_COVERAGE_TIMES.MONDAY_YN%TYPE := OKC_API.G_MISS_CHAR
46: ,tuesday_yn OKS_COVERAGE_TIMES.TUESDAY_YN%TYPE := OKC_API.G_MISS_CHAR
47: ,wednesday_yn OKS_COVERAGE_TIMES.WEDNESDAY_YN%TYPE := OKC_API.G_MISS_CHAR
48: ,thursday_yn OKS_COVERAGE_TIMES.THURSDAY_YN%TYPE := OKC_API.G_MISS_CHAR
49: ,friday_yn OKS_COVERAGE_TIMES.FRIDAY_YN%TYPE := OKC_API.G_MISS_CHAR
42: ,start_minute NUMBER := OKC_API.G_MISS_NUM
43: ,end_hour NUMBER := OKC_API.G_MISS_NUM
44: ,end_minute NUMBER := OKC_API.G_MISS_NUM
45: ,monday_yn OKS_COVERAGE_TIMES.MONDAY_YN%TYPE := OKC_API.G_MISS_CHAR
46: ,tuesday_yn OKS_COVERAGE_TIMES.TUESDAY_YN%TYPE := OKC_API.G_MISS_CHAR
47: ,wednesday_yn OKS_COVERAGE_TIMES.WEDNESDAY_YN%TYPE := OKC_API.G_MISS_CHAR
48: ,thursday_yn OKS_COVERAGE_TIMES.THURSDAY_YN%TYPE := OKC_API.G_MISS_CHAR
49: ,friday_yn OKS_COVERAGE_TIMES.FRIDAY_YN%TYPE := OKC_API.G_MISS_CHAR
50: ,saturday_yn OKS_COVERAGE_TIMES.SATURDAY_YN%TYPE := OKC_API.G_MISS_CHAR
43: ,end_hour NUMBER := OKC_API.G_MISS_NUM
44: ,end_minute NUMBER := OKC_API.G_MISS_NUM
45: ,monday_yn OKS_COVERAGE_TIMES.MONDAY_YN%TYPE := OKC_API.G_MISS_CHAR
46: ,tuesday_yn OKS_COVERAGE_TIMES.TUESDAY_YN%TYPE := OKC_API.G_MISS_CHAR
47: ,wednesday_yn OKS_COVERAGE_TIMES.WEDNESDAY_YN%TYPE := OKC_API.G_MISS_CHAR
48: ,thursday_yn OKS_COVERAGE_TIMES.THURSDAY_YN%TYPE := OKC_API.G_MISS_CHAR
49: ,friday_yn OKS_COVERAGE_TIMES.FRIDAY_YN%TYPE := OKC_API.G_MISS_CHAR
50: ,saturday_yn OKS_COVERAGE_TIMES.SATURDAY_YN%TYPE := OKC_API.G_MISS_CHAR
51: ,sunday_yn OKS_COVERAGE_TIMES.SUNDAY_YN%TYPE := OKC_API.G_MISS_CHAR
44: ,end_minute NUMBER := OKC_API.G_MISS_NUM
45: ,monday_yn OKS_COVERAGE_TIMES.MONDAY_YN%TYPE := OKC_API.G_MISS_CHAR
46: ,tuesday_yn OKS_COVERAGE_TIMES.TUESDAY_YN%TYPE := OKC_API.G_MISS_CHAR
47: ,wednesday_yn OKS_COVERAGE_TIMES.WEDNESDAY_YN%TYPE := OKC_API.G_MISS_CHAR
48: ,thursday_yn OKS_COVERAGE_TIMES.THURSDAY_YN%TYPE := OKC_API.G_MISS_CHAR
49: ,friday_yn OKS_COVERAGE_TIMES.FRIDAY_YN%TYPE := OKC_API.G_MISS_CHAR
50: ,saturday_yn OKS_COVERAGE_TIMES.SATURDAY_YN%TYPE := OKC_API.G_MISS_CHAR
51: ,sunday_yn OKS_COVERAGE_TIMES.SUNDAY_YN%TYPE := OKC_API.G_MISS_CHAR
52: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
45: ,monday_yn OKS_COVERAGE_TIMES.MONDAY_YN%TYPE := OKC_API.G_MISS_CHAR
46: ,tuesday_yn OKS_COVERAGE_TIMES.TUESDAY_YN%TYPE := OKC_API.G_MISS_CHAR
47: ,wednesday_yn OKS_COVERAGE_TIMES.WEDNESDAY_YN%TYPE := OKC_API.G_MISS_CHAR
48: ,thursday_yn OKS_COVERAGE_TIMES.THURSDAY_YN%TYPE := OKC_API.G_MISS_CHAR
49: ,friday_yn OKS_COVERAGE_TIMES.FRIDAY_YN%TYPE := OKC_API.G_MISS_CHAR
50: ,saturday_yn OKS_COVERAGE_TIMES.SATURDAY_YN%TYPE := OKC_API.G_MISS_CHAR
51: ,sunday_yn OKS_COVERAGE_TIMES.SUNDAY_YN%TYPE := OKC_API.G_MISS_CHAR
52: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
53: ,program_id NUMBER := OKC_API.G_MISS_NUM
46: ,tuesday_yn OKS_COVERAGE_TIMES.TUESDAY_YN%TYPE := OKC_API.G_MISS_CHAR
47: ,wednesday_yn OKS_COVERAGE_TIMES.WEDNESDAY_YN%TYPE := OKC_API.G_MISS_CHAR
48: ,thursday_yn OKS_COVERAGE_TIMES.THURSDAY_YN%TYPE := OKC_API.G_MISS_CHAR
49: ,friday_yn OKS_COVERAGE_TIMES.FRIDAY_YN%TYPE := OKC_API.G_MISS_CHAR
50: ,saturday_yn OKS_COVERAGE_TIMES.SATURDAY_YN%TYPE := OKC_API.G_MISS_CHAR
51: ,sunday_yn OKS_COVERAGE_TIMES.SUNDAY_YN%TYPE := OKC_API.G_MISS_CHAR
52: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
53: ,program_id NUMBER := OKC_API.G_MISS_NUM
54: ,program_update_date OKS_COVERAGE_TIMES.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
47: ,wednesday_yn OKS_COVERAGE_TIMES.WEDNESDAY_YN%TYPE := OKC_API.G_MISS_CHAR
48: ,thursday_yn OKS_COVERAGE_TIMES.THURSDAY_YN%TYPE := OKC_API.G_MISS_CHAR
49: ,friday_yn OKS_COVERAGE_TIMES.FRIDAY_YN%TYPE := OKC_API.G_MISS_CHAR
50: ,saturday_yn OKS_COVERAGE_TIMES.SATURDAY_YN%TYPE := OKC_API.G_MISS_CHAR
51: ,sunday_yn OKS_COVERAGE_TIMES.SUNDAY_YN%TYPE := OKC_API.G_MISS_CHAR
52: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
53: ,program_id NUMBER := OKC_API.G_MISS_NUM
54: ,program_update_date OKS_COVERAGE_TIMES.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
55: ,request_id NUMBER := OKC_API.G_MISS_NUM
48: ,thursday_yn OKS_COVERAGE_TIMES.THURSDAY_YN%TYPE := OKC_API.G_MISS_CHAR
49: ,friday_yn OKS_COVERAGE_TIMES.FRIDAY_YN%TYPE := OKC_API.G_MISS_CHAR
50: ,saturday_yn OKS_COVERAGE_TIMES.SATURDAY_YN%TYPE := OKC_API.G_MISS_CHAR
51: ,sunday_yn OKS_COVERAGE_TIMES.SUNDAY_YN%TYPE := OKC_API.G_MISS_CHAR
52: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
53: ,program_id NUMBER := OKC_API.G_MISS_NUM
54: ,program_update_date OKS_COVERAGE_TIMES.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
55: ,request_id NUMBER := OKC_API.G_MISS_NUM
56: ,created_by NUMBER := OKC_API.G_MISS_NUM
49: ,friday_yn OKS_COVERAGE_TIMES.FRIDAY_YN%TYPE := OKC_API.G_MISS_CHAR
50: ,saturday_yn OKS_COVERAGE_TIMES.SATURDAY_YN%TYPE := OKC_API.G_MISS_CHAR
51: ,sunday_yn OKS_COVERAGE_TIMES.SUNDAY_YN%TYPE := OKC_API.G_MISS_CHAR
52: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
53: ,program_id NUMBER := OKC_API.G_MISS_NUM
54: ,program_update_date OKS_COVERAGE_TIMES.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
55: ,request_id NUMBER := OKC_API.G_MISS_NUM
56: ,created_by NUMBER := OKC_API.G_MISS_NUM
57: ,creation_date OKS_COVERAGE_TIMES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
50: ,saturday_yn OKS_COVERAGE_TIMES.SATURDAY_YN%TYPE := OKC_API.G_MISS_CHAR
51: ,sunday_yn OKS_COVERAGE_TIMES.SUNDAY_YN%TYPE := OKC_API.G_MISS_CHAR
52: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
53: ,program_id NUMBER := OKC_API.G_MISS_NUM
54: ,program_update_date OKS_COVERAGE_TIMES.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
55: ,request_id NUMBER := OKC_API.G_MISS_NUM
56: ,created_by NUMBER := OKC_API.G_MISS_NUM
57: ,creation_date OKS_COVERAGE_TIMES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
58: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
51: ,sunday_yn OKS_COVERAGE_TIMES.SUNDAY_YN%TYPE := OKC_API.G_MISS_CHAR
52: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
53: ,program_id NUMBER := OKC_API.G_MISS_NUM
54: ,program_update_date OKS_COVERAGE_TIMES.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
55: ,request_id NUMBER := OKC_API.G_MISS_NUM
56: ,created_by NUMBER := OKC_API.G_MISS_NUM
57: ,creation_date OKS_COVERAGE_TIMES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
58: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
59: ,last_update_date OKS_COVERAGE_TIMES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
52: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
53: ,program_id NUMBER := OKC_API.G_MISS_NUM
54: ,program_update_date OKS_COVERAGE_TIMES.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
55: ,request_id NUMBER := OKC_API.G_MISS_NUM
56: ,created_by NUMBER := OKC_API.G_MISS_NUM
57: ,creation_date OKS_COVERAGE_TIMES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
58: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
59: ,last_update_date OKS_COVERAGE_TIMES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
60: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
53: ,program_id NUMBER := OKC_API.G_MISS_NUM
54: ,program_update_date OKS_COVERAGE_TIMES.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
55: ,request_id NUMBER := OKC_API.G_MISS_NUM
56: ,created_by NUMBER := OKC_API.G_MISS_NUM
57: ,creation_date OKS_COVERAGE_TIMES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
58: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
59: ,last_update_date OKS_COVERAGE_TIMES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
60: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
61: ,object_version_number NUMBER := OKC_API.G_MISS_NUM);
54: ,program_update_date OKS_COVERAGE_TIMES.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
55: ,request_id NUMBER := OKC_API.G_MISS_NUM
56: ,created_by NUMBER := OKC_API.G_MISS_NUM
57: ,creation_date OKS_COVERAGE_TIMES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
58: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
59: ,last_update_date OKS_COVERAGE_TIMES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
60: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
61: ,object_version_number NUMBER := OKC_API.G_MISS_NUM);
62: G_MISS_oks_coverage_times_rec oks_coverage_times_rec_type;
55: ,request_id NUMBER := OKC_API.G_MISS_NUM
56: ,created_by NUMBER := OKC_API.G_MISS_NUM
57: ,creation_date OKS_COVERAGE_TIMES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
58: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
59: ,last_update_date OKS_COVERAGE_TIMES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
60: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
61: ,object_version_number NUMBER := OKC_API.G_MISS_NUM);
62: G_MISS_oks_coverage_times_rec oks_coverage_times_rec_type;
63: TYPE oks_coverage_times_tbl_type IS TABLE OF oks_coverage_times_rec_type
56: ,created_by NUMBER := OKC_API.G_MISS_NUM
57: ,creation_date OKS_COVERAGE_TIMES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
58: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
59: ,last_update_date OKS_COVERAGE_TIMES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
60: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
61: ,object_version_number NUMBER := OKC_API.G_MISS_NUM);
62: G_MISS_oks_coverage_times_rec oks_coverage_times_rec_type;
63: TYPE oks_coverage_times_tbl_type IS TABLE OF oks_coverage_times_rec_type
64: INDEX BY BINARY_INTEGER;
57: ,creation_date OKS_COVERAGE_TIMES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
58: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
59: ,last_update_date OKS_COVERAGE_TIMES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
60: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
61: ,object_version_number NUMBER := OKC_API.G_MISS_NUM);
62: G_MISS_oks_coverage_times_rec oks_coverage_times_rec_type;
63: TYPE oks_coverage_times_tbl_type IS TABLE OF oks_coverage_times_rec_type
64: INDEX BY BINARY_INTEGER;
65: ---------------------------------------------------------------------------
64: INDEX BY BINARY_INTEGER;
65: ---------------------------------------------------------------------------
66: -- GLOBAL MESSAGE CONSTANTS
67: ---------------------------------------------------------------------------
68: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
69: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
70: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
71: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
72: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
65: ---------------------------------------------------------------------------
66: -- GLOBAL MESSAGE CONSTANTS
67: ---------------------------------------------------------------------------
68: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
69: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
70: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
71: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
72: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
73: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
66: -- GLOBAL MESSAGE CONSTANTS
67: ---------------------------------------------------------------------------
68: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
69: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
70: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
71: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
72: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
73: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
74: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
67: ---------------------------------------------------------------------------
68: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
69: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
70: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
71: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
72: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
73: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
74: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
75: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
68: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
69: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
70: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
71: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
72: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
73: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
74: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
75: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
76: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
69: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
70: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
71: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
72: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
73: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
74: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
75: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
76: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
77: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
70: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
71: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
72: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
73: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
74: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
75: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
76: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
77: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
78: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
71: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
72: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
73: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
74: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
75: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
76: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
77: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
78: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
79: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
72: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
73: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
74: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
75: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
76: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
77: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
78: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
79: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
80: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
73: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
74: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
75: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
76: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
77: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
78: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
79: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
80: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
81:
87: ---------------------------------------------------------------------------
88: -- GLOBAL VARIABLES
89: ---------------------------------------------------------------------------
90: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKS_CVT_PVT';
91: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
92: ---------------------------------------------------------------------------
93: -- Procedures and Functions
94: ---------------------------------------------------------------------------
95:
111: x_msg_count OUT NOCOPY NUMBER,
112: x_msg_data OUT NOCOPY VARCHAR2,
113: p_oks_coverage_times_v_tbl IN oks_coverage_times_v_tbl_type,
114: x_oks_coverage_times_v_tbl OUT NOCOPY oks_coverage_times_v_tbl_type,
115: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
116: PROCEDURE insert_row(
117: p_api_version IN NUMBER,
118: p_init_msg_list IN VARCHAR2,
119: x_return_status OUT NOCOPY VARCHAR2,
134: x_return_status OUT NOCOPY VARCHAR2,
135: x_msg_count OUT NOCOPY NUMBER,
136: x_msg_data OUT NOCOPY VARCHAR2,
137: p_oks_coverage_times_v_tbl IN oks_coverage_times_v_tbl_type,
138: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
139: PROCEDURE lock_row(
140: p_api_version IN NUMBER,
141: p_init_msg_list IN VARCHAR2,
142: x_return_status OUT NOCOPY VARCHAR2,
158: x_msg_count OUT NOCOPY NUMBER,
159: x_msg_data OUT NOCOPY VARCHAR2,
160: p_oks_coverage_times_v_tbl IN oks_coverage_times_v_tbl_type,
161: x_oks_coverage_times_v_tbl OUT NOCOPY oks_coverage_times_v_tbl_type,
162: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
163: PROCEDURE update_row(
164: p_api_version IN NUMBER,
165: p_init_msg_list IN VARCHAR2,
166: x_return_status OUT NOCOPY VARCHAR2,
181: x_return_status OUT NOCOPY VARCHAR2,
182: x_msg_count OUT NOCOPY NUMBER,
183: x_msg_data OUT NOCOPY VARCHAR2,
184: p_oks_coverage_times_v_tbl IN oks_coverage_times_v_tbl_type,
185: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
186: PROCEDURE delete_row(
187: p_api_version IN NUMBER,
188: p_init_msg_list IN VARCHAR2,
189: x_return_status OUT NOCOPY VARCHAR2,
203: x_return_status OUT NOCOPY VARCHAR2,
204: x_msg_count OUT NOCOPY NUMBER,
205: x_msg_data OUT NOCOPY VARCHAR2,
206: p_oks_coverage_times_v_tbl IN oks_coverage_times_v_tbl_type,
207: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
208: PROCEDURE validate_row(
209: p_api_version IN NUMBER,
210: p_init_msg_list IN VARCHAR2,
211: x_return_status OUT NOCOPY VARCHAR2,