61: );
62:
63: -- Do not include WHO, LANGUAGE and SFWT_FLAG columns in the _TL record structure
64: TYPE asotl_rec_type IS RECORD (
65: id okl_asset_components_tl.id%TYPE
66: ,short_description okl_asset_components_tl.short_description%TYPE
67: ,description okl_asset_components_tl.description%TYPE
68: ,comments okl_asset_components_tl.comments%TYPE
69: );
62:
63: -- Do not include WHO, LANGUAGE and SFWT_FLAG columns in the _TL record structure
64: TYPE asotl_rec_type IS RECORD (
65: id okl_asset_components_tl.id%TYPE
66: ,short_description okl_asset_components_tl.short_description%TYPE
67: ,description okl_asset_components_tl.description%TYPE
68: ,comments okl_asset_components_tl.comments%TYPE
69: );
70:
63: -- Do not include WHO, LANGUAGE and SFWT_FLAG columns in the _TL record structure
64: TYPE asotl_rec_type IS RECORD (
65: id okl_asset_components_tl.id%TYPE
66: ,short_description okl_asset_components_tl.short_description%TYPE
67: ,description okl_asset_components_tl.description%TYPE
68: ,comments okl_asset_components_tl.comments%TYPE
69: );
70:
71: -- view record structure
64: TYPE asotl_rec_type IS RECORD (
65: id okl_asset_components_tl.id%TYPE
66: ,short_description okl_asset_components_tl.short_description%TYPE
67: ,description okl_asset_components_tl.description%TYPE
68: ,comments okl_asset_components_tl.comments%TYPE
69: );
70:
71: -- view record structure
72: TYPE asov_rec_type IS RECORD (
96: ,number_of_units okl_asset_components_b.number_of_units%TYPE
97: ,manufacturer_name okl_asset_components_b.manufacturer_name%TYPE
98: ,year_manufactured okl_asset_components_b.year_manufactured%TYPE
99: ,model_number okl_asset_components_b.model_number%TYPE
100: ,short_description okl_asset_components_tl.short_description%TYPE
101: ,description okl_asset_components_tl.description%TYPE
102: ,comments okl_asset_components_tl.comments%TYPE
103: );
104:
97: ,manufacturer_name okl_asset_components_b.manufacturer_name%TYPE
98: ,year_manufactured okl_asset_components_b.year_manufactured%TYPE
99: ,model_number okl_asset_components_b.model_number%TYPE
100: ,short_description okl_asset_components_tl.short_description%TYPE
101: ,description okl_asset_components_tl.description%TYPE
102: ,comments okl_asset_components_tl.comments%TYPE
103: );
104:
105: TYPE asov_tbl_type IS TABLE OF asov_rec_type INDEX BY BINARY_INTEGER;
98: ,year_manufactured okl_asset_components_b.year_manufactured%TYPE
99: ,model_number okl_asset_components_b.model_number%TYPE
100: ,short_description okl_asset_components_tl.short_description%TYPE
101: ,description okl_asset_components_tl.description%TYPE
102: ,comments okl_asset_components_tl.comments%TYPE
103: );
104:
105: TYPE asov_tbl_type IS TABLE OF asov_rec_type INDEX BY BINARY_INTEGER;
106: