56: );
57:
58: -- Do not include WHO, LANGUAGE and SFWT_FLAG columns in the _TL record structure
59: TYPE vlstl_rec_type IS RECORD (
60: id okl_validation_sets_tl.id%TYPE
61: ,short_description okl_validation_sets_tl.short_description%TYPE
62: ,description okl_validation_sets_tl.description%TYPE
63: ,comments okl_validation_sets_tl.comments%TYPE
64: );
57:
58: -- Do not include WHO, LANGUAGE and SFWT_FLAG columns in the _TL record structure
59: TYPE vlstl_rec_type IS RECORD (
60: id okl_validation_sets_tl.id%TYPE
61: ,short_description okl_validation_sets_tl.short_description%TYPE
62: ,description okl_validation_sets_tl.description%TYPE
63: ,comments okl_validation_sets_tl.comments%TYPE
64: );
65:
58: -- Do not include WHO, LANGUAGE and SFWT_FLAG columns in the _TL record structure
59: TYPE vlstl_rec_type IS RECORD (
60: id okl_validation_sets_tl.id%TYPE
61: ,short_description okl_validation_sets_tl.short_description%TYPE
62: ,description okl_validation_sets_tl.description%TYPE
63: ,comments okl_validation_sets_tl.comments%TYPE
64: );
65:
66: -- view record structure
59: TYPE vlstl_rec_type IS RECORD (
60: id okl_validation_sets_tl.id%TYPE
61: ,short_description okl_validation_sets_tl.short_description%TYPE
62: ,description okl_validation_sets_tl.description%TYPE
63: ,comments okl_validation_sets_tl.comments%TYPE
64: );
65:
66: -- view record structure
67: TYPE vlsv_rec_type IS RECORD (
86: ,org_id okl_validation_sets_b.org_id%TYPE
87: ,validation_set_name okl_validation_sets_b.validation_set_name%TYPE
88: ,effective_from okl_validation_sets_b.effective_from%TYPE
89: ,effective_to okl_validation_sets_b.effective_to%TYPE
90: ,short_description okl_validation_sets_tl.short_description%TYPE
91: ,description okl_validation_sets_tl.description%TYPE
92: ,comments okl_validation_sets_tl.comments%TYPE
93: );
94:
87: ,validation_set_name okl_validation_sets_b.validation_set_name%TYPE
88: ,effective_from okl_validation_sets_b.effective_from%TYPE
89: ,effective_to okl_validation_sets_b.effective_to%TYPE
90: ,short_description okl_validation_sets_tl.short_description%TYPE
91: ,description okl_validation_sets_tl.description%TYPE
92: ,comments okl_validation_sets_tl.comments%TYPE
93: );
94:
95: TYPE vlsv_tbl_type IS TABLE OF vlsv_rec_type INDEX BY BINARY_INTEGER;
88: ,effective_from okl_validation_sets_b.effective_from%TYPE
89: ,effective_to okl_validation_sets_b.effective_to%TYPE
90: ,short_description okl_validation_sets_tl.short_description%TYPE
91: ,description okl_validation_sets_tl.description%TYPE
92: ,comments okl_validation_sets_tl.comments%TYPE
93: );
94:
95: TYPE vlsv_tbl_type IS TABLE OF vlsv_rec_type INDEX BY BINARY_INTEGER;
96: