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_DENORMALIZED_PRICING_ATTRS dependencies on QP_NUMBER

Line 312: LEAST(qp_number.number_to_canonical(pricing_attr_value_from_number),

308: --pricing_attr_value_from and pricing_attr_value_to are negative.
309: FORALL k IN l_list_header_id_tbl.FIRST..l_list_header_id_tbl.LAST
310: UPDATE qp_pricing_attributes
311: SET pattern_value_from_negative =
312: LEAST(qp_number.number_to_canonical(pricing_attr_value_from_number),
313: qp_number.number_to_canonical(pricing_attr_value_to_number)),
314: pattern_value_to_negative =
315: GREATEST(
316: qp_number.number_to_canonical(pricing_attr_value_from_number),

Line 313: qp_number.number_to_canonical(pricing_attr_value_to_number)),

309: FORALL k IN l_list_header_id_tbl.FIRST..l_list_header_id_tbl.LAST
310: UPDATE qp_pricing_attributes
311: SET pattern_value_from_negative =
312: LEAST(qp_number.number_to_canonical(pricing_attr_value_from_number),
313: qp_number.number_to_canonical(pricing_attr_value_to_number)),
314: pattern_value_to_negative =
315: GREATEST(
316: qp_number.number_to_canonical(pricing_attr_value_from_number),
317: qp_number.number_to_canonical(pricing_attr_value_to_number)),

Line 316: qp_number.number_to_canonical(pricing_attr_value_from_number),

312: LEAST(qp_number.number_to_canonical(pricing_attr_value_from_number),
313: qp_number.number_to_canonical(pricing_attr_value_to_number)),
314: pattern_value_to_negative =
315: GREATEST(
316: qp_number.number_to_canonical(pricing_attr_value_from_number),
317: qp_number.number_to_canonical(pricing_attr_value_to_number)),
318: pattern_value_from_positive = null,
319: pattern_value_to_positive = null
320: WHERE comparison_operator_code = 'BETWEEN'

Line 317: qp_number.number_to_canonical(pricing_attr_value_to_number)),

313: qp_number.number_to_canonical(pricing_attr_value_to_number)),
314: pattern_value_to_negative =
315: GREATEST(
316: qp_number.number_to_canonical(pricing_attr_value_from_number),
317: qp_number.number_to_canonical(pricing_attr_value_to_number)),
318: pattern_value_from_positive = null,
319: pattern_value_to_positive = null
320: WHERE comparison_operator_code = 'BETWEEN'
321: AND pricing_attribute_datatype = 'N'

Line 331: LEAST(qp_number.number_to_canonical(pricing_attr_value_from_number),

327: --pricing_attr_value_from and pricing_attr_value_to are positive.
328: FORALL k IN l_list_header_id_tbl.FIRST..l_list_header_id_tbl.LAST
329: UPDATE qp_pricing_attributes
330: SET pattern_value_from_positive =
331: LEAST(qp_number.number_to_canonical(pricing_attr_value_from_number),
332: qp_number.number_to_canonical(pricing_attr_value_to_number)),
333: pattern_value_to_positive =
334: GREATEST(
335: qp_number.number_to_canonical(pricing_attr_value_from_number),

Line 332: qp_number.number_to_canonical(pricing_attr_value_to_number)),

328: FORALL k IN l_list_header_id_tbl.FIRST..l_list_header_id_tbl.LAST
329: UPDATE qp_pricing_attributes
330: SET pattern_value_from_positive =
331: LEAST(qp_number.number_to_canonical(pricing_attr_value_from_number),
332: qp_number.number_to_canonical(pricing_attr_value_to_number)),
333: pattern_value_to_positive =
334: GREATEST(
335: qp_number.number_to_canonical(pricing_attr_value_from_number),
336: qp_number.number_to_canonical(pricing_attr_value_to_number)),

Line 335: qp_number.number_to_canonical(pricing_attr_value_from_number),

331: LEAST(qp_number.number_to_canonical(pricing_attr_value_from_number),
332: qp_number.number_to_canonical(pricing_attr_value_to_number)),
333: pattern_value_to_positive =
334: GREATEST(
335: qp_number.number_to_canonical(pricing_attr_value_from_number),
336: qp_number.number_to_canonical(pricing_attr_value_to_number)),
337: pattern_value_from_negative = null,
338: pattern_value_to_negative = null
339: WHERE comparison_operator_code = 'BETWEEN'

Line 336: qp_number.number_to_canonical(pricing_attr_value_to_number)),

332: qp_number.number_to_canonical(pricing_attr_value_to_number)),
333: pattern_value_to_positive =
334: GREATEST(
335: qp_number.number_to_canonical(pricing_attr_value_from_number),
336: qp_number.number_to_canonical(pricing_attr_value_to_number)),
337: pattern_value_from_negative = null,
338: pattern_value_to_negative = null
339: WHERE comparison_operator_code = 'BETWEEN'
340: AND pricing_attribute_datatype = 'N'

Line 350: '-' || LTRIM(qp_number.number_to_canonical(0)),

346: --operator is between and pricing attribute datatype is 'N'.
347: FORALL k IN l_list_header_id_tbl.FIRST..l_list_header_id_tbl.LAST
348: UPDATE qp_pricing_attributes
349: SET pattern_value_from_negative =
350: '-' || LTRIM(qp_number.number_to_canonical(0)),
351: pattern_value_to_negative =
352: qp_number.number_to_canonical(pricing_attr_value_from_number),
353: pattern_value_from_positive = null,
354: pattern_value_to_positive = null

Line 352: qp_number.number_to_canonical(pricing_attr_value_from_number),

348: UPDATE qp_pricing_attributes
349: SET pattern_value_from_negative =
350: '-' || LTRIM(qp_number.number_to_canonical(0)),
351: pattern_value_to_negative =
352: qp_number.number_to_canonical(pricing_attr_value_from_number),
353: pattern_value_from_positive = null,
354: pattern_value_to_positive = null
355: WHERE comparison_operator_code = 'BETWEEN'
356: AND pricing_attribute_datatype = 'N'

Line 366: '-' || LTRIM(qp_number.number_to_canonical(0)),

362: --positive, operator is between and pricing attribute datatype is 'N'.
363: FORALL k IN l_list_header_id_tbl.FIRST..l_list_header_id_tbl.LAST
364: UPDATE qp_pricing_attributes
365: SET pattern_value_from_negative =
366: '-' || LTRIM(qp_number.number_to_canonical(0)),
367: pattern_value_to_negative =
368: qp_number.number_to_canonical(pricing_attr_value_from_number),
369: pattern_value_from_positive = qp_number.number_to_canonical(0),
370: pattern_value_to_positive =

Line 368: qp_number.number_to_canonical(pricing_attr_value_from_number),

364: UPDATE qp_pricing_attributes
365: SET pattern_value_from_negative =
366: '-' || LTRIM(qp_number.number_to_canonical(0)),
367: pattern_value_to_negative =
368: qp_number.number_to_canonical(pricing_attr_value_from_number),
369: pattern_value_from_positive = qp_number.number_to_canonical(0),
370: pattern_value_to_positive =
371: qp_number.number_to_canonical(pricing_attr_value_to_number)
372: WHERE comparison_operator_code = 'BETWEEN'

Line 369: pattern_value_from_positive = qp_number.number_to_canonical(0),

365: SET pattern_value_from_negative =
366: '-' || LTRIM(qp_number.number_to_canonical(0)),
367: pattern_value_to_negative =
368: qp_number.number_to_canonical(pricing_attr_value_from_number),
369: pattern_value_from_positive = qp_number.number_to_canonical(0),
370: pattern_value_to_positive =
371: qp_number.number_to_canonical(pricing_attr_value_to_number)
372: WHERE comparison_operator_code = 'BETWEEN'
373: AND pricing_attribute_datatype = 'N'

Line 371: qp_number.number_to_canonical(pricing_attr_value_to_number)

367: pattern_value_to_negative =
368: qp_number.number_to_canonical(pricing_attr_value_from_number),
369: pattern_value_from_positive = qp_number.number_to_canonical(0),
370: pattern_value_to_positive =
371: qp_number.number_to_canonical(pricing_attr_value_to_number)
372: WHERE comparison_operator_code = 'BETWEEN'
373: AND pricing_attribute_datatype = 'N'
374: AND list_header_id = l_list_header_id_tbl(k)
375: AND pricing_attr_value_from_number < 0

Line 383: qp_number.number_to_canonical(pricing_attr_value_from_number),

379: --pricing_attr_value_from is positive.
380: FORALL k IN l_list_header_id_tbl.FIRST..l_list_header_id_tbl.LAST
381: UPDATE qp_pricing_attributes
382: SET pattern_value_from_positive =
383: qp_number.number_to_canonical(pricing_attr_value_from_number),
384: pattern_value_to_positive =
385: qp_number.number_to_canonical(pricing_attr_value_from_number),
386: pattern_value_from_negative = null,
387: pattern_value_to_negative = null

Line 385: qp_number.number_to_canonical(pricing_attr_value_from_number),

381: UPDATE qp_pricing_attributes
382: SET pattern_value_from_positive =
383: qp_number.number_to_canonical(pricing_attr_value_from_number),
384: pattern_value_to_positive =
385: qp_number.number_to_canonical(pricing_attr_value_from_number),
386: pattern_value_from_negative = null,
387: pattern_value_to_negative = null
388: WHERE comparison_operator_code = '='
389: AND pricing_attribute_datatype = 'N'

Line 398: qp_number.number_to_canonical(pricing_attr_value_from_number),

394: --pricing_attr_value_from is negative.
395: FORALL k IN l_list_header_id_tbl.FIRST..l_list_header_id_tbl.LAST
396: UPDATE qp_pricing_attributes
397: SET pattern_value_from_negative =
398: qp_number.number_to_canonical(pricing_attr_value_from_number),
399: pattern_value_to_negative =
400: qp_number.number_to_canonical(pricing_attr_value_from_number),
401: pattern_value_from_positive = null,
402: pattern_value_to_positive = null

Line 400: qp_number.number_to_canonical(pricing_attr_value_from_number),

396: UPDATE qp_pricing_attributes
397: SET pattern_value_from_negative =
398: qp_number.number_to_canonical(pricing_attr_value_from_number),
399: pattern_value_to_negative =
400: qp_number.number_to_canonical(pricing_attr_value_from_number),
401: pattern_value_from_positive = null,
402: pattern_value_to_positive = null
403: WHERE comparison_operator_code = '='
404: AND pricing_attribute_datatype = 'N'

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

437:
438: l_list_header_id_tbl.DELETE; --Clear the plsql table.
439:
440: --Set the format mask for the canonical form of numbers
441: qp_number.canonical_mask := 'FM999999999999999999999.9999999999999999999999999999999999999999';
442:
443: --dbms_output.put_line('Updated Search_Ind columns');
444: --dbms_output.put_line('Updated Pattern_value_from/Pattern_value_to columns');
445: