eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKC_TAV_PVT dependencies on OKC_API

Line 10: G_RETURN_STATUS VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

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,

Line 13: 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,

Line 14: spn_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,

Line 15: tve_id_offset 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: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,

Line 16: uom_code OKC_TIMEVALUES.uom_code%TYPE := OKC_API.G_MISS_CHAR,

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: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
20: tze_id NUMBER := OKC_API.G_MISS_NUM,

Line 17: cnh_id 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: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
20: tze_id NUMBER := OKC_API.G_MISS_NUM,
21: tve_id_limited NUMBER := OKC_API.G_MISS_NUM,

Line 18: 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: tve_id_generated_by NUMBER := OKC_API.G_MISS_NUM,
19: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
20: tze_id NUMBER := OKC_API.G_MISS_NUM,
21: tve_id_limited NUMBER := OKC_API.G_MISS_NUM,
22: tve_id_started NUMBER := OKC_API.G_MISS_NUM,

Line 19: 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: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
20: tze_id NUMBER := OKC_API.G_MISS_NUM,
21: tve_id_limited 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,

Line 20: 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: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
20: tze_id NUMBER := OKC_API.G_MISS_NUM,
21: tve_id_limited 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,

Line 21: tve_id_limited NUMBER := OKC_API.G_MISS_NUM,

17: cnh_id NUMBER := OKC_API.G_MISS_NUM,
18: tve_id_generated_by NUMBER := OKC_API.G_MISS_NUM,
19: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
20: tze_id NUMBER := OKC_API.G_MISS_NUM,
21: tve_id_limited 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,

Line 22: tve_id_started NUMBER := OKC_API.G_MISS_NUM,

18: tve_id_generated_by NUMBER := OKC_API.G_MISS_NUM,
19: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
20: tze_id NUMBER := OKC_API.G_MISS_NUM,
21: tve_id_limited 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,

Line 23: tve_id_ended NUMBER := OKC_API.G_MISS_NUM,

19: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
20: tze_id NUMBER := OKC_API.G_MISS_NUM,
21: tve_id_limited 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,

Line 24: tve_type OKC_TIMEVALUES.TVE_TYPE%TYPE := OKC_API.G_MISS_CHAR,

20: tze_id NUMBER := OKC_API.G_MISS_NUM,
21: tve_id_limited 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,

Line 25: object_version_number NUMBER := OKC_API.G_MISS_NUM,

21: tve_id_limited 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,

Line 26: created_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,
30: duration NUMBER := OKC_API.G_MISS_NUM,

Line 27: creation_date OKC_TIMEVALUES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,

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,

Line 28: last_updated_by 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,
32: before_after OKC_TIMEVALUES.BEFORE_AFTER%TYPE := OKC_API.G_MISS_CHAR,

Line 29: last_update_date OKC_TIMEVALUES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,

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,

Line 30: duration 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,
34: month NUMBER := OKC_API.G_MISS_NUM,

Line 31: operator OKC_TIMEVALUES.OPERATOR%TYPE := OKC_API.G_MISS_CHAR,

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,

Line 32: before_after OKC_TIMEVALUES.BEFORE_AFTER%TYPE := OKC_API.G_MISS_CHAR,

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,

Line 33: datetime OKC_TIMEVALUES.DATETIME%TYPE := OKC_API.G_MISS_DATE,

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,

Line 34: month 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,

Line 35: day 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: interval_yn OKC_TIMEVALUES.INTERVAL_YN%TYPE := OKC_API.G_MISS_CHAR,

Line 36: hour 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: interval_yn OKC_TIMEVALUES.INTERVAL_YN%TYPE := OKC_API.G_MISS_CHAR,
40: nth NUMBER := OKC_API.G_MISS_NUM,

Line 37: minute NUMBER := OKC_API.G_MISS_NUM,

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: interval_yn OKC_TIMEVALUES.INTERVAL_YN%TYPE := OKC_API.G_MISS_CHAR,
40: nth NUMBER := OKC_API.G_MISS_NUM,
41: day_of_week OKC_TIMEVALUES.DAY_OF_WEEK%TYPE := OKC_API.G_MISS_CHAR,

Line 38: second NUMBER := OKC_API.G_MISS_NUM,

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: interval_yn OKC_TIMEVALUES.INTERVAL_YN%TYPE := OKC_API.G_MISS_CHAR,
40: nth NUMBER := OKC_API.G_MISS_NUM,
41: day_of_week OKC_TIMEVALUES.DAY_OF_WEEK%TYPE := OKC_API.G_MISS_CHAR,
42: last_update_login NUMBER := OKC_API.G_MISS_NUM,

Line 39: interval_yn OKC_TIMEVALUES.INTERVAL_YN%TYPE := OKC_API.G_MISS_CHAR,

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: interval_yn OKC_TIMEVALUES.INTERVAL_YN%TYPE := OKC_API.G_MISS_CHAR,
40: nth NUMBER := OKC_API.G_MISS_NUM,
41: day_of_week OKC_TIMEVALUES.DAY_OF_WEEK%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,

Line 40: nth 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: interval_yn OKC_TIMEVALUES.INTERVAL_YN%TYPE := OKC_API.G_MISS_CHAR,
40: nth NUMBER := OKC_API.G_MISS_NUM,
41: day_of_week OKC_TIMEVALUES.DAY_OF_WEEK%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: --Bug 3122962

Line 41: day_of_week OKC_TIMEVALUES.DAY_OF_WEEK%TYPE := OKC_API.G_MISS_CHAR,

37: minute NUMBER := OKC_API.G_MISS_NUM,
38: second NUMBER := OKC_API.G_MISS_NUM,
39: interval_yn OKC_TIMEVALUES.INTERVAL_YN%TYPE := OKC_API.G_MISS_CHAR,
40: nth NUMBER := OKC_API.G_MISS_NUM,
41: day_of_week OKC_TIMEVALUES.DAY_OF_WEEK%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: --Bug 3122962
45: name OKC_TIMEVALUES.name%TYPE := OKC_API.G_MISS_CHAR,

Line 42: last_update_login NUMBER := OKC_API.G_MISS_NUM,

38: second NUMBER := OKC_API.G_MISS_NUM,
39: interval_yn OKC_TIMEVALUES.INTERVAL_YN%TYPE := OKC_API.G_MISS_CHAR,
40: nth NUMBER := OKC_API.G_MISS_NUM,
41: day_of_week OKC_TIMEVALUES.DAY_OF_WEEK%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: --Bug 3122962
45: name OKC_TIMEVALUES.name%TYPE := OKC_API.G_MISS_CHAR,
46: description OKC_TIMEVALUES.description%TYPE := OKC_API.G_MISS_CHAR,

Line 43: attribute_category OKC_TIMEVALUES.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,

39: interval_yn OKC_TIMEVALUES.INTERVAL_YN%TYPE := OKC_API.G_MISS_CHAR,
40: nth NUMBER := OKC_API.G_MISS_NUM,
41: day_of_week OKC_TIMEVALUES.DAY_OF_WEEK%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: --Bug 3122962
45: name OKC_TIMEVALUES.name%TYPE := OKC_API.G_MISS_CHAR,
46: description OKC_TIMEVALUES.description%TYPE := OKC_API.G_MISS_CHAR,
47: short_description OKC_TIMEVALUES.short_description%TYPE := OKC_API.G_MISS_CHAR,

Line 45: name OKC_TIMEVALUES.name%TYPE := OKC_API.G_MISS_CHAR,

41: day_of_week OKC_TIMEVALUES.DAY_OF_WEEK%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: --Bug 3122962
45: name OKC_TIMEVALUES.name%TYPE := OKC_API.G_MISS_CHAR,
46: description OKC_TIMEVALUES.description%TYPE := OKC_API.G_MISS_CHAR,
47: short_description OKC_TIMEVALUES.short_description%TYPE := OKC_API.G_MISS_CHAR,
48: comments OKC_TIMEVALUES.comments%TYPE := OKC_API.G_MISS_CHAR,
49: attribute1 OKC_TIMEVALUES.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,

Line 46: description OKC_TIMEVALUES.description%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: --Bug 3122962
45: name OKC_TIMEVALUES.name%TYPE := OKC_API.G_MISS_CHAR,
46: description OKC_TIMEVALUES.description%TYPE := OKC_API.G_MISS_CHAR,
47: short_description OKC_TIMEVALUES.short_description%TYPE := OKC_API.G_MISS_CHAR,
48: comments OKC_TIMEVALUES.comments%TYPE := OKC_API.G_MISS_CHAR,
49: attribute1 OKC_TIMEVALUES.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
50: attribute2 OKC_TIMEVALUES.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,

Line 47: short_description OKC_TIMEVALUES.short_description%TYPE := OKC_API.G_MISS_CHAR,

43: attribute_category OKC_TIMEVALUES.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
44: --Bug 3122962
45: name OKC_TIMEVALUES.name%TYPE := OKC_API.G_MISS_CHAR,
46: description OKC_TIMEVALUES.description%TYPE := OKC_API.G_MISS_CHAR,
47: short_description OKC_TIMEVALUES.short_description%TYPE := OKC_API.G_MISS_CHAR,
48: comments OKC_TIMEVALUES.comments%TYPE := OKC_API.G_MISS_CHAR,
49: attribute1 OKC_TIMEVALUES.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
50: attribute2 OKC_TIMEVALUES.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
51: attribute3 OKC_TIMEVALUES.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,

Line 48: comments OKC_TIMEVALUES.comments%TYPE := OKC_API.G_MISS_CHAR,

44: --Bug 3122962
45: name OKC_TIMEVALUES.name%TYPE := OKC_API.G_MISS_CHAR,
46: description OKC_TIMEVALUES.description%TYPE := OKC_API.G_MISS_CHAR,
47: short_description OKC_TIMEVALUES.short_description%TYPE := OKC_API.G_MISS_CHAR,
48: comments OKC_TIMEVALUES.comments%TYPE := OKC_API.G_MISS_CHAR,
49: attribute1 OKC_TIMEVALUES.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
50: attribute2 OKC_TIMEVALUES.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
51: attribute3 OKC_TIMEVALUES.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
52: attribute4 OKC_TIMEVALUES.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,

Line 49: attribute1 OKC_TIMEVALUES.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,

45: name OKC_TIMEVALUES.name%TYPE := OKC_API.G_MISS_CHAR,
46: description OKC_TIMEVALUES.description%TYPE := OKC_API.G_MISS_CHAR,
47: short_description OKC_TIMEVALUES.short_description%TYPE := OKC_API.G_MISS_CHAR,
48: comments OKC_TIMEVALUES.comments%TYPE := OKC_API.G_MISS_CHAR,
49: attribute1 OKC_TIMEVALUES.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
50: attribute2 OKC_TIMEVALUES.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
51: attribute3 OKC_TIMEVALUES.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
52: attribute4 OKC_TIMEVALUES.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
53: attribute5 OKC_TIMEVALUES.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,

Line 50: attribute2 OKC_TIMEVALUES.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,

46: description OKC_TIMEVALUES.description%TYPE := OKC_API.G_MISS_CHAR,
47: short_description OKC_TIMEVALUES.short_description%TYPE := OKC_API.G_MISS_CHAR,
48: comments OKC_TIMEVALUES.comments%TYPE := OKC_API.G_MISS_CHAR,
49: attribute1 OKC_TIMEVALUES.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
50: attribute2 OKC_TIMEVALUES.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
51: attribute3 OKC_TIMEVALUES.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
52: attribute4 OKC_TIMEVALUES.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
53: attribute5 OKC_TIMEVALUES.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
54: attribute6 OKC_TIMEVALUES.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,

Line 51: attribute3 OKC_TIMEVALUES.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,

47: short_description OKC_TIMEVALUES.short_description%TYPE := OKC_API.G_MISS_CHAR,
48: comments OKC_TIMEVALUES.comments%TYPE := OKC_API.G_MISS_CHAR,
49: attribute1 OKC_TIMEVALUES.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
50: attribute2 OKC_TIMEVALUES.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
51: attribute3 OKC_TIMEVALUES.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
52: attribute4 OKC_TIMEVALUES.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
53: attribute5 OKC_TIMEVALUES.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
54: attribute6 OKC_TIMEVALUES.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
55: attribute7 OKC_TIMEVALUES.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,

Line 52: attribute4 OKC_TIMEVALUES.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,

48: comments OKC_TIMEVALUES.comments%TYPE := OKC_API.G_MISS_CHAR,
49: attribute1 OKC_TIMEVALUES.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
50: attribute2 OKC_TIMEVALUES.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
51: attribute3 OKC_TIMEVALUES.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
52: attribute4 OKC_TIMEVALUES.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
53: attribute5 OKC_TIMEVALUES.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
54: attribute6 OKC_TIMEVALUES.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
55: attribute7 OKC_TIMEVALUES.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
56: attribute8 OKC_TIMEVALUES.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,

Line 53: attribute5 OKC_TIMEVALUES.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,

49: attribute1 OKC_TIMEVALUES.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
50: attribute2 OKC_TIMEVALUES.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
51: attribute3 OKC_TIMEVALUES.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
52: attribute4 OKC_TIMEVALUES.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
53: attribute5 OKC_TIMEVALUES.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
54: attribute6 OKC_TIMEVALUES.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
55: attribute7 OKC_TIMEVALUES.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
56: attribute8 OKC_TIMEVALUES.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
57: attribute9 OKC_TIMEVALUES.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,

Line 54: attribute6 OKC_TIMEVALUES.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,

50: attribute2 OKC_TIMEVALUES.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
51: attribute3 OKC_TIMEVALUES.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
52: attribute4 OKC_TIMEVALUES.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
53: attribute5 OKC_TIMEVALUES.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
54: attribute6 OKC_TIMEVALUES.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
55: attribute7 OKC_TIMEVALUES.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
56: attribute8 OKC_TIMEVALUES.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
57: attribute9 OKC_TIMEVALUES.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
58: attribute10 OKC_TIMEVALUES.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,

Line 55: attribute7 OKC_TIMEVALUES.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,

51: attribute3 OKC_TIMEVALUES.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
52: attribute4 OKC_TIMEVALUES.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
53: attribute5 OKC_TIMEVALUES.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
54: attribute6 OKC_TIMEVALUES.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
55: attribute7 OKC_TIMEVALUES.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
56: attribute8 OKC_TIMEVALUES.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
57: attribute9 OKC_TIMEVALUES.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
58: attribute10 OKC_TIMEVALUES.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
59: attribute11 OKC_TIMEVALUES.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,

Line 56: attribute8 OKC_TIMEVALUES.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,

52: attribute4 OKC_TIMEVALUES.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
53: attribute5 OKC_TIMEVALUES.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
54: attribute6 OKC_TIMEVALUES.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
55: attribute7 OKC_TIMEVALUES.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
56: attribute8 OKC_TIMEVALUES.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
57: attribute9 OKC_TIMEVALUES.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
58: attribute10 OKC_TIMEVALUES.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
59: attribute11 OKC_TIMEVALUES.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
60: attribute12 OKC_TIMEVALUES.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,

Line 57: attribute9 OKC_TIMEVALUES.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,

53: attribute5 OKC_TIMEVALUES.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
54: attribute6 OKC_TIMEVALUES.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
55: attribute7 OKC_TIMEVALUES.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
56: attribute8 OKC_TIMEVALUES.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
57: attribute9 OKC_TIMEVALUES.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
58: attribute10 OKC_TIMEVALUES.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
59: attribute11 OKC_TIMEVALUES.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
60: attribute12 OKC_TIMEVALUES.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
61: attribute13 OKC_TIMEVALUES.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,

Line 58: attribute10 OKC_TIMEVALUES.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,

54: attribute6 OKC_TIMEVALUES.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
55: attribute7 OKC_TIMEVALUES.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
56: attribute8 OKC_TIMEVALUES.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
57: attribute9 OKC_TIMEVALUES.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
58: attribute10 OKC_TIMEVALUES.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
59: attribute11 OKC_TIMEVALUES.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
60: attribute12 OKC_TIMEVALUES.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
61: attribute13 OKC_TIMEVALUES.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
62: attribute14 OKC_TIMEVALUES.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,

Line 59: attribute11 OKC_TIMEVALUES.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,

55: attribute7 OKC_TIMEVALUES.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
56: attribute8 OKC_TIMEVALUES.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
57: attribute9 OKC_TIMEVALUES.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
58: attribute10 OKC_TIMEVALUES.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
59: attribute11 OKC_TIMEVALUES.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
60: attribute12 OKC_TIMEVALUES.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
61: attribute13 OKC_TIMEVALUES.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
62: attribute14 OKC_TIMEVALUES.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
63: attribute15 OKC_TIMEVALUES.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR);

Line 60: attribute12 OKC_TIMEVALUES.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,

56: attribute8 OKC_TIMEVALUES.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
57: attribute9 OKC_TIMEVALUES.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
58: attribute10 OKC_TIMEVALUES.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
59: attribute11 OKC_TIMEVALUES.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
60: attribute12 OKC_TIMEVALUES.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
61: attribute13 OKC_TIMEVALUES.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
62: attribute14 OKC_TIMEVALUES.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
63: attribute15 OKC_TIMEVALUES.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR);
64: g_miss_tve_rec tve_rec_type;

Line 61: attribute13 OKC_TIMEVALUES.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,

57: attribute9 OKC_TIMEVALUES.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
58: attribute10 OKC_TIMEVALUES.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
59: attribute11 OKC_TIMEVALUES.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
60: attribute12 OKC_TIMEVALUES.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
61: attribute13 OKC_TIMEVALUES.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
62: attribute14 OKC_TIMEVALUES.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
63: attribute15 OKC_TIMEVALUES.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR);
64: g_miss_tve_rec tve_rec_type;
65: TYPE tve_tbl_type IS TABLE OF tve_rec_type

Line 62: attribute14 OKC_TIMEVALUES.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,

58: attribute10 OKC_TIMEVALUES.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
59: attribute11 OKC_TIMEVALUES.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
60: attribute12 OKC_TIMEVALUES.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
61: attribute13 OKC_TIMEVALUES.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
62: attribute14 OKC_TIMEVALUES.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
63: attribute15 OKC_TIMEVALUES.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR);
64: g_miss_tve_rec tve_rec_type;
65: TYPE tve_tbl_type IS TABLE OF tve_rec_type
66: INDEX BY BINARY_INTEGER;

Line 63: attribute15 OKC_TIMEVALUES.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR);

59: attribute11 OKC_TIMEVALUES.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
60: attribute12 OKC_TIMEVALUES.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
61: attribute13 OKC_TIMEVALUES.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
62: attribute14 OKC_TIMEVALUES.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
63: attribute15 OKC_TIMEVALUES.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR);
64: g_miss_tve_rec tve_rec_type;
65: TYPE tve_tbl_type IS TABLE OF tve_rec_type
66: INDEX BY BINARY_INTEGER;
67: /* TYPE okc_timevalues_tl_rec_type IS RECORD (

Line 68: id NUMBER := OKC_API.G_MISS_NUM,

64: g_miss_tve_rec tve_rec_type;
65: TYPE tve_tbl_type IS TABLE OF tve_rec_type
66: INDEX BY BINARY_INTEGER;
67: /* TYPE okc_timevalues_tl_rec_type IS RECORD (
68: id NUMBER := OKC_API.G_MISS_NUM,
69: language OKC_TIMEVALUES_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
70: source_lang OKC_TIMEVALUES_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
71: sfwt_flag OKC_TIMEVALUES_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
72: description OKC_TIMEVALUES_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,

Line 69: language OKC_TIMEVALUES_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,

65: TYPE tve_tbl_type IS TABLE OF tve_rec_type
66: INDEX BY BINARY_INTEGER;
67: /* TYPE okc_timevalues_tl_rec_type IS RECORD (
68: id NUMBER := OKC_API.G_MISS_NUM,
69: language OKC_TIMEVALUES_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
70: source_lang OKC_TIMEVALUES_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
71: sfwt_flag OKC_TIMEVALUES_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
72: description OKC_TIMEVALUES_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
73: short_description OKC_TIMEVALUES_TL.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,

Line 70: source_lang OKC_TIMEVALUES_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,

66: INDEX BY BINARY_INTEGER;
67: /* TYPE okc_timevalues_tl_rec_type IS RECORD (
68: id NUMBER := OKC_API.G_MISS_NUM,
69: language OKC_TIMEVALUES_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
70: source_lang OKC_TIMEVALUES_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
71: sfwt_flag OKC_TIMEVALUES_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
72: description OKC_TIMEVALUES_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
73: short_description OKC_TIMEVALUES_TL.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
74: comments OKC_TIMEVALUES_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,

Line 71: sfwt_flag OKC_TIMEVALUES_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,

67: /* TYPE okc_timevalues_tl_rec_type IS RECORD (
68: id NUMBER := OKC_API.G_MISS_NUM,
69: language OKC_TIMEVALUES_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
70: source_lang OKC_TIMEVALUES_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
71: sfwt_flag OKC_TIMEVALUES_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
72: description OKC_TIMEVALUES_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
73: short_description OKC_TIMEVALUES_TL.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
74: comments OKC_TIMEVALUES_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
75: name OKC_TIMEVALUES_TL.NAME%TYPE := OKC_API.G_MISS_CHAR,

Line 72: description OKC_TIMEVALUES_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,

68: id NUMBER := OKC_API.G_MISS_NUM,
69: language OKC_TIMEVALUES_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
70: source_lang OKC_TIMEVALUES_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
71: sfwt_flag OKC_TIMEVALUES_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
72: description OKC_TIMEVALUES_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
73: short_description OKC_TIMEVALUES_TL.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
74: comments OKC_TIMEVALUES_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
75: name OKC_TIMEVALUES_TL.NAME%TYPE := OKC_API.G_MISS_CHAR,
76: created_by NUMBER := OKC_API.G_MISS_NUM,

Line 73: short_description OKC_TIMEVALUES_TL.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,

69: language OKC_TIMEVALUES_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
70: source_lang OKC_TIMEVALUES_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
71: sfwt_flag OKC_TIMEVALUES_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
72: description OKC_TIMEVALUES_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
73: short_description OKC_TIMEVALUES_TL.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
74: comments OKC_TIMEVALUES_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
75: name OKC_TIMEVALUES_TL.NAME%TYPE := OKC_API.G_MISS_CHAR,
76: created_by NUMBER := OKC_API.G_MISS_NUM,
77: creation_date OKC_TIMEVALUES_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,

Line 74: comments OKC_TIMEVALUES_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,

70: source_lang OKC_TIMEVALUES_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
71: sfwt_flag OKC_TIMEVALUES_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
72: description OKC_TIMEVALUES_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
73: short_description OKC_TIMEVALUES_TL.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
74: comments OKC_TIMEVALUES_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
75: name OKC_TIMEVALUES_TL.NAME%TYPE := OKC_API.G_MISS_CHAR,
76: created_by NUMBER := OKC_API.G_MISS_NUM,
77: creation_date OKC_TIMEVALUES_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
78: last_updated_by NUMBER := OKC_API.G_MISS_NUM,

Line 75: name OKC_TIMEVALUES_TL.NAME%TYPE := OKC_API.G_MISS_CHAR,

71: sfwt_flag OKC_TIMEVALUES_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
72: description OKC_TIMEVALUES_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
73: short_description OKC_TIMEVALUES_TL.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
74: comments OKC_TIMEVALUES_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
75: name OKC_TIMEVALUES_TL.NAME%TYPE := OKC_API.G_MISS_CHAR,
76: created_by NUMBER := OKC_API.G_MISS_NUM,
77: creation_date OKC_TIMEVALUES_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
78: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
79: last_update_date OKC_TIMEVALUES_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,

Line 76: created_by NUMBER := OKC_API.G_MISS_NUM,

72: description OKC_TIMEVALUES_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
73: short_description OKC_TIMEVALUES_TL.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
74: comments OKC_TIMEVALUES_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
75: name OKC_TIMEVALUES_TL.NAME%TYPE := OKC_API.G_MISS_CHAR,
76: created_by NUMBER := OKC_API.G_MISS_NUM,
77: creation_date OKC_TIMEVALUES_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
78: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
79: last_update_date OKC_TIMEVALUES_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
80: last_update_login NUMBER := OKC_API.G_MISS_NUM);

Line 77: creation_date OKC_TIMEVALUES_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,

73: short_description OKC_TIMEVALUES_TL.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
74: comments OKC_TIMEVALUES_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
75: name OKC_TIMEVALUES_TL.NAME%TYPE := OKC_API.G_MISS_CHAR,
76: created_by NUMBER := OKC_API.G_MISS_NUM,
77: creation_date OKC_TIMEVALUES_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
78: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
79: last_update_date OKC_TIMEVALUES_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
80: last_update_login NUMBER := OKC_API.G_MISS_NUM);
81: g_miss_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;

Line 78: last_updated_by NUMBER := OKC_API.G_MISS_NUM,

74: comments OKC_TIMEVALUES_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
75: name OKC_TIMEVALUES_TL.NAME%TYPE := OKC_API.G_MISS_CHAR,
76: created_by NUMBER := OKC_API.G_MISS_NUM,
77: creation_date OKC_TIMEVALUES_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
78: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
79: last_update_date OKC_TIMEVALUES_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
80: last_update_login NUMBER := OKC_API.G_MISS_NUM);
81: g_miss_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
82: TYPE okc_timevalues_tl_tbl_type IS TABLE OF okc_timevalues_tl_rec_type

Line 79: last_update_date OKC_TIMEVALUES_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,

75: name OKC_TIMEVALUES_TL.NAME%TYPE := OKC_API.G_MISS_CHAR,
76: created_by NUMBER := OKC_API.G_MISS_NUM,
77: creation_date OKC_TIMEVALUES_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
78: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
79: last_update_date OKC_TIMEVALUES_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
80: last_update_login NUMBER := OKC_API.G_MISS_NUM);
81: g_miss_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
82: TYPE okc_timevalues_tl_tbl_type IS TABLE OF okc_timevalues_tl_rec_type
83: INDEX BY BINARY_INTEGER;

Line 80: last_update_login NUMBER := OKC_API.G_MISS_NUM);

76: created_by NUMBER := OKC_API.G_MISS_NUM,
77: creation_date OKC_TIMEVALUES_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
78: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
79: last_update_date OKC_TIMEVALUES_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
80: last_update_login NUMBER := OKC_API.G_MISS_NUM);
81: g_miss_okc_timevalues_tl_rec okc_timevalues_tl_rec_type;
82: TYPE okc_timevalues_tl_tbl_type IS TABLE OF okc_timevalues_tl_rec_type
83: INDEX BY BINARY_INTEGER;
84: */

Line 86: id NUMBER := OKC_API.G_MISS_NUM,

82: TYPE okc_timevalues_tl_tbl_type IS TABLE OF okc_timevalues_tl_rec_type
83: INDEX BY BINARY_INTEGER;
84: */
85: TYPE tavv_rec_type IS RECORD (
86: id NUMBER := OKC_API.G_MISS_NUM,
87: object_version_number NUMBER := OKC_API.G_MISS_NUM,
88: --Bug 3122962
89: sfwt_flag OKC_TIME_TPA_VALUE_V.SFWT_FLAG%TYPE := 'N',
90: spn_id NUMBER := OKC_API.G_MISS_NUM,

Line 87: object_version_number NUMBER := OKC_API.G_MISS_NUM,

83: INDEX BY BINARY_INTEGER;
84: */
85: TYPE tavv_rec_type IS RECORD (
86: id NUMBER := OKC_API.G_MISS_NUM,
87: object_version_number NUMBER := OKC_API.G_MISS_NUM,
88: --Bug 3122962
89: sfwt_flag OKC_TIME_TPA_VALUE_V.SFWT_FLAG%TYPE := 'N',
90: spn_id NUMBER := OKC_API.G_MISS_NUM,
91: tve_id_generated_by NUMBER := OKC_API.G_MISS_NUM,

Line 90: spn_id NUMBER := OKC_API.G_MISS_NUM,

86: id NUMBER := OKC_API.G_MISS_NUM,
87: object_version_number NUMBER := OKC_API.G_MISS_NUM,
88: --Bug 3122962
89: sfwt_flag OKC_TIME_TPA_VALUE_V.SFWT_FLAG%TYPE := 'N',
90: spn_id NUMBER := OKC_API.G_MISS_NUM,
91: tve_id_generated_by NUMBER := OKC_API.G_MISS_NUM,
92: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
93: tze_id NUMBER := OKC_API.G_MISS_NUM,
94: tve_id_limited NUMBER := OKC_API.G_MISS_NUM,

Line 91: tve_id_generated_by NUMBER := OKC_API.G_MISS_NUM,

87: object_version_number NUMBER := OKC_API.G_MISS_NUM,
88: --Bug 3122962
89: sfwt_flag OKC_TIME_TPA_VALUE_V.SFWT_FLAG%TYPE := 'N',
90: spn_id NUMBER := OKC_API.G_MISS_NUM,
91: tve_id_generated_by NUMBER := OKC_API.G_MISS_NUM,
92: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
93: tze_id NUMBER := OKC_API.G_MISS_NUM,
94: tve_id_limited NUMBER := OKC_API.G_MISS_NUM,
95: description OKC_TIME_TPA_VALUE_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,

Line 92: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,

88: --Bug 3122962
89: sfwt_flag OKC_TIME_TPA_VALUE_V.SFWT_FLAG%TYPE := 'N',
90: spn_id NUMBER := OKC_API.G_MISS_NUM,
91: tve_id_generated_by NUMBER := OKC_API.G_MISS_NUM,
92: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
93: tze_id NUMBER := OKC_API.G_MISS_NUM,
94: tve_id_limited NUMBER := OKC_API.G_MISS_NUM,
95: description OKC_TIME_TPA_VALUE_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
96: short_description OKC_TIME_TPA_VALUE_V.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,

Line 93: tze_id NUMBER := OKC_API.G_MISS_NUM,

89: sfwt_flag OKC_TIME_TPA_VALUE_V.SFWT_FLAG%TYPE := 'N',
90: spn_id NUMBER := OKC_API.G_MISS_NUM,
91: tve_id_generated_by NUMBER := OKC_API.G_MISS_NUM,
92: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
93: tze_id NUMBER := OKC_API.G_MISS_NUM,
94: tve_id_limited NUMBER := OKC_API.G_MISS_NUM,
95: description OKC_TIME_TPA_VALUE_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
96: short_description OKC_TIME_TPA_VALUE_V.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
97: comments OKC_TIME_TPA_VALUE_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,

Line 94: tve_id_limited NUMBER := OKC_API.G_MISS_NUM,

90: spn_id NUMBER := OKC_API.G_MISS_NUM,
91: tve_id_generated_by NUMBER := OKC_API.G_MISS_NUM,
92: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
93: tze_id NUMBER := OKC_API.G_MISS_NUM,
94: tve_id_limited NUMBER := OKC_API.G_MISS_NUM,
95: description OKC_TIME_TPA_VALUE_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
96: short_description OKC_TIME_TPA_VALUE_V.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
97: comments OKC_TIME_TPA_VALUE_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
98: datetime OKC_TIME_TPA_VALUE_V.DATETIME%TYPE := OKC_API.G_MISS_DATE,

Line 95: description OKC_TIME_TPA_VALUE_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,

91: tve_id_generated_by NUMBER := OKC_API.G_MISS_NUM,
92: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
93: tze_id NUMBER := OKC_API.G_MISS_NUM,
94: tve_id_limited NUMBER := OKC_API.G_MISS_NUM,
95: description OKC_TIME_TPA_VALUE_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
96: short_description OKC_TIME_TPA_VALUE_V.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
97: comments OKC_TIME_TPA_VALUE_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
98: datetime OKC_TIME_TPA_VALUE_V.DATETIME%TYPE := OKC_API.G_MISS_DATE,
99: attribute_category OKC_TIME_TPA_VALUE_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,

Line 96: short_description OKC_TIME_TPA_VALUE_V.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,

92: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
93: tze_id NUMBER := OKC_API.G_MISS_NUM,
94: tve_id_limited NUMBER := OKC_API.G_MISS_NUM,
95: description OKC_TIME_TPA_VALUE_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
96: short_description OKC_TIME_TPA_VALUE_V.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
97: comments OKC_TIME_TPA_VALUE_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
98: datetime OKC_TIME_TPA_VALUE_V.DATETIME%TYPE := OKC_API.G_MISS_DATE,
99: attribute_category OKC_TIME_TPA_VALUE_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
100: attribute1 OKC_TIME_TPA_VALUE_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,

Line 97: comments OKC_TIME_TPA_VALUE_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,

93: tze_id NUMBER := OKC_API.G_MISS_NUM,
94: tve_id_limited NUMBER := OKC_API.G_MISS_NUM,
95: description OKC_TIME_TPA_VALUE_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
96: short_description OKC_TIME_TPA_VALUE_V.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
97: comments OKC_TIME_TPA_VALUE_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
98: datetime OKC_TIME_TPA_VALUE_V.DATETIME%TYPE := OKC_API.G_MISS_DATE,
99: attribute_category OKC_TIME_TPA_VALUE_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
100: attribute1 OKC_TIME_TPA_VALUE_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
101: attribute2 OKC_TIME_TPA_VALUE_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,

Line 98: datetime OKC_TIME_TPA_VALUE_V.DATETIME%TYPE := OKC_API.G_MISS_DATE,

94: tve_id_limited NUMBER := OKC_API.G_MISS_NUM,
95: description OKC_TIME_TPA_VALUE_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
96: short_description OKC_TIME_TPA_VALUE_V.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
97: comments OKC_TIME_TPA_VALUE_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
98: datetime OKC_TIME_TPA_VALUE_V.DATETIME%TYPE := OKC_API.G_MISS_DATE,
99: attribute_category OKC_TIME_TPA_VALUE_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
100: attribute1 OKC_TIME_TPA_VALUE_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
101: attribute2 OKC_TIME_TPA_VALUE_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
102: attribute3 OKC_TIME_TPA_VALUE_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,

Line 99: attribute_category OKC_TIME_TPA_VALUE_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,

95: description OKC_TIME_TPA_VALUE_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
96: short_description OKC_TIME_TPA_VALUE_V.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
97: comments OKC_TIME_TPA_VALUE_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
98: datetime OKC_TIME_TPA_VALUE_V.DATETIME%TYPE := OKC_API.G_MISS_DATE,
99: attribute_category OKC_TIME_TPA_VALUE_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
100: attribute1 OKC_TIME_TPA_VALUE_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
101: attribute2 OKC_TIME_TPA_VALUE_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
102: attribute3 OKC_TIME_TPA_VALUE_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
103: attribute4 OKC_TIME_TPA_VALUE_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,

Line 100: attribute1 OKC_TIME_TPA_VALUE_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,

96: short_description OKC_TIME_TPA_VALUE_V.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
97: comments OKC_TIME_TPA_VALUE_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
98: datetime OKC_TIME_TPA_VALUE_V.DATETIME%TYPE := OKC_API.G_MISS_DATE,
99: attribute_category OKC_TIME_TPA_VALUE_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
100: attribute1 OKC_TIME_TPA_VALUE_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
101: attribute2 OKC_TIME_TPA_VALUE_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
102: attribute3 OKC_TIME_TPA_VALUE_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
103: attribute4 OKC_TIME_TPA_VALUE_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
104: attribute5 OKC_TIME_TPA_VALUE_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,

Line 101: attribute2 OKC_TIME_TPA_VALUE_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,

97: comments OKC_TIME_TPA_VALUE_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
98: datetime OKC_TIME_TPA_VALUE_V.DATETIME%TYPE := OKC_API.G_MISS_DATE,
99: attribute_category OKC_TIME_TPA_VALUE_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
100: attribute1 OKC_TIME_TPA_VALUE_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
101: attribute2 OKC_TIME_TPA_VALUE_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
102: attribute3 OKC_TIME_TPA_VALUE_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
103: attribute4 OKC_TIME_TPA_VALUE_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
104: attribute5 OKC_TIME_TPA_VALUE_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
105: attribute6 OKC_TIME_TPA_VALUE_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,

Line 102: attribute3 OKC_TIME_TPA_VALUE_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,

98: datetime OKC_TIME_TPA_VALUE_V.DATETIME%TYPE := OKC_API.G_MISS_DATE,
99: attribute_category OKC_TIME_TPA_VALUE_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
100: attribute1 OKC_TIME_TPA_VALUE_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
101: attribute2 OKC_TIME_TPA_VALUE_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
102: attribute3 OKC_TIME_TPA_VALUE_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
103: attribute4 OKC_TIME_TPA_VALUE_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
104: attribute5 OKC_TIME_TPA_VALUE_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
105: attribute6 OKC_TIME_TPA_VALUE_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
106: attribute7 OKC_TIME_TPA_VALUE_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,

Line 103: attribute4 OKC_TIME_TPA_VALUE_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,

99: attribute_category OKC_TIME_TPA_VALUE_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
100: attribute1 OKC_TIME_TPA_VALUE_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
101: attribute2 OKC_TIME_TPA_VALUE_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
102: attribute3 OKC_TIME_TPA_VALUE_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
103: attribute4 OKC_TIME_TPA_VALUE_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
104: attribute5 OKC_TIME_TPA_VALUE_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
105: attribute6 OKC_TIME_TPA_VALUE_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
106: attribute7 OKC_TIME_TPA_VALUE_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
107: attribute8 OKC_TIME_TPA_VALUE_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,

Line 104: attribute5 OKC_TIME_TPA_VALUE_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,

100: attribute1 OKC_TIME_TPA_VALUE_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
101: attribute2 OKC_TIME_TPA_VALUE_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
102: attribute3 OKC_TIME_TPA_VALUE_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
103: attribute4 OKC_TIME_TPA_VALUE_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
104: attribute5 OKC_TIME_TPA_VALUE_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
105: attribute6 OKC_TIME_TPA_VALUE_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
106: attribute7 OKC_TIME_TPA_VALUE_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
107: attribute8 OKC_TIME_TPA_VALUE_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
108: attribute9 OKC_TIME_TPA_VALUE_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,

Line 105: attribute6 OKC_TIME_TPA_VALUE_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,

101: attribute2 OKC_TIME_TPA_VALUE_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
102: attribute3 OKC_TIME_TPA_VALUE_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
103: attribute4 OKC_TIME_TPA_VALUE_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
104: attribute5 OKC_TIME_TPA_VALUE_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
105: attribute6 OKC_TIME_TPA_VALUE_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
106: attribute7 OKC_TIME_TPA_VALUE_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
107: attribute8 OKC_TIME_TPA_VALUE_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
108: attribute9 OKC_TIME_TPA_VALUE_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
109: attribute10 OKC_TIME_TPA_VALUE_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,

Line 106: attribute7 OKC_TIME_TPA_VALUE_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,

102: attribute3 OKC_TIME_TPA_VALUE_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
103: attribute4 OKC_TIME_TPA_VALUE_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
104: attribute5 OKC_TIME_TPA_VALUE_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
105: attribute6 OKC_TIME_TPA_VALUE_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
106: attribute7 OKC_TIME_TPA_VALUE_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
107: attribute8 OKC_TIME_TPA_VALUE_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
108: attribute9 OKC_TIME_TPA_VALUE_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
109: attribute10 OKC_TIME_TPA_VALUE_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
110: attribute11 OKC_TIME_TPA_VALUE_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,

Line 107: attribute8 OKC_TIME_TPA_VALUE_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,

103: attribute4 OKC_TIME_TPA_VALUE_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
104: attribute5 OKC_TIME_TPA_VALUE_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
105: attribute6 OKC_TIME_TPA_VALUE_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
106: attribute7 OKC_TIME_TPA_VALUE_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
107: attribute8 OKC_TIME_TPA_VALUE_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
108: attribute9 OKC_TIME_TPA_VALUE_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
109: attribute10 OKC_TIME_TPA_VALUE_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
110: attribute11 OKC_TIME_TPA_VALUE_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
111: attribute12 OKC_TIME_TPA_VALUE_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,

Line 108: attribute9 OKC_TIME_TPA_VALUE_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,

104: attribute5 OKC_TIME_TPA_VALUE_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
105: attribute6 OKC_TIME_TPA_VALUE_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
106: attribute7 OKC_TIME_TPA_VALUE_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
107: attribute8 OKC_TIME_TPA_VALUE_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
108: attribute9 OKC_TIME_TPA_VALUE_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
109: attribute10 OKC_TIME_TPA_VALUE_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
110: attribute11 OKC_TIME_TPA_VALUE_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
111: attribute12 OKC_TIME_TPA_VALUE_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
112: attribute13 OKC_TIME_TPA_VALUE_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,

Line 109: attribute10 OKC_TIME_TPA_VALUE_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,

105: attribute6 OKC_TIME_TPA_VALUE_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
106: attribute7 OKC_TIME_TPA_VALUE_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
107: attribute8 OKC_TIME_TPA_VALUE_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
108: attribute9 OKC_TIME_TPA_VALUE_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
109: attribute10 OKC_TIME_TPA_VALUE_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
110: attribute11 OKC_TIME_TPA_VALUE_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
111: attribute12 OKC_TIME_TPA_VALUE_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
112: attribute13 OKC_TIME_TPA_VALUE_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
113: attribute14 OKC_TIME_TPA_VALUE_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,

Line 110: attribute11 OKC_TIME_TPA_VALUE_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,

106: attribute7 OKC_TIME_TPA_VALUE_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
107: attribute8 OKC_TIME_TPA_VALUE_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
108: attribute9 OKC_TIME_TPA_VALUE_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
109: attribute10 OKC_TIME_TPA_VALUE_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
110: attribute11 OKC_TIME_TPA_VALUE_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
111: attribute12 OKC_TIME_TPA_VALUE_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
112: attribute13 OKC_TIME_TPA_VALUE_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
113: attribute14 OKC_TIME_TPA_VALUE_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
114: attribute15 OKC_TIME_TPA_VALUE_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,

Line 111: attribute12 OKC_TIME_TPA_VALUE_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,

107: attribute8 OKC_TIME_TPA_VALUE_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
108: attribute9 OKC_TIME_TPA_VALUE_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
109: attribute10 OKC_TIME_TPA_VALUE_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
110: attribute11 OKC_TIME_TPA_VALUE_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
111: attribute12 OKC_TIME_TPA_VALUE_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
112: attribute13 OKC_TIME_TPA_VALUE_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
113: attribute14 OKC_TIME_TPA_VALUE_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
114: attribute15 OKC_TIME_TPA_VALUE_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
115: created_by NUMBER := OKC_API.G_MISS_NUM,

Line 112: attribute13 OKC_TIME_TPA_VALUE_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,

108: attribute9 OKC_TIME_TPA_VALUE_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
109: attribute10 OKC_TIME_TPA_VALUE_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
110: attribute11 OKC_TIME_TPA_VALUE_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
111: attribute12 OKC_TIME_TPA_VALUE_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
112: attribute13 OKC_TIME_TPA_VALUE_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
113: attribute14 OKC_TIME_TPA_VALUE_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
114: attribute15 OKC_TIME_TPA_VALUE_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
115: created_by NUMBER := OKC_API.G_MISS_NUM,
116: creation_date OKC_TIME_TPA_VALUE_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,

Line 113: attribute14 OKC_TIME_TPA_VALUE_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,

109: attribute10 OKC_TIME_TPA_VALUE_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
110: attribute11 OKC_TIME_TPA_VALUE_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
111: attribute12 OKC_TIME_TPA_VALUE_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
112: attribute13 OKC_TIME_TPA_VALUE_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
113: attribute14 OKC_TIME_TPA_VALUE_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
114: attribute15 OKC_TIME_TPA_VALUE_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
115: created_by NUMBER := OKC_API.G_MISS_NUM,
116: creation_date OKC_TIME_TPA_VALUE_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
117: last_updated_by NUMBER := OKC_API.G_MISS_NUM,

Line 114: attribute15 OKC_TIME_TPA_VALUE_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,

110: attribute11 OKC_TIME_TPA_VALUE_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
111: attribute12 OKC_TIME_TPA_VALUE_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
112: attribute13 OKC_TIME_TPA_VALUE_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
113: attribute14 OKC_TIME_TPA_VALUE_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
114: attribute15 OKC_TIME_TPA_VALUE_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
115: created_by NUMBER := OKC_API.G_MISS_NUM,
116: creation_date OKC_TIME_TPA_VALUE_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
117: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
118: last_update_date OKC_TIME_TPA_VALUE_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,

Line 115: created_by NUMBER := OKC_API.G_MISS_NUM,

111: attribute12 OKC_TIME_TPA_VALUE_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
112: attribute13 OKC_TIME_TPA_VALUE_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
113: attribute14 OKC_TIME_TPA_VALUE_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
114: attribute15 OKC_TIME_TPA_VALUE_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
115: created_by NUMBER := OKC_API.G_MISS_NUM,
116: creation_date OKC_TIME_TPA_VALUE_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
117: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
118: last_update_date OKC_TIME_TPA_VALUE_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
119: last_update_login NUMBER := OKC_API.G_MISS_NUM);

Line 116: creation_date OKC_TIME_TPA_VALUE_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,

112: attribute13 OKC_TIME_TPA_VALUE_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
113: attribute14 OKC_TIME_TPA_VALUE_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
114: attribute15 OKC_TIME_TPA_VALUE_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
115: created_by NUMBER := OKC_API.G_MISS_NUM,
116: creation_date OKC_TIME_TPA_VALUE_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
117: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
118: last_update_date OKC_TIME_TPA_VALUE_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
119: last_update_login NUMBER := OKC_API.G_MISS_NUM);
120: g_miss_tavv_rec tavv_rec_type;

Line 117: last_updated_by NUMBER := OKC_API.G_MISS_NUM,

113: attribute14 OKC_TIME_TPA_VALUE_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
114: attribute15 OKC_TIME_TPA_VALUE_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
115: created_by NUMBER := OKC_API.G_MISS_NUM,
116: creation_date OKC_TIME_TPA_VALUE_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
117: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
118: last_update_date OKC_TIME_TPA_VALUE_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
119: last_update_login NUMBER := OKC_API.G_MISS_NUM);
120: g_miss_tavv_rec tavv_rec_type;
121: TYPE tavv_tbl_type IS TABLE OF tavv_rec_type

Line 118: last_update_date OKC_TIME_TPA_VALUE_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,

114: attribute15 OKC_TIME_TPA_VALUE_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
115: created_by NUMBER := OKC_API.G_MISS_NUM,
116: creation_date OKC_TIME_TPA_VALUE_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
117: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
118: last_update_date OKC_TIME_TPA_VALUE_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
119: last_update_login NUMBER := OKC_API.G_MISS_NUM);
120: g_miss_tavv_rec tavv_rec_type;
121: TYPE tavv_tbl_type IS TABLE OF tavv_rec_type
122: INDEX BY BINARY_INTEGER;

Line 119: last_update_login NUMBER := OKC_API.G_MISS_NUM);

