DBA Data[Home] [Help]

APPS.ASO_PRICE_ADJUSTMENTS_PKG dependencies on ASO_PRICE_ADJ_RELATIONSHIPS

Line 525: DELETE FROM ASO_PRICE_ADJ_RELATIONSHIPS

521: null;
522: End If;
523:
524: -- delete from aso_price adjustments the id and the related id
525: DELETE FROM ASO_PRICE_ADJ_RELATIONSHIPS
526: WHERE PRICE_ADJUSTMENT_ID = p_PRICE_ADJ_ID
527: OR RLTD_PRICE_ADJ_ID = p_PRICE_ADJ_ID;
528: If (SQL%NOTFOUND) then
529: null;

Line 564: DELETE FROM ASO_PRICE_ADJ_RELATIONSHIPS

560: BEGIN
561:
562: If p_TYPE_CODE = 'QUOTE_LINE' THEN
563:
564: DELETE FROM ASO_PRICE_ADJ_RELATIONSHIPS
565: WHERE QUOTE_LINE_ID = p_line_id;
566: If (SQL%NOTFOUND) then
567: null;
568: End If;

Line 576: DELETE FROM ASO_PRICE_ADJ_RELATIONSHIPS

572: END LOOP;
573:
574: elsif p_TYPE_CODE = 'SHIPMENT_LINE' THEN
575:
576: DELETE FROM ASO_PRICE_ADJ_RELATIONSHIPS
577: WHERE QUOTE_SHIPMENT_ID = p_line_id;
578: If (SQL%NOTFOUND) then
579: null;
580: End If;