5: ---------------------------------------------------------------------------
6: -- Global transaction id
7: g_trans_id VARCHAR2(100) := 'XXX';
8:
9: TYPE okc_k_vers_numbers_h_rec_type IS RECORD (
10: chr_id NUMBER := OKC_API.G_MISS_NUM,
11: major_version NUMBER := OKC_API.G_MISS_NUM,
12: minor_version NUMBER := OKC_API.G_MISS_NUM,
13: object_version_number NUMBER := OKC_API.G_MISS_NUM,
11: major_version NUMBER := OKC_API.G_MISS_NUM,
12: minor_version NUMBER := OKC_API.G_MISS_NUM,
13: object_version_number NUMBER := OKC_API.G_MISS_NUM,
14: created_by NUMBER := OKC_API.G_MISS_NUM,
15: creation_date OKC_K_VERS_NUMBERS_H.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
16: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
17: last_update_date OKC_K_VERS_NUMBERS_H.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
18: last_update_login NUMBER := OKC_API.G_MISS_NUM);
19: GMissOkcKVersNumbersHRec okc_k_vers_numbers_h_rec_type;
13: object_version_number NUMBER := OKC_API.G_MISS_NUM,
14: created_by NUMBER := OKC_API.G_MISS_NUM,
15: creation_date OKC_K_VERS_NUMBERS_H.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
16: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
17: last_update_date OKC_K_VERS_NUMBERS_H.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
18: last_update_login NUMBER := OKC_API.G_MISS_NUM);
19: GMissOkcKVersNumbersHRec okc_k_vers_numbers_h_rec_type;
20: TYPE okc_k_vers_numbers_h_tbl_type IS TABLE OF okc_k_vers_numbers_h_rec_type
21: INDEX BY BINARY_INTEGER;
15: creation_date OKC_K_VERS_NUMBERS_H.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
16: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
17: last_update_date OKC_K_VERS_NUMBERS_H.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
18: last_update_login NUMBER := OKC_API.G_MISS_NUM);
19: GMissOkcKVersNumbersHRec okc_k_vers_numbers_h_rec_type;
20: TYPE okc_k_vers_numbers_h_tbl_type IS TABLE OF okc_k_vers_numbers_h_rec_type
21: INDEX BY BINARY_INTEGER;
22: TYPE cvm_rec_type IS RECORD (
23: chr_id NUMBER := OKC_API.G_MISS_NUM,
16: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
17: last_update_date OKC_K_VERS_NUMBERS_H.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
18: last_update_login NUMBER := OKC_API.G_MISS_NUM);
19: GMissOkcKVersNumbersHRec okc_k_vers_numbers_h_rec_type;
20: TYPE okc_k_vers_numbers_h_tbl_type IS TABLE OF okc_k_vers_numbers_h_rec_type
21: INDEX BY BINARY_INTEGER;
22: TYPE cvm_rec_type IS RECORD (
23: chr_id NUMBER := OKC_API.G_MISS_NUM,
24: major_version NUMBER := OKC_API.G_MISS_NUM,
24: major_version NUMBER := OKC_API.G_MISS_NUM,
25: minor_version NUMBER := OKC_API.G_MISS_NUM,
26: object_version_number NUMBER := OKC_API.G_MISS_NUM,
27: created_by NUMBER := OKC_API.G_MISS_NUM,
28: creation_date OKC_K_VERS_NUMBERS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
29: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
30: last_update_date OKC_K_VERS_NUMBERS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
31: last_update_login NUMBER := OKC_API.G_MISS_NUM);
32: g_miss_cvm_rec cvm_rec_type;
26: object_version_number NUMBER := OKC_API.G_MISS_NUM,
27: created_by NUMBER := OKC_API.G_MISS_NUM,
28: creation_date OKC_K_VERS_NUMBERS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
29: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
30: last_update_date OKC_K_VERS_NUMBERS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
31: last_update_login NUMBER := OKC_API.G_MISS_NUM);
32: g_miss_cvm_rec cvm_rec_type;
33: TYPE cvm_tbl_type IS TABLE OF cvm_rec_type
34: INDEX BY BINARY_INTEGER;
37: object_version_number NUMBER := OKC_API.G_MISS_NUM,
38: major_version NUMBER := OKC_API.G_MISS_NUM,
39: minor_version NUMBER := OKC_API.G_MISS_NUM,
40: created_by NUMBER := OKC_API.G_MISS_NUM,
41: creation_date OKC_K_VERS_NUMBERS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
42: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
43: last_update_date OKC_K_VERS_NUMBERS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
44: last_update_login NUMBER := OKC_API.G_MISS_NUM);
45: g_miss_cvmv_rec cvmv_rec_type;
39: minor_version NUMBER := OKC_API.G_MISS_NUM,
40: created_by NUMBER := OKC_API.G_MISS_NUM,
41: creation_date OKC_K_VERS_NUMBERS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
42: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
43: last_update_date OKC_K_VERS_NUMBERS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
44: last_update_login NUMBER := OKC_API.G_MISS_NUM);
45: g_miss_cvmv_rec cvmv_rec_type;
46: TYPE cvmv_tbl_type IS TABLE OF cvmv_rec_type
47: INDEX BY BINARY_INTEGER;