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,
14: created_by NUMBER := OKC_API.G_MISS_NUM,
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,
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,
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,
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,
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,
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,
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,
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);
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;
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;
20: TYPE okc_k_vers_numbers_h_tbl_type IS TABLE OF 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;
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;
22: TYPE cvm_rec_type IS RECORD (
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,
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,
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,
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,
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,
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,
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,
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,
23: chr_id 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);
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;
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;
33: TYPE cvm_tbl_type IS TABLE OF 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;
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;
35: TYPE cvmv_rec_type IS RECORD (
32: g_miss_cvm_rec cvm_rec_type;
33: TYPE cvm_tbl_type IS TABLE OF cvm_rec_type
34: INDEX BY BINARY_INTEGER;
35: TYPE cvmv_rec_type IS RECORD (
36: chr_id NUMBER := OKC_API.G_MISS_NUM,
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,
33: TYPE cvm_tbl_type IS TABLE OF cvm_rec_type
34: INDEX BY BINARY_INTEGER;
35: TYPE cvmv_rec_type IS RECORD (
36: chr_id NUMBER := OKC_API.G_MISS_NUM,
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,
34: INDEX BY BINARY_INTEGER;
35: TYPE cvmv_rec_type IS RECORD (
36: chr_id NUMBER := OKC_API.G_MISS_NUM,
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,
35: TYPE cvmv_rec_type IS RECORD (
36: chr_id NUMBER := OKC_API.G_MISS_NUM,
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,
36: chr_id NUMBER := OKC_API.G_MISS_NUM,
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);
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;
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;
46: TYPE cvmv_tbl_type IS TABLE OF 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;
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;
48: ---------------------------------------------------------------------------
47: INDEX BY BINARY_INTEGER;
48: ---------------------------------------------------------------------------
49: -- GLOBAL MESSAGE CONSTANTS
50: ---------------------------------------------------------------------------
51: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
52: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
53: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
54: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
55: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
48: ---------------------------------------------------------------------------
49: -- GLOBAL MESSAGE CONSTANTS
50: ---------------------------------------------------------------------------
51: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
52: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
53: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
54: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
55: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
56: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
49: -- GLOBAL MESSAGE CONSTANTS
50: ---------------------------------------------------------------------------
51: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
52: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
53: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
54: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
55: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
56: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
57: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
50: ---------------------------------------------------------------------------
51: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
52: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
53: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
54: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
55: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
56: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
57: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
58: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
51: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
52: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
53: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
54: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
55: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
56: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
57: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
58: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
59: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
52: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
53: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
54: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
55: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
56: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
57: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
58: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
59: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
60: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
53: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
54: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
55: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
56: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
57: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
58: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
59: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
60: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
61: ---------------------------------------------------------------------------
54: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
55: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
56: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
57: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
58: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
59: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
60: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
61: ---------------------------------------------------------------------------
62: -- GLOBAL VARIABLES
55: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
56: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
57: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
58: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
59: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
60: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
61: ---------------------------------------------------------------------------
62: -- GLOBAL VARIABLES
63: ---------------------------------------------------------------------------
56: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
57: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
58: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
59: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
60: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
61: ---------------------------------------------------------------------------
62: -- GLOBAL VARIABLES
63: ---------------------------------------------------------------------------
64: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_CVM_PVT';
61: ---------------------------------------------------------------------------
62: -- GLOBAL VARIABLES
63: ---------------------------------------------------------------------------
64: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_CVM_PVT';
65: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
66: ---------------------------------------------------------------------------
67: -- Procedures and Functions
68: ---------------------------------------------------------------------------
69:
68: ---------------------------------------------------------------------------
69:
70: PROCEDURE insert_row(
71: p_api_version IN NUMBER,
72: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
73: x_return_status OUT NOCOPY VARCHAR2,
74: x_msg_count OUT NOCOPY NUMBER,
75: x_msg_data OUT NOCOPY VARCHAR2,
76: p_cvmv_rec IN cvmv_rec_type,
77: x_cvmv_rec OUT NOCOPY cvmv_rec_type);
78:
79: PROCEDURE lock_row(
80: p_api_version IN NUMBER,
81: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
82: x_return_status OUT NOCOPY VARCHAR2,
83: x_msg_count OUT NOCOPY NUMBER,
84: x_msg_data OUT NOCOPY VARCHAR2,
85: p_cvmv_rec IN cvmv_rec_type);
85: p_cvmv_rec IN cvmv_rec_type);
86:
87: PROCEDURE lock_row(
88: p_api_version IN NUMBER,
89: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
90: x_return_status OUT NOCOPY VARCHAR2,
91: x_msg_count OUT NOCOPY NUMBER,
92: x_msg_data OUT NOCOPY VARCHAR2,
93: p_cvmv_tbl IN cvmv_tbl_type);
93: p_cvmv_tbl IN cvmv_tbl_type);
94:
95: PROCEDURE update_row(
96: p_api_version IN NUMBER,
97: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
98: x_return_status OUT NOCOPY VARCHAR2,
99: x_msg_count OUT NOCOPY NUMBER,
100: x_msg_data OUT NOCOPY VARCHAR2,
101: p_cvmv_rec IN cvmv_rec_type,
102: x_cvmv_rec OUT NOCOPY cvmv_rec_type);
103:
104: PROCEDURE delete_row(
105: p_api_version IN NUMBER,
106: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
107: x_return_status OUT NOCOPY VARCHAR2,
108: x_msg_count OUT NOCOPY NUMBER,
109: x_msg_data OUT NOCOPY VARCHAR2,
110: p_cvmv_rec IN cvmv_rec_type);
110: p_cvmv_rec IN cvmv_rec_type);
111:
112: PROCEDURE create_contract_version(
113: p_api_version IN NUMBER,
114: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
115: x_return_status OUT NOCOPY VARCHAR2,
116: x_msg_count OUT NOCOPY NUMBER,
117: x_msg_data OUT NOCOPY VARCHAR2,
118: p_cvmv_rec IN cvmv_rec_type,
120:
121:
122: PROCEDURE update_contract_version(
123: p_api_version IN NUMBER,
124: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
125: x_return_status OUT NOCOPY VARCHAR2,
126: x_msg_count OUT NOCOPY NUMBER,
127: x_msg_data OUT NOCOPY VARCHAR2,
128: p_cvmv_rec IN cvmv_rec_type,
129: x_cvmv_rec OUT NOCOPY cvmv_rec_type);
130:
131: PROCEDURE version_contract_version(
132: p_api_version IN NUMBER,
133: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
134: x_return_status OUT NOCOPY VARCHAR2,
135: x_msg_count OUT NOCOPY NUMBER,
136: x_msg_data OUT NOCOPY VARCHAR2,
137: p_cvmv_rec IN cvmv_rec_type,
138: x_cvmv_rec OUT NOCOPY cvmv_rec_type);
139:
140: PROCEDURE delete_contract_version(
141: p_api_version IN NUMBER,
142: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
143: x_return_status OUT NOCOPY VARCHAR2,
144: x_msg_count OUT NOCOPY NUMBER,
145: x_msg_data OUT NOCOPY VARCHAR2,
146: p_cvmv_rec IN cvmv_rec_type);