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

Line 501: G_Order_Info.order_amount := ABS(QP_NUMBER.NUMBER_TO_CANONICAL(NVL(orders_total_amt,0)-NVL(returns_total_amt,0))); --bug#13655307

497: End;
498:
499: End If; --HVOP_Pricing_On
500: G_Order_Info.header_id := p_header_id;
501: G_Order_Info.order_amount := ABS(QP_NUMBER.NUMBER_TO_CANONICAL(NVL(orders_total_amt,0)-NVL(returns_total_amt,0))); --bug#13655307
502: G_Order_Info.order_quantity := QP_NUMBER.NUMBER_TO_CANONICAL(NVL(orders_total_qty,0)-NVL(returns_total_qty,0));
503:
504: end if; --new pricing call
505: END;

Line 502: G_Order_Info.order_quantity := QP_NUMBER.NUMBER_TO_CANONICAL(NVL(orders_total_qty,0)-NVL(returns_total_qty,0));

498:
499: End If; --HVOP_Pricing_On
500: G_Order_Info.header_id := p_header_id;
501: G_Order_Info.order_amount := ABS(QP_NUMBER.NUMBER_TO_CANONICAL(NVL(orders_total_amt,0)-NVL(returns_total_amt,0))); --bug#13655307
502: G_Order_Info.order_quantity := QP_NUMBER.NUMBER_TO_CANONICAL(NVL(orders_total_qty,0)-NVL(returns_total_qty,0));
503:
504: end if; --new pricing call
505: END;
506:

