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_TGN_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_limited 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_limited 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_limited 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_limited 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_generated_by NUMBER := OKC_API.G_MISS_NUM,

Line 18: tve_id_limited NUMBER := OKC_API.G_MISS_NUM,

14: spn_id NUMBER := OKC_API.G_MISS_NUM,
15: tve_id_offset NUMBER := OKC_API.G_MISS_NUM,
16: uom_code OKC_TIMEVALUES.uom_code%TYPE := OKC_API.G_MISS_CHAR,
17: cnh_id NUMBER := OKC_API.G_MISS_NUM,
18: tve_id_limited 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_generated_by 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_limited 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_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,

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_limited 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_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,

Line 21: tve_id_generated_by NUMBER := OKC_API.G_MISS_NUM,

17: cnh_id NUMBER := OKC_API.G_MISS_NUM,
18: tve_id_limited 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_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,

Line 22: tve_id_started NUMBER := OKC_API.G_MISS_NUM,

18: tve_id_limited 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_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,

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_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,

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_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,

Line 25: object_version_number 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,

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: nth NUMBER := OKC_API.G_MISS_NUM,

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

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

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

Line 39: nth 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

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

36: hour NUMBER := OKC_API.G_MISS_NUM,
37: minute NUMBER := OKC_API.G_MISS_NUM,
38: second NUMBER := OKC_API.G_MISS_NUM,
39: nth NUMBER := OKC_API.G_MISS_NUM,
40: day_of_week OKC_TIMEVALUES.DAY_OF_WEEK%TYPE := OKC_API.G_MISS_CHAR,
41: interval_yn OKC_TIMEVALUES.INTERVAL_YN%TYPE := OKC_API.G_MISS_CHAR,
42: last_update_login NUMBER := OKC_API.G_MISS_NUM,
43: --Bug 3122962
44: description OKC_TIMEVALUES.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,

Line 41: interval_yn OKC_TIMEVALUES.INTERVAL_YN%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: description OKC_TIMEVALUES.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
45: short_description OKC_TIMEVALUES.SHORT_DESCRIPTION%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: 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: description OKC_TIMEVALUES.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
45: short_description OKC_TIMEVALUES.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
46: comments OKC_TIMEVALUES.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,

Line 44: description OKC_TIMEVALUES.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: description OKC_TIMEVALUES.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
45: short_description OKC_TIMEVALUES.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
46: comments OKC_TIMEVALUES.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
47: name OKC_TIMEVALUES.NAME%TYPE := OKC_API.G_MISS_CHAR,
48:

Line 45: short_description OKC_TIMEVALUES.SHORT_DESCRIPTION%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: description OKC_TIMEVALUES.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
45: short_description OKC_TIMEVALUES.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
46: comments OKC_TIMEVALUES.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
47: name OKC_TIMEVALUES.NAME%TYPE := OKC_API.G_MISS_CHAR,
48:
49: attribute_category OKC_TIMEVALUES.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,

Line 46: comments OKC_TIMEVALUES.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,

42: last_update_login NUMBER := OKC_API.G_MISS_NUM,
43: --Bug 3122962
44: description OKC_TIMEVALUES.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
45: short_description OKC_TIMEVALUES.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
46: comments OKC_TIMEVALUES.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
47: name OKC_TIMEVALUES.NAME%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,

Line 47: name OKC_TIMEVALUES.NAME%TYPE := OKC_API.G_MISS_CHAR,

43: --Bug 3122962
44: description OKC_TIMEVALUES.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
45: short_description OKC_TIMEVALUES.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
46: comments OKC_TIMEVALUES.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
47: name OKC_TIMEVALUES.NAME%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,

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

45: short_description OKC_TIMEVALUES.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
46: comments OKC_TIMEVALUES.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
47: name OKC_TIMEVALUES.NAME%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,

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

46: comments OKC_TIMEVALUES.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
47: name OKC_TIMEVALUES.NAME%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,

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

47: name OKC_TIMEVALUES.NAME%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,

Line 52: attribute3 OKC_TIMEVALUES.ATTRIBUTE3%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,

Line 53: attribute4 OKC_TIMEVALUES.ATTRIBUTE4%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,

Line 54: attribute5 OKC_TIMEVALUES.ATTRIBUTE5%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,

Line 55: attribute6 OKC_TIMEVALUES.ATTRIBUTE6%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,

Line 56: attribute7 OKC_TIMEVALUES.ATTRIBUTE7%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,

Line 57: attribute8 OKC_TIMEVALUES.ATTRIBUTE8%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,

Line 58: attribute9 OKC_TIMEVALUES.ATTRIBUTE9%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,

Line 59: attribute10 OKC_TIMEVALUES.ATTRIBUTE10%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,

Line 60: attribute11 OKC_TIMEVALUES.ATTRIBUTE11%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);

Line 61: attribute12 OKC_TIMEVALUES.ATTRIBUTE12%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;

Line 62: attribute13 OKC_TIMEVALUES.ATTRIBUTE13%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;
66: TYPE tve_tbl_type IS TABLE OF tve_rec_type

Line 63: attribute14 OKC_TIMEVALUES.ATTRIBUTE14%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
67: INDEX BY BINARY_INTEGER;

Line 64: attribute15 OKC_TIMEVALUES.ATTRIBUTE15%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;
68: --Bug 3122962

Line 71: id NUMBER := OKC_API.G_MISS_NUM,

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 79: created_by NUMBER := OKC_API.G_MISS_NUM,

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

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

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

Line 81: last_updated_by NUMBER := OKC_API.G_MISS_NUM,

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

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

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

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

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

Line 89: id NUMBER := OKC_API.G_MISS_NUM,

85: TYPE okc_timevalues_tl_tbl_type IS TABLE OF okc_timevalues_tl_rec_type
86: INDEX BY BINARY_INTEGER;
87: */
88: TYPE tgnv_rec_type IS RECORD (
89: id NUMBER := OKC_API.G_MISS_NUM,
90: object_version_number NUMBER := OKC_API.G_MISS_NUM,
91: --Bug 3122962
92: sfwt_flag OKC_TIME_TPG_NAMED_V.SFWT_FLAG%TYPE := 'N',
93: cnh_id NUMBER := OKC_API.G_MISS_NUM,

Line 90: object_version_number NUMBER := OKC_API.G_MISS_NUM,

86: INDEX BY BINARY_INTEGER;
87: */
88: TYPE tgnv_rec_type IS RECORD (
89: id NUMBER := OKC_API.G_MISS_NUM,
90: object_version_number NUMBER := OKC_API.G_MISS_NUM,
91: --Bug 3122962
92: sfwt_flag OKC_TIME_TPG_NAMED_V.SFWT_FLAG%TYPE := 'N',
93: cnh_id NUMBER := OKC_API.G_MISS_NUM,
94: tve_id_limited NUMBER := OKC_API.G_MISS_NUM,

Line 93: cnh_id NUMBER := OKC_API.G_MISS_NUM,

89: id NUMBER := OKC_API.G_MISS_NUM,
90: object_version_number NUMBER := OKC_API.G_MISS_NUM,
91: --Bug 3122962
92: sfwt_flag OKC_TIME_TPG_NAMED_V.SFWT_FLAG%TYPE := 'N',
93: cnh_id NUMBER := OKC_API.G_MISS_NUM,
94: tve_id_limited NUMBER := OKC_API.G_MISS_NUM,
95: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
96: tze_id NUMBER := OKC_API.G_MISS_NUM,
97: description OKC_TIME_TPG_NAMED_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,

Line 94: tve_id_limited NUMBER := OKC_API.G_MISS_NUM,

90: object_version_number NUMBER := OKC_API.G_MISS_NUM,
91: --Bug 3122962
92: sfwt_flag OKC_TIME_TPG_NAMED_V.SFWT_FLAG%TYPE := 'N',
93: cnh_id NUMBER := OKC_API.G_MISS_NUM,
94: tve_id_limited NUMBER := OKC_API.G_MISS_NUM,
95: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
96: tze_id NUMBER := OKC_API.G_MISS_NUM,
97: description OKC_TIME_TPG_NAMED_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
98: short_description OKC_TIME_TPG_NAMED_V.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,

Line 95: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,

91: --Bug 3122962
92: sfwt_flag OKC_TIME_TPG_NAMED_V.SFWT_FLAG%TYPE := 'N',
93: cnh_id NUMBER := OKC_API.G_MISS_NUM,
94: tve_id_limited NUMBER := OKC_API.G_MISS_NUM,
95: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
96: tze_id NUMBER := OKC_API.G_MISS_NUM,
97: description OKC_TIME_TPG_NAMED_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
98: short_description OKC_TIME_TPG_NAMED_V.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
99: comments OKC_TIME_TPG_NAMED_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,

Line 96: tze_id NUMBER := OKC_API.G_MISS_NUM,

92: sfwt_flag OKC_TIME_TPG_NAMED_V.SFWT_FLAG%TYPE := 'N',
93: cnh_id NUMBER := OKC_API.G_MISS_NUM,
94: tve_id_limited NUMBER := OKC_API.G_MISS_NUM,
95: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
96: tze_id NUMBER := OKC_API.G_MISS_NUM,
97: description OKC_TIME_TPG_NAMED_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
98: short_description OKC_TIME_TPG_NAMED_V.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
99: comments OKC_TIME_TPG_NAMED_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
100: attribute_category OKC_TIME_TPG_NAMED_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,

Line 97: description OKC_TIME_TPG_NAMED_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,

93: cnh_id NUMBER := OKC_API.G_MISS_NUM,
94: tve_id_limited NUMBER := OKC_API.G_MISS_NUM,
95: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
96: tze_id NUMBER := OKC_API.G_MISS_NUM,
97: description OKC_TIME_TPG_NAMED_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
98: short_description OKC_TIME_TPG_NAMED_V.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
99: comments OKC_TIME_TPG_NAMED_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
100: attribute_category OKC_TIME_TPG_NAMED_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
101: attribute1 OKC_TIME_TPG_NAMED_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,

Line 98: short_description OKC_TIME_TPG_NAMED_V.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,

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

Line 99: comments OKC_TIME_TPG_NAMED_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,

95: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
96: tze_id NUMBER := OKC_API.G_MISS_NUM,
97: description OKC_TIME_TPG_NAMED_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
98: short_description OKC_TIME_TPG_NAMED_V.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
99: comments OKC_TIME_TPG_NAMED_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
100: attribute_category OKC_TIME_TPG_NAMED_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
101: attribute1 OKC_TIME_TPG_NAMED_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
102: attribute2 OKC_TIME_TPG_NAMED_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
103: attribute3 OKC_TIME_TPG_NAMED_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,

Line 100: attribute_category OKC_TIME_TPG_NAMED_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,

96: tze_id NUMBER := OKC_API.G_MISS_NUM,
97: description OKC_TIME_TPG_NAMED_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
98: short_description OKC_TIME_TPG_NAMED_V.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
99: comments OKC_TIME_TPG_NAMED_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
100: attribute_category OKC_TIME_TPG_NAMED_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
101: attribute1 OKC_TIME_TPG_NAMED_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
102: attribute2 OKC_TIME_TPG_NAMED_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
103: attribute3 OKC_TIME_TPG_NAMED_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
104: attribute4 OKC_TIME_TPG_NAMED_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,

Line 101: attribute1 OKC_TIME_TPG_NAMED_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,

97: description OKC_TIME_TPG_NAMED_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
98: short_description OKC_TIME_TPG_NAMED_V.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
99: comments OKC_TIME_TPG_NAMED_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
100: attribute_category OKC_TIME_TPG_NAMED_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
101: attribute1 OKC_TIME_TPG_NAMED_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
102: attribute2 OKC_TIME_TPG_NAMED_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
103: attribute3 OKC_TIME_TPG_NAMED_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
104: attribute4 OKC_TIME_TPG_NAMED_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
105: attribute5 OKC_TIME_TPG_NAMED_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,

Line 102: attribute2 OKC_TIME_TPG_NAMED_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,

98: short_description OKC_TIME_TPG_NAMED_V.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
99: comments OKC_TIME_TPG_NAMED_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
100: attribute_category OKC_TIME_TPG_NAMED_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
101: attribute1 OKC_TIME_TPG_NAMED_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
102: attribute2 OKC_TIME_TPG_NAMED_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
103: attribute3 OKC_TIME_TPG_NAMED_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
104: attribute4 OKC_TIME_TPG_NAMED_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
105: attribute5 OKC_TIME_TPG_NAMED_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
106: attribute6 OKC_TIME_TPG_NAMED_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,

Line 103: attribute3 OKC_TIME_TPG_NAMED_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,

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

Line 104: attribute4 OKC_TIME_TPG_NAMED_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,

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

Line 105: attribute5 OKC_TIME_TPG_NAMED_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,

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

Line 106: attribute6 OKC_TIME_TPG_NAMED_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,

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

Line 107: attribute7 OKC_TIME_TPG_NAMED_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,

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

Line 108: attribute8 OKC_TIME_TPG_NAMED_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,

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

Line 109: attribute9 OKC_TIME_TPG_NAMED_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,

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

Line 110: attribute10 OKC_TIME_TPG_NAMED_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,

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

Line 111: attribute11 OKC_TIME_TPG_NAMED_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,

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

Line 112: attribute12 OKC_TIME_TPG_NAMED_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,

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

Line 113: attribute13 OKC_TIME_TPG_NAMED_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,

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

Line 114: attribute14 OKC_TIME_TPG_NAMED_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,

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

Line 115: attribute15 OKC_TIME_TPG_NAMED_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,

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

Line 116: created_by NUMBER := OKC_API.G_MISS_NUM,

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

Line 117: creation_date OKC_TIME_TPG_NAMED_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,

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

Line 118: last_updated_by NUMBER := OKC_API.G_MISS_NUM,

114: attribute14 OKC_TIME_TPG_NAMED_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
115: attribute15 OKC_TIME_TPG_NAMED_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
116: created_by NUMBER := OKC_API.G_MISS_NUM,
117: creation_date OKC_TIME_TPG_NAMED_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
118: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
119: last_update_date OKC_TIME_TPG_NAMED_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
120: last_update_login NUMBER := OKC_API.G_MISS_NUM);
121: g_miss_tgnv_rec tgnv_rec_type;
122: TYPE tgnv_tbl_type IS TABLE OF tgnv_rec_type

Line 119: last_update_date OKC_TIME_TPG_NAMED_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,

115: attribute15 OKC_TIME_TPG_NAMED_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
116: created_by NUMBER := OKC_API.G_MISS_NUM,
117: creation_date OKC_TIME_TPG_NAMED_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
118: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
119: last_update_date OKC_TIME_TPG_NAMED_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
120: last_update_login NUMBER := OKC_API.G_MISS_NUM);
121: g_miss_tgnv_rec tgnv_rec_type;
122: TYPE tgnv_tbl_type IS TABLE OF tgnv_rec_type
123: INDEX BY BINARY_INTEGER;

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

116: created_by NUMBER := OKC_API.G_MISS_NUM,
117: creation_date OKC_TIME_TPG_NAMED_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
118: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
119: last_update_date OKC_TIME_TPG_NAMED_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
120: last_update_login NUMBER := OKC_API.G_MISS_NUM);
121: g_miss_tgnv_rec tgnv_rec_type;
122: TYPE tgnv_tbl_type IS TABLE OF tgnv_rec_type
123: INDEX BY BINARY_INTEGER;
124: ---------------------------------------------------------------------------

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 151: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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

Line 160: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

156: x_tgnv_rec OUT NOCOPY tgnv_rec_type);
157:
158: PROCEDURE insert_row(
159: p_api_version IN NUMBER,
160: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
161: x_return_status OUT NOCOPY VARCHAR2,
162: x_msg_count OUT NOCOPY NUMBER,
163: x_msg_data OUT NOCOPY VARCHAR2,
164: p_tgnv_tbl IN tgnv_tbl_type,

Line 169: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

165: x_tgnv_tbl OUT NOCOPY tgnv_tbl_type);
166:
167: PROCEDURE lock_row(
168: p_api_version IN NUMBER,
169: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
170: x_return_status OUT NOCOPY VARCHAR2,
171: x_msg_count OUT NOCOPY NUMBER,
172: x_msg_data OUT NOCOPY VARCHAR2,
173: p_tgnv_rec IN tgnv_rec_type);

Line 177: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

173: p_tgnv_rec IN tgnv_rec_type);
174:
175: PROCEDURE lock_row(
176: p_api_version IN NUMBER,
177: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
178: x_return_status OUT NOCOPY VARCHAR2,
179: x_msg_count OUT NOCOPY NUMBER,
180: x_msg_data OUT NOCOPY VARCHAR2,
181: p_tgnv_tbl IN tgnv_tbl_type);

Line 185: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

181: p_tgnv_tbl IN tgnv_tbl_type);
182:
183: PROCEDURE update_row(
184: p_api_version IN NUMBER,
185: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
186: x_return_status OUT NOCOPY VARCHAR2,
187: x_msg_count OUT NOCOPY NUMBER,
188: x_msg_data OUT NOCOPY VARCHAR2,
189: p_tgnv_rec IN tgnv_rec_type,

Line 194: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

190: x_tgnv_rec OUT NOCOPY tgnv_rec_type);
191:
192: PROCEDURE update_row(
193: p_api_version IN NUMBER,
194: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
195: x_return_status OUT NOCOPY VARCHAR2,
196: x_msg_count OUT NOCOPY NUMBER,
197: x_msg_data OUT NOCOPY VARCHAR2,
198: p_tgnv_tbl IN tgnv_tbl_type,

Line 203: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

199: x_tgnv_tbl OUT NOCOPY tgnv_tbl_type);
200:
201: PROCEDURE delete_row(
202: p_api_version IN NUMBER,
203: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
204: x_return_status OUT NOCOPY VARCHAR2,
205: x_msg_count OUT NOCOPY NUMBER,
206: x_msg_data OUT NOCOPY VARCHAR2,
207: p_tgnv_rec IN tgnv_rec_type);

Line 211: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

207: p_tgnv_rec IN tgnv_rec_type);
208:
209: PROCEDURE delete_row(
210: p_api_version IN NUMBER,
211: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
212: x_return_status OUT NOCOPY VARCHAR2,
213: x_msg_count OUT NOCOPY NUMBER,
214: x_msg_data OUT NOCOPY VARCHAR2,
215: p_tgnv_tbl IN tgnv_tbl_type);

Line 219: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

215: p_tgnv_tbl IN tgnv_tbl_type);
216:
217: PROCEDURE validate_row(
218: p_api_version IN NUMBER,
219: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
220: x_return_status OUT NOCOPY VARCHAR2,
221: x_msg_count OUT NOCOPY NUMBER,
222: x_msg_data OUT NOCOPY VARCHAR2,
223: p_tgnv_rec IN tgnv_rec_type);

Line 227: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

223: p_tgnv_rec IN tgnv_rec_type);
224:
225: PROCEDURE validate_row(
226: p_api_version IN NUMBER,
227: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
228: x_return_status OUT NOCOPY VARCHAR2,
229: x_msg_count OUT NOCOPY NUMBER,
230: x_msg_data OUT NOCOPY VARCHAR2,
231: p_tgnv_tbl IN tgnv_tbl_type);