APPS.ASO_QUOTE_HEADERS_PVT dependencies on ASO_FREIGHT_CHARGES

Line 1144: ASO_FREIGHT_CHARGES_PKG.Insert_Row(

1140: l_freight_charge_rec := p_freight_charge_tbl(i);
1141: -- BC4J Fix
1142: --x_FREIGHT_CHARGE_tbl(i).freight_charge_id := NULL;
1143: l_sysdate := sysdate;
1144: ASO_FREIGHT_CHARGES_PKG.Insert_Row(
1145: px_FREIGHT_CHARGE_ID => x_FREIGHT_CHARGE_tbl(i).freight_charge_id,
1146: p_CREATION_DATE => SYSDATE,
1147: p_CREATED_BY => G_USER_ID,
1148: p_LAST_UPDATE_DATE => l_sysdate,

Line 2576: ASO_FREIGHT_CHARGES_PKG.Insert_Row(

2572: l_freight_charge_rec := l_freight_charge_tbl(i);
2573: x_FREIGHT_CHARGE_tbl(i).last_update_date := l_sysdate;
2574: -- BC4J Fix
2575: --x_FREIGHT_CHARGE_tbl(i).freight_charge_id := NULL;
2576: ASO_FREIGHT_CHARGES_PKG.Insert_Row(
2577: px_FREIGHT_CHARGE_ID => x_FREIGHT_CHARGE_tbl(i).freight_charge_id,
2578: p_CREATION_DATE => SYSDATE,
2579: p_CREATED_BY => G_USER_ID,
2580: p_LAST_UPDATE_DATE => l_sysdate,

Line 2610: ASO_FREIGHT_CHARGES_PKG.Update_Row(

2606: ELSIF l_Freight_Charge_Tbl(i).operation_code = 'UPDATE' THEN
2607: l_sysdate := sysdate;
2608: l_freight_charge_rec := l_freight_charge_tbl(i);
2609: x_FREIGHT_CHARGE_tbl(i).last_update_date := l_sysdate;
2610: ASO_FREIGHT_CHARGES_PKG.Update_Row(
2611: p_FREIGHT_CHARGE_ID => l_freight_charge_rec.freight_charge_id,
2612: p_CREATION_DATE => l_freight_charge_rec.creation_date,
2613: p_CREATED_BY => G_USER_ID,
2614: p_LAST_UPDATE_DATE => l_sysdate,

Line 2641: ASO_FREIGHT_CHARGES_PKG.Delete_Row(

2637: p_ATTRIBUTE13 => l_freight_charge_rec.ATTRIBUTE13,
2638: p_ATTRIBUTE14 => l_freight_charge_rec.ATTRIBUTE14,
2639: p_ATTRIBUTE15 => l_freight_charge_rec.ATTRIBUTE15);
2640: ELSIF l_Freight_Charge_Tbl(i).operation_code = 'DELETE' THEN
2641: ASO_FREIGHT_CHARGES_PKG.Delete_Row(
2642: p_FREIGHT_CHARGE_ID => l_freight_charge_tbl(i).freight_charge_id);
2643: END IF;
2644: END LOOP;
2645:

Line 11761: DELETE FROM ASO_FREIGHT_CHARGES

11757:
11758: DELETE FROM ASO_PAYMENTS
11759: WHERE QUOTE_HEADER_ID = p_qte_header_id;
11760:
11761: DELETE FROM ASO_FREIGHT_CHARGES
11762: WHERE quote_shipment_id in
11763: (select shipment_id from ASO_SHIPMENTS
11764: where QUOTE_HEADER_ID = p_qte_header_id);
11765: