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 972: and qp_number.canonical_to_number(decode(qpq.qualifier_datatype,G_NUMERIC,qplatq.value_from,null))

968: and qpq.comparison_operator_code = G_OPERATOR_BETWEEN
969: and qpq.qualifier_datatype = G_NUMERIC
970: and qpq.search_ind = 2
971: and qpq.qualifier_group_cnt > 1
972: and qp_number.canonical_to_number(decode(qpq.qualifier_datatype,G_NUMERIC,qplatq.value_from,null))
973: between qpq.qual_attr_value_from_number and qpq.qual_attr_value_to_number
974: and ((qph.currency_code IS NOT NULL AND qph.currency_code = G_CURRENCY_CODE)
975: OR
976: qph.currency_code IS NULL) -- optional currency

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

1063: and qpq.qualifier_attribute = qplatq.attribute
1064: and qpq.comparison_operator_code = G_OPERATOR_BETWEEN
1065: and qpq.qualifier_datatype = G_NUMERIC
1066: and qpq.search_ind = 2
1067: and qp_number.canonical_to_number(decode(qpq.qualifier_datatype,G_NUMERIC,qplatq.value_from,null))
1068: between qpq.qual_attr_value_from_number and qpq.qual_attr_value_to_number
1069: and ((qph.currency_code IS NOT NULL AND qph.currency_code = G_CURRENCY_CODE)
1070: OR
1071: qph.currency_code IS NULL) -- optional currency

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

1885: AND c.excluder_flag = G_NO
1886: --3683298 AND qpprod.line_index = qplatq.line_index
1887: AND rownum = 1)
1888: ) --3520634 end
1889: and qp_number.canonical_to_number(decode(qpq.qualifier_datatype,G_NUMERIC,qplatq.value_from,null))
1890: between qpq.qual_attr_value_from_number and qpq.qual_attr_value_to_number
1891: and ((qph.currency_code IS NOT NULL AND qph.currency_code = G_CURRENCY_CODE)
1892: OR
1893: qph.currency_code IS NULL) -- optional currency

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

2531: and qpq.comparison_operator_code = G_OPERATOR_BETWEEN
2532: and qpq.qualifier_datatype = G_NUMERIC
2533: and qpq.search_ind = 1
2534: and qpq.list_line_id = -1 -- Header level quals
2535: and qp_number.canonical_to_number(decode(qpq.qualifier_datatype,G_NUMERIC,qplatq.value_from,null))
2536: between qpq.qual_attr_value_from_number and qpq.qual_attr_value_to_number
2537: and ((qph.currency_code IS NOT NULL AND qph.currency_code = G_CURRENCY_CODE)
2538: OR
2539: qph.currency_code IS NULL) -- optional currency

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

7443: -- ITEM QUANTITY(Price List Sequence)
7444: /* IF (p_pricing_phase_seq = G_PRICE_LIST_SEQUENCE AND i.LINE_TYPE_CODE = G_LINE_LEVEL) THEN
7445:
7446: UPDATE qp_npreq_line_attrs_tmp
7447: SET VALUE_FROM = qp_number.number_to_canonical(nvl(I.LINE_QUANTITY,0))
7448: WHERE LINE_INDEX = I.LINE_INDEX
7449: AND CONTEXT = G_PRIC_VOLUME_CONTEXT
7450: AND ATTRIBUTE = G_QUANTITY_ATTRIBUTE
7451: AND ATTRIBUTE_TYPE = G_PRICING_TYPE

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

7460: p_ATTRIBUTE_LEVEL =>G_LINE_LEVEL,
7461: p_ATTRIBUTE_TYPE =>G_PRICING_TYPE,
7462: p_CONTEXT =>G_PRIC_VOLUME_CONTEXT,
7463: p_ATTRIBUTE =>G_QUANTITY_ATTRIBUTE,
7464: p_VALUE_FROM =>qp_number.number_to_canonical(NVL(I.LINE_QUANTITY,0)),
7465: p_VALIDATED_FLAG =>G_NO,
7466: p_APPLIED_FLAG =>G_LIST_NOT_APPLIED,
7467: p_PRICING_STATUS_CODE =>G_STATUS_UNCHANGED,
7468: P_PRICING_ATTR_FLAG =>G_PRICING_YES,

Line 7545: 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));

7541: INDX,QP_PREQ_GRP.source_vol_contexts_attributes.source_vol_contexts_attributes_upd3,qp_npreq_line_attrs_tmp_N2,ATTRIBUTE,4
7542: INDX,QP_PREQ_GRP.source_vol_contexts_attributes.source_vol_contexts_attributes_upd3,qp_npreq_line_attrs_tmp_N2,LINE_INDEX,5
7543: */
7544: -- julin [3805113]: bulk update
7545: 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));
7546: l_ia_line_index_tbl(l_ia_bulk_count) := l_l_line_index_tbl(I);
7547: l_ia_attribute_tbl(l_ia_bulk_count) := G_QUANTITY_ATTRIBUTE;
7548: l_ia_bulk_count := l_ia_bulk_count + 1;
7549:

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

7556: p_ATTRIBUTE_LEVEL =>G_LINE_LEVEL,
7557: p_ATTRIBUTE_TYPE =>G_PRICING_TYPE,
7558: p_CONTEXT =>G_PRIC_VOLUME_CONTEXT,
7559: p_ATTRIBUTE =>G_QUANTITY_ATTRIBUTE,
7560: p_VALUE_FROM =>qp_number.number_to_canonical(nvl(NVL(I.PRICED_QUANTITY,I.LINE_QUANTITY),0)),
7561: p_VALIDATED_FLAG =>G_NO,
7562: p_APPLIED_FLAG =>G_LIST_NOT_APPLIED,
7563: p_PRICING_STATUS_CODE =>G_STATUS_UNCHANGED,
7564: P_PRICING_ATTR_FLAG =>G_PRICING_YES,

Line 7577: 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));

7573: INDX,QP_PREQ_GRP.source_vol_contexts_attributes.source_vol_contexts_attributes_upd5,qp_npreq_line_attrs_tmp_N2,ATTRIBUTE,4
7574: INDX,QP_PREQ_GRP.source_vol_contexts_attributes.source_vol_contexts_attributes_upd5,qp_npreq_line_attrs_tmp_N2,LINE_INDEX,5
7575: */
7576: -- julin [3805113]: bulk update
7577: 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));
7578: l_ia_line_index_tbl(l_ia_bulk_count) := l_l_line_index_tbl(I);
7579: l_ia_attribute_tbl(l_ia_bulk_count) := G_LINE_AMT_ATTRIBUTE;
7580: l_ia_bulk_count := l_ia_bulk_count + 1;
7581:

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

7588: p_ATTRIBUTE_LEVEL =>G_LINE_LEVEL,
7589: p_ATTRIBUTE_TYPE =>G_PRICING_TYPE,
7590: p_CONTEXT =>G_PRIC_VOLUME_CONTEXT,
7591: p_ATTRIBUTE =>G_LINE_AMT_ATTRIBUTE,
7592: p_VALUE_FROM =>qp_number.number_to_canonical(nvl(nvl(I.PRICED_QUANTITY,I.LINE_QUANTITY) * I.UNIT_PRICE ,0)),
7593: p_VALIDATED_FLAG =>G_NO,
7594: p_APPLIED_FLAG =>G_LIST_NOT_APPLIED,
7595: p_PRICING_STATUS_CODE =>G_STATUS_UNCHANGED,
7596: P_PRICING_ATTR_FLAG =>G_PRICING_YES,

Line 7616: 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))

7612: -- julin [3805113]: bulk update for CROSS ORDER VOLUME
7613: IF (l_co_line_index_tbl.count > 0) THEN
7614: FORALL I IN l_co_line_index_tbl.first..l_co_line_index_tbl.last
7615: UPDATE /*+ index(qp_npreq_line_attrs_tmp qp_preq_line_attrs_tmp_n2) */ qp_npreq_line_attrs_tmp --upd4
7616: 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))
7617: WHERE LINE_INDEX = l_co_line_index_tbl(I)
7618: AND CONTEXT = G_PRIC_VOLUME_CONTEXT
7619: AND ATTRIBUTE IN ('PRICING_ATTRIBUTE3','PRICING_ATTRIBUTE1','PRICING_ATTRIBUTE11')
7620: AND ATTRIBUTE_TYPE = G_PRICING_TYPE

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

7655: INDX,QP_PREQ_GRP.source_vol_contexts_attributes.source_vol_contexts_attributes_upd6,qp_npreq_line_attrs_tmp_N2,ATTRIBUTE,4
7656: */
7657: -- Bug 3143535 - ORDER AMOUNT CALCULATION ISSUE
7658: UPDATE qp_npreq_line_attrs_tmp --upd6
7659: --SET VALUE_FROM = qp_number.number_to_canonical(v_order_amt)
7660: SET VALUE_FROM = qp_number.number_to_canonical(qp_number.canonical_to_number(value_from)
7661: - G_BEFORE_PRICING_ORD_AMT
7662: + v_order_amt)
7663: WHERE

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

7656: */
7657: -- Bug 3143535 - ORDER AMOUNT CALCULATION ISSUE
7658: UPDATE qp_npreq_line_attrs_tmp --upd6
7659: --SET VALUE_FROM = qp_number.number_to_canonical(v_order_amt)
7660: SET VALUE_FROM = qp_number.number_to_canonical(qp_number.canonical_to_number(value_from)
7661: - G_BEFORE_PRICING_ORD_AMT
7662: + v_order_amt)
7663: WHERE
7664: CONTEXT = G_PRIC_VOLUME_CONTEXT

Line 7683: qp_number.number_to_canonical(v_order_amt),

7679: LINE_TYPE_CODE,
7680: G_QUALIFIER_TYPE,
7681: G_PRIC_VOLUME_CONTEXT,
7682: G_ORDER_AMOUNT_ATTRIBUTE,
7683: qp_number.number_to_canonical(v_order_amt),
7684: G_NO,
7685: G_NO,
7686: G_STATUS_UNCHANGED,
7687: G_NO

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

8534: G_ATTRIBUTE_LEVEL_tbl(K) := G_LINE_LEVEL;
8535: G_ATTRIBUTE_TYPE_tbl(K) := G_PRICING_TYPE;
8536: G_CONTEXT_tbl(K) := G_PRIC_VOLUME_CONTEXT;
8537: G_ATTRIBUTE_tbl(K) := G_QUANTITY_ATTRIBUTE;
8538: G_VALUE_FROM_tbl(K) := qp_number.number_to_canonical(l_line_quantity);
8539: G_VALUE_TO_tbl(K) := NULL;
8540: G_COMPARISON_OPERATOR_TYPE_tbl(K):=NULL;
8541: G_VALIDATED_FLAG_tbl(K) := G_NO;
8542: G_APPLIED_FLAG_tbl(K) := G_LIST_NOT_APPLIED;

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

8594: G_ATTRIBUTE_LEVEL_tbl(K) := G_LINE_LEVEL;
8595: G_ATTRIBUTE_TYPE_tbl(K) := G_PRICING_TYPE;
8596: G_CONTEXT_tbl(K) := G_PRIC_VOLUME_CONTEXT;
8597: G_ATTRIBUTE_tbl(K) := G_LINE_AMT_ATTRIBUTE;
8598: G_VALUE_FROM_tbl(K) := qp_number.number_to_canonical(l_line_amount);
8599: G_VALUE_TO_tbl(K) := NULL;
8600: G_COMPARISON_OPERATOR_TYPE_tbl(K):=NULL;
8601: G_VALIDATED_FLAG_tbl(K) := G_NO;
8602: G_APPLIED_FLAG_tbl(K) := G_LIST_NOT_APPLIED;

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

10284:
10285: CURSOR line_grp_cur IS
10286: select /*+ ORDERED USE_NL(c a ) index(a qp_pricing_attributes_n2) line_grp_cur */
10287: b.created_from_list_line_id list_line_id , c.context , c.attribute ,
10288: sum(qp_number.canonical_to_number(c.value_from)) group_value
10289: from
10290: qp_npreq_ldets_tmp b , qp_npreq_line_attrs_tmp c , qp_pricing_attributes a
10291: where
10292: b.modifier_level_code = G_LINE_GROUP

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

