68: );
69:
70: -- Do not include WHO, LANGUAGE and SFWT_FLAG columns in the _TL record structure
71: TYPE asstl_rec_type IS RECORD (
72: id okl_assets_tl.id%TYPE
73: ,short_description okl_assets_tl.short_description%TYPE
74: ,description okl_assets_tl.description%TYPE
75: ,comments okl_assets_tl.comments%TYPE
76: );
69:
70: -- Do not include WHO, LANGUAGE and SFWT_FLAG columns in the _TL record structure
71: TYPE asstl_rec_type IS RECORD (
72: id okl_assets_tl.id%TYPE
73: ,short_description okl_assets_tl.short_description%TYPE
74: ,description okl_assets_tl.description%TYPE
75: ,comments okl_assets_tl.comments%TYPE
76: );
77:
70: -- Do not include WHO, LANGUAGE and SFWT_FLAG columns in the _TL record structure
71: TYPE asstl_rec_type IS RECORD (
72: id okl_assets_tl.id%TYPE
73: ,short_description okl_assets_tl.short_description%TYPE
74: ,description okl_assets_tl.description%TYPE
75: ,comments okl_assets_tl.comments%TYPE
76: );
77:
78: -- view record structure
71: TYPE asstl_rec_type IS RECORD (
72: id okl_assets_tl.id%TYPE
73: ,short_description okl_assets_tl.short_description%TYPE
74: ,description okl_assets_tl.description%TYPE
75: ,comments okl_assets_tl.comments%TYPE
76: );
77:
78: -- view record structure
79: TYPE assv_rec_type IS RECORD (
110: ,end_of_term_value okl_assets_b.end_of_term_value%TYPE
111: ,orig_asset_id okl_assets_b.orig_asset_id%TYPE
112: ,target_amount okl_assets_b.target_amount%TYPE
113: ,target_frequency okl_assets_b.target_frequency%TYPE
114: ,short_description okl_assets_tl.short_description%TYPE
115: ,description okl_assets_tl.description%TYPE
116: ,comments okl_assets_tl.comments%TYPE
117: );
118:
111: ,orig_asset_id okl_assets_b.orig_asset_id%TYPE
112: ,target_amount okl_assets_b.target_amount%TYPE
113: ,target_frequency okl_assets_b.target_frequency%TYPE
114: ,short_description okl_assets_tl.short_description%TYPE
115: ,description okl_assets_tl.description%TYPE
116: ,comments okl_assets_tl.comments%TYPE
117: );
118:
119: TYPE assv_tbl_type IS TABLE OF assv_rec_type INDEX BY BINARY_INTEGER;
112: ,target_amount okl_assets_b.target_amount%TYPE
113: ,target_frequency okl_assets_b.target_frequency%TYPE
114: ,short_description okl_assets_tl.short_description%TYPE
115: ,description okl_assets_tl.description%TYPE
116: ,comments okl_assets_tl.comments%TYPE
117: );
118:
119: TYPE assv_tbl_type IS TABLE OF assv_rec_type INDEX BY BINARY_INTEGER;
120: