DBA Data[Home] [Help]

APPS.OKC_IGS_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: tve_id_started 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: tve_id_started NUMBER := OKC_API.G_MISS_NUM,
20: tve_id_ended 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: tve_id_started NUMBER := OKC_API.G_MISS_NUM,
20: tve_id_ended NUMBER := OKC_API.G_MISS_NUM,
21: tve_id_limited NUMBER := OKC_API.G_MISS_NUM,

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: tve_id_started NUMBER := OKC_API.G_MISS_NUM,
20: tve_id_ended NUMBER := OKC_API.G_MISS_NUM,
21: tve_id_limited NUMBER := OKC_API.G_MISS_NUM,
22: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,

Line 19: tve_id_started NUMBER := OKC_API.G_MISS_NUM,

15: tve_id_offset NUMBER := OKC_API.G_MISS_NUM,
16: uom_code OKC_TIMEVALUES.uom_code%TYPE := OKC_API.G_MISS_CHAR,
17: cnh_id NUMBER := OKC_API.G_MISS_NUM,
18: tve_id_generated_by NUMBER := OKC_API.G_MISS_NUM,
19: tve_id_started NUMBER := OKC_API.G_MISS_NUM,
20: tve_id_ended NUMBER := OKC_API.G_MISS_NUM,
21: tve_id_limited NUMBER := OKC_API.G_MISS_NUM,
22: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
23: tze_id NUMBER := OKC_API.G_MISS_NUM,

Line 20: tve_id_ended NUMBER := OKC_API.G_MISS_NUM,

16: uom_code OKC_TIMEVALUES.uom_code%TYPE := OKC_API.G_MISS_CHAR,
17: cnh_id NUMBER := OKC_API.G_MISS_NUM,
18: tve_id_generated_by NUMBER := OKC_API.G_MISS_NUM,
19: tve_id_started NUMBER := OKC_API.G_MISS_NUM,
20: tve_id_ended NUMBER := OKC_API.G_MISS_NUM,
21: tve_id_limited NUMBER := OKC_API.G_MISS_NUM,
22: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
23: tze_id NUMBER := OKC_API.G_MISS_NUM,
24: tve_type OKC_TIMEVALUES.TVE_TYPE%TYPE := OKC_API.G_MISS_CHAR,

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: tve_id_started NUMBER := OKC_API.G_MISS_NUM,
20: tve_id_ended NUMBER := OKC_API.G_MISS_NUM,
21: tve_id_limited NUMBER := OKC_API.G_MISS_NUM,
22: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
23: tze_id NUMBER := OKC_API.G_MISS_NUM,
24: tve_type OKC_TIMEVALUES.TVE_TYPE%TYPE := OKC_API.G_MISS_CHAR,
25: object_version_number NUMBER := OKC_API.G_MISS_NUM,

Line 22: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,

18: tve_id_generated_by NUMBER := OKC_API.G_MISS_NUM,
19: tve_id_started NUMBER := OKC_API.G_MISS_NUM,
20: tve_id_ended NUMBER := OKC_API.G_MISS_NUM,
21: tve_id_limited NUMBER := OKC_API.G_MISS_NUM,
22: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
23: tze_id NUMBER := OKC_API.G_MISS_NUM,
24: tve_type OKC_TIMEVALUES.TVE_TYPE%TYPE := OKC_API.G_MISS_CHAR,
25: object_version_number NUMBER := OKC_API.G_MISS_NUM,
26: created_by NUMBER := OKC_API.G_MISS_NUM,

Line 23: tze_id NUMBER := OKC_API.G_MISS_NUM,

19: tve_id_started NUMBER := OKC_API.G_MISS_NUM,
20: tve_id_ended NUMBER := OKC_API.G_MISS_NUM,
21: tve_id_limited NUMBER := OKC_API.G_MISS_NUM,
22: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
23: tze_id NUMBER := OKC_API.G_MISS_NUM,
24: tve_type OKC_TIMEVALUES.TVE_TYPE%TYPE := OKC_API.G_MISS_CHAR,
25: object_version_number NUMBER := OKC_API.G_MISS_NUM,
26: created_by NUMBER := OKC_API.G_MISS_NUM,
27: creation_date OKC_TIMEVALUES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,

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

20: tve_id_ended NUMBER := OKC_API.G_MISS_NUM,
21: tve_id_limited NUMBER := OKC_API.G_MISS_NUM,
22: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
23: tze_id NUMBER := OKC_API.G_MISS_NUM,
24: tve_type OKC_TIMEVALUES.TVE_TYPE%TYPE := OKC_API.G_MISS_CHAR,
25: object_version_number NUMBER := OKC_API.G_MISS_NUM,
26: created_by NUMBER := OKC_API.G_MISS_NUM,
27: creation_date OKC_TIMEVALUES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
28: last_updated_by NUMBER := OKC_API.G_MISS_NUM,

Line 25: object_version_number NUMBER := OKC_API.G_MISS_NUM,

21: tve_id_limited NUMBER := OKC_API.G_MISS_NUM,
22: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
23: tze_id NUMBER := OKC_API.G_MISS_NUM,
24: tve_type OKC_TIMEVALUES.TVE_TYPE%TYPE := OKC_API.G_MISS_CHAR,
25: object_version_number NUMBER := OKC_API.G_MISS_NUM,
26: created_by NUMBER := OKC_API.G_MISS_NUM,
27: creation_date OKC_TIMEVALUES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
28: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
29: last_update_date OKC_TIMEVALUES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,

Line 26: created_by NUMBER := OKC_API.G_MISS_NUM,

22: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
23: tze_id NUMBER := OKC_API.G_MISS_NUM,
24: tve_type OKC_TIMEVALUES.TVE_TYPE%TYPE := OKC_API.G_MISS_CHAR,
25: object_version_number NUMBER := OKC_API.G_MISS_NUM,
26: created_by NUMBER := OKC_API.G_MISS_NUM,
27: creation_date OKC_TIMEVALUES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
28: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
29: last_update_date OKC_TIMEVALUES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
30: duration NUMBER := OKC_API.G_MISS_NUM,

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

23: tze_id NUMBER := OKC_API.G_MISS_NUM,
24: tve_type OKC_TIMEVALUES.TVE_TYPE%TYPE := OKC_API.G_MISS_CHAR,
25: object_version_number NUMBER := OKC_API.G_MISS_NUM,
26: created_by NUMBER := OKC_API.G_MISS_NUM,
27: creation_date OKC_TIMEVALUES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
28: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
29: last_update_date OKC_TIMEVALUES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
30: duration NUMBER := OKC_API.G_MISS_NUM,
31: operator OKC_TIMEVALUES.OPERATOR%TYPE := OKC_API.G_MISS_CHAR,

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: attribute_category OKC_TIMEVALUES.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,

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: attribute_category OKC_TIMEVALUES.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
44: --Bug 3122962

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: attribute_category OKC_TIMEVALUES.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
44: --Bug 3122962
45: description OKC_TIMEVALUES.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: attribute_category OKC_TIMEVALUES.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
44: --Bug 3122962
45: description OKC_TIMEVALUES.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
46: short_description OKC_TIMEVALUES.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,

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

39: nth NUMBER := OKC_API.G_MISS_NUM,
40: day_of_week OKC_TIMEVALUES.DAY_OF_WEEK%TYPE := OKC_API.G_MISS_CHAR,
41: interval_yn OKC_TIMEVALUES.INTERVAL_YN%TYPE := OKC_API.G_MISS_CHAR,
42: last_update_login NUMBER := OKC_API.G_MISS_NUM,
43: attribute_category OKC_TIMEVALUES.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
44: --Bug 3122962
45: description OKC_TIMEVALUES.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
46: short_description OKC_TIMEVALUES.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
47: comments OKC_TIMEVALUES.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,

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

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

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

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

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

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

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

46: short_description OKC_TIMEVALUES.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
47: comments OKC_TIMEVALUES.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
48: name OKC_TIMEVALUES.NAME%TYPE := OKC_API.G_MISS_CHAR,
49:
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: comments OKC_TIMEVALUES.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
48: name OKC_TIMEVALUES.NAME%TYPE := OKC_API.G_MISS_CHAR,
49:
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: name OKC_TIMEVALUES.NAME%TYPE := OKC_API.G_MISS_CHAR,
49:
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:
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 igsv_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_IG_STARTEND_V.SFWT_FLAG%TYPE := 'N',
93: tve_id_started 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 igsv_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_IG_STARTEND_V.SFWT_FLAG%TYPE := 'N',
93: tve_id_started NUMBER := OKC_API.G_MISS_NUM,
94: tve_id_ended NUMBER := OKC_API.G_MISS_NUM,

Line 93: tve_id_started 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_IG_STARTEND_V.SFWT_FLAG%TYPE := 'N',
93: tve_id_started NUMBER := OKC_API.G_MISS_NUM,
94: tve_id_ended NUMBER := OKC_API.G_MISS_NUM,
95: tve_id_limited NUMBER := OKC_API.G_MISS_NUM,
96: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
97: tze_id NUMBER := OKC_API.G_MISS_NUM,

Line 94: tve_id_ended NUMBER := OKC_API.G_MISS_NUM,

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

Line 95: tve_id_limited NUMBER := OKC_API.G_MISS_NUM,

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

Line 96: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,

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

Line 97: tze_id NUMBER := OKC_API.G_MISS_NUM,

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

Line 98: description OKC_TIME_IG_STARTEND_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,

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

Line 99: short_description OKC_TIME_IG_STARTEND_V.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,

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

Line 100: comments OKC_TIME_IG_STARTEND_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,

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

Line 101: attribute_category OKC_TIME_IG_STARTEND_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,

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

Line 102: attribute1 OKC_TIME_IG_STARTEND_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,

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

Line 103: attribute2 OKC_TIME_IG_STARTEND_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,

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

Line 104: attribute3 OKC_TIME_IG_STARTEND_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,

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

Line 105: attribute4 OKC_TIME_IG_STARTEND_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,

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

Line 106: attribute5 OKC_TIME_IG_STARTEND_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,

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

Line 107: attribute6 OKC_TIME_IG_STARTEND_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,

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

Line 108: attribute7 OKC_TIME_IG_STARTEND_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,

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

Line 109: attribute8 OKC_TIME_IG_STARTEND_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,

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

Line 110: attribute9 OKC_TIME_IG_STARTEND_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,

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

Line 111: attribute10 OKC_TIME_IG_STARTEND_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,

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

Line 112: attribute11 OKC_TIME_IG_STARTEND_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,

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

Line 113: attribute12 OKC_TIME_IG_STARTEND_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,

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

Line 114: attribute13 OKC_TIME_IG_STARTEND_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,

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

Line 115: attribute14 OKC_TIME_IG_STARTEND_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,

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

Line 116: attribute15 OKC_TIME_IG_STARTEND_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,

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

Line 117: created_by NUMBER := OKC_API.G_MISS_NUM,

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

Line 118: creation_date OKC_TIME_IG_STARTEND_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,

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

Line 119: last_updated_by NUMBER := OKC_API.G_MISS_NUM,

115: attribute14 OKC_TIME_IG_STARTEND_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
116: attribute15 OKC_TIME_IG_STARTEND_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
117: created_by NUMBER := OKC_API.G_MISS_NUM,
118: creation_date OKC_TIME_IG_STARTEND_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
119: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
120: last_update_date OKC_TIME_IG_STARTEND_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
121: last_update_login NUMBER := OKC_API.G_MISS_NUM);
122: g_miss_igsv_rec igsv_rec_type;
123: TYPE igsv_tbl_type IS TABLE OF igsv_rec_type

Line 120: last_update_date OKC_TIME_IG_STARTEND_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,

116: attribute15 OKC_TIME_IG_STARTEND_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
117: created_by NUMBER := OKC_API.G_MISS_NUM,
118: creation_date OKC_TIME_IG_STARTEND_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
119: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
120: last_update_date OKC_TIME_IG_STARTEND_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
121: last_update_login NUMBER := OKC_API.G_MISS_NUM);
122: g_miss_igsv_rec igsv_rec_type;
123: TYPE igsv_tbl_type IS TABLE OF igsv_rec_type
124: INDEX BY BINARY_INTEGER;

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

117: created_by NUMBER := OKC_API.G_MISS_NUM,
118: creation_date OKC_TIME_IG_STARTEND_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
119: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
120: last_update_date OKC_TIME_IG_STARTEND_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
121: last_update_login NUMBER := OKC_API.G_MISS_NUM);
122: g_miss_igsv_rec igsv_rec_type;
123: TYPE igsv_tbl_type IS TABLE OF igsv_rec_type
124: INDEX BY BINARY_INTEGER;
125: ---------------------------------------------------------------------------

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 152: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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

Line 161: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

157: x_igsv_rec OUT NOCOPY igsv_rec_type);
158:
159: PROCEDURE insert_row(
160: p_api_version IN NUMBER,
161: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
162: x_return_status OUT NOCOPY VARCHAR2,
163: x_msg_count OUT NOCOPY NUMBER,
164: x_msg_data OUT NOCOPY VARCHAR2,
165: p_igsv_tbl IN igsv_tbl_type,

Line 170: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

166: x_igsv_tbl OUT NOCOPY igsv_tbl_type);
167:
168: PROCEDURE lock_row(
169: p_api_version IN NUMBER,
170: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
171: x_return_status OUT NOCOPY VARCHAR2,
172: x_msg_count OUT NOCOPY NUMBER,
173: x_msg_data OUT NOCOPY VARCHAR2,
174: p_igsv_rec IN igsv_rec_type);

Line 178: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

174: p_igsv_rec IN igsv_rec_type);
175:
176: PROCEDURE lock_row(
177: p_api_version IN NUMBER,
178: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
179: x_return_status OUT NOCOPY VARCHAR2,
180: x_msg_count OUT NOCOPY NUMBER,
181: x_msg_data OUT NOCOPY VARCHAR2,
182: p_igsv_tbl IN igsv_tbl_type);

Line 186: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

182: p_igsv_tbl IN igsv_tbl_type);
183:
184: PROCEDURE update_row(
185: p_api_version IN NUMBER,
186: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
187: x_return_status OUT NOCOPY VARCHAR2,
188: x_msg_count OUT NOCOPY NUMBER,
189: x_msg_data OUT NOCOPY VARCHAR2,
190: p_igsv_rec IN igsv_rec_type,

Line 195: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

191: x_igsv_rec OUT NOCOPY igsv_rec_type);
192:
193: PROCEDURE update_row(
194: p_api_version IN NUMBER,
195: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
196: x_return_status OUT NOCOPY VARCHAR2,
197: x_msg_count OUT NOCOPY NUMBER,
198: x_msg_data OUT NOCOPY VARCHAR2,
199: p_igsv_tbl IN igsv_tbl_type,

Line 204: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

200: x_igsv_tbl OUT NOCOPY igsv_tbl_type);
201:
202: PROCEDURE delete_row(
203: p_api_version IN NUMBER,
204: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
205: x_return_status OUT NOCOPY VARCHAR2,
206: x_msg_count OUT NOCOPY NUMBER,
207: x_msg_data OUT NOCOPY VARCHAR2,
208: p_igsv_rec IN igsv_rec_type);

Line 212: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

208: p_igsv_rec IN igsv_rec_type);
209:
210: PROCEDURE delete_row(
211: p_api_version IN NUMBER,
212: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
213: x_return_status OUT NOCOPY VARCHAR2,
214: x_msg_count OUT NOCOPY NUMBER,
215: x_msg_data OUT NOCOPY VARCHAR2,
216: p_igsv_tbl IN igsv_tbl_type);

Line 220: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

216: p_igsv_tbl IN igsv_tbl_type);
217:
218: PROCEDURE validate_row(
219: p_api_version IN NUMBER,
220: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
221: x_return_status OUT NOCOPY VARCHAR2,
222: x_msg_count OUT NOCOPY NUMBER,
223: x_msg_data OUT NOCOPY VARCHAR2,
224: p_igsv_rec IN igsv_rec_type);

Line 228: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

224: p_igsv_rec IN igsv_rec_type);
225:
226: PROCEDURE validate_row(
227: p_api_version IN NUMBER,
228: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
229: x_return_status OUT NOCOPY VARCHAR2,
230: x_msg_count OUT NOCOPY NUMBER,
231: x_msg_data OUT NOCOPY VARCHAR2,
232: p_igsv_tbl IN igsv_tbl_type);