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,
60: attribute_category OKL_INS_EXCLUSIONS_V.ATTRIBUTE_CATEGORY%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,
60: attribute_category OKL_INS_EXCLUSIONS_V.ATTRIBUTE_CATEGORY%TYPE,
61: attribute1 OKL_INS_EXCLUSIONS_V.ATTRIBUTE1%TYPE,
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,
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,
64: attribute4 OKL_INS_EXCLUSIONS_V.ATTRIBUTE4%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,
64: attribute4 OKL_INS_EXCLUSIONS_V.ATTRIBUTE4%TYPE,
65: attribute5 OKL_INS_EXCLUSIONS_V.ATTRIBUTE5%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,
64: attribute4 OKL_INS_EXCLUSIONS_V.ATTRIBUTE4%TYPE,
65: attribute5 OKL_INS_EXCLUSIONS_V.ATTRIBUTE5%TYPE,
66: attribute6 OKL_INS_EXCLUSIONS_V.ATTRIBUTE6%TYPE,
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,
64: attribute4 OKL_INS_EXCLUSIONS_V.ATTRIBUTE4%TYPE,
65: attribute5 OKL_INS_EXCLUSIONS_V.ATTRIBUTE5%TYPE,
66: attribute6 OKL_INS_EXCLUSIONS_V.ATTRIBUTE6%TYPE,
67: attribute7 OKL_INS_EXCLUSIONS_V.ATTRIBUTE7%TYPE,
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,
64: attribute4 OKL_INS_EXCLUSIONS_V.ATTRIBUTE4%TYPE,
65: attribute5 OKL_INS_EXCLUSIONS_V.ATTRIBUTE5%TYPE,
66: attribute6 OKL_INS_EXCLUSIONS_V.ATTRIBUTE6%TYPE,
67: attribute7 OKL_INS_EXCLUSIONS_V.ATTRIBUTE7%TYPE,
68: attribute8 OKL_INS_EXCLUSIONS_V.ATTRIBUTE8%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,
64: attribute4 OKL_INS_EXCLUSIONS_V.ATTRIBUTE4%TYPE,
65: attribute5 OKL_INS_EXCLUSIONS_V.ATTRIBUTE5%TYPE,
66: attribute6 OKL_INS_EXCLUSIONS_V.ATTRIBUTE6%TYPE,
67: attribute7 OKL_INS_EXCLUSIONS_V.ATTRIBUTE7%TYPE,
68: attribute8 OKL_INS_EXCLUSIONS_V.ATTRIBUTE8%TYPE,
69: attribute9 OKL_INS_EXCLUSIONS_V.ATTRIBUTE9%TYPE,
62: attribute2 OKL_INS_EXCLUSIONS_V.ATTRIBUTE2%TYPE,
63: attribute3 OKL_INS_EXCLUSIONS_V.ATTRIBUTE3%TYPE,
64: attribute4 OKL_INS_EXCLUSIONS_V.ATTRIBUTE4%TYPE,
65: attribute5 OKL_INS_EXCLUSIONS_V.ATTRIBUTE5%TYPE,
66: attribute6 OKL_INS_EXCLUSIONS_V.ATTRIBUTE6%TYPE,
67: attribute7 OKL_INS_EXCLUSIONS_V.ATTRIBUTE7%TYPE,
68: attribute8 OKL_INS_EXCLUSIONS_V.ATTRIBUTE8%TYPE,
69: attribute9 OKL_INS_EXCLUSIONS_V.ATTRIBUTE9%TYPE,
70: attribute10 OKL_INS_EXCLUSIONS_V.ATTRIBUTE10%TYPE,
63: attribute3 OKL_INS_EXCLUSIONS_V.ATTRIBUTE3%TYPE,
64: attribute4 OKL_INS_EXCLUSIONS_V.ATTRIBUTE4%TYPE,
65: attribute5 OKL_INS_EXCLUSIONS_V.ATTRIBUTE5%TYPE,
66: attribute6 OKL_INS_EXCLUSIONS_V.ATTRIBUTE6%TYPE,
67: attribute7 OKL_INS_EXCLUSIONS_V.ATTRIBUTE7%TYPE,
68: attribute8 OKL_INS_EXCLUSIONS_V.ATTRIBUTE8%TYPE,
69: attribute9 OKL_INS_EXCLUSIONS_V.ATTRIBUTE9%TYPE,
70: attribute10 OKL_INS_EXCLUSIONS_V.ATTRIBUTE10%TYPE,
71: attribute11 OKL_INS_EXCLUSIONS_V.ATTRIBUTE11%TYPE,
64: attribute4 OKL_INS_EXCLUSIONS_V.ATTRIBUTE4%TYPE,
65: attribute5 OKL_INS_EXCLUSIONS_V.ATTRIBUTE5%TYPE,
66: attribute6 OKL_INS_EXCLUSIONS_V.ATTRIBUTE6%TYPE,
67: attribute7 OKL_INS_EXCLUSIONS_V.ATTRIBUTE7%TYPE,
68: attribute8 OKL_INS_EXCLUSIONS_V.ATTRIBUTE8%TYPE,
69: attribute9 OKL_INS_EXCLUSIONS_V.ATTRIBUTE9%TYPE,
70: attribute10 OKL_INS_EXCLUSIONS_V.ATTRIBUTE10%TYPE,
71: attribute11 OKL_INS_EXCLUSIONS_V.ATTRIBUTE11%TYPE,
72: attribute12 OKL_INS_EXCLUSIONS_V.ATTRIBUTE12%TYPE,
65: attribute5 OKL_INS_EXCLUSIONS_V.ATTRIBUTE5%TYPE,
66: attribute6 OKL_INS_EXCLUSIONS_V.ATTRIBUTE6%TYPE,
67: attribute7 OKL_INS_EXCLUSIONS_V.ATTRIBUTE7%TYPE,
68: attribute8 OKL_INS_EXCLUSIONS_V.ATTRIBUTE8%TYPE,
69: attribute9 OKL_INS_EXCLUSIONS_V.ATTRIBUTE9%TYPE,
70: attribute10 OKL_INS_EXCLUSIONS_V.ATTRIBUTE10%TYPE,
71: attribute11 OKL_INS_EXCLUSIONS_V.ATTRIBUTE11%TYPE,
72: attribute12 OKL_INS_EXCLUSIONS_V.ATTRIBUTE12%TYPE,
73: attribute13 OKL_INS_EXCLUSIONS_V.ATTRIBUTE13%TYPE,
66: attribute6 OKL_INS_EXCLUSIONS_V.ATTRIBUTE6%TYPE,
67: attribute7 OKL_INS_EXCLUSIONS_V.ATTRIBUTE7%TYPE,
68: attribute8 OKL_INS_EXCLUSIONS_V.ATTRIBUTE8%TYPE,
69: attribute9 OKL_INS_EXCLUSIONS_V.ATTRIBUTE9%TYPE,
70: attribute10 OKL_INS_EXCLUSIONS_V.ATTRIBUTE10%TYPE,
71: attribute11 OKL_INS_EXCLUSIONS_V.ATTRIBUTE11%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,
67: attribute7 OKL_INS_EXCLUSIONS_V.ATTRIBUTE7%TYPE,
68: attribute8 OKL_INS_EXCLUSIONS_V.ATTRIBUTE8%TYPE,
69: attribute9 OKL_INS_EXCLUSIONS_V.ATTRIBUTE9%TYPE,
70: attribute10 OKL_INS_EXCLUSIONS_V.ATTRIBUTE10%TYPE,
71: attribute11 OKL_INS_EXCLUSIONS_V.ATTRIBUTE11%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,
68: attribute8 OKL_INS_EXCLUSIONS_V.ATTRIBUTE8%TYPE,
69: attribute9 OKL_INS_EXCLUSIONS_V.ATTRIBUTE9%TYPE,
70: attribute10 OKL_INS_EXCLUSIONS_V.ATTRIBUTE10%TYPE,
71: attribute11 OKL_INS_EXCLUSIONS_V.ATTRIBUTE11%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,
69: attribute9 OKL_INS_EXCLUSIONS_V.ATTRIBUTE9%TYPE,
70: attribute10 OKL_INS_EXCLUSIONS_V.ATTRIBUTE10%TYPE,
71: attribute11 OKL_INS_EXCLUSIONS_V.ATTRIBUTE11%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,
70: attribute10 OKL_INS_EXCLUSIONS_V.ATTRIBUTE10%TYPE,
71: attribute11 OKL_INS_EXCLUSIONS_V.ATTRIBUTE11%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,
71: attribute11 OKL_INS_EXCLUSIONS_V.ATTRIBUTE11%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,
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,
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: );
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