APPS.OE_BULK_PRICE_PVT dependencies on OE_BULK_PRICE_PVT

Line 1: PACKAGE BODY OE_BULK_PRICE_PVT AS

1: PACKAGE BODY OE_BULK_PRICE_PVT AS
2: /* $Header: OEBVPRCB.pls 120.2.12010000.5 2009/01/08 15:45:40 smanian ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):='OE_BULK_PRICE_PVT';
5:

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30):='OE_BULK_PRICE_PVT';

1: PACKAGE BODY OE_BULK_PRICE_PVT AS
2: /* $Header: OEBVPRCB.pls 120.2.12010000.5 2009/01/08 15:45:40 smanian ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):='OE_BULK_PRICE_PVT';
5:
6: PROCEDURE mark_header_error(p_header_index IN NUMBER,
7: p_header_rec IN OUT NOCOPY OE_BULK_ORDER_PVT.HEADER_REC_TYPE);
8:

Line 591: OE_BULK_PRICE_PVT.G_Booking_Failed := FALSE;

587: QP_PREQ_GRP.G_SEARCH_N_CALCULATE;
588: l_Price_Control_Rec.Simulation_Flag := 'N';
589:
590: --added for HVOP Tax project
591: OE_BULK_PRICE_PVT.G_Booking_Failed := FALSE;
592: OE_BULK_PRICE_PVT.G_Header_Index := I;
593:
594: OE_Order_Adj_Pvt.Price_Line
595: (x_return_status => x_return_status

Line 592: OE_BULK_PRICE_PVT.G_Header_Index := I;

588: l_Price_Control_Rec.Simulation_Flag := 'N';
589:
590: --added for HVOP Tax project
591: OE_BULK_PRICE_PVT.G_Booking_Failed := FALSE;
592: OE_BULK_PRICE_PVT.G_Header_Index := I;
593:
594: OE_Order_Adj_Pvt.Price_Line
595: (x_return_status => x_return_status
596: ,p_Header_id => l_header_id

Line 620: IF OE_BULK_PRICE_PVT.G_BOOKING_FAILED THEN

616: END IF; -- IF OE_BULK_ORDER_PVT.G_PRICING_NEEDED =
617:
618: IF p_header_rec.booked_flag(i) = 'Y' THEN
619:
620: IF OE_BULK_PRICE_PVT.G_BOOKING_FAILED THEN
621: l_book_failed := 'Y';
622: ELSE
623: l_book_failed := 'N';
624: END IF;

Line 824: IF OE_BULK_PRICE_PVT.G_HEADER_INDEX IS NULL THEN

820: BEGIN
821: oe_debug_pub.add(' In Update_Pricing_Attributes', 1);
822: oe_debug_pub.add(' table count :'|| p_line_tbl.count, 1 );
823:
824: IF OE_BULK_PRICE_PVT.G_HEADER_INDEX IS NULL THEN
825: RETURN;
826: ELSE
827: l_last_index := NVL(OE_BULK_ORDER_PVT.G_HEADER_REC.start_line_index(OE_BULK_PRICE_PVT.G_HEADER_INDEX),1);
828: --NVL added to prevent pl/sql numeric/value error in for loop.bug7685103

Line 827: l_last_index := NVL(OE_BULK_ORDER_PVT.G_HEADER_REC.start_line_index(OE_BULK_PRICE_PVT.G_HEADER_INDEX),1);

823:
824: IF OE_BULK_PRICE_PVT.G_HEADER_INDEX IS NULL THEN
825: RETURN;
826: ELSE
827: l_last_index := NVL(OE_BULK_ORDER_PVT.G_HEADER_REC.start_line_index(OE_BULK_PRICE_PVT.G_HEADER_INDEX),1);
828: --NVL added to prevent pl/sql numeric/value error in for loop.bug7685103
829:
830: FOR j in 1..p_line_tbl.count LOOP
831: FOR i IN l_last_index..

Line 832: OE_BULK_ORDER_PVT.G_HEADER_REC.end_line_index(OE_BULK_PRICE_PVT.G_HEADER_INDEX)

828: --NVL added to prevent pl/sql numeric/value error in for loop.bug7685103
829:
830: FOR j in 1..p_line_tbl.count LOOP
831: FOR i IN l_last_index..
832: OE_BULK_ORDER_PVT.G_HEADER_REC.end_line_index(OE_BULK_PRICE_PVT.G_HEADER_INDEX)
833: LOOP
834: IF p_line_tbl(j).line_id = OE_BULK_ORDER_PVT.G_LINE_REC.line_id(i) THEN
835: -- match
836: IF

Line 837: OE_BULK_ORDER_PVT.G_HEADER_REC.BOOKED_FLAG(OE_BULK_PRICE_PVT.G_HEADER_INDEX) = 'Y' AND

833: LOOP
834: IF p_line_tbl(j).line_id = OE_BULK_ORDER_PVT.G_LINE_REC.line_id(i) THEN
835: -- match
836: IF
837: OE_BULK_ORDER_PVT.G_HEADER_REC.BOOKED_FLAG(OE_BULK_PRICE_PVT.G_HEADER_INDEX) = 'Y' AND
838: (p_line_tbl(j).unit_selling_price IS NULL OR
839: p_line_tbl(j).unit_list_price IS NULL OR
840: p_line_tbl(j).price_list_id IS NULL) THEN
841: OE_BULK_PRICE_PVT.G_BOOKING_FAILED := TRUE;

Line 841: OE_BULK_PRICE_PVT.G_BOOKING_FAILED := TRUE;

837: OE_BULK_ORDER_PVT.G_HEADER_REC.BOOKED_FLAG(OE_BULK_PRICE_PVT.G_HEADER_INDEX) = 'Y' AND
838: (p_line_tbl(j).unit_selling_price IS NULL OR
839: p_line_tbl(j).unit_list_price IS NULL OR
840: p_line_tbl(j).price_list_id IS NULL) THEN
841: OE_BULK_PRICE_PVT.G_BOOKING_FAILED := TRUE;
842: END IF;
843:
844: OE_BULK_ORDER_PVT.G_LINE_REC.unit_selling_price(i) := p_line_tbl(j).unit_selling_price;
845: OE_BULK_ORDER_PVT.G_LINE_REC.unit_list_price(i) := p_line_tbl(j).unit_list_price;

Line 885: END OE_BULK_PRICE_PVT;

881:
882: END mark_header_error;
883:
884:
885: END OE_BULK_PRICE_PVT;