51:
52: -- type declaration to be used in quote-to-contract scenario
53: -- helps figure out what line style to use
54:
55: TYPE line_style_rec_type IS RECORD (lty_code okc_line_styles_v.lty_code%TYPE
56: ,priced_yn okc_line_styles_v.priced_yn%TYPE
57: ,service_item_yn okc_line_styles_v.service_item_yn%TYPE -- GF bug=2291968
58:
59: --new pricing columns
52: -- type declaration to be used in quote-to-contract scenario
53: -- helps figure out what line style to use
54:
55: TYPE line_style_rec_type IS RECORD (lty_code okc_line_styles_v.lty_code%TYPE
56: ,priced_yn okc_line_styles_v.priced_yn%TYPE
57: ,service_item_yn okc_line_styles_v.service_item_yn%TYPE -- GF bug=2291968
58:
59: --new pricing columns
60: ,item_to_price_yn okc_line_styles_v.item_to_price_yn%TYPE
53: -- helps figure out what line style to use
54:
55: TYPE line_style_rec_type IS RECORD (lty_code okc_line_styles_v.lty_code%TYPE
56: ,priced_yn okc_line_styles_v.priced_yn%TYPE
57: ,service_item_yn okc_line_styles_v.service_item_yn%TYPE -- GF bug=2291968
58:
59: --new pricing columns
60: ,item_to_price_yn okc_line_styles_v.item_to_price_yn%TYPE
61: ,price_basis_yn okc_line_styles_v.price_basis_yn%TYPE
56: ,priced_yn okc_line_styles_v.priced_yn%TYPE
57: ,service_item_yn okc_line_styles_v.service_item_yn%TYPE -- GF bug=2291968
58:
59: --new pricing columns
60: ,item_to_price_yn okc_line_styles_v.item_to_price_yn%TYPE
61: ,price_basis_yn okc_line_styles_v.price_basis_yn%TYPE
62:
63: ,lse_id okc_line_styles_v.id%TYPE
64: ,lse_name okc_line_styles_v.name%TYPE
57: ,service_item_yn okc_line_styles_v.service_item_yn%TYPE -- GF bug=2291968
58:
59: --new pricing columns
60: ,item_to_price_yn okc_line_styles_v.item_to_price_yn%TYPE
61: ,price_basis_yn okc_line_styles_v.price_basis_yn%TYPE
62:
63: ,lse_id okc_line_styles_v.id%TYPE
64: ,lse_name okc_line_styles_v.name%TYPE
65: ,object_code jtf_objects_b.object_code%TYPE
59: --new pricing columns
60: ,item_to_price_yn okc_line_styles_v.item_to_price_yn%TYPE
61: ,price_basis_yn okc_line_styles_v.price_basis_yn%TYPE
62:
63: ,lse_id okc_line_styles_v.id%TYPE
64: ,lse_name okc_line_styles_v.name%TYPE
65: ,object_code jtf_objects_b.object_code%TYPE
66: ,where_clause jtf_objects_b.where_clause%TYPE
67: ,from_table jtf_objects_b.from_table%TYPE --Added by RG 04/20/2000
60: ,item_to_price_yn okc_line_styles_v.item_to_price_yn%TYPE
61: ,price_basis_yn okc_line_styles_v.price_basis_yn%TYPE
62:
63: ,lse_id okc_line_styles_v.id%TYPE
64: ,lse_name okc_line_styles_v.name%TYPE
65: ,object_code jtf_objects_b.object_code%TYPE
66: ,where_clause jtf_objects_b.where_clause%TYPE
67: ,from_table jtf_objects_b.from_table%TYPE --Added by RG 04/20/2000
68:
65: ,object_code jtf_objects_b.object_code%TYPE
66: ,where_clause jtf_objects_b.where_clause%TYPE
67: ,from_table jtf_objects_b.from_table%TYPE --Added by RG 04/20/2000
68:
69: ,recursive_yn okc_line_styles_v.recursive_yn%TYPE
70: --added for configurator model line
71: );
72:
73: TYPE line_style_tab_type IS TABLE OF line_style_rec_type INDEX BY BINARY_INTEGER;
74:
75: --
76: -- sub line style record definition
77:
78: TYPE sub_line_style_rec_type is RECORD (lty_code okc_line_styles_v.lty_code%TYPE
79: ,priced_yn okc_line_styles_v.priced_yn%TYPE
80: ,service_item_yn okc_line_styles_v.service_item_yn%TYPE -- GF bug=2291968
81: ,lse_id okc_line_styles_v.id%TYPE
82: ,lse_name okc_line_styles_v.name%TYPE
75: --
76: -- sub line style record definition
77:
78: TYPE sub_line_style_rec_type is RECORD (lty_code okc_line_styles_v.lty_code%TYPE
79: ,priced_yn okc_line_styles_v.priced_yn%TYPE
80: ,service_item_yn okc_line_styles_v.service_item_yn%TYPE -- GF bug=2291968
81: ,lse_id okc_line_styles_v.id%TYPE
82: ,lse_name okc_line_styles_v.name%TYPE
83: ,object_code jtf_objects_b.object_code%TYPE
76: -- sub line style record definition
77:
78: TYPE sub_line_style_rec_type is RECORD (lty_code okc_line_styles_v.lty_code%TYPE
79: ,priced_yn okc_line_styles_v.priced_yn%TYPE
80: ,service_item_yn okc_line_styles_v.service_item_yn%TYPE -- GF bug=2291968
81: ,lse_id okc_line_styles_v.id%TYPE
82: ,lse_name okc_line_styles_v.name%TYPE
83: ,object_code jtf_objects_b.object_code%TYPE
84: ,from_table jtf_objects_b.from_table%TYPE
77:
78: TYPE sub_line_style_rec_type is RECORD (lty_code okc_line_styles_v.lty_code%TYPE
79: ,priced_yn okc_line_styles_v.priced_yn%TYPE
80: ,service_item_yn okc_line_styles_v.service_item_yn%TYPE -- GF bug=2291968
81: ,lse_id okc_line_styles_v.id%TYPE
82: ,lse_name okc_line_styles_v.name%TYPE
83: ,object_code jtf_objects_b.object_code%TYPE
84: ,from_table jtf_objects_b.from_table%TYPE
85: ,where_clause jtf_objects_b.where_clause%TYPE );
78: TYPE sub_line_style_rec_type is RECORD (lty_code okc_line_styles_v.lty_code%TYPE
79: ,priced_yn okc_line_styles_v.priced_yn%TYPE
80: ,service_item_yn okc_line_styles_v.service_item_yn%TYPE -- GF bug=2291968
81: ,lse_id okc_line_styles_v.id%TYPE
82: ,lse_name okc_line_styles_v.name%TYPE
83: ,object_code jtf_objects_b.object_code%TYPE
84: ,from_table jtf_objects_b.from_table%TYPE
85: ,where_clause jtf_objects_b.where_clause%TYPE );
86: