2: /* $Header: OKSCOVTS.pls 120.0 2005/05/25 17:57:03 appldev noship $ */
3: ---------------------------------------------------------------------------
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
3: ---------------------------------------------------------------------------
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
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
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
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);
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
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
37: TYPE oks_coverage_times_rec_type IS RECORD (
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
37: TYPE oks_coverage_times_rec_type IS RECORD (
38: id 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
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
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
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
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
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
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);
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
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: ---------------------------------------------------------------------------
66: -- GLOBAL MESSAGE CONSTANTS
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: ---------------------------------------------------------------------------
66: -- GLOBAL MESSAGE CONSTANTS
67: ---------------------------------------------------------------------------
101: p_init_msg_list IN VARCHAR2,
102: x_return_status OUT NOCOPY VARCHAR2,
103: x_msg_count OUT NOCOPY NUMBER,
104: x_msg_data OUT NOCOPY VARCHAR2,
105: p_oks_coverage_times_v_rec IN oks_coverage_times_v_rec_type,
106: x_oks_coverage_times_v_rec OUT NOCOPY oks_coverage_times_v_rec_type);
107: PROCEDURE insert_row(
108: p_api_version IN NUMBER,
109: p_init_msg_list IN VARCHAR2,
102: x_return_status OUT NOCOPY VARCHAR2,
103: x_msg_count OUT NOCOPY NUMBER,
104: x_msg_data OUT NOCOPY VARCHAR2,
105: p_oks_coverage_times_v_rec IN oks_coverage_times_v_rec_type,
106: x_oks_coverage_times_v_rec OUT NOCOPY oks_coverage_times_v_rec_type);
107: PROCEDURE insert_row(
108: p_api_version IN NUMBER,
109: p_init_msg_list IN VARCHAR2,
110: x_return_status OUT NOCOPY VARCHAR2,
109: p_init_msg_list IN VARCHAR2,
110: x_return_status OUT NOCOPY VARCHAR2,
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,
110: x_return_status OUT NOCOPY VARCHAR2,
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,
118: p_init_msg_list IN VARCHAR2,
119: x_return_status OUT NOCOPY VARCHAR2,
120: x_msg_count OUT NOCOPY NUMBER,
121: x_msg_data OUT NOCOPY VARCHAR2,
122: p_oks_coverage_times_v_tbl IN oks_coverage_times_v_tbl_type,
123: x_oks_coverage_times_v_tbl OUT NOCOPY oks_coverage_times_v_tbl_type);
124: PROCEDURE lock_row(
125: p_api_version IN NUMBER,
126: p_init_msg_list IN VARCHAR2,
119: x_return_status OUT NOCOPY VARCHAR2,
120: x_msg_count OUT NOCOPY NUMBER,
121: x_msg_data OUT NOCOPY VARCHAR2,
122: p_oks_coverage_times_v_tbl IN oks_coverage_times_v_tbl_type,
123: x_oks_coverage_times_v_tbl OUT NOCOPY oks_coverage_times_v_tbl_type);
124: PROCEDURE lock_row(
125: p_api_version IN NUMBER,
126: p_init_msg_list IN VARCHAR2,
127: x_return_status OUT NOCOPY VARCHAR2,
126: p_init_msg_list IN VARCHAR2,
127: x_return_status OUT NOCOPY VARCHAR2,
128: x_msg_count OUT NOCOPY NUMBER,
129: x_msg_data OUT NOCOPY VARCHAR2,
130: p_oks_coverage_times_v_rec IN oks_coverage_times_v_rec_type);
131: PROCEDURE lock_row(
132: p_api_version IN NUMBER,
133: p_init_msg_list IN VARCHAR2,
134: x_return_status OUT NOCOPY VARCHAR2,
133: p_init_msg_list IN 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,
141: p_init_msg_list IN VARCHAR2,
142: x_return_status OUT NOCOPY VARCHAR2,
143: x_msg_count OUT NOCOPY NUMBER,
144: x_msg_data OUT NOCOPY VARCHAR2,
145: p_oks_coverage_times_v_tbl IN oks_coverage_times_v_tbl_type);
146: PROCEDURE update_row(
147: p_api_version IN NUMBER,
148: p_init_msg_list IN VARCHAR2,
149: x_return_status OUT NOCOPY VARCHAR2,
148: p_init_msg_list IN VARCHAR2,
149: x_return_status OUT NOCOPY VARCHAR2,
150: x_msg_count OUT NOCOPY NUMBER,
151: x_msg_data OUT NOCOPY VARCHAR2,
152: p_oks_coverage_times_v_rec IN oks_coverage_times_v_rec_type,
153: x_oks_coverage_times_v_rec OUT NOCOPY oks_coverage_times_v_rec_type);
154: PROCEDURE update_row(
155: p_api_version IN NUMBER,
156: p_init_msg_list IN VARCHAR2,
149: x_return_status OUT NOCOPY VARCHAR2,
150: x_msg_count OUT NOCOPY NUMBER,
151: x_msg_data OUT NOCOPY VARCHAR2,
152: p_oks_coverage_times_v_rec IN oks_coverage_times_v_rec_type,
153: x_oks_coverage_times_v_rec OUT NOCOPY oks_coverage_times_v_rec_type);
154: PROCEDURE update_row(
155: p_api_version IN NUMBER,
156: p_init_msg_list IN VARCHAR2,
157: x_return_status OUT NOCOPY VARCHAR2,
156: p_init_msg_list IN VARCHAR2,
157: 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,
157: 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,
165: p_init_msg_list IN VARCHAR2,
166: x_return_status OUT NOCOPY VARCHAR2,
167: x_msg_count OUT NOCOPY NUMBER,
168: x_msg_data OUT NOCOPY VARCHAR2,
169: p_oks_coverage_times_v_tbl IN oks_coverage_times_v_tbl_type,
170: x_oks_coverage_times_v_tbl OUT NOCOPY oks_coverage_times_v_tbl_type);
171: PROCEDURE delete_row(
172: p_api_version IN NUMBER,
173: p_init_msg_list IN VARCHAR2,
166: x_return_status OUT NOCOPY VARCHAR2,
167: x_msg_count OUT NOCOPY NUMBER,
168: x_msg_data OUT NOCOPY VARCHAR2,
169: p_oks_coverage_times_v_tbl IN oks_coverage_times_v_tbl_type,
170: x_oks_coverage_times_v_tbl OUT NOCOPY oks_coverage_times_v_tbl_type);
171: PROCEDURE delete_row(
172: p_api_version IN NUMBER,
173: p_init_msg_list IN VARCHAR2,
174: x_return_status OUT NOCOPY VARCHAR2,
173: p_init_msg_list IN VARCHAR2,
174: x_return_status OUT NOCOPY VARCHAR2,
175: x_msg_count OUT NOCOPY NUMBER,
176: x_msg_data OUT NOCOPY VARCHAR2,
177: p_oks_coverage_times_v_rec IN oks_coverage_times_v_rec_type);
178: PROCEDURE delete_row(
179: p_api_version IN NUMBER,
180: p_init_msg_list IN VARCHAR2,
181: x_return_status OUT NOCOPY VARCHAR2,
180: p_init_msg_list IN 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,
188: p_init_msg_list IN VARCHAR2,
189: x_return_status OUT NOCOPY VARCHAR2,
190: x_msg_count OUT NOCOPY NUMBER,
191: x_msg_data OUT NOCOPY VARCHAR2,
192: p_oks_coverage_times_v_tbl IN oks_coverage_times_v_tbl_type);
193: PROCEDURE validate_row(
194: p_api_version IN NUMBER,
195: p_init_msg_list IN VARCHAR2,
196: x_return_status OUT NOCOPY VARCHAR2,
195: p_init_msg_list IN VARCHAR2,
196: x_return_status OUT NOCOPY VARCHAR2,
197: x_msg_count OUT NOCOPY NUMBER,
198: x_msg_data OUT NOCOPY VARCHAR2,
199: p_oks_coverage_times_v_rec IN oks_coverage_times_v_rec_type);
200: PROCEDURE validate_row(
201: p_api_version IN NUMBER,
202: p_init_msg_list IN VARCHAR2,
203: x_return_status OUT NOCOPY VARCHAR2,
202: p_init_msg_list IN 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,
210: p_init_msg_list IN VARCHAR2,
211: x_return_status OUT NOCOPY VARCHAR2,
212: x_msg_count OUT NOCOPY NUMBER,
213: x_msg_data OUT NOCOPY VARCHAR2,
214: p_oks_coverage_times_v_tbl IN oks_coverage_times_v_tbl_type);
215:
216:
217: FUNCTION Create_Version(
218: p_id IN NUMBER,