14: * Coverage Times record and table declaration, for the UI
15: */
16: TYPE ui_coverage_times_rec IS RECORD
17: (
18: MONDAY_YN OKS_COVERAGE_TIMES.monday_yn%TYPE,
19: TUESDAY_YN OKS_COVERAGE_TIMES.tuesday_yn%TYPE,
20: WEDNESDAY_YN OKS_COVERAGE_TIMES.wednesday_yn%TYPE,
21: THURSDAY_YN OKS_COVERAGE_TIMES.thursday_yn%TYPE,
22: FRIDAY_YN OKS_COVERAGE_TIMES.friday_yn%TYPE,
15: */
16: TYPE ui_coverage_times_rec IS RECORD
17: (
18: MONDAY_YN OKS_COVERAGE_TIMES.monday_yn%TYPE,
19: TUESDAY_YN OKS_COVERAGE_TIMES.tuesday_yn%TYPE,
20: WEDNESDAY_YN OKS_COVERAGE_TIMES.wednesday_yn%TYPE,
21: THURSDAY_YN OKS_COVERAGE_TIMES.thursday_yn%TYPE,
22: FRIDAY_YN OKS_COVERAGE_TIMES.friday_yn%TYPE,
23: SATURDAY_YN OKS_COVERAGE_TIMES.saturday_yn%TYPE,
16: TYPE ui_coverage_times_rec IS RECORD
17: (
18: MONDAY_YN OKS_COVERAGE_TIMES.monday_yn%TYPE,
19: TUESDAY_YN OKS_COVERAGE_TIMES.tuesday_yn%TYPE,
20: WEDNESDAY_YN OKS_COVERAGE_TIMES.wednesday_yn%TYPE,
21: THURSDAY_YN OKS_COVERAGE_TIMES.thursday_yn%TYPE,
22: FRIDAY_YN OKS_COVERAGE_TIMES.friday_yn%TYPE,
23: SATURDAY_YN OKS_COVERAGE_TIMES.saturday_yn%TYPE,
24: SUNDAY_YN OKS_COVERAGE_TIMES.sunday_yn%TYPE,
17: (
18: MONDAY_YN OKS_COVERAGE_TIMES.monday_yn%TYPE,
19: TUESDAY_YN OKS_COVERAGE_TIMES.tuesday_yn%TYPE,
20: WEDNESDAY_YN OKS_COVERAGE_TIMES.wednesday_yn%TYPE,
21: THURSDAY_YN OKS_COVERAGE_TIMES.thursday_yn%TYPE,
22: FRIDAY_YN OKS_COVERAGE_TIMES.friday_yn%TYPE,
23: SATURDAY_YN OKS_COVERAGE_TIMES.saturday_yn%TYPE,
24: SUNDAY_YN OKS_COVERAGE_TIMES.sunday_yn%TYPE,
25: COV_TZE_LINE_ID OKS_COVERAGE_TIMES.COV_TZE_LINE_ID%TYPE,
18: MONDAY_YN OKS_COVERAGE_TIMES.monday_yn%TYPE,
19: TUESDAY_YN OKS_COVERAGE_TIMES.tuesday_yn%TYPE,
20: WEDNESDAY_YN OKS_COVERAGE_TIMES.wednesday_yn%TYPE,
21: THURSDAY_YN OKS_COVERAGE_TIMES.thursday_yn%TYPE,
22: FRIDAY_YN OKS_COVERAGE_TIMES.friday_yn%TYPE,
23: SATURDAY_YN OKS_COVERAGE_TIMES.saturday_yn%TYPE,
24: SUNDAY_YN OKS_COVERAGE_TIMES.sunday_yn%TYPE,
25: COV_TZE_LINE_ID OKS_COVERAGE_TIMES.COV_TZE_LINE_ID%TYPE,
26: START_TIME VARCHAR2(10),
19: TUESDAY_YN OKS_COVERAGE_TIMES.tuesday_yn%TYPE,
20: WEDNESDAY_YN OKS_COVERAGE_TIMES.wednesday_yn%TYPE,
21: THURSDAY_YN OKS_COVERAGE_TIMES.thursday_yn%TYPE,
22: FRIDAY_YN OKS_COVERAGE_TIMES.friday_yn%TYPE,
23: SATURDAY_YN OKS_COVERAGE_TIMES.saturday_yn%TYPE,
24: SUNDAY_YN OKS_COVERAGE_TIMES.sunday_yn%TYPE,
25: COV_TZE_LINE_ID OKS_COVERAGE_TIMES.COV_TZE_LINE_ID%TYPE,
26: START_TIME VARCHAR2(10),
27: END_TIME VARCHAR2(10),
20: WEDNESDAY_YN OKS_COVERAGE_TIMES.wednesday_yn%TYPE,
21: THURSDAY_YN OKS_COVERAGE_TIMES.thursday_yn%TYPE,
22: FRIDAY_YN OKS_COVERAGE_TIMES.friday_yn%TYPE,
23: SATURDAY_YN OKS_COVERAGE_TIMES.saturday_yn%TYPE,
24: SUNDAY_YN OKS_COVERAGE_TIMES.sunday_yn%TYPE,
25: COV_TZE_LINE_ID OKS_COVERAGE_TIMES.COV_TZE_LINE_ID%TYPE,
26: START_TIME VARCHAR2(10),
27: END_TIME VARCHAR2(10),
28: START_HOUR_MINUTE NUMBER,
21: THURSDAY_YN OKS_COVERAGE_TIMES.thursday_yn%TYPE,
22: FRIDAY_YN OKS_COVERAGE_TIMES.friday_yn%TYPE,
23: SATURDAY_YN OKS_COVERAGE_TIMES.saturday_yn%TYPE,
24: SUNDAY_YN OKS_COVERAGE_TIMES.sunday_yn%TYPE,
25: COV_TZE_LINE_ID OKS_COVERAGE_TIMES.COV_TZE_LINE_ID%TYPE,
26: START_TIME VARCHAR2(10),
27: END_TIME VARCHAR2(10),
28: START_HOUR_MINUTE NUMBER,
29: END_HOUR_MINUTE NUMBER);