eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.QP_MULTI_CURRENCY_PVT dependencies on QP_NUMBER

Line 32: , qp_number.canonical_to_number(value_from)

28: , attribute_type
29: , context
30: , attribute
31: , pricing_status_code
32: , qp_number.canonical_to_number(value_from)
33: FROM qp_npreq_line_attrs_tmp lattr
34: WHERE attribute_type IN ('PRICING', 'PRODUCT')
35: AND pricing_status_code = QP_PREQ_GRP.G_STATUS_UNCHANGED
36: AND EXISTS (

Line 55: ,qp_number.canonical_to_number(value_from)

51: ,attribute_type
52: ,context
53: ,attribute
54: ,pricing_status_code
55: ,qp_number.canonical_to_number(value_from)
56: FROM qp_npreq_line_attrs_tmp lattr
57: WHERE attribute_type IN ('PRICING', 'PRODUCT')
58: AND pricing_status_code = QP_PREQ_GRP.G_STATUS_UNCHANGED
59: AND EXISTS(

Line 115: /*qp_number.canonical_mask :=

111:
112: IF l_insert_into_tmp = 'Y' THEN
113:
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:

Line 124: qp_number.canonical_mask := 'FM999999999999999999999.9999999999999999999999999999999999999999';

120: IF qp_util.attrmgr_installed = 'Y' THEN
121: --Begin Bug No: 8427852
122:
123: OPEN am_attr_cur;
124: qp_number.canonical_mask := 'FM999999999999999999999.9999999999999999999999999999999999999999';
125: LOOP
126: l_line_index_tbl.delete;
127: l_attribute_type_tbl.delete;
128: l_context_tbl.delete;

Line 140: qp_number.canonical_mask := '00999999999999999999999.99999999999999999999999999999999999999';

136: l_value_from_tbl
137: LIMIT l_rows;
138: EXIT WHEN l_line_index_tbl.COUNT = 0;
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,

Line 149: qp_number.number_to_canonical(l_value_from_tbl(i))

145: attribute, pricing_status_code, value_from)
146: VALUES
147: ( l_line_index_tbl(i), l_attribute_type_tbl(i), l_context_tbl(i),
148: l_attribute_tbl(i), l_pricing_status_code_tbl(i),
149: qp_number.number_to_canonical(l_value_from_tbl(i))
150: );
151:
152: qp_number.canonical_mask := 'FM999999999999999999999.9999999999999999999999999999999999999999';
153: END LOOP;

Line 152: qp_number.canonical_mask := 'FM999999999999999999999.9999999999999999999999999999999999999999';

148: l_attribute_tbl(i), l_pricing_status_code_tbl(i),
149: qp_number.number_to_canonical(l_value_from_tbl(i))
150: );
151:
152: qp_number.canonical_mask := 'FM999999999999999999999.9999999999999999999999999999999999999999';
153: END LOOP;
154: CLOSE am_attr_cur;
155:
156: --commented for Bug No: 8427852

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

170: ,attribute_type
171: ,context
172: ,attribute
173: ,pricing_status_code
174: ,qp_number.number_to_canonical(to_number(value_from))
175: FROM
176: qp_npreq_line_attrs_tmp lattr
177: WHERE
178: attribute_type IN ('PRICING', 'PRODUCT')

Line 237: qp_number.canonical_mask := 'FM999999999999999999999.9999999999999999999999999999999999999999';

233:
234: ELSE
235: --Begin Bug No: 8427852
236: OPEN attr_cur;
237: qp_number.canonical_mask := 'FM999999999999999999999.9999999999999999999999999999999999999999';
238: LOOP
239: l_line_index_tbl.delete;
240: l_attribute_type_tbl.delete;
241: l_context_tbl.delete;

Line 253: qp_number.canonical_mask := '00999999999999999999999.99999999999999999999999999999999999999';

249: LIMIT l_rows;
250:
251: EXIT WHEN l_line_index_tbl.COUNT = 0;
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,

Line 262: qp_number.number_to_canonical(l_value_from_tbl(i))

258: attribute, pricing_status_code, value_from)
259: VALUES
260: ( l_line_index_tbl(i), l_attribute_type_tbl(i), l_context_tbl(i),
261: l_attribute_tbl(i), l_pricing_status_code_tbl(i),
262: qp_number.number_to_canonical(l_value_from_tbl(i))
263: );
264:
265: qp_number.canonical_mask := 'FM999999999999999999999.9999999999999999999999999999999999999999';
266: END LOOP;

Line 265: qp_number.canonical_mask := 'FM999999999999999999999.9999999999999999999999999999999999999999';

261: l_attribute_tbl(i), l_pricing_status_code_tbl(i),
262: qp_number.number_to_canonical(l_value_from_tbl(i))
263: );
264:
265: qp_number.canonical_mask := 'FM999999999999999999999.9999999999999999999999999999999999999999';
266: END LOOP;
267: CLOSE attr_cur;
268: --commented for Bug No: 8427852
269: -- Insert request line attributes with datatype = 'N'

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

282: ,attribute_type
283: ,context
284: ,attribute
285: ,pricing_status_code
286: ,qp_number.number_to_canonical(to_number(value_from))
287: FROM
288: qp_npreq_line_attrs_tmp lattr
289: WHERE
290: attribute_type IN ('PRICING', 'PRODUCT')

Line 355: qp_number.canonical_mask :=

351: -- WHERE line_index = lattr.line_index);
352:
353: END IF; -- attribute manager installed
354: --Change mask back to flexible mask.
355: qp_number.canonical_mask :=
356: 'FM999999999999999999999.9999999999999999999999999999999999999999';
357:
358: END IF;
359: