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

Line 1020: and qp_number.canonical_to_number(decode(qpq.qualifier_datatype,G_NUMERIC,qplatq.value_from,null))

1016: and qpq.comparison_operator_code = G_OPERATOR_BETWEEN
1017: and qpq.qualifier_datatype = G_NUMERIC
1018: and qpq.search_ind = 2
1019: and qpq.qualifier_group_cnt > 1
1020: and qp_number.canonical_to_number(decode(qpq.qualifier_datatype,G_NUMERIC,qplatq.value_from,null))
1021: between qpq.qual_attr_value_from_number and qpq.qual_attr_value_to_number
1022: and ((qph.currency_code IS NOT NULL AND qph.currency_code = G_CURRENCY_CODE)
1023: OR
1024: qph.currency_code IS NULL) -- optional currency

Line 1121: and qp_number.canonical_to_number(decode(qpq.qualifier_datatype,G_NUMERIC,qplatq.value_from,null))

1117: and qpq.qualifier_attribute = qplatq.attribute
1118: and qpq.comparison_operator_code = G_OPERATOR_BETWEEN
1119: and qpq.qualifier_datatype = G_NUMERIC
1120: and qpq.search_ind = 2
1121: and qp_number.canonical_to_number(decode(qpq.qualifier_datatype,G_NUMERIC,qplatq.value_from,null))
1122: between qpq.qual_attr_value_from_number and qpq.qual_attr_value_to_number
1123: and ((qph.currency_code IS NOT NULL AND qph.currency_code = G_CURRENCY_CODE)
1124: OR
1125: qph.currency_code IS NULL) -- optional currency

Line 1981: and qp_number.canonical_to_number(decode(qpq.qualifier_datatype,G_NUMERIC,qplatq.value_from,null))

1977: AND c.excluder_flag = G_NO
1978: --3683298 AND qpprod.line_index = qplatq.line_index
1979: AND rownum = 1)
1980: ) --3520634 end
1981: and qp_number.canonical_to_number(decode(qpq.qualifier_datatype,G_NUMERIC,qplatq.value_from,null))
1982: between qpq.qual_attr_value_from_number and qpq.qual_attr_value_to_number
1983: and ((qph.currency_code IS NOT NULL AND qph.currency_code = G_CURRENCY_CODE)
1984: OR
1985: qph.currency_code IS NULL) -- optional currency

Line 2655: and qp_number.canonical_to_number(decode(qpq.qualifier_datatype,G_NUMERIC,qplatq.value_from,null))

2651: and qpq.comparison_operator_code = G_OPERATOR_BETWEEN
2652: and qpq.qualifier_datatype = G_NUMERIC
2653: and qpq.search_ind = 1
2654: and qpq.list_line_id = -1 -- Header level quals
2655: and qp_number.canonical_to_number(decode(qpq.qualifier_datatype,G_NUMERIC,qplatq.value_from,null))
2656: between qpq.qual_attr_value_from_number and qpq.qual_attr_value_to_number
2657: and ((qph.currency_code IS NOT NULL AND qph.currency_code = G_CURRENCY_CODE)
2658: OR
2659: qph.currency_code IS NULL) -- optional currency

Line 7658: SET VALUE_FROM = qp_number.number_to_canonical(nvl(I.LINE_QUANTITY,0))

7654: -- ITEM QUANTITY(Price List Sequence)
7655: /* IF (p_pricing_phase_seq = G_PRICE_LIST_SEQUENCE AND i.LINE_TYPE_CODE = G_LINE_LEVEL) THEN
7656:
7657: UPDATE qp_npreq_line_attrs_tmp
7658: SET VALUE_FROM = qp_number.number_to_canonical(nvl(I.LINE_QUANTITY,0))
7659: WHERE LINE_INDEX = I.LINE_INDEX
7660: AND CONTEXT = G_PRIC_VOLUME_CONTEXT
7661: AND ATTRIBUTE = G_QUANTITY_ATTRIBUTE
7662: AND ATTRIBUTE_TYPE = G_PRICING_TYPE

Line 7675: p_VALUE_FROM =>qp_number.number_to_canonical(NVL(I.LINE_QUANTITY,0)),

7671: p_ATTRIBUTE_LEVEL =>G_LINE_LEVEL,
7672: p_ATTRIBUTE_TYPE =>G_PRICING_TYPE,
7673: p_CONTEXT =>G_PRIC_VOLUME_CONTEXT,
7674: p_ATTRIBUTE =>G_QUANTITY_ATTRIBUTE,
7675: p_VALUE_FROM =>qp_number.number_to_canonical(NVL(I.LINE_QUANTITY,0)),
7676: p_VALIDATED_FLAG =>G_NO,
7677: p_APPLIED_FLAG =>G_LIST_NOT_APPLIED,
7678: p_PRICING_STATUS_CODE =>G_STATUS_UNCHANGED,
7679: P_PRICING_ATTR_FLAG =>G_PRICING_YES,

Line 7756: l_ia_value_from_tbl(l_ia_bulk_count) := qp_number.number_to_canonical(nvl(nvl(l_l_priced_quantity_tbl(I),l_l_line_quantity_tbl(I)),0));

7752: INDX,QP_PREQ_GRP.source_vol_contexts_attributes.source_vol_contexts_attributes_upd3,qp_npreq_line_attrs_tmp_N2,ATTRIBUTE,4
7753: INDX,QP_PREQ_GRP.source_vol_contexts_attributes.source_vol_contexts_attributes_upd3,qp_npreq_line_attrs_tmp_N2,LINE_INDEX,5
7754: */
7755: -- julin [3805113]: bulk update
7756: l_ia_value_from_tbl(l_ia_bulk_count) := qp_number.number_to_canonical(nvl(nvl(l_l_priced_quantity_tbl(I),l_l_line_quantity_tbl(I)),0));
7757: l_ia_line_index_tbl(l_ia_bulk_count) := l_l_line_index_tbl(I);
7758: l_ia_attribute_tbl(l_ia_bulk_count) := G_QUANTITY_ATTRIBUTE;
7759: l_ia_bulk_count := l_ia_bulk_count + 1;
7760:

Line 7794: qp_number.number_to_canonical(nvl(nvl(l_l_priced_quantity_tbl(j),l_l_line_quantity_tbl(j)),0)),

7790: G_LINE_LEVEL,
7791: G_PRICING_TYPE,
7792: G_PRIC_VOLUME_CONTEXT,
7793: G_QUANTITY_ATTRIBUTE,
7794: qp_number.number_to_canonical(nvl(nvl(l_l_priced_quantity_tbl(j),l_l_line_quantity_tbl(j)),0)),
7795: G_NO,
7796: G_LIST_NOT_APPLIED,
7797: G_STATUS_UNCHANGED,
7798: 'Unchanged',

Line 7817: p_VALUE_FROM =>qp_number.number_to_canonical(nvl(NVL(I.PRICED_QUANTITY,I.LINE_QUANTITY),0)),

7813: p_ATTRIBUTE_LEVEL =>G_LINE_LEVEL,
7814: p_ATTRIBUTE_TYPE =>G_PRICING_TYPE,
7815: p_CONTEXT =>G_PRIC_VOLUME_CONTEXT,
7816: p_ATTRIBUTE =>G_QUANTITY_ATTRIBUTE,
7817: p_VALUE_FROM =>qp_number.number_to_canonical(nvl(NVL(I.PRICED_QUANTITY,I.LINE_QUANTITY),0)),
7818: p_VALIDATED_FLAG =>G_NO,
7819: p_APPLIED_FLAG =>G_LIST_NOT_APPLIED,
7820: p_PRICING_STATUS_CODE =>G_STATUS_UNCHANGED,
7821: P_PRICING_ATTR_FLAG =>G_PRICING_YES,

Line 7834: l_ia_value_from_tbl(l_ia_bulk_count) := qp_number.number_to_canonical(nvl(nvl(l_l_priced_quantity_tbl(I),l_l_line_quantity_tbl(I)) * l_l_unit_price_tbl(I),0));

7830: INDX,QP_PREQ_GRP.source_vol_contexts_attributes.source_vol_contexts_attributes_upd5,qp_npreq_line_attrs_tmp_N2,ATTRIBUTE,4
7831: INDX,QP_PREQ_GRP.source_vol_contexts_attributes.source_vol_contexts_attributes_upd5,qp_npreq_line_attrs_tmp_N2,LINE_INDEX,5
7832: */
7833: -- julin [3805113]: bulk update
7834: l_ia_value_from_tbl(l_ia_bulk_count) := qp_number.number_to_canonical(nvl(nvl(l_l_priced_quantity_tbl(I),l_l_line_quantity_tbl(I)) * l_l_unit_price_tbl(I),0));
7835: l_ia_line_index_tbl(l_ia_bulk_count) := l_l_line_index_tbl(I);
7836: l_ia_attribute_tbl(l_ia_bulk_count) := G_LINE_AMT_ATTRIBUTE;
7837: l_ia_bulk_count := l_ia_bulk_count + 1;
7838:

Line 7849: p_VALUE_FROM =>qp_number.number_to_canonical(nvl(nvl(I.PRICED_QUANTITY,I.LINE_QUANTITY) * I.UNIT_PRICE ,0)),

7845: p_ATTRIBUTE_LEVEL =>G_LINE_LEVEL,
7846: p_ATTRIBUTE_TYPE =>G_PRICING_TYPE,
7847: p_CONTEXT =>G_PRIC_VOLUME_CONTEXT,
7848: p_ATTRIBUTE =>G_LINE_AMT_ATTRIBUTE,
7849: p_VALUE_FROM =>qp_number.number_to_canonical(nvl(nvl(I.PRICED_QUANTITY,I.LINE_QUANTITY) * I.UNIT_PRICE ,0)),
7850: p_VALIDATED_FLAG =>G_NO,
7851: p_APPLIED_FLAG =>G_LIST_NOT_APPLIED,
7852: p_PRICING_STATUS_CODE =>G_STATUS_UNCHANGED,
7853: P_PRICING_ATTR_FLAG =>G_PRICING_YES,

Line 7873: SET VALUE_FROM = qp_number.number_to_canonical(round(qp_number.canonical_to_number(nvl(VALUE_FROM,0)) * v_uom_rate, G_INV_DECIMAL_PRECISION))

7869: -- julin [3805113]: bulk update for CROSS ORDER VOLUME
7870: IF (l_co_line_index_tbl.count > 0) THEN
7871: FORALL I IN l_co_line_index_tbl.first..l_co_line_index_tbl.last
7872: UPDATE /*+ index(qp_npreq_line_attrs_tmp qp_preq_line_attrs_tmp_n2) */ qp_npreq_line_attrs_tmp --upd4
7873: SET VALUE_FROM = qp_number.number_to_canonical(round(qp_number.canonical_to_number(nvl(VALUE_FROM,0)) * v_uom_rate, G_INV_DECIMAL_PRECISION))
7874: WHERE LINE_INDEX = l_co_line_index_tbl(I)
7875: AND CONTEXT = G_PRIC_VOLUME_CONTEXT
7876: AND ATTRIBUTE IN ('PRICING_ATTRIBUTE3','PRICING_ATTRIBUTE1','PRICING_ATTRIBUTE11')
7877: AND ATTRIBUTE_TYPE = G_PRICING_TYPE

Line 7916: --SET VALUE_FROM = qp_number.number_to_canonical(v_order_amt)

7912: INDX,QP_PREQ_GRP.source_vol_contexts_attributes.source_vol_contexts_attributes_upd6,qp_npreq_line_attrs_tmp_N2,ATTRIBUTE,4
7913: */
7914: -- Bug 3143535 - ORDER AMOUNT CALCULATION ISSUE
7915: UPDATE qp_npreq_line_attrs_tmp --upd6
7916: --SET VALUE_FROM = qp_number.number_to_canonical(v_order_amt)
7917: SET VALUE_FROM = qp_number.number_to_canonical(qp_number.canonical_to_number(value_from)
7918: - G_BEFORE_PRICING_ORD_AMT
7919: + v_order_amt)
7920: WHERE

Line 7917: SET VALUE_FROM = qp_number.number_to_canonical(qp_number.canonical_to_number(value_from)

7913: */
7914: -- Bug 3143535 - ORDER AMOUNT CALCULATION ISSUE
7915: UPDATE qp_npreq_line_attrs_tmp --upd6
7916: --SET VALUE_FROM = qp_number.number_to_canonical(v_order_amt)
7917: SET VALUE_FROM = qp_number.number_to_canonical(qp_number.canonical_to_number(value_from)
7918: - G_BEFORE_PRICING_ORD_AMT
7919: + v_order_amt)
7920: WHERE
7921: CONTEXT = G_PRIC_VOLUME_CONTEXT

Line 7940: qp_number.number_to_canonical(v_order_amt),

7936: LINE_TYPE_CODE,
7937: G_QUALIFIER_TYPE,
7938: G_PRIC_VOLUME_CONTEXT,
7939: G_ORDER_AMOUNT_ATTRIBUTE,
7940: qp_number.number_to_canonical(v_order_amt),
7941: G_NO,
7942: G_NO,
7943: G_STATUS_UNCHANGED,
7944: G_NO

Line 8803: G_VALUE_FROM_tbl(K) := qp_number.number_to_canonical(l_line_quantity);

8799: G_ATTRIBUTE_LEVEL_tbl(K) := G_LINE_LEVEL;
8800: G_ATTRIBUTE_TYPE_tbl(K) := G_PRICING_TYPE;
8801: G_CONTEXT_tbl(K) := G_PRIC_VOLUME_CONTEXT;
8802: G_ATTRIBUTE_tbl(K) := G_QUANTITY_ATTRIBUTE;
8803: G_VALUE_FROM_tbl(K) := qp_number.number_to_canonical(l_line_quantity);
8804: G_VALUE_TO_tbl(K) := NULL;
8805: G_COMPARISON_OPERATOR_TYPE_tbl(K):=NULL;
8806: G_VALIDATED_FLAG_tbl(K) := G_NO;
8807: G_APPLIED_FLAG_tbl(K) := G_LIST_NOT_APPLIED;

Line 8863: G_VALUE_FROM_tbl(K) := qp_number.number_to_canonical(l_line_amount);

8859: G_ATTRIBUTE_LEVEL_tbl(K) := G_LINE_LEVEL;
8860: G_ATTRIBUTE_TYPE_tbl(K) := G_PRICING_TYPE;
8861: G_CONTEXT_tbl(K) := G_PRIC_VOLUME_CONTEXT;
8862: G_ATTRIBUTE_tbl(K) := G_LINE_AMT_ATTRIBUTE;
8863: G_VALUE_FROM_tbl(K) := qp_number.number_to_canonical(l_line_amount);
8864: G_VALUE_TO_tbl(K) := NULL;
8865: G_COMPARISON_OPERATOR_TYPE_tbl(K):=NULL;
8866: G_VALIDATED_FLAG_tbl(K) := G_NO;
8867: G_APPLIED_FLAG_tbl(K) := G_LIST_NOT_APPLIED;

Line 10566: sum(qp_number.canonical_to_number(c.value_from)) group_value

10562:
10563: CURSOR line_grp_cur IS
10564: select /*+ ORDERED USE_NL(c a ) index(a qp_pricing_attributes_n2) line_grp_cur */
10565: b.created_from_list_line_id list_line_id , c.context , c.attribute ,
10566: sum(qp_number.canonical_to_number(c.value_from)) group_value
10567: from
10568: qp_npreq_ldets_tmp b , qp_npreq_line_attrs_tmp c , qp_pricing_attributes a
10569: where
10570: b.modifier_level_code = G_LINE_GROUP

Line 10583: sum(qp_number.canonical_to_number(c.value_from)) group_value

10579: and a.pricing_attribute = c.attribute
10580: group by b.created_from_list_line_id , c.context , c.attribute;
10581:
10582: /*select c.list_line_id list_line_id , c.context , c.attribute ,
10583: sum(qp_number.canonical_to_number(c.value_from)) group_value
10584: from
10585: qp_npreq_line_attrs_tmp c
10586: where
10587: c.modifier_level_code = G_LINE_GROUP

Line 11326: l_value_from_num := qp_number.canonical_to_number(I.value_from);

11322: l_value_from_num := I.group_amount;
11323: END IF;
11324: l_selected_volume_attr := G_AMOUNT; -- 2388011_new
11325: ELSE -- For Order Amount,Period1 Amount kind of attributes
11326: l_value_from_num := qp_number.canonical_to_number(I.value_from);
11327: END IF;
11328: ELSE -- Make it a success,because line group between is done again,so do not delete
11329: l_value_from_num := NULL;
11330: END IF;

Line 11339: l_value_from_num := qp_number.canonical_to_number(I.value_from);

11335: engine_debug('Line detail index: '||I.line_detail_index);
11336: END IF;
11337: ELSE -- is not a line group
11338: l_is_line_group_flag := 'F';
11339: l_value_from_num := qp_number.canonical_to_number(I.value_from);
11340: -- begin 2388011_new
11341: IF (I.attribute = G_QUANTITY_ATTRIBUTE) THEN
11342: l_selected_volume_attr := G_QUANTITY;
11343: ELSIF (I.attribute = G_LINE_AMT_ATTRIBUTE) THEN

Line 11352: l_value_from_num := qp_number.canonical_to_number(I.value_from);

11348: -- end 2388011_new
11349: END IF;-- END is a line group
11350: ELSE --else Not a Volume Context
11351: l_is_line_group_flag := 'F';
11352: l_value_from_num := qp_number.canonical_to_number(I.value_from);
11353: END IF;
11354:
11355:
11356: IF (I.setup_value_from IS NULL) THEN

Line 11359: l_setup_value_from_num := qp_number.canonical_to_number(I.setup_value_from);

11355:
11356: IF (I.setup_value_from IS NULL) THEN
11357: l_setup_value_from_num := l_value_from_num;
11358: ELSE
11359: l_setup_value_from_num := qp_number.canonical_to_number(I.setup_value_from);
11360: END IF;
11361:
11362: IF (I.setup_value_to IS NULL) THEN
11363: l_setup_value_to_num := l_value_from_num;

Line 11365: l_setup_value_to_num := qp_number.canonical_to_number(I.setup_value_to);

11361:
11362: IF (I.setup_value_to IS NULL) THEN
11363: l_setup_value_to_num := l_value_from_num;
11364: ELSE
11365: l_setup_value_to_num := qp_number.canonical_to_number(I.setup_value_to);
11366: END IF;
11367:
11368: IF G_DEBUG_ENGINE = FND_API.G_TRUE THEN
11369: engine_debug('1VALUE: '||l_value_from_num);

Line 11501: l_value_from_num := qp_number.canonical_to_number(I.value_from);

11497: IF (p_pricing_phase_id <> G_PRICE_LIST_PHASE_ID) THEN
11498: l_value_from_num := I.group_amount;
11499: END IF;
11500: ELSE -- For Order Amount,Period1 Amount kind of attributes
11501: l_value_from_num := qp_number.canonical_to_number(I.value_from);
11502: END IF;
11503: ELSE -- Make it a success,because line group between is done again,so do not delete
11504: l_value_from_num := NULL;
11505: END IF;

Line 11514: l_value_from_num := qp_number.canonical_to_number(I.value_from);

11510: engine_debug('Line detail index: '||I.line_detail_index);
11511: END IF;
11512: ELSE -- is not a line group
11513: l_is_line_group_flag := 'F';
11514: l_value_from_num := qp_number.canonical_to_number(I.value_from);
11515: END IF;
11516: ELSE --else Not a Volume Context
11517: l_is_line_group_flag := 'F';
11518: l_value_from_num := qp_number.canonical_to_number(I.value_from);

Line 11518: l_value_from_num := qp_number.canonical_to_number(I.value_from);

11514: l_value_from_num := qp_number.canonical_to_number(I.value_from);
11515: END IF;
11516: ELSE --else Not a Volume Context
11517: l_is_line_group_flag := 'F';
11518: l_value_from_num := qp_number.canonical_to_number(I.value_from);
11519: END IF;
11520:
11521:
11522: IF (I.setup_value_from IS NULL) THEN

Line 11525: l_setup_value_from_num := qp_number.canonical_to_number(I.setup_value_from);

11521:
11522: IF (I.setup_value_from IS NULL) THEN
11523: l_setup_value_from_num := l_value_from_num;
11524: ELSE
11525: l_setup_value_from_num := qp_number.canonical_to_number(I.setup_value_from);
11526: END IF;
11527:
11528: IF (I.setup_value_to IS NULL) THEN
11529: l_setup_value_to_num := l_value_from_num;

Line 11531: l_setup_value_to_num := qp_number.canonical_to_number(I.setup_value_to);

11527:
11528: IF (I.setup_value_to IS NULL) THEN
11529: l_setup_value_to_num := l_value_from_num;
11530: ELSE
11531: l_setup_value_to_num := qp_number.canonical_to_number(I.setup_value_to);
11532: END IF;
11533:
11534: IF G_DEBUG_ENGINE = FND_API.G_TRUE THEN
11535: engine_debug('1VALUE: '||l_value_from_num);

Line 11786: -- and qp_number.canonical_to_number(qplat_pricing.value_from) <> 0 -- 5158413

11782: AND qplat_pricing.attribute_type = G_PRICING_TYPE
11783: AND qplat_pricing.line_index = qplines.line_index
11784: AND qplat_pricing.pricing_status_code = G_STATUS_UNCHANGED
11785: AND qplat_pricing.line_index = p_line_index
11786: -- and qp_number.canonical_to_number(qplat_pricing.value_from) <> 0 -- 5158413
11787: -- commented above for bug#6896139 as fix for bug#5158413 did not consider for G_LINE_GROUP,lines with line qty as 0
11788: --(i.e qplat_pricing.value_from=0) even when the qualifier group count for G_LINE_GROUP was greater than zero
11789: and qpll.list_header_id = qph.list_header_id /* Vivek */
11790: and QPH.CURRENCY_HEADER_ID = QCDT.CURRENCY_HEADER_ID /* Vivek */

Line 11836: and ( (qpll.price_break_type_code = G_POINT_BREAK and qp_number.canonical_to_number(qplat_pricing.value_from)

11832: ) /* Vivek */
11833: ) /* Vivek */
11834: and (( (p_reduced_pbh_processing = G_YES) --[julin/3783009/4712794]
11835: and (nvl(qplines.usage_pricing_type,G_REGULAR_USAGE_TYPE) <> G_AUTHORING_TYPE)
11836: and ( (qpll.price_break_type_code = G_POINT_BREAK and qp_number.canonical_to_number(qplat_pricing.value_from)
11837: between qp_number.canonical_to_number(qppa.pricing_attr_value_from)
11838: and qp_number.canonical_to_number(qppa.pricing_attr_value_to)
11839: ) OR
11840: (qpll.price_break_type_code = G_RANGE_BREAK and qp_number.canonical_to_number(qppa.pricing_attr_value_from)

Line 11837: between qp_number.canonical_to_number(qppa.pricing_attr_value_from)

11833: ) /* Vivek */
11834: and (( (p_reduced_pbh_processing = G_YES) --[julin/3783009/4712794]
11835: and (nvl(qplines.usage_pricing_type,G_REGULAR_USAGE_TYPE) <> G_AUTHORING_TYPE)
11836: and ( (qpll.price_break_type_code = G_POINT_BREAK and qp_number.canonical_to_number(qplat_pricing.value_from)
11837: between qp_number.canonical_to_number(qppa.pricing_attr_value_from)
11838: and qp_number.canonical_to_number(qppa.pricing_attr_value_to)
11839: ) OR
11840: (qpll.price_break_type_code = G_RANGE_BREAK and qp_number.canonical_to_number(qppa.pricing_attr_value_from)
11841: <= qp_number.canonical_to_number(qplat_pricing.value_from)

Line 11838: and qp_number.canonical_to_number(qppa.pricing_attr_value_to)

11834: and (( (p_reduced_pbh_processing = G_YES) --[julin/3783009/4712794]
11835: and (nvl(qplines.usage_pricing_type,G_REGULAR_USAGE_TYPE) <> G_AUTHORING_TYPE)
11836: and ( (qpll.price_break_type_code = G_POINT_BREAK and qp_number.canonical_to_number(qplat_pricing.value_from)
11837: between qp_number.canonical_to_number(qppa.pricing_attr_value_from)
11838: and qp_number.canonical_to_number(qppa.pricing_attr_value_to)
11839: ) OR
11840: (qpll.price_break_type_code = G_RANGE_BREAK and qp_number.canonical_to_number(qppa.pricing_attr_value_from)
11841: <= qp_number.canonical_to_number(qplat_pricing.value_from)
11842: )

Line 11840: (qpll.price_break_type_code = G_RANGE_BREAK and qp_number.canonical_to_number(qppa.pricing_attr_value_from)

11836: and ( (qpll.price_break_type_code = G_POINT_BREAK and qp_number.canonical_to_number(qplat_pricing.value_from)
11837: between qp_number.canonical_to_number(qppa.pricing_attr_value_from)
11838: and qp_number.canonical_to_number(qppa.pricing_attr_value_to)
11839: ) OR
11840: (qpll.price_break_type_code = G_RANGE_BREAK and qp_number.canonical_to_number(qppa.pricing_attr_value_from)
11841: <= qp_number.canonical_to_number(qplat_pricing.value_from)
11842: )
11843: )
11844: )

Line 11841: <= qp_number.canonical_to_number(qplat_pricing.value_from)

11837: between qp_number.canonical_to_number(qppa.pricing_attr_value_from)
11838: and qp_number.canonical_to_number(qppa.pricing_attr_value_to)
11839: ) OR
11840: (qpll.price_break_type_code = G_RANGE_BREAK and qp_number.canonical_to_number(qppa.pricing_attr_value_from)
11841: <= qp_number.canonical_to_number(qplat_pricing.value_from)
11842: )
11843: )
11844: )
11845: or

Line 11848: ORDER BY qp_number.canonical_to_number(qppa.pricing_attr_value_from); --bug#1819397

11844: )
11845: or
11846: (p_reduced_pbh_processing = G_NO)
11847: )
11848: ORDER BY qp_number.canonical_to_number(qppa.pricing_attr_value_from); --bug#1819397
11849:
11850: cursor l_price_break_detail_cur(p_reduced_pbh_processing VARCHAR2) is
11851: SELECT /*+ ordered use_nl(qplines, qprm, qppa, qpll) */
11852: qpll.pricing_group_sequence,

Line 11917: -- and qp_number.canonical_to_number(qplat_pricing.value_from) <> 0 -- 5158413

11913: AND qplat_pricing.attribute_type = G_PRICING_TYPE
11914: AND qplat_pricing.line_index = qplines.line_index
11915: AND qplat_pricing.pricing_status_code = G_STATUS_UNCHANGED
11916: AND qplat_pricing.line_index = p_line_index
11917: -- and qp_number.canonical_to_number(qplat_pricing.value_from) <> 0 -- 5158413
11918: -- commented above for bug#6896139 as fix for bug#5158413 did not consider for G_LINE_GROUP,lines with line qty as 0
11919: --(i.e qplat_pricing.value_from=0) even when the qualifier group count for G_LINE_GROUP was greater than zero
11920: and (( (p_reduced_pbh_processing = G_YES) --[julin/3783009/4712794]
11921: and (nvl(qplines.usage_pricing_type,G_REGULAR_USAGE_TYPE) <> G_AUTHORING_TYPE)

Line 11922: and ( (qpll.price_break_type_code = G_POINT_BREAK and qp_number.canonical_to_number(qplat_pricing.value_from)

11918: -- commented above for bug#6896139 as fix for bug#5158413 did not consider for G_LINE_GROUP,lines with line qty as 0
11919: --(i.e qplat_pricing.value_from=0) even when the qualifier group count for G_LINE_GROUP was greater than zero
11920: and (( (p_reduced_pbh_processing = G_YES) --[julin/3783009/4712794]
11921: and (nvl(qplines.usage_pricing_type,G_REGULAR_USAGE_TYPE) <> G_AUTHORING_TYPE)
11922: and ( (qpll.price_break_type_code = G_POINT_BREAK and qp_number.canonical_to_number(qplat_pricing.value_from)
11923: between qp_number.canonical_to_number(qppa.pricing_attr_value_from)
11924: and qp_number.canonical_to_number(qppa.pricing_attr_value_to)
11925: ) OR
11926: (qpll.price_break_type_code = G_RANGE_BREAK and qp_number.canonical_to_number(qppa.pricing_attr_value_from)

Line 11923: between qp_number.canonical_to_number(qppa.pricing_attr_value_from)

11919: --(i.e qplat_pricing.value_from=0) even when the qualifier group count for G_LINE_GROUP was greater than zero
11920: and (( (p_reduced_pbh_processing = G_YES) --[julin/3783009/4712794]
11921: and (nvl(qplines.usage_pricing_type,G_REGULAR_USAGE_TYPE) <> G_AUTHORING_TYPE)
11922: and ( (qpll.price_break_type_code = G_POINT_BREAK and qp_number.canonical_to_number(qplat_pricing.value_from)
11923: between qp_number.canonical_to_number(qppa.pricing_attr_value_from)
11924: and qp_number.canonical_to_number(qppa.pricing_attr_value_to)
11925: ) OR
11926: (qpll.price_break_type_code = G_RANGE_BREAK and qp_number.canonical_to_number(qppa.pricing_attr_value_from)
11927: <= qp_number.canonical_to_number(qplat_pricing.value_from)

Line 11924: and qp_number.canonical_to_number(qppa.pricing_attr_value_to)

11920: and (( (p_reduced_pbh_processing = G_YES) --[julin/3783009/4712794]
11921: and (nvl(qplines.usage_pricing_type,G_REGULAR_USAGE_TYPE) <> G_AUTHORING_TYPE)
11922: and ( (qpll.price_break_type_code = G_POINT_BREAK and qp_number.canonical_to_number(qplat_pricing.value_from)
11923: between qp_number.canonical_to_number(qppa.pricing_attr_value_from)
11924: and qp_number.canonical_to_number(qppa.pricing_attr_value_to)
11925: ) OR
11926: (qpll.price_break_type_code = G_RANGE_BREAK and qp_number.canonical_to_number(qppa.pricing_attr_value_from)
11927: <= qp_number.canonical_to_number(qplat_pricing.value_from)
11928: )

Line 11926: (qpll.price_break_type_code = G_RANGE_BREAK and qp_number.canonical_to_number(qppa.pricing_attr_value_from)

11922: and ( (qpll.price_break_type_code = G_POINT_BREAK and qp_number.canonical_to_number(qplat_pricing.value_from)
11923: between qp_number.canonical_to_number(qppa.pricing_attr_value_from)
11924: and qp_number.canonical_to_number(qppa.pricing_attr_value_to)
11925: ) OR
11926: (qpll.price_break_type_code = G_RANGE_BREAK and qp_number.canonical_to_number(qppa.pricing_attr_value_from)
11927: <= qp_number.canonical_to_number(qplat_pricing.value_from)
11928: )
11929: )
11930: )

Line 11927: <= qp_number.canonical_to_number(qplat_pricing.value_from)

11923: between qp_number.canonical_to_number(qppa.pricing_attr_value_from)
11924: and qp_number.canonical_to_number(qppa.pricing_attr_value_to)
11925: ) OR
11926: (qpll.price_break_type_code = G_RANGE_BREAK and qp_number.canonical_to_number(qppa.pricing_attr_value_from)
11927: <= qp_number.canonical_to_number(qplat_pricing.value_from)
11928: )
11929: )
11930: )
11931: or

Line 11934: ORDER BY qp_number.canonical_to_number(qppa.pricing_attr_value_from); --bug#1819397

11930: )
11931: or
11932: (p_reduced_pbh_processing = G_NO)
11933: )
11934: ORDER BY qp_number.canonical_to_number(qppa.pricing_attr_value_from); --bug#1819397
11935:
11936: CURSOR l_pbh_cur IS
11937: SELECT net_amount_flag
11938: FROM qp_list_lines

Line 12217: IF qp_number.canonical_to_number(l_h_value_from_tbl(i)) <> 0 OR (qp_number.canonical_to_number(l_h_value_from_tbl(i)) = 0 AND--bug#6896139.If Condition to consider 0 value only for G_LINE_GROUP

12213: engine_debug('Modifier_level_code: '||l_h_modifier_level_code_tbl(i));
12214: engine_debug('Attribute: '||l_h_ATTRIBUTE_tbl(i));
12215:
12216: END IF;
12217: IF qp_number.canonical_to_number(l_h_value_from_tbl(i)) <> 0 OR (qp_number.canonical_to_number(l_h_value_from_tbl(i)) = 0 AND--bug#6896139.If Condition to consider 0 value only for G_LINE_GROUP
12218: l_h_modifier_level_code_tbl(i) = G_LINE_GROUP) THEN --since 0 value is now being considered in the cursor l_price_break_detail_cur --9475080 added
12219: IF l_h_modifier_level_code_tbl(i) = G_LINE_GROUP THEN
12220: IF l_h_attribute_tbl(i) = G_QUANTITY_ATTRIBUTE THEN
12221: l_quantity := p_group_quantity;

Line 12277: l_quantity := qp_number.canonical_to_number(l_h_value_from_tbl(i));

12273: IF (l_h_line_uom_code_tbl(i) = l_h_order_uom_code_tbl(i) ) THEN -- no uom conversion if pricing_uom_code is same as order_uom_code
12274: IF G_DEBUG_ENGINE = FND_API.G_TRUE THEN
12275: engine_debug ('no uom conversion, pricing_uom_code is same as order_uom_code: '||l_h_line_uom_code_tbl(i));
12276: END IF;
12277: l_quantity := qp_number.canonical_to_number(l_h_value_from_tbl(i));
12278: IF G_DEBUG_ENGINE = FND_API.G_TRUE THEN
12279: engine_debug ('l_quantity: '||l_quantity);
12280: END IF;
12281: ELSE -- uom conversion

Line 12287: l_total_item_quantity := qp_number.canonical_to_number(l_h_value_from_tbl(i));

12283: engine_debug ('uom conversion...');
12284: engine_debug ('order_uom_code: '||l_h_order_uom_code_tbl(i));
12285: engine_debug ('primary_uom_code: '||l_h_product_uom_code_tbl(i));
12286: END IF;
12287: l_total_item_quantity := qp_number.canonical_to_number(l_h_value_from_tbl(i));
12288: IF G_DEBUG_ENGINE = FND_API.G_TRUE THEN
12289: engine_debug ('l_quantity before uom convertion: '||l_total_item_quantity );
12290: END IF;
12291:

Line 12317: l_quantity := qp_number.canonical_to_number(l_h_value_from_tbl(i));

12313: END IF;
12314: l_selected_volume_attr := 'O'; --2388011_latest
12315: -- end, shu fix
12316: ELSE
12317: l_quantity := qp_number.canonical_to_number(l_h_value_from_tbl(i));
12318: l_selected_volume_attr := G_AMOUNT;
12319: END IF;
12320:
12321: -- This LINE_QUANTITY is column is needed for knowing the right value for

Line 12344: l_setup_value_from := qp_number.canonical_to_number(l_h_pricing_attr_val_from_tbl(i));

12340:
12341: END IF;
12342:
12343:
12344: l_setup_value_from := qp_number.canonical_to_number(l_h_pricing_attr_val_from_tbl(i));
12345:
12346: --handle the case when value_to is null
12347: IF (l_h_pricing_attr_val_to_tbl(i) IS NULL) THEN
12348: IF l_quantity >= l_setup_value_from THEN

Line 12354: l_value_to := qp_number.canonical_to_number(l_h_pricing_attr_val_to_tbl(i));

12350: ELSIF l_quantity < l_setup_value_from THEN
12351: l_value_to := l_setup_value_from;
12352: END IF;
12353: ELSE
12354: l_value_to := qp_number.canonical_to_number(l_h_pricing_attr_val_to_tbl(i));
12355: END IF;
12356:
12357: IF G_DEBUG_ENGINE = FND_API.G_TRUE THEN
12358: engine_debug(l_routine||' Line quantity: '||l_quantity);

Line 12761: l_h_pricing_attr_val_from_tbl(i) := qp_number.number_to_canonical(l_setup_value_from);

12757: l_line_detail_tbl(N).base_currency_code := l_h_base_currency_code_tbl(i); /* Vivek /
12758: */
12759: /* Proration START */
12760: if l_proration_processed = 'Y' then
12761: l_h_pricing_attr_val_from_tbl(i) := qp_number.number_to_canonical(l_setup_value_from);
12762: l_h_pricing_attr_val_to_tbl(i) := qp_number.number_to_canonical(l_value_to);
12763: if l_continuous_flag = TRUE then
12764: -- 4061138
12765: l_h_pricing_attr_val_to_tbl(i-1) := l_h_pricing_attr_val_from_tbl(i);

Line 12762: l_h_pricing_attr_val_to_tbl(i) := qp_number.number_to_canonical(l_value_to);

12758: */
12759: /* Proration START */
12760: if l_proration_processed = 'Y' then
12761: l_h_pricing_attr_val_from_tbl(i) := qp_number.number_to_canonical(l_setup_value_from);
12762: l_h_pricing_attr_val_to_tbl(i) := qp_number.number_to_canonical(l_value_to);
12763: if l_continuous_flag = TRUE then
12764: -- 4061138
12765: l_h_pricing_attr_val_to_tbl(i-1) := l_h_pricing_attr_val_from_tbl(i);
12766: -- here, we do the aforementioned BETWEEN check again to catch the

Line 13017: qp_number.canonical_to_number(l_h_pricing_attr_val_from_tbl(J)),

13013: l_h_arithmetic_operator_tbl(J),
13014: l_h_operand_tbl(J),
13015: l_h_pricing_group_sequence_tbl(J),
13016: l_h_price_break_type_code_tbl(J),
13017: qp_number.canonical_to_number(l_h_pricing_attr_val_from_tbl(J)),
13018: qp_number.canonical_to_number(l_h_pricing_attr_val_to_tbl(J)),
13019: l_l_quantity_tbl(J));
13020: END IF;
13021:

Line 13018: qp_number.canonical_to_number(l_h_pricing_attr_val_to_tbl(J)),

13014: l_h_operand_tbl(J),
13015: l_h_pricing_group_sequence_tbl(J),
13016: l_h_price_break_type_code_tbl(J),
13017: qp_number.canonical_to_number(l_h_pricing_attr_val_from_tbl(J)),
13018: qp_number.canonical_to_number(l_h_pricing_attr_val_to_tbl(J)),
13019: l_l_quantity_tbl(J));
13020: END IF;
13021:
13022: IF (G_DEBUG_ENGINE = FND_API.G_TRUE) THEN

Line 14649: CASE WHEN (a.PRICE_LIST_HEADER_ID < 0) THEN qp_number.canonical_to_number(value_from)

14645: --[julin/5223502] price_list_header_id directly passed in via lines_tmp has precedence over sourced value
14646: UPDATE /*+ dynamic_sampling(1) */ qp_npreq_lines_tmp a
14647: SET (price_list_header_id,validated_flag) =
14648: (SELECT /*+ index(b QP_PREQ_LINE_ATTRS_TMP_N2) */ distinct
14649: CASE WHEN (a.PRICE_LIST_HEADER_ID < 0) THEN qp_number.canonical_to_number(value_from)
14650: ELSE a.PRICE_LIST_HEADER_ID
14651: END price_list_header_id,
14652: validated_flag
14653: FROM qp_npreq_line_attrs_tmp b

Line 31416: and qp_number.canonical_to_number(decode(qpq.qualifier_datatype,G_NUMERIC,qplatq.value_from,null))

31412: and ((qpq.qualifier_datatype IN (G_VARCHAR,G_DATE_X,G_DATE_Y) --[julin/5007789]
31413: and qplatq.value_from between qpq.qualifier_attr_value and qpq.qualifier_attr_value_to)
31414: or
31415: (qpq.qualifier_datatype = G_NUMERIC
31416: and qp_number.canonical_to_number(decode(qpq.qualifier_datatype,G_NUMERIC,qplatq.value_from,null))
31417: between qpq.qual_attr_value_from_number and qpq.qual_attr_value_to_number))
31418: AND qpprod.pricing_phase_id = p_pricing_phase_id
31419: AND qpprod.qualification_ind = QP_PREQ_GRP.G_YES_PROD_HDR_QUAL_IND
31420: AND qpprod.product_attribute_context = qplatpr.context

Line 31900: and qp_number.canonical_to_number(decode(qpq.qualifier_datatype,G_NUMERIC,qplatq.value_from,null))

31896: and ((qpq.qualifier_datatype IN (G_VARCHAR,G_DATE_X,G_DATE_Y) --[julin/5007789]
31897: and qplatq.value_from between qpq.qualifier_attr_value and qpq.qualifier_attr_value_to)
31898: or
31899: (qpq.qualifier_datatype = G_NUMERIC
31900: and qp_number.canonical_to_number(decode(qpq.qualifier_datatype,G_NUMERIC,qplatq.value_from,null))
31901: between qpq.qual_attr_value_from_number and qpq.qual_attr_value_to_number))
31902: AND qpprod.pricing_phase_id = p_pricing_phase_id
31903: AND qpprod.qualification_ind = QP_PREQ_GRP.G_YES_PROD_HDR_QUAL_IND
31904: AND qpprod.product_attribute_context = qplatpr.context

Line 32286: and qp_number.canonical_to_number(decode(qpq.qualifier_datatype,G_NUMERIC,qplatq.value_from,null))

32282: and ((qpq.qualifier_datatype IN (G_VARCHAR,G_DATE_X,G_DATE_Y) --[julin/5007789]
32283: and qplatq.value_from between qpq.qualifier_attr_value and qpq.qualifier_attr_value_to)
32284: or
32285: (qpq.qualifier_datatype = G_NUMERIC
32286: and qp_number.canonical_to_number(decode(qpq.qualifier_datatype,G_NUMERIC,qplatq.value_from,null))
32287: between qpq.qual_attr_value_from_number and qpq.qual_attr_value_to_number))
32288: AND qpprod.pricing_phase_id = p_pricing_phase_id
32289: AND qpprod.qualification_ind = QP_PREQ_GRP.G_YES_PROD_PRIC_HDR_QUAL_IND
32290: AND qpprod.product_attribute_context = qplatpr.context

Line 32825: and qp_number.canonical_to_number(decode(qpq.qualifier_datatype,G_NUMERIC,qplatq.value_from,null))

32821: and ((qpq.qualifier_datatype IN (G_VARCHAR,G_DATE_X,G_DATE_Y) --[julin/5007789]
32822: and qplatq.value_from between qpq.qualifier_attr_value and qpq.qualifier_attr_value_to)
32823: or
32824: (qpq.qualifier_datatype = G_NUMERIC
32825: and qp_number.canonical_to_number(decode(qpq.qualifier_datatype,G_NUMERIC,qplatq.value_from,null))
32826: between qpq.qual_attr_value_from_number and qpq.qual_attr_value_to_number))
32827: AND qpprod.pricing_phase_id = p_pricing_phase_id
32828: AND qpprod.qualification_ind = QP_PREQ_GRP.G_YES_PROD_PRIC_HDR_QUAL_IND
32829: AND qpprod.product_attribute_context = qplatpr.context

Line 35549: SELECT qp_number.canonical_to_number(VALUE_FROM)

35545: FROM qp_list_headers_v a
35546: WHERE a.list_header_id = p_list_header_id;
35547:
35548: CURSOR get_request_inv_item_id_cur(p_line_index PLS_INTEGER) IS
35549: SELECT qp_number.canonical_to_number(VALUE_FROM)
35550: FROM qp_npreq_line_attrs_tmp
35551: WHERE CONTEXT = G_PRIC_ITEM_CONTEXT
35552: AND ATTRIBUTE = G_PRIC_ATTRIBUTE1
35553: AND ATTRIBUTE_TYPE = G_PRODUCT_TYPE

Line 35900: p_cal_req_rltd_tbl(N).value_from := qp_number.canonical_to_number(G_CHILD_VALUE_FROM_TBL(k.line_detail_index));

35896: END IF;
35897: ELSIF (K.LINE_DETAIL_TYPE_CODE = G_CHILD_DETAIL_TYPE) THEN
35898: --FOR P IN l_line_attrs_cur(K.LINE_DETAIL_INDEX) LOOP
35899:
35900: p_cal_req_rltd_tbl(N).value_from := qp_number.canonical_to_number(G_CHILD_VALUE_FROM_TBL(k.line_detail_index));
35901: p_cal_req_rltd_tbl(N).value_to := qp_number.canonical_to_number(G_CHILD_VALUE_TO_TBL(k.line_detail_index));
35902: p_cal_req_rltd_tbl(N).operand_calculation_code := K.operand_calculation_code;
35903: p_cal_req_rltd_tbl(N).operand_value := K.operand_value;
35904: p_cal_req_rltd_tbl(N).price_break_type_code := K.price_break_type_code;

Line 35901: p_cal_req_rltd_tbl(N).value_to := qp_number.canonical_to_number(G_CHILD_VALUE_TO_TBL(k.line_detail_index));

35897: ELSIF (K.LINE_DETAIL_TYPE_CODE = G_CHILD_DETAIL_TYPE) THEN
35898: --FOR P IN l_line_attrs_cur(K.LINE_DETAIL_INDEX) LOOP
35899:
35900: p_cal_req_rltd_tbl(N).value_from := qp_number.canonical_to_number(G_CHILD_VALUE_FROM_TBL(k.line_detail_index));
35901: p_cal_req_rltd_tbl(N).value_to := qp_number.canonical_to_number(G_CHILD_VALUE_TO_TBL(k.line_detail_index));
35902: p_cal_req_rltd_tbl(N).operand_calculation_code := K.operand_calculation_code;
35903: p_cal_req_rltd_tbl(N).operand_value := K.operand_value;
35904: p_cal_req_rltd_tbl(N).price_break_type_code := K.price_break_type_code;
35905: p_cal_req_rltd_tbl(N).child_line_detail_index :=K.line_detail_index;

Line 36575: pricing_status_code, qp_number.canonical_to_number(value_from)

36571: E_ATTRIBUTE_NON_NUMERIC EXCEPTION;
36572: CURSOR am_attr_cols_cur
36573: IS
36574: SELECT /*+ dynamic_sampling(1) */ line_index, attribute_type, context, attribute,
36575: pricing_status_code, qp_number.canonical_to_number(value_from)
36576: FROM qp_npreq_line_attrs_tmp lattr
36577: WHERE attribute_type IN ('PRICING', 'PRODUCT')
36578: AND pricing_status_code = G_STATUS_UNCHANGED
36579: AND EXISTS (SELECT format_type

Line 36595: pricing_status_code, qp_number.canonical_to_number(value_from)

36591:
36592: CURSOR am_attr_qual_cols_cur
36593: IS
36594: SELECT line_index, attribute_type, context, attribute,
36595: pricing_status_code, qp_number.canonical_to_number(value_from)
36596: FROM qp_npreq_line_attrs_tmp lattr
36597: WHERE attribute_type IN ('PRICING', 'PRODUCT', 'QUALIFIER')
36598: AND pricing_status_code = G_STATUS_UNCHANGED
36599: AND EXISTS (SELECT format_type

Line 36630: pricing_status_code, qp_number.canonical_to_number(value_from)

36626:
36627: CURSOR attr_cols_cur
36628: IS
36629: SELECT line_index, attribute_type, context, attribute,
36630: pricing_status_code, qp_number.canonical_to_number(value_from)
36631: FROM qp_npreq_line_attrs_tmp lattr
36632: WHERE attribute_type IN ('PRICING', 'PRODUCT')
36633: AND pricing_status_code = G_STATUS_UNCHANGED
36634: AND EXISTS (SELECT format_type

Line 36688: qp_number.canonical_mask :=

36684:
36685: EXIT WHEN l_line_index_tbl.COUNT = 0;
36686:
36687: --Change flexible mask to mask below for formula pattern use.
36688: qp_number.canonical_mask :=
36689: '00999999999999999999999.99999999999999999999999999999999999999';
36690: FORALL i IN l_line_index_tbl.FIRST..l_line_index_tbl.LAST
36691: INSERT INTO qp_preq_line_attrs_formula_tmp
36692: ( line_index,

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

36701: l_attribute_type_tbl(i),
36702: l_context_tbl(i),
36703: l_attribute_tbl(i),
36704: l_pricing_status_code_tbl(i),
36705: qp_number.number_to_canonical(l_value_from_tbl(i))
36706: );
36707:
36708: --Change mask back to flexible mask.
36709: qp_number.canonical_mask :=

Line 36709: qp_number.canonical_mask :=

36705: qp_number.number_to_canonical(l_value_from_tbl(i))
36706: );
36707:
36708: --Change mask back to flexible mask.
36709: qp_number.canonical_mask :=
36710: 'FM999999999999999999999.9999999999999999999999999999999999999999';
36711:
36712: END LOOP; --Loop for bulk fetch
36713:

Line 36732: qp_number.canonical_mask :=

36728: l_value_from_tbl LIMIT l_rows;
36729:
36730: EXIT WHEN l_line_index_tbl.COUNT = 0;
36731: --Change flexible mask to mask below for formula pattern use.
36732: qp_number.canonical_mask :=
36733: '00999999999999999999999.99999999999999999999999999999999999999';
36734: FORALL i IN l_line_index_tbl.FIRST..l_line_index_tbl.LAST
36735: INSERT INTO qp_preq_line_attrs_formula_tmp
36736: ( line_index,

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

36745: l_attribute_type_tbl(i),
36746: l_context_tbl(i),
36747: l_attribute_tbl(i),
36748: l_pricing_status_code_tbl(i),
36749: qp_number.number_to_canonical(l_value_from_tbl(i))
36750: );
36751: qp_number.canonical_mask :=
36752: 'FM999999999999999999999.9999999999999999999999999999999999999999';
36753:

Line 36751: qp_number.canonical_mask :=

36747: l_attribute_tbl(i),
36748: l_pricing_status_code_tbl(i),
36749: qp_number.number_to_canonical(l_value_from_tbl(i))
36750: );
36751: qp_number.canonical_mask :=
36752: 'FM999999999999999999999.9999999999999999999999999999999999999999';
36753:
36754: END LOOP; --Loop for bulk fetch
36755: CLOSE am_attr_qual_cols_cur;

Line 36764: l_value_from := qp_number.canonical_to_number(l_rec.value_from);

36760: FOR l_rec IN am_attr_qual_msg_cur
36761: LOOP
36762: l_msg_context := l_rec.context;
36763: l_msg_attribute := l_rec.attribute;
36764: l_value_from := qp_number.canonical_to_number(l_rec.value_from);
36765: END LOOP;
36766: EXCEPTION
36767: WHEN OTHERS THEN
36768: fnd_message.set_token('CONTEXT',l_msg_context);

Line 36778: qp_number.canonical_mask :=

36774:
36775: End If;
36776:
36777: --Change flexible mask to mask below for formula pattern use.
36778: qp_number.canonical_mask :=
36779: '00999999999999999999999.99999999999999999999999999999999999999';
36780:
36781: -- Bug 2772214 l_pass_qualifiers condition in where clause
36782: --Insert request line attrs with datatype 'X', 'Y', 'C' or null

Line 36817: qp_number.canonical_mask :=

36813: AND segments.prc_context_id = pcontexts.prc_context_id
36814: AND vset.format_type = 'N'); --by yangli 03/06/2002 9:30am
36815:
36816: --Change mask back to flexible mask.
36817: qp_number.canonical_mask :=
36818: 'FM999999999999999999999.9999999999999999999999999999999999999999';
36819:
36820: ELSE --If AM not installed
36821:

Line 36839: qp_number.canonical_mask :=

36835:
36836: EXIT WHEN l_line_index_tbl.COUNT = 0;
36837:
36838: --Change flexible mask to mask below for formula pattern use.
36839: qp_number.canonical_mask :=
36840: '00999999999999999999999.99999999999999999999999999999999999999';
36841:
36842: FORALL i IN l_line_index_tbl.FIRST..l_line_index_tbl.LAST
36843: INSERT INTO qp_preq_line_attrs_formula_tmp

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

36853: l_attribute_type_tbl(i),
36854: l_context_tbl(i),
36855: l_attribute_tbl(i),
36856: l_pricing_status_code_tbl(i),
36857: qp_number.number_to_canonical(l_value_from_tbl(i))
36858: );
36859:
36860: --Change mask back to flexible mask.
36861: qp_number.canonical_mask :=

Line 36861: qp_number.canonical_mask :=

36857: qp_number.number_to_canonical(l_value_from_tbl(i))
36858: );
36859:
36860: --Change mask back to flexible mask.
36861: qp_number.canonical_mask :=
36862: 'FM999999999999999999999.9999999999999999999999999999999999999999';
36863:
36864: END LOOP; --Loop for bulk fetch
36865:

Line 36869: qp_number.canonical_mask :=

36865:
36866: CLOSE attr_cols_cur;
36867:
36868: --Change flexible mask to mask below for formula pattern use.
36869: qp_number.canonical_mask :=
36870: '00999999999999999999999.99999999999999999999999999999999999999';
36871:
36872: --Insert request line attrs with datatype 'X', 'Y', 'C' or null
36873: INSERT INTO qp_preq_line_attrs_formula_tmp

Line 36903: qp_number.canonical_mask :=

36899: AND dflex.application_column_name = lattr.attribute
36900: AND vset.format_type = 'N');
36901:
36902: --Change mask back to flexible mask.
36903: qp_number.canonical_mask :=
36904: 'FM999999999999999999999.9999999999999999999999999999999999999999';
36905:
36906: END IF; -- if G_AM_INSTALLED_PROFILE is true
36907:

Line 36933: qp_number.canonical_mask :=

36929: IF (i.group_quantity IS NOT NULL and l_attr_inserted_flag = FALSE) THEN
36930:
36931:
36932: --Change flexible mask to mask below for formula pattern use.
36933: qp_number.canonical_mask :=
36934: '00999999999999999999999.99999999999999999999999999999999999999';
36935: INSERT INTO qp_preq_line_attrs_formula_tmp
36936: ( line_index,
36937: attribute_type,

Line 36949: qp_number.number_to_canonical(i.group_quantity)

36945: G_PRICING_TYPE,
36946: 'VOLUME',
36947: 'PRICING_ATTRIBUTE4',
36948: G_STATUS_UNCHANGED,
36949: qp_number.number_to_canonical(i.group_quantity)
36950: );
36951:
36952: --Change mask back to flexible mask.
36953: qp_number.canonical_mask :=

Line 36953: qp_number.canonical_mask :=

36949: qp_number.number_to_canonical(i.group_quantity)
36950: );
36951:
36952: --Change mask back to flexible mask.
36953: qp_number.canonical_mask :=
36954: 'FM999999999999999999999.9999999999999999999999999999999999999999';
36955:
36956: l_attr_inserted_flag := TRUE;
36957:

Line 36963: qp_number.canonical_mask :=

36959:
36960: IF (i.group_amount IS NOT NULL and l_attr_inserted_flag = FALSE) THEN
36961:
36962: --Change flexible mask to mask below for formula pattern use.
36963: qp_number.canonical_mask :=
36964: '00999999999999999999999.99999999999999999999999999999999999999';
36965: INSERT INTO qp_preq_line_attrs_formula_tmp
36966: ( line_index,
36967: attribute_type,

Line 36979: qp_number.number_to_canonical(i.group_amount)

36975: G_PRICING_TYPE,
36976: 'VOLUME',
36977: 'PRICING_ATTRIBUTE5',
36978: G_STATUS_UNCHANGED,
36979: qp_number.number_to_canonical(i.group_amount)
36980: );
36981:
36982: --Change mask back to flexible mask.
36983: qp_number.canonical_mask :=

Line 36983: qp_number.canonical_mask :=

36979: qp_number.number_to_canonical(i.group_amount)
36980: );
36981:
36982: --Change mask back to flexible mask.
36983: qp_number.canonical_mask :=
36984: 'FM999999999999999999999.9999999999999999999999999999999999999999';
36985:
36986: l_attr_inserted_flag := TRUE;
36987:

Line 41521: -- qp_number.canonical_mask := 'FM999999999999999999999.99999999999999999999999999999999999999'; --3085147

41517: --If user populates the temp tables directly
41518: --the public API will populate the currency_code etc in
41519: --public variables
41520: --********************************************************************
41521: -- qp_number.canonical_mask := 'FM999999999999999999999.99999999999999999999999999999999999999'; --3085147
41522: qp_number.canonical_mask := 'FM999999999999999999999.9999999999999999999999999999999999999999'; --3169430
41523:
41524: --=======START: Pre-pricing processing needed by JAVA and PL/SQL engine======
41525: IF G_TEMP_TABLE_INSERT_FLAG = G_YES THEN

Line 41522: qp_number.canonical_mask := 'FM999999999999999999999.9999999999999999999999999999999999999999'; --3169430

41518: --the public API will populate the currency_code etc in
41519: --public variables
41520: --********************************************************************
41521: -- qp_number.canonical_mask := 'FM999999999999999999999.99999999999999999999999999999999999999'; --3085147
41522: qp_number.canonical_mask := 'FM999999999999999999999.9999999999999999999999999999999999999999'; --3169430
41523:
41524: --=======START: Pre-pricing processing needed by JAVA and PL/SQL engine======
41525: IF G_TEMP_TABLE_INSERT_FLAG = G_YES THEN
41526:

Line 41532: -- qp_number.canonical_mask := 'FM999999999999999999999.99999999999999999999999999999999999999';

41528: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
41529: RAISE E_ROUTINE_ERRORS;
41530: END IF; */
41531:
41532: -- qp_number.canonical_mask := 'FM999999999999999999999.99999999999999999999999999999999999999';
41533:
41534:
41535: l_bypass_pricing := FND_PROFILE.VALUE(G_BYPASS_PRICING);
41536:

Line 41853: SET value_from = qp_number.number_to_canonical(qp_number.canonical_to_number(lattr.value_from)),

41849:
41850: IF G_AM_INSTALLED_PROFILE = G_YES THEN
41851: BEGIN
41852: UPDATE /*+ dynamic_sampling(1) */ qp_npreq_line_attrs_tmp lattr
41853: SET value_from = qp_number.number_to_canonical(qp_number.canonical_to_number(lattr.value_from)),
41854: value_to = qp_number.number_to_canonical(qp_number.canonical_to_number(lattr.value_to))
41855: WHERE attribute_type = G_PRICING_TYPE
41856: AND pricing_status_code = G_STATUS_UNCHANGED
41857: AND exists (

Line 41854: value_to = qp_number.number_to_canonical(qp_number.canonical_to_number(lattr.value_to))

41850: IF G_AM_INSTALLED_PROFILE = G_YES THEN
41851: BEGIN
41852: UPDATE /*+ dynamic_sampling(1) */ qp_npreq_line_attrs_tmp lattr
41853: SET value_from = qp_number.number_to_canonical(qp_number.canonical_to_number(lattr.value_from)),
41854: value_to = qp_number.number_to_canonical(qp_number.canonical_to_number(lattr.value_to))
41855: WHERE attribute_type = G_PRICING_TYPE
41856: AND pricing_status_code = G_STATUS_UNCHANGED
41857: AND exists (
41858: SELECT format_type

Line 41878: l_msg_value_from := qp_number.number_to_canonical(l_rec.value_from);

41874: FOR l_rec IN am_attr_msg_cur
41875: LOOP
41876: l_msg_context := l_rec.context;
41877: l_msg_attribute := l_rec.attribute;
41878: l_msg_value_from := qp_number.number_to_canonical(l_rec.value_from);
41879: l_msg_value_to := qp_number.number_to_canonical(l_rec.value_to);
41880: END LOOP;
41881:
41882: EXCEPTION

Line 41879: l_msg_value_to := qp_number.number_to_canonical(l_rec.value_to);

41875: LOOP
41876: l_msg_context := l_rec.context;
41877: l_msg_attribute := l_rec.attribute;
41878: l_msg_value_from := qp_number.number_to_canonical(l_rec.value_from);
41879: l_msg_value_to := qp_number.number_to_canonical(l_rec.value_to);
41880: END LOOP;
41881:
41882: EXCEPTION
41883: WHEN OTHERS THEN

Line 41897: SET value_from = qp_number.number_to_canonical(qp_number.canonical_to_number(lattr.value_from)),

41893: ELSE
41894:
41895: BEGIN
41896: UPDATE qp_npreq_line_attrs_tmp lattr
41897: SET value_from = qp_number.number_to_canonical(qp_number.canonical_to_number(lattr.value_from)),
41898: value_to = qp_number.number_to_canonical(qp_number.canonical_to_number(lattr.value_to))
41899: WHERE attribute_type = G_PRICING_TYPE
41900: AND pricing_status_code = G_STATUS_UNCHANGED
41901: AND exists (

Line 41898: value_to = qp_number.number_to_canonical(qp_number.canonical_to_number(lattr.value_to))

41894:
41895: BEGIN
41896: UPDATE qp_npreq_line_attrs_tmp lattr
41897: SET value_from = qp_number.number_to_canonical(qp_number.canonical_to_number(lattr.value_from)),
41898: value_to = qp_number.number_to_canonical(qp_number.canonical_to_number(lattr.value_to))
41899: WHERE attribute_type = G_PRICING_TYPE
41900: AND pricing_status_code = G_STATUS_UNCHANGED
41901: AND exists (
41902: SELECT format_type

Line 41921: l_msg_value_from := qp_number.number_to_canonical(l_rec.value_from);

41917: FOR l_rec IN attr_msg_cur
41918: LOOP
41919: l_msg_context := l_rec.context;
41920: l_msg_attribute := l_rec.attribute;
41921: l_msg_value_from := qp_number.number_to_canonical(l_rec.value_from);
41922: l_msg_value_to := qp_number.number_to_canonical(l_rec.value_to);
41923: END LOOP;
41924: EXCEPTION
41925: WHEN OTHERS THEN

Line 41922: l_msg_value_to := qp_number.number_to_canonical(l_rec.value_to);

41918: LOOP
41919: l_msg_context := l_rec.context;
41920: l_msg_attribute := l_rec.attribute;
41921: l_msg_value_from := qp_number.number_to_canonical(l_rec.value_from);
41922: l_msg_value_to := qp_number.number_to_canonical(l_rec.value_to);
41923: END LOOP;
41924: EXCEPTION
41925: WHEN OTHERS THEN
41926: l_status_text := 'Exception in QP_PREQ_GRP.PRICE_REQUEST ';

Line 42391: (SELECT /+ index(b QP_PREQ_LINE_ATTRS_TMP_N2) / distinct qp_number.canonical_to_number(value_from),validated_flag

42387:
42388: --[julin/pricebook] added hint
42389: UPDATE qp_npreq_lines_tmp a
42390: SET (price_list_header_id,validated_flag) =
42391: (SELECT /*+ index(b QP_PREQ_LINE_ATTRS_TMP_N2) */ distinct qp_number.canonical_to_number(value_from),validated_flag
42392: FROM qp_npreq_line_attrs_tmp b
42393: WHERE a.line_index = b.line_index
42394: AND context = G_LIST_HEADER_CONTEXT
42395: AND attribute = G_PRICELIST_ATTRIBUTE

Line 42805: select qp_number.canonical_to_number(value_from) -- 5515203

42801: IF (l_header_limit_exists = G_YES or l_line_limit_exists = G_YES) THEN
42802: -- Bug 3143535
42803: -- get the order amount from attributes. if not found then sum it from order lines
42804: begin
42805: select qp_number.canonical_to_number(value_from) -- 5515203
42806: into v_order_amount
42807: from qp_npreq_line_attrs_tmp
42808: where CONTEXT = G_PRIC_VOLUME_CONTEXT
42809: AND ATTRIBUTE = G_ORDER_AMOUNT_ATTRIBUTE