Line 647: x_Conv_quantity := QP_NUMBER.NUMBER_TO_CANONICAL(inv_convert.inv_um_convert(p_inventory_item_id,

643: return 0;
644: end if;
645: END;
646:
647: x_Conv_quantity := QP_NUMBER.NUMBER_TO_CANONICAL(inv_convert.inv_um_convert(p_inventory_item_id,
648: l_inv_precision,
649: x_item_quantity,
650: l_puom,
651: p_ordered_uom,

Line 702: x_Conv_quantity := QP_NUMBER.NUMBER_TO_CANONICAL(inv_convert.inv_um_convert(p_inventory_item_id,

698: end if;
699:
700: END;
701:
702: x_Conv_quantity := QP_NUMBER.NUMBER_TO_CANONICAL(inv_convert.inv_um_convert(p_inventory_item_id,
703: l_inv_precision,
704: x_item_quantity,
705: l_puom,
706: p_ordered_uom,

Line 756: x_Conv_quantity := QP_NUMBER.NUMBER_TO_CANONICAL(inv_convert.inv_um_convert(p_inventory_item_id,

752: end if;
753:
754: END;
755:
756: x_Conv_quantity := QP_NUMBER.NUMBER_TO_CANONICAL(inv_convert.inv_um_convert(p_inventory_item_id,
757: l_inv_precision,
758: x_item_quantity,
759: l_puom,
760: p_ordered_uom,

Line 845: RETURN QP_NUMBER.NUMBER_TO_CANONICAL(x_amount);

841: oe_order_pub.g_hdr.conversion_type_code,
842: x_amount);
843: */
844:
845: RETURN QP_NUMBER.NUMBER_TO_CANONICAL(x_amount);
846:
847: END Get_Period1_Item_Amount;
848:
849: FUNCTION Get_Period1_Item_Amount(p_cust_id IN NUMBER, p_inventory_item_id IN NUMBER) RETURN VARCHAR2

Line 930: RETURN QP_NUMBER.NUMBER_TO_CANONICAL(x_amount);

926: oe_order_pub.g_hdr.conversion_type_code,
927: x_amount);
928:
929: */
930: RETURN QP_NUMBER.NUMBER_TO_CANONICAL(x_amount);
931:
932: END Get_Period2_Item_Amount;
933:
934: FUNCTION Get_Period2_Item_Amount(p_cust_id IN NUMBER, p_inventory_item_id IN NUMBER) RETURN VARCHAR2

Line 1022: RETURN QP_NUMBER.NUMBER_TO_CANONICAL(x_amount);

1018: );
1019: End If;
1020: */
1021:
1022: RETURN QP_NUMBER.NUMBER_TO_CANONICAL(x_amount);
1023:
1024: END Get_Period3_Item_Amount;
1025:
1026: FUNCTION Get_Period3_Item_Amount(p_cust_id IN NUMBER, p_inventory_item_id IN NUMBER) RETURN VARCHAR2

Line 1108: g_order_info.period1_total_amount := qp_number.number_to_canonical(x_total_amount);

1104: x_total_amount) ;
1105: --+ G_Order_Info.order_amount;
1106: */
1107:
1108: g_order_info.period1_total_amount := qp_number.number_to_canonical(x_total_amount);
1109: end if;
1110:
1111: return g_order_info.period1_total_amount;
1112:

Line 1191: g_order_info.period2_total_amount := qp_number.number_to_canonical(x_total_amount);

1187: x_total_amount) ;
1188: --+ G_Order_Info.order_amount;
1189: */
1190:
1191: g_order_info.period2_total_amount := qp_number.number_to_canonical(x_total_amount);
1192: end if;
1193:
1194: return g_order_info.period2_total_amount;
1195:

Line 1274: g_order_info.period3_total_amount := qp_number.number_to_canonical(x_total_amount);

1270: --+ G_Order_Info.order_amount;
1271:
1272: */
1273:
1274: g_order_info.period3_total_amount := qp_number.number_to_canonical(x_total_amount);
1275: end if;
1276:
1277: return g_order_info.period3_total_amount;
1278:

Line 1406: RETURN QP_NUMBER.NUMBER_TO_CANONICAL(TRUNC(l_uom_rate * p_ordered_quantity, 2));

1402:
1403: INV_CONVERT.INV_UM_CONVERSION(p_order_quantity_uom, l_uom_code, p_inventory_item_id, l_uom_rate);
1404:
1405: IF l_uom_rate > 0 THEN
1406: RETURN QP_NUMBER.NUMBER_TO_CANONICAL(TRUNC(l_uom_rate * p_ordered_quantity, 2));
1407: ELSE
1408: IF l_debug = FND_API.G_TRUE THEN
1409: oe_debug_pub.add('No conversion information is available for converting from ' || p_order_quantity_uom || ' TO ' || l_uom_code);
1410: END IF;

Line 1476: QP_NUMBER.NUMBER_TO_CANONICAL(TRUNC(l_uom_rate * l_ordered_quantity, 2));

1472: INV_CONVERT.INV_UM_CONVERSION(l_ordered_quantity_uom, l_uom_code, l_inventory_item_id, l_uom_rate);
1473:
1474: IF l_uom_rate > 0 THEN
1475: l_order_total := l_order_total +
1476: QP_NUMBER.NUMBER_TO_CANONICAL(TRUNC(l_uom_rate * l_ordered_quantity, 2));
1477: ELSE
1478: IF l_debug = FND_API.G_TRUE THEN
1479: oe_debug_pub.add('No conversion information is available for converting from ' || l_ordered_quantity_uom || 'TO ' || l_uom_code);
1480: END IF;

Line 1518: return QP_NUMBER.NUMBER_TO_CANONICAL(g_order_info.order_total); -- bug 3191779

1514:
1515: g_order_info.order_total := l_order_total;
1516: end if; --g_new_pricing_call
1517:
1518: return QP_NUMBER.NUMBER_TO_CANONICAL(g_order_info.order_total); -- bug 3191779
1519:
1520: END Get_Order_Weight_Or_Volume;
1521:
1522: FUNCTION Get_Shippable_Flag(p_header_id IN NUMBER) RETURN VARCHAR2

Line 1580: RETURN QP_NUMBER.NUMBER_TO_CANONICAL(NVL(p_pricing_qty,p_ordered_qty));

1576: IS
1577:
1578: BEGIN
1579:
1580: RETURN QP_NUMBER.NUMBER_TO_CANONICAL(NVL(p_pricing_qty,p_ordered_qty));
1581:
1582: END Get_Item_Quantity;
1583:
1584: FUNCTION Get_Item_Amount

Line 1595: x_return := QP_NUMBER.NUMBER_TO_CANONICAL(NVL(p_pricing_qty,p_ordered_qty) * NVL(OE_ORDER_PUB.G_LINE.UNIT_LIST_PRICE_PER_PQTY, OE_ORDER_PUB.G_LINE.UNIT_LIST_PRICE));

1591: x_return NUMBER;
1592:
1593: BEGIN
1594:
1595: x_return := QP_NUMBER.NUMBER_TO_CANONICAL(NVL(p_pricing_qty,p_ordered_qty) * NVL(OE_ORDER_PUB.G_LINE.UNIT_LIST_PRICE_PER_PQTY, OE_ORDER_PUB.G_LINE.UNIT_LIST_PRICE));
1596:
1597: IF (OE_ORDER_PUB.G_LINE.UNIT_LIST_PRICE_PER_PQTY IS NULL) AND (OE_ORDER_PUB.G_LINE.UNIT_LIST_PRICE is NULL) THEN
1598: x_return := 0;
1599: END IF;

Line 1753: x_return := QP_NUMBER.NUMBER_TO_CANONICAL(NVL(p_pricing_qty,p_ordered_qty) * NVL(p_UNIT_LIST_PRICE_PER_PQTY, p_UNIT_LIST_PRICE));

1749: x_return NUMBER;
1750:
1751: BEGIN
1752:
1753: x_return := QP_NUMBER.NUMBER_TO_CANONICAL(NVL(p_pricing_qty,p_ordered_qty) * NVL(p_UNIT_LIST_PRICE_PER_PQTY, p_UNIT_LIST_PRICE));
1754:
1755: IF (p_UNIT_LIST_PRICE_PER_PQTY IS NULL) AND (p_UNIT_LIST_PRICE is NULL) THEN
1756: x_return := 0;
1757: END IF;