3: ---------------------------------------------------------------------------
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE cls_rec_type IS RECORD (
7: code OKC_CLASSES_B.CODE%TYPE := OKC_API.G_MISS_CHAR,
8: fff_function_id NUMBER := OKC_API.G_MISS_NUM,
9: object_version_number NUMBER := OKC_API.G_MISS_NUM,
10: created_by NUMBER := OKC_API.G_MISS_NUM,
11: creation_date OKC_CLASSES_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE cls_rec_type IS RECORD (
7: code OKC_CLASSES_B.CODE%TYPE := OKC_API.G_MISS_CHAR,
8: fff_function_id NUMBER := OKC_API.G_MISS_NUM,
9: object_version_number NUMBER := OKC_API.G_MISS_NUM,
10: created_by NUMBER := OKC_API.G_MISS_NUM,
11: creation_date OKC_CLASSES_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
12: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
5: ---------------------------------------------------------------------------
6: TYPE cls_rec_type IS RECORD (
7: code OKC_CLASSES_B.CODE%TYPE := OKC_API.G_MISS_CHAR,
8: fff_function_id NUMBER := OKC_API.G_MISS_NUM,
9: object_version_number NUMBER := OKC_API.G_MISS_NUM,
10: created_by NUMBER := OKC_API.G_MISS_NUM,
11: creation_date OKC_CLASSES_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
12: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
13: last_update_date OKC_CLASSES_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
6: TYPE cls_rec_type IS RECORD (
7: code OKC_CLASSES_B.CODE%TYPE := OKC_API.G_MISS_CHAR,
8: fff_function_id NUMBER := OKC_API.G_MISS_NUM,
9: object_version_number NUMBER := OKC_API.G_MISS_NUM,
10: created_by NUMBER := OKC_API.G_MISS_NUM,
11: creation_date OKC_CLASSES_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
12: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
13: last_update_date OKC_CLASSES_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
14: last_update_login NUMBER := OKC_API.G_MISS_NUM,
7: code OKC_CLASSES_B.CODE%TYPE := OKC_API.G_MISS_CHAR,
8: fff_function_id NUMBER := OKC_API.G_MISS_NUM,
9: object_version_number NUMBER := OKC_API.G_MISS_NUM,
10: created_by NUMBER := OKC_API.G_MISS_NUM,
11: creation_date OKC_CLASSES_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
12: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
13: last_update_date OKC_CLASSES_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
14: last_update_login NUMBER := OKC_API.G_MISS_NUM,
15: application_id OKC_CLASSES_V.APPLICATION_ID%TYPE :=OKC_API.G_MISS_NUM,
8: fff_function_id NUMBER := OKC_API.G_MISS_NUM,
9: object_version_number NUMBER := OKC_API.G_MISS_NUM,
10: created_by NUMBER := OKC_API.G_MISS_NUM,
11: creation_date OKC_CLASSES_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
12: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
13: last_update_date OKC_CLASSES_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
14: last_update_login NUMBER := OKC_API.G_MISS_NUM,
15: application_id OKC_CLASSES_V.APPLICATION_ID%TYPE :=OKC_API.G_MISS_NUM,
16: adv_search_form_function_id OKC_CLASSES_V.ADV_SEARCH_FORM_FUNCTION_ID%TYPE := OKC_API.G_MISS_NUM );
9: object_version_number NUMBER := OKC_API.G_MISS_NUM,
10: created_by NUMBER := OKC_API.G_MISS_NUM,
11: creation_date OKC_CLASSES_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
12: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
13: last_update_date OKC_CLASSES_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
14: last_update_login NUMBER := OKC_API.G_MISS_NUM,
15: application_id OKC_CLASSES_V.APPLICATION_ID%TYPE :=OKC_API.G_MISS_NUM,
16: adv_search_form_function_id OKC_CLASSES_V.ADV_SEARCH_FORM_FUNCTION_ID%TYPE := OKC_API.G_MISS_NUM );
17: g_miss_cls_rec cls_rec_type;
10: created_by NUMBER := OKC_API.G_MISS_NUM,
11: creation_date OKC_CLASSES_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
12: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
13: last_update_date OKC_CLASSES_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
14: last_update_login NUMBER := OKC_API.G_MISS_NUM,
15: application_id OKC_CLASSES_V.APPLICATION_ID%TYPE :=OKC_API.G_MISS_NUM,
16: adv_search_form_function_id OKC_CLASSES_V.ADV_SEARCH_FORM_FUNCTION_ID%TYPE := OKC_API.G_MISS_NUM );
17: g_miss_cls_rec cls_rec_type;
18: TYPE cls_tbl_type IS TABLE OF cls_rec_type
11: creation_date OKC_CLASSES_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
12: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
13: last_update_date OKC_CLASSES_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
14: last_update_login NUMBER := OKC_API.G_MISS_NUM,
15: application_id OKC_CLASSES_V.APPLICATION_ID%TYPE :=OKC_API.G_MISS_NUM,
16: adv_search_form_function_id OKC_CLASSES_V.ADV_SEARCH_FORM_FUNCTION_ID%TYPE := OKC_API.G_MISS_NUM );
17: g_miss_cls_rec cls_rec_type;
18: TYPE cls_tbl_type IS TABLE OF cls_rec_type
19: INDEX BY BINARY_INTEGER;
12: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
13: last_update_date OKC_CLASSES_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
14: last_update_login NUMBER := OKC_API.G_MISS_NUM,
15: application_id OKC_CLASSES_V.APPLICATION_ID%TYPE :=OKC_API.G_MISS_NUM,
16: adv_search_form_function_id OKC_CLASSES_V.ADV_SEARCH_FORM_FUNCTION_ID%TYPE := OKC_API.G_MISS_NUM );
17: g_miss_cls_rec cls_rec_type;
18: TYPE cls_tbl_type IS TABLE OF cls_rec_type
19: INDEX BY BINARY_INTEGER;
20: TYPE okc_classes_tl_rec_type IS RECORD (
17: g_miss_cls_rec cls_rec_type;
18: TYPE cls_tbl_type IS TABLE OF cls_rec_type
19: INDEX BY BINARY_INTEGER;
20: TYPE okc_classes_tl_rec_type IS RECORD (
21: code OKC_CLASSES_TL.CODE%TYPE := OKC_API.G_MISS_CHAR,
22: language OKC_CLASSES_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
23: source_lang OKC_CLASSES_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
24: sfwt_flag OKC_CLASSES_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
25: meaning OKC_CLASSES_TL.MEANING%TYPE := OKC_API.G_MISS_CHAR,
18: TYPE cls_tbl_type IS TABLE OF cls_rec_type
19: INDEX BY BINARY_INTEGER;
20: TYPE okc_classes_tl_rec_type IS RECORD (
21: code OKC_CLASSES_TL.CODE%TYPE := OKC_API.G_MISS_CHAR,
22: language OKC_CLASSES_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
23: source_lang OKC_CLASSES_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
24: sfwt_flag OKC_CLASSES_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
25: meaning OKC_CLASSES_TL.MEANING%TYPE := OKC_API.G_MISS_CHAR,
26: description OKC_CLASSES_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
19: INDEX BY BINARY_INTEGER;
20: TYPE okc_classes_tl_rec_type IS RECORD (
21: code OKC_CLASSES_TL.CODE%TYPE := OKC_API.G_MISS_CHAR,
22: language OKC_CLASSES_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
23: source_lang OKC_CLASSES_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
24: sfwt_flag OKC_CLASSES_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
25: meaning OKC_CLASSES_TL.MEANING%TYPE := OKC_API.G_MISS_CHAR,
26: description OKC_CLASSES_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
27: created_by NUMBER := OKC_API.G_MISS_NUM,
20: TYPE okc_classes_tl_rec_type IS RECORD (
21: code OKC_CLASSES_TL.CODE%TYPE := OKC_API.G_MISS_CHAR,
22: language OKC_CLASSES_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
23: source_lang OKC_CLASSES_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
24: sfwt_flag OKC_CLASSES_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
25: meaning OKC_CLASSES_TL.MEANING%TYPE := OKC_API.G_MISS_CHAR,
26: description OKC_CLASSES_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
27: created_by NUMBER := OKC_API.G_MISS_NUM,
28: creation_date OKC_CLASSES_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
21: code OKC_CLASSES_TL.CODE%TYPE := OKC_API.G_MISS_CHAR,
22: language OKC_CLASSES_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
23: source_lang OKC_CLASSES_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
24: sfwt_flag OKC_CLASSES_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
25: meaning OKC_CLASSES_TL.MEANING%TYPE := OKC_API.G_MISS_CHAR,
26: description OKC_CLASSES_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
27: created_by NUMBER := OKC_API.G_MISS_NUM,
28: creation_date OKC_CLASSES_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
29: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
22: language OKC_CLASSES_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
23: source_lang OKC_CLASSES_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
24: sfwt_flag OKC_CLASSES_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
25: meaning OKC_CLASSES_TL.MEANING%TYPE := OKC_API.G_MISS_CHAR,
26: description OKC_CLASSES_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
27: created_by NUMBER := OKC_API.G_MISS_NUM,
28: creation_date OKC_CLASSES_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
29: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
30: last_update_date OKC_CLASSES_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
23: source_lang OKC_CLASSES_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
24: sfwt_flag OKC_CLASSES_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
25: meaning OKC_CLASSES_TL.MEANING%TYPE := OKC_API.G_MISS_CHAR,
26: description OKC_CLASSES_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
27: created_by NUMBER := OKC_API.G_MISS_NUM,
28: creation_date OKC_CLASSES_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
29: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
30: last_update_date OKC_CLASSES_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
31: last_update_login NUMBER := OKC_API.G_MISS_NUM);
24: sfwt_flag OKC_CLASSES_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
25: meaning OKC_CLASSES_TL.MEANING%TYPE := OKC_API.G_MISS_CHAR,
26: description OKC_CLASSES_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
27: created_by NUMBER := OKC_API.G_MISS_NUM,
28: creation_date OKC_CLASSES_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
29: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
30: last_update_date OKC_CLASSES_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
31: last_update_login NUMBER := OKC_API.G_MISS_NUM);
32: g_miss_okc_classes_tl_rec okc_classes_tl_rec_type;
25: meaning OKC_CLASSES_TL.MEANING%TYPE := OKC_API.G_MISS_CHAR,
26: description OKC_CLASSES_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
27: created_by NUMBER := OKC_API.G_MISS_NUM,
28: creation_date OKC_CLASSES_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
29: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
30: last_update_date OKC_CLASSES_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
31: last_update_login NUMBER := OKC_API.G_MISS_NUM);
32: g_miss_okc_classes_tl_rec okc_classes_tl_rec_type;
33: TYPE okc_classes_tl_tbl_type IS TABLE OF okc_classes_tl_rec_type
26: description OKC_CLASSES_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
27: created_by NUMBER := OKC_API.G_MISS_NUM,
28: creation_date OKC_CLASSES_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
29: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
30: last_update_date OKC_CLASSES_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
31: last_update_login NUMBER := OKC_API.G_MISS_NUM);
32: g_miss_okc_classes_tl_rec okc_classes_tl_rec_type;
33: TYPE okc_classes_tl_tbl_type IS TABLE OF okc_classes_tl_rec_type
34: INDEX BY BINARY_INTEGER;
27: created_by NUMBER := OKC_API.G_MISS_NUM,
28: creation_date OKC_CLASSES_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
29: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
30: last_update_date OKC_CLASSES_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
31: last_update_login NUMBER := OKC_API.G_MISS_NUM);
32: g_miss_okc_classes_tl_rec okc_classes_tl_rec_type;
33: TYPE okc_classes_tl_tbl_type IS TABLE OF okc_classes_tl_rec_type
34: INDEX BY BINARY_INTEGER;
35: TYPE clsv_rec_type IS RECORD (
32: g_miss_okc_classes_tl_rec okc_classes_tl_rec_type;
33: TYPE okc_classes_tl_tbl_type IS TABLE OF okc_classes_tl_rec_type
34: INDEX BY BINARY_INTEGER;
35: TYPE clsv_rec_type IS RECORD (
36: code OKC_CLASSES_V.CODE%TYPE := OKC_API.G_MISS_CHAR,
37: object_version_number NUMBER := OKC_API.G_MISS_NUM,
38: sfwt_flag OKC_CLASSES_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
39: fff_function_id NUMBER := OKC_API.G_MISS_NUM,
40: meaning OKC_CLASSES_V.MEANING%TYPE := OKC_API.G_MISS_CHAR,
33: TYPE okc_classes_tl_tbl_type IS TABLE OF okc_classes_tl_rec_type
34: INDEX BY BINARY_INTEGER;
35: TYPE clsv_rec_type IS RECORD (
36: code OKC_CLASSES_V.CODE%TYPE := OKC_API.G_MISS_CHAR,
37: object_version_number NUMBER := OKC_API.G_MISS_NUM,
38: sfwt_flag OKC_CLASSES_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
39: fff_function_id NUMBER := OKC_API.G_MISS_NUM,
40: meaning OKC_CLASSES_V.MEANING%TYPE := OKC_API.G_MISS_CHAR,
41: description OKC_CLASSES_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
34: INDEX BY BINARY_INTEGER;
35: TYPE clsv_rec_type IS RECORD (
36: code OKC_CLASSES_V.CODE%TYPE := OKC_API.G_MISS_CHAR,
37: object_version_number NUMBER := OKC_API.G_MISS_NUM,
38: sfwt_flag OKC_CLASSES_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
39: fff_function_id NUMBER := OKC_API.G_MISS_NUM,
40: meaning OKC_CLASSES_V.MEANING%TYPE := OKC_API.G_MISS_CHAR,
41: description OKC_CLASSES_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
42: created_by NUMBER := OKC_API.G_MISS_NUM,
35: TYPE clsv_rec_type IS RECORD (
36: code OKC_CLASSES_V.CODE%TYPE := OKC_API.G_MISS_CHAR,
37: object_version_number NUMBER := OKC_API.G_MISS_NUM,
38: sfwt_flag OKC_CLASSES_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
39: fff_function_id NUMBER := OKC_API.G_MISS_NUM,
40: meaning OKC_CLASSES_V.MEANING%TYPE := OKC_API.G_MISS_CHAR,
41: description OKC_CLASSES_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
42: created_by NUMBER := OKC_API.G_MISS_NUM,
43: creation_date OKC_CLASSES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
36: code OKC_CLASSES_V.CODE%TYPE := OKC_API.G_MISS_CHAR,
37: object_version_number NUMBER := OKC_API.G_MISS_NUM,
38: sfwt_flag OKC_CLASSES_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
39: fff_function_id NUMBER := OKC_API.G_MISS_NUM,
40: meaning OKC_CLASSES_V.MEANING%TYPE := OKC_API.G_MISS_CHAR,
41: description OKC_CLASSES_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
42: created_by NUMBER := OKC_API.G_MISS_NUM,
43: creation_date OKC_CLASSES_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_CLASSES_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
39: fff_function_id NUMBER := OKC_API.G_MISS_NUM,
40: meaning OKC_CLASSES_V.MEANING%TYPE := OKC_API.G_MISS_CHAR,
41: description OKC_CLASSES_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
42: created_by NUMBER := OKC_API.G_MISS_NUM,
43: creation_date OKC_CLASSES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
44: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
45: last_update_date OKC_CLASSES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
38: sfwt_flag OKC_CLASSES_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
39: fff_function_id NUMBER := OKC_API.G_MISS_NUM,
40: meaning OKC_CLASSES_V.MEANING%TYPE := OKC_API.G_MISS_CHAR,
41: description OKC_CLASSES_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
42: created_by NUMBER := OKC_API.G_MISS_NUM,
43: creation_date OKC_CLASSES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
44: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
45: last_update_date OKC_CLASSES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
46: last_update_login NUMBER := OKC_API.G_MISS_NUM,
39: fff_function_id NUMBER := OKC_API.G_MISS_NUM,
40: meaning OKC_CLASSES_V.MEANING%TYPE := OKC_API.G_MISS_CHAR,
41: description OKC_CLASSES_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
42: created_by NUMBER := OKC_API.G_MISS_NUM,
43: creation_date OKC_CLASSES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
44: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
45: last_update_date OKC_CLASSES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
46: last_update_login NUMBER := OKC_API.G_MISS_NUM,
47: application_id OKC_CLASSES_V.APPLICATION_ID%TYPE :=OKC_API.G_MISS_NUM,
40: meaning OKC_CLASSES_V.MEANING%TYPE := OKC_API.G_MISS_CHAR,
41: description OKC_CLASSES_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
42: created_by NUMBER := OKC_API.G_MISS_NUM,
43: creation_date OKC_CLASSES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
44: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
45: last_update_date OKC_CLASSES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
46: last_update_login NUMBER := OKC_API.G_MISS_NUM,
47: application_id OKC_CLASSES_V.APPLICATION_ID%TYPE :=OKC_API.G_MISS_NUM,
48: adv_search_form_function_id OKC_CLASSES_V.ADV_SEARCH_FORM_FUNCTION_ID%TYPE := OKC_API.G_MISS_NUM );
41: description OKC_CLASSES_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
42: created_by NUMBER := OKC_API.G_MISS_NUM,
43: creation_date OKC_CLASSES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
44: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
45: last_update_date OKC_CLASSES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
46: last_update_login NUMBER := OKC_API.G_MISS_NUM,
47: application_id OKC_CLASSES_V.APPLICATION_ID%TYPE :=OKC_API.G_MISS_NUM,
48: adv_search_form_function_id OKC_CLASSES_V.ADV_SEARCH_FORM_FUNCTION_ID%TYPE := OKC_API.G_MISS_NUM );
49: g_miss_clsv_rec clsv_rec_type;
42: created_by NUMBER := OKC_API.G_MISS_NUM,
43: creation_date OKC_CLASSES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
44: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
45: last_update_date OKC_CLASSES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
46: last_update_login NUMBER := OKC_API.G_MISS_NUM,
47: application_id OKC_CLASSES_V.APPLICATION_ID%TYPE :=OKC_API.G_MISS_NUM,
48: adv_search_form_function_id OKC_CLASSES_V.ADV_SEARCH_FORM_FUNCTION_ID%TYPE := OKC_API.G_MISS_NUM );
49: g_miss_clsv_rec clsv_rec_type;
50: TYPE clsv_tbl_type IS TABLE OF clsv_rec_type
43: creation_date OKC_CLASSES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
44: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
45: last_update_date OKC_CLASSES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
46: last_update_login NUMBER := OKC_API.G_MISS_NUM,
47: application_id OKC_CLASSES_V.APPLICATION_ID%TYPE :=OKC_API.G_MISS_NUM,
48: adv_search_form_function_id OKC_CLASSES_V.ADV_SEARCH_FORM_FUNCTION_ID%TYPE := OKC_API.G_MISS_NUM );
49: g_miss_clsv_rec clsv_rec_type;
50: TYPE clsv_tbl_type IS TABLE OF clsv_rec_type
51: INDEX BY BINARY_INTEGER;
44: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
45: last_update_date OKC_CLASSES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
46: last_update_login NUMBER := OKC_API.G_MISS_NUM,
47: application_id OKC_CLASSES_V.APPLICATION_ID%TYPE :=OKC_API.G_MISS_NUM,
48: adv_search_form_function_id OKC_CLASSES_V.ADV_SEARCH_FORM_FUNCTION_ID%TYPE := OKC_API.G_MISS_NUM );
49: g_miss_clsv_rec clsv_rec_type;
50: TYPE clsv_tbl_type IS TABLE OF clsv_rec_type
51: INDEX BY BINARY_INTEGER;
52: ---------------------------------------------------------------------------
51: INDEX BY BINARY_INTEGER;
52: ---------------------------------------------------------------------------
53: -- GLOBAL MESSAGE CONSTANTS
54: ---------------------------------------------------------------------------
55: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
56: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
57: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
58: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
59: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
52: ---------------------------------------------------------------------------
53: -- GLOBAL MESSAGE CONSTANTS
54: ---------------------------------------------------------------------------
55: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
56: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
57: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
58: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
59: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
60: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
53: -- GLOBAL MESSAGE CONSTANTS
54: ---------------------------------------------------------------------------
55: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
56: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
57: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
58: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
59: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
60: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
61: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
54: ---------------------------------------------------------------------------
55: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
56: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
57: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
58: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
59: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
60: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
61: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
62: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
55: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
56: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
57: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
58: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
59: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
60: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
61: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
62: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
63: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
56: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
57: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
58: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
59: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
60: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
61: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
62: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
63: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
64: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
57: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
58: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
59: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
60: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
61: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
62: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
63: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
64: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
65: ---------------------------------------------------------------------------
58: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
59: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
60: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
61: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
62: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
63: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
64: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
65: ---------------------------------------------------------------------------
66: -- GLOBAL VARIABLES
59: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
60: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
61: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
62: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
63: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
64: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
65: ---------------------------------------------------------------------------
66: -- GLOBAL VARIABLES
67: ---------------------------------------------------------------------------
60: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
61: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
62: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
63: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
64: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
65: ---------------------------------------------------------------------------
66: -- GLOBAL VARIABLES
67: ---------------------------------------------------------------------------
68: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_CLS_PVT';
65: ---------------------------------------------------------------------------
66: -- GLOBAL VARIABLES
67: ---------------------------------------------------------------------------
68: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_CLS_PVT';
69: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
70: ---------------------------------------------------------------------------
71: -- Procedures and Functions
72: ---------------------------------------------------------------------------
73:
76: PROCEDURE api_copy;
77: PROCEDURE add_language;
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_clsv_rec IN clsv_rec_type,
85: x_clsv_rec OUT NOCOPY clsv_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_clsv_tbl IN clsv_tbl_type,
94: x_clsv_tbl OUT NOCOPY clsv_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_clsv_rec IN clsv_rec_type);
102: p_clsv_rec IN clsv_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_clsv_tbl IN clsv_tbl_type);
110: p_clsv_tbl IN clsv_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_clsv_rec IN clsv_rec_type,
119: x_clsv_rec OUT NOCOPY clsv_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_clsv_tbl IN clsv_tbl_type,
128: x_clsv_tbl OUT NOCOPY clsv_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_clsv_rec IN clsv_rec_type);
136: p_clsv_rec IN clsv_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_clsv_tbl IN clsv_tbl_type);
144: p_clsv_tbl IN clsv_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_clsv_rec IN clsv_rec_type);
152: p_clsv_rec IN clsv_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_clsv_tbl IN clsv_tbl_type);