115: created_by NUMBER := OKC_API.G_MISS_NUM,
116: creation_date OKC_TIME_TPA_VALUE_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
117: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
118: last_update_date OKC_TIME_TPA_VALUE_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
119: last_update_login NUMBER := OKC_API.G_MISS_NUM);
120: g_miss_tavv_rec tavv_rec_type;
121: TYPE tavv_tbl_type IS TABLE OF tavv_rec_type
122: INDEX BY BINARY_INTEGER;
123: ---------------------------------------------------------------------------

Line 126: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;

122: INDEX BY BINARY_INTEGER;
123: ---------------------------------------------------------------------------
124: -- GLOBAL MESSAGE CONSTANTS
125: ---------------------------------------------------------------------------
126: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
127: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
128: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
129: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
130: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;

Line 127: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;

123: ---------------------------------------------------------------------------
124: -- GLOBAL MESSAGE CONSTANTS
125: ---------------------------------------------------------------------------
126: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
127: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
128: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
129: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
130: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
131: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;

Line 128: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;

124: -- GLOBAL MESSAGE CONSTANTS
125: ---------------------------------------------------------------------------
126: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
127: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
128: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
129: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
130: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
131: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
132: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;

Line 129: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;

125: ---------------------------------------------------------------------------
126: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
127: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
128: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
129: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
130: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
131: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
132: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
133: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;

Line 130: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;

126: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
127: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
128: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
129: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
130: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
131: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
132: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
133: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
134: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;

Line 131: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;

127: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
128: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
129: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
130: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
131: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
132: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
133: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
134: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
135: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;

Line 132: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;

128: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
129: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
130: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
131: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
132: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
133: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
134: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
135: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
136: ---------------------------------------------------------------------------

Line 133: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;

129: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
130: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
131: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
132: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
133: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
134: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
135: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
136: ---------------------------------------------------------------------------
137: -- GLOBAL VARIABLES

Line 134: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;

130: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
131: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
132: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
133: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
134: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
135: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
136: ---------------------------------------------------------------------------
137: -- GLOBAL VARIABLES
138: ---------------------------------------------------------------------------

Line 135: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;

131: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
132: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
133: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
134: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
135: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
136: ---------------------------------------------------------------------------
137: -- GLOBAL VARIABLES
138: ---------------------------------------------------------------------------
139: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_TAV_PVT';

Line 140: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;

136: ---------------------------------------------------------------------------
137: -- GLOBAL VARIABLES
138: ---------------------------------------------------------------------------
139: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_TAV_PVT';
140: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
141: ---------------------------------------------------------------------------
142: -- Procedures and Functions
143: ---------------------------------------------------------------------------
144:

Line 150: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

146: PROCEDURE change_version;
147: PROCEDURE api_copy;
148: PROCEDURE insert_row(
149: p_api_version IN NUMBER,
150: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
151: x_return_status OUT NOCOPY VARCHAR2,
152: x_msg_count OUT NOCOPY NUMBER,
153: x_msg_data OUT NOCOPY VARCHAR2,
154: p_tavv_rec IN tavv_rec_type,

Line 159: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

155: x_tavv_rec OUT NOCOPY tavv_rec_type);
156:
157: PROCEDURE insert_row(
158: p_api_version IN NUMBER,
159: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
160: x_return_status OUT NOCOPY VARCHAR2,
161: x_msg_count OUT NOCOPY NUMBER,
162: x_msg_data OUT NOCOPY VARCHAR2,
163: p_tavv_tbl IN tavv_tbl_type,

Line 168: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

164: x_tavv_tbl OUT NOCOPY tavv_tbl_type);
165:
166: PROCEDURE lock_row(
167: p_api_version IN NUMBER,
168: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
169: x_return_status OUT NOCOPY VARCHAR2,
170: x_msg_count OUT NOCOPY NUMBER,
171: x_msg_data OUT NOCOPY VARCHAR2,
172: p_tavv_rec IN tavv_rec_type);

Line 176: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

172: p_tavv_rec IN tavv_rec_type);
173:
174: PROCEDURE lock_row(
175: p_api_version IN NUMBER,
176: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
177: x_return_status OUT NOCOPY VARCHAR2,
178: x_msg_count OUT NOCOPY NUMBER,
179: x_msg_data OUT NOCOPY VARCHAR2,
180: p_tavv_tbl IN tavv_tbl_type);

Line 184: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

180: p_tavv_tbl IN tavv_tbl_type);
181:
182: PROCEDURE update_row(
183: p_api_version IN NUMBER,
184: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
185: x_return_status OUT NOCOPY VARCHAR2,
186: x_msg_count OUT NOCOPY NUMBER,
187: x_msg_data OUT NOCOPY VARCHAR2,
188: p_tavv_rec IN tavv_rec_type,

Line 193: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

189: x_tavv_rec OUT NOCOPY tavv_rec_type);
190:
191: PROCEDURE update_row(
192: p_api_version IN NUMBER,
193: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
194: x_return_status OUT NOCOPY VARCHAR2,
195: x_msg_count OUT NOCOPY NUMBER,
196: x_msg_data OUT NOCOPY VARCHAR2,
197: p_tavv_tbl IN tavv_tbl_type,

Line 202: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

198: x_tavv_tbl OUT NOCOPY tavv_tbl_type);
199:
200: PROCEDURE delete_row(
201: p_api_version IN NUMBER,
202: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
203: x_return_status OUT NOCOPY VARCHAR2,
204: x_msg_count OUT NOCOPY NUMBER,
205: x_msg_data OUT NOCOPY VARCHAR2,
206: p_tavv_rec IN tavv_rec_type);

Line 210: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

206: p_tavv_rec IN tavv_rec_type);
207:
208: PROCEDURE delete_row(
209: p_api_version IN NUMBER,
210: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
211: x_return_status OUT NOCOPY VARCHAR2,
212: x_msg_count OUT NOCOPY NUMBER,
213: x_msg_data OUT NOCOPY VARCHAR2,
214: p_tavv_tbl IN tavv_tbl_type);

Line 218: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

214: p_tavv_tbl IN tavv_tbl_type);
215:
216: PROCEDURE validate_row(
217: p_api_version IN NUMBER,
218: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
219: x_return_status OUT NOCOPY VARCHAR2,
220: x_msg_count OUT NOCOPY NUMBER,
221: x_msg_data OUT NOCOPY VARCHAR2,
222: p_tavv_rec IN tavv_rec_type);

Line 226: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

222: p_tavv_rec IN tavv_rec_type);
223:
224: PROCEDURE validate_row(
225: p_api_version IN NUMBER,
226: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
227: x_return_status OUT NOCOPY VARCHAR2,
228: x_msg_count OUT NOCOPY NUMBER,
229: x_msg_data OUT NOCOPY VARCHAR2,
230: p_tavv_tbl IN tavv_tbl_type);