4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: -- OKS_COVERAGE_TIMEZONES_V Record Spec
7: TYPE OksCoverageTimezonesVRecType IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,cle_id NUMBER := OKC_API.G_MISS_NUM
10: ,default_yn OKS_COVERAGE_TIMEZONES_V.DEFAULT_YN%TYPE := OKC_API.G_MISS_CHAR
11: ,timezone_id NUMBER := OKC_API.G_MISS_NUM
12: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
5: ---------------------------------------------------------------------------
6: -- OKS_COVERAGE_TIMEZONES_V Record Spec
7: TYPE OksCoverageTimezonesVRecType IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,cle_id NUMBER := OKC_API.G_MISS_NUM
10: ,default_yn OKS_COVERAGE_TIMEZONES_V.DEFAULT_YN%TYPE := OKC_API.G_MISS_CHAR
11: ,timezone_id NUMBER := OKC_API.G_MISS_NUM
12: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
13: ,security_group_id NUMBER := OKC_API.G_MISS_NUM
6: -- OKS_COVERAGE_TIMEZONES_V Record Spec
7: TYPE OksCoverageTimezonesVRecType IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,cle_id NUMBER := OKC_API.G_MISS_NUM
10: ,default_yn OKS_COVERAGE_TIMEZONES_V.DEFAULT_YN%TYPE := OKC_API.G_MISS_CHAR
11: ,timezone_id NUMBER := OKC_API.G_MISS_NUM
12: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
13: ,security_group_id NUMBER := OKC_API.G_MISS_NUM
14: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
7: TYPE OksCoverageTimezonesVRecType IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,cle_id NUMBER := OKC_API.G_MISS_NUM
10: ,default_yn OKS_COVERAGE_TIMEZONES_V.DEFAULT_YN%TYPE := OKC_API.G_MISS_CHAR
11: ,timezone_id NUMBER := OKC_API.G_MISS_NUM
12: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
13: ,security_group_id NUMBER := OKC_API.G_MISS_NUM
14: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
15: ,program_id NUMBER := OKC_API.G_MISS_NUM
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,cle_id NUMBER := OKC_API.G_MISS_NUM
10: ,default_yn OKS_COVERAGE_TIMEZONES_V.DEFAULT_YN%TYPE := OKC_API.G_MISS_CHAR
11: ,timezone_id NUMBER := OKC_API.G_MISS_NUM
12: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
13: ,security_group_id NUMBER := OKC_API.G_MISS_NUM
14: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
15: ,program_id NUMBER := OKC_API.G_MISS_NUM
16: ,program_update_date OKS_COVERAGE_TIMEZONES_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
9: ,cle_id NUMBER := OKC_API.G_MISS_NUM
10: ,default_yn OKS_COVERAGE_TIMEZONES_V.DEFAULT_YN%TYPE := OKC_API.G_MISS_CHAR
11: ,timezone_id NUMBER := OKC_API.G_MISS_NUM
12: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
13: ,security_group_id NUMBER := OKC_API.G_MISS_NUM
14: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
15: ,program_id NUMBER := OKC_API.G_MISS_NUM
16: ,program_update_date OKS_COVERAGE_TIMEZONES_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
17: ,request_id NUMBER := OKC_API.G_MISS_NUM
10: ,default_yn OKS_COVERAGE_TIMEZONES_V.DEFAULT_YN%TYPE := OKC_API.G_MISS_CHAR
11: ,timezone_id NUMBER := OKC_API.G_MISS_NUM
12: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
13: ,security_group_id NUMBER := OKC_API.G_MISS_NUM
14: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
15: ,program_id NUMBER := OKC_API.G_MISS_NUM
16: ,program_update_date OKS_COVERAGE_TIMEZONES_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
17: ,request_id NUMBER := OKC_API.G_MISS_NUM
18: ,created_by NUMBER := OKC_API.G_MISS_NUM
11: ,timezone_id NUMBER := OKC_API.G_MISS_NUM
12: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
13: ,security_group_id NUMBER := OKC_API.G_MISS_NUM
14: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
15: ,program_id NUMBER := OKC_API.G_MISS_NUM
16: ,program_update_date OKS_COVERAGE_TIMEZONES_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
17: ,request_id NUMBER := OKC_API.G_MISS_NUM
18: ,created_by NUMBER := OKC_API.G_MISS_NUM
19: ,creation_date OKS_COVERAGE_TIMEZONES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
12: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
13: ,security_group_id NUMBER := OKC_API.G_MISS_NUM
14: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
15: ,program_id NUMBER := OKC_API.G_MISS_NUM
16: ,program_update_date OKS_COVERAGE_TIMEZONES_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
17: ,request_id NUMBER := OKC_API.G_MISS_NUM
18: ,created_by NUMBER := OKC_API.G_MISS_NUM
19: ,creation_date OKS_COVERAGE_TIMEZONES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
20: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
13: ,security_group_id NUMBER := OKC_API.G_MISS_NUM
14: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
15: ,program_id NUMBER := OKC_API.G_MISS_NUM
16: ,program_update_date OKS_COVERAGE_TIMEZONES_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
17: ,request_id NUMBER := OKC_API.G_MISS_NUM
18: ,created_by NUMBER := OKC_API.G_MISS_NUM
19: ,creation_date OKS_COVERAGE_TIMEZONES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
20: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
21: ,last_update_date OKS_COVERAGE_TIMEZONES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
14: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
15: ,program_id NUMBER := OKC_API.G_MISS_NUM
16: ,program_update_date OKS_COVERAGE_TIMEZONES_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
17: ,request_id NUMBER := OKC_API.G_MISS_NUM
18: ,created_by NUMBER := OKC_API.G_MISS_NUM
19: ,creation_date OKS_COVERAGE_TIMEZONES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
20: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
21: ,last_update_date OKS_COVERAGE_TIMEZONES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
22: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
15: ,program_id NUMBER := OKC_API.G_MISS_NUM
16: ,program_update_date OKS_COVERAGE_TIMEZONES_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
17: ,request_id NUMBER := OKC_API.G_MISS_NUM
18: ,created_by NUMBER := OKC_API.G_MISS_NUM
19: ,creation_date OKS_COVERAGE_TIMEZONES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
20: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
21: ,last_update_date OKS_COVERAGE_TIMEZONES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
22: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
23: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
16: ,program_update_date OKS_COVERAGE_TIMEZONES_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
17: ,request_id NUMBER := OKC_API.G_MISS_NUM
18: ,created_by NUMBER := OKC_API.G_MISS_NUM
19: ,creation_date OKS_COVERAGE_TIMEZONES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
20: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
21: ,last_update_date OKS_COVERAGE_TIMEZONES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
22: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
23: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
24: -- R12 Data Model Changes 4485150 Start
17: ,request_id NUMBER := OKC_API.G_MISS_NUM
18: ,created_by NUMBER := OKC_API.G_MISS_NUM
19: ,creation_date OKS_COVERAGE_TIMEZONES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
20: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
21: ,last_update_date OKS_COVERAGE_TIMEZONES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
22: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
23: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
24: -- R12 Data Model Changes 4485150 Start
25: ,orig_system_id1 NUMBER := OKC_API.G_MISS_NUM
18: ,created_by NUMBER := OKC_API.G_MISS_NUM
19: ,creation_date OKS_COVERAGE_TIMEZONES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
20: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
21: ,last_update_date OKS_COVERAGE_TIMEZONES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
22: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
23: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
24: -- R12 Data Model Changes 4485150 Start
25: ,orig_system_id1 NUMBER := OKC_API.G_MISS_NUM
26: ,orig_system_reference1 OKS_COVERAGE_TIMEZONES_V.ORIG_SYSTEM_REFERENCE1%TYPE := OKC_API.G_MISS_CHAR
19: ,creation_date OKS_COVERAGE_TIMEZONES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
20: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
21: ,last_update_date OKS_COVERAGE_TIMEZONES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
22: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
23: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
24: -- R12 Data Model Changes 4485150 Start
25: ,orig_system_id1 NUMBER := OKC_API.G_MISS_NUM
26: ,orig_system_reference1 OKS_COVERAGE_TIMEZONES_V.ORIG_SYSTEM_REFERENCE1%TYPE := OKC_API.G_MISS_CHAR
27: ,orig_system_source_code OKS_COVERAGE_TIMEZONES_V.ORIG_SYSTEM_SOURCE_CODE%TYPE := OKC_API.G_MISS_CHAR
21: ,last_update_date OKS_COVERAGE_TIMEZONES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
22: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
23: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
24: -- R12 Data Model Changes 4485150 Start
25: ,orig_system_id1 NUMBER := OKC_API.G_MISS_NUM
26: ,orig_system_reference1 OKS_COVERAGE_TIMEZONES_V.ORIG_SYSTEM_REFERENCE1%TYPE := OKC_API.G_MISS_CHAR
27: ,orig_system_source_code OKS_COVERAGE_TIMEZONES_V.ORIG_SYSTEM_SOURCE_CODE%TYPE := OKC_API.G_MISS_CHAR
28: -- R12 Data Model Changes 4485150 End
29: );
22: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
23: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
24: -- R12 Data Model Changes 4485150 Start
25: ,orig_system_id1 NUMBER := OKC_API.G_MISS_NUM
26: ,orig_system_reference1 OKS_COVERAGE_TIMEZONES_V.ORIG_SYSTEM_REFERENCE1%TYPE := OKC_API.G_MISS_CHAR
27: ,orig_system_source_code OKS_COVERAGE_TIMEZONES_V.ORIG_SYSTEM_SOURCE_CODE%TYPE := OKC_API.G_MISS_CHAR
28: -- R12 Data Model Changes 4485150 End
29: );
30: GMissOksCoverageTimezonesVRec OksCoverageTimezonesVRecType;
23: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
24: -- R12 Data Model Changes 4485150 Start
25: ,orig_system_id1 NUMBER := OKC_API.G_MISS_NUM
26: ,orig_system_reference1 OKS_COVERAGE_TIMEZONES_V.ORIG_SYSTEM_REFERENCE1%TYPE := OKC_API.G_MISS_CHAR
27: ,orig_system_source_code OKS_COVERAGE_TIMEZONES_V.ORIG_SYSTEM_SOURCE_CODE%TYPE := OKC_API.G_MISS_CHAR
28: -- R12 Data Model Changes 4485150 End
29: );
30: GMissOksCoverageTimezonesVRec OksCoverageTimezonesVRecType;
31: TYPE OksCoverageTimezonesVTblType IS TABLE OF OksCoverageTimezonesVRecType
31: TYPE OksCoverageTimezonesVTblType IS TABLE OF OksCoverageTimezonesVRecType
32: INDEX BY BINARY_INTEGER;
33: -- OKS_COVERAGE_TIMEZONES Record Spec
34: TYPE OksCoverageTimezonesRecType IS RECORD (
35: id NUMBER := OKC_API.G_MISS_NUM
36: ,cle_id NUMBER := OKC_API.G_MISS_NUM
37: ,default_yn OKS_COVERAGE_TIMEZONES.DEFAULT_YN%TYPE := OKC_API.G_MISS_CHAR
38: ,timezone_id NUMBER := OKC_API.G_MISS_NUM
39: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
32: INDEX BY BINARY_INTEGER;
33: -- OKS_COVERAGE_TIMEZONES Record Spec
34: TYPE OksCoverageTimezonesRecType IS RECORD (
35: id NUMBER := OKC_API.G_MISS_NUM
36: ,cle_id NUMBER := OKC_API.G_MISS_NUM
37: ,default_yn OKS_COVERAGE_TIMEZONES.DEFAULT_YN%TYPE := OKC_API.G_MISS_CHAR
38: ,timezone_id NUMBER := OKC_API.G_MISS_NUM
39: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
40: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
33: -- OKS_COVERAGE_TIMEZONES Record Spec
34: TYPE OksCoverageTimezonesRecType IS RECORD (
35: id NUMBER := OKC_API.G_MISS_NUM
36: ,cle_id NUMBER := OKC_API.G_MISS_NUM
37: ,default_yn OKS_COVERAGE_TIMEZONES.DEFAULT_YN%TYPE := OKC_API.G_MISS_CHAR
38: ,timezone_id NUMBER := OKC_API.G_MISS_NUM
39: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
40: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
41: ,program_id NUMBER := OKC_API.G_MISS_NUM
34: TYPE OksCoverageTimezonesRecType IS RECORD (
35: id NUMBER := OKC_API.G_MISS_NUM
36: ,cle_id NUMBER := OKC_API.G_MISS_NUM
37: ,default_yn OKS_COVERAGE_TIMEZONES.DEFAULT_YN%TYPE := OKC_API.G_MISS_CHAR
38: ,timezone_id NUMBER := OKC_API.G_MISS_NUM
39: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
40: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
41: ,program_id NUMBER := OKC_API.G_MISS_NUM
42: ,program_update_date OKS_COVERAGE_TIMEZONES.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
35: id NUMBER := OKC_API.G_MISS_NUM
36: ,cle_id NUMBER := OKC_API.G_MISS_NUM
37: ,default_yn OKS_COVERAGE_TIMEZONES.DEFAULT_YN%TYPE := OKC_API.G_MISS_CHAR
38: ,timezone_id NUMBER := OKC_API.G_MISS_NUM
39: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
40: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
41: ,program_id NUMBER := OKC_API.G_MISS_NUM
42: ,program_update_date OKS_COVERAGE_TIMEZONES.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
43: ,request_id NUMBER := OKC_API.G_MISS_NUM
36: ,cle_id NUMBER := OKC_API.G_MISS_NUM
37: ,default_yn OKS_COVERAGE_TIMEZONES.DEFAULT_YN%TYPE := OKC_API.G_MISS_CHAR
38: ,timezone_id NUMBER := OKC_API.G_MISS_NUM
39: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
40: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
41: ,program_id NUMBER := OKC_API.G_MISS_NUM
42: ,program_update_date OKS_COVERAGE_TIMEZONES.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
43: ,request_id NUMBER := OKC_API.G_MISS_NUM
44: ,created_by NUMBER := OKC_API.G_MISS_NUM
37: ,default_yn OKS_COVERAGE_TIMEZONES.DEFAULT_YN%TYPE := OKC_API.G_MISS_CHAR
38: ,timezone_id NUMBER := OKC_API.G_MISS_NUM
39: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
40: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
41: ,program_id NUMBER := OKC_API.G_MISS_NUM
42: ,program_update_date OKS_COVERAGE_TIMEZONES.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
43: ,request_id NUMBER := OKC_API.G_MISS_NUM
44: ,created_by NUMBER := OKC_API.G_MISS_NUM
45: ,creation_date OKS_COVERAGE_TIMEZONES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
38: ,timezone_id NUMBER := OKC_API.G_MISS_NUM
39: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
40: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
41: ,program_id NUMBER := OKC_API.G_MISS_NUM
42: ,program_update_date OKS_COVERAGE_TIMEZONES.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
43: ,request_id NUMBER := OKC_API.G_MISS_NUM
44: ,created_by NUMBER := OKC_API.G_MISS_NUM
45: ,creation_date OKS_COVERAGE_TIMEZONES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
46: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
39: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
40: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
41: ,program_id NUMBER := OKC_API.G_MISS_NUM
42: ,program_update_date OKS_COVERAGE_TIMEZONES.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
43: ,request_id NUMBER := OKC_API.G_MISS_NUM
44: ,created_by NUMBER := OKC_API.G_MISS_NUM
45: ,creation_date OKS_COVERAGE_TIMEZONES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
46: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
47: ,last_update_date OKS_COVERAGE_TIMEZONES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
40: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
41: ,program_id NUMBER := OKC_API.G_MISS_NUM
42: ,program_update_date OKS_COVERAGE_TIMEZONES.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
43: ,request_id NUMBER := OKC_API.G_MISS_NUM
44: ,created_by NUMBER := OKC_API.G_MISS_NUM
45: ,creation_date OKS_COVERAGE_TIMEZONES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
46: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
47: ,last_update_date OKS_COVERAGE_TIMEZONES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
48: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
41: ,program_id NUMBER := OKC_API.G_MISS_NUM
42: ,program_update_date OKS_COVERAGE_TIMEZONES.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
43: ,request_id NUMBER := OKC_API.G_MISS_NUM
44: ,created_by NUMBER := OKC_API.G_MISS_NUM
45: ,creation_date OKS_COVERAGE_TIMEZONES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
46: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
47: ,last_update_date OKS_COVERAGE_TIMEZONES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
48: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
49: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
42: ,program_update_date OKS_COVERAGE_TIMEZONES.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
43: ,request_id NUMBER := OKC_API.G_MISS_NUM
44: ,created_by NUMBER := OKC_API.G_MISS_NUM
45: ,creation_date OKS_COVERAGE_TIMEZONES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
46: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
47: ,last_update_date OKS_COVERAGE_TIMEZONES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
48: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
49: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
50: -- R12 Data Model Changes 4485150 Start
43: ,request_id NUMBER := OKC_API.G_MISS_NUM
44: ,created_by NUMBER := OKC_API.G_MISS_NUM
45: ,creation_date OKS_COVERAGE_TIMEZONES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
46: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
47: ,last_update_date OKS_COVERAGE_TIMEZONES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
48: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
49: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
50: -- R12 Data Model Changes 4485150 Start
51: ,orig_system_id1 NUMBER := OKC_API.G_MISS_NUM
44: ,created_by NUMBER := OKC_API.G_MISS_NUM
45: ,creation_date OKS_COVERAGE_TIMEZONES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
46: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
47: ,last_update_date OKS_COVERAGE_TIMEZONES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
48: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
49: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
50: -- R12 Data Model Changes 4485150 Start
51: ,orig_system_id1 NUMBER := OKC_API.G_MISS_NUM
52: ,orig_system_reference1 OKS_COVERAGE_TIMEZONES_V.ORIG_SYSTEM_REFERENCE1%TYPE := OKC_API.G_MISS_CHAR
45: ,creation_date OKS_COVERAGE_TIMEZONES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
46: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
47: ,last_update_date OKS_COVERAGE_TIMEZONES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
48: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
49: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
50: -- R12 Data Model Changes 4485150 Start
51: ,orig_system_id1 NUMBER := OKC_API.G_MISS_NUM
52: ,orig_system_reference1 OKS_COVERAGE_TIMEZONES_V.ORIG_SYSTEM_REFERENCE1%TYPE := OKC_API.G_MISS_CHAR
53: ,orig_system_source_code OKS_COVERAGE_TIMEZONES_V.ORIG_SYSTEM_SOURCE_CODE%TYPE := OKC_API.G_MISS_CHAR
47: ,last_update_date OKS_COVERAGE_TIMEZONES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
48: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
49: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
50: -- R12 Data Model Changes 4485150 Start
51: ,orig_system_id1 NUMBER := OKC_API.G_MISS_NUM
52: ,orig_system_reference1 OKS_COVERAGE_TIMEZONES_V.ORIG_SYSTEM_REFERENCE1%TYPE := OKC_API.G_MISS_CHAR
53: ,orig_system_source_code OKS_COVERAGE_TIMEZONES_V.ORIG_SYSTEM_SOURCE_CODE%TYPE := OKC_API.G_MISS_CHAR
54: -- R12 Data Model Changes 4485150 End
55: );
48: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
49: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
50: -- R12 Data Model Changes 4485150 Start
51: ,orig_system_id1 NUMBER := OKC_API.G_MISS_NUM
52: ,orig_system_reference1 OKS_COVERAGE_TIMEZONES_V.ORIG_SYSTEM_REFERENCE1%TYPE := OKC_API.G_MISS_CHAR
53: ,orig_system_source_code OKS_COVERAGE_TIMEZONES_V.ORIG_SYSTEM_SOURCE_CODE%TYPE := OKC_API.G_MISS_CHAR
54: -- R12 Data Model Changes 4485150 End
55: );
56: GMissOksCoverageTimezonesRec OksCoverageTimezonesRecType;
49: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
50: -- R12 Data Model Changes 4485150 Start
51: ,orig_system_id1 NUMBER := OKC_API.G_MISS_NUM
52: ,orig_system_reference1 OKS_COVERAGE_TIMEZONES_V.ORIG_SYSTEM_REFERENCE1%TYPE := OKC_API.G_MISS_CHAR
53: ,orig_system_source_code OKS_COVERAGE_TIMEZONES_V.ORIG_SYSTEM_SOURCE_CODE%TYPE := OKC_API.G_MISS_CHAR
54: -- R12 Data Model Changes 4485150 End
55: );
56: GMissOksCoverageTimezonesRec OksCoverageTimezonesRecType;
57: TYPE OksCoverageTimezonesTblType IS TABLE OF OksCoverageTimezonesRecType
58: INDEX BY BINARY_INTEGER;
59: ---------------------------------------------------------------------------
60: -- GLOBAL MESSAGE CONSTANTS
61: ---------------------------------------------------------------------------
62: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
63: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
64: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
65: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
66: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
59: ---------------------------------------------------------------------------
60: -- GLOBAL MESSAGE CONSTANTS
61: ---------------------------------------------------------------------------
62: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
63: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
64: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
65: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
66: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
67: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
60: -- GLOBAL MESSAGE CONSTANTS
61: ---------------------------------------------------------------------------
62: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
63: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
64: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
65: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
66: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
67: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
68: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
61: ---------------------------------------------------------------------------
62: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
63: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
64: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
65: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
66: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
67: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
68: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
69: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
62: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
63: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
64: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
65: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
66: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
67: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
68: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
69: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
70: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
63: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
64: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
65: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
66: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
67: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
68: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
69: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
70: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
71: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
64: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
65: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
66: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
67: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
68: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
69: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
70: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
71: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
72: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
65: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
66: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
67: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
68: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
69: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
70: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
71: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
72: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
73: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
66: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
67: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
68: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
69: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
70: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
71: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
72: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
73: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
74: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
67: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
68: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
69: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
70: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
71: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
72: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
73: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
74: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
75:
81: ---------------------------------------------------------------------------
82: -- GLOBAL VARIABLES
83: ---------------------------------------------------------------------------
84: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKS_CTZ_PVT';
85: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
86: ---------------------------------------------------------------------------
87: -- Procedures and Functions
88: ---------------------------------------------------------------------------
89:
105: x_msg_count OUT NOCOPY NUMBER,
106: x_msg_data OUT NOCOPY VARCHAR2,
107: p_oks_coverage_timezones_v_tbl IN OksCoverageTimezonesVTblType,
108: x_oks_coverage_timezones_v_tbl OUT NOCOPY OksCoverageTimezonesVTblType,
109: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
110: PROCEDURE insert_row(
111: p_api_version IN NUMBER,
112: p_init_msg_list IN VARCHAR2,
113: x_return_status OUT NOCOPY VARCHAR2,
128: x_return_status OUT NOCOPY VARCHAR2,
129: x_msg_count OUT NOCOPY NUMBER,
130: x_msg_data OUT NOCOPY VARCHAR2,
131: p_oks_coverage_timezones_v_tbl IN OksCoverageTimezonesVTblType,
132: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
133: PROCEDURE lock_row(
134: p_api_version IN NUMBER,
135: p_init_msg_list IN VARCHAR2,
136: x_return_status OUT NOCOPY VARCHAR2,
152: x_msg_count OUT NOCOPY NUMBER,
153: x_msg_data OUT NOCOPY VARCHAR2,
154: p_oks_coverage_timezones_v_tbl IN OksCoverageTimezonesVTblType,
155: x_oks_coverage_timezones_v_tbl OUT NOCOPY OksCoverageTimezonesVTblType,
156: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
157: PROCEDURE update_row(
158: p_api_version IN NUMBER,
159: p_init_msg_list IN VARCHAR2,
160: x_return_status OUT NOCOPY VARCHAR2,
175: x_return_status OUT NOCOPY VARCHAR2,
176: x_msg_count OUT NOCOPY NUMBER,
177: x_msg_data OUT NOCOPY VARCHAR2,
178: p_oks_coverage_timezones_v_tbl IN OksCoverageTimezonesVTblType,
179: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
180: PROCEDURE delete_row(
181: p_api_version IN NUMBER,
182: p_init_msg_list IN VARCHAR2,
183: x_return_status OUT NOCOPY VARCHAR2,
197: x_return_status OUT NOCOPY VARCHAR2,
198: x_msg_count OUT NOCOPY NUMBER,
199: x_msg_data OUT NOCOPY VARCHAR2,
200: p_oks_coverage_timezones_v_tbl IN OksCoverageTimezonesVTblType,
201: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
202: PROCEDURE validate_row(
203: p_api_version IN NUMBER,
204: p_init_msg_list IN VARCHAR2,
205: x_return_status OUT NOCOPY VARCHAR2,