3: ---------------------------------------------------------------------------
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE opn_rec_type IS RECORD (
7: code OKC_OPERATIONS_B.CODE%TYPE := OKC_API.G_MISS_CHAR,
8: opn_type OKC_OPERATIONS_B.OPN_TYPE%TYPE := OKC_API.G_MISS_CHAR,
9: object_version_number NUMBER := OKC_API.G_MISS_NUM,
10: created_by NUMBER := OKC_API.G_MISS_NUM,
11: creation_date OKC_OPERATIONS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE opn_rec_type IS RECORD (
7: code OKC_OPERATIONS_B.CODE%TYPE := OKC_API.G_MISS_CHAR,
8: opn_type OKC_OPERATIONS_B.OPN_TYPE%TYPE := OKC_API.G_MISS_CHAR,
9: object_version_number NUMBER := OKC_API.G_MISS_NUM,
10: created_by NUMBER := OKC_API.G_MISS_NUM,
11: creation_date OKC_OPERATIONS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
12: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
5: ---------------------------------------------------------------------------
6: TYPE opn_rec_type IS RECORD (
7: code OKC_OPERATIONS_B.CODE%TYPE := OKC_API.G_MISS_CHAR,
8: opn_type OKC_OPERATIONS_B.OPN_TYPE%TYPE := OKC_API.G_MISS_CHAR,
9: object_version_number NUMBER := OKC_API.G_MISS_NUM,
10: created_by NUMBER := OKC_API.G_MISS_NUM,
11: creation_date OKC_OPERATIONS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
12: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
13: last_update_date OKC_OPERATIONS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
6: TYPE opn_rec_type IS RECORD (
7: code OKC_OPERATIONS_B.CODE%TYPE := OKC_API.G_MISS_CHAR,
8: opn_type OKC_OPERATIONS_B.OPN_TYPE%TYPE := OKC_API.G_MISS_CHAR,
9: object_version_number NUMBER := OKC_API.G_MISS_NUM,
10: created_by NUMBER := OKC_API.G_MISS_NUM,
11: creation_date OKC_OPERATIONS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
12: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
13: last_update_date OKC_OPERATIONS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
14: last_update_login NUMBER := OKC_API.G_MISS_NUM,
7: code OKC_OPERATIONS_B.CODE%TYPE := OKC_API.G_MISS_CHAR,
8: opn_type OKC_OPERATIONS_B.OPN_TYPE%TYPE := OKC_API.G_MISS_CHAR,
9: object_version_number NUMBER := OKC_API.G_MISS_NUM,
10: created_by NUMBER := OKC_API.G_MISS_NUM,
11: creation_date OKC_OPERATIONS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
12: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
13: last_update_date OKC_OPERATIONS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
14: last_update_login NUMBER := OKC_API.G_MISS_NUM,
15: purpose OKC_OPERATIONS_B.PURPOSE%TYPE := OKC_API.G_MISS_CHAR);
8: opn_type OKC_OPERATIONS_B.OPN_TYPE%TYPE := OKC_API.G_MISS_CHAR,
9: object_version_number NUMBER := OKC_API.G_MISS_NUM,
10: created_by NUMBER := OKC_API.G_MISS_NUM,
11: creation_date OKC_OPERATIONS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
12: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
13: last_update_date OKC_OPERATIONS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
14: last_update_login NUMBER := OKC_API.G_MISS_NUM,
15: purpose OKC_OPERATIONS_B.PURPOSE%TYPE := OKC_API.G_MISS_CHAR);
16: g_miss_opn_rec opn_rec_type;
9: object_version_number NUMBER := OKC_API.G_MISS_NUM,
10: created_by NUMBER := OKC_API.G_MISS_NUM,
11: creation_date OKC_OPERATIONS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
12: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
13: last_update_date OKC_OPERATIONS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
14: last_update_login NUMBER := OKC_API.G_MISS_NUM,
15: purpose OKC_OPERATIONS_B.PURPOSE%TYPE := OKC_API.G_MISS_CHAR);
16: g_miss_opn_rec opn_rec_type;
17: TYPE opn_tbl_type IS TABLE OF opn_rec_type
10: created_by NUMBER := OKC_API.G_MISS_NUM,
11: creation_date OKC_OPERATIONS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
12: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
13: last_update_date OKC_OPERATIONS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
14: last_update_login NUMBER := OKC_API.G_MISS_NUM,
15: purpose OKC_OPERATIONS_B.PURPOSE%TYPE := OKC_API.G_MISS_CHAR);
16: g_miss_opn_rec opn_rec_type;
17: TYPE opn_tbl_type IS TABLE OF opn_rec_type
18: INDEX BY BINARY_INTEGER;
11: creation_date OKC_OPERATIONS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
12: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
13: last_update_date OKC_OPERATIONS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
14: last_update_login NUMBER := OKC_API.G_MISS_NUM,
15: purpose OKC_OPERATIONS_B.PURPOSE%TYPE := OKC_API.G_MISS_CHAR);
16: g_miss_opn_rec opn_rec_type;
17: TYPE opn_tbl_type IS TABLE OF opn_rec_type
18: INDEX BY BINARY_INTEGER;
19: TYPE okc_operations_tl_rec_type IS RECORD (
16: g_miss_opn_rec opn_rec_type;
17: TYPE opn_tbl_type IS TABLE OF opn_rec_type
18: INDEX BY BINARY_INTEGER;
19: TYPE okc_operations_tl_rec_type IS RECORD (
20: code OKC_OPERATIONS_TL.CODE%TYPE := OKC_API.G_MISS_CHAR,
21: language OKC_OPERATIONS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
22: source_lang OKC_OPERATIONS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
23: sfwt_flag OKC_OPERATIONS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
24: meaning OKC_OPERATIONS_TL.MEANING%TYPE := OKC_API.G_MISS_CHAR,
17: TYPE opn_tbl_type IS TABLE OF opn_rec_type
18: INDEX BY BINARY_INTEGER;
19: TYPE okc_operations_tl_rec_type IS RECORD (
20: code OKC_OPERATIONS_TL.CODE%TYPE := OKC_API.G_MISS_CHAR,
21: language OKC_OPERATIONS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
22: source_lang OKC_OPERATIONS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
23: sfwt_flag OKC_OPERATIONS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
24: meaning OKC_OPERATIONS_TL.MEANING%TYPE := OKC_API.G_MISS_CHAR,
25: description OKC_OPERATIONS_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
18: INDEX BY BINARY_INTEGER;
19: TYPE okc_operations_tl_rec_type IS RECORD (
20: code OKC_OPERATIONS_TL.CODE%TYPE := OKC_API.G_MISS_CHAR,
21: language OKC_OPERATIONS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
22: source_lang OKC_OPERATIONS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
23: sfwt_flag OKC_OPERATIONS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
24: meaning OKC_OPERATIONS_TL.MEANING%TYPE := OKC_API.G_MISS_CHAR,
25: description OKC_OPERATIONS_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
26: opn_type OKC_OPERATIONS_TL.OPN_TYPE%TYPE := OKC_API.G_MISS_CHAR,
19: TYPE okc_operations_tl_rec_type IS RECORD (
20: code OKC_OPERATIONS_TL.CODE%TYPE := OKC_API.G_MISS_CHAR,
21: language OKC_OPERATIONS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
22: source_lang OKC_OPERATIONS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
23: sfwt_flag OKC_OPERATIONS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
24: meaning OKC_OPERATIONS_TL.MEANING%TYPE := OKC_API.G_MISS_CHAR,
25: description OKC_OPERATIONS_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
26: opn_type OKC_OPERATIONS_TL.OPN_TYPE%TYPE := OKC_API.G_MISS_CHAR,
27: created_by NUMBER := OKC_API.G_MISS_NUM,
20: code OKC_OPERATIONS_TL.CODE%TYPE := OKC_API.G_MISS_CHAR,
21: language OKC_OPERATIONS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
22: source_lang OKC_OPERATIONS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
23: sfwt_flag OKC_OPERATIONS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
24: meaning OKC_OPERATIONS_TL.MEANING%TYPE := OKC_API.G_MISS_CHAR,
25: description OKC_OPERATIONS_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
26: opn_type OKC_OPERATIONS_TL.OPN_TYPE%TYPE := OKC_API.G_MISS_CHAR,
27: created_by NUMBER := OKC_API.G_MISS_NUM,
28: creation_date OKC_OPERATIONS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
21: language OKC_OPERATIONS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
22: source_lang OKC_OPERATIONS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
23: sfwt_flag OKC_OPERATIONS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
24: meaning OKC_OPERATIONS_TL.MEANING%TYPE := OKC_API.G_MISS_CHAR,
25: description OKC_OPERATIONS_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
26: opn_type OKC_OPERATIONS_TL.OPN_TYPE%TYPE := OKC_API.G_MISS_CHAR,
27: created_by NUMBER := OKC_API.G_MISS_NUM,
28: creation_date OKC_OPERATIONS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
29: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
22: source_lang OKC_OPERATIONS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
23: sfwt_flag OKC_OPERATIONS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
24: meaning OKC_OPERATIONS_TL.MEANING%TYPE := OKC_API.G_MISS_CHAR,
25: description OKC_OPERATIONS_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
26: opn_type OKC_OPERATIONS_TL.OPN_TYPE%TYPE := OKC_API.G_MISS_CHAR,
27: created_by NUMBER := OKC_API.G_MISS_NUM,
28: creation_date OKC_OPERATIONS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
29: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
30: last_update_date OKC_OPERATIONS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
23: sfwt_flag OKC_OPERATIONS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
24: meaning OKC_OPERATIONS_TL.MEANING%TYPE := OKC_API.G_MISS_CHAR,
25: description OKC_OPERATIONS_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
26: opn_type OKC_OPERATIONS_TL.OPN_TYPE%TYPE := OKC_API.G_MISS_CHAR,
27: created_by NUMBER := OKC_API.G_MISS_NUM,
28: creation_date OKC_OPERATIONS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
29: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
30: last_update_date OKC_OPERATIONS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
31: last_update_login NUMBER := OKC_API.G_MISS_NUM);
24: meaning OKC_OPERATIONS_TL.MEANING%TYPE := OKC_API.G_MISS_CHAR,
25: description OKC_OPERATIONS_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
26: opn_type OKC_OPERATIONS_TL.OPN_TYPE%TYPE := OKC_API.G_MISS_CHAR,
27: created_by NUMBER := OKC_API.G_MISS_NUM,
28: creation_date OKC_OPERATIONS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
29: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
30: last_update_date OKC_OPERATIONS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
31: last_update_login NUMBER := OKC_API.G_MISS_NUM);
32: g_miss_okc_operations_tl_rec okc_operations_tl_rec_type;
25: description OKC_OPERATIONS_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
26: opn_type OKC_OPERATIONS_TL.OPN_TYPE%TYPE := OKC_API.G_MISS_CHAR,
27: created_by NUMBER := OKC_API.G_MISS_NUM,
28: creation_date OKC_OPERATIONS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
29: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
30: last_update_date OKC_OPERATIONS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
31: last_update_login NUMBER := OKC_API.G_MISS_NUM);
32: g_miss_okc_operations_tl_rec okc_operations_tl_rec_type;
33: TYPE okc_operations_tl_tbl_type IS TABLE OF okc_operations_tl_rec_type
26: opn_type OKC_OPERATIONS_TL.OPN_TYPE%TYPE := OKC_API.G_MISS_CHAR,
27: created_by NUMBER := OKC_API.G_MISS_NUM,
28: creation_date OKC_OPERATIONS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
29: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
30: last_update_date OKC_OPERATIONS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
31: last_update_login NUMBER := OKC_API.G_MISS_NUM);
32: g_miss_okc_operations_tl_rec okc_operations_tl_rec_type;
33: TYPE okc_operations_tl_tbl_type IS TABLE OF okc_operations_tl_rec_type
34: INDEX BY BINARY_INTEGER;
27: created_by NUMBER := OKC_API.G_MISS_NUM,
28: creation_date OKC_OPERATIONS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
29: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
30: last_update_date OKC_OPERATIONS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
31: last_update_login NUMBER := OKC_API.G_MISS_NUM);
32: g_miss_okc_operations_tl_rec okc_operations_tl_rec_type;
33: TYPE okc_operations_tl_tbl_type IS TABLE OF okc_operations_tl_rec_type
34: INDEX BY BINARY_INTEGER;
35: TYPE opnv_rec_type IS RECORD (
32: g_miss_okc_operations_tl_rec okc_operations_tl_rec_type;
33: TYPE okc_operations_tl_tbl_type IS TABLE OF okc_operations_tl_rec_type
34: INDEX BY BINARY_INTEGER;
35: TYPE opnv_rec_type IS RECORD (
36: code OKC_OPERATIONS_V.CODE%TYPE := OKC_API.G_MISS_CHAR,
37: object_version_number NUMBER := OKC_API.G_MISS_NUM,
38: sfwt_flag OKC_OPERATIONS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
39: meaning OKC_OPERATIONS_V.MEANING%TYPE := OKC_API.G_MISS_CHAR,
40: description OKC_OPERATIONS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
33: TYPE okc_operations_tl_tbl_type IS TABLE OF okc_operations_tl_rec_type
34: INDEX BY BINARY_INTEGER;
35: TYPE opnv_rec_type IS RECORD (
36: code OKC_OPERATIONS_V.CODE%TYPE := OKC_API.G_MISS_CHAR,
37: object_version_number NUMBER := OKC_API.G_MISS_NUM,
38: sfwt_flag OKC_OPERATIONS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
39: meaning OKC_OPERATIONS_V.MEANING%TYPE := OKC_API.G_MISS_CHAR,
40: description OKC_OPERATIONS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
41: opn_type OKC_OPERATIONS_V.OPN_TYPE%TYPE := OKC_API.G_MISS_CHAR,
34: INDEX BY BINARY_INTEGER;
35: TYPE opnv_rec_type IS RECORD (
36: code OKC_OPERATIONS_V.CODE%TYPE := OKC_API.G_MISS_CHAR,
37: object_version_number NUMBER := OKC_API.G_MISS_NUM,
38: sfwt_flag OKC_OPERATIONS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
39: meaning OKC_OPERATIONS_V.MEANING%TYPE := OKC_API.G_MISS_CHAR,
40: description OKC_OPERATIONS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
41: opn_type OKC_OPERATIONS_V.OPN_TYPE%TYPE := OKC_API.G_MISS_CHAR,
42: created_by NUMBER := OKC_API.G_MISS_NUM,
35: TYPE opnv_rec_type IS RECORD (
36: code OKC_OPERATIONS_V.CODE%TYPE := OKC_API.G_MISS_CHAR,
37: object_version_number NUMBER := OKC_API.G_MISS_NUM,
38: sfwt_flag OKC_OPERATIONS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
39: meaning OKC_OPERATIONS_V.MEANING%TYPE := OKC_API.G_MISS_CHAR,
40: description OKC_OPERATIONS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
41: opn_type OKC_OPERATIONS_V.OPN_TYPE%TYPE := OKC_API.G_MISS_CHAR,
42: created_by NUMBER := OKC_API.G_MISS_NUM,
43: creation_date OKC_OPERATIONS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
36: code OKC_OPERATIONS_V.CODE%TYPE := OKC_API.G_MISS_CHAR,
37: object_version_number NUMBER := OKC_API.G_MISS_NUM,
38: sfwt_flag OKC_OPERATIONS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
39: meaning OKC_OPERATIONS_V.MEANING%TYPE := OKC_API.G_MISS_CHAR,
40: description OKC_OPERATIONS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
41: opn_type OKC_OPERATIONS_V.OPN_TYPE%TYPE := OKC_API.G_MISS_CHAR,
42: created_by NUMBER := OKC_API.G_MISS_NUM,
43: creation_date OKC_OPERATIONS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
44: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
37: object_version_number NUMBER := OKC_API.G_MISS_NUM,
38: sfwt_flag OKC_OPERATIONS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
39: meaning OKC_OPERATIONS_V.MEANING%TYPE := OKC_API.G_MISS_CHAR,
40: description OKC_OPERATIONS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
41: opn_type OKC_OPERATIONS_V.OPN_TYPE%TYPE := OKC_API.G_MISS_CHAR,
42: created_by NUMBER := OKC_API.G_MISS_NUM,
43: creation_date OKC_OPERATIONS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
44: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
45: last_update_date OKC_OPERATIONS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
38: sfwt_flag OKC_OPERATIONS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
39: meaning OKC_OPERATIONS_V.MEANING%TYPE := OKC_API.G_MISS_CHAR,
40: description OKC_OPERATIONS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
41: opn_type OKC_OPERATIONS_V.OPN_TYPE%TYPE := OKC_API.G_MISS_CHAR,
42: created_by NUMBER := OKC_API.G_MISS_NUM,
43: creation_date OKC_OPERATIONS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
44: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
45: last_update_date OKC_OPERATIONS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
46: last_update_login NUMBER := OKC_API.G_MISS_NUM,
39: meaning OKC_OPERATIONS_V.MEANING%TYPE := OKC_API.G_MISS_CHAR,
40: description OKC_OPERATIONS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
41: opn_type OKC_OPERATIONS_V.OPN_TYPE%TYPE := OKC_API.G_MISS_CHAR,
42: created_by NUMBER := OKC_API.G_MISS_NUM,
43: creation_date OKC_OPERATIONS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
44: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
45: last_update_date OKC_OPERATIONS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
46: last_update_login NUMBER := OKC_API.G_MISS_NUM,
47: purpose OKC_OPERATIONS_V.PURPOSE%TYPE := OKC_API.G_MISS_CHAR); -- Bug # 2171059
40: description OKC_OPERATIONS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
41: opn_type OKC_OPERATIONS_V.OPN_TYPE%TYPE := OKC_API.G_MISS_CHAR,
42: created_by NUMBER := OKC_API.G_MISS_NUM,
43: creation_date OKC_OPERATIONS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
44: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
45: last_update_date OKC_OPERATIONS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
46: last_update_login NUMBER := OKC_API.G_MISS_NUM,
47: purpose OKC_OPERATIONS_V.PURPOSE%TYPE := OKC_API.G_MISS_CHAR); -- Bug # 2171059
48: g_miss_opnv_rec opnv_rec_type;
41: opn_type OKC_OPERATIONS_V.OPN_TYPE%TYPE := OKC_API.G_MISS_CHAR,
42: created_by NUMBER := OKC_API.G_MISS_NUM,
43: creation_date OKC_OPERATIONS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
44: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
45: last_update_date OKC_OPERATIONS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
46: last_update_login NUMBER := OKC_API.G_MISS_NUM,
47: purpose OKC_OPERATIONS_V.PURPOSE%TYPE := OKC_API.G_MISS_CHAR); -- Bug # 2171059
48: g_miss_opnv_rec opnv_rec_type;
49: TYPE opnv_tbl_type IS TABLE OF opnv_rec_type
42: created_by NUMBER := OKC_API.G_MISS_NUM,
43: creation_date OKC_OPERATIONS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
44: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
45: last_update_date OKC_OPERATIONS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
46: last_update_login NUMBER := OKC_API.G_MISS_NUM,
47: purpose OKC_OPERATIONS_V.PURPOSE%TYPE := OKC_API.G_MISS_CHAR); -- Bug # 2171059
48: g_miss_opnv_rec opnv_rec_type;
49: TYPE opnv_tbl_type IS TABLE OF opnv_rec_type
50: INDEX BY BINARY_INTEGER;
43: creation_date OKC_OPERATIONS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
44: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
45: last_update_date OKC_OPERATIONS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
46: last_update_login NUMBER := OKC_API.G_MISS_NUM,
47: purpose OKC_OPERATIONS_V.PURPOSE%TYPE := OKC_API.G_MISS_CHAR); -- Bug # 2171059
48: g_miss_opnv_rec opnv_rec_type;
49: TYPE opnv_tbl_type IS TABLE OF opnv_rec_type
50: INDEX BY BINARY_INTEGER;
51: ---------------------------------------------------------------------------
50: INDEX BY BINARY_INTEGER;
51: ---------------------------------------------------------------------------
52: -- GLOBAL MESSAGE CONSTANTS
53: ---------------------------------------------------------------------------
54: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
55: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
56: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
57: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
58: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
51: ---------------------------------------------------------------------------
52: -- GLOBAL MESSAGE CONSTANTS
53: ---------------------------------------------------------------------------
54: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
55: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
56: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
57: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
58: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
59: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
52: -- GLOBAL MESSAGE CONSTANTS
53: ---------------------------------------------------------------------------
54: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
55: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
56: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
57: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
58: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
59: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
60: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
53: ---------------------------------------------------------------------------
54: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
55: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
56: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
57: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
58: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
59: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
60: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
61: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
54: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
55: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
56: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
57: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
58: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
59: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
60: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
61: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
62: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
55: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
56: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
57: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
58: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
59: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
60: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
61: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
62: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
63: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
56: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
57: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
58: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
59: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
60: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
61: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
62: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
63: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
64: ---------------------------------------------------------------------------
57: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
58: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
59: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
60: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
61: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
62: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
63: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
64: ---------------------------------------------------------------------------
65: -- GLOBAL VARIABLES
58: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
59: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
60: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
61: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
62: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
63: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
64: ---------------------------------------------------------------------------
65: -- GLOBAL VARIABLES
66: ---------------------------------------------------------------------------
59: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
60: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
61: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
62: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
63: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
64: ---------------------------------------------------------------------------
65: -- GLOBAL VARIABLES
66: ---------------------------------------------------------------------------
67: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_OPN_PVT';
64: ---------------------------------------------------------------------------
65: -- GLOBAL VARIABLES
66: ---------------------------------------------------------------------------
67: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_OPN_PVT';
68: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
69: ---------------------------------------------------------------------------
70: -- Procedures and Functions
71: ---------------------------------------------------------------------------
72:
75: PROCEDURE api_copy;
76: PROCEDURE add_language;
77: PROCEDURE insert_row(
78: p_api_version IN NUMBER,
79: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
80: x_return_status OUT NOCOPY VARCHAR2,
81: x_msg_count OUT NOCOPY NUMBER,
82: x_msg_data OUT NOCOPY VARCHAR2,
83: p_opnv_rec IN opnv_rec_type,
84: x_opnv_rec OUT NOCOPY opnv_rec_type);
85:
86: PROCEDURE insert_row(
87: p_api_version IN NUMBER,
88: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
89: x_return_status OUT NOCOPY VARCHAR2,
90: x_msg_count OUT NOCOPY NUMBER,
91: x_msg_data OUT NOCOPY VARCHAR2,
92: p_opnv_tbl IN opnv_tbl_type,
93: x_opnv_tbl OUT NOCOPY opnv_tbl_type);
94:
95: PROCEDURE lock_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_opnv_rec IN opnv_rec_type);
101: p_opnv_rec IN opnv_rec_type);
102:
103: PROCEDURE lock_row(
104: p_api_version IN NUMBER,
105: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
106: x_return_status OUT NOCOPY VARCHAR2,
107: x_msg_count OUT NOCOPY NUMBER,
108: x_msg_data OUT NOCOPY VARCHAR2,
109: p_opnv_tbl IN opnv_tbl_type);
109: p_opnv_tbl IN opnv_tbl_type);
110:
111: PROCEDURE update_row(
112: p_api_version IN NUMBER,
113: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
114: x_return_status OUT NOCOPY VARCHAR2,
115: x_msg_count OUT NOCOPY NUMBER,
116: x_msg_data OUT NOCOPY VARCHAR2,
117: p_opnv_rec IN opnv_rec_type,
118: x_opnv_rec OUT NOCOPY opnv_rec_type);
119:
120: PROCEDURE update_row(
121: p_api_version IN NUMBER,
122: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
123: x_return_status OUT NOCOPY VARCHAR2,
124: x_msg_count OUT NOCOPY NUMBER,
125: x_msg_data OUT NOCOPY VARCHAR2,
126: p_opnv_tbl IN opnv_tbl_type,
127: x_opnv_tbl OUT NOCOPY opnv_tbl_type);
128:
129: PROCEDURE delete_row(
130: p_api_version IN NUMBER,
131: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
132: x_return_status OUT NOCOPY VARCHAR2,
133: x_msg_count OUT NOCOPY NUMBER,
134: x_msg_data OUT NOCOPY VARCHAR2,
135: p_opnv_rec IN opnv_rec_type);
135: p_opnv_rec IN opnv_rec_type);
136:
137: PROCEDURE delete_row(
138: p_api_version IN NUMBER,
139: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
140: x_return_status OUT NOCOPY VARCHAR2,
141: x_msg_count OUT NOCOPY NUMBER,
142: x_msg_data OUT NOCOPY VARCHAR2,
143: p_opnv_tbl IN opnv_tbl_type);
143: p_opnv_tbl IN opnv_tbl_type);
144:
145: PROCEDURE validate_row(
146: p_api_version IN NUMBER,
147: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
148: x_return_status OUT NOCOPY VARCHAR2,
149: x_msg_count OUT NOCOPY NUMBER,
150: x_msg_data OUT NOCOPY VARCHAR2,
151: p_opnv_rec IN opnv_rec_type);
151: p_opnv_rec IN opnv_rec_type);
152:
153: PROCEDURE validate_row(
154: p_api_version IN NUMBER,
155: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
156: x_return_status OUT NOCOPY VARCHAR2,
157: x_msg_count OUT NOCOPY NUMBER,
158: x_msg_data OUT NOCOPY VARCHAR2,
159: p_opnv_tbl IN opnv_tbl_type);