49: -- Change flexible mask to mask below for formula pattern use
50: qp_number.canonical_mask :=
51: '00999999999999999999999.99999999999999999999999999999999999999';
52:
53: delete from qp_preq_line_attrs_formula_tmp;
54:
55: IF qp_util.attrmgr_installed = 'Y' THEN
56: -- Insert request line attributes with datatype = 'N'
57: INSERT INTO
54:
55: IF qp_util.attrmgr_installed = 'Y' THEN
56: -- Insert request line attributes with datatype = 'N'
57: INSERT INTO
58: qp_preq_line_attrs_formula_tmp
59: (
60: line_index
61: ,attribute_type
62: ,context
91: AND vset.format_type = 'N'
92: );
93: -- Insert request line attributes with datatype 'X','Y','C' or null
94: INSERT INTO
95: qp_preq_line_attrs_formula_tmp
96: (
97: line_index
98: ,attribute_type
99: ,context
130:
131: ELSE
132: -- Insert request line attributes with datatype = 'N'
133: INSERT INTO
134: qp_preq_line_attrs_formula_tmp
135: (
136: line_index
137: ,attribute_type
138: ,context
166: AND vset.format_type = 'N'
167: );
168: -- AND
169: -- NOT EXISTS
170: -- (SELECT 'x' FROM qp_preq_line_attrs_formula_tmp
171: -- WHERE line_index = lattr.line_index);
172:
173: -- Insert request line attributes with datatype 'X','Y','C' or null
174: INSERT INTO
171: -- WHERE line_index = lattr.line_index);
172:
173: -- Insert request line attributes with datatype 'X','Y','C' or null
174: INSERT INTO
175: qp_preq_line_attrs_formula_tmp
176: (
177: line_index
178: ,attribute_type
179: ,context
208: AND vset.format_type = 'N'
209: );
210: --AND
211: -- NOT EXISTS
212: -- (SELECT 'x' FROM qp_preq_line_attrs_formula_tmp
213: -- WHERE line_index = lattr.line_index);
214:
215: END IF; -- attribute manager installed
216: --Change mask back to flexible mask.