55: );
56:
57: -- Do not include WHO, LANGUAGE and SFWT_FLAG columns in the _TL record structure
58: TYPE vldtl_rec_type IS RECORD (
59: id okl_validations_tl.id%TYPE
60: ,short_description okl_validations_tl.short_description%TYPE
61: ,description okl_validations_tl.description%TYPE
62: ,comments okl_validations_tl.comments%TYPE
63: );
56:
57: -- Do not include WHO, LANGUAGE and SFWT_FLAG columns in the _TL record structure
58: TYPE vldtl_rec_type IS RECORD (
59: id okl_validations_tl.id%TYPE
60: ,short_description okl_validations_tl.short_description%TYPE
61: ,description okl_validations_tl.description%TYPE
62: ,comments okl_validations_tl.comments%TYPE
63: );
64:
57: -- Do not include WHO, LANGUAGE and SFWT_FLAG columns in the _TL record structure
58: TYPE vldtl_rec_type IS RECORD (
59: id okl_validations_tl.id%TYPE
60: ,short_description okl_validations_tl.short_description%TYPE
61: ,description okl_validations_tl.description%TYPE
62: ,comments okl_validations_tl.comments%TYPE
63: );
64:
65: -- view record structure
58: TYPE vldtl_rec_type IS RECORD (
59: id okl_validations_tl.id%TYPE
60: ,short_description okl_validations_tl.short_description%TYPE
61: ,description okl_validations_tl.description%TYPE
62: ,comments okl_validations_tl.comments%TYPE
63: );
64:
65: -- view record structure
66: TYPE vldv_rec_type IS RECORD (
84: ,attribute15 okl_validations_b.attribute15%TYPE
85: ,validation_set_id okl_validations_b.validation_set_id%TYPE
86: ,function_id okl_validations_b.function_id%TYPE
87: ,failure_severity okl_validations_b.failure_severity%TYPE
88: ,short_description okl_validations_tl.short_description%TYPE
89: ,description okl_validations_tl.description%TYPE
90: ,comments okl_validations_tl.comments%TYPE
91: );
92:
85: ,validation_set_id okl_validations_b.validation_set_id%TYPE
86: ,function_id okl_validations_b.function_id%TYPE
87: ,failure_severity okl_validations_b.failure_severity%TYPE
88: ,short_description okl_validations_tl.short_description%TYPE
89: ,description okl_validations_tl.description%TYPE
90: ,comments okl_validations_tl.comments%TYPE
91: );
92:
93: TYPE vldv_tbl_type IS TABLE OF vldv_rec_type INDEX BY BINARY_INTEGER;
86: ,function_id okl_validations_b.function_id%TYPE
87: ,failure_severity okl_validations_b.failure_severity%TYPE
88: ,short_description okl_validations_tl.short_description%TYPE
89: ,description okl_validations_tl.description%TYPE
90: ,comments okl_validations_tl.comments%TYPE
91: );
92:
93: TYPE vldv_tbl_type IS TABLE OF vldv_rec_type INDEX BY BINARY_INTEGER;
94: