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,