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: dnz_chr_id 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: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
19: tze_id 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: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
19: tze_id NUMBER := OKC_API.G_MISS_NUM,
20: tve_id_limited 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: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
19: tze_id NUMBER := OKC_API.G_MISS_NUM,
20: tve_id_limited NUMBER := OKC_API.G_MISS_NUM,
21: tve_id_generated_by 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: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
19: tze_id NUMBER := OKC_API.G_MISS_NUM,
20: tve_id_limited NUMBER := OKC_API.G_MISS_NUM,
21: tve_id_generated_by NUMBER := OKC_API.G_MISS_NUM,
22: tve_id_started 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: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
19: tze_id NUMBER := OKC_API.G_MISS_NUM,
20: tve_id_limited NUMBER := OKC_API.G_MISS_NUM,
21: tve_id_generated_by NUMBER := OKC_API.G_MISS_NUM,
22: tve_id_started NUMBER := OKC_API.G_MISS_NUM,
23: tve_id_ended 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: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
19: tze_id NUMBER := OKC_API.G_MISS_NUM,
20: tve_id_limited NUMBER := OKC_API.G_MISS_NUM,
21: tve_id_generated_by NUMBER := OKC_API.G_MISS_NUM,
22: tve_id_started NUMBER := OKC_API.G_MISS_NUM,
23: tve_id_ended 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: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
19: tze_id NUMBER := OKC_API.G_MISS_NUM,
20: tve_id_limited NUMBER := OKC_API.G_MISS_NUM,
21: tve_id_generated_by NUMBER := OKC_API.G_MISS_NUM,
22: tve_id_started NUMBER := OKC_API.G_MISS_NUM,
23: tve_id_ended 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: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
19: tze_id NUMBER := OKC_API.G_MISS_NUM,
20: tve_id_limited NUMBER := OKC_API.G_MISS_NUM,
21: tve_id_generated_by NUMBER := OKC_API.G_MISS_NUM,
22: tve_id_started NUMBER := OKC_API.G_MISS_NUM,
23: tve_id_ended 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: tze_id NUMBER := OKC_API.G_MISS_NUM,
20: tve_id_limited NUMBER := OKC_API.G_MISS_NUM,
21: tve_id_generated_by NUMBER := OKC_API.G_MISS_NUM,
22: tve_id_started NUMBER := OKC_API.G_MISS_NUM,
23: tve_id_ended 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_limited NUMBER := OKC_API.G_MISS_NUM,
21: tve_id_generated_by NUMBER := OKC_API.G_MISS_NUM,
22: tve_id_started NUMBER := OKC_API.G_MISS_NUM,
23: tve_id_ended 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_generated_by NUMBER := OKC_API.G_MISS_NUM,
22: tve_id_started NUMBER := OKC_API.G_MISS_NUM,
23: tve_id_ended 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: tve_id_started NUMBER := OKC_API.G_MISS_NUM,
23: tve_id_ended 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: tve_id_ended 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: --Bug 3122962
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: --Bug 3122962
44: name OKC_TIMEVALUES.name%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: --Bug 3122962
44: name OKC_TIMEVALUES.name%TYPE := OKC_API.G_MISS_CHAR,
45: description OKC_TIMEVALUES.description%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: --Bug 3122962
44: name OKC_TIMEVALUES.name%TYPE := OKC_API.G_MISS_CHAR,
45: description OKC_TIMEVALUES.description%TYPE := OKC_API.G_MISS_CHAR,
46: short_description OKC_TIMEVALUES.short_description%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: --Bug 3122962
44: name OKC_TIMEVALUES.name%TYPE := OKC_API.G_MISS_CHAR,
45: description OKC_TIMEVALUES.description%TYPE := OKC_API.G_MISS_CHAR,
46: short_description OKC_TIMEVALUES.short_description%TYPE := OKC_API.G_MISS_CHAR,
47: comments OKC_TIMEVALUES.comments%TYPE := OKC_API.G_MISS_CHAR,
48:
41: interval_yn OKC_TIMEVALUES.INTERVAL_YN%TYPE := OKC_API.G_MISS_CHAR,
42: last_update_login NUMBER := OKC_API.G_MISS_NUM,
43: --Bug 3122962
44: name OKC_TIMEVALUES.name%TYPE := OKC_API.G_MISS_CHAR,
45: description OKC_TIMEVALUES.description%TYPE := OKC_API.G_MISS_CHAR,
46: short_description OKC_TIMEVALUES.short_description%TYPE := OKC_API.G_MISS_CHAR,
47: comments OKC_TIMEVALUES.comments%TYPE := OKC_API.G_MISS_CHAR,
48:
49: attribute_category OKC_TIMEVALUES.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
42: last_update_login NUMBER := OKC_API.G_MISS_NUM,
43: --Bug 3122962
44: name OKC_TIMEVALUES.name%TYPE := OKC_API.G_MISS_CHAR,
45: description OKC_TIMEVALUES.description%TYPE := OKC_API.G_MISS_CHAR,
46: short_description OKC_TIMEVALUES.short_description%TYPE := OKC_API.G_MISS_CHAR,
47: comments OKC_TIMEVALUES.comments%TYPE := OKC_API.G_MISS_CHAR,
48:
49: attribute_category OKC_TIMEVALUES.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
50: attribute1 OKC_TIMEVALUES.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
43: --Bug 3122962
44: name OKC_TIMEVALUES.name%TYPE := OKC_API.G_MISS_CHAR,
45: description OKC_TIMEVALUES.description%TYPE := OKC_API.G_MISS_CHAR,
46: short_description OKC_TIMEVALUES.short_description%TYPE := OKC_API.G_MISS_CHAR,
47: comments OKC_TIMEVALUES.comments%TYPE := OKC_API.G_MISS_CHAR,
48:
49: attribute_category OKC_TIMEVALUES.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
50: attribute1 OKC_TIMEVALUES.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
51: attribute2 OKC_TIMEVALUES.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
45: description OKC_TIMEVALUES.description%TYPE := OKC_API.G_MISS_CHAR,
46: short_description OKC_TIMEVALUES.short_description%TYPE := OKC_API.G_MISS_CHAR,
47: comments OKC_TIMEVALUES.comments%TYPE := OKC_API.G_MISS_CHAR,
48:
49: attribute_category OKC_TIMEVALUES.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
50: attribute1 OKC_TIMEVALUES.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
51: attribute2 OKC_TIMEVALUES.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
52: attribute3 OKC_TIMEVALUES.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
53: attribute4 OKC_TIMEVALUES.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
46: short_description OKC_TIMEVALUES.short_description%TYPE := OKC_API.G_MISS_CHAR,
47: comments OKC_TIMEVALUES.comments%TYPE := OKC_API.G_MISS_CHAR,
48:
49: attribute_category OKC_TIMEVALUES.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
50: attribute1 OKC_TIMEVALUES.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
51: attribute2 OKC_TIMEVALUES.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
52: attribute3 OKC_TIMEVALUES.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
53: attribute4 OKC_TIMEVALUES.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
54: attribute5 OKC_TIMEVALUES.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
47: comments OKC_TIMEVALUES.comments%TYPE := OKC_API.G_MISS_CHAR,
48:
49: attribute_category OKC_TIMEVALUES.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
50: attribute1 OKC_TIMEVALUES.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
51: attribute2 OKC_TIMEVALUES.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
52: attribute3 OKC_TIMEVALUES.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
53: attribute4 OKC_TIMEVALUES.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
54: attribute5 OKC_TIMEVALUES.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
55: attribute6 OKC_TIMEVALUES.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
48:
49: attribute_category OKC_TIMEVALUES.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
50: attribute1 OKC_TIMEVALUES.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
51: attribute2 OKC_TIMEVALUES.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
52: attribute3 OKC_TIMEVALUES.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
53: attribute4 OKC_TIMEVALUES.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
54: attribute5 OKC_TIMEVALUES.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
55: attribute6 OKC_TIMEVALUES.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
56: attribute7 OKC_TIMEVALUES.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
49: attribute_category OKC_TIMEVALUES.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
50: attribute1 OKC_TIMEVALUES.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
51: attribute2 OKC_TIMEVALUES.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
52: attribute3 OKC_TIMEVALUES.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
53: attribute4 OKC_TIMEVALUES.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
54: attribute5 OKC_TIMEVALUES.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
55: attribute6 OKC_TIMEVALUES.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
56: attribute7 OKC_TIMEVALUES.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
57: attribute8 OKC_TIMEVALUES.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
50: attribute1 OKC_TIMEVALUES.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
51: attribute2 OKC_TIMEVALUES.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
52: attribute3 OKC_TIMEVALUES.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
53: attribute4 OKC_TIMEVALUES.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
54: attribute5 OKC_TIMEVALUES.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
55: attribute6 OKC_TIMEVALUES.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
56: attribute7 OKC_TIMEVALUES.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
57: attribute8 OKC_TIMEVALUES.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
58: attribute9 OKC_TIMEVALUES.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
51: attribute2 OKC_TIMEVALUES.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
52: attribute3 OKC_TIMEVALUES.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
53: attribute4 OKC_TIMEVALUES.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
54: attribute5 OKC_TIMEVALUES.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
55: attribute6 OKC_TIMEVALUES.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
56: attribute7 OKC_TIMEVALUES.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
57: attribute8 OKC_TIMEVALUES.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
58: attribute9 OKC_TIMEVALUES.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
59: attribute10 OKC_TIMEVALUES.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
52: attribute3 OKC_TIMEVALUES.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
53: attribute4 OKC_TIMEVALUES.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
54: attribute5 OKC_TIMEVALUES.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
55: attribute6 OKC_TIMEVALUES.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
56: attribute7 OKC_TIMEVALUES.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
57: attribute8 OKC_TIMEVALUES.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
58: attribute9 OKC_TIMEVALUES.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
59: attribute10 OKC_TIMEVALUES.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
60: attribute11 OKC_TIMEVALUES.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
53: attribute4 OKC_TIMEVALUES.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
54: attribute5 OKC_TIMEVALUES.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
55: attribute6 OKC_TIMEVALUES.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
56: attribute7 OKC_TIMEVALUES.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
57: attribute8 OKC_TIMEVALUES.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
58: attribute9 OKC_TIMEVALUES.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
59: attribute10 OKC_TIMEVALUES.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
60: attribute11 OKC_TIMEVALUES.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
61: attribute12 OKC_TIMEVALUES.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
54: attribute5 OKC_TIMEVALUES.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
55: attribute6 OKC_TIMEVALUES.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
56: attribute7 OKC_TIMEVALUES.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
57: attribute8 OKC_TIMEVALUES.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
58: attribute9 OKC_TIMEVALUES.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
59: attribute10 OKC_TIMEVALUES.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
60: attribute11 OKC_TIMEVALUES.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
61: attribute12 OKC_TIMEVALUES.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
62: attribute13 OKC_TIMEVALUES.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
55: attribute6 OKC_TIMEVALUES.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
56: attribute7 OKC_TIMEVALUES.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
57: attribute8 OKC_TIMEVALUES.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
58: attribute9 OKC_TIMEVALUES.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
59: attribute10 OKC_TIMEVALUES.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
60: attribute11 OKC_TIMEVALUES.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
61: attribute12 OKC_TIMEVALUES.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
62: attribute13 OKC_TIMEVALUES.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
63: attribute14 OKC_TIMEVALUES.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
56: attribute7 OKC_TIMEVALUES.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
57: attribute8 OKC_TIMEVALUES.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
58: attribute9 OKC_TIMEVALUES.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
59: attribute10 OKC_TIMEVALUES.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
60: attribute11 OKC_TIMEVALUES.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
61: attribute12 OKC_TIMEVALUES.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
62: attribute13 OKC_TIMEVALUES.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
63: attribute14 OKC_TIMEVALUES.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
64: attribute15 OKC_TIMEVALUES.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR);
57: attribute8 OKC_TIMEVALUES.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
58: attribute9 OKC_TIMEVALUES.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
59: attribute10 OKC_TIMEVALUES.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
60: attribute11 OKC_TIMEVALUES.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
61: attribute12 OKC_TIMEVALUES.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
62: attribute13 OKC_TIMEVALUES.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
63: attribute14 OKC_TIMEVALUES.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
64: attribute15 OKC_TIMEVALUES.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR);
65: g_miss_tve_rec tve_rec_type;
58: attribute9 OKC_TIMEVALUES.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
59: attribute10 OKC_TIMEVALUES.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
60: attribute11 OKC_TIMEVALUES.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
61: attribute12 OKC_TIMEVALUES.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
62: attribute13 OKC_TIMEVALUES.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
63: attribute14 OKC_TIMEVALUES.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
64: attribute15 OKC_TIMEVALUES.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR);
65: g_miss_tve_rec tve_rec_type;
66: TYPE tve_tbl_type IS TABLE OF tve_rec_type
59: attribute10 OKC_TIMEVALUES.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
60: attribute11 OKC_TIMEVALUES.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
61: attribute12 OKC_TIMEVALUES.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
62: attribute13 OKC_TIMEVALUES.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
63: attribute14 OKC_TIMEVALUES.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
64: attribute15 OKC_TIMEVALUES.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR);
65: g_miss_tve_rec tve_rec_type;
66: TYPE tve_tbl_type IS TABLE OF tve_rec_type
67: INDEX BY BINARY_INTEGER;
60: attribute11 OKC_TIMEVALUES.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
61: attribute12 OKC_TIMEVALUES.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
62: attribute13 OKC_TIMEVALUES.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
63: attribute14 OKC_TIMEVALUES.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
64: attribute15 OKC_TIMEVALUES.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR);
65: g_miss_tve_rec tve_rec_type;
66: TYPE tve_tbl_type IS TABLE OF tve_rec_type
67: INDEX BY BINARY_INTEGER;
68: /*
66: TYPE tve_tbl_type IS TABLE OF tve_rec_type
67: INDEX BY BINARY_INTEGER;
68: /*
69: TYPE okc_timevalues_tl_rec_type IS RECORD (
70: id NUMBER := OKC_API.G_MISS_NUM,
71: language OKC_TIMEVALUES_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
72: source_lang OKC_TIMEVALUES_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
73: sfwt_flag OKC_TIMEVALUES_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
74: description OKC_TIMEVALUES_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
67: INDEX BY BINARY_INTEGER;
68: /*
69: TYPE okc_timevalues_tl_rec_type IS RECORD (
70: id NUMBER := OKC_API.G_MISS_NUM,
71: language OKC_TIMEVALUES_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
72: source_lang OKC_TIMEVALUES_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
73: sfwt_flag OKC_TIMEVALUES_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
74: description OKC_TIMEVALUES_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
75: short_description OKC_TIMEVALUES_TL.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
68: /*
69: TYPE okc_timevalues_tl_rec_type IS RECORD (
70: id NUMBER := OKC_API.G_MISS_NUM,
71: language OKC_TIMEVALUES_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
72: source_lang OKC_TIMEVALUES_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
73: sfwt_flag OKC_TIMEVALUES_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
74: description OKC_TIMEVALUES_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
75: short_description OKC_TIMEVALUES_TL.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
76: comments OKC_TIMEVALUES_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
69: TYPE okc_timevalues_tl_rec_type IS RECORD (
70: id NUMBER := OKC_API.G_MISS_NUM,
71: language OKC_TIMEVALUES_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
72: source_lang OKC_TIMEVALUES_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
73: sfwt_flag OKC_TIMEVALUES_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
74: description OKC_TIMEVALUES_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
75: short_description OKC_TIMEVALUES_TL.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
76: comments OKC_TIMEVALUES_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
77: name OKC_TIMEVALUES_TL.NAME%TYPE := OKC_API.G_MISS_CHAR,
70: id NUMBER := OKC_API.G_MISS_NUM,
71: language OKC_TIMEVALUES_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
72: source_lang OKC_TIMEVALUES_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
73: sfwt_flag OKC_TIMEVALUES_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
74: description OKC_TIMEVALUES_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
75: short_description OKC_TIMEVALUES_TL.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
76: comments OKC_TIMEVALUES_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
77: name OKC_TIMEVALUES_TL.NAME%TYPE := OKC_API.G_MISS_CHAR,
78: created_by NUMBER := OKC_API.G_MISS_NUM,
71: language OKC_TIMEVALUES_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
72: source_lang OKC_TIMEVALUES_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
73: sfwt_flag OKC_TIMEVALUES_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
74: description OKC_TIMEVALUES_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
75: short_description OKC_TIMEVALUES_TL.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
76: comments OKC_TIMEVALUES_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
77: name OKC_TIMEVALUES_TL.NAME%TYPE := OKC_API.G_MISS_CHAR,
78: created_by NUMBER := OKC_API.G_MISS_NUM,
79: creation_date OKC_TIMEVALUES_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
72: source_lang OKC_TIMEVALUES_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
73: sfwt_flag OKC_TIMEVALUES_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
74: description OKC_TIMEVALUES_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
75: short_description OKC_TIMEVALUES_TL.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
76: comments OKC_TIMEVALUES_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
77: name OKC_TIMEVALUES_TL.NAME%TYPE := OKC_API.G_MISS_CHAR,
78: created_by NUMBER := OKC_API.G_MISS_NUM,
79: creation_date OKC_TIMEVALUES_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
80: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
73: sfwt_flag OKC_TIMEVALUES_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
74: description OKC_TIMEVALUES_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
75: short_description OKC_TIMEVALUES_TL.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
76: comments OKC_TIMEVALUES_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
77: name OKC_TIMEVALUES_TL.NAME%TYPE := OKC_API.G_MISS_CHAR,
78: created_by NUMBER := OKC_API.G_MISS_NUM,
79: creation_date OKC_TIMEVALUES_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
80: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
81: last_update_date OKC_TIMEVALUES_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
74: description OKC_TIMEVALUES_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
75: short_description OKC_TIMEVALUES_TL.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
76: comments OKC_TIMEVALUES_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
77: name OKC_TIMEVALUES_TL.NAME%TYPE := OKC_API.G_MISS_CHAR,
78: created_by NUMBER := OKC_API.G_MISS_NUM,
79: creation_date OKC_TIMEVALUES_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
80: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
81: last_update_date OKC_TIMEVALUES_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
82: last_update_login NUMBER := OKC_API.G_MISS_NUM);
75: short_description OKC_TIMEVALUES_TL.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
76: comments OKC_TIMEVALUES_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
77: name OKC_TIMEVALUES_TL.NAME%TYPE := OKC_API.G_MISS_CHAR,
78: created_by NUMBER := OKC_API.G_MISS_NUM,
79: creation_date OKC_TIMEVALUES_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
80: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
81: last_update_date OKC_TIMEVALUES_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
82: last_update_login NUMBER := OKC_API.G_MISS_NUM);
83: g_miss_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
76: comments OKC_TIMEVALUES_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
77: name OKC_TIMEVALUES_TL.NAME%TYPE := OKC_API.G_MISS_CHAR,
78: created_by NUMBER := OKC_API.G_MISS_NUM,
79: creation_date OKC_TIMEVALUES_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
80: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
81: last_update_date OKC_TIMEVALUES_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
82: last_update_login NUMBER := OKC_API.G_MISS_NUM);
83: g_miss_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
84: TYPE okc_timevalues_tl_tbl_type IS TABLE OF okc_timevalues_tl_rec_type
77: name OKC_TIMEVALUES_TL.NAME%TYPE := OKC_API.G_MISS_CHAR,
78: created_by NUMBER := OKC_API.G_MISS_NUM,
79: creation_date OKC_TIMEVALUES_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
80: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
81: last_update_date OKC_TIMEVALUES_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
82: last_update_login NUMBER := OKC_API.G_MISS_NUM);
83: g_miss_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
84: TYPE okc_timevalues_tl_tbl_type IS TABLE OF okc_timevalues_tl_rec_type
85: INDEX BY BINARY_INTEGER;
78: created_by NUMBER := OKC_API.G_MISS_NUM,
79: creation_date OKC_TIMEVALUES_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
80: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
81: last_update_date OKC_TIMEVALUES_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
82: last_update_login NUMBER := OKC_API.G_MISS_NUM);
83: g_miss_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
84: TYPE okc_timevalues_tl_tbl_type IS TABLE OF okc_timevalues_tl_rec_type
85: INDEX BY BINARY_INTEGER;
86: */
84: TYPE okc_timevalues_tl_tbl_type IS TABLE OF okc_timevalues_tl_rec_type
85: INDEX BY BINARY_INTEGER;
86: */
87: TYPE tgdv_rec_type IS RECORD (
88: id NUMBER := OKC_API.G_MISS_NUM,
89: object_version_number NUMBER := OKC_API.G_MISS_NUM,
90: --Bug 3122962
91: sfwt_flag OKC_TIME_TPG_DELIMITED_V.SFWT_FLAG%TYPE := 'N',
92: npt_id NUMBER := OKC_API.G_MISS_NUM,
85: INDEX BY BINARY_INTEGER;
86: */
87: TYPE tgdv_rec_type IS RECORD (
88: id NUMBER := OKC_API.G_MISS_NUM,
89: object_version_number NUMBER := OKC_API.G_MISS_NUM,
90: --Bug 3122962
91: sfwt_flag OKC_TIME_TPG_DELIMITED_V.SFWT_FLAG%TYPE := 'N',
92: npt_id NUMBER := OKC_API.G_MISS_NUM,
93: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
88: id NUMBER := OKC_API.G_MISS_NUM,
89: object_version_number NUMBER := OKC_API.G_MISS_NUM,
90: --Bug 3122962
91: sfwt_flag OKC_TIME_TPG_DELIMITED_V.SFWT_FLAG%TYPE := 'N',
92: npt_id NUMBER := OKC_API.G_MISS_NUM,
93: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
94: tze_id NUMBER := OKC_API.G_MISS_NUM,
95: tve_id_limited NUMBER := OKC_API.G_MISS_NUM,
96: description OKC_TIME_TPG_DELIMITED_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
89: object_version_number NUMBER := OKC_API.G_MISS_NUM,
90: --Bug 3122962
91: sfwt_flag OKC_TIME_TPG_DELIMITED_V.SFWT_FLAG%TYPE := 'N',
92: npt_id NUMBER := OKC_API.G_MISS_NUM,
93: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
94: tze_id NUMBER := OKC_API.G_MISS_NUM,
95: tve_id_limited NUMBER := OKC_API.G_MISS_NUM,
96: description OKC_TIME_TPG_DELIMITED_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
97: short_description OKC_TIME_TPG_DELIMITED_V.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
90: --Bug 3122962
91: sfwt_flag OKC_TIME_TPG_DELIMITED_V.SFWT_FLAG%TYPE := 'N',
92: npt_id NUMBER := OKC_API.G_MISS_NUM,
93: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
94: tze_id NUMBER := OKC_API.G_MISS_NUM,
95: tve_id_limited NUMBER := OKC_API.G_MISS_NUM,
96: description OKC_TIME_TPG_DELIMITED_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
97: short_description OKC_TIME_TPG_DELIMITED_V.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
98: comments OKC_TIME_TPG_DELIMITED_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
91: sfwt_flag OKC_TIME_TPG_DELIMITED_V.SFWT_FLAG%TYPE := 'N',
92: npt_id NUMBER := OKC_API.G_MISS_NUM,
93: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
94: tze_id NUMBER := OKC_API.G_MISS_NUM,
95: tve_id_limited NUMBER := OKC_API.G_MISS_NUM,
96: description OKC_TIME_TPG_DELIMITED_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
97: short_description OKC_TIME_TPG_DELIMITED_V.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
98: comments OKC_TIME_TPG_DELIMITED_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
99: month NUMBER := OKC_API.G_MISS_NUM,
92: npt_id NUMBER := OKC_API.G_MISS_NUM,
93: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
94: tze_id NUMBER := OKC_API.G_MISS_NUM,
95: tve_id_limited NUMBER := OKC_API.G_MISS_NUM,
96: description OKC_TIME_TPG_DELIMITED_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
97: short_description OKC_TIME_TPG_DELIMITED_V.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
98: comments OKC_TIME_TPG_DELIMITED_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
99: month NUMBER := OKC_API.G_MISS_NUM,
100: day NUMBER := OKC_API.G_MISS_NUM,
93: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
94: tze_id NUMBER := OKC_API.G_MISS_NUM,
95: tve_id_limited NUMBER := OKC_API.G_MISS_NUM,
96: description OKC_TIME_TPG_DELIMITED_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
97: short_description OKC_TIME_TPG_DELIMITED_V.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
98: comments OKC_TIME_TPG_DELIMITED_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
99: month NUMBER := OKC_API.G_MISS_NUM,
100: day NUMBER := OKC_API.G_MISS_NUM,
101: day_of_week OKC_TIME_TPG_DELIMITED_V.DAY_OF_WEEK%TYPE := OKC_API.G_MISS_CHAR,
94: tze_id NUMBER := OKC_API.G_MISS_NUM,
95: tve_id_limited NUMBER := OKC_API.G_MISS_NUM,
96: description OKC_TIME_TPG_DELIMITED_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
97: short_description OKC_TIME_TPG_DELIMITED_V.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
98: comments OKC_TIME_TPG_DELIMITED_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
99: month NUMBER := OKC_API.G_MISS_NUM,
100: day NUMBER := OKC_API.G_MISS_NUM,
101: day_of_week OKC_TIME_TPG_DELIMITED_V.DAY_OF_WEEK%TYPE := OKC_API.G_MISS_CHAR,
102: hour NUMBER := OKC_API.G_MISS_NUM,
95: tve_id_limited NUMBER := OKC_API.G_MISS_NUM,
96: description OKC_TIME_TPG_DELIMITED_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
97: short_description OKC_TIME_TPG_DELIMITED_V.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
98: comments OKC_TIME_TPG_DELIMITED_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
99: month NUMBER := OKC_API.G_MISS_NUM,
100: day NUMBER := OKC_API.G_MISS_NUM,
101: day_of_week OKC_TIME_TPG_DELIMITED_V.DAY_OF_WEEK%TYPE := OKC_API.G_MISS_CHAR,
102: hour NUMBER := OKC_API.G_MISS_NUM,
103: minute NUMBER := OKC_API.G_MISS_NUM,
96: description OKC_TIME_TPG_DELIMITED_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
97: short_description OKC_TIME_TPG_DELIMITED_V.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
98: comments OKC_TIME_TPG_DELIMITED_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
99: month NUMBER := OKC_API.G_MISS_NUM,
100: day NUMBER := OKC_API.G_MISS_NUM,
101: day_of_week OKC_TIME_TPG_DELIMITED_V.DAY_OF_WEEK%TYPE := OKC_API.G_MISS_CHAR,
102: hour NUMBER := OKC_API.G_MISS_NUM,
103: minute NUMBER := OKC_API.G_MISS_NUM,
104: second NUMBER := OKC_API.G_MISS_NUM,
97: short_description OKC_TIME_TPG_DELIMITED_V.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
98: comments OKC_TIME_TPG_DELIMITED_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
99: month NUMBER := OKC_API.G_MISS_NUM,
100: day NUMBER := OKC_API.G_MISS_NUM,
101: day_of_week OKC_TIME_TPG_DELIMITED_V.DAY_OF_WEEK%TYPE := OKC_API.G_MISS_CHAR,
102: hour NUMBER := OKC_API.G_MISS_NUM,
103: minute NUMBER := OKC_API.G_MISS_NUM,
104: second NUMBER := OKC_API.G_MISS_NUM,
105: nth NUMBER := OKC_API.G_MISS_NUM,
98: comments OKC_TIME_TPG_DELIMITED_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
99: month NUMBER := OKC_API.G_MISS_NUM,
100: day NUMBER := OKC_API.G_MISS_NUM,
101: day_of_week OKC_TIME_TPG_DELIMITED_V.DAY_OF_WEEK%TYPE := OKC_API.G_MISS_CHAR,
102: hour NUMBER := OKC_API.G_MISS_NUM,
103: minute NUMBER := OKC_API.G_MISS_NUM,
104: second NUMBER := OKC_API.G_MISS_NUM,
105: nth NUMBER := OKC_API.G_MISS_NUM,
106: attribute_category OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
99: month NUMBER := OKC_API.G_MISS_NUM,
100: day NUMBER := OKC_API.G_MISS_NUM,
101: day_of_week OKC_TIME_TPG_DELIMITED_V.DAY_OF_WEEK%TYPE := OKC_API.G_MISS_CHAR,
102: hour NUMBER := OKC_API.G_MISS_NUM,
103: minute NUMBER := OKC_API.G_MISS_NUM,
104: second NUMBER := OKC_API.G_MISS_NUM,
105: nth NUMBER := OKC_API.G_MISS_NUM,
106: attribute_category OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
107: attribute1 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
100: day NUMBER := OKC_API.G_MISS_NUM,
101: day_of_week OKC_TIME_TPG_DELIMITED_V.DAY_OF_WEEK%TYPE := OKC_API.G_MISS_CHAR,
102: hour NUMBER := OKC_API.G_MISS_NUM,
103: minute NUMBER := OKC_API.G_MISS_NUM,
104: second NUMBER := OKC_API.G_MISS_NUM,
105: nth NUMBER := OKC_API.G_MISS_NUM,
106: attribute_category OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
107: attribute1 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
108: attribute2 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
101: day_of_week OKC_TIME_TPG_DELIMITED_V.DAY_OF_WEEK%TYPE := OKC_API.G_MISS_CHAR,
102: hour NUMBER := OKC_API.G_MISS_NUM,
103: minute NUMBER := OKC_API.G_MISS_NUM,
104: second NUMBER := OKC_API.G_MISS_NUM,
105: nth NUMBER := OKC_API.G_MISS_NUM,
106: attribute_category OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
107: attribute1 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
108: attribute2 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
109: attribute3 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
102: hour NUMBER := OKC_API.G_MISS_NUM,
103: minute NUMBER := OKC_API.G_MISS_NUM,
104: second NUMBER := OKC_API.G_MISS_NUM,
105: nth NUMBER := OKC_API.G_MISS_NUM,
106: attribute_category OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
107: attribute1 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
108: attribute2 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
109: attribute3 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
110: attribute4 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
103: minute NUMBER := OKC_API.G_MISS_NUM,
104: second NUMBER := OKC_API.G_MISS_NUM,
105: nth NUMBER := OKC_API.G_MISS_NUM,
106: attribute_category OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
107: attribute1 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
108: attribute2 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
109: attribute3 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
110: attribute4 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
111: attribute5 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
104: second NUMBER := OKC_API.G_MISS_NUM,
105: nth NUMBER := OKC_API.G_MISS_NUM,
106: attribute_category OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
107: attribute1 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
108: attribute2 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
109: attribute3 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
110: attribute4 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
111: attribute5 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
112: attribute6 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
105: nth NUMBER := OKC_API.G_MISS_NUM,
106: attribute_category OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
107: attribute1 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
108: attribute2 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
109: attribute3 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
110: attribute4 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
111: attribute5 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
112: attribute6 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
113: attribute7 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
106: attribute_category OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
107: attribute1 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
108: attribute2 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
109: attribute3 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
110: attribute4 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
111: attribute5 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
112: attribute6 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
113: attribute7 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
114: attribute8 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
107: attribute1 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
108: attribute2 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
109: attribute3 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
110: attribute4 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
111: attribute5 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
112: attribute6 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
113: attribute7 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
114: attribute8 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
115: attribute9 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
108: attribute2 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
109: attribute3 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
110: attribute4 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
111: attribute5 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
112: attribute6 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
113: attribute7 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
114: attribute8 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
115: attribute9 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
116: attribute10 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
109: attribute3 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
110: attribute4 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
111: attribute5 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
112: attribute6 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
113: attribute7 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
114: attribute8 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
115: attribute9 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
116: attribute10 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
117: attribute11 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
110: attribute4 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
111: attribute5 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
112: attribute6 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
113: attribute7 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
114: attribute8 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
115: attribute9 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
116: attribute10 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
117: attribute11 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
118: attribute12 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
111: attribute5 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
112: attribute6 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
113: attribute7 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
114: attribute8 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
115: attribute9 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
116: attribute10 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
117: attribute11 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
118: attribute12 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
119: attribute13 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
112: attribute6 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
113: attribute7 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
114: attribute8 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
115: attribute9 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
116: attribute10 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
117: attribute11 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
118: attribute12 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
119: attribute13 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
120: attribute14 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
113: attribute7 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
114: attribute8 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
115: attribute9 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
116: attribute10 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
117: attribute11 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
118: attribute12 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
119: attribute13 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
120: attribute14 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
121: attribute15 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
114: attribute8 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
115: attribute9 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
116: attribute10 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
117: attribute11 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
118: attribute12 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
119: attribute13 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
120: attribute14 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
121: attribute15 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
122: created_by NUMBER := OKC_API.G_MISS_NUM,
115: attribute9 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
116: attribute10 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
117: attribute11 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
118: attribute12 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
119: attribute13 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
120: attribute14 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
121: attribute15 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
122: created_by NUMBER := OKC_API.G_MISS_NUM,
123: creation_date OKC_TIME_TPG_DELIMITED_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
116: attribute10 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
117: attribute11 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
118: attribute12 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
119: attribute13 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
120: attribute14 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
121: attribute15 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
122: created_by NUMBER := OKC_API.G_MISS_NUM,
123: creation_date OKC_TIME_TPG_DELIMITED_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
124: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
117: attribute11 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
118: attribute12 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
119: attribute13 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
120: attribute14 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
121: attribute15 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
122: created_by NUMBER := OKC_API.G_MISS_NUM,
123: creation_date OKC_TIME_TPG_DELIMITED_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
124: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
125: last_update_date OKC_TIME_TPG_DELIMITED_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
118: attribute12 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
119: attribute13 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
120: attribute14 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
121: attribute15 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
122: created_by NUMBER := OKC_API.G_MISS_NUM,
123: creation_date OKC_TIME_TPG_DELIMITED_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
124: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
125: last_update_date OKC_TIME_TPG_DELIMITED_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
126: last_update_login NUMBER := OKC_API.G_MISS_NUM);
119: attribute13 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
120: attribute14 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
121: attribute15 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
122: created_by NUMBER := OKC_API.G_MISS_NUM,
123: creation_date OKC_TIME_TPG_DELIMITED_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
124: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
125: last_update_date OKC_TIME_TPG_DELIMITED_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
126: last_update_login NUMBER := OKC_API.G_MISS_NUM);
127: g_miss_tgdv_rec tgdv_rec_type;
120: attribute14 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
121: attribute15 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
122: created_by NUMBER := OKC_API.G_MISS_NUM,
123: creation_date OKC_TIME_TPG_DELIMITED_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
124: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
125: last_update_date OKC_TIME_TPG_DELIMITED_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
126: last_update_login NUMBER := OKC_API.G_MISS_NUM);
127: g_miss_tgdv_rec tgdv_rec_type;
128: TYPE tgdv_tbl_type IS TABLE OF tgdv_rec_type
121: attribute15 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
122: created_by NUMBER := OKC_API.G_MISS_NUM,
123: creation_date OKC_TIME_TPG_DELIMITED_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
124: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
125: last_update_date OKC_TIME_TPG_DELIMITED_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
126: last_update_login NUMBER := OKC_API.G_MISS_NUM);
127: g_miss_tgdv_rec tgdv_rec_type;
128: TYPE tgdv_tbl_type IS TABLE OF tgdv_rec_type
129: INDEX BY BINARY_INTEGER;
122: created_by NUMBER := OKC_API.G_MISS_NUM,
123: creation_date OKC_TIME_TPG_DELIMITED_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
124: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
125: last_update_date OKC_TIME_TPG_DELIMITED_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
126: last_update_login NUMBER := OKC_API.G_MISS_NUM);
127: g_miss_tgdv_rec tgdv_rec_type;
128: TYPE tgdv_tbl_type IS TABLE OF tgdv_rec_type
129: INDEX BY BINARY_INTEGER;
130: ---------------------------------------------------------------------------
129: INDEX BY BINARY_INTEGER;
130: ---------------------------------------------------------------------------
131: -- GLOBAL MESSAGE CONSTANTS
132: ---------------------------------------------------------------------------
133: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
134: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
135: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
136: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
137: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
130: ---------------------------------------------------------------------------
131: -- GLOBAL MESSAGE CONSTANTS
132: ---------------------------------------------------------------------------
133: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
134: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
135: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
136: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
137: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
138: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
131: -- GLOBAL MESSAGE CONSTANTS
132: ---------------------------------------------------------------------------
133: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
134: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
135: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
136: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
137: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
138: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
139: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
132: ---------------------------------------------------------------------------
133: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
134: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
135: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
136: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
137: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
138: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
139: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
140: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
133: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
134: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
135: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
136: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
137: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
138: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
139: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
140: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
141: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
134: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
135: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
136: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
137: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
138: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
139: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
140: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
141: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
142: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
135: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
136: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
137: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
138: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
139: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
140: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
141: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
142: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
143: ---------------------------------------------------------------------------
136: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
137: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
138: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
139: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
140: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
141: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
142: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
143: ---------------------------------------------------------------------------
144: -- GLOBAL VARIABLES
137: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
138: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
139: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
140: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
141: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
142: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
143: ---------------------------------------------------------------------------
144: -- GLOBAL VARIABLES
145: ---------------------------------------------------------------------------
138: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
139: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
140: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
141: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
142: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
143: ---------------------------------------------------------------------------
144: -- GLOBAL VARIABLES
145: ---------------------------------------------------------------------------
146: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_TGD_PVT';
143: ---------------------------------------------------------------------------
144: -- GLOBAL VARIABLES
145: ---------------------------------------------------------------------------
146: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_TGD_PVT';
147: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
148: ---------------------------------------------------------------------------
149: -- Procedures and Functions
150: ---------------------------------------------------------------------------
151:
153: PROCEDURE change_version;
154: PROCEDURE api_copy;
155: PROCEDURE insert_row(
156: p_api_version IN NUMBER,
157: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
158: x_return_status OUT NOCOPY VARCHAR2,
159: x_msg_count OUT NOCOPY NUMBER,
160: x_msg_data OUT NOCOPY VARCHAR2,
161: p_tgdv_rec IN tgdv_rec_type,
162: x_tgdv_rec OUT NOCOPY tgdv_rec_type);
163:
164: PROCEDURE insert_row(
165: p_api_version IN NUMBER,
166: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
167: x_return_status OUT NOCOPY VARCHAR2,
168: x_msg_count OUT NOCOPY NUMBER,
169: x_msg_data OUT NOCOPY VARCHAR2,
170: p_tgdv_tbl IN tgdv_tbl_type,
171: x_tgdv_tbl OUT NOCOPY tgdv_tbl_type);
172:
173: PROCEDURE lock_row(
174: p_api_version IN NUMBER,
175: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
176: x_return_status OUT NOCOPY VARCHAR2,
177: x_msg_count OUT NOCOPY NUMBER,
178: x_msg_data OUT NOCOPY VARCHAR2,
179: p_tgdv_rec IN tgdv_rec_type);
179: p_tgdv_rec IN tgdv_rec_type);
180:
181: PROCEDURE lock_row(
182: p_api_version IN NUMBER,
183: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
184: x_return_status OUT NOCOPY VARCHAR2,
185: x_msg_count OUT NOCOPY NUMBER,
186: x_msg_data OUT NOCOPY VARCHAR2,
187: p_tgdv_tbl IN tgdv_tbl_type);
187: p_tgdv_tbl IN tgdv_tbl_type);
188:
189: PROCEDURE update_row(
190: p_api_version IN NUMBER,
191: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
192: x_return_status OUT NOCOPY VARCHAR2,
193: x_msg_count OUT NOCOPY NUMBER,
194: x_msg_data OUT NOCOPY VARCHAR2,
195: p_tgdv_rec IN tgdv_rec_type,
196: x_tgdv_rec OUT NOCOPY tgdv_rec_type);
197:
198: PROCEDURE update_row(
199: p_api_version IN NUMBER,
200: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
201: x_return_status OUT NOCOPY VARCHAR2,
202: x_msg_count OUT NOCOPY NUMBER,
203: x_msg_data OUT NOCOPY VARCHAR2,
204: p_tgdv_tbl IN tgdv_tbl_type,
205: x_tgdv_tbl OUT NOCOPY tgdv_tbl_type);
206:
207: PROCEDURE delete_row(
208: p_api_version IN NUMBER,
209: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
210: x_return_status OUT NOCOPY VARCHAR2,
211: x_msg_count OUT NOCOPY NUMBER,
212: x_msg_data OUT NOCOPY VARCHAR2,
213: p_tgdv_rec IN tgdv_rec_type);
213: p_tgdv_rec IN tgdv_rec_type);
214:
215: PROCEDURE delete_row(
216: p_api_version IN NUMBER,
217: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
218: x_return_status OUT NOCOPY VARCHAR2,
219: x_msg_count OUT NOCOPY NUMBER,
220: x_msg_data OUT NOCOPY VARCHAR2,
221: p_tgdv_tbl IN tgdv_tbl_type);
221: p_tgdv_tbl IN tgdv_tbl_type);
222:
223: PROCEDURE validate_row(
224: p_api_version IN NUMBER,
225: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
226: x_return_status OUT NOCOPY VARCHAR2,
227: x_msg_count OUT NOCOPY NUMBER,
228: x_msg_data OUT NOCOPY VARCHAR2,
229: p_tgdv_rec IN tgdv_rec_type);
229: p_tgdv_rec IN tgdv_rec_type);
230:
231: PROCEDURE validate_row(
232: p_api_version IN NUMBER,
233: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
234: x_return_status OUT NOCOPY VARCHAR2,
235: x_msg_count OUT NOCOPY NUMBER,
236: x_msg_data OUT NOCOPY VARCHAR2,
237: p_tgdv_tbl IN tgdv_tbl_type);