DBA Data[Home] [Help]

APPS.QP_MULTI_CURRENCY_PVT dependencies on QP_PREQ_LINE_ATTRS_FORMULA_TMP

Line 118: delete from qp_preq_line_attrs_formula_tmp;

114: -- Change flexible mask to mask below for formula pattern use
115: /*qp_number.canonical_mask :=
116: '00999999999999999999999.99999999999999999999999999999999999999';*/ --Bug No: 8427852
117:
118: delete from qp_preq_line_attrs_formula_tmp;
119:
120: IF qp_util.attrmgr_installed = 'Y' THEN
121: --Begin Bug No: 8427852
122:

Line 143: INSERT INTO qp_preq_line_attrs_formula_tmp

139:
140: qp_number.canonical_mask := '00999999999999999999999.99999999999999999999999999999999999999';
141:
142: FORALL i IN l_line_index_tbl.FIRST..l_line_index_tbl.LAST
143: INSERT INTO qp_preq_line_attrs_formula_tmp
144: (line_index, attribute_type, context,
145: attribute, pricing_status_code, value_from)
146: VALUES
147: ( l_line_index_tbl(i), l_attribute_type_tbl(i), l_context_tbl(i),

Line 159: qp_preq_line_attrs_formula_tmp

155:
156: --commented for Bug No: 8427852
157: -- Insert request line attributes with datatype = 'N'
158: /* INSERT INTO
159: qp_preq_line_attrs_formula_tmp
160: (
161: line_index
162: ,attribute_type
163: ,context

Line 198: qp_preq_line_attrs_formula_tmp

194: --End Bug No: 8427852
195:
196: -- Insert request line attributes with datatype 'X','Y','C' or null
197: INSERT INTO
198: qp_preq_line_attrs_formula_tmp
199: (
200: line_index
201: ,attribute_type
202: ,context

Line 256: INSERT INTO qp_preq_line_attrs_formula_tmp

252:
253: qp_number.canonical_mask := '00999999999999999999999.99999999999999999999999999999999999999';
254:
255: FORALL i IN l_line_index_tbl.FIRST..l_line_index_tbl.LAST
256: INSERT INTO qp_preq_line_attrs_formula_tmp
257: (line_index, attribute_type, context,
258: attribute, pricing_status_code, value_from)
259: VALUES
260: ( l_line_index_tbl(i), l_attribute_type_tbl(i), l_context_tbl(i),

Line 271: qp_preq_line_attrs_formula_tmp

267: CLOSE attr_cur;
268: --commented for Bug No: 8427852
269: -- Insert request line attributes with datatype = 'N'
270: /*INSERT INTO
271: qp_preq_line_attrs_formula_tmp
272: (
273: line_index
274: ,attribute_type
275: ,context

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

303: AND vset.format_type = 'N'
304: ) ;*/
305: -- AND
306: -- NOT EXISTS
307: -- (SELECT 'x' FROM qp_preq_line_attrs_formula_tmp
308: -- WHERE line_index = lattr.line_index);
309: --End Bug No: 8427852
310:
311: -- Insert request line attributes with datatype 'X','Y','C' or null

Line 313: qp_preq_line_attrs_formula_tmp

309: --End Bug No: 8427852
310:
311: -- Insert request line attributes with datatype 'X','Y','C' or null
312: INSERT INTO
313: qp_preq_line_attrs_formula_tmp
314: (
315: line_index
316: ,attribute_type
317: ,context

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

346: AND vset.format_type = 'N'
347: );
348: --AND
349: -- NOT EXISTS
350: -- (SELECT 'x' FROM qp_preq_line_attrs_formula_tmp
351: -- WHERE line_index = lattr.line_index);
352:
353: END IF; -- attribute manager installed
354: --Change mask back to flexible mask.