DBA Data[Home] [Help]

APPS.ASO_SHIPMENT_PVT dependencies on ASO_FREIGHT_CHARGES

Line 28: SELECT FREIGHT_CHARGE_ID FROM aso_freight_charges

24: l_api_name CONSTANT VARCHAR2(30) := 'Delete_quote';
25: l_api_version_number CONSTANT NUMBER := 1.0;
26:
27: CURSOR c_freight_charges IS
28: SELECT FREIGHT_CHARGE_ID FROM aso_freight_charges
29: WHERE QUOTE_SHIPMENT_ID = p_shipment_rec.shipment_id;
30:
31: l_return_status VARCHAR2(240);
32: BEGIN

Line 79: ASO_FREIGHT_CHARGES_PKG.Delete_Row(

75: END IF;
76: END IF;
77:
78: FOR freight_rec IN c_freight_charges LOOP
79: ASO_FREIGHT_CHARGES_PKG.Delete_Row(
80: p_FREIGHT_CHARGE_ID => freight_rec.FREIGHT_CHARGE_ID);
81: END LOOP;
82: -- Invoke table handler(ASO_SHIPMENTS_PKG.Delete_Row)
83: ASO_SHIPMENTS_PKG.Delete_Row(