DBA Data[Home] [Help]

APPS.QP_MULTI_CURRENCY_PVT dependencies on QP_PREQ_LINE_ATTRS_FORMULA_TMP

Line 53: delete from qp_preq_line_attrs_formula_tmp;

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

Line 58: 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
58: qp_preq_line_attrs_formula_tmp
59: (
60: line_index
61: ,attribute_type
62: ,context

Line 95: qp_preq_line_attrs_formula_tmp

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

Line 134: qp_preq_line_attrs_formula_tmp

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

Line 170: -- (SELECT 'x' FROM qp_preq_line_attrs_formula_tmp

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

Line 175: 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
175: qp_preq_line_attrs_formula_tmp
176: (
177: line_index
178: ,attribute_type
179: ,context

Line 212: -- (SELECT 'x' FROM qp_preq_line_attrs_formula_tmp

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.