778: FOR UPDATE NOWAIT;
779:
780:
781: l_temp_rec FTE_FREIGHT_COSTS_TEMP%ROWTYPE;
782: l_empty_freight_rec WSH_FREIGHT_COSTS_PVT.Freight_Cost_Rec_Type;
783: l_freight_rec WSH_FREIGHT_COSTS_PVT.Freight_Cost_Rec_Type;
784: l_freight_cost_id NUMBER;
785: l_return_status VARCHAR2(1);
786: l_rowid VARCHAR2(30);
779:
780:
781: l_temp_rec FTE_FREIGHT_COSTS_TEMP%ROWTYPE;
782: l_empty_freight_rec WSH_FREIGHT_COSTS_PVT.Freight_Cost_Rec_Type;
783: l_freight_rec WSH_FREIGHT_COSTS_PVT.Freight_Cost_Rec_Type;
784: l_freight_cost_id NUMBER;
785: l_return_status VARCHAR2(1);
786: l_rowid VARCHAR2(30);
787: l_init_msg_list VARCHAR2(30) :=FND_API.G_FALSE;
909: END IF;
910:
911: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_DBG,'>>5');
912:
913: WSH_FREIGHT_COSTS_PVT.Update_Freight_Cost(
914: p_rowid => l_rowid,
915: p_freight_cost_info => l_freight_rec,
916: x_return_status => l_return_status);
917:
926:
927: ELSE
928: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_DBG,'>>6');
929:
930: WSH_FREIGHT_COSTS_PVT.Create_Freight_Cost(
931: p_freight_cost_info => l_freight_rec,
932: x_rowid => l_rowid,
933: x_freight_cost_id => l_freight_cost_id,
934: x_return_status => l_return_status);
1080: FOR UPDATE NOWAIT;
1081:
1082:
1083: l_temp_rec FTE_FREIGHT_COSTS_TEMP%ROWTYPE;
1084: l_empty_freight_rec WSH_FREIGHT_COSTS_PVT.Freight_Cost_Rec_Type;
1085: l_freight_rec WSH_FREIGHT_COSTS_PVT.Freight_Cost_Rec_Type;
1086: l_freight_cost_id NUMBER;
1087: l_return_status VARCHAR2(1);
1088: l_rowid VARCHAR2(30);
1081:
1082:
1083: l_temp_rec FTE_FREIGHT_COSTS_TEMP%ROWTYPE;
1084: l_empty_freight_rec WSH_FREIGHT_COSTS_PVT.Freight_Cost_Rec_Type;
1085: l_freight_rec WSH_FREIGHT_COSTS_PVT.Freight_Cost_Rec_Type;
1086: l_freight_cost_id NUMBER;
1087: l_return_status VARCHAR2(1);
1088: l_rowid VARCHAR2(30);
1089: l_init_msg_list VARCHAR2(30) :=FND_API.G_FALSE;
1277: END IF;
1278:
1279: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_DBG,'>>5');
1280:
1281: WSH_FREIGHT_COSTS_PVT.Update_Freight_Cost(
1282: p_rowid => l_rowid,
1283: p_freight_cost_info => l_freight_rec,
1284: x_return_status => l_return_status);
1285:
1294:
1295: ELSE
1296: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_DBG,'>>6');
1297:
1298: WSH_FREIGHT_COSTS_PVT.Create_Freight_Cost(
1299: p_freight_cost_info => l_freight_rec,
1300: x_rowid => l_rowid,
1301: x_freight_cost_id => l_freight_cost_id,
1302: x_return_status => l_return_status);