130: PROCEDURE Calculate_Freight_Charges(
131: P_Api_Version_Number IN NUMBER,
132: P_Charge_Control_Rec IN Charge_Control_Rec_Type
133: := G_Miss_Charge_Control_Rec,
134: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type
135: := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec,
136: P_Qte_Line_Rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type
137: := ASO_QUOTE_PUB.G_Miss_Qte_Line_Rec,
138: P_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
131: P_Api_Version_Number IN NUMBER,
132: P_Charge_Control_Rec IN Charge_Control_Rec_Type
133: := G_Miss_Charge_Control_Rec,
134: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type
135: := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec,
136: P_Qte_Line_Rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type
137: := ASO_QUOTE_PUB.G_Miss_Qte_Line_Rec,
138: P_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
139: := ASO_QUOTE_PUB.G_MISS_SHIPMENT_TBL,
132: P_Charge_Control_Rec IN Charge_Control_Rec_Type
133: := G_Miss_Charge_Control_Rec,
134: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type
135: := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec,
136: P_Qte_Line_Rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type
137: := ASO_QUOTE_PUB.G_Miss_Qte_Line_Rec,
138: P_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
139: := ASO_QUOTE_PUB.G_MISS_SHIPMENT_TBL,
140: x_Freight_Charge_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
133: := G_Miss_Charge_Control_Rec,
134: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type
135: := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec,
136: P_Qte_Line_Rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type
137: := ASO_QUOTE_PUB.G_Miss_Qte_Line_Rec,
138: P_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
139: := ASO_QUOTE_PUB.G_MISS_SHIPMENT_TBL,
140: x_Freight_Charge_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
141: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
134: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type
135: := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec,
136: P_Qte_Line_Rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type
137: := ASO_QUOTE_PUB.G_Miss_Qte_Line_Rec,
138: P_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
139: := ASO_QUOTE_PUB.G_MISS_SHIPMENT_TBL,
140: x_Freight_Charge_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
141: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
142: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
135: := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec,
136: P_Qte_Line_Rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type
137: := ASO_QUOTE_PUB.G_Miss_Qte_Line_Rec,
138: P_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
139: := ASO_QUOTE_PUB.G_MISS_SHIPMENT_TBL,
140: x_Freight_Charge_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
141: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
142: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
143: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
136: P_Qte_Line_Rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type
137: := ASO_QUOTE_PUB.G_Miss_Qte_Line_Rec,
138: P_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
139: := ASO_QUOTE_PUB.G_MISS_SHIPMENT_TBL,
140: x_Freight_Charge_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
141: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
142: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
143: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
144: IS
142: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
143: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
144: IS
145: l_api_name CONSTANT VARCHAR2(30) := 'Calculate_Freight_Charges';
146: l_freight_charge_rec ASO_QUOTE_PUB.Freight_Charge_Rec_Type;
147:
148: BEGIN
149: x_return_status := FND_API.G_RET_STS_SUCCESS;
150: