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 310: qp_number.canonical_mask := '00999999999999999999999.99999999999999999999999999999999999999';

306: --datatype = 'N'and for other datatypes, populate the pricing_attr_value_from
307: --and to in the pattern_value_from and pattern_value_to columns
308:
309: --Set the format mask for the canonical form of numbers --bug 7696883
310: qp_number.canonical_mask := '00999999999999999999999.99999999999999999999999999999999999999';
311:
312: IF l_list_header_id_tbl.COUNT > 0 THEN
313: --When pricing attribute datatype is 'N', operator is between and both
314: --pricing_attr_value_from and pricing_attr_value_to are negative.

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

314: --pricing_attr_value_from and pricing_attr_value_to are negative.
315: FORALL k IN l_list_header_id_tbl.FIRST..l_list_header_id_tbl.LAST
316: UPDATE qp_pricing_attributes
317: SET pattern_value_from_negative =
318: LEAST(qp_number.number_to_canonical(pricing_attr_value_from_number),
319: qp_number.number_to_canonical(pricing_attr_value_to_number)),
320: pattern_value_to_negative =
321: GREATEST(
322: qp_number.number_to_canonical(pricing_attr_value_from_number),

Line 319: qp_number.number_to_canonical(pricing_attr_value_to_number)),

315: FORALL k IN l_list_header_id_tbl.FIRST..l_list_header_id_tbl.LAST
316: UPDATE qp_pricing_attributes
317: SET pattern_value_from_negative =
318: LEAST(qp_number.number_to_canonical(pricing_attr_value_from_number),
319: qp_number.number_to_canonical(pricing_attr_value_to_number)),
320: pattern_value_to_negative =
321: GREATEST(
322: qp_number.number_to_canonical(pricing_attr_value_from_number),
323: qp_number.number_to_canonical(pricing_attr_value_to_number)),

Line 322: qp_number.number_to_canonical(pricing_attr_value_from_number),

318: LEAST(qp_number.number_to_canonical(pricing_attr_value_from_number),
319: qp_number.number_to_canonical(pricing_attr_value_to_number)),
320: pattern_value_to_negative =
321: GREATEST(
322: qp_number.number_to_canonical(pricing_attr_value_from_number),
323: qp_number.number_to_canonical(pricing_attr_value_to_number)),
324: pattern_value_from_positive = null,
325: pattern_value_to_positive = null
326: WHERE comparison_operator_code = 'BETWEEN'

Line 323: qp_number.number_to_canonical(pricing_attr_value_to_number)),

319: qp_number.number_to_canonical(pricing_attr_value_to_number)),
320: pattern_value_to_negative =
321: GREATEST(
322: qp_number.number_to_canonical(pricing_attr_value_from_number),
323: qp_number.number_to_canonical(pricing_attr_value_to_number)),
324: pattern_value_from_positive = null,
325: pattern_value_to_positive = null
326: WHERE comparison_operator_code = 'BETWEEN'
327: AND pricing_attribute_datatype = 'N'

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

333: --pricing_attr_value_from and pricing_attr_value_to are positive.
334: FORALL k IN l_list_header_id_tbl.FIRST..l_list_header_id_tbl.LAST
335: UPDATE qp_pricing_attributes
336: SET pattern_value_from_positive =
337: LEAST(qp_number.number_to_canonical(pricing_attr_value_from_number),
338: qp_number.number_to_canonical(pricing_attr_value_to_number)),
339: pattern_value_to_positive =
340: GREATEST(
341: qp_number.number_to_canonical(pricing_attr_value_from_number),

Line 338: qp_number.number_to_canonical(pricing_attr_value_to_number)),

334: FORALL k IN l_list_header_id_tbl.FIRST..l_list_header_id_tbl.LAST
335: UPDATE qp_pricing_attributes
336: SET pattern_value_from_positive =
337: LEAST(qp_number.number_to_canonical(pricing_attr_value_from_number),
338: qp_number.number_to_canonical(pricing_attr_value_to_number)),
339: pattern_value_to_positive =
340: GREATEST(
341: qp_number.number_to_canonical(pricing_attr_value_from_number),
342: qp_number.number_to_canonical(pricing_attr_value_to_number)),

Line 341: qp_number.number_to_canonical(pricing_attr_value_from_number),

337: LEAST(qp_number.number_to_canonical(pricing_attr_value_from_number),
338: qp_number.number_to_canonical(pricing_attr_value_to_number)),
339: pattern_value_to_positive =
340: GREATEST(
341: qp_number.number_to_canonical(pricing_attr_value_from_number),
342: qp_number.number_to_canonical(pricing_attr_value_to_number)),
343: pattern_value_from_negative = null,
344: pattern_value_to_negative = null
345: WHERE comparison_operator_code = 'BETWEEN'

Line 342: qp_number.number_to_canonical(pricing_attr_value_to_number)),

338: qp_number.number_to_canonical(pricing_attr_value_to_number)),
339: pattern_value_to_positive =
340: GREATEST(
341: qp_number.number_to_canonical(pricing_attr_value_from_number),
342: qp_number.number_to_canonical(pricing_attr_value_to_number)),
343: pattern_value_from_negative = null,
344: pattern_value_to_negative = null
345: WHERE comparison_operator_code = 'BETWEEN'
346: AND pricing_attribute_datatype = 'N'

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

352: --operator is between and pricing attribute datatype is 'N'.
353: FORALL k IN l_list_header_id_tbl.FIRST..l_list_header_id_tbl.LAST
354: UPDATE qp_pricing_attributes
355: SET pattern_value_from_negative =
356: '-' || LTRIM(qp_number.number_to_canonical(0)),
357: pattern_value_to_negative =
358: qp_number.number_to_canonical(pricing_attr_value_from_number),
359: pattern_value_from_positive = null,
360: pattern_value_to_positive = null

