APPS.OE_BULK_PRICEORDER_PVT dependencies on OE_BULK_PRICEORDER_PVT

Line 1: PACKAGE BODY OE_BULK_PRICEORDER_PVT AS

1: PACKAGE BODY OE_BULK_PRICEORDER_PVT AS
2: /* $Header: OEBVOPRB.pls 120.3.12010000.3 2008/11/18 13:14:23 smusanna ship $ */
3:
4:
5:

Line 6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_BULK_PRICEORDER_PVT';

2: /* $Header: OEBVOPRB.pls 120.3.12010000.3 2008/11/18 13:14:23 smusanna ship $ */
3:
4:
5:
6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_BULK_PRICEORDER_PVT';
7: G_CHARGES_FOR_INCLUDED_ITEM Varchar2(30)
8: := nvl(fnd_profile.value('ONT_CHARGES_FOR_INCLUDED_ITEM'),'N');
9: G_FUNCTION_CURRENCY VARCHAR2(30) default NULL;
10: G_PRICE_FLAG_TBL_EXTENDED BOOLEAN default null;

Line 170: oe_debug_pub.add( 'INSIDE OE_BULK_PRICEORDER_PVT.INSERT_ADJ' ) ;

166: cursor test is
167: select pricing_status_code,LINE_DETAIL_INDEX,LINE_INDEX from QP_PREQ_LINE_ATTRS_TMP;
168: BEGIN
169: IF l_debug_level > 0 THEN
170: oe_debug_pub.add( 'INSIDE OE_BULK_PRICEORDER_PVT.INSERT_ADJ' ) ;
171: END IF;
172: --bug 3544829
173: -- added the condition for manual adjustments in the where clause
174: INSERT INTO OE_PRICE_ADJUSTMENTS

Line 664: oe_debug_pub.add('Entering OE_BULK_PRICEORDER_PVT.credit_check');

660: Begin
661: l_return_status:= FND_API.G_RET_STS_SUCCESS;
662:
663: If l_debug_level > 0 Then
664: oe_debug_pub.add('Entering OE_BULK_PRICEORDER_PVT.credit_check');
665: End If;
666:
667: For i IN 1..p_header_rec.header_id.count Loop
668:

Line 712: oe_debug_pub.add('Leaving OE_BULK_PRICEORDER_PVT.credit_checking');

708: End If;
709: End Loop;
710:
711: If l_debug_level > 0 Then
712: oe_debug_pub.add('Leaving OE_BULK_PRICEORDER_PVT.credit_checking');
713: End If;
714: End;
715:
716:

Line 1602: End OE_BULK_PRICEORDER_PVT;

1598: ,'Price_Orders');
1599: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1600: END Price_Orders;
1601:
1602: End OE_BULK_PRICEORDER_PVT;