2: /* $Header: OKCSPDFS.pls 120.0 2005/06/01 22:56:14 appldev noship $ */
3: ---------------------------------------------------------------------------
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE okc_process_defs_tl_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: language OKC_PROCESS_DEFS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
9: source_lang OKC_PROCESS_DEFS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
10: sfwt_flag OKC_PROCESS_DEFS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE okc_process_defs_tl_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: language OKC_PROCESS_DEFS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
9: source_lang OKC_PROCESS_DEFS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
10: sfwt_flag OKC_PROCESS_DEFS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
11: name OKC_PROCESS_DEFS_TL.NAME%TYPE := OKC_API.G_MISS_CHAR,
12: description OKC_PROCESS_DEFS_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
5: ---------------------------------------------------------------------------
6: TYPE okc_process_defs_tl_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: language OKC_PROCESS_DEFS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
9: source_lang OKC_PROCESS_DEFS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
10: sfwt_flag OKC_PROCESS_DEFS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
11: name OKC_PROCESS_DEFS_TL.NAME%TYPE := OKC_API.G_MISS_CHAR,
12: description OKC_PROCESS_DEFS_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
13: short_description OKC_PROCESS_DEFS_TL.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
6: TYPE okc_process_defs_tl_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: language OKC_PROCESS_DEFS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
9: source_lang OKC_PROCESS_DEFS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
10: sfwt_flag OKC_PROCESS_DEFS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
11: name OKC_PROCESS_DEFS_TL.NAME%TYPE := OKC_API.G_MISS_CHAR,
12: description OKC_PROCESS_DEFS_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
13: short_description OKC_PROCESS_DEFS_TL.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
14: comments OKC_PROCESS_DEFS_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
7: id NUMBER := OKC_API.G_MISS_NUM,
8: language OKC_PROCESS_DEFS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
9: source_lang OKC_PROCESS_DEFS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
10: sfwt_flag OKC_PROCESS_DEFS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
11: name OKC_PROCESS_DEFS_TL.NAME%TYPE := OKC_API.G_MISS_CHAR,
12: description OKC_PROCESS_DEFS_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
13: short_description OKC_PROCESS_DEFS_TL.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
14: comments OKC_PROCESS_DEFS_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
15: created_by NUMBER := OKC_API.G_MISS_NUM,
8: language OKC_PROCESS_DEFS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
9: source_lang OKC_PROCESS_DEFS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
10: sfwt_flag OKC_PROCESS_DEFS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
11: name OKC_PROCESS_DEFS_TL.NAME%TYPE := OKC_API.G_MISS_CHAR,
12: description OKC_PROCESS_DEFS_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
13: short_description OKC_PROCESS_DEFS_TL.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
14: comments OKC_PROCESS_DEFS_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
15: created_by NUMBER := OKC_API.G_MISS_NUM,
16: creation_date OKC_PROCESS_DEFS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
9: source_lang OKC_PROCESS_DEFS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
10: sfwt_flag OKC_PROCESS_DEFS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
11: name OKC_PROCESS_DEFS_TL.NAME%TYPE := OKC_API.G_MISS_CHAR,
12: description OKC_PROCESS_DEFS_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
13: short_description OKC_PROCESS_DEFS_TL.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
14: comments OKC_PROCESS_DEFS_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
15: created_by NUMBER := OKC_API.G_MISS_NUM,
16: creation_date OKC_PROCESS_DEFS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
17: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
10: sfwt_flag OKC_PROCESS_DEFS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
11: name OKC_PROCESS_DEFS_TL.NAME%TYPE := OKC_API.G_MISS_CHAR,
12: description OKC_PROCESS_DEFS_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
13: short_description OKC_PROCESS_DEFS_TL.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
14: comments OKC_PROCESS_DEFS_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
15: created_by NUMBER := OKC_API.G_MISS_NUM,
16: creation_date OKC_PROCESS_DEFS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
17: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
18: last_update_date OKC_PROCESS_DEFS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
12: description OKC_PROCESS_DEFS_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
13: short_description OKC_PROCESS_DEFS_TL.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
14: comments OKC_PROCESS_DEFS_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
15: created_by NUMBER := OKC_API.G_MISS_NUM,
16: creation_date OKC_PROCESS_DEFS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
17: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
18: last_update_date OKC_PROCESS_DEFS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
19: last_update_login NUMBER := OKC_API.G_MISS_NUM);
20: g_miss_okc_process_defs_tl_rec okc_process_defs_tl_rec_type;
14: comments OKC_PROCESS_DEFS_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
15: created_by NUMBER := OKC_API.G_MISS_NUM,
16: creation_date OKC_PROCESS_DEFS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
17: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
18: last_update_date OKC_PROCESS_DEFS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
19: last_update_login NUMBER := OKC_API.G_MISS_NUM);
20: g_miss_okc_process_defs_tl_rec okc_process_defs_tl_rec_type;
21: TYPE okc_process_defs_tl_tbl_type IS TABLE OF okc_process_defs_tl_rec_type
22: INDEX BY BINARY_INTEGER;
16: creation_date OKC_PROCESS_DEFS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
17: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
18: last_update_date OKC_PROCESS_DEFS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
19: last_update_login NUMBER := OKC_API.G_MISS_NUM);
20: g_miss_okc_process_defs_tl_rec okc_process_defs_tl_rec_type;
21: TYPE okc_process_defs_tl_tbl_type IS TABLE OF okc_process_defs_tl_rec_type
22: INDEX BY BINARY_INTEGER;
23: TYPE pdf_rec_type IS RECORD (
24: id NUMBER := OKC_API.G_MISS_NUM,
17: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
18: last_update_date OKC_PROCESS_DEFS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
19: last_update_login NUMBER := OKC_API.G_MISS_NUM);
20: g_miss_okc_process_defs_tl_rec okc_process_defs_tl_rec_type;
21: TYPE okc_process_defs_tl_tbl_type IS TABLE OF okc_process_defs_tl_rec_type
22: INDEX BY BINARY_INTEGER;
23: TYPE pdf_rec_type IS RECORD (
24: id NUMBER := OKC_API.G_MISS_NUM,
25: pdf_type OKC_PROCESS_DEFS_B.PDF_TYPE%TYPE := OKC_API.G_MISS_CHAR,