Line 358: qp_number.number_to_canonical(pricing_attr_value_from_number),

354: UPDATE qp_pricing_attributes
355: SET pattern_value_from_negative =
356: '-' || LTRIM(qp_number.number_to_canonical(0)),
357: pattern_value_to_negative =
358: qp_number.number_to_canonical(pricing_attr_value_from_number),
359: pattern_value_from_positive = null,
360: pattern_value_to_positive = null
361: WHERE comparison_operator_code = 'BETWEEN'
362: AND pricing_attribute_datatype = 'N'

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

368: --positive, operator is between and pricing attribute datatype is 'N'.
369: FORALL k IN l_list_header_id_tbl.FIRST..l_list_header_id_tbl.LAST
370: UPDATE qp_pricing_attributes
371: SET pattern_value_from_negative =
372: '-' || LTRIM(qp_number.number_to_canonical(0)),
373: pattern_value_to_negative =
374: qp_number.number_to_canonical(pricing_attr_value_from_number),
375: pattern_value_from_positive = qp_number.number_to_canonical(0),
376: pattern_value_to_positive =

Line 374: qp_number.number_to_canonical(pricing_attr_value_from_number),

370: UPDATE qp_pricing_attributes
371: SET pattern_value_from_negative =
372: '-' || LTRIM(qp_number.number_to_canonical(0)),
373: pattern_value_to_negative =
374: qp_number.number_to_canonical(pricing_attr_value_from_number),
375: pattern_value_from_positive = qp_number.number_to_canonical(0),
376: pattern_value_to_positive =
377: qp_number.number_to_canonical(pricing_attr_value_to_number)
378: WHERE comparison_operator_code = 'BETWEEN'

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

371: SET pattern_value_from_negative =
372: '-' || LTRIM(qp_number.number_to_canonical(0)),
373: pattern_value_to_negative =
374: qp_number.number_to_canonical(pricing_attr_value_from_number),
375: pattern_value_from_positive = qp_number.number_to_canonical(0),
376: pattern_value_to_positive =
377: qp_number.number_to_canonical(pricing_attr_value_to_number)
378: WHERE comparison_operator_code = 'BETWEEN'
379: AND pricing_attribute_datatype = 'N'

Line 377: qp_number.number_to_canonical(pricing_attr_value_to_number)

373: pattern_value_to_negative =
374: qp_number.number_to_canonical(pricing_attr_value_from_number),
375: pattern_value_from_positive = qp_number.number_to_canonical(0),
376: pattern_value_to_positive =
377: qp_number.number_to_canonical(pricing_attr_value_to_number)
378: WHERE comparison_operator_code = 'BETWEEN'
379: AND pricing_attribute_datatype = 'N'
380: AND list_header_id = l_list_header_id_tbl(k)
381: AND pricing_attr_value_from_number < 0

Line 389: qp_number.number_to_canonical(pricing_attr_value_from_number),

385: --pricing_attr_value_from is positive.
386: FORALL k IN l_list_header_id_tbl.FIRST..l_list_header_id_tbl.LAST
387: UPDATE qp_pricing_attributes
388: SET pattern_value_from_positive =
389: qp_number.number_to_canonical(pricing_attr_value_from_number),
390: pattern_value_to_positive =
391: qp_number.number_to_canonical(pricing_attr_value_from_number),
392: pattern_value_from_negative = null,
393: pattern_value_to_negative = null

Line 391: qp_number.number_to_canonical(pricing_attr_value_from_number),

387: UPDATE qp_pricing_attributes
388: SET pattern_value_from_positive =
389: qp_number.number_to_canonical(pricing_attr_value_from_number),
390: pattern_value_to_positive =
391: qp_number.number_to_canonical(pricing_attr_value_from_number),
392: pattern_value_from_negative = null,
393: pattern_value_to_negative = null
394: WHERE comparison_operator_code = '='
395: AND pricing_attribute_datatype = 'N'

Line 404: qp_number.number_to_canonical(pricing_attr_value_from_number),

400: --pricing_attr_value_from is negative.
401: FORALL k IN l_list_header_id_tbl.FIRST..l_list_header_id_tbl.LAST
402: UPDATE qp_pricing_attributes
403: SET pattern_value_from_negative =
404: qp_number.number_to_canonical(pricing_attr_value_from_number),
405: pattern_value_to_negative =
406: qp_number.number_to_canonical(pricing_attr_value_from_number),
407: pattern_value_from_positive = null,
408: pattern_value_to_positive = null

Line 406: qp_number.number_to_canonical(pricing_attr_value_from_number),

402: UPDATE qp_pricing_attributes
403: SET pattern_value_from_negative =
404: qp_number.number_to_canonical(pricing_attr_value_from_number),
405: pattern_value_to_negative =
406: qp_number.number_to_canonical(pricing_attr_value_from_number),
407: pattern_value_from_positive = null,
408: pattern_value_to_positive = null
409: WHERE comparison_operator_code = '='
410: AND pricing_attribute_datatype = 'N'

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

443:
444: l_list_header_id_tbl.DELETE; --Clear the plsql table.
445:
446: --Set the format mask for the canonical form of numbers
447: qp_number.canonical_mask := 'FM999999999999999999999.9999999999999999999999999999999999999999';
448:
449: --dbms_output.put_line('Updated Search_Ind columns');
450: --dbms_output.put_line('Updated Pattern_value_from/Pattern_value_to columns');
451: