The following lines contain the word 'select', 'insert', 'update' or 'delete':
x_pvt_plsl_rec.LAST_UPDATED_BY := P_plsl_Rec.LAST_UPDATED_BY;
x_pvt_plsl_rec.LAST_UPDATE_DATE := P_plsl_Rec.LAST_UPDATE_DATE;
x_pvt_plsl_rec.LAST_UPDATE_LOGIN := P_plsl_Rec.LAST_UPDATE_LOGIN;
PROCEDURE Update_pack_serial_lots(
P_Api_Version_Number IN NUMBER,
P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
P_Commit IN VARCHAR2 := FND_API.G_FALSE,
P_Identity_Salesforce_Id IN NUMBER := NULL,
P_plsl_Rec IN plsl_Rec_Type,
X_Return_Status OUT NOCOPY VARCHAR2,
X_Msg_Count OUT NOCOPY NUMBER,
X_Msg_Data OUT NOCOPY VARCHAR2
)
IS
l_api_name CONSTANT VARCHAR2(30) := 'Update_pack_serial_lots';
SAVEPOINT UPDATE_Pack_Serial_Lots_PUB;
CSP_pack_serial_lots_PVT.Update_pack_serial_lots(
P_Api_Version_Number => 2.0,
P_Init_Msg_List => FND_API.G_FALSE,
P_Commit => p_commit,
P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,
P_Identity_Salesforce_Id => p_identity_salesforce_id,
P_plsl_Rec => l_pvt_plsl_Rec ,
X_Return_Status => x_return_status,
X_Msg_Count => x_msg_count,
X_Msg_Data => x_msg_data);
End Update_pack_serial_lots;
PROCEDURE Delete_pack_serial_lots(
P_Api_Version_Number IN NUMBER,
P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
P_Commit IN VARCHAR2 := FND_API.G_FALSE,
P_identity_salesforce_id IN NUMBER := NULL,
P_plsl_Rec IN plsl_Rec_Type,
X_Return_Status OUT NOCOPY VARCHAR2,
X_Msg_Count OUT NOCOPY NUMBER,
X_Msg_Data OUT NOCOPY VARCHAR2
)
IS
l_api_name CONSTANT VARCHAR2(30) := 'Delete_pack_serial_lots';
SAVEPOINT DELETE_Pack_Serial_Lots_PUB;
CSP_pack_serial_lots_PVT.Delete_pack_serial_lots(
P_Api_Version_Number => 2.0,
P_Init_Msg_List => FND_API.G_FALSE,
P_Commit => p_commit,
P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,
P_Identity_Salesforce_Id => p_identity_salesforce_id,
P_plsl_Rec => l_pvt_plsl_Rec,
X_Return_Status => x_return_status,
X_Msg_Count => x_msg_count,
X_Msg_Data => x_msg_data);
End Delete_pack_serial_lots;