62: );
63:
64: -- Do not include WHO, LANGUAGE and SFWT_FLAG columns in the _TL record structure
65: TYPE qqltl_rec_type IS RECORD (
66: id okl_quick_quote_lines_tl.id%TYPE
67: ,short_description okl_quick_quote_lines_tl.short_description%TYPE
68: ,description okl_quick_quote_lines_tl.description%TYPE
69: ,comments okl_quick_quote_lines_tl.comments%TYPE
70: );
63:
64: -- Do not include WHO, LANGUAGE and SFWT_FLAG columns in the _TL record structure
65: TYPE qqltl_rec_type IS RECORD (
66: id okl_quick_quote_lines_tl.id%TYPE
67: ,short_description okl_quick_quote_lines_tl.short_description%TYPE
68: ,description okl_quick_quote_lines_tl.description%TYPE
69: ,comments okl_quick_quote_lines_tl.comments%TYPE
70: );
71:
64: -- Do not include WHO, LANGUAGE and SFWT_FLAG columns in the _TL record structure
65: TYPE qqltl_rec_type IS RECORD (
66: id okl_quick_quote_lines_tl.id%TYPE
67: ,short_description okl_quick_quote_lines_tl.short_description%TYPE
68: ,description okl_quick_quote_lines_tl.description%TYPE
69: ,comments okl_quick_quote_lines_tl.comments%TYPE
70: );
71:
72: -- view record structure
65: TYPE qqltl_rec_type IS RECORD (
66: id okl_quick_quote_lines_tl.id%TYPE
67: ,short_description okl_quick_quote_lines_tl.short_description%TYPE
68: ,description okl_quick_quote_lines_tl.description%TYPE
69: ,comments okl_quick_quote_lines_tl.comments%TYPE
70: );
71:
72: -- view record structure
73: TYPE qqlv_rec_type IS RECORD (
98: ,percentage_of_total_cost okl_quick_quote_lines_b.percentage_of_total_cost%TYPE
99: ,item_category_id okl_quick_quote_lines_b.item_category_id%TYPE
100: ,item_category_set_id okl_quick_quote_lines_b.item_category_set_id%TYPE
101: ,lease_rate_factor okl_quick_quote_lines_b.lease_rate_factor%TYPE
102: ,short_description okl_quick_quote_lines_tl.short_description%TYPE
103: ,description okl_quick_quote_lines_tl.description%TYPE
104: ,comments okl_quick_quote_lines_tl.comments%TYPE
105: );
106:
99: ,item_category_id okl_quick_quote_lines_b.item_category_id%TYPE
100: ,item_category_set_id okl_quick_quote_lines_b.item_category_set_id%TYPE
101: ,lease_rate_factor okl_quick_quote_lines_b.lease_rate_factor%TYPE
102: ,short_description okl_quick_quote_lines_tl.short_description%TYPE
103: ,description okl_quick_quote_lines_tl.description%TYPE
104: ,comments okl_quick_quote_lines_tl.comments%TYPE
105: );
106:
107: TYPE qqlv_tbl_type IS TABLE OF qqlv_rec_type INDEX BY BINARY_INTEGER;
100: ,item_category_set_id okl_quick_quote_lines_b.item_category_set_id%TYPE
101: ,lease_rate_factor okl_quick_quote_lines_b.lease_rate_factor%TYPE
102: ,short_description okl_quick_quote_lines_tl.short_description%TYPE
103: ,description okl_quick_quote_lines_tl.description%TYPE
104: ,comments okl_quick_quote_lines_tl.comments%TYPE
105: );
106:
107: TYPE qqlv_tbl_type IS TABLE OF qqlv_rec_type INDEX BY BINARY_INTEGER;
108: