3: ---------------------------------------------------------------------------
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE ove_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: opt_id NUMBER := OKC_API.G_MISS_NUM,
9: value OKL_OPT_VALUES.VALUE%TYPE := OKC_API.G_MISS_CHAR,
10: object_version_number NUMBER := OKC_API.G_MISS_NUM,
11: description OKL_OPT_VALUES.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE ove_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: opt_id NUMBER := OKC_API.G_MISS_NUM,
9: value OKL_OPT_VALUES.VALUE%TYPE := OKC_API.G_MISS_CHAR,
10: object_version_number NUMBER := OKC_API.G_MISS_NUM,
11: description OKL_OPT_VALUES.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
12: from_date OKL_OPT_VALUES.FROM_DATE%TYPE := OKC_API.G_MISS_DATE,
5: ---------------------------------------------------------------------------
6: TYPE ove_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: opt_id NUMBER := OKC_API.G_MISS_NUM,
9: value OKL_OPT_VALUES.VALUE%TYPE := OKC_API.G_MISS_CHAR,
10: object_version_number NUMBER := OKC_API.G_MISS_NUM,
11: description OKL_OPT_VALUES.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
12: from_date OKL_OPT_VALUES.FROM_DATE%TYPE := OKC_API.G_MISS_DATE,
13: to_date OKL_OPT_VALUES.TO_DATE%TYPE := OKC_API.G_MISS_DATE,
6: TYPE ove_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: opt_id NUMBER := OKC_API.G_MISS_NUM,
9: value OKL_OPT_VALUES.VALUE%TYPE := OKC_API.G_MISS_CHAR,
10: object_version_number NUMBER := OKC_API.G_MISS_NUM,
11: description OKL_OPT_VALUES.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
12: from_date OKL_OPT_VALUES.FROM_DATE%TYPE := OKC_API.G_MISS_DATE,
13: to_date OKL_OPT_VALUES.TO_DATE%TYPE := OKC_API.G_MISS_DATE,
14: created_by NUMBER := OKC_API.G_MISS_NUM,
7: id NUMBER := OKC_API.G_MISS_NUM,
8: opt_id NUMBER := OKC_API.G_MISS_NUM,
9: value OKL_OPT_VALUES.VALUE%TYPE := OKC_API.G_MISS_CHAR,
10: object_version_number NUMBER := OKC_API.G_MISS_NUM,
11: description OKL_OPT_VALUES.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
12: from_date OKL_OPT_VALUES.FROM_DATE%TYPE := OKC_API.G_MISS_DATE,
13: to_date OKL_OPT_VALUES.TO_DATE%TYPE := OKC_API.G_MISS_DATE,
14: created_by NUMBER := OKC_API.G_MISS_NUM,
15: creation_date OKL_OPT_VALUES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
8: opt_id NUMBER := OKC_API.G_MISS_NUM,
9: value OKL_OPT_VALUES.VALUE%TYPE := OKC_API.G_MISS_CHAR,
10: object_version_number NUMBER := OKC_API.G_MISS_NUM,
11: description OKL_OPT_VALUES.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
12: from_date OKL_OPT_VALUES.FROM_DATE%TYPE := OKC_API.G_MISS_DATE,
13: to_date OKL_OPT_VALUES.TO_DATE%TYPE := OKC_API.G_MISS_DATE,
14: created_by NUMBER := OKC_API.G_MISS_NUM,
15: creation_date OKL_OPT_VALUES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
16: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
9: value OKL_OPT_VALUES.VALUE%TYPE := OKC_API.G_MISS_CHAR,
10: object_version_number NUMBER := OKC_API.G_MISS_NUM,
11: description OKL_OPT_VALUES.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
12: from_date OKL_OPT_VALUES.FROM_DATE%TYPE := OKC_API.G_MISS_DATE,
13: to_date OKL_OPT_VALUES.TO_DATE%TYPE := OKC_API.G_MISS_DATE,
14: created_by NUMBER := OKC_API.G_MISS_NUM,
15: creation_date OKL_OPT_VALUES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
16: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
17: last_update_date OKL_OPT_VALUES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
10: object_version_number NUMBER := OKC_API.G_MISS_NUM,
11: description OKL_OPT_VALUES.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
12: from_date OKL_OPT_VALUES.FROM_DATE%TYPE := OKC_API.G_MISS_DATE,
13: to_date OKL_OPT_VALUES.TO_DATE%TYPE := OKC_API.G_MISS_DATE,
14: created_by NUMBER := OKC_API.G_MISS_NUM,
15: creation_date OKL_OPT_VALUES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
16: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
17: last_update_date OKL_OPT_VALUES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
18: last_update_login NUMBER := OKC_API.G_MISS_NUM);
11: description OKL_OPT_VALUES.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
12: from_date OKL_OPT_VALUES.FROM_DATE%TYPE := OKC_API.G_MISS_DATE,
13: to_date OKL_OPT_VALUES.TO_DATE%TYPE := OKC_API.G_MISS_DATE,
14: created_by NUMBER := OKC_API.G_MISS_NUM,
15: creation_date OKL_OPT_VALUES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
16: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
17: last_update_date OKL_OPT_VALUES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
18: last_update_login NUMBER := OKC_API.G_MISS_NUM);
19: g_miss_ove_rec ove_rec_type;
12: from_date OKL_OPT_VALUES.FROM_DATE%TYPE := OKC_API.G_MISS_DATE,
13: to_date OKL_OPT_VALUES.TO_DATE%TYPE := OKC_API.G_MISS_DATE,
14: created_by NUMBER := OKC_API.G_MISS_NUM,
15: creation_date OKL_OPT_VALUES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
16: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
17: last_update_date OKL_OPT_VALUES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
18: last_update_login NUMBER := OKC_API.G_MISS_NUM);
19: g_miss_ove_rec ove_rec_type;
20: TYPE ove_tbl_type IS TABLE OF ove_rec_type
13: to_date OKL_OPT_VALUES.TO_DATE%TYPE := OKC_API.G_MISS_DATE,
14: created_by NUMBER := OKC_API.G_MISS_NUM,
15: creation_date OKL_OPT_VALUES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
16: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
17: last_update_date OKL_OPT_VALUES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
18: last_update_login NUMBER := OKC_API.G_MISS_NUM);
19: g_miss_ove_rec ove_rec_type;
20: TYPE ove_tbl_type IS TABLE OF ove_rec_type
21: INDEX BY BINARY_INTEGER;
14: created_by NUMBER := OKC_API.G_MISS_NUM,
15: creation_date OKL_OPT_VALUES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
16: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
17: last_update_date OKL_OPT_VALUES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
18: last_update_login NUMBER := OKC_API.G_MISS_NUM);
19: g_miss_ove_rec ove_rec_type;
20: TYPE ove_tbl_type IS TABLE OF ove_rec_type
21: INDEX BY BINARY_INTEGER;
22: TYPE ovev_rec_type IS RECORD (
19: g_miss_ove_rec ove_rec_type;
20: TYPE ove_tbl_type IS TABLE OF ove_rec_type
21: INDEX BY BINARY_INTEGER;
22: TYPE ovev_rec_type IS RECORD (
23: id NUMBER := OKC_API.G_MISS_NUM,
24: object_version_number NUMBER := OKC_API.G_MISS_NUM,
25: opt_id NUMBER := OKC_API.G_MISS_NUM,
26: value OKL_OPT_VALUES_V.VALUE%TYPE := OKC_API.G_MISS_CHAR,
27: description OKL_OPT_VALUES_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
20: TYPE ove_tbl_type IS TABLE OF ove_rec_type
21: INDEX BY BINARY_INTEGER;
22: TYPE ovev_rec_type IS RECORD (
23: id NUMBER := OKC_API.G_MISS_NUM,
24: object_version_number NUMBER := OKC_API.G_MISS_NUM,
25: opt_id NUMBER := OKC_API.G_MISS_NUM,
26: value OKL_OPT_VALUES_V.VALUE%TYPE := OKC_API.G_MISS_CHAR,
27: description OKL_OPT_VALUES_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
28: from_date OKL_OPT_VALUES_V.FROM_DATE%TYPE := OKC_API.G_MISS_DATE,
21: INDEX BY BINARY_INTEGER;
22: TYPE ovev_rec_type IS RECORD (
23: id NUMBER := OKC_API.G_MISS_NUM,
24: object_version_number NUMBER := OKC_API.G_MISS_NUM,
25: opt_id NUMBER := OKC_API.G_MISS_NUM,
26: value OKL_OPT_VALUES_V.VALUE%TYPE := OKC_API.G_MISS_CHAR,
27: description OKL_OPT_VALUES_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
28: from_date OKL_OPT_VALUES_V.FROM_DATE%TYPE := OKC_API.G_MISS_DATE,
29: to_date OKL_OPT_VALUES_V.TO_DATE%TYPE := OKC_API.G_MISS_DATE,
22: TYPE ovev_rec_type IS RECORD (
23: id NUMBER := OKC_API.G_MISS_NUM,
24: object_version_number NUMBER := OKC_API.G_MISS_NUM,
25: opt_id NUMBER := OKC_API.G_MISS_NUM,
26: value OKL_OPT_VALUES_V.VALUE%TYPE := OKC_API.G_MISS_CHAR,
27: description OKL_OPT_VALUES_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
28: from_date OKL_OPT_VALUES_V.FROM_DATE%TYPE := OKC_API.G_MISS_DATE,
29: to_date OKL_OPT_VALUES_V.TO_DATE%TYPE := OKC_API.G_MISS_DATE,
30: created_by NUMBER := OKC_API.G_MISS_NUM,
23: id NUMBER := OKC_API.G_MISS_NUM,
24: object_version_number NUMBER := OKC_API.G_MISS_NUM,
25: opt_id NUMBER := OKC_API.G_MISS_NUM,
26: value OKL_OPT_VALUES_V.VALUE%TYPE := OKC_API.G_MISS_CHAR,
27: description OKL_OPT_VALUES_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
28: from_date OKL_OPT_VALUES_V.FROM_DATE%TYPE := OKC_API.G_MISS_DATE,
29: to_date OKL_OPT_VALUES_V.TO_DATE%TYPE := OKC_API.G_MISS_DATE,
30: created_by NUMBER := OKC_API.G_MISS_NUM,
31: creation_date OKL_OPT_VALUES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
24: object_version_number NUMBER := OKC_API.G_MISS_NUM,
25: opt_id NUMBER := OKC_API.G_MISS_NUM,
26: value OKL_OPT_VALUES_V.VALUE%TYPE := OKC_API.G_MISS_CHAR,
27: description OKL_OPT_VALUES_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
28: from_date OKL_OPT_VALUES_V.FROM_DATE%TYPE := OKC_API.G_MISS_DATE,
29: to_date OKL_OPT_VALUES_V.TO_DATE%TYPE := OKC_API.G_MISS_DATE,
30: created_by NUMBER := OKC_API.G_MISS_NUM,
31: creation_date OKL_OPT_VALUES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
32: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
25: opt_id NUMBER := OKC_API.G_MISS_NUM,
26: value OKL_OPT_VALUES_V.VALUE%TYPE := OKC_API.G_MISS_CHAR,
27: description OKL_OPT_VALUES_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
28: from_date OKL_OPT_VALUES_V.FROM_DATE%TYPE := OKC_API.G_MISS_DATE,
29: to_date OKL_OPT_VALUES_V.TO_DATE%TYPE := OKC_API.G_MISS_DATE,
30: created_by NUMBER := OKC_API.G_MISS_NUM,
31: creation_date OKL_OPT_VALUES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
32: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
33: last_update_date OKL_OPT_VALUES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
26: value OKL_OPT_VALUES_V.VALUE%TYPE := OKC_API.G_MISS_CHAR,
27: description OKL_OPT_VALUES_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
28: from_date OKL_OPT_VALUES_V.FROM_DATE%TYPE := OKC_API.G_MISS_DATE,
29: to_date OKL_OPT_VALUES_V.TO_DATE%TYPE := OKC_API.G_MISS_DATE,
30: created_by NUMBER := OKC_API.G_MISS_NUM,
31: creation_date OKL_OPT_VALUES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
32: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
33: last_update_date OKL_OPT_VALUES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
34: last_update_login NUMBER := OKC_API.G_MISS_NUM);
27: description OKL_OPT_VALUES_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
28: from_date OKL_OPT_VALUES_V.FROM_DATE%TYPE := OKC_API.G_MISS_DATE,
29: to_date OKL_OPT_VALUES_V.TO_DATE%TYPE := OKC_API.G_MISS_DATE,
30: created_by NUMBER := OKC_API.G_MISS_NUM,
31: creation_date OKL_OPT_VALUES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
32: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
33: last_update_date OKL_OPT_VALUES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
34: last_update_login NUMBER := OKC_API.G_MISS_NUM);
35: g_miss_ovev_rec ovev_rec_type;
28: from_date OKL_OPT_VALUES_V.FROM_DATE%TYPE := OKC_API.G_MISS_DATE,
29: to_date OKL_OPT_VALUES_V.TO_DATE%TYPE := OKC_API.G_MISS_DATE,
30: created_by NUMBER := OKC_API.G_MISS_NUM,
31: creation_date OKL_OPT_VALUES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
32: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
33: last_update_date OKL_OPT_VALUES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
34: last_update_login NUMBER := OKC_API.G_MISS_NUM);
35: g_miss_ovev_rec ovev_rec_type;
36: TYPE ovev_tbl_type IS TABLE OF ovev_rec_type
29: to_date OKL_OPT_VALUES_V.TO_DATE%TYPE := OKC_API.G_MISS_DATE,
30: created_by NUMBER := OKC_API.G_MISS_NUM,
31: creation_date OKL_OPT_VALUES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
32: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
33: last_update_date OKL_OPT_VALUES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
34: last_update_login NUMBER := OKC_API.G_MISS_NUM);
35: g_miss_ovev_rec ovev_rec_type;
36: TYPE ovev_tbl_type IS TABLE OF ovev_rec_type
37: INDEX BY BINARY_INTEGER;
30: created_by NUMBER := OKC_API.G_MISS_NUM,
31: creation_date OKL_OPT_VALUES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
32: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
33: last_update_date OKL_OPT_VALUES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
34: last_update_login NUMBER := OKC_API.G_MISS_NUM);
35: g_miss_ovev_rec ovev_rec_type;
36: TYPE ovev_tbl_type IS TABLE OF ovev_rec_type
37: INDEX BY BINARY_INTEGER;
38: ---------------------------------------------------------------------------
37: INDEX BY BINARY_INTEGER;
38: ---------------------------------------------------------------------------
39: -- GLOBAL MESSAGE CONSTANTS
40: ---------------------------------------------------------------------------
41: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
42: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
43: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
44: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
45: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
38: ---------------------------------------------------------------------------
39: -- GLOBAL MESSAGE CONSTANTS
40: ---------------------------------------------------------------------------
41: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
42: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
43: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
44: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
45: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
46: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
39: -- GLOBAL MESSAGE CONSTANTS
40: ---------------------------------------------------------------------------
41: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
42: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
43: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
44: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
45: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
46: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
47: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
40: ---------------------------------------------------------------------------
41: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
42: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
43: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
44: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
45: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
46: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
47: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
48: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
41: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
42: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
43: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
44: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
45: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
46: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
47: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
48: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
49: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
42: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
43: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
44: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
45: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
46: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
47: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
48: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
49: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
50: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
43: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
44: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
45: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
46: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
47: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
48: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
49: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
50: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
51: ------TCHGS BEGIN-------------------------------------------------------------
44: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
45: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
46: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
47: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
48: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
49: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
50: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
51: ------TCHGS BEGIN-------------------------------------------------------------
52: ---------------------------------------------------------------------------
45: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
46: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
47: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
48: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
49: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
50: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
51: ------TCHGS BEGIN-------------------------------------------------------------
52: ---------------------------------------------------------------------------
53: -- GLOBAL EXCEPTION
46: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
47: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
48: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
49: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
50: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
51: ------TCHGS BEGIN-------------------------------------------------------------
52: ---------------------------------------------------------------------------
53: -- GLOBAL EXCEPTION
54: ---------------------------------------------------------------------------
66: ------TCHGS END--------------------------------------------------------------- ---------------------------------------------------------------------------
67: -- GLOBAL VARIABLES
68: ---------------------------------------------------------------------------
69: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_OVE_PVT';
70: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
71: ---------------------------------------------------------------------------
72: -- Procedures and Functions
73: ---------------------------------------------------------------------------
74:
76: PROCEDURE change_version;
77: PROCEDURE api_copy;
78: PROCEDURE insert_row(
79: p_api_version IN NUMBER,
80: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
81: x_return_status OUT NOCOPY VARCHAR2,
82: x_msg_count OUT NOCOPY NUMBER,
83: x_msg_data OUT NOCOPY VARCHAR2,
84: p_ovev_rec IN ovev_rec_type,
85: x_ovev_rec OUT NOCOPY ovev_rec_type);
86:
87: PROCEDURE insert_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_ovev_tbl IN ovev_tbl_type,
94: x_ovev_tbl OUT NOCOPY ovev_tbl_type);
95:
96: PROCEDURE lock_row(
97: p_api_version IN NUMBER,
98: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
99: x_return_status OUT NOCOPY VARCHAR2,
100: x_msg_count OUT NOCOPY NUMBER,
101: x_msg_data OUT NOCOPY VARCHAR2,
102: p_ovev_rec IN ovev_rec_type);
102: p_ovev_rec IN ovev_rec_type);
103:
104: PROCEDURE lock_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_ovev_tbl IN ovev_tbl_type);
110: p_ovev_tbl IN ovev_tbl_type);
111:
112: PROCEDURE update_row(
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_ovev_rec IN ovev_rec_type,
119: x_ovev_rec OUT NOCOPY ovev_rec_type);
120:
121: PROCEDURE update_row(
122: p_api_version IN NUMBER,
123: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
124: x_return_status OUT NOCOPY VARCHAR2,
125: x_msg_count OUT NOCOPY NUMBER,
126: x_msg_data OUT NOCOPY VARCHAR2,
127: p_ovev_tbl IN ovev_tbl_type,
128: x_ovev_tbl OUT NOCOPY ovev_tbl_type);
129:
130: PROCEDURE delete_row(
131: p_api_version IN NUMBER,
132: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
133: x_return_status OUT NOCOPY VARCHAR2,
134: x_msg_count OUT NOCOPY NUMBER,
135: x_msg_data OUT NOCOPY VARCHAR2,
136: p_ovev_rec IN ovev_rec_type);
136: p_ovev_rec IN ovev_rec_type);
137:
138: PROCEDURE delete_row(
139: p_api_version IN NUMBER,
140: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
141: x_return_status OUT NOCOPY VARCHAR2,
142: x_msg_count OUT NOCOPY NUMBER,
143: x_msg_data OUT NOCOPY VARCHAR2,
144: p_ovev_tbl IN ovev_tbl_type);
144: p_ovev_tbl IN ovev_tbl_type);
145:
146: PROCEDURE validate_row(
147: p_api_version IN NUMBER,
148: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
149: x_return_status OUT NOCOPY VARCHAR2,
150: x_msg_count OUT NOCOPY NUMBER,
151: x_msg_data OUT NOCOPY VARCHAR2,
152: p_ovev_rec IN ovev_rec_type);
152: p_ovev_rec IN ovev_rec_type);
153:
154: PROCEDURE validate_row(
155: p_api_version IN NUMBER,
156: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
157: x_return_status OUT NOCOPY VARCHAR2,
158: x_msg_count OUT NOCOPY NUMBER,
159: x_msg_data OUT NOCOPY VARCHAR2,
160: p_ovev_tbl IN ovev_tbl_type);