3: ---------------------------------------------------------------------------
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE ien_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: country_id OKL_INS_EXCLUSIONS_B.COUNTRY_ID%TYPE := OKC_API.G_MISS_CHAR,
9: date_from OKL_INS_EXCLUSIONS_B.DATE_FROM%TYPE := OKC_API.G_MISS_DATE,
10: coll_code NUMBER := OKC_API.G_MISS_NUM,
11: object_version_number OKL_INS_EXCLUSIONS_B.OBJECT_VERSION_NUMBER%TYPE,
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE ien_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: country_id OKL_INS_EXCLUSIONS_B.COUNTRY_ID%TYPE := OKC_API.G_MISS_CHAR,
9: date_from OKL_INS_EXCLUSIONS_B.DATE_FROM%TYPE := OKC_API.G_MISS_DATE,
10: coll_code NUMBER := OKC_API.G_MISS_NUM,
11: object_version_number OKL_INS_EXCLUSIONS_B.OBJECT_VERSION_NUMBER%TYPE,
12: sic_code OKL_INS_EXCLUSIONS_B.SIC_CODE%TYPE := OKC_API.G_MISS_CHAR,
5: ---------------------------------------------------------------------------
6: TYPE ien_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: country_id OKL_INS_EXCLUSIONS_B.COUNTRY_ID%TYPE := OKC_API.G_MISS_CHAR,
9: date_from OKL_INS_EXCLUSIONS_B.DATE_FROM%TYPE := OKC_API.G_MISS_DATE,
10: coll_code NUMBER := OKC_API.G_MISS_NUM,
11: object_version_number OKL_INS_EXCLUSIONS_B.OBJECT_VERSION_NUMBER%TYPE,
12: sic_code OKL_INS_EXCLUSIONS_B.SIC_CODE%TYPE := OKC_API.G_MISS_CHAR,
13: date_to OKL_INS_EXCLUSIONS_B.DATE_TO%TYPE := OKC_API.G_MISS_DATE,
6: TYPE ien_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: country_id OKL_INS_EXCLUSIONS_B.COUNTRY_ID%TYPE := OKC_API.G_MISS_CHAR,
9: date_from OKL_INS_EXCLUSIONS_B.DATE_FROM%TYPE := OKC_API.G_MISS_DATE,
10: coll_code NUMBER := OKC_API.G_MISS_NUM,
11: object_version_number OKL_INS_EXCLUSIONS_B.OBJECT_VERSION_NUMBER%TYPE,
12: sic_code OKL_INS_EXCLUSIONS_B.SIC_CODE%TYPE := OKC_API.G_MISS_CHAR,
13: date_to OKL_INS_EXCLUSIONS_B.DATE_TO%TYPE := OKC_API.G_MISS_DATE,
14: --comments OKL_INS_EXCLUSIONS_B.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
8: country_id OKL_INS_EXCLUSIONS_B.COUNTRY_ID%TYPE := OKC_API.G_MISS_CHAR,
9: date_from OKL_INS_EXCLUSIONS_B.DATE_FROM%TYPE := OKC_API.G_MISS_DATE,
10: coll_code NUMBER := OKC_API.G_MISS_NUM,
11: object_version_number OKL_INS_EXCLUSIONS_B.OBJECT_VERSION_NUMBER%TYPE,
12: sic_code OKL_INS_EXCLUSIONS_B.SIC_CODE%TYPE := OKC_API.G_MISS_CHAR,
13: date_to OKL_INS_EXCLUSIONS_B.DATE_TO%TYPE := OKC_API.G_MISS_DATE,
14: --comments OKL_INS_EXCLUSIONS_B.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
15: attribute_category OKL_INS_EXCLUSIONS_B.ATTRIBUTE_CATEGORY%TYPE,
16: attribute1 OKL_INS_EXCLUSIONS_B.ATTRIBUTE1%TYPE,
9: date_from OKL_INS_EXCLUSIONS_B.DATE_FROM%TYPE := OKC_API.G_MISS_DATE,
10: coll_code NUMBER := OKC_API.G_MISS_NUM,
11: object_version_number OKL_INS_EXCLUSIONS_B.OBJECT_VERSION_NUMBER%TYPE,
12: sic_code OKL_INS_EXCLUSIONS_B.SIC_CODE%TYPE := OKC_API.G_MISS_CHAR,
13: date_to OKL_INS_EXCLUSIONS_B.DATE_TO%TYPE := OKC_API.G_MISS_DATE,
14: --comments OKL_INS_EXCLUSIONS_B.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
15: attribute_category OKL_INS_EXCLUSIONS_B.ATTRIBUTE_CATEGORY%TYPE,
16: attribute1 OKL_INS_EXCLUSIONS_B.ATTRIBUTE1%TYPE,
17: attribute2 OKL_INS_EXCLUSIONS_B.ATTRIBUTE2%TYPE,
10: coll_code NUMBER := OKC_API.G_MISS_NUM,
11: object_version_number OKL_INS_EXCLUSIONS_B.OBJECT_VERSION_NUMBER%TYPE,
12: sic_code OKL_INS_EXCLUSIONS_B.SIC_CODE%TYPE := OKC_API.G_MISS_CHAR,
13: date_to OKL_INS_EXCLUSIONS_B.DATE_TO%TYPE := OKC_API.G_MISS_DATE,
14: --comments OKL_INS_EXCLUSIONS_B.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
15: attribute_category OKL_INS_EXCLUSIONS_B.ATTRIBUTE_CATEGORY%TYPE,
16: attribute1 OKL_INS_EXCLUSIONS_B.ATTRIBUTE1%TYPE,
17: attribute2 OKL_INS_EXCLUSIONS_B.ATTRIBUTE2%TYPE,
18: attribute3 OKL_INS_EXCLUSIONS_B.ATTRIBUTE3%TYPE,
27: attribute12 OKL_INS_EXCLUSIONS_B.ATTRIBUTE12%TYPE,
28: attribute13 OKL_INS_EXCLUSIONS_B.ATTRIBUTE13%TYPE,
29: attribute14 OKL_INS_EXCLUSIONS_B.ATTRIBUTE14%TYPE,
30: attribute15 OKL_INS_EXCLUSIONS_B.ATTRIBUTE15%TYPE,
31: created_by NUMBER := OKC_API.G_MISS_NUM,
32: creation_date OKL_INS_EXCLUSIONS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
33: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
34: last_update_date OKL_INS_EXCLUSIONS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
35: last_update_login NUMBER := OKC_API.G_MISS_NUM);
28: attribute13 OKL_INS_EXCLUSIONS_B.ATTRIBUTE13%TYPE,
29: attribute14 OKL_INS_EXCLUSIONS_B.ATTRIBUTE14%TYPE,
30: attribute15 OKL_INS_EXCLUSIONS_B.ATTRIBUTE15%TYPE,
31: created_by NUMBER := OKC_API.G_MISS_NUM,
32: creation_date OKL_INS_EXCLUSIONS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
33: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
34: last_update_date OKL_INS_EXCLUSIONS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
35: last_update_login NUMBER := OKC_API.G_MISS_NUM);
36: g_miss_ien_rec ien_rec_type;
29: attribute14 OKL_INS_EXCLUSIONS_B.ATTRIBUTE14%TYPE,
30: attribute15 OKL_INS_EXCLUSIONS_B.ATTRIBUTE15%TYPE,
31: created_by NUMBER := OKC_API.G_MISS_NUM,
32: creation_date OKL_INS_EXCLUSIONS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
33: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
34: last_update_date OKL_INS_EXCLUSIONS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
35: last_update_login NUMBER := OKC_API.G_MISS_NUM);
36: g_miss_ien_rec ien_rec_type;
37: TYPE ien_tbl_type IS TABLE OF ien_rec_type
30: attribute15 OKL_INS_EXCLUSIONS_B.ATTRIBUTE15%TYPE,
31: created_by NUMBER := OKC_API.G_MISS_NUM,
32: creation_date OKL_INS_EXCLUSIONS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
33: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
34: last_update_date OKL_INS_EXCLUSIONS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
35: last_update_login NUMBER := OKC_API.G_MISS_NUM);
36: g_miss_ien_rec ien_rec_type;
37: TYPE ien_tbl_type IS TABLE OF ien_rec_type
38: INDEX BY BINARY_INTEGER;
31: created_by NUMBER := OKC_API.G_MISS_NUM,
32: creation_date OKL_INS_EXCLUSIONS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
33: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
34: last_update_date OKL_INS_EXCLUSIONS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
35: last_update_login NUMBER := OKC_API.G_MISS_NUM);
36: g_miss_ien_rec ien_rec_type;
37: TYPE ien_tbl_type IS TABLE OF ien_rec_type
38: INDEX BY BINARY_INTEGER;
39: TYPE okl_ins_exclusions_tl_rec_type IS RECORD (
36: g_miss_ien_rec ien_rec_type;
37: TYPE ien_tbl_type IS TABLE OF ien_rec_type
38: INDEX BY BINARY_INTEGER;
39: TYPE okl_ins_exclusions_tl_rec_type IS RECORD (
40: id NUMBER := OKC_API.G_MISS_NUM,
41: LANGUAGE OKL_INS_EXCLUSIONS_TL.LANGUAGE%TYPE,
42: source_lang OKL_INS_EXCLUSIONS_TL.SOURCE_LANG%TYPE,
43: sfwt_flag OKL_INS_EXCLUSIONS_TL.SFWT_FLAG%TYPE,
44: comments OKL_INS_EXCLUSIONS_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
40: id NUMBER := OKC_API.G_MISS_NUM,
41: LANGUAGE OKL_INS_EXCLUSIONS_TL.LANGUAGE%TYPE,
42: source_lang OKL_INS_EXCLUSIONS_TL.SOURCE_LANG%TYPE,
43: sfwt_flag OKL_INS_EXCLUSIONS_TL.SFWT_FLAG%TYPE,
44: comments OKL_INS_EXCLUSIONS_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
45: created_by NUMBER := OKC_API.G_MISS_NUM,
46: creation_date OKL_INS_EXCLUSIONS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
47: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
48: last_update_date OKL_INS_EXCLUSIONS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
41: LANGUAGE OKL_INS_EXCLUSIONS_TL.LANGUAGE%TYPE,
42: source_lang OKL_INS_EXCLUSIONS_TL.SOURCE_LANG%TYPE,
43: sfwt_flag OKL_INS_EXCLUSIONS_TL.SFWT_FLAG%TYPE,
44: comments OKL_INS_EXCLUSIONS_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
45: created_by NUMBER := OKC_API.G_MISS_NUM,
46: creation_date OKL_INS_EXCLUSIONS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
47: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
48: last_update_date OKL_INS_EXCLUSIONS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
49: last_update_login NUMBER := OKC_API.G_MISS_NUM
42: source_lang OKL_INS_EXCLUSIONS_TL.SOURCE_LANG%TYPE,
43: sfwt_flag OKL_INS_EXCLUSIONS_TL.SFWT_FLAG%TYPE,
44: comments OKL_INS_EXCLUSIONS_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
45: created_by NUMBER := OKC_API.G_MISS_NUM,
46: creation_date OKL_INS_EXCLUSIONS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
47: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
48: last_update_date OKL_INS_EXCLUSIONS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
49: last_update_login NUMBER := OKC_API.G_MISS_NUM
50: );
43: sfwt_flag OKL_INS_EXCLUSIONS_TL.SFWT_FLAG%TYPE,
44: comments OKL_INS_EXCLUSIONS_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
45: created_by NUMBER := OKC_API.G_MISS_NUM,
46: creation_date OKL_INS_EXCLUSIONS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
47: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
48: last_update_date OKL_INS_EXCLUSIONS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
49: last_update_login NUMBER := OKC_API.G_MISS_NUM
50: );
51: GMissOklInsExclusionsTlRec okl_ins_exclusions_tl_rec_type;
44: comments OKL_INS_EXCLUSIONS_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
45: created_by NUMBER := OKC_API.G_MISS_NUM,
46: creation_date OKL_INS_EXCLUSIONS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
47: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
48: last_update_date OKL_INS_EXCLUSIONS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
49: last_update_login NUMBER := OKC_API.G_MISS_NUM
50: );
51: GMissOklInsExclusionsTlRec okl_ins_exclusions_tl_rec_type;
52: TYPE okl_ins_exclusions_tl_tbl_type IS TABLE OF okl_ins_exclusions_tl_rec_type
45: created_by NUMBER := OKC_API.G_MISS_NUM,
46: creation_date OKL_INS_EXCLUSIONS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
47: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
48: last_update_date OKL_INS_EXCLUSIONS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
49: last_update_login NUMBER := OKC_API.G_MISS_NUM
50: );
51: GMissOklInsExclusionsTlRec okl_ins_exclusions_tl_rec_type;
52: TYPE okl_ins_exclusions_tl_tbl_type IS TABLE OF okl_ins_exclusions_tl_rec_type
53: INDEX BY BINARY_INTEGER;
51: GMissOklInsExclusionsTlRec okl_ins_exclusions_tl_rec_type;
52: TYPE okl_ins_exclusions_tl_tbl_type IS TABLE OF okl_ins_exclusions_tl_rec_type
53: INDEX BY BINARY_INTEGER;
54: TYPE ienv_rec_type IS RECORD (
55: id NUMBER := OKC_API.G_MISS_NUM,
56: object_version_number OKL_INS_EXCLUSIONS_V.OBJECT_VERSION_NUMBER%TYPE,
57: sfwt_flag OKL_INS_EXCLUSIONS_V.SFWT_FLAG%TYPE,
58: country_id OKL_INS_EXCLUSIONS_V.COUNTRY_ID%TYPE := OKC_API.G_MISS_CHAR,
59: coll_code NUMBER := OKC_API.G_MISS_NUM,
54: TYPE ienv_rec_type IS RECORD (
55: id NUMBER := OKC_API.G_MISS_NUM,
56: object_version_number OKL_INS_EXCLUSIONS_V.OBJECT_VERSION_NUMBER%TYPE,
57: sfwt_flag OKL_INS_EXCLUSIONS_V.SFWT_FLAG%TYPE,
58: country_id OKL_INS_EXCLUSIONS_V.COUNTRY_ID%TYPE := OKC_API.G_MISS_CHAR,
59: coll_code NUMBER := OKC_API.G_MISS_NUM,
60: attribute_category OKL_INS_EXCLUSIONS_V.ATTRIBUTE_CATEGORY%TYPE,
61: attribute1 OKL_INS_EXCLUSIONS_V.ATTRIBUTE1%TYPE,
62: attribute2 OKL_INS_EXCLUSIONS_V.ATTRIBUTE2%TYPE,
55: id NUMBER := OKC_API.G_MISS_NUM,
56: object_version_number OKL_INS_EXCLUSIONS_V.OBJECT_VERSION_NUMBER%TYPE,
57: sfwt_flag OKL_INS_EXCLUSIONS_V.SFWT_FLAG%TYPE,
58: country_id OKL_INS_EXCLUSIONS_V.COUNTRY_ID%TYPE := OKC_API.G_MISS_CHAR,
59: coll_code NUMBER := OKC_API.G_MISS_NUM,
60: attribute_category OKL_INS_EXCLUSIONS_V.ATTRIBUTE_CATEGORY%TYPE,
61: attribute1 OKL_INS_EXCLUSIONS_V.ATTRIBUTE1%TYPE,
62: attribute2 OKL_INS_EXCLUSIONS_V.ATTRIBUTE2%TYPE,
63: attribute3 OKL_INS_EXCLUSIONS_V.ATTRIBUTE3%TYPE,
72: attribute12 OKL_INS_EXCLUSIONS_V.ATTRIBUTE12%TYPE,
73: attribute13 OKL_INS_EXCLUSIONS_V.ATTRIBUTE13%TYPE,
74: attribute14 OKL_INS_EXCLUSIONS_V.ATTRIBUTE14%TYPE,
75: attribute15 OKL_INS_EXCLUSIONS_V.ATTRIBUTE15%TYPE,
76: date_from OKL_INS_EXCLUSIONS_V.DATE_FROM%TYPE := OKC_API.G_MISS_DATE,
77: sic_code OKL_INS_EXCLUSIONS_V.SIC_CODE%TYPE := OKC_API.G_MISS_CHAR,
78: date_to OKL_INS_EXCLUSIONS_V.DATE_TO%TYPE := OKC_API.G_MISS_DATE,
79: comments OKL_INS_EXCLUSIONS_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
80: created_by NUMBER := OKC_API.G_MISS_NUM,
73: attribute13 OKL_INS_EXCLUSIONS_V.ATTRIBUTE13%TYPE,
74: attribute14 OKL_INS_EXCLUSIONS_V.ATTRIBUTE14%TYPE,
75: attribute15 OKL_INS_EXCLUSIONS_V.ATTRIBUTE15%TYPE,
76: date_from OKL_INS_EXCLUSIONS_V.DATE_FROM%TYPE := OKC_API.G_MISS_DATE,
77: sic_code OKL_INS_EXCLUSIONS_V.SIC_CODE%TYPE := OKC_API.G_MISS_CHAR,
78: date_to OKL_INS_EXCLUSIONS_V.DATE_TO%TYPE := OKC_API.G_MISS_DATE,
79: comments OKL_INS_EXCLUSIONS_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
80: created_by NUMBER := OKC_API.G_MISS_NUM,
81: creation_date OKL_INS_EXCLUSIONS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
74: attribute14 OKL_INS_EXCLUSIONS_V.ATTRIBUTE14%TYPE,
75: attribute15 OKL_INS_EXCLUSIONS_V.ATTRIBUTE15%TYPE,
76: date_from OKL_INS_EXCLUSIONS_V.DATE_FROM%TYPE := OKC_API.G_MISS_DATE,
77: sic_code OKL_INS_EXCLUSIONS_V.SIC_CODE%TYPE := OKC_API.G_MISS_CHAR,
78: date_to OKL_INS_EXCLUSIONS_V.DATE_TO%TYPE := OKC_API.G_MISS_DATE,
79: comments OKL_INS_EXCLUSIONS_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
80: created_by NUMBER := OKC_API.G_MISS_NUM,
81: creation_date OKL_INS_EXCLUSIONS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
82: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
75: attribute15 OKL_INS_EXCLUSIONS_V.ATTRIBUTE15%TYPE,
76: date_from OKL_INS_EXCLUSIONS_V.DATE_FROM%TYPE := OKC_API.G_MISS_DATE,
77: sic_code OKL_INS_EXCLUSIONS_V.SIC_CODE%TYPE := OKC_API.G_MISS_CHAR,
78: date_to OKL_INS_EXCLUSIONS_V.DATE_TO%TYPE := OKC_API.G_MISS_DATE,
79: comments OKL_INS_EXCLUSIONS_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
80: created_by NUMBER := OKC_API.G_MISS_NUM,
81: creation_date OKL_INS_EXCLUSIONS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
82: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
83: last_update_date OKL_INS_EXCLUSIONS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
76: date_from OKL_INS_EXCLUSIONS_V.DATE_FROM%TYPE := OKC_API.G_MISS_DATE,
77: sic_code OKL_INS_EXCLUSIONS_V.SIC_CODE%TYPE := OKC_API.G_MISS_CHAR,
78: date_to OKL_INS_EXCLUSIONS_V.DATE_TO%TYPE := OKC_API.G_MISS_DATE,
79: comments OKL_INS_EXCLUSIONS_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
80: created_by NUMBER := OKC_API.G_MISS_NUM,
81: creation_date OKL_INS_EXCLUSIONS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
82: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
83: last_update_date OKL_INS_EXCLUSIONS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
84: last_update_login NUMBER := OKC_API.G_MISS_NUM
77: sic_code OKL_INS_EXCLUSIONS_V.SIC_CODE%TYPE := OKC_API.G_MISS_CHAR,
78: date_to OKL_INS_EXCLUSIONS_V.DATE_TO%TYPE := OKC_API.G_MISS_DATE,
79: comments OKL_INS_EXCLUSIONS_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
80: created_by NUMBER := OKC_API.G_MISS_NUM,
81: creation_date OKL_INS_EXCLUSIONS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
82: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
83: last_update_date OKL_INS_EXCLUSIONS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
84: last_update_login NUMBER := OKC_API.G_MISS_NUM
85: );
78: date_to OKL_INS_EXCLUSIONS_V.DATE_TO%TYPE := OKC_API.G_MISS_DATE,
79: comments OKL_INS_EXCLUSIONS_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
80: created_by NUMBER := OKC_API.G_MISS_NUM,
81: creation_date OKL_INS_EXCLUSIONS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
82: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
83: last_update_date OKL_INS_EXCLUSIONS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
84: last_update_login NUMBER := OKC_API.G_MISS_NUM
85: );
86: g_miss_ienv_rec ienv_rec_type;
79: comments OKL_INS_EXCLUSIONS_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
80: created_by NUMBER := OKC_API.G_MISS_NUM,
81: creation_date OKL_INS_EXCLUSIONS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
82: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
83: last_update_date OKL_INS_EXCLUSIONS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
84: last_update_login NUMBER := OKC_API.G_MISS_NUM
85: );
86: g_miss_ienv_rec ienv_rec_type;
87: TYPE ienv_tbl_type IS TABLE OF ienv_rec_type
80: created_by NUMBER := OKC_API.G_MISS_NUM,
81: creation_date OKL_INS_EXCLUSIONS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
82: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
83: last_update_date OKL_INS_EXCLUSIONS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
84: last_update_login NUMBER := OKC_API.G_MISS_NUM
85: );
86: g_miss_ienv_rec ienv_rec_type;
87: TYPE ienv_tbl_type IS TABLE OF ienv_rec_type
88: INDEX BY BINARY_INTEGER;
88: INDEX BY BINARY_INTEGER;
89: ---------------------------------------------------------------------------
90: -- GLOBAL MESSAGE CONSTANTS
91: ---------------------------------------------------------------------------
92: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
93: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
94: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
95: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
96: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
89: ---------------------------------------------------------------------------
90: -- GLOBAL MESSAGE CONSTANTS
91: ---------------------------------------------------------------------------
92: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
93: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
94: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
95: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
96: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
97: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
90: -- GLOBAL MESSAGE CONSTANTS
91: ---------------------------------------------------------------------------
92: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
93: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
94: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
95: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
96: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
97: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
98: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
91: ---------------------------------------------------------------------------
92: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
93: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
94: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
95: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
96: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
97: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
98: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
99: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
92: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
93: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
94: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
95: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
96: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
97: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
98: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
99: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
100: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
93: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
94: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
95: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
96: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
97: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
98: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
99: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
100: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
101: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
94: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
95: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
96: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
97: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
98: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
99: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
100: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
101: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
102: ---------------------------------------------------------------------------
95: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
96: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
97: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
98: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
99: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
100: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
101: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
102: ---------------------------------------------------------------------------
103: -- GLOBAL VARIABLES
96: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
97: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
98: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
99: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
100: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
101: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
102: ---------------------------------------------------------------------------
103: -- GLOBAL VARIABLES
104: ---------------------------------------------------------------------------
97: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
98: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
99: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
100: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
101: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
102: ---------------------------------------------------------------------------
103: -- GLOBAL VARIABLES
104: ---------------------------------------------------------------------------
105: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_IEN_PVT';
121: PROCEDURE api_copy;
122: PROCEDURE add_language;
123: PROCEDURE insert_row(
124: p_api_version IN NUMBER,
125: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
126: x_return_status OUT NOCOPY VARCHAR2,
127: x_msg_count OUT NOCOPY NUMBER,
128: x_msg_data OUT NOCOPY VARCHAR2,
129: p_ienv_rec IN ienv_rec_type,
129: p_ienv_rec IN ienv_rec_type,
130: x_ienv_rec OUT NOCOPY ienv_rec_type);
131: PROCEDURE insert_row(
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_ienv_tbl IN ienv_tbl_type,
137: p_ienv_tbl IN ienv_tbl_type,
138: x_ienv_tbl OUT NOCOPY ienv_tbl_type);
139: PROCEDURE lock_row(
140: p_api_version IN NUMBER,
141: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
142: x_return_status OUT NOCOPY VARCHAR2,
143: x_msg_count OUT NOCOPY NUMBER,
144: x_msg_data OUT NOCOPY VARCHAR2,
145: p_ienv_rec IN ienv_rec_type);
144: x_msg_data OUT NOCOPY VARCHAR2,
145: p_ienv_rec IN ienv_rec_type);
146: PROCEDURE lock_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_ienv_tbl IN ienv_tbl_type);
151: x_msg_data OUT NOCOPY VARCHAR2,
152: p_ienv_tbl IN ienv_tbl_type);
153: PROCEDURE update_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_ienv_rec IN ienv_rec_type,
159: p_ienv_rec IN ienv_rec_type,
160: x_ienv_rec OUT NOCOPY ienv_rec_type);
161: PROCEDURE update_row(
162: p_api_version IN NUMBER,
163: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
164: x_return_status OUT NOCOPY VARCHAR2,
165: x_msg_count OUT NOCOPY NUMBER,
166: x_msg_data OUT NOCOPY VARCHAR2,
167: p_ienv_tbl IN ienv_tbl_type,
167: p_ienv_tbl IN ienv_tbl_type,
168: x_ienv_tbl OUT NOCOPY ienv_tbl_type);
169: PROCEDURE delete_row(
170: p_api_version IN NUMBER,
171: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
172: x_return_status OUT NOCOPY VARCHAR2,
173: x_msg_count OUT NOCOPY NUMBER,
174: x_msg_data OUT NOCOPY VARCHAR2,
175: p_ienv_rec IN ienv_rec_type);
174: x_msg_data OUT NOCOPY VARCHAR2,
175: p_ienv_rec IN ienv_rec_type);
176: PROCEDURE delete_row(
177: p_api_version IN NUMBER,
178: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
179: x_return_status OUT NOCOPY VARCHAR2,
180: x_msg_count OUT NOCOPY NUMBER,
181: x_msg_data OUT NOCOPY VARCHAR2,
182: p_ienv_tbl IN ienv_tbl_type);
181: x_msg_data OUT NOCOPY VARCHAR2,
182: p_ienv_tbl IN ienv_tbl_type);
183: PROCEDURE validate_row(
184: p_api_version IN NUMBER,
185: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
186: x_return_status OUT NOCOPY VARCHAR2,
187: x_msg_count OUT NOCOPY NUMBER,
188: x_msg_data OUT NOCOPY VARCHAR2,
189: p_ienv_rec IN ienv_rec_type);
188: x_msg_data OUT NOCOPY VARCHAR2,
189: p_ienv_rec IN ienv_rec_type);
190: PROCEDURE validate_row(
191: p_api_version IN NUMBER,
192: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
193: x_return_status OUT NOCOPY VARCHAR2,
194: x_msg_count OUT NOCOPY NUMBER,
195: x_msg_data OUT NOCOPY VARCHAR2,
196: p_ienv_tbl IN ienv_tbl_type);