6: G_UPPERCASE_REQUIRED CONSTANT VARCHAR2(200) := 'OKC_UPPER_CASE_REQUIRED';
7: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
8: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
9: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
10: G_RETURN_STATUS VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
11: G_EXCEPTION_HALT_VALIDATION EXCEPTION;
12: TYPE tve_rec_type IS RECORD (
13: id NUMBER := OKC_API.G_MISS_NUM,
14: spn_id NUMBER := OKC_API.G_MISS_NUM,
9: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
10: G_RETURN_STATUS VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
11: G_EXCEPTION_HALT_VALIDATION EXCEPTION;
12: TYPE tve_rec_type IS RECORD (
13: id NUMBER := OKC_API.G_MISS_NUM,
14: spn_id NUMBER := OKC_API.G_MISS_NUM,
15: tve_id_offset NUMBER := OKC_API.G_MISS_NUM,
16: uom_code OKC_TIMEVALUES.uom_code%TYPE := OKC_API.G_MISS_CHAR,
17: cnh_id NUMBER := OKC_API.G_MISS_NUM,
10: G_RETURN_STATUS VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
11: G_EXCEPTION_HALT_VALIDATION EXCEPTION;
12: TYPE tve_rec_type IS RECORD (
13: id NUMBER := OKC_API.G_MISS_NUM,
14: spn_id NUMBER := OKC_API.G_MISS_NUM,
15: tve_id_offset NUMBER := OKC_API.G_MISS_NUM,
16: uom_code OKC_TIMEVALUES.uom_code%TYPE := OKC_API.G_MISS_CHAR,
17: cnh_id NUMBER := OKC_API.G_MISS_NUM,
18: tve_id_generated_by NUMBER := OKC_API.G_MISS_NUM,
11: G_EXCEPTION_HALT_VALIDATION EXCEPTION;
12: TYPE tve_rec_type IS RECORD (
13: id NUMBER := OKC_API.G_MISS_NUM,
14: spn_id NUMBER := OKC_API.G_MISS_NUM,
15: tve_id_offset NUMBER := OKC_API.G_MISS_NUM,
16: uom_code OKC_TIMEVALUES.uom_code%TYPE := OKC_API.G_MISS_CHAR,
17: cnh_id NUMBER := OKC_API.G_MISS_NUM,
18: tve_id_generated_by NUMBER := OKC_API.G_MISS_NUM,
19: tve_id_started NUMBER := OKC_API.G_MISS_NUM,
12: TYPE tve_rec_type IS RECORD (
13: id NUMBER := OKC_API.G_MISS_NUM,
14: spn_id NUMBER := OKC_API.G_MISS_NUM,
15: tve_id_offset NUMBER := OKC_API.G_MISS_NUM,
16: uom_code OKC_TIMEVALUES.uom_code%TYPE := OKC_API.G_MISS_CHAR,
17: cnh_id NUMBER := OKC_API.G_MISS_NUM,
18: tve_id_generated_by NUMBER := OKC_API.G_MISS_NUM,
19: tve_id_started NUMBER := OKC_API.G_MISS_NUM,
20: tve_id_ended NUMBER := OKC_API.G_MISS_NUM,
13: id NUMBER := OKC_API.G_MISS_NUM,
14: spn_id NUMBER := OKC_API.G_MISS_NUM,
15: tve_id_offset NUMBER := OKC_API.G_MISS_NUM,
16: uom_code OKC_TIMEVALUES.uom_code%TYPE := OKC_API.G_MISS_CHAR,
17: cnh_id NUMBER := OKC_API.G_MISS_NUM,
18: tve_id_generated_by NUMBER := OKC_API.G_MISS_NUM,
19: tve_id_started NUMBER := OKC_API.G_MISS_NUM,
20: tve_id_ended NUMBER := OKC_API.G_MISS_NUM,
21: tve_id_limited NUMBER := OKC_API.G_MISS_NUM,
14: spn_id NUMBER := OKC_API.G_MISS_NUM,
15: tve_id_offset NUMBER := OKC_API.G_MISS_NUM,
16: uom_code OKC_TIMEVALUES.uom_code%TYPE := OKC_API.G_MISS_CHAR,
17: cnh_id NUMBER := OKC_API.G_MISS_NUM,
18: tve_id_generated_by NUMBER := OKC_API.G_MISS_NUM,
19: tve_id_started NUMBER := OKC_API.G_MISS_NUM,
20: tve_id_ended NUMBER := OKC_API.G_MISS_NUM,
21: tve_id_limited NUMBER := OKC_API.G_MISS_NUM,
22: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
15: tve_id_offset NUMBER := OKC_API.G_MISS_NUM,
16: uom_code OKC_TIMEVALUES.uom_code%TYPE := OKC_API.G_MISS_CHAR,
17: cnh_id NUMBER := OKC_API.G_MISS_NUM,
18: tve_id_generated_by NUMBER := OKC_API.G_MISS_NUM,
19: tve_id_started NUMBER := OKC_API.G_MISS_NUM,
20: tve_id_ended NUMBER := OKC_API.G_MISS_NUM,
21: tve_id_limited NUMBER := OKC_API.G_MISS_NUM,
22: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
23: tze_id NUMBER := OKC_API.G_MISS_NUM,
16: uom_code OKC_TIMEVALUES.uom_code%TYPE := OKC_API.G_MISS_CHAR,
17: cnh_id NUMBER := OKC_API.G_MISS_NUM,
18: tve_id_generated_by NUMBER := OKC_API.G_MISS_NUM,
19: tve_id_started NUMBER := OKC_API.G_MISS_NUM,
20: tve_id_ended NUMBER := OKC_API.G_MISS_NUM,
21: tve_id_limited NUMBER := OKC_API.G_MISS_NUM,
22: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
23: tze_id NUMBER := OKC_API.G_MISS_NUM,
24: tve_type OKC_TIMEVALUES.TVE_TYPE%TYPE := OKC_API.G_MISS_CHAR,
17: cnh_id NUMBER := OKC_API.G_MISS_NUM,
18: tve_id_generated_by NUMBER := OKC_API.G_MISS_NUM,
19: tve_id_started NUMBER := OKC_API.G_MISS_NUM,
20: tve_id_ended NUMBER := OKC_API.G_MISS_NUM,
21: tve_id_limited NUMBER := OKC_API.G_MISS_NUM,
22: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
23: tze_id NUMBER := OKC_API.G_MISS_NUM,
24: tve_type OKC_TIMEVALUES.TVE_TYPE%TYPE := OKC_API.G_MISS_CHAR,
25: object_version_number NUMBER := OKC_API.G_MISS_NUM,
18: tve_id_generated_by NUMBER := OKC_API.G_MISS_NUM,
19: tve_id_started NUMBER := OKC_API.G_MISS_NUM,
20: tve_id_ended NUMBER := OKC_API.G_MISS_NUM,
21: tve_id_limited NUMBER := OKC_API.G_MISS_NUM,
22: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
23: tze_id NUMBER := OKC_API.G_MISS_NUM,
24: tve_type OKC_TIMEVALUES.TVE_TYPE%TYPE := OKC_API.G_MISS_CHAR,
25: object_version_number NUMBER := OKC_API.G_MISS_NUM,
26: created_by NUMBER := OKC_API.G_MISS_NUM,
19: tve_id_started NUMBER := OKC_API.G_MISS_NUM,
20: tve_id_ended NUMBER := OKC_API.G_MISS_NUM,
21: tve_id_limited NUMBER := OKC_API.G_MISS_NUM,
22: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
23: tze_id NUMBER := OKC_API.G_MISS_NUM,
24: tve_type OKC_TIMEVALUES.TVE_TYPE%TYPE := OKC_API.G_MISS_CHAR,
25: object_version_number NUMBER := OKC_API.G_MISS_NUM,
26: created_by NUMBER := OKC_API.G_MISS_NUM,
27: creation_date OKC_TIMEVALUES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
20: tve_id_ended NUMBER := OKC_API.G_MISS_NUM,
21: tve_id_limited NUMBER := OKC_API.G_MISS_NUM,
22: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
23: tze_id NUMBER := OKC_API.G_MISS_NUM,
24: tve_type OKC_TIMEVALUES.TVE_TYPE%TYPE := OKC_API.G_MISS_CHAR,
25: object_version_number NUMBER := OKC_API.G_MISS_NUM,
26: created_by NUMBER := OKC_API.G_MISS_NUM,
27: creation_date OKC_TIMEVALUES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
28: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
21: tve_id_limited NUMBER := OKC_API.G_MISS_NUM,
22: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
23: tze_id NUMBER := OKC_API.G_MISS_NUM,
24: tve_type OKC_TIMEVALUES.TVE_TYPE%TYPE := OKC_API.G_MISS_CHAR,
25: object_version_number NUMBER := OKC_API.G_MISS_NUM,
26: created_by NUMBER := OKC_API.G_MISS_NUM,
27: creation_date OKC_TIMEVALUES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
28: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
29: last_update_date OKC_TIMEVALUES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
22: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
23: tze_id NUMBER := OKC_API.G_MISS_NUM,
24: tve_type OKC_TIMEVALUES.TVE_TYPE%TYPE := OKC_API.G_MISS_CHAR,
25: object_version_number NUMBER := OKC_API.G_MISS_NUM,
26: created_by NUMBER := OKC_API.G_MISS_NUM,
27: creation_date OKC_TIMEVALUES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
28: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
29: last_update_date OKC_TIMEVALUES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
30: duration NUMBER := OKC_API.G_MISS_NUM,
23: tze_id NUMBER := OKC_API.G_MISS_NUM,
24: tve_type OKC_TIMEVALUES.TVE_TYPE%TYPE := OKC_API.G_MISS_CHAR,
25: object_version_number NUMBER := OKC_API.G_MISS_NUM,
26: created_by NUMBER := OKC_API.G_MISS_NUM,
27: creation_date OKC_TIMEVALUES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
28: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
29: last_update_date OKC_TIMEVALUES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
30: duration NUMBER := OKC_API.G_MISS_NUM,
31: operator OKC_TIMEVALUES.OPERATOR%TYPE := OKC_API.G_MISS_CHAR,
24: tve_type OKC_TIMEVALUES.TVE_TYPE%TYPE := OKC_API.G_MISS_CHAR,
25: object_version_number NUMBER := OKC_API.G_MISS_NUM,
26: created_by NUMBER := OKC_API.G_MISS_NUM,
27: creation_date OKC_TIMEVALUES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
28: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
29: last_update_date OKC_TIMEVALUES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
30: duration NUMBER := OKC_API.G_MISS_NUM,
31: operator OKC_TIMEVALUES.OPERATOR%TYPE := OKC_API.G_MISS_CHAR,
32: before_after OKC_TIMEVALUES.BEFORE_AFTER%TYPE := OKC_API.G_MISS_CHAR,
25: object_version_number NUMBER := OKC_API.G_MISS_NUM,
26: created_by NUMBER := OKC_API.G_MISS_NUM,
27: creation_date OKC_TIMEVALUES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
28: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
29: last_update_date OKC_TIMEVALUES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
30: duration NUMBER := OKC_API.G_MISS_NUM,
31: operator OKC_TIMEVALUES.OPERATOR%TYPE := OKC_API.G_MISS_CHAR,
32: before_after OKC_TIMEVALUES.BEFORE_AFTER%TYPE := OKC_API.G_MISS_CHAR,
33: datetime OKC_TIMEVALUES.DATETIME%TYPE := OKC_API.G_MISS_DATE,
26: created_by NUMBER := OKC_API.G_MISS_NUM,
27: creation_date OKC_TIMEVALUES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
28: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
29: last_update_date OKC_TIMEVALUES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
30: duration NUMBER := OKC_API.G_MISS_NUM,
31: operator OKC_TIMEVALUES.OPERATOR%TYPE := OKC_API.G_MISS_CHAR,
32: before_after OKC_TIMEVALUES.BEFORE_AFTER%TYPE := OKC_API.G_MISS_CHAR,
33: datetime OKC_TIMEVALUES.DATETIME%TYPE := OKC_API.G_MISS_DATE,
34: month NUMBER := OKC_API.G_MISS_NUM,
27: creation_date OKC_TIMEVALUES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
28: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
29: last_update_date OKC_TIMEVALUES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
30: duration NUMBER := OKC_API.G_MISS_NUM,
31: operator OKC_TIMEVALUES.OPERATOR%TYPE := OKC_API.G_MISS_CHAR,
32: before_after OKC_TIMEVALUES.BEFORE_AFTER%TYPE := OKC_API.G_MISS_CHAR,
33: datetime OKC_TIMEVALUES.DATETIME%TYPE := OKC_API.G_MISS_DATE,
34: month NUMBER := OKC_API.G_MISS_NUM,
35: day NUMBER := OKC_API.G_MISS_NUM,
28: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
29: last_update_date OKC_TIMEVALUES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
30: duration NUMBER := OKC_API.G_MISS_NUM,
31: operator OKC_TIMEVALUES.OPERATOR%TYPE := OKC_API.G_MISS_CHAR,
32: before_after OKC_TIMEVALUES.BEFORE_AFTER%TYPE := OKC_API.G_MISS_CHAR,
33: datetime OKC_TIMEVALUES.DATETIME%TYPE := OKC_API.G_MISS_DATE,
34: month NUMBER := OKC_API.G_MISS_NUM,
35: day NUMBER := OKC_API.G_MISS_NUM,
36: hour NUMBER := OKC_API.G_MISS_NUM,
29: last_update_date OKC_TIMEVALUES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
30: duration NUMBER := OKC_API.G_MISS_NUM,
31: operator OKC_TIMEVALUES.OPERATOR%TYPE := OKC_API.G_MISS_CHAR,
32: before_after OKC_TIMEVALUES.BEFORE_AFTER%TYPE := OKC_API.G_MISS_CHAR,
33: datetime OKC_TIMEVALUES.DATETIME%TYPE := OKC_API.G_MISS_DATE,
34: month NUMBER := OKC_API.G_MISS_NUM,
35: day NUMBER := OKC_API.G_MISS_NUM,
36: hour NUMBER := OKC_API.G_MISS_NUM,
37: minute NUMBER := OKC_API.G_MISS_NUM,
30: duration NUMBER := OKC_API.G_MISS_NUM,
31: operator OKC_TIMEVALUES.OPERATOR%TYPE := OKC_API.G_MISS_CHAR,
32: before_after OKC_TIMEVALUES.BEFORE_AFTER%TYPE := OKC_API.G_MISS_CHAR,
33: datetime OKC_TIMEVALUES.DATETIME%TYPE := OKC_API.G_MISS_DATE,
34: month NUMBER := OKC_API.G_MISS_NUM,
35: day NUMBER := OKC_API.G_MISS_NUM,
36: hour NUMBER := OKC_API.G_MISS_NUM,
37: minute NUMBER := OKC_API.G_MISS_NUM,
38: second NUMBER := OKC_API.G_MISS_NUM,
31: operator OKC_TIMEVALUES.OPERATOR%TYPE := OKC_API.G_MISS_CHAR,
32: before_after OKC_TIMEVALUES.BEFORE_AFTER%TYPE := OKC_API.G_MISS_CHAR,
33: datetime OKC_TIMEVALUES.DATETIME%TYPE := OKC_API.G_MISS_DATE,
34: month NUMBER := OKC_API.G_MISS_NUM,
35: day NUMBER := OKC_API.G_MISS_NUM,
36: hour NUMBER := OKC_API.G_MISS_NUM,
37: minute NUMBER := OKC_API.G_MISS_NUM,
38: second NUMBER := OKC_API.G_MISS_NUM,
39: nth NUMBER := OKC_API.G_MISS_NUM,
32: before_after OKC_TIMEVALUES.BEFORE_AFTER%TYPE := OKC_API.G_MISS_CHAR,
33: datetime OKC_TIMEVALUES.DATETIME%TYPE := OKC_API.G_MISS_DATE,
34: month NUMBER := OKC_API.G_MISS_NUM,
35: day NUMBER := OKC_API.G_MISS_NUM,
36: hour NUMBER := OKC_API.G_MISS_NUM,
37: minute NUMBER := OKC_API.G_MISS_NUM,
38: second NUMBER := OKC_API.G_MISS_NUM,
39: nth NUMBER := OKC_API.G_MISS_NUM,
40: day_of_week OKC_TIMEVALUES.DAY_OF_WEEK%TYPE := OKC_API.G_MISS_CHAR,
33: datetime OKC_TIMEVALUES.DATETIME%TYPE := OKC_API.G_MISS_DATE,
34: month NUMBER := OKC_API.G_MISS_NUM,
35: day NUMBER := OKC_API.G_MISS_NUM,
36: hour NUMBER := OKC_API.G_MISS_NUM,
37: minute NUMBER := OKC_API.G_MISS_NUM,
38: second NUMBER := OKC_API.G_MISS_NUM,
39: nth NUMBER := OKC_API.G_MISS_NUM,
40: day_of_week OKC_TIMEVALUES.DAY_OF_WEEK%TYPE := OKC_API.G_MISS_CHAR,
41: interval_yn OKC_TIMEVALUES.INTERVAL_YN%TYPE := OKC_API.G_MISS_CHAR,
34: month NUMBER := OKC_API.G_MISS_NUM,
35: day NUMBER := OKC_API.G_MISS_NUM,
36: hour NUMBER := OKC_API.G_MISS_NUM,
37: minute NUMBER := OKC_API.G_MISS_NUM,
38: second NUMBER := OKC_API.G_MISS_NUM,
39: nth NUMBER := OKC_API.G_MISS_NUM,
40: day_of_week OKC_TIMEVALUES.DAY_OF_WEEK%TYPE := OKC_API.G_MISS_CHAR,
41: interval_yn OKC_TIMEVALUES.INTERVAL_YN%TYPE := OKC_API.G_MISS_CHAR,
42: last_update_login NUMBER := OKC_API.G_MISS_NUM,
35: day NUMBER := OKC_API.G_MISS_NUM,
36: hour NUMBER := OKC_API.G_MISS_NUM,
37: minute NUMBER := OKC_API.G_MISS_NUM,
38: second NUMBER := OKC_API.G_MISS_NUM,
39: nth NUMBER := OKC_API.G_MISS_NUM,
40: day_of_week OKC_TIMEVALUES.DAY_OF_WEEK%TYPE := OKC_API.G_MISS_CHAR,
41: interval_yn OKC_TIMEVALUES.INTERVAL_YN%TYPE := OKC_API.G_MISS_CHAR,
42: last_update_login NUMBER := OKC_API.G_MISS_NUM,
43: attribute_category OKC_TIMEVALUES.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
36: hour NUMBER := OKC_API.G_MISS_NUM,
37: minute NUMBER := OKC_API.G_MISS_NUM,
38: second NUMBER := OKC_API.G_MISS_NUM,
39: nth NUMBER := OKC_API.G_MISS_NUM,
40: day_of_week OKC_TIMEVALUES.DAY_OF_WEEK%TYPE := OKC_API.G_MISS_CHAR,
41: interval_yn OKC_TIMEVALUES.INTERVAL_YN%TYPE := OKC_API.G_MISS_CHAR,
42: last_update_login NUMBER := OKC_API.G_MISS_NUM,
43: attribute_category OKC_TIMEVALUES.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
44: attribute1 OKC_TIMEVALUES.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
37: minute NUMBER := OKC_API.G_MISS_NUM,
38: second NUMBER := OKC_API.G_MISS_NUM,
39: nth NUMBER := OKC_API.G_MISS_NUM,
40: day_of_week OKC_TIMEVALUES.DAY_OF_WEEK%TYPE := OKC_API.G_MISS_CHAR,
41: interval_yn OKC_TIMEVALUES.INTERVAL_YN%TYPE := OKC_API.G_MISS_CHAR,
42: last_update_login NUMBER := OKC_API.G_MISS_NUM,
43: attribute_category OKC_TIMEVALUES.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
44: attribute1 OKC_TIMEVALUES.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
45: attribute2 OKC_TIMEVALUES.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
38: second NUMBER := OKC_API.G_MISS_NUM,
39: nth NUMBER := OKC_API.G_MISS_NUM,
40: day_of_week OKC_TIMEVALUES.DAY_OF_WEEK%TYPE := OKC_API.G_MISS_CHAR,
41: interval_yn OKC_TIMEVALUES.INTERVAL_YN%TYPE := OKC_API.G_MISS_CHAR,
42: last_update_login NUMBER := OKC_API.G_MISS_NUM,
43: attribute_category OKC_TIMEVALUES.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
44: attribute1 OKC_TIMEVALUES.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
45: attribute2 OKC_TIMEVALUES.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
46: attribute3 OKC_TIMEVALUES.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
39: nth NUMBER := OKC_API.G_MISS_NUM,
40: day_of_week OKC_TIMEVALUES.DAY_OF_WEEK%TYPE := OKC_API.G_MISS_CHAR,
41: interval_yn OKC_TIMEVALUES.INTERVAL_YN%TYPE := OKC_API.G_MISS_CHAR,
42: last_update_login NUMBER := OKC_API.G_MISS_NUM,
43: attribute_category OKC_TIMEVALUES.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
44: attribute1 OKC_TIMEVALUES.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
45: attribute2 OKC_TIMEVALUES.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
46: attribute3 OKC_TIMEVALUES.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
47: attribute4 OKC_TIMEVALUES.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
40: day_of_week OKC_TIMEVALUES.DAY_OF_WEEK%TYPE := OKC_API.G_MISS_CHAR,
41: interval_yn OKC_TIMEVALUES.INTERVAL_YN%TYPE := OKC_API.G_MISS_CHAR,
42: last_update_login NUMBER := OKC_API.G_MISS_NUM,
43: attribute_category OKC_TIMEVALUES.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
44: attribute1 OKC_TIMEVALUES.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
45: attribute2 OKC_TIMEVALUES.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
46: attribute3 OKC_TIMEVALUES.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
47: attribute4 OKC_TIMEVALUES.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
48: attribute5 OKC_TIMEVALUES.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
41: interval_yn OKC_TIMEVALUES.INTERVAL_YN%TYPE := OKC_API.G_MISS_CHAR,
42: last_update_login NUMBER := OKC_API.G_MISS_NUM,
43: attribute_category OKC_TIMEVALUES.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
44: attribute1 OKC_TIMEVALUES.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
45: attribute2 OKC_TIMEVALUES.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
46: attribute3 OKC_TIMEVALUES.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
47: attribute4 OKC_TIMEVALUES.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
48: attribute5 OKC_TIMEVALUES.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
49: attribute6 OKC_TIMEVALUES.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
42: last_update_login NUMBER := OKC_API.G_MISS_NUM,
43: attribute_category OKC_TIMEVALUES.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
44: attribute1 OKC_TIMEVALUES.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
45: attribute2 OKC_TIMEVALUES.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
46: attribute3 OKC_TIMEVALUES.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
47: attribute4 OKC_TIMEVALUES.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
48: attribute5 OKC_TIMEVALUES.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
49: attribute6 OKC_TIMEVALUES.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
50: attribute7 OKC_TIMEVALUES.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
43: attribute_category OKC_TIMEVALUES.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
44: attribute1 OKC_TIMEVALUES.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
45: attribute2 OKC_TIMEVALUES.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
46: attribute3 OKC_TIMEVALUES.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
47: attribute4 OKC_TIMEVALUES.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
48: attribute5 OKC_TIMEVALUES.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
49: attribute6 OKC_TIMEVALUES.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
50: attribute7 OKC_TIMEVALUES.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
51: attribute8 OKC_TIMEVALUES.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
44: attribute1 OKC_TIMEVALUES.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
45: attribute2 OKC_TIMEVALUES.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
46: attribute3 OKC_TIMEVALUES.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
47: attribute4 OKC_TIMEVALUES.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
48: attribute5 OKC_TIMEVALUES.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
49: attribute6 OKC_TIMEVALUES.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
50: attribute7 OKC_TIMEVALUES.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
51: attribute8 OKC_TIMEVALUES.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
52: attribute9 OKC_TIMEVALUES.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
45: attribute2 OKC_TIMEVALUES.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
46: attribute3 OKC_TIMEVALUES.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
47: attribute4 OKC_TIMEVALUES.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
48: attribute5 OKC_TIMEVALUES.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
49: attribute6 OKC_TIMEVALUES.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
50: attribute7 OKC_TIMEVALUES.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
51: attribute8 OKC_TIMEVALUES.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
52: attribute9 OKC_TIMEVALUES.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
53: attribute10 OKC_TIMEVALUES.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
46: attribute3 OKC_TIMEVALUES.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
47: attribute4 OKC_TIMEVALUES.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
48: attribute5 OKC_TIMEVALUES.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
49: attribute6 OKC_TIMEVALUES.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
50: attribute7 OKC_TIMEVALUES.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
51: attribute8 OKC_TIMEVALUES.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
52: attribute9 OKC_TIMEVALUES.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
53: attribute10 OKC_TIMEVALUES.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
54: attribute11 OKC_TIMEVALUES.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
47: attribute4 OKC_TIMEVALUES.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
48: attribute5 OKC_TIMEVALUES.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
49: attribute6 OKC_TIMEVALUES.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
50: attribute7 OKC_TIMEVALUES.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
51: attribute8 OKC_TIMEVALUES.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
52: attribute9 OKC_TIMEVALUES.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
53: attribute10 OKC_TIMEVALUES.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
54: attribute11 OKC_TIMEVALUES.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
55: attribute12 OKC_TIMEVALUES.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
48: attribute5 OKC_TIMEVALUES.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
49: attribute6 OKC_TIMEVALUES.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
50: attribute7 OKC_TIMEVALUES.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
51: attribute8 OKC_TIMEVALUES.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
52: attribute9 OKC_TIMEVALUES.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
53: attribute10 OKC_TIMEVALUES.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
54: attribute11 OKC_TIMEVALUES.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
55: attribute12 OKC_TIMEVALUES.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
56: attribute13 OKC_TIMEVALUES.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
49: attribute6 OKC_TIMEVALUES.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
50: attribute7 OKC_TIMEVALUES.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
51: attribute8 OKC_TIMEVALUES.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
52: attribute9 OKC_TIMEVALUES.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
53: attribute10 OKC_TIMEVALUES.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
54: attribute11 OKC_TIMEVALUES.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
55: attribute12 OKC_TIMEVALUES.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
56: attribute13 OKC_TIMEVALUES.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
57: attribute14 OKC_TIMEVALUES.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
50: attribute7 OKC_TIMEVALUES.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
51: attribute8 OKC_TIMEVALUES.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
52: attribute9 OKC_TIMEVALUES.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
53: attribute10 OKC_TIMEVALUES.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
54: attribute11 OKC_TIMEVALUES.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
55: attribute12 OKC_TIMEVALUES.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
56: attribute13 OKC_TIMEVALUES.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
57: attribute14 OKC_TIMEVALUES.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
58: attribute15 OKC_TIMEVALUES.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
51: attribute8 OKC_TIMEVALUES.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
52: attribute9 OKC_TIMEVALUES.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
53: attribute10 OKC_TIMEVALUES.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
54: attribute11 OKC_TIMEVALUES.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
55: attribute12 OKC_TIMEVALUES.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
56: attribute13 OKC_TIMEVALUES.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
57: attribute14 OKC_TIMEVALUES.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
58: attribute15 OKC_TIMEVALUES.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
59: --Bug 3122962
52: attribute9 OKC_TIMEVALUES.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
53: attribute10 OKC_TIMEVALUES.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
54: attribute11 OKC_TIMEVALUES.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
55: attribute12 OKC_TIMEVALUES.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
56: attribute13 OKC_TIMEVALUES.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
57: attribute14 OKC_TIMEVALUES.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
58: attribute15 OKC_TIMEVALUES.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
59: --Bug 3122962
60: name OKC_TIMEVALUES.name%TYPE := OKC_API.G_MISS_CHAR,
53: attribute10 OKC_TIMEVALUES.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
54: attribute11 OKC_TIMEVALUES.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
55: attribute12 OKC_TIMEVALUES.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
56: attribute13 OKC_TIMEVALUES.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
57: attribute14 OKC_TIMEVALUES.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
58: attribute15 OKC_TIMEVALUES.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
59: --Bug 3122962
60: name OKC_TIMEVALUES.name%TYPE := OKC_API.G_MISS_CHAR,
61: description OKC_TIMEVALUES.description%TYPE := OKC_API.G_MISS_CHAR,
54: attribute11 OKC_TIMEVALUES.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
55: attribute12 OKC_TIMEVALUES.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
56: attribute13 OKC_TIMEVALUES.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
57: attribute14 OKC_TIMEVALUES.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
58: attribute15 OKC_TIMEVALUES.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
59: --Bug 3122962
60: name OKC_TIMEVALUES.name%TYPE := OKC_API.G_MISS_CHAR,
61: description OKC_TIMEVALUES.description%TYPE := OKC_API.G_MISS_CHAR,
62: short_description OKC_TIMEVALUES.short_description%TYPE := OKC_API.G_MISS_CHAR,
56: attribute13 OKC_TIMEVALUES.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
57: attribute14 OKC_TIMEVALUES.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
58: attribute15 OKC_TIMEVALUES.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
59: --Bug 3122962
60: name OKC_TIMEVALUES.name%TYPE := OKC_API.G_MISS_CHAR,
61: description OKC_TIMEVALUES.description%TYPE := OKC_API.G_MISS_CHAR,
62: short_description OKC_TIMEVALUES.short_description%TYPE := OKC_API.G_MISS_CHAR,
63: comments OKC_TIMEVALUES.comments%TYPE := OKC_API.G_MISS_CHAR
64: );
57: attribute14 OKC_TIMEVALUES.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
58: attribute15 OKC_TIMEVALUES.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
59: --Bug 3122962
60: name OKC_TIMEVALUES.name%TYPE := OKC_API.G_MISS_CHAR,
61: description OKC_TIMEVALUES.description%TYPE := OKC_API.G_MISS_CHAR,
62: short_description OKC_TIMEVALUES.short_description%TYPE := OKC_API.G_MISS_CHAR,
63: comments OKC_TIMEVALUES.comments%TYPE := OKC_API.G_MISS_CHAR
64: );
65: g_miss_tve_rec tve_rec_type;
58: attribute15 OKC_TIMEVALUES.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
59: --Bug 3122962
60: name OKC_TIMEVALUES.name%TYPE := OKC_API.G_MISS_CHAR,
61: description OKC_TIMEVALUES.description%TYPE := OKC_API.G_MISS_CHAR,
62: short_description OKC_TIMEVALUES.short_description%TYPE := OKC_API.G_MISS_CHAR,
63: comments OKC_TIMEVALUES.comments%TYPE := OKC_API.G_MISS_CHAR
64: );
65: g_miss_tve_rec tve_rec_type;
66: TYPE tve_tbl_type IS TABLE OF tve_rec_type
59: --Bug 3122962
60: name OKC_TIMEVALUES.name%TYPE := OKC_API.G_MISS_CHAR,
61: description OKC_TIMEVALUES.description%TYPE := OKC_API.G_MISS_CHAR,
62: short_description OKC_TIMEVALUES.short_description%TYPE := OKC_API.G_MISS_CHAR,
63: comments OKC_TIMEVALUES.comments%TYPE := OKC_API.G_MISS_CHAR
64: );
65: g_miss_tve_rec tve_rec_type;
66: TYPE tve_tbl_type IS TABLE OF tve_rec_type
67: INDEX BY BINARY_INTEGER;
67: INDEX BY BINARY_INTEGER;
68: --Bug 3122962
69: /*
70: TYPE okc_timevalues_tl_rec_type IS RECORD (
71: id NUMBER := OKC_API.G_MISS_NUM,
72: language OKC_TIMEVALUES_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
73: source_lang OKC_TIMEVALUES_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
74: sfwt_flag OKC_TIMEVALUES_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
75: description OKC_TIMEVALUES_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
68: --Bug 3122962
69: /*
70: TYPE okc_timevalues_tl_rec_type IS RECORD (
71: id NUMBER := OKC_API.G_MISS_NUM,
72: language OKC_TIMEVALUES_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
73: source_lang OKC_TIMEVALUES_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
74: sfwt_flag OKC_TIMEVALUES_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
75: description OKC_TIMEVALUES_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
76: short_description OKC_TIMEVALUES_TL.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
69: /*
70: TYPE okc_timevalues_tl_rec_type IS RECORD (
71: id NUMBER := OKC_API.G_MISS_NUM,
72: language OKC_TIMEVALUES_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
73: source_lang OKC_TIMEVALUES_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
74: sfwt_flag OKC_TIMEVALUES_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
75: description OKC_TIMEVALUES_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
76: short_description OKC_TIMEVALUES_TL.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
77: comments OKC_TIMEVALUES_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
70: TYPE okc_timevalues_tl_rec_type IS RECORD (
71: id NUMBER := OKC_API.G_MISS_NUM,
72: language OKC_TIMEVALUES_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
73: source_lang OKC_TIMEVALUES_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
74: sfwt_flag OKC_TIMEVALUES_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
75: description OKC_TIMEVALUES_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
76: short_description OKC_TIMEVALUES_TL.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
77: comments OKC_TIMEVALUES_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
78: name OKC_TIMEVALUES_TL.NAME%TYPE := OKC_API.G_MISS_CHAR,
71: id NUMBER := OKC_API.G_MISS_NUM,
72: language OKC_TIMEVALUES_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
73: source_lang OKC_TIMEVALUES_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
74: sfwt_flag OKC_TIMEVALUES_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
75: description OKC_TIMEVALUES_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
76: short_description OKC_TIMEVALUES_TL.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
77: comments OKC_TIMEVALUES_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
78: name OKC_TIMEVALUES_TL.NAME%TYPE := OKC_API.G_MISS_CHAR,
79: created_by NUMBER := OKC_API.G_MISS_NUM,
72: language OKC_TIMEVALUES_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
73: source_lang OKC_TIMEVALUES_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
74: sfwt_flag OKC_TIMEVALUES_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
75: description OKC_TIMEVALUES_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
76: short_description OKC_TIMEVALUES_TL.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
77: comments OKC_TIMEVALUES_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
78: name OKC_TIMEVALUES_TL.NAME%TYPE := OKC_API.G_MISS_CHAR,
79: created_by NUMBER := OKC_API.G_MISS_NUM,
80: creation_date OKC_TIMEVALUES_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
73: source_lang OKC_TIMEVALUES_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
74: sfwt_flag OKC_TIMEVALUES_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
75: description OKC_TIMEVALUES_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
76: short_description OKC_TIMEVALUES_TL.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
77: comments OKC_TIMEVALUES_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
78: name OKC_TIMEVALUES_TL.NAME%TYPE := OKC_API.G_MISS_CHAR,
79: created_by NUMBER := OKC_API.G_MISS_NUM,
80: creation_date OKC_TIMEVALUES_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
81: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
74: sfwt_flag OKC_TIMEVALUES_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
75: description OKC_TIMEVALUES_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
76: short_description OKC_TIMEVALUES_TL.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
77: comments OKC_TIMEVALUES_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
78: name OKC_TIMEVALUES_TL.NAME%TYPE := OKC_API.G_MISS_CHAR,
79: created_by NUMBER := OKC_API.G_MISS_NUM,
80: creation_date OKC_TIMEVALUES_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
81: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
82: last_update_date OKC_TIMEVALUES_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
75: description OKC_TIMEVALUES_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
76: short_description OKC_TIMEVALUES_TL.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
77: comments OKC_TIMEVALUES_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
78: name OKC_TIMEVALUES_TL.NAME%TYPE := OKC_API.G_MISS_CHAR,
79: created_by NUMBER := OKC_API.G_MISS_NUM,
80: creation_date OKC_TIMEVALUES_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
81: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
82: last_update_date OKC_TIMEVALUES_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
83: last_update_login NUMBER := OKC_API.G_MISS_NUM);
76: short_description OKC_TIMEVALUES_TL.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
77: comments OKC_TIMEVALUES_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
78: name OKC_TIMEVALUES_TL.NAME%TYPE := OKC_API.G_MISS_CHAR,
79: created_by NUMBER := OKC_API.G_MISS_NUM,
80: creation_date OKC_TIMEVALUES_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
81: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
82: last_update_date OKC_TIMEVALUES_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
83: last_update_login NUMBER := OKC_API.G_MISS_NUM);
84: g_miss_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
77: comments OKC_TIMEVALUES_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
78: name OKC_TIMEVALUES_TL.NAME%TYPE := OKC_API.G_MISS_CHAR,
79: created_by NUMBER := OKC_API.G_MISS_NUM,
80: creation_date OKC_TIMEVALUES_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
81: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
82: last_update_date OKC_TIMEVALUES_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
83: last_update_login NUMBER := OKC_API.G_MISS_NUM);
84: g_miss_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
85: TYPE okc_timevalues_tl_tbl_type IS TABLE OF okc_timevalues_tl_rec_type
78: name OKC_TIMEVALUES_TL.NAME%TYPE := OKC_API.G_MISS_CHAR,
79: created_by NUMBER := OKC_API.G_MISS_NUM,
80: creation_date OKC_TIMEVALUES_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
81: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
82: last_update_date OKC_TIMEVALUES_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
83: last_update_login NUMBER := OKC_API.G_MISS_NUM);
84: g_miss_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
85: TYPE okc_timevalues_tl_tbl_type IS TABLE OF okc_timevalues_tl_rec_type
86: INDEX BY BINARY_INTEGER;
79: created_by NUMBER := OKC_API.G_MISS_NUM,
80: creation_date OKC_TIMEVALUES_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
81: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
82: last_update_date OKC_TIMEVALUES_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
83: last_update_login NUMBER := OKC_API.G_MISS_NUM);
84: g_miss_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
85: TYPE okc_timevalues_tl_tbl_type IS TABLE OF okc_timevalues_tl_rec_type
86: INDEX BY BINARY_INTEGER;
87: */
85: TYPE okc_timevalues_tl_tbl_type IS TABLE OF okc_timevalues_tl_rec_type
86: INDEX BY BINARY_INTEGER;
87: */
88: TYPE cylv_rec_type IS RECORD (
89: id NUMBER := OKC_API.G_MISS_NUM,
90: object_version_number NUMBER := OKC_API.G_MISS_NUM,
91: --Bug 3122962
92: sfwt_flag OKC_TIME_CYCLE_V.SFWT_FLAG%TYPE := 'N',
93: spn_id NUMBER := OKC_API.G_MISS_NUM,
86: INDEX BY BINARY_INTEGER;
87: */
88: TYPE cylv_rec_type IS RECORD (
89: id NUMBER := OKC_API.G_MISS_NUM,
90: object_version_number NUMBER := OKC_API.G_MISS_NUM,
91: --Bug 3122962
92: sfwt_flag OKC_TIME_CYCLE_V.SFWT_FLAG%TYPE := 'N',
93: spn_id NUMBER := OKC_API.G_MISS_NUM,
94: tve_id_limited NUMBER := OKC_API.G_MISS_NUM,
89: id NUMBER := OKC_API.G_MISS_NUM,
90: object_version_number NUMBER := OKC_API.G_MISS_NUM,
91: --Bug 3122962
92: sfwt_flag OKC_TIME_CYCLE_V.SFWT_FLAG%TYPE := 'N',
93: spn_id NUMBER := OKC_API.G_MISS_NUM,
94: tve_id_limited NUMBER := OKC_API.G_MISS_NUM,
95: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
96: tze_id NUMBER := OKC_API.G_MISS_NUM,
97: description OKC_TIME_CYCLE_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
90: object_version_number NUMBER := OKC_API.G_MISS_NUM,
91: --Bug 3122962
92: sfwt_flag OKC_TIME_CYCLE_V.SFWT_FLAG%TYPE := 'N',
93: spn_id NUMBER := OKC_API.G_MISS_NUM,
94: tve_id_limited NUMBER := OKC_API.G_MISS_NUM,
95: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
96: tze_id NUMBER := OKC_API.G_MISS_NUM,
97: description OKC_TIME_CYCLE_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
98: short_description OKC_TIME_CYCLE_V.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
91: --Bug 3122962
92: sfwt_flag OKC_TIME_CYCLE_V.SFWT_FLAG%TYPE := 'N',
93: spn_id NUMBER := OKC_API.G_MISS_NUM,
94: tve_id_limited NUMBER := OKC_API.G_MISS_NUM,
95: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
96: tze_id NUMBER := OKC_API.G_MISS_NUM,
97: description OKC_TIME_CYCLE_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
98: short_description OKC_TIME_CYCLE_V.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
99: comments OKC_TIME_CYCLE_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
92: sfwt_flag OKC_TIME_CYCLE_V.SFWT_FLAG%TYPE := 'N',
93: spn_id NUMBER := OKC_API.G_MISS_NUM,
94: tve_id_limited NUMBER := OKC_API.G_MISS_NUM,
95: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
96: tze_id NUMBER := OKC_API.G_MISS_NUM,
97: description OKC_TIME_CYCLE_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
98: short_description OKC_TIME_CYCLE_V.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
99: comments OKC_TIME_CYCLE_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
100: name OKC_TIME_CYCLE_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
93: spn_id NUMBER := OKC_API.G_MISS_NUM,
94: tve_id_limited NUMBER := OKC_API.G_MISS_NUM,
95: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
96: tze_id NUMBER := OKC_API.G_MISS_NUM,
97: description OKC_TIME_CYCLE_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
98: short_description OKC_TIME_CYCLE_V.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
99: comments OKC_TIME_CYCLE_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
100: name OKC_TIME_CYCLE_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
101: interval_yn OKC_TIME_CYCLE_V.INTERVAL_YN%TYPE := OKC_API.G_MISS_CHAR,
94: tve_id_limited NUMBER := OKC_API.G_MISS_NUM,
95: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
96: tze_id NUMBER := OKC_API.G_MISS_NUM,
97: description OKC_TIME_CYCLE_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
98: short_description OKC_TIME_CYCLE_V.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
99: comments OKC_TIME_CYCLE_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
100: name OKC_TIME_CYCLE_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
101: interval_yn OKC_TIME_CYCLE_V.INTERVAL_YN%TYPE := OKC_API.G_MISS_CHAR,
102: attribute_category OKC_TIME_CYCLE_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
95: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
96: tze_id NUMBER := OKC_API.G_MISS_NUM,
97: description OKC_TIME_CYCLE_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
98: short_description OKC_TIME_CYCLE_V.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
99: comments OKC_TIME_CYCLE_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
100: name OKC_TIME_CYCLE_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
101: interval_yn OKC_TIME_CYCLE_V.INTERVAL_YN%TYPE := OKC_API.G_MISS_CHAR,
102: attribute_category OKC_TIME_CYCLE_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
103: attribute1 OKC_TIME_CYCLE_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
96: tze_id NUMBER := OKC_API.G_MISS_NUM,
97: description OKC_TIME_CYCLE_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
98: short_description OKC_TIME_CYCLE_V.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
99: comments OKC_TIME_CYCLE_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
100: name OKC_TIME_CYCLE_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
101: interval_yn OKC_TIME_CYCLE_V.INTERVAL_YN%TYPE := OKC_API.G_MISS_CHAR,
102: attribute_category OKC_TIME_CYCLE_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
103: attribute1 OKC_TIME_CYCLE_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
104: attribute2 OKC_TIME_CYCLE_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
97: description OKC_TIME_CYCLE_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
98: short_description OKC_TIME_CYCLE_V.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
99: comments OKC_TIME_CYCLE_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
100: name OKC_TIME_CYCLE_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
101: interval_yn OKC_TIME_CYCLE_V.INTERVAL_YN%TYPE := OKC_API.G_MISS_CHAR,
102: attribute_category OKC_TIME_CYCLE_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
103: attribute1 OKC_TIME_CYCLE_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
104: attribute2 OKC_TIME_CYCLE_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
105: attribute3 OKC_TIME_CYCLE_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
98: short_description OKC_TIME_CYCLE_V.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
99: comments OKC_TIME_CYCLE_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
100: name OKC_TIME_CYCLE_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
101: interval_yn OKC_TIME_CYCLE_V.INTERVAL_YN%TYPE := OKC_API.G_MISS_CHAR,
102: attribute_category OKC_TIME_CYCLE_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
103: attribute1 OKC_TIME_CYCLE_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
104: attribute2 OKC_TIME_CYCLE_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
105: attribute3 OKC_TIME_CYCLE_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
106: attribute4 OKC_TIME_CYCLE_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
99: comments OKC_TIME_CYCLE_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
100: name OKC_TIME_CYCLE_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
101: interval_yn OKC_TIME_CYCLE_V.INTERVAL_YN%TYPE := OKC_API.G_MISS_CHAR,
102: attribute_category OKC_TIME_CYCLE_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
103: attribute1 OKC_TIME_CYCLE_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
104: attribute2 OKC_TIME_CYCLE_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
105: attribute3 OKC_TIME_CYCLE_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
106: attribute4 OKC_TIME_CYCLE_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
107: attribute5 OKC_TIME_CYCLE_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
100: name OKC_TIME_CYCLE_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
101: interval_yn OKC_TIME_CYCLE_V.INTERVAL_YN%TYPE := OKC_API.G_MISS_CHAR,
102: attribute_category OKC_TIME_CYCLE_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
103: attribute1 OKC_TIME_CYCLE_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
104: attribute2 OKC_TIME_CYCLE_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
105: attribute3 OKC_TIME_CYCLE_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
106: attribute4 OKC_TIME_CYCLE_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
107: attribute5 OKC_TIME_CYCLE_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
108: attribute6 OKC_TIME_CYCLE_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
101: interval_yn OKC_TIME_CYCLE_V.INTERVAL_YN%TYPE := OKC_API.G_MISS_CHAR,
102: attribute_category OKC_TIME_CYCLE_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
103: attribute1 OKC_TIME_CYCLE_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
104: attribute2 OKC_TIME_CYCLE_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
105: attribute3 OKC_TIME_CYCLE_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
106: attribute4 OKC_TIME_CYCLE_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
107: attribute5 OKC_TIME_CYCLE_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
108: attribute6 OKC_TIME_CYCLE_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
109: attribute7 OKC_TIME_CYCLE_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
102: attribute_category OKC_TIME_CYCLE_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
103: attribute1 OKC_TIME_CYCLE_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
104: attribute2 OKC_TIME_CYCLE_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
105: attribute3 OKC_TIME_CYCLE_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
106: attribute4 OKC_TIME_CYCLE_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
107: attribute5 OKC_TIME_CYCLE_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
108: attribute6 OKC_TIME_CYCLE_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
109: attribute7 OKC_TIME_CYCLE_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
110: attribute8 OKC_TIME_CYCLE_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
103: attribute1 OKC_TIME_CYCLE_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
104: attribute2 OKC_TIME_CYCLE_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
105: attribute3 OKC_TIME_CYCLE_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
106: attribute4 OKC_TIME_CYCLE_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
107: attribute5 OKC_TIME_CYCLE_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
108: attribute6 OKC_TIME_CYCLE_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
109: attribute7 OKC_TIME_CYCLE_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
110: attribute8 OKC_TIME_CYCLE_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
111: attribute9 OKC_TIME_CYCLE_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
104: attribute2 OKC_TIME_CYCLE_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
105: attribute3 OKC_TIME_CYCLE_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
106: attribute4 OKC_TIME_CYCLE_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
107: attribute5 OKC_TIME_CYCLE_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
108: attribute6 OKC_TIME_CYCLE_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
109: attribute7 OKC_TIME_CYCLE_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
110: attribute8 OKC_TIME_CYCLE_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
111: attribute9 OKC_TIME_CYCLE_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
112: attribute10 OKC_TIME_CYCLE_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
105: attribute3 OKC_TIME_CYCLE_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
106: attribute4 OKC_TIME_CYCLE_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
107: attribute5 OKC_TIME_CYCLE_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
108: attribute6 OKC_TIME_CYCLE_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
109: attribute7 OKC_TIME_CYCLE_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
110: attribute8 OKC_TIME_CYCLE_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
111: attribute9 OKC_TIME_CYCLE_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
112: attribute10 OKC_TIME_CYCLE_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
113: attribute11 OKC_TIME_CYCLE_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
106: attribute4 OKC_TIME_CYCLE_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
107: attribute5 OKC_TIME_CYCLE_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
108: attribute6 OKC_TIME_CYCLE_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
109: attribute7 OKC_TIME_CYCLE_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
110: attribute8 OKC_TIME_CYCLE_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
111: attribute9 OKC_TIME_CYCLE_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
112: attribute10 OKC_TIME_CYCLE_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
113: attribute11 OKC_TIME_CYCLE_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
114: attribute12 OKC_TIME_CYCLE_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
107: attribute5 OKC_TIME_CYCLE_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
108: attribute6 OKC_TIME_CYCLE_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
109: attribute7 OKC_TIME_CYCLE_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
110: attribute8 OKC_TIME_CYCLE_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
111: attribute9 OKC_TIME_CYCLE_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
112: attribute10 OKC_TIME_CYCLE_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
113: attribute11 OKC_TIME_CYCLE_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
114: attribute12 OKC_TIME_CYCLE_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
115: attribute13 OKC_TIME_CYCLE_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
108: attribute6 OKC_TIME_CYCLE_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
109: attribute7 OKC_TIME_CYCLE_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
110: attribute8 OKC_TIME_CYCLE_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
111: attribute9 OKC_TIME_CYCLE_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
112: attribute10 OKC_TIME_CYCLE_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
113: attribute11 OKC_TIME_CYCLE_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
114: attribute12 OKC_TIME_CYCLE_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
115: attribute13 OKC_TIME_CYCLE_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
116: attribute14 OKC_TIME_CYCLE_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
109: attribute7 OKC_TIME_CYCLE_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
110: attribute8 OKC_TIME_CYCLE_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
111: attribute9 OKC_TIME_CYCLE_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
112: attribute10 OKC_TIME_CYCLE_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
113: attribute11 OKC_TIME_CYCLE_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
114: attribute12 OKC_TIME_CYCLE_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
115: attribute13 OKC_TIME_CYCLE_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
116: attribute14 OKC_TIME_CYCLE_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
117: attribute15 OKC_TIME_CYCLE_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
110: attribute8 OKC_TIME_CYCLE_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
111: attribute9 OKC_TIME_CYCLE_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
112: attribute10 OKC_TIME_CYCLE_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
113: attribute11 OKC_TIME_CYCLE_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
114: attribute12 OKC_TIME_CYCLE_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
115: attribute13 OKC_TIME_CYCLE_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
116: attribute14 OKC_TIME_CYCLE_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
117: attribute15 OKC_TIME_CYCLE_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
118: created_by NUMBER := OKC_API.G_MISS_NUM,
111: attribute9 OKC_TIME_CYCLE_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
112: attribute10 OKC_TIME_CYCLE_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
113: attribute11 OKC_TIME_CYCLE_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
114: attribute12 OKC_TIME_CYCLE_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
115: attribute13 OKC_TIME_CYCLE_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
116: attribute14 OKC_TIME_CYCLE_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
117: attribute15 OKC_TIME_CYCLE_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
118: created_by NUMBER := OKC_API.G_MISS_NUM,
119: creation_date OKC_TIME_CYCLE_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
112: attribute10 OKC_TIME_CYCLE_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
113: attribute11 OKC_TIME_CYCLE_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
114: attribute12 OKC_TIME_CYCLE_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
115: attribute13 OKC_TIME_CYCLE_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
116: attribute14 OKC_TIME_CYCLE_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
117: attribute15 OKC_TIME_CYCLE_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
118: created_by NUMBER := OKC_API.G_MISS_NUM,
119: creation_date OKC_TIME_CYCLE_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
120: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
113: attribute11 OKC_TIME_CYCLE_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
114: attribute12 OKC_TIME_CYCLE_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
115: attribute13 OKC_TIME_CYCLE_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
116: attribute14 OKC_TIME_CYCLE_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
117: attribute15 OKC_TIME_CYCLE_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
118: created_by NUMBER := OKC_API.G_MISS_NUM,
119: creation_date OKC_TIME_CYCLE_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
120: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
121: last_update_date OKC_TIME_CYCLE_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
114: attribute12 OKC_TIME_CYCLE_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
115: attribute13 OKC_TIME_CYCLE_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
116: attribute14 OKC_TIME_CYCLE_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
117: attribute15 OKC_TIME_CYCLE_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
118: created_by NUMBER := OKC_API.G_MISS_NUM,
119: creation_date OKC_TIME_CYCLE_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
120: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
121: last_update_date OKC_TIME_CYCLE_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
122: last_update_login NUMBER := OKC_API.G_MISS_NUM);
115: attribute13 OKC_TIME_CYCLE_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
116: attribute14 OKC_TIME_CYCLE_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
117: attribute15 OKC_TIME_CYCLE_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
118: created_by NUMBER := OKC_API.G_MISS_NUM,
119: creation_date OKC_TIME_CYCLE_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
120: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
121: last_update_date OKC_TIME_CYCLE_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
122: last_update_login NUMBER := OKC_API.G_MISS_NUM);
123: g_miss_cylv_rec cylv_rec_type;
116: attribute14 OKC_TIME_CYCLE_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
117: attribute15 OKC_TIME_CYCLE_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
118: created_by NUMBER := OKC_API.G_MISS_NUM,
119: creation_date OKC_TIME_CYCLE_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
120: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
121: last_update_date OKC_TIME_CYCLE_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
122: last_update_login NUMBER := OKC_API.G_MISS_NUM);
123: g_miss_cylv_rec cylv_rec_type;
124: TYPE cylv_tbl_type IS TABLE OF cylv_rec_type
117: attribute15 OKC_TIME_CYCLE_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
118: created_by NUMBER := OKC_API.G_MISS_NUM,
119: creation_date OKC_TIME_CYCLE_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
120: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
121: last_update_date OKC_TIME_CYCLE_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
122: last_update_login NUMBER := OKC_API.G_MISS_NUM);
123: g_miss_cylv_rec cylv_rec_type;
124: TYPE cylv_tbl_type IS TABLE OF cylv_rec_type
125: INDEX BY BINARY_INTEGER;
118: created_by NUMBER := OKC_API.G_MISS_NUM,
119: creation_date OKC_TIME_CYCLE_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
120: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
121: last_update_date OKC_TIME_CYCLE_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
122: last_update_login NUMBER := OKC_API.G_MISS_NUM);
123: g_miss_cylv_rec cylv_rec_type;
124: TYPE cylv_tbl_type IS TABLE OF cylv_rec_type
125: INDEX BY BINARY_INTEGER;
126: ---------------------------------------------------------------------------
125: INDEX BY BINARY_INTEGER;
126: ---------------------------------------------------------------------------
127: -- GLOBAL MESSAGE CONSTANTS
128: ---------------------------------------------------------------------------
129: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
130: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
131: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
132: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
133: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
126: ---------------------------------------------------------------------------
127: -- GLOBAL MESSAGE CONSTANTS
128: ---------------------------------------------------------------------------
129: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
130: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
131: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
132: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
133: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
134: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
127: -- GLOBAL MESSAGE CONSTANTS
128: ---------------------------------------------------------------------------
129: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
130: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
131: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
132: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
133: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
134: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
135: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
128: ---------------------------------------------------------------------------
129: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
130: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
131: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
132: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
133: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
134: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
135: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
136: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
129: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
130: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
131: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
132: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
133: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
134: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
135: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
136: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
137: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
130: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
131: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
132: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
133: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
134: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
135: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
136: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
137: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
138: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
131: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
132: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
133: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
134: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
135: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
136: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
137: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
138: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
139: ---------------------------------------------------------------------------
132: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
133: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
134: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
135: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
136: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
137: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
138: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
139: ---------------------------------------------------------------------------
140: -- GLOBAL VARIABLES
133: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
134: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
135: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
136: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
137: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
138: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
139: ---------------------------------------------------------------------------
140: -- GLOBAL VARIABLES
141: ---------------------------------------------------------------------------
134: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
135: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
136: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
137: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
138: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
139: ---------------------------------------------------------------------------
140: -- GLOBAL VARIABLES
141: ---------------------------------------------------------------------------
142: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_CYL_PVT';
139: ---------------------------------------------------------------------------
140: -- GLOBAL VARIABLES
141: ---------------------------------------------------------------------------
142: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_CYL_PVT';
143: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
144: ---------------------------------------------------------------------------
145: -- Procedures and Functions
146: ---------------------------------------------------------------------------
147:
149: PROCEDURE change_version;
150: PROCEDURE api_copy;
151: PROCEDURE insert_row(
152: p_api_version IN NUMBER,
153: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
154: x_return_status OUT NOCOPY VARCHAR2,
155: x_msg_count OUT NOCOPY NUMBER,
156: x_msg_data OUT NOCOPY VARCHAR2,
157: p_cylv_rec IN cylv_rec_type,
158: x_cylv_rec OUT NOCOPY cylv_rec_type);
159:
160: PROCEDURE insert_row(
161: p_api_version IN NUMBER,
162: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
163: x_return_status OUT NOCOPY VARCHAR2,
164: x_msg_count OUT NOCOPY NUMBER,
165: x_msg_data OUT NOCOPY VARCHAR2,
166: p_cylv_tbl IN cylv_tbl_type,
167: x_cylv_tbl OUT NOCOPY cylv_tbl_type);
168:
169: PROCEDURE lock_row(
170: p_api_version IN NUMBER,
171: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
172: x_return_status OUT NOCOPY VARCHAR2,
173: x_msg_count OUT NOCOPY NUMBER,
174: x_msg_data OUT NOCOPY VARCHAR2,
175: p_cylv_rec IN cylv_rec_type);
175: p_cylv_rec IN cylv_rec_type);
176:
177: PROCEDURE lock_row(
178: p_api_version IN NUMBER,
179: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
180: x_return_status OUT NOCOPY VARCHAR2,
181: x_msg_count OUT NOCOPY NUMBER,
182: x_msg_data OUT NOCOPY VARCHAR2,
183: p_cylv_tbl IN cylv_tbl_type);
183: p_cylv_tbl IN cylv_tbl_type);
184:
185: PROCEDURE update_row(
186: p_api_version IN NUMBER,
187: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
188: x_return_status OUT NOCOPY VARCHAR2,
189: x_msg_count OUT NOCOPY NUMBER,
190: x_msg_data OUT NOCOPY VARCHAR2,
191: p_cylv_rec IN cylv_rec_type,
192: x_cylv_rec OUT NOCOPY cylv_rec_type);
193:
194: PROCEDURE update_row(
195: p_api_version IN NUMBER,
196: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
197: x_return_status OUT NOCOPY VARCHAR2,
198: x_msg_count OUT NOCOPY NUMBER,
199: x_msg_data OUT NOCOPY VARCHAR2,
200: p_cylv_tbl IN cylv_tbl_type,
201: x_cylv_tbl OUT NOCOPY cylv_tbl_type);
202:
203: PROCEDURE delete_row(
204: p_api_version IN NUMBER,
205: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
206: x_return_status OUT NOCOPY VARCHAR2,
207: x_msg_count OUT NOCOPY NUMBER,
208: x_msg_data OUT NOCOPY VARCHAR2,
209: p_cylv_rec IN cylv_rec_type);
209: p_cylv_rec IN cylv_rec_type);
210:
211: PROCEDURE delete_row(
212: p_api_version IN NUMBER,
213: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
214: x_return_status OUT NOCOPY VARCHAR2,
215: x_msg_count OUT NOCOPY NUMBER,
216: x_msg_data OUT NOCOPY VARCHAR2,
217: p_cylv_tbl IN cylv_tbl_type);
217: p_cylv_tbl IN cylv_tbl_type);
218:
219: PROCEDURE validate_row(
220: p_api_version IN NUMBER,
221: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
222: x_return_status OUT NOCOPY VARCHAR2,
223: x_msg_count OUT NOCOPY NUMBER,
224: x_msg_data OUT NOCOPY VARCHAR2,
225: p_cylv_rec IN cylv_rec_type);
225: p_cylv_rec IN cylv_rec_type);
226:
227: PROCEDURE validate_row(
228: p_api_version IN NUMBER,
229: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
230: x_return_status OUT NOCOPY VARCHAR2,
231: x_msg_count OUT NOCOPY NUMBER,
232: x_msg_data OUT NOCOPY VARCHAR2,
233: p_cylv_tbl IN cylv_tbl_type);