DBA Data[Home] [Help]

APPS.QP_SOURCING_API_PUB dependencies on QP_NUMBER

Line 509: G_Order_Info.order_amount := QP_NUMBER.NUMBER_TO_CANONICAL(NVL(orders_total_amt,0)-NVL(returns_total_amt,0));

505: End;
506:
507: End If; --HVOP_Pricing_On
508: G_Order_Info.header_id := p_header_id;
509: G_Order_Info.order_amount := QP_NUMBER.NUMBER_TO_CANONICAL(NVL(orders_total_amt,0)-NVL(returns_total_amt,0));
510: G_Order_Info.order_quantity := QP_NUMBER.NUMBER_TO_CANONICAL(NVL(orders_total_qty,0)-NVL(returns_total_qty,0));
511:
512: end if; --new pricing call
513: END;

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

506:
507: End If; --HVOP_Pricing_On
508: G_Order_Info.header_id := p_header_id;
509: G_Order_Info.order_amount := QP_NUMBER.NUMBER_TO_CANONICAL(NVL(orders_total_amt,0)-NVL(returns_total_amt,0));
510: G_Order_Info.order_quantity := QP_NUMBER.NUMBER_TO_CANONICAL(NVL(orders_total_qty,0)-NVL(returns_total_qty,0));
511:
512: end if; --new pricing call
513: END;
514:

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

651: return 0;
652: end if;
653: END;
654:
655: x_Conv_quantity := QP_NUMBER.NUMBER_TO_CANONICAL(inv_convert.inv_um_convert(p_inventory_item_id,
656: l_inv_precision,
657: x_item_quantity,
658: l_puom,
659: p_ordered_uom,

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

706: end if;
707:
708: END;
709:
710: x_Conv_quantity := QP_NUMBER.NUMBER_TO_CANONICAL(inv_convert.inv_um_convert(p_inventory_item_id,
711: l_inv_precision,
712: x_item_quantity,
713: l_puom,
714: p_ordered_uom,

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

760: end if;
761:
762: END;
763:
764: x_Conv_quantity := QP_NUMBER.NUMBER_TO_CANONICAL(inv_convert.inv_um_convert(p_inventory_item_id,
765: l_inv_precision,
766: x_item_quantity,
767: l_puom,
768: p_ordered_uom,

Line 853: RETURN QP_NUMBER.NUMBER_TO_CANONICAL(x_amount);

849: oe_order_pub.g_hdr.conversion_type_code,
850: x_amount);
851: */
852:
853: RETURN QP_NUMBER.NUMBER_TO_CANONICAL(x_amount);
854:
855: END Get_Period1_Item_Amount;
856:
857: FUNCTION Get_Period1_Item_Amount(p_cust_id IN NUMBER, p_inventory_item_id IN NUMBER) RETURN VARCHAR2

Line 938: RETURN QP_NUMBER.NUMBER_TO_CANONICAL(x_amount);

934: oe_order_pub.g_hdr.conversion_type_code,
935: x_amount);
936:
937: */
938: RETURN QP_NUMBER.NUMBER_TO_CANONICAL(x_amount);
939:
940: END Get_Period2_Item_Amount;
941:
942: FUNCTION Get_Period2_Item_Amount(p_cust_id IN NUMBER, p_inventory_item_id IN NUMBER) RETURN VARCHAR2

Line 1030: RETURN QP_NUMBER.NUMBER_TO_CANONICAL(x_amount);

1026: );
1027: End If;
1028: */
1029:
1030: RETURN QP_NUMBER.NUMBER_TO_CANONICAL(x_amount);
1031:
1032: END Get_Period3_Item_Amount;
1033:
1034: FUNCTION Get_Period3_Item_Amount(p_cust_id IN NUMBER, p_inventory_item_id IN NUMBER) RETURN VARCHAR2

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

1112: x_total_amount) ;
1113: --+ G_Order_Info.order_amount;
1114: */
1115:
1116: g_order_info.period1_total_amount := qp_number.number_to_canonical(x_total_amount);
1117: end if;
1118:
1119: return g_order_info.period1_total_amount;
1120:

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

1195: x_total_amount) ;
1196: --+ G_Order_Info.order_amount;
1197: */
1198:
1199: g_order_info.period2_total_amount := qp_number.number_to_canonical(x_total_amount);
1200: end if;
1201:
1202: return g_order_info.period2_total_amount;
1203:

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

1278: --+ G_Order_Info.order_amount;
1279:
1280: */
1281:
1282: g_order_info.period3_total_amount := qp_number.number_to_canonical(x_total_amount);
1283: end if;
1284:
1285: return g_order_info.period3_total_amount;
1286:

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

1410:
1411: INV_CONVERT.INV_UM_CONVERSION(p_order_quantity_uom, l_uom_code, p_inventory_item_id, l_uom_rate);
1412:
1413: IF l_uom_rate > 0 THEN
1414: RETURN QP_NUMBER.NUMBER_TO_CANONICAL(TRUNC(l_uom_rate * p_ordered_quantity, 2));
1415: ELSE
1416: IF l_debug = FND_API.G_TRUE THEN
1417: oe_debug_pub.add('No conversion information is available for converting from ' || p_order_quantity_uom || ' TO ' || l_uom_code);
1418: END IF;

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

1480: INV_CONVERT.INV_UM_CONVERSION(l_ordered_quantity_uom, l_uom_code, l_inventory_item_id, l_uom_rate);
1481:
1482: IF l_uom_rate > 0 THEN
1483: l_order_total := l_order_total +
1484: QP_NUMBER.NUMBER_TO_CANONICAL(TRUNC(l_uom_rate * l_ordered_quantity, 2));
1485: ELSE
1486: IF l_debug = FND_API.G_TRUE THEN
1487: oe_debug_pub.add('No conversion information is available for converting from ' || l_ordered_quantity_uom || 'TO ' || l_uom_code);
1488: END IF;

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

1522:
1523: g_order_info.order_total := l_order_total;
1524: end if; --g_new_pricing_call
1525:
1526: return QP_NUMBER.NUMBER_TO_CANONICAL(g_order_info.order_total); -- bug 3191779
1527:
1528: END Get_Order_Weight_Or_Volume;
1529:
1530: FUNCTION Get_Shippable_Flag(p_header_id IN NUMBER) RETURN VARCHAR2

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

1584: IS
1585:
1586: BEGIN
1587:
1588: RETURN QP_NUMBER.NUMBER_TO_CANONICAL(NVL(p_pricing_qty,p_ordered_qty));
1589:
1590: END Get_Item_Quantity;
1591:
1592: FUNCTION Get_Item_Amount

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

1599: x_return NUMBER;
1600:
1601: BEGIN
1602:
1603: 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));
1604:
1605: 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
1606: x_return := 0;
1607: END IF;

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

1757: x_return NUMBER;
1758:
1759: BEGIN
1760:
1761: 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));
1762:
1763: IF (p_UNIT_LIST_PRICE_PER_PQTY IS NULL) AND (p_UNIT_LIST_PRICE is NULL) THEN
1764: x_return := 0;
1765: END IF;