[Home] [Help]
1: PACKAGE BODY PO_SOURCING2_SV AS
2: /* $Header: POXSCS2B.pls 120.10.12020000.3 2013/03/22 08:25:43 mitao ship $ */
3:
4: /*============================= PO_SOURCING2_SV ===========================*/
5:
1: PACKAGE BODY PO_SOURCING2_SV AS
2: /* $Header: POXSCS2B.pls 120.10.12020000.3 2013/03/22 08:25:43 mitao ship $ */
3:
4: /*============================= PO_SOURCING2_SV ===========================*/
5:
6: /**==========================================================================
7: *
8: * FUNCTION NAME: get_break_price()
12: * Modified By Date Descriptions
13: * Dreddy Overloaded the price break API
14: *===========================================================================*/
15:
16: G_PKG_NAME CONSTANT VARCHAR2(30) := 'PO_SOURCING2_SV';
17: g_log_head CONSTANT VARCHAR2(50) := 'po.plsql.' || G_PKG_NAME || '.';
18:
19: -- Read the profile option that enables/disables the debug log
20: g_fnd_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'), 'N');
558: /* Call get_release_quantity to a) determine how to select
559: ** the correct break price and b) the quantity released against
560: ** the corresponding shipment/organization combination.
561: */
562: release_to_date := PO_SOURCING2_SV.get_release_quantity(p_ship_to_org,
563: p_ship_to_loc,
564: p_po_line_id,
565: match_type);
566:
1430: l_progress := '002';
1431:
1432: --
1433: --
1434: PO_SOURCING2_SV.get_break_price
1435: (p_api_version => 1.0
1436: , p_order_quantity => p_quantity
1437: , p_ship_to_org => l_ship_to_organization_id
1438: , p_ship_to_loc => l_ship_to_location_id
1469: po_message_s.sql_error('get_shipment_price', l_progress, SQLCODE);
1470: RAISE;
1471: END get_shipment_price;
1472:
1473: END PO_SOURCING2_SV;