10301: and a.pricing_attribute = c.attribute
10302: group by b.created_from_list_line_id , c.context , c.attribute;
10303:
10304: /*select c.list_line_id list_line_id , c.context , c.attribute ,
10305: sum(qp_number.canonical_to_number(c.value_from)) group_value
10306: from
10307: qp_npreq_line_attrs_tmp c
10308: where
10309: c.modifier_level_code = G_LINE_GROUP

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

11042: l_value_from_num := I.group_amount;
11043: END IF;
11044: l_selected_volume_attr := G_AMOUNT; -- 2388011_new
11045: ELSE -- For Order Amount,Period1 Amount kind of attributes
11046: l_value_from_num := qp_number.canonical_to_number(I.value_from);
11047: END IF;
11048: ELSE -- Make it a success,because line group between is done again,so do not delete
11049: l_value_from_num := NULL;
11050: END IF;

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

11055: engine_debug('Line detail index: '||I.line_detail_index);
11056: END IF;
11057: ELSE -- is not a line group
11058: l_is_line_group_flag := 'F';
11059: l_value_from_num := qp_number.canonical_to_number(I.value_from);
11060: -- begin 2388011_new
11061: IF (I.attribute = G_QUANTITY_ATTRIBUTE) THEN
11062: l_selected_volume_attr := G_QUANTITY;
11063: ELSIF (I.attribute = G_LINE_AMT_ATTRIBUTE) THEN

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

11068: -- end 2388011_new
11069: END IF;-- END is a line group
11070: ELSE --else Not a Volume Context
11071: l_is_line_group_flag := 'F';
11072: l_value_from_num := qp_number.canonical_to_number(I.value_from);
11073: END IF;
11074:
11075:
11076: IF (I.setup_value_from IS NULL) THEN

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

11075:
11076: IF (I.setup_value_from IS NULL) THEN
11077: l_setup_value_from_num := l_value_from_num;
11078: ELSE
11079: l_setup_value_from_num := qp_number.canonical_to_number(I.setup_value_from);
11080: END IF;
11081:
11082: IF (I.setup_value_to IS NULL) THEN
11083: l_setup_value_to_num := l_value_from_num;

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

11081:
11082: IF (I.setup_value_to IS NULL) THEN
11083: l_setup_value_to_num := l_value_from_num;
11084: ELSE
11085: l_setup_value_to_num := qp_number.canonical_to_number(I.setup_value_to);
11086: END IF;
11087:
11088: IF G_DEBUG_ENGINE = FND_API.G_TRUE THEN
11089: engine_debug('1VALUE: '||l_value_from_num);

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

11217: IF (p_pricing_phase_id <> G_PRICE_LIST_PHASE_ID) THEN
11218: l_value_from_num := I.group_amount;
11219: END IF;
11220: ELSE -- For Order Amount,Period1 Amount kind of attributes
11221: l_value_from_num := qp_number.canonical_to_number(I.value_from);
11222: END IF;
11223: ELSE -- Make it a success,because line group between is done again,so do not delete
11224: l_value_from_num := NULL;
11225: END IF;

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

11230: engine_debug('Line detail index: '||I.line_detail_index);
11231: END IF;
11232: ELSE -- is not a line group
11233: l_is_line_group_flag := 'F';
11234: l_value_from_num := qp_number.canonical_to_number(I.value_from);
11235: END IF;
11236: ELSE --else Not a Volume Context
11237: l_is_line_group_flag := 'F';
11238: l_value_from_num := qp_number.canonical_to_number(I.value_from);

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

11234: l_value_from_num := qp_number.canonical_to_number(I.value_from);
11235: END IF;
11236: ELSE --else Not a Volume Context
11237: l_is_line_group_flag := 'F';
11238: l_value_from_num := qp_number.canonical_to_number(I.value_from);
11239: END IF;
11240:
11241:
11242: IF (I.setup_value_from IS NULL) THEN

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

11241:
11242: IF (I.setup_value_from IS NULL) THEN
11243: l_setup_value_from_num := l_value_from_num;
11244: ELSE
11245: l_setup_value_from_num := qp_number.canonical_to_number(I.setup_value_from);
11246: END IF;
11247:
11248: IF (I.setup_value_to IS NULL) THEN
11249: l_setup_value_to_num := l_value_from_num;

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

11247:
11248: IF (I.setup_value_to IS NULL) THEN
11249: l_setup_value_to_num := l_value_from_num;
11250: ELSE
11251: l_setup_value_to_num := qp_number.canonical_to_number(I.setup_value_to);
11252: END IF;
11253:
11254: IF G_DEBUG_ENGINE = FND_API.G_TRUE THEN
11255: engine_debug('1VALUE: '||l_value_from_num);

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

11500: AND qplat_pricing.attribute_type = G_PRICING_TYPE
11501: AND qplat_pricing.line_index = qplines.line_index
11502: AND qplat_pricing.pricing_status_code = G_STATUS_UNCHANGED
11503: AND qplat_pricing.line_index = p_line_index
11504: -- and qp_number.canonical_to_number(qplat_pricing.value_from) <> 0 -- 5158413
11505: -- commented above for bug#6896139 as fix for bug#5158413 did not consider for G_LINE_GROUP,lines with line qty as 0
11506: --(i.e qplat_pricing.value_from=0) even when the qualifier group count for G_LINE_GROUP was greater than zero
11507: and qpll.list_header_id = qph.list_header_id /* Vivek */
11508: and QPH.CURRENCY_HEADER_ID = QCDT.CURRENCY_HEADER_ID /* Vivek */

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

11550: ) /* Vivek */
11551: ) /* Vivek */
11552: and (( (p_reduced_pbh_processing = G_YES) --[julin/3783009/4712794]
11553: and (nvl(qplines.usage_pricing_type,G_REGULAR_USAGE_TYPE) <> G_AUTHORING_TYPE)
11554: and ( (qpll.price_break_type_code = G_POINT_BREAK and qp_number.canonical_to_number(qplat_pricing.value_from)
11555: between qp_number.canonical_to_number(qppa.pricing_attr_value_from)
11556: and qp_number.canonical_to_number(qppa.pricing_attr_value_to)
11557: ) OR
11558: (qpll.price_break_type_code = G_RANGE_BREAK and qp_number.canonical_to_number(qppa.pricing_attr_value_from)

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

11551: ) /* Vivek */
11552: and (( (p_reduced_pbh_processing = G_YES) --[julin/3783009/4712794]
11553: and (nvl(qplines.usage_pricing_type,G_REGULAR_USAGE_TYPE) <> G_AUTHORING_TYPE)
11554: and ( (qpll.price_break_type_code = G_POINT_BREAK and qp_number.canonical_to_number(qplat_pricing.value_from)
11555: between qp_number.canonical_to_number(qppa.pricing_attr_value_from)
11556: and qp_number.canonical_to_number(qppa.pricing_attr_value_to)
11557: ) OR
11558: (qpll.price_break_type_code = G_RANGE_BREAK and qp_number.canonical_to_number(qppa.pricing_attr_value_from)
11559: <= qp_number.canonical_to_number(qplat_pricing.value_from)

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

11552: and (( (p_reduced_pbh_processing = G_YES) --[julin/3783009/4712794]
11553: and (nvl(qplines.usage_pricing_type,G_REGULAR_USAGE_TYPE) <> G_AUTHORING_TYPE)
11554: and ( (qpll.price_break_type_code = G_POINT_BREAK and qp_number.canonical_to_number(qplat_pricing.value_from)
11555: between qp_number.canonical_to_number(qppa.pricing_attr_value_from)
11556: and qp_number.canonical_to_number(qppa.pricing_attr_value_to)
11557: ) OR
11558: (qpll.price_break_type_code = G_RANGE_BREAK and qp_number.canonical_to_number(qppa.pricing_attr_value_from)
11559: <= qp_number.canonical_to_number(qplat_pricing.value_from)
11560: )

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

11554: and ( (qpll.price_break_type_code = G_POINT_BREAK and qp_number.canonical_to_number(qplat_pricing.value_from)
11555: between qp_number.canonical_to_number(qppa.pricing_attr_value_from)
11556: and qp_number.canonical_to_number(qppa.pricing_attr_value_to)
11557: ) OR
11558: (qpll.price_break_type_code = G_RANGE_BREAK and qp_number.canonical_to_number(qppa.pricing_attr_value_from)
11559: <= qp_number.canonical_to_number(qplat_pricing.value_from)
11560: )
11561: )
11562: )

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

11555: between qp_number.canonical_to_number(qppa.pricing_attr_value_from)
11556: and qp_number.canonical_to_number(qppa.pricing_attr_value_to)
11557: ) OR
11558: (qpll.price_break_type_code = G_RANGE_BREAK and qp_number.canonical_to_number(qppa.pricing_attr_value_from)
11559: <= qp_number.canonical_to_number(qplat_pricing.value_from)
11560: )
11561: )
11562: )
11563: or

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

11562: )
11563: or
11564: (p_reduced_pbh_processing = G_NO)
11565: )
11566: ORDER BY qp_number.canonical_to_number(qppa.pricing_attr_value_from); --bug#1819397
11567:
11568: cursor l_price_break_detail_cur(p_reduced_pbh_processing VARCHAR2) is
11569: SELECT /*+ ordered use_nl(qplines, qprm, qppa, qpll) */
11570: qpll.pricing_group_sequence,

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

11629: AND qplat_pricing.attribute_type = G_PRICING_TYPE
11630: AND qplat_pricing.line_index = qplines.line_index
11631: AND qplat_pricing.pricing_status_code = G_STATUS_UNCHANGED
11632: AND qplat_pricing.line_index = p_line_index
11633: -- and qp_number.canonical_to_number(qplat_pricing.value_from) <> 0 -- 5158413
11634: -- commented above for bug#6896139 as fix for bug#5158413 did not consider for G_LINE_GROUP,lines with line qty as 0
11635: --(i.e qplat_pricing.value_from=0) even when the qualifier group count for G_LINE_GROUP was greater than zero
11636: and (( (p_reduced_pbh_processing = G_YES) --[julin/3783009/4712794]
11637: and (nvl(qplines.usage_pricing_type,G_REGULAR_USAGE_TYPE) <> G_AUTHORING_TYPE)

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

11634: -- commented above for bug#6896139 as fix for bug#5158413 did not consider for G_LINE_GROUP,lines with line qty as 0
11635: --(i.e qplat_pricing.value_from=0) even when the qualifier group count for G_LINE_GROUP was greater than zero
11636: and (( (p_reduced_pbh_processing = G_YES) --[julin/3783009/4712794]
11637: and (nvl(qplines.usage_pricing_type,G_REGULAR_USAGE_TYPE) <> G_AUTHORING_TYPE)
11638: and ( (qpll.price_break_type_code = G_POINT_BREAK and qp_number.canonical_to_number(qplat_pricing.value_from)
11639: between qp_number.canonical_to_number(qppa.pricing_attr_value_from)
11640: and qp_number.canonical_to_number(qppa.pricing_attr_value_to)
11641: ) OR
11642: (qpll.price_break_type_code = G_RANGE_BREAK and qp_number.canonical_to_number(qppa.pricing_attr_value_from)

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

11635: --(i.e qplat_pricing.value_from=0) even when the qualifier group count for G_LINE_GROUP was greater than zero
11636: and (( (p_reduced_pbh_processing = G_YES) --[julin/3783009/4712794]
11637: and (nvl(qplines.usage_pricing_type,G_REGULAR_USAGE_TYPE) <> G_AUTHORING_TYPE)
11638: and ( (qpll.price_break_type_code = G_POINT_BREAK and qp_number.canonical_to_number(qplat_pricing.value_from)
11639: between qp_number.canonical_to_number(qppa.pricing_attr_value_from)
11640: and qp_number.canonical_to_number(qppa.pricing_attr_value_to)
11641: ) OR
11642: (qpll.price_break_type_code = G_RANGE_BREAK and qp_number.canonical_to_number(qppa.pricing_attr_value_from)
11643: <= qp_number.canonical_to_number(qplat_pricing.value_from)

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

11636: and (( (p_reduced_pbh_processing = G_YES) --[julin/3783009/4712794]
11637: and (nvl(qplines.usage_pricing_type,G_REGULAR_USAGE_TYPE) <> G_AUTHORING_TYPE)
11638: and ( (qpll.price_break_type_code = G_POINT_BREAK and qp_number.canonical_to_number(qplat_pricing.value_from)
11639: between qp_number.canonical_to_number(qppa.pricing_attr_value_from)
11640: and qp_number.canonical_to_number(qppa.pricing_attr_value_to)
11641: ) OR
11642: (qpll.price_break_type_code = G_RANGE_BREAK and qp_number.canonical_to_number(qppa.pricing_attr_value_from)
11643: <= qp_number.canonical_to_number(qplat_pricing.value_from)
11644: )

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

11638: and ( (qpll.price_break_type_code = G_POINT_BREAK and qp_number.canonical_to_number(qplat_pricing.value_from)
11639: between qp_number.canonical_to_number(qppa.pricing_attr_value_from)
11640: and qp_number.canonical_to_number(qppa.pricing_attr_value_to)
11641: ) OR
11642: (qpll.price_break_type_code = G_RANGE_BREAK and qp_number.canonical_to_number(qppa.pricing_attr_value_from)
11643: <= qp_number.canonical_to_number(qplat_pricing.value_from)
11644: )
11645: )
11646: )

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

11639: between qp_number.canonical_to_number(qppa.pricing_attr_value_from)
11640: and qp_number.canonical_to_number(qppa.pricing_attr_value_to)
11641: ) OR
11642: (qpll.price_break_type_code = G_RANGE_BREAK and qp_number.canonical_to_number(qppa.pricing_attr_value_from)
11643: <= qp_number.canonical_to_number(qplat_pricing.value_from)
11644: )
11645: )
11646: )
11647: or

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

11646: )
11647: or
11648: (p_reduced_pbh_processing = G_NO)
11649: )
11650: ORDER BY qp_number.canonical_to_number(qppa.pricing_attr_value_from); --bug#1819397
11651:
11652: CURSOR l_pbh_cur IS
11653: SELECT net_amount_flag
11654: FROM qp_list_lines

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

11983: 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
11984: IF G_DEBUG_ENGINE = FND_API.G_TRUE THEN
11985: engine_debug ('no uom conversion, pricing_uom_code is same as order_uom_code: '||l_h_line_uom_code_tbl(i));
11986: END IF;
11987: l_quantity := qp_number.canonical_to_number(l_h_value_from_tbl(i));
11988: IF G_DEBUG_ENGINE = FND_API.G_TRUE THEN
11989: engine_debug ('l_quantity: '||l_quantity);
11990: END IF;
11991: ELSE -- uom conversion

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

11993: engine_debug ('uom conversion...');
11994: engine_debug ('order_uom_code: '||l_h_order_uom_code_tbl(i));
11995: engine_debug ('primary_uom_code: '||l_h_product_uom_code_tbl(i));
11996: END IF;
11997: l_total_item_quantity := qp_number.canonical_to_number(l_h_value_from_tbl(i));
11998: IF G_DEBUG_ENGINE = FND_API.G_TRUE THEN
11999: engine_debug ('l_quantity before uom convertion: '||l_total_item_quantity );
12000: END IF;
12001:

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

12023: END IF;
12024: l_selected_volume_attr := 'O'; --2388011_latest
12025: -- end, shu fix
12026: ELSE
12027: l_quantity := qp_number.canonical_to_number(l_h_value_from_tbl(i));
12028: l_selected_volume_attr := G_AMOUNT;
12029: END IF;
12030:
12031: -- This LINE_QUANTITY is column is needed for knowing the right value for

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

12050:
12051: END IF;
12052:
12053:
12054: l_setup_value_from := qp_number.canonical_to_number(l_h_pricing_attr_val_from_tbl(i));
12055:
12056: --handle the case when value_to is null
12057: IF (l_h_pricing_attr_val_to_tbl(i) IS NULL) THEN
12058: IF l_quantity >= l_setup_value_from THEN

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

12060: ELSIF l_quantity < l_setup_value_from THEN
12061: l_value_to := l_setup_value_from;
12062: END IF;
12063: ELSE
12064: l_value_to := qp_number.canonical_to_number(l_h_pricing_attr_val_to_tbl(i));
12065: END IF;
12066:
12067: IF G_DEBUG_ENGINE = FND_API.G_TRUE THEN
12068: engine_debug(l_routine||' Line quantity: '||l_quantity);

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

12467: l_line_detail_tbl(N).base_currency_code := l_h_base_currency_code_tbl(i); /* Vivek /
12468: */
12469: /* Proration START */
12470: if l_proration_processed = 'Y' then
12471: l_h_pricing_attr_val_from_tbl(i) := qp_number.number_to_canonical(l_setup_value_from);
12472: l_h_pricing_attr_val_to_tbl(i) := qp_number.number_to_canonical(l_value_to);
12473: if l_continuous_flag = TRUE then
12474: -- 4061138
12475: l_h_pricing_attr_val_to_tbl(i-1) := l_h_pricing_attr_val_from_tbl(i);

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

12468: */
12469: /* Proration START */
12470: if l_proration_processed = 'Y' then
12471: l_h_pricing_attr_val_from_tbl(i) := qp_number.number_to_canonical(l_setup_value_from);
12472: l_h_pricing_attr_val_to_tbl(i) := qp_number.number_to_canonical(l_value_to);
12473: if l_continuous_flag = TRUE then
12474: -- 4061138
12475: l_h_pricing_attr_val_to_tbl(i-1) := l_h_pricing_attr_val_from_tbl(i);
12476: -- here, we do the aforementioned BETWEEN check again to catch the

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

12719: l_h_arithmetic_operator_tbl(J),
12720: l_h_operand_tbl(J),
12721: l_h_pricing_group_sequence_tbl(J),
12722: l_h_price_break_type_code_tbl(J),
12723: qp_number.canonical_to_number(l_h_pricing_attr_val_from_tbl(J)),
12724: qp_number.canonical_to_number(l_h_pricing_attr_val_to_tbl(J)),
12725: l_l_quantity_tbl(J));
12726: END IF;
12727:

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

12720: l_h_operand_tbl(J),
12721: l_h_pricing_group_sequence_tbl(J),
12722: l_h_price_break_type_code_tbl(J),
12723: qp_number.canonical_to_number(l_h_pricing_attr_val_from_tbl(J)),
12724: qp_number.canonical_to_number(l_h_pricing_attr_val_to_tbl(J)),
12725: l_l_quantity_tbl(J));
12726: END IF;
12727:
12728: IF (G_DEBUG_ENGINE = FND_API.G_TRUE) THEN

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

14348: --[julin/5223502] price_list_header_id directly passed in via lines_tmp has precedence over sourced value
14349: UPDATE /*+ dynamic_sampling(1) */ qp_npreq_lines_tmp a
14350: SET (price_list_header_id,validated_flag) =
14351: (SELECT /*+ index(b QP_PREQ_LINE_ATTRS_TMP_N2) */ distinct
14352: CASE WHEN (a.PRICE_LIST_HEADER_ID < 0) THEN qp_number.canonical_to_number(value_from)
14353: ELSE a.PRICE_LIST_HEADER_ID
14354: END price_list_header_id,
14355: validated_flag
14356: FROM qp_npreq_line_attrs_tmp b

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

25861: and ((qpq.qualifier_datatype IN (G_VARCHAR,G_DATE_X,G_DATE_Y) --[julin/5007789]
25862: and qplatq.value_from between qpq.qualifier_attr_value and qpq.qualifier_attr_value_to)
25863: or
25864: (qpq.qualifier_datatype = G_NUMERIC
25865: and qp_number.canonical_to_number(decode(qpq.qualifier_datatype,G_NUMERIC,qplatq.value_from,null))
25866: between qpq.qual_attr_value_from_number and qpq.qual_attr_value_to_number))
25867: AND qpprod.pricing_phase_id = p_pricing_phase_id
25868: AND qpprod.qualification_ind = QP_PREQ_GRP.G_YES_PROD_HDR_QUAL_IND
25869: AND qpprod.product_attribute_context = qplatpr.context

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

26339: and ((qpq.qualifier_datatype IN (G_VARCHAR,G_DATE_X,G_DATE_Y) --[julin/5007789]
26340: and qplatq.value_from between qpq.qualifier_attr_value and qpq.qualifier_attr_value_to)
26341: or
26342: (qpq.qualifier_datatype = G_NUMERIC
26343: and qp_number.canonical_to_number(decode(qpq.qualifier_datatype,G_NUMERIC,qplatq.value_from,null))
26344: between qpq.qual_attr_value_from_number and qpq.qual_attr_value_to_number))
26345: AND qpprod.pricing_phase_id = p_pricing_phase_id
26346: AND qpprod.qualification_ind = QP_PREQ_GRP.G_YES_PROD_HDR_QUAL_IND
26347: AND qpprod.product_attribute_context = qplatpr.context

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

26725: and ((qpq.qualifier_datatype IN (G_VARCHAR,G_DATE_X,G_DATE_Y) --[julin/5007789]
26726: and qplatq.value_from between qpq.qualifier_attr_value and qpq.qualifier_attr_value_to)
26727: or
26728: (qpq.qualifier_datatype = G_NUMERIC
26729: and qp_number.canonical_to_number(decode(qpq.qualifier_datatype,G_NUMERIC,qplatq.value_from,null))
26730: between qpq.qual_attr_value_from_number and qpq.qual_attr_value_to_number))
26731: AND qpprod.pricing_phase_id = p_pricing_phase_id
26732: AND qpprod.qualification_ind = QP_PREQ_GRP.G_YES_PROD_PRIC_HDR_QUAL_IND
26733: AND qpprod.product_attribute_context = qplatpr.context

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

27264: and ((qpq.qualifier_datatype IN (G_VARCHAR,G_DATE_X,G_DATE_Y) --[julin/5007789]
27265: and qplatq.value_from between qpq.qualifier_attr_value and qpq.qualifier_attr_value_to)
27266: or
27267: (qpq.qualifier_datatype = G_NUMERIC
27268: and qp_number.canonical_to_number(decode(qpq.qualifier_datatype,G_NUMERIC,qplatq.value_from,null))
27269: between qpq.qual_attr_value_from_number and qpq.qual_attr_value_to_number))
27270: AND qpprod.pricing_phase_id = p_pricing_phase_id
27271: AND qpprod.qualification_ind = QP_PREQ_GRP.G_YES_PROD_PRIC_HDR_QUAL_IND
27272: AND qpprod.product_attribute_context = qplatpr.context

Line 29977: SELECT qp_number.canonical_to_number(VALUE_FROM)

29973: FROM qp_list_headers_v a
29974: WHERE a.list_header_id = p_list_header_id;
29975:
29976: CURSOR get_request_inv_item_id_cur(p_line_index PLS_INTEGER) IS
29977: SELECT qp_number.canonical_to_number(VALUE_FROM)
29978: FROM qp_npreq_line_attrs_tmp
29979: WHERE CONTEXT = G_PRIC_ITEM_CONTEXT
29980: AND ATTRIBUTE = G_PRIC_ATTRIBUTE1
29981: AND ATTRIBUTE_TYPE = G_PRODUCT_TYPE

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

30321: END IF;
30322: ELSIF (K.LINE_DETAIL_TYPE_CODE = G_CHILD_DETAIL_TYPE) THEN
30323: --FOR P IN l_line_attrs_cur(K.LINE_DETAIL_INDEX) LOOP
30324:
30325: p_cal_req_rltd_tbl(N).value_from := qp_number.canonical_to_number(G_CHILD_VALUE_FROM_TBL(k.line_detail_index));
30326: p_cal_req_rltd_tbl(N).value_to := qp_number.canonical_to_number(G_CHILD_VALUE_TO_TBL(k.line_detail_index));
30327: p_cal_req_rltd_tbl(N).operand_calculation_code := K.operand_calculation_code;
30328: p_cal_req_rltd_tbl(N).operand_value := K.operand_value;
30329: p_cal_req_rltd_tbl(N).price_break_type_code := K.price_break_type_code;

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

30322: ELSIF (K.LINE_DETAIL_TYPE_CODE = G_CHILD_DETAIL_TYPE) THEN
30323: --FOR P IN l_line_attrs_cur(K.LINE_DETAIL_INDEX) LOOP
30324:
30325: p_cal_req_rltd_tbl(N).value_from := qp_number.canonical_to_number(G_CHILD_VALUE_FROM_TBL(k.line_detail_index));
30326: p_cal_req_rltd_tbl(N).value_to := qp_number.canonical_to_number(G_CHILD_VALUE_TO_TBL(k.line_detail_index));
30327: p_cal_req_rltd_tbl(N).operand_calculation_code := K.operand_calculation_code;
30328: p_cal_req_rltd_tbl(N).operand_value := K.operand_value;
30329: p_cal_req_rltd_tbl(N).price_break_type_code := K.price_break_type_code;
30330: p_cal_req_rltd_tbl(N).child_line_detail_index :=K.line_detail_index;

Line 30997: pricing_status_code, qp_number.canonical_to_number(value_from)

30993: E_ATTRIBUTE_NON_NUMERIC EXCEPTION;
30994: CURSOR am_attr_cols_cur
30995: IS
30996: SELECT /*+ dynamic_sampling(1) */ line_index, attribute_type, context, attribute,
30997: pricing_status_code, qp_number.canonical_to_number(value_from)
30998: FROM qp_npreq_line_attrs_tmp lattr
30999: WHERE attribute_type IN ('PRICING', 'PRODUCT')
31000: AND pricing_status_code = G_STATUS_UNCHANGED
31001: AND EXISTS (SELECT format_type

Line 31017: pricing_status_code, qp_number.canonical_to_number(value_from)

31013:
31014: CURSOR am_attr_qual_cols_cur
31015: IS
31016: SELECT line_index, attribute_type, context, attribute,
31017: pricing_status_code, qp_number.canonical_to_number(value_from)
31018: FROM qp_npreq_line_attrs_tmp lattr
31019: WHERE attribute_type IN ('PRICING', 'PRODUCT', 'QUALIFIER')
31020: AND pricing_status_code = G_STATUS_UNCHANGED
31021: AND EXISTS (SELECT format_type

Line 31052: pricing_status_code, qp_number.canonical_to_number(value_from)

31048:
31049: CURSOR attr_cols_cur
31050: IS
31051: SELECT line_index, attribute_type, context, attribute,
31052: pricing_status_code, qp_number.canonical_to_number(value_from)
31053: FROM qp_npreq_line_attrs_tmp lattr
31054: WHERE attribute_type IN ('PRICING', 'PRODUCT')
31055: AND pricing_status_code = G_STATUS_UNCHANGED
31056: AND EXISTS (SELECT format_type

Line 31110: qp_number.canonical_mask :=

31106:
31107: EXIT WHEN l_line_index_tbl.COUNT = 0;
31108:
31109: --Change flexible mask to mask below for formula pattern use.
31110: qp_number.canonical_mask :=
31111: '00999999999999999999999.99999999999999999999999999999999999999';
31112: FORALL i IN l_line_index_tbl.FIRST..l_line_index_tbl.LAST
31113: INSERT INTO qp_preq_line_attrs_formula_tmp
31114: ( line_index,

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

31123: l_attribute_type_tbl(i),
31124: l_context_tbl(i),
31125: l_attribute_tbl(i),
31126: l_pricing_status_code_tbl(i),
31127: qp_number.number_to_canonical(l_value_from_tbl(i))
31128: );
31129:
31130: --Change mask back to flexible mask.
31131: qp_number.canonical_mask :=

Line 31131: qp_number.canonical_mask :=

31127: qp_number.number_to_canonical(l_value_from_tbl(i))
31128: );
31129:
31130: --Change mask back to flexible mask.
31131: qp_number.canonical_mask :=
31132: 'FM999999999999999999999.9999999999999999999999999999999999999999';
31133:
31134: END LOOP; --Loop for bulk fetch
31135:

Line 31154: qp_number.canonical_mask :=

31150: l_value_from_tbl LIMIT l_rows;
31151:
31152: EXIT WHEN l_line_index_tbl.COUNT = 0;
31153: --Change flexible mask to mask below for formula pattern use.
31154: qp_number.canonical_mask :=
31155: '00999999999999999999999.99999999999999999999999999999999999999';
31156: FORALL i IN l_line_index_tbl.FIRST..l_line_index_tbl.LAST
31157: INSERT INTO qp_preq_line_attrs_formula_tmp
31158: ( line_index,

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

31167: l_attribute_type_tbl(i),
31168: l_context_tbl(i),
31169: l_attribute_tbl(i),
31170: l_pricing_status_code_tbl(i),
31171: qp_number.number_to_canonical(l_value_from_tbl(i))
31172: );
31173: qp_number.canonical_mask :=
31174: 'FM999999999999999999999.9999999999999999999999999999999999999999';
31175:

Line 31173: qp_number.canonical_mask :=

31169: l_attribute_tbl(i),
31170: l_pricing_status_code_tbl(i),
31171: qp_number.number_to_canonical(l_value_from_tbl(i))
31172: );
31173: qp_number.canonical_mask :=
31174: 'FM999999999999999999999.9999999999999999999999999999999999999999';
31175:
31176: END LOOP; --Loop for bulk fetch
31177: CLOSE am_attr_qual_cols_cur;

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

31182: FOR l_rec IN am_attr_qual_msg_cur
31183: LOOP
31184: l_msg_context := l_rec.context;
31185: l_msg_attribute := l_rec.attribute;
31186: l_value_from := qp_number.canonical_to_number(l_rec.value_from);
31187: END LOOP;
31188: EXCEPTION
31189: WHEN OTHERS THEN
31190: fnd_message.set_token('CONTEXT',l_msg_context);

Line 31200: qp_number.canonical_mask :=

31196:
31197: End If;
31198:
31199: --Change flexible mask to mask below for formula pattern use.
31200: qp_number.canonical_mask :=
31201: '00999999999999999999999.99999999999999999999999999999999999999';
31202:
31203: -- Bug 2772214 l_pass_qualifiers condition in where clause
31204: --Insert request line attrs with datatype 'X', 'Y', 'C' or null

Line 31239: qp_number.canonical_mask :=

31235: AND segments.prc_context_id = pcontexts.prc_context_id
31236: AND vset.format_type = 'N'); --by yangli 03/06/2002 9:30am
31237:
31238: --Change mask back to flexible mask.
31239: qp_number.canonical_mask :=
31240: 'FM999999999999999999999.9999999999999999999999999999999999999999';
31241:
31242: ELSE --If AM not installed
31243:

Line 31261: qp_number.canonical_mask :=

31257:
31258: EXIT WHEN l_line_index_tbl.COUNT = 0;
31259:
31260: --Change flexible mask to mask below for formula pattern use.
31261: qp_number.canonical_mask :=
31262: '00999999999999999999999.99999999999999999999999999999999999999';
31263:
31264: FORALL i IN l_line_index_tbl.FIRST..l_line_index_tbl.LAST
31265: INSERT INTO qp_preq_line_attrs_formula_tmp

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

31275: l_attribute_type_tbl(i),
31276: l_context_tbl(i),
31277: l_attribute_tbl(i),
31278: l_pricing_status_code_tbl(i),
31279: qp_number.number_to_canonical(l_value_from_tbl(i))
31280: );
31281:
31282: --Change mask back to flexible mask.
31283: qp_number.canonical_mask :=

Line 31283: qp_number.canonical_mask :=

31279: qp_number.number_to_canonical(l_value_from_tbl(i))
31280: );
31281:
31282: --Change mask back to flexible mask.
31283: qp_number.canonical_mask :=
31284: 'FM999999999999999999999.9999999999999999999999999999999999999999';
31285:
31286: END LOOP; --Loop for bulk fetch
31287:

Line 31291: qp_number.canonical_mask :=

31287:
31288: CLOSE attr_cols_cur;
31289:
31290: --Change flexible mask to mask below for formula pattern use.
31291: qp_number.canonical_mask :=
31292: '00999999999999999999999.99999999999999999999999999999999999999';
31293:
31294: --Insert request line attrs with datatype 'X', 'Y', 'C' or null
31295: INSERT INTO qp_preq_line_attrs_formula_tmp

Line 31325: qp_number.canonical_mask :=

31321: AND dflex.application_column_name = lattr.attribute
31322: AND vset.format_type = 'N');
31323:
31324: --Change mask back to flexible mask.
31325: qp_number.canonical_mask :=
31326: 'FM999999999999999999999.9999999999999999999999999999999999999999';
31327:
31328: END IF; -- if G_AM_INSTALLED_PROFILE is true
31329:

Line 31355: qp_number.canonical_mask :=

31351: IF (i.group_quantity IS NOT NULL and l_attr_inserted_flag = FALSE) THEN
31352:
31353:
31354: --Change flexible mask to mask below for formula pattern use.
31355: qp_number.canonical_mask :=
31356: '00999999999999999999999.99999999999999999999999999999999999999';
31357: INSERT INTO qp_preq_line_attrs_formula_tmp
31358: ( line_index,
31359: attribute_type,

Line 31371: qp_number.number_to_canonical(i.group_quantity)

31367: G_PRICING_TYPE,
31368: 'VOLUME',
31369: 'PRICING_ATTRIBUTE4',
31370: G_STATUS_UNCHANGED,
31371: qp_number.number_to_canonical(i.group_quantity)
31372: );
31373:
31374: --Change mask back to flexible mask.
31375: qp_number.canonical_mask :=

Line 31375: qp_number.canonical_mask :=

31371: qp_number.number_to_canonical(i.group_quantity)
31372: );
31373:
31374: --Change mask back to flexible mask.
31375: qp_number.canonical_mask :=
31376: 'FM999999999999999999999.9999999999999999999999999999999999999999';
31377:
31378: l_attr_inserted_flag := TRUE;
31379:

Line 31385: qp_number.canonical_mask :=

31381:
31382: IF (i.group_amount IS NOT NULL and l_attr_inserted_flag = FALSE) THEN
31383:
31384: --Change flexible mask to mask below for formula pattern use.
31385: qp_number.canonical_mask :=
31386: '00999999999999999999999.99999999999999999999999999999999999999';
31387: INSERT INTO qp_preq_line_attrs_formula_tmp
31388: ( line_index,
31389: attribute_type,

Line 31401: qp_number.number_to_canonical(i.group_amount)

31397: G_PRICING_TYPE,
31398: 'VOLUME',
31399: 'PRICING_ATTRIBUTE5',
31400: G_STATUS_UNCHANGED,
31401: qp_number.number_to_canonical(i.group_amount)
31402: );
31403:
31404: --Change mask back to flexible mask.
31405: qp_number.canonical_mask :=

Line 31405: qp_number.canonical_mask :=

31401: qp_number.number_to_canonical(i.group_amount)
31402: );
31403:
31404: --Change mask back to flexible mask.
31405: qp_number.canonical_mask :=
31406: 'FM999999999999999999999.9999999999999999999999999999999999999999';
31407:
31408: l_attr_inserted_flag := TRUE;
31409:

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

32707: --If user populates the temp tables directly
32708: --the public API will populate the currency_code etc in
32709: --public variables
32710: --********************************************************************
32711: -- qp_number.canonical_mask := 'FM999999999999999999999.99999999999999999999999999999999999999'; --3085147
32712: qp_number.canonical_mask := 'FM999999999999999999999.9999999999999999999999999999999999999999'; --3169430
32713:
32714: --=======START: Pre-pricing processing needed by JAVA and PL/SQL engine======
32715: IF G_TEMP_TABLE_INSERT_FLAG = G_YES THEN

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

32708: --the public API will populate the currency_code etc in
32709: --public variables
32710: --********************************************************************
32711: -- qp_number.canonical_mask := 'FM999999999999999999999.99999999999999999999999999999999999999'; --3085147
32712: qp_number.canonical_mask := 'FM999999999999999999999.9999999999999999999999999999999999999999'; --3169430
32713:
32714: --=======START: Pre-pricing processing needed by JAVA and PL/SQL engine======
32715: IF G_TEMP_TABLE_INSERT_FLAG = G_YES THEN
32716:

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

32718: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
32719: RAISE E_ROUTINE_ERRORS;
32720: END IF; */
32721:
32722: -- qp_number.canonical_mask := 'FM999999999999999999999.99999999999999999999999999999999999999';
32723:
32724:
32725: l_bypass_pricing := FND_PROFILE.VALUE(G_BYPASS_PRICING);
32726:

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

33004:
33005: IF G_AM_INSTALLED_PROFILE = G_YES THEN
33006: BEGIN
33007: UPDATE /*+ dynamic_sampling(1) */ qp_npreq_line_attrs_tmp lattr
33008: SET value_from = qp_number.number_to_canonical(qp_number.canonical_to_number(lattr.value_from)),
33009: value_to = qp_number.number_to_canonical(qp_number.canonical_to_number(lattr.value_to))
33010: WHERE attribute_type = G_PRICING_TYPE
33011: AND pricing_status_code = G_STATUS_UNCHANGED
33012: AND exists (

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

33005: IF G_AM_INSTALLED_PROFILE = G_YES THEN
33006: BEGIN
33007: UPDATE /*+ dynamic_sampling(1) */ qp_npreq_line_attrs_tmp lattr
33008: SET value_from = qp_number.number_to_canonical(qp_number.canonical_to_number(lattr.value_from)),
33009: value_to = qp_number.number_to_canonical(qp_number.canonical_to_number(lattr.value_to))
33010: WHERE attribute_type = G_PRICING_TYPE
33011: AND pricing_status_code = G_STATUS_UNCHANGED
33012: AND exists (
33013: SELECT format_type

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

33029: FOR l_rec IN am_attr_msg_cur
33030: LOOP
33031: l_msg_context := l_rec.context;
33032: l_msg_attribute := l_rec.attribute;
33033: l_msg_value_from := qp_number.number_to_canonical(l_rec.value_from);
33034: l_msg_value_to := qp_number.number_to_canonical(l_rec.value_to);
33035: END LOOP;
33036:
33037: EXCEPTION

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

33030: LOOP
33031: l_msg_context := l_rec.context;
33032: l_msg_attribute := l_rec.attribute;
33033: l_msg_value_from := qp_number.number_to_canonical(l_rec.value_from);
33034: l_msg_value_to := qp_number.number_to_canonical(l_rec.value_to);
33035: END LOOP;
33036:
33037: EXCEPTION
33038: WHEN OTHERS THEN

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

33048: ELSE
33049:
33050: BEGIN
33051: UPDATE qp_npreq_line_attrs_tmp lattr
33052: SET value_from = qp_number.number_to_canonical(qp_number.canonical_to_number(lattr.value_from)),
33053: value_to = qp_number.number_to_canonical(qp_number.canonical_to_number(lattr.value_to))
33054: WHERE attribute_type = G_PRICING_TYPE
33055: AND pricing_status_code = G_STATUS_UNCHANGED
33056: AND exists (

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

33049:
33050: BEGIN
33051: UPDATE qp_npreq_line_attrs_tmp lattr
33052: SET value_from = qp_number.number_to_canonical(qp_number.canonical_to_number(lattr.value_from)),
33053: value_to = qp_number.number_to_canonical(qp_number.canonical_to_number(lattr.value_to))
33054: WHERE attribute_type = G_PRICING_TYPE
33055: AND pricing_status_code = G_STATUS_UNCHANGED
33056: AND exists (
33057: SELECT format_type

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

33072: FOR l_rec IN attr_msg_cur
33073: LOOP
33074: l_msg_context := l_rec.context;
33075: l_msg_attribute := l_rec.attribute;
33076: l_msg_value_from := qp_number.number_to_canonical(l_rec.value_from);
33077: l_msg_value_to := qp_number.number_to_canonical(l_rec.value_to);
33078: END LOOP;
33079: EXCEPTION
33080: WHEN OTHERS THEN

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

33073: LOOP
33074: l_msg_context := l_rec.context;
33075: l_msg_attribute := l_rec.attribute;
33076: l_msg_value_from := qp_number.number_to_canonical(l_rec.value_from);
33077: l_msg_value_to := qp_number.number_to_canonical(l_rec.value_to);
33078: END LOOP;
33079: EXCEPTION
33080: WHEN OTHERS THEN
33081: l_status_text := 'Exception in QP_PREQ_GRP.PRICE_REQUEST ';

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

33430:
33431: --[julin/pricebook] added hint
33432: UPDATE qp_npreq_lines_tmp a
33433: SET (price_list_header_id,validated_flag) =
33434: (SELECT /*+ index(b QP_PREQ_LINE_ATTRS_TMP_N2) */ distinct qp_number.canonical_to_number(value_from),validated_flag
33435: FROM qp_npreq_line_attrs_tmp b
33436: WHERE a.line_index = b.line_index
33437: AND context = G_LIST_HEADER_CONTEXT
33438: AND attribute = G_PRICELIST_ATTRIBUTE

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

33781: IF (l_header_limit_exists = G_YES or l_line_limit_exists = G_YES) THEN
33782: -- Bug 3143535
33783: -- get the order amount from attributes. if not found then sum it from order lines
33784: begin
33785: select qp_number.canonical_to_number(value_from) -- 5515203
33786: into v_order_amount
33787: from qp_npreq_line_attrs_tmp
33788: where CONTEXT = G_PRIC_VOLUME_CONTEXT
33789: AND ATTRIBUTE = G_ORDER_AMOUNT_ATTRIBUTE