DBA Data[Home] [Help]

APPS.QP_MULTI_CURRENCY_PVT dependencies on QP_NUMBER

Line 50: qp_number.canonical_mask :=

46:
47: IF l_insert_into_tmp = 'Y' THEN
48:
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:

Line 73: ,qp_number.number_to_canonical(to_number(value_from))

69: ,attribute_type
70: ,context
71: ,attribute
72: ,pricing_status_code
73: ,qp_number.number_to_canonical(to_number(value_from))
74: FROM
75: qp_npreq_line_attrs_tmp lattr
76: WHERE
77: attribute_type IN ('PRICING', 'PRODUCT')

Line 149: ,qp_number.number_to_canonical(to_number(value_from))

145: ,attribute_type
146: ,context
147: ,attribute
148: ,pricing_status_code
149: ,qp_number.number_to_canonical(to_number(value_from))
150: FROM
151: qp_npreq_line_attrs_tmp lattr
152: WHERE
153: attribute_type IN ('PRICING', 'PRODUCT')

Line 217: qp_number.canonical_mask :=

213: -- WHERE line_index = lattr.line_index);
214:
215: END IF; -- attribute manager installed
216: --Change mask back to flexible mask.
217: qp_number.canonical_mask :=
218: 'FM999999999999999999999.9999999999999999999999999999999999999999';
219:
220: END IF;
221: