DBA Data[Home] [Help]

APPS.OE_RETROBILL_PVT dependencies on OE_LINE_UTIL

Line 1576: l_line_rec:=Oe_Line_Util.Query_Row(I.line_id);

1572: (l_retrobill_list_price = 0 AND
1573: l_retrobill_selling_price < 0) THEN
1574: oe_debug_pub.add('Retro: New price is higher charging more');
1575:
1576: l_line_rec:=Oe_Line_Util.Query_Row(I.line_id);
1577: l_old_line_rec:=l_line_rec;
1578: l_line_rec.unit_selling_price :=-1 * l_retrobill_selling_price; --bug3654144
1579: l_line_rec.unit_list_price :=abs(l_retrobill_list_price);
1580: l_line_rec.unit_selling_price_per_pqty:=-1 *I.UNIT_SELLING_PRICE_PER_PQTY;--bug3654144

Line 1621: Oe_Line_Util.Delete_Row(I.line_id);

1617: IF(I.line_number =1) THEN
1618: G_FIRST_LINE_DELETED := 'Y';
1619: END IF;
1620:
1621: Oe_Line_Util.Delete_Row(I.line_id);
1622:
1623: IF G_LINES_NOT_RETRO_DISPLAYED='N' THEN
1624: FND_MESSAGE.SET_NAME('ONT','ONT_RETROBILL_LINES_NO_CHANGE');
1625: OE_MSG_PUB.ADD;

Line 2852: Oe_Line_Util.Delete_Row(p_line_id=>l_delete_tbl(i).retrobill_line_id);

2848: --We need to delete first, otherwise, we will be unable to delete booked records.
2849: i:=l_delete_tbl.first;
2850: WHILE i IS NOT NULL LOOP
2851: oe_debug_pub.add('Retro:Operation DELETE:deleting line id:'||l_delete_tbl(i).retrobill_line_id);
2852: Oe_Line_Util.Delete_Row(p_line_id=>l_delete_tbl(i).retrobill_line_id);
2853: i:=l_delete_tbl.next(i);
2854: END LOOP;
2855:
2856: -- rearranging the line numbers for the headers corresponding to the lines which were